Import Routine

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.

 

DataSight's import routine allows for:

  • Import of human readable data files in many formats including XLSX, XLS, CSV, TXT, a large number of data logger .DAT data files as well as many LIMS data exports.
  • Optional automated review against a selected standard, with little or no pre-processing.
  • Both manual and automated reception of monitoring data or files.
  • Modification of import templates to meet changing needs with new instrumentation or electronic formats.
  • Easy migration of historical data by using the “wild card” option with an automated import task.

 

Start Import Routine

  • Click Import in the Input group on the DataSight Ribbon.

 

See also:

  • Manual Data Entry
  • Data Migration
  • Automated Import

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

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

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

    • LoRaWAN Device Automated Import Task

      Currently DataSight supports the Sense API for requesting data (i.e. a PULL operation) in an Automated Task, which requests the latest data, downloads it in JSON format, converts it to a Normalised CSV format, and then imports the data into your ...