Skip to main content

Data import overview

LOGiCAL Import tool, that allows users to import new instruments and references from other systems to LOGiCAL via an excel file.

Import view​

Instrument import view can be opened by clicking + Add on the navigation pane and selecting Import from the opening menu.

New import​

New instruments and references are imported to LOGiCAL using excel files. Start by clicking Templates to download the Import excel templates in one zip file and extract them into your computer.

There are three different excel files available in LOGiCAL:

Import templateUsed to
templateXmtr.xlsximport new instruments (other than switches).
templateSwitch.xlsximport new switch instruments
templateReference.xlsximport new references

Fill the excel​

Choose the import template based on the type of data you want to import and open it. The Import template contains two tabs:

  • Sheet 1 tab, where the data to be imported is filled out
  • Examples tab, which includes some example function data.

Instrument import and Reference import pages instruct you on the specific data fields to fill.

Note!

You should save the import template with a recognizable name, as it will be shown in the import log view

Close the excel file before you load the excel file back to LOGiCAL

Import data​

You can drag and drop the excel file to the import area, or click the area to browse for the file.

Once the file is chosen, LOGiCAL validates the excel data and shows a preview of the data to be imported:

  • Excel row
  • Status of the validation
  • Instrument and function identifications and
  • Validation note indicates if there is an error found during data validation.

Import can be started by clicking START IMPORT. Importing will take some time so be patient.

Note!

Data rows that have validation errors cannot be imported.

In progress​

This view shows imports that are in progress. By clicking on the data row, you can see more details.

Import history​

This view lists all import events, indicating

  • the name of the imported file
  • the type of the instrument template
  • Status of the import (e.g. Completed or Failed)
  • Timestamp of the Import start time and
  • Who started the import process

By clicking on the data row, you can see more details.