You can import multiple images and optionally additional information (e.g. magnification of microscope images) in one parameter, requiring only a new evaluation and two parameters.

Guide: Importing and Linking Images and Measurement Data

1. Preparation

Create Parameter

• Create a parameter for merging all information/files.
• Add a Image column, optionally with concatenation and Image ID.
• Important: The Image column must have the data type upload.

File Naming for Automatic Assignment

To ensure that the evaluation can correctly assign images, there are two options:

1. Use Sample Number in File Name

   • The sample number must be included in the file name.
   • Optional: If images are to be assigned to different parameters or columns, this should also be included in the file name.
   • Example format:
     SampleNumber;ParameterShort;Column.jpg

2. Assign Unique Image ID

   • Alternatively, each image can be assigned a unique Image ID.
   • This ID must also be stored in a parameter, e.g., via a measurement value import.
   • Only in this way can the images later be correctly linked to samples and parameters.

2. Create Interfaces

2.1 File Import Interface

• For uploading the image as a file (without direct linking).
• Note: This interface is only used for uploading the file; assignment is done via the evaluation.

3. Create Evaluation

• Searches for file name, upload_id, and assigns the corresponding sample (and parameter/column).
• Sends the data to the measurement value import interface.

Example code for the evaluation (SQL)
Images are initially imported without assignment in a file import interface and subsequently assigned via this evaluation using the file name. This evaluation must be connected to a measured value import and should run at regular intervals (e.g. every 30 minutes).

The files must be given a fixed name, here:

Sample number;Parameter short;Parameter column

Replace XXX with id of the file import interface,

Adjust interval to the frequency of the evaluation.

SELECT
SUBSTRING_INDEX(imports.file_name,';',1)as 'Probe',
SUBSTRING_INDEX(SUBSTRING_INDEX(imports.file_name,';',2),';',-1)as 'Parameter',
if(SUBSTRING_INDEX(imports.file_name,';',-1) like '0%', imports.upload_id, '') as Spalte0,
if(SUBSTRING_INDEX(imports.file_name,';',-1) like '1%', imports.upload_id, '') AS Spalte1,
if(SUBSTRING_INDEX(imports.file_name,';',-1) like '2%', imports.upload_id, '') AS Spalte2,
if(SUBSTRING_INDEX(imports.file_name,';',-1) like '3%', imports.upload_id, '') AS Spalte3,
if(SUBSTRING_INDEX(imports.file_name,';',-1) like '4%', imports.upload_id, '') AS Spalte4,
if(SUBSTRING_INDEX(imports.file_name,';',-1) like '5%', imports.upload_id, '') AS Spalte5,
if(SUBSTRING_INDEX(imports.file_name,';',-1) like '6%', imports.upload_id, '') AS Spalte6,
if(SUBSTRING_INDEX(imports.file_name,';',-1) like '7%', imports.upload_id, '') AS Spalte7,
if(SUBSTRING_INDEX(imports.file_name,';',-1) like '8%', imports.upload_id, '') AS Spalte8,
if(SUBSTRING_INDEX(imports.file_name,';',-1) like '9%', imports.upload_id, '') AS Spalte9

from imports

where imports.importinterface_id = XXX
and imports.date > UNIX_TIMESTAMP(NOW() - INTERVAL 35 MINUTE)

2.2 Import Interface for Automatic Entry

• In Import Mapping, define the parameter assignments.
• When executing this interface, images are automatically assigned to the correct samples and parameters based on the evaluation.

2.3 Optional Measurement Value Interface

• For uploading additional information, e.g., microscope data.
• Also provides the unique Image ID and sample number.

4. Import Process

1. Upload Image:
   Upload the image as a file via the File Import Interface.

2. Optional: Import Measurement Values:
   Import text-based information (e.g., microscope data) along with the Image ID and sample number.

3. Execute Evaluation:

   • Searches for the image based on the file name and links it to the sample and, if applicable, parameters/columns.
   • Imports the uploads.id into the parameter.

Info: Enterprise customers can schedule import interfaces, so manual execution is not required.