The ClinData software allows data updates in the database using batche imports.
The import batch must meet the following conditions:
- File extension is txt or csv.
- File encoding is UTF-8 without BOM.
- Columns are separated by commas.
- Text does not need to be enclosed in quotation marks unless it contains a comma.
- Decimal numbers are separated by a dot.
- Dates are in the format DD/MM/YYYY.
- Checkbox values are "on" (checked) or "off" (unchecked).
- The first row contains a header with the identification of imported parameters.
- Record identification for updating is done using the patient ID (idPatient).
Identification of patient parameters:
You can use the following items for identifying patient parameters:
Identifikátor | Popis | Formát |
|---|---|---|
| idPatient | ID patient (mandatory) | číslo |
| firstName | name | text |
lastName | surname | text |
sex | sex | M - muž F - žena |
| address | adress | text |
| personalID | personal identification number | 700101/1111 |
| text@email.cz | ||
| telephone | telephone number | (+420)731111111 |
| healthInsurance | heath insurance | 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 |
| birthDate | date of birth | 01/01/1970 |
Identification of other form parameters:
Identification of other parameters on the form can be found in the data export to xlsx format. The number of imported parameters is not limited.
The format for identifying an imported parameter is form{idForm}_param{idParam}.
Each form in the study has its own ID, and to retrieve it, you need to contact the administrator.
Each parameter in the form has its own ID. These IDs can be obtained from the data export to Excel.
Categorical Parameters
For categorical parameters, the imported text value must exactly match the displayed text on the form.
Example of update batch file
Description of the example:
- Updating data for patient with ID 28620
- Updating data on forms 775 and 774
- Updating parameters 5119, 5120, 5122, 5123, and 6796