Import Samples
To import samples, start with the creation of an import template for a sample type. Navigate to the Import tab in the System Admin Panel and open Import Samples from Template. Please read the instructions here for on the formatting of data prior to executing the data migration.
Prior to importing the file, make sure that the imported sample type template is created according to the following specifications:
- The name of the sample import template must be contained in the imported file. It is allowed add additional info using only letters in the file name (e.g. the file name should be SamplesImportTemplate_24_228.xlsx or SamplesImportTemplate_24_228.csv)
- The file contains a maximum of 1000 rows (e.g import up to 1000 samples at a time)
- The to be imported data is formatted according to the import specifications (see here). The common reasons problems in data formatting are wrong or mixed date formatting (should be yyy-mm-dd), use of comma (,) to separate decimal numbers and importing multiple samples on the same position.
- In case of import from CSV, the file is converted to a .CSV file with a ; as the separator
- In case special characters are used (e.g. Greek characters or symbols), make sure that the .CSV file is created with the UTF-8 character set. Note that there are known issues in Excel when converting the file to CSV with special characters. LibreOffice provides better options to concert Excel to CSV files.
To execute the sample import, Upload the file and click Import Samples. Depending on the number of samples to be imported, the application is processing the file and importing the sample. Note that if the file is not formatted according to specifications, the import is not executed.