1. From main menu, select Temporal Data > Load Data File…
2. Select the Open File button. A window will pop up and prompt you to select a file for importing. Navigate to the folder where the file resides.Select the file name and click on “Open” button. The window on the left side of the form will become populated with field names from the selected file.
Note: If the file you select to import is a database containing more than 1 table or query, an additional dialog will appear prompting you select the desired data source.
3. Select an item from the Destination Table drop down list to choose the destination for the data file your are about to append. The field names underneath will change depending on what table is selected. Note: Some destination tables have a minimum or required set of fields that MUST be used. In these cases the colour coding scheme will be used with red to indicate a required field.
4. Click and drag fields from the Source File Fields list to the matching Destination Field, one at a time. This is what is meant by mapping the fields.
Optional: Place a check mark beside any fields that should be used to check for duplicate data. If you suspect that data in your import file already exists in the database, you should use this option.
5. If this combination of field mappings will be frequently used (for example, to load in data from a lab monthly), press the Save button and follow the instructions in the window. The mapping template is now saved.
6. Press the Append button. Any unusual circumstances will be reported to the user who can then decide how to proceed based on the information given.