Data import in a txt/csv batch file is done from the study window. Special permissions are required for this type of import.
The batch import must meet the following conditions:
- The file extension is txt or csv.
- The file encoding is UTF-8 without BOM.
- The first row contains a header with the identification of the imported parameters.
- The column separator is a comma. If a comma exists within a text, it should be enclosed in quotation marks.
- Decimal numbers are separated by a dot.
- Dates are in the format DD/MM/YYYY.
Patient Identification:
The following parameters can be used for patient identification:
Identifier | Description | Format |
---|---|---|
Identifier | Description | Format |
firstName | name | text |
lastName | surname | text |
sex | sex | M - male F - female |
address | adress | text |
personalID | personal identification number | 700101/1111 |
text@email.cz | ||
telephone | telephone number | (+420)731111111 |
healthInsurance | health insurance company | 111 Všeobecná zdravotní pojišťovna 201 Vojenská zdravotní pojišťovna 205 Česká průmyslová zdravotní pojišťovna 207 Oborová zdravotní pojišťovna zaměstnanců bank, pojišťoven a stavebnictví 209 Zaměstnanecká pojišťovna Škoda 211 Zdravotní pojišťovna ministerstva vnitra České republiky 213 Revírní bratrská pokladna 747 Pojišťovna Maxima |
city | city | Brno |
postalCode | postal code | 60100 |
birthDate | date of birth | 08/01/2012 |
Identification of other form parameters
The identification of other parameters on the form can be found in the data export to XLSX. An example of some parameters is shown in the image.
Before granting parameter a number, it is necessary to insert the form ID with an underscore in which the parameter is located. The form ID can be obtained by selecting Study - Study details from the menu, choosing the relevant study, go to the CRF templates tab, and then editing the form that contains the parameter. The form number can be found at the end of the URL address, for example, https://clindata.imtm.cz/formDesigner/open?idForm=1697. An example for parameter number for import is form1697_param10101.
For categorical parameters, the imported text value must exactly match the displayed text on the form.
Example of batch import file