The
This page will be expanded as I produce more PalmPilot utility programs. Currently, there is one package available: JFILE Pro Utility Pack.
All programs can read both old JFile and new JFile Pro format. Output .PDB format is always JFile Pro. If you need old JFile format, run PDB2PDB on the output .PDB file to convert it.
JFile Pro database utilities:
CSV2PDB, PDB2CSV & PDB2PDB: Convert back and forth between native JFile .PDB format and standard .CSV format, or between JFile and JFile Pro.
PDB2HTM: Export a JFile database to an html table.
MergePDB: Merge two JFile databases into one. Useful if you are downloading databases off the net, and they contain fields that you are supposed to fill out (like a "Have it?" flag). By merging the new database into your existing, you preserve all existing modifications you might have made, since only new fields and records are added, and only fields that are empty in your current database are updated with values from the new one.
SplitPDB: Split a JFile database into several seperate databases. Splits the file according to a field of type PopupList (if there are multiple such fields, you are prompted as to which one you want to base the split on) and creates several databases, where all fields (except the one on which the split is based) is copied as-is to the output databases.
MergePDB & SplitPDB are primarily made to support the JFile databases on the trekkies.dk home page (see trekkies.dk PalmPilot page).
Versions available for OS/2 and Win32.
| Version | Date | Changes |
| 1.30 | 30 Nov 2000 | CSV2PDB, PDB2CSV: Handles long popup list definitions (>255 chars) properly. |
| 1.27 | 09 Oct 2000 |
CSV2PDB: Truncates popup lists to 100 entries and now handles more than 20 entries. |
| 1.26 | 04 Oct 2000 |
CSV2PDB: Truncates database to 50 fields. PDB2CSV and CSV2PDB: Saves/Restores PopUp lists in .DEF file. |
| 1.23 | 26 Mar 2000 | Added PDB2HTM, DumpPDB, SplitPDB and MergePDB programs to the package. |
| 1.22 |
CSV2PDB: Truncating huge (>4000 chars) field values. OS/2: Better character set translation. |
|
| 1.21 |
Better handling of large (>255 chars) field values. Better handling of field values with <CR><LF> sequences. |
|
| 1.20 |
Now supports wild cards in source file name specifications. Better handling when encountering non-JFile .PDB files. OS/2: Character set conversion (CP850<->ISO-8859-1). |
All versions are command-line utilities. Run them without any parameters to get a brief calling syntax.
I have also started working on programs to edit directly in JFile .PDB files, and have a Win32 GUI version and an OS/2 text mode
version available as EditPDB for Win32 and EditPDB for OS/2.
Please note that these two programs are beta releases and are only supplied "as is" without any support or warranty of any kind.