AirVision allows you to create an import template for each site.Each template contains the actual hard links to the parameter/average interval combination (e.g, dbs ID). To configure an import template:

• From the Configuration Editors select File Import Configuration and either select a previously configured template from the sidebar or click the New Template button from the upper section of the screen (Figure 6-5).

Figure 6-5 File Import Configuration

• In the File Schema section:
• Enter a Template Name and select the Number of Header Rows to skip before parsing data and the Number of Footer Rows to ignore at the end of file.
• Select a Maximum Number of Columns to allow
• Select a Field Delimiter to determine how imported data is delimited (comma or pipe)
• Select a Sample Type (Standard or a particular custom type)
• Select whether parameters will be matched by Column Number or Header Name.
• Click the check box if you want to Overwrite Existing Data during the file import. Note that this setting only applies to manual import, it does not apply to scheduled imports associated with instrument polls (like the logger polling, it does not overwrite existing records).
  
• Select a Parameter Data Type--Average (Continuous) with an Average Interval, Composite Sample with a Composite Type, or Particulate Sample with the Duration and Frequency Codes. An appropriate drop-down list will be displayed according to the data type selected.
• In the File Column Mapping section, column headings include Data Type, Parameter Template, and Parse Format. Parameter Match Name and Column vary according to which type of Parameter Matching was selected in the Parameter Information section.
• To add a column mapping row, click the Add Column Mapping button at the bottom of the screen. A blank row will be added to the table.

Click the Save icon in the upper left corner of AirVision to save changes to the database.


The File Import Tool has been significantly improved in Version 2.3. Click here for details on the Enhanced File Import Tool.


Special Case San Diego Sample ID

Cases Supported:

ddmSh24 = 24 hour duration sample at 0h:00 at specified month/day

ddmSh24L = append to exception record file: <site>_LAB.txt

ddmSh24S = append to exception record file:<site>_SPIKE.txt

ddmSh24D =append to exception record file: <site>_FDUPL.txt

BddmmNNN = ignore?


if the last two digits aren’t “24”, then…

ddmShhN = N hour duration sample at hh:00 at specified month/day