Connect Blood Donor Online with other Blood Management System
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.
Use an EAI like Enovacom or Cloverleaf
Connect to the SFTP server using your credentials (username, password and/or SSH key).
After connection:
Navigate to the IN directory.
Navigate to the good subfolder.
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.
Once the files have been transferred, check that they appear in the target folder.
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.
Contact support to inform that the files have been successfully uploaded and continue with the deployment steps:
Here is the folder structure used for organizing files on the SFTP server:
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
The OUT folder allows you to recover files subsequently exported from Blood Donor software such as the exam catalog, users...
Format: Files are in .csv format (semicolon separated and quoted column by '"').
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.
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
• The file will be a smemicolon-separated CSV with eventually quoted columns ".
• The escape character is \.
• Encoding: Files must use UTF-8 encoding.**
Steps to follow
1. Connection to SFTP server
Use an EAI like Enovacom or Cloverleaf
Connect to the SFTP server using your credentials (username, password and/or SSH key).
2. Navigate to target folder
After connection:
Navigate to the IN directory.
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
Once the files have been transferred, check that they appear in the target folder.
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
Format: Files are in .csv format (semicolon separated and quoted column by '"').
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
Thank you!