A Perl script to convert Zetetic Palm/Visor encrypted Strip database to CSV format so that the information can be imported to SplashID for iPhone or other devices. It is very easy to create a SplashID's non-encrypted vid file (which gives more control) but Strip's data is so simple, I went
... [More]
with the CSV format.
Strip (Secure Tool for Recalling Important Passwords) is a password manager for Palm computing platform. I use it in my Visor for many years. As a matter of fact Strip is the reason I was still using the Visor.
Now that I've a iPhone and my Visor is dying slowly, can't hold charge that long, I noticed SplashID and purchased it. This script converts Strip database to CSV format, so that the information can be imported to SplashID desktop software. After importing you can sync with iPhone.
I hope you will find this information useful.
To download/view the script, click on Source->Browse and go to svn's trunk.
RequirementsLinux Palm libraries and Perl modules. Palm::Zetetic::Strip Perl module. Usage $ perl strip2csv.pl \
\
\
SplashID CSV formatAccording to SplashID 5.1.0.0 documentation, to import a CSV file, the data must be in the following format:
Type,Field 1,Field 2,Field 3,Field 4,Field 5,Field 6,Field 7,Field 8,Field 9,Date Modified:"Month DD,YYYY",Notes,CategoryVersion of StripThe version of Strip I use in my Visor is Strip v1.0 (AES).
Fields mappingThe way we will map Strip's fields to SplashID's fields is as follows:
Strip SplashID Category Field1 Login Field2 Password Field3 System Field4 Service Ignore. The Perl module does not have any fucntion to retrieve it Notes Notes
We will use user supplied Category and Type for the CSV file.
ExampleIn your Palm/Visor, if an entry looks like:
Category: Example
System: Example system
Service: Example service
Login: jdoe@example.com
Password: secret
blah
Notes: This a test line1
line2After converting, the CSV entry will look like:
PalmVisor,"Example","jdoe@example.com","secret1 blah","Example system",,,,,,"Sep 05, 2009","this is a test line1^Kline2^K",PalmVisorNote: the Service field is missing, I did not find any function in the Perl module to retrieve it. ^K is 0x0b, it separates a line in the Notes.
How to useStart SplashID Desktop application. Select Edit Categories... from the All Categories selection from at the top of the window and Create a category called PalmVisor. Keep a note of it.
Now select Edit Types... from All Types selection list. Click on New... and create a Type as follows:
Name: PalmVisor
Field1: Description
Field2: Login
Field3: Password (Click on Mask)
Field4: SystemKeep a note of the Type.
Set the password of your Strip database to the environent variable STRIP_PASSWD. Example: STRIP_PASSWD="secret"
export STRIP_PASSWDFind out where the Palm/Visor databases are located. I use J-Pilot to sync/backup my Visor, so my directory is: $HOME/.jpilot/Backup/LatestArchiveRun the script: $ perl strip2csv.pl
usage: strip2csv.pl
$ perl strip2csv.pl "PalmVisor" "PalmVisor" \
"$HOME/.jpilot/Backup/LatestArchive" visor.csvTo import the CSV file to SplashID, go to File->Import->CSV and select the visor.csv file. A Screenshot of SplashID:
If everything looks ok, sync with your iPhone. [Less]
Copyright
©
2013
Black Duck Software, Inc.
and its contributors, Some Rights Reserved. Unless otherwise marked, this work is licensed under a
Creative Commons Attribution 3.0 Unported License
. Ohloh
®
and the Ohloh logo are trademarks of
Black Duck Software, Inc.
in the United States and/or other jurisdictions. All other trademarks are the property of their respective holders.