JFile Converter - version 1.6 1.6 Allows fields to be up to 500 characters long, but each record must remain below 4000 characters in total 1.5 Replaces carriage returns in a JFile .pdb with spaces for .csv usage Adds ability to use command line arguments for ease of use in batch files 1.4 Fixes a bug that caused some .pdb's not to convert properly 1.1 Update notice - should now handle true .csv files with quoted string output, also pdb.->.csv file output will be in the format of quoted string output also. *************************************************************************** NOTE: Be sure you are using JFile 1.0 beta-4 or later when loading a file that has been created with this import application. *************************************************************************** This is just a very rough first cut at a JFile <-> comma seperated values import/export program. It's a Windows95 console application. A sample comma seperated values file is included for example purposes (and is also available at the Pilot Memowarehouse!) for Airline Reservation Phone numbers. The format is: - top line is the field names, each seperated by a comma - each following line is a record, each field seperated by a comma Be sure to follow this format, as there is only minimal error checking of the file being done at this point. Example Usage: - Run jconv.exe - Select option 1 to go from CSV (comma seperated values) to JFile .pdb - Select input file name (airlines.txt) - Select output file name (airlines.pdb) - Select Pilot database name - no spaces (Airlines_Info) You should then have an airlines.pdb file which you can upload to your Pilot just as you would any .prc program file, (in most instances this will be via the install app program that came with Pilot Desktop from USR). Export of JFile .pdb's is also possible. Your JFile .pdb's should be backed up in your Pilot//backup directory. If they are not, it is likely you have the older HotSync 1.0 which has a bug in that it only backs up a few non-ROM based app's databases - to correct this problem you need to upgrade to HotSync 1.1 or the Generic Conduit Manager from Pat Beirne. NOTE: Pat is currently working on a better conduit system than this simple export/importer for JFile, but since I have had many requests for simple export/import, I decided to release this application for user's looking for a way to get data into and out of JBase. Watch for updates of this program as well as JFile in the future.