Import Data with the Import Window

To import data, use these steps:

1. Open the Import window.
2. On the All Imports tab, select the import template you want.
3. Select the Import Batches tab.
4. Right-click in the Import Batches tab and select Insert. The system displays a dialog box to select the file to be imported.
5. Select Browse. The system displays a typical file explorer window.
6. In the file explorer window, locate the file to be imported and then double-click the file name to display the file name in the dialog box.
7.  Select Upload. The system imports the data into the temporary, intermediate table. When the import process is finished, a new record appears in the Import Batches tab.
8. Right-click the new record and select View Batch. The system displays a new window that shows the records that were loaded from the source table. If any format errors were detected, they are shown in the Import Err String column. You must correct the errors before continuing. If no errors were detected, close the Batch View window.
9. In the Import Batches tab, right-click the new record and then click Process Batch. This command runs the data validation and transfer procedure for the import.
10. After the Process Batch command has finished, right-click the new record and select View Batch. The system displays a new window that shows either no records (if all records are error-free) or the processed records that have errors.
    1. If no records are shown, close the window. The import process is now complete.
    2. If records with errors are shown, you may recover in either of the following ways:
       
       1. Correct the errors in the View Batch window, close the window, and then return to step 9 to continue.
       2. Use the contents of the window to identify the records in your original file and correct the errors in the original file. Once the records in the original file are corrected, return to the AgileAssets Pavement Management system and, in the Import Batches tab, right-click the record showing the last import attempt and select Reimport Batch. The system again asks you for the data source and then re-imports the data, displaying a new record in the Import Batches tab. Return to step 6 to continue.