TN112 - Convert 4TNox records to SplashID

112.1    Summary

        Instructions to convert 4TNox records to SplashID. 
        
        4TNox was a palm application from Fortsoft to store passwords and other
        confidential information in an encrypted database. Fortsoft no longer
        seems to be enhancing the 4Tnox application, so a method to move the
        data to leading alternative was required.

        SplashID from SplashData <http://www.splashdata.com> seems to be one of
        the better palm applications currently on the market to store and
        organize passwords and other sensitive information in an encrypted
        database.

112.2    Conversion utility

        4tnox2splash.pl is a conversion utility written in perl that will
        convert the "memos" exported by 4TNox into CSV files that can be
        imported into SplashID.
        
        Download the 4tnox2splash utility from:

            http://www.marchansen.com/bin/txt.cgi/tn112/4tnox2splash.pl

        Requires perl. See TN106.6 to install perl on your PC.

112.3    Conversion instructions

        1. From 4TNox export each category sequentially.

           a. Choose each category separately.

           b. Choose "export to memopad" from the "options" menu.

           c. 4TNox will place each exported category into a separate "unfiled"
              memo file titled "4TNox Export."

        2. From the memo pad application

           a. Rename each memo to the category name.

           b. Check to see that entire category was exported to each memo.
              Categories past a certain length are truncated. If category is
              truncated, divide into smaller categories and export again.

        3. HotSync Palm with Palm desktop

        4. From the Palm Desktop

           a. Choose each memo created in the steps above sequentially.

           b. Choose "Export" from the "file" menu.

           c. Set export type to "text" and choose any unique file name ending
              in .txt. Put all exported files in a directory that contains no
              other .txt files.

           d. On the "Specify Export Fields" dialog box, uncheck everything
              except "memo" and pick "OK"

        5. From a command console run the perl program 4tnox2splash.pl

           Usage: 4tnox2splash.pl [directory]
                  directory is optional argument, directory to start
                  in. Current directory is default.

           a. Either change to the directory with the exported 4tnox files to
              run the command or supply the full path to the directory as an
              argument to the program.

           b. Expects all *.txt in directory to be input files.

           c. Outputs a single file "splash.csv" in same directory as input
              files.


        6. Choose "Import CSV" from the file menu in the desktop SplashID 
           application. Import splash.csv file.

112.4    Conversion notes

        Double quotes would interfere with the CSV file format
        so all double quotes in input files are translated to 
        single quotes.

        4TNox Field    SplashID Field
        -----------    --------------
        Description    Custom1
        Type           Not copied
        User Name      Custom2
        Password       Custom3
        Date           Not copied
        Notes          Notes

        All other 4TNox fields/values are added to SplashID 
        notes field, showing both field and value names.