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)

select samples.name as 'Sample',
pt.short as 'Parameter',
CONCAT('upload_id_for_img_to_show==', MAX(uploads.id)) as 'Image',
MAX(uploads.id) As 'Image-ID' 
FROM samples
JOIN parameters on parameters.sample_id = samples.id
JOIN parametertypes as pt on parameters.parametertype_id = pt.id and pt.name LIKE '%Recording%'
JOIN imports on imports.importinterface_id = "Customer-ID" 
   and INSTR(file_name, "Entry in Column X")
JOIN uploads on uploads.id = imports.upload_id
WHERE samples.id = _VAR0_
group by pt.id

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.