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 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.

Requirements

• Linux
• Palm libraries and Perl modules.
• Palm::Zetetic::Strip Perl module.

Usage

 $ perl strip2csv.pl <SplashID Type> \
                     <SplasdID Category> \
                     <directory of Strip databases> \
                     <csv file>

SplashID CSV format

According 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,Category

Version of Strip

The version of Strip I use in my Visor is Strip v1.0 (AES).

Fields mapping

The way we will map Strip's fields to SplashID's fields is as follows:

We will use user supplied Category and Type for the CSV file.

Example

In 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
          line2

After 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",PalmVisor

Note: 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 use

• Start 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: System

Keep a note of the Type.

• Set the password of your Strip database to the environent variable STRIP_PASSWD. Example:

 STRIP_PASSWD="secret"
 export STRIP_PASSWD

• Find out where the Palm/Visor databases are located. I use J-Pilot to sync/backup my Visor, so my directory is:

$HOME/.jpilot/Backup/LatestArchive

• Run the script:

  $ perl strip2csv.pl 
  usage: strip2csv.pl <SplashID Type> <SplasdID Category> 
                     <directory of Strip databases> 
                      <csv file>

  $ perl strip2csv.pl "PalmVisor" "PalmVisor" \
 "$HOME/.jpilot/Backup/LatestArchive" visor.csv

• To 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.