Export routine and procedures for migrating Buspkg data to another system.

Two Perl 4 programs, glam2csv.pl and ytd2csv.pl will provide the necessary conversion of the Account Master file and Year to Date Transaction file to .csv format for import into Excel.

You can download the conversion routines here: buspkg2csv.zip (141k).

The procedure is as follows:

1. Unload the GLAMAS and YTDGLT files using the ISLOAD utility. To do this:

 a. Go to a DOS prompt.

 b. Run menu once and exit to set the environment variable for DBLDIR.

 c. CD to the GLFILE directory (usually cd \buspkg\glfile).

 d. dbr dbldir:isload

 e. Option: UNLOAD

 f. File to unload: GLAMAS

 g. Ascii file to unload to: GLAMAS

 h. Reporting interval: <Enter>

 i. Repeat d through h for YTDGLT

You now have the files GLAMAS.DDF and YTDGLT.DDF in your GLFILE folder.

2. Unzip the three files (perl4.exe, glam2csv.pl, ytd2csv.pl) to the GLFILE folder.

3. Run the conversion routines by giving these commands at the DOS prompt:

  a. perl4 glam2csv.pl [-c]

 b. perl4 ytd2csv.pl [-c]

The -c option means "no cents". Type -c on the command line if the base currency is formatted with no digits to the right of the decimal place.

You now have the files GLAMAS.CSV and YTDGLT.CSV in the GLFILE folder.

These files are now ready to be opened in Excel.


Bugs and notes:

The conversion will not correctly handle quote marks (") in the description fields of accounts or transactions. If you are having trouble with corrupted data caused by quote marks, you should open the GLAMAS.DDF and/or YTDGLT.DDF files in Notepad and look for any quotes. Replace quote marks with spaces, being very careful not to change the number of characters in the line. I.e. when you delete a quote, be sure to replace it with exactly one blank space. Then go and run the glam2csv.pl and/or ytd2csv.pl programs again.

There is no provision for moving data back to the BUSPKG after conversion to .csv files.