This help explains how to upload files containing patient results to an SFTP server. Files should be organized and placed in specific directories based on their format.

Steps to follow

1. Connection to SFTP server

1. Use an EAI like Enovacom or Cloverleaf
2. Connect to the SFTP server using your credentials (username, password and/or SSH key).
   

2. Navigate to target folder

After connection:

1. Navigate to the IN directory.
2. Navigate to the good subfolder.
   

3. Automatic file classification

Once a file is dropped into the corresponding subfolder ( hl7 or hprim), it will automatically be sorted by date. This organization makes it easy to find files according to their filing date and to ensure their processing.

4. Verification after transfer

1. Once the files have been transferred, check that they appear in the target folder.
2. Make sure the SFTP repository is working properly. Use an SFTP client like FileZilla, WinSCP, or an SFTP command line to verify that the EAI is working.
   

5. Contact the support team

Contact support to inform that the files have been successfully uploaded and continue with the deployment steps:

SFTP directory structure

Here is the folder structure used for organizing files on the SFTP server:

1. Folder IN

The IN folder allows you to drop files in order to enrich the software in the Inlog4CATALOG and Blood Donor Online suite. These files can contain various types of data, including:

• Results
• Patients
• Users
• Exams
  

2. Folder OUT

The OUT folder allows you to recover files subsequently exported from **Blood Donor **software such as the exam catalog, users...

Structure of CSV Questionnaire file for Blood Donor

File Format

1. Format: Files are in .csv format (semicolon separated and quoted column by '"').

2. Columns:

• Static Columns: columns prefixed with “STATIC_”. Include general donor information such as ID_DONOR, FIRST_NAME, LAST_NAME, BIRTHDATE.

• Dynamic Columns: Customizable columns prefixed with “DYNAMIC_”. For the input file, every dynamic column will be used and inserted into the questionnaire. In the output file, each question will have its own column.

NO HEADER CSV

The CSV is special, it has no header and the columns are directly included in the value cell. Each cell value is represented by a key value separated by double dots.
For example :
STATIC_UID:1706B8EA91C545CD8F2A37369D7A9766;STATIC_DONOR_NO:167050;STATIC_COLLECTION_NOL:901920;STATIC_SITE:1;DYNAMIC_ELIGIBILITY:1011;STATIC_LASTNAME:DEMOSPENDER;STATIC_FIRSTNAME:Alfred;DYNAMIC_DOB:12.12.1990;STATIC_GENDER:M;DYNAMIC_QUALIFICATION:WB;DYNAMIC_PHYS_DIRECTED:0

CSV Formatting:

• The file will be a smemicolon-separated CSV with eventually quoted columns ".

• The escape character is \.

• Encoding: Files must use UTF-8 encoding.**

Updated on: 10/02/2025