If you want imported data to go in specific columns, save the File Schema entries (top half of the screen) and click the Add Column Mapping button at the bottom of the screen. Enter the following information:

• Column Number for each column in the file where you want data to be imported. Not every column needs to be configured (e.g., if you only want columns 1, 2, and 5 out of a 10-column file, only those 3 records need to be configured).
• Data Type Select one of the following from a drop-down list (some are only available in single-point-per-row format)
  

Date
Time
Date and Time
Parameter Key (to map the row to a parameter)
Site Key (to map to a particular site)
Floating Point Value
Flags
AQS Method Code
AQS Duration Code
AQS Frequency Code
AQS Blank Type
Null Code
Qualifier Code
Uncertainty Value
Minimum Detectable Limit
Tare Weight
Final Weight
Sample Volume
Sample Barometric Pressure
Sample Ambient Temp
Sample Identifier
Cannister ID
Sample End Time
Sample Retrieved Date
Sample Analysis Time

• Parameter Template can be selected from a drop-down list of all parameter templates only if you selected Floating Point Value for the Data Type
• Parse Format can be selected for date and/time data only (not floating point); for example, MM/dd/yyyy HH:mm. Select from a drop-down list.

Click the Add Column Mapping button to add another record, .

To delete a column mapping record, select the row and press the Delete key on the keyboard.

To delete an entire File Import Template, select it from the Template Name section of the screen and click the Delete button in AirVision.

Save the template again. Use the Manual File Import tool to test your file import template.