APPENDIX B

Each time a GC run is finished and the report printed on the screen, one of the following messages will appear on the white command line at the bottom of the Method and Run Control window of the HP ChemStation. For GC3: "CSV File C:\HPCHEM\GC3\DATA\JANUS\ GC3030.CSV," and for NGA: "CSV File C:\HPCHEM\NGA\DATA\ JANUS\NGA030.CSV." CSV files are created by a postrun macro embedded in the GC methods. The CSV files are used to transfer the data to the Janus database. If a CSV message does not show up after a run is finished, the macro needs to be reactivated. In the command line, type "MACRO GC3_CSV.MAC, GO" and press enter. Similarly, for NGA macro reactivation, type "MACRO NGA_CSV.MAC, GO" and press enter.

Every time that the chromatogram of a sample is reintegrated, a new CSV file needs to be created to incorporate the changes. To create a new CSV for the reintegrated sample, print the report on the screen and in the command line type either GC3_CSV or NGA_CSV, depending on which instrument you used to performed the run.

To transfer the gas data to the Janus database, proceed as follows:

1. Make sure you are logged into the Janus database. If not, log in as chem104, password = chem104, and select Chemistry under the Applications menu and then Gas-Input/Edit Gas File Data. An Input/Gas File Data window will open.
2. Select File Input under Mode. Query the desired CSV file under Enter Input File. A screen appears that allows you to select the directory where the CSV files generated from GC3 or NGA are stored. The directory will either be: "C:\HPCHEM\GC3\DATA\JANUS" for the GC3 or "C:\HPCHEM\NGA\DATA\JANUS" for the NGA. The data files will look like "GC3030.CSV" or "NGA030.CSV." Always scroll down to the latest, or largest numbered, data file (e.g., NGA033.CSV should be taken instead of NGA032.CSV). The GC program automatically assigns its latest run with the next sequential number;
3. Press Read File. The sample ID and data will be loaded, and a Status window will appear. If there is a verification problem, the error will appear in red instead of black. If everything is loaded properly, press Save Input to load the data into the database.