Final Prep of the XML output files

Aren't you excited?

This page covers the final steps before the data are passed into the "perl converter"--the program that actually loads the data into the HDMS database (right before the Biotics 4 Tracker User Interface is installed).

---

Prep the data for the Perl Converter

The data coming from the BCD comes out in a character encoding known as "IBM437" or "CP437"--it's really old. In order for the Perl Converter to use the data coming from the BCD, the encoding has to be converted from "IBM437" to "ISO-8859-1" (done via a simple Java program--which is why you had to install the Java Runtime Engine noted above--the International Version (which contains many more character encodings than the United States only version)).

1. Log out of the BCD--you don't need it anymore (we hope).
2. Go to Windows Explorer (or whatever you prefer to do this next step)
3. Execute the arev\hdms\java\charconv.bat file (double-click on it in Windows Explorer).

List of output files that should be in the hdms\output\conv subdirectory after all the data dumps are completed:

* = required always (assumes the BCD has EOR records)
* = required for people who have Biotics 3.x
All other files will be created if the export command line is uncommented AND there are data in the target BCD files.


cont.xml egr.xml *egt.xml enr.xml *ent.xml *EO.xml (from BIOTICS) *EO_SOURCE.xml (from BIOTICS) *eor.xml es1.xml es2.xml es3.xml esr.xml *est.xml ica.xml mabr.xml pca.xml *sa.xml sbr.xml *SHAPE.xml (from BIOTICS) *SOURCE_FEATURE.xml (from BIOTICS) *syn.xml vca.xml

4. If for any reason you have to run a single file again, make the appropriate modifications to the EXPORT.BCD file (commenting out the files you do not want to export), then re-execute the export (see ExportDataForConversion). When you are ready to run the charconv.bat file, you must first discretely remove the applicable XML files from the arev\hdms\output\conv subdirectory (charconv.bat only converts files that exist that do not have a resulting file already in the arev\hdms\output\conv subdirectory).

---

Run the Perl Conversion
Note that at this time, the data output from the prep step immediately preceding this step does not put the output files in the desired location for the Perl Conversion. In this document, the assumption is that the person executing the data dump from the BCD is a different person from the one who runs the Perl Conversion.

1. Zip up (but do not MOVE) the contents of the arev\hdms\output\conv subdirectory and back up the zip file. Leave the XML files there, and deliver either the XML files or the zip file to the person running the Perl Conversion.

Back to RunningTheDumpForAnNHP