----------------------------------------------------- ----------------------------------------------------- Usage: conv -l|p [-?] filename DESCRIPTION: This program converts pipe delimited records in a flatfile database into formage logfile format or the other way around. OPTIONS: The following command line options are acceptable: -l convert records in a FORMAGE LOGFILE to a pipe delimited format for a flat file database The field order may vary when converting from the formage logfile format because formage is not bound to a fixed write order when updating its logfile. So, there is no way to anticpate the order of the fields when converting the formage logfile into pipe delimited records. So, the best option is to open the new pipe delimited file in Microsoft Excel and cut and paste the columns to be in the proper order (see -p option) before using the pipe delimited file to convert back to a formage logfile format. -p convert records in a PIP DELIMITED FLATFILE DATABASE to a formage logfile format. The field order is fixed and must be: id|datatitle|source|callnum|workstation|description -? help notes on program usage APPENDING RECORDS: To append converted records to the target file use the UNIX append operator >> in your command line statement. $ conv -p cdrom.txt >> cdrom.db OVERWRITING RECORDS: To rewrite (erase all current records and replace with the newly converted records) the target file use the UNIX write operator > in your command line statement. $ conv -l cdrom.db > cdrom.txt EXIT CODES: 0 - no errors 1 - target file not found 2 - cannot read filename 3 - option does not match current file format 5 - no records in target file to convert 22 - insufficient or invalid argument ----------------------------------------------------- -----------------------------------------------------