Check all import templates have date time delimiters

Check all import templates have date time delimiters

Reported: October 4, 2018

Version(s) affected: DataSight 3.4 onwards

Issue: Date and Time Delimiters in Step 1 of the Import need to be precisely identified.  Data validation is strictly enforced in DataSight version 3.4 onwards and any change in date or time formatting from record to record within a raw data file will result in the partial transfer of your data to the database.

Resolution: Please check your import templates to ensure that the Date and Time Delimiters in Step 1 of the Import are precisely identified. 

Last Updated: October 10, 2018

    • Related Articles

    • Automatically Import Data

      Using saved Import Templates, an import routine can be automated as a task. From within the Tasks grid view, either double-click on a selected task row, or click on the Edit The Edit Tasks dialogue window appears. Select an Import Template (See also ...

    • 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 ...

    • Set Date and Time

      You can set the date and time within DataSight by either overtyping or by using the calendar tool. Overtyping Click the day to highlight and overtype new day. Click the month to highlight and overtype new month. Click the year to highlight and ...

    • Calculation Templates

      DataSight allows you to save your Calculation as a template that can be accessed later: To pre-fill level, variable, time shifting, formula, flags and output fields in Calculation as defined in the saved template. To be used as reference by any other ...

    • 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 ...