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)
Bilder werden zunächst ohne Zuordnung in einer Dateiimportschnittstelle importiert und nachträglich über diese Auswertung zugeordnet über den Dateinamen. Diese Auswertung muss an einen Messwerteimport angeschlossen werden und sollte in regelmäßigen Abständen (z.B. alle 30 min) laufen.

Die Dateien müssen fest benannt werden, hier:

Probennummer;Parametershort;Parameterspalte

XXX ersetzen durch id der Dateiimportschnittstelle,

Intervall anpassen auf die Häufigkeit der Auswertung.

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.