Commit Your Import

Commit Your Import

In the last step of the Import Routine, you will be able to view a summary of your import specifications prior to committing your data or document to the database.

At the top of the Import Summary section, DataSight will display a coloured text box summarising the outcome of the checks completed prior to committing the data to your database:

  • (Green) Import OK - no issues were identified and the import will proceed without errors or omissions in the data to be imported.
  • (Orange) Import OK with warnings (## errors, ## skipped variables) - issues were identified and some data may not be imported.
  • (Red) Import Failed. No records to import - issues were identified and no data will be imported.

Import Summary Checks

  1. Check the Import datetime stamp, user and computer are showing correctly.
  2. Check the original path of the raw data file is correctly displayed.
  3. Ensure the data row selection is that which you intended.
  4. Most importantly, ensure you have selected the correct levels and the field mappings are correct. Levels added and variables skipped will be shown at this point.
  5. Check to see if you have any exceeding data which will be imported into the database.
  6. Click Back at any stage to revise any import specifications that are not correct or Cancel if you wish to cancel and close the Import Routine without importing.
  7. Type in any commentary about the import as required. This comment will be saved with in the processing history.
  8. When satisfied with the import summary, click Import. A Completing the Import window will appear showing the import progress.

 

Data Validation

  • During the final stage of a data import when you commit your data to the database, DataSight runs a validation check to ensure that the date and time is correctly formatted before import.
  • If the date and time is incorrectly formatted, or missing, an Error List will appear detailing the lines and fields affected in the import.
  • You are able to either Cancel or select OK to continue the import with the nominated lines being excluded.
  • You can right-click on the lines of data to Select All and create a Copy of the Error List.

 

Stop Import

  • Click Stop to quit the Import at any point of progress.
  • The number of rows imported at this stage will be indicated and any remaining rows will not be imported.
  • Details of the number of imported rows is added to the Level 3 Processing History in either case.

 

After Successful Import

  • Once your import is successfully completed, click Finish to close the Import Routine.

 

    • Related Articles

    • Document Import

      In the Document Import Routine, you will identify the level under which the file will be saved. (Optional) If you have already saved an Import Template for this type of file and want to use it, click Load Template The Load Import Template window will ...

    • Data Import

      Data Import Checklist Before importing data, you should be able to answer the following questions about the current format of your file. What type of file are you importing? Is the data normalised or pivoted? Do the data variables you wish to import ...

    • Import Routine

      DataSight's Import Routine is a simple and flexible import wizard that steps you through the import process. It is simple to use and designed for non-IT personnel to set up and configure, thus allowing any DataSight user to become self-sufficient. ...

    • Import Data

      Open a desired Station Table. Click Import Data. Select Manual Data Entry or Import Data File. Manual Data Entry Enter date, time and your variable value. Click Save. Import Data File Browse to your file and select Open, then click Upload. Configure ...

    • Video: Import Normalised Data

      This video provides a basic overview of normalised data import.