Skip to Content
Last modified by Mr on 2025/08/13 11:46
From version 1.1
edited by Mr
on 2025/08/05 13:20
Change comment: Uploaded new attachment "image2020-6-16_10-54-16.png", version {1}
To version 2.2
edited by Mr
on 2025/08/05 13:30
Change comment: Update document after refactoring.

Summary

Details

Page properties
Title
... ... @@ -1,0 +1,1 @@
1 +Data update with batch file
Parent
... ... @@ -1,0 +1,1 @@
1 +PUB.ClinLab.Clinlab user manual.02\. Data manager manual.4\. Data update.WebHome
Content
... ... @@ -1,0 +1,124 @@
1 +The ClinLab software allows data updates in the database using batch import. Rules for records update are almost same as for import and it must meet the following conditions:
2 +
3 +* File extension is **txt** or **csv**.
4 +* File encoding is **UTF-8 without BOM**.
5 +* Columns are separated by **commas**.
6 +* Text **does not** need to be **enclosed** in quotation marks unless it contains a comma.
7 +* Decimal numbers are separated by a **dot.**
8 +* Dates are in the format **DD/MM/YYYY**.
9 +* Checkbox values are "**on**" (checked) or "**off**" (unchecked).
10 +* The **first row** contains a **header** with the identification of imported parameters.
11 +* The first column contains the patient **identification** (idPatient), followed by the form definition (form) where the parameter we want to update is located, and then the parameter definition (param) separated by an underscore.
12 +* For **categorical parameters**, the imported text value must **exactly match** the displayed text on the form.
13 +
14 +**Identification of patient parameters:**
15 +
16 +You can use the following items for identifying patient parameters:
17 +
18 +|=(((
19 +Identifikátor
20 +)))|=(((
21 +Popis
22 +)))|=(((
23 +Formát
24 +)))
25 +|(((
26 +**~ idPatient**
27 +)))|(((
28 + ID patient (**mandatory**)
29 +)))|(((
30 +number
31 +)))
32 +|(((
33 + //firstName//
34 +)))|(((
35 +name
36 +)))|(((
37 +text
38 +)))
39 +|(((
40 +//lastName//
41 +)))|(((
42 +surname
43 +)))|(((
44 +text
45 +)))
46 +|(((
47 +//sex//
48 +)))|(((
49 +sex
50 +)))|(((
51 +M - male
52 +
53 +F - female
54 +)))
55 +|(((
56 +//address//
57 +)))|(((
58 +adress
59 +)))|(((
60 +text
61 +)))
62 +|(((
63 +//personalID//
64 +)))|(((
65 +personal identification number
66 +)))|(((
67 +700101/1111
68 +)))
69 +|(((
70 +//email//
71 +)))|(((
72 +email
73 +)))|(((
74 +[[text@email.cz>>mailto:text@email.cz]]
75 +)))
76 +|(((
77 +//telephone//
78 +)))|(((
79 +telephone number
80 +)))|(((
81 +(+420)731111111
82 +)))
83 +|(((
84 +//healthInsurance//
85 +)))|(((
86 +heath insurance
87 +)))|(((
88 +name of health insurance
89 +)))
90 +|(((
91 +//birthDate//
92 +)))|(((
93 +date of birth
94 +)))|(((
95 +01/01/1970
96 +)))
97 +
98 +**Identification of other form parameters:**
99 +
100 +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.
101 +
102 +The format for identifying an imported parameter is form{idForm}_param{idParam}.
103 +
104 +Each form in the study has its own ID, and to retrieve it, you need to contact the administrator.
105 +
106 +Each parameter in the form has its own ID. These IDs can be obtained from the data export to Excel.
107 +
108 +[[image:https://confluence.imtm.cz/download/attachments/38895655/image2020-5-8_15-34-3.png?version=1&modificationDate=1592302789000&api=v2||alt="https://confluence.imtm.cz/download/attachments/38895655/image2020-5-8_15-34-3.png?version=1&modificationDate=1592302789000&api=v2"]]
109 +
110 +**Example of update batch files**
111 +
112 +Numbers with decimal comma are separated by quotes, and checkbox selections are set using the values on/off.
113 +
114 +[[image:https://confluence.imtm.cz/download/attachments/74055746/image2022-5-17_13-5-6.png?version=1&modificationDate=1652792706000&api=v2||alt="https://confluence.imtm.cz/download/attachments/74055746/image2022-5-17_13-5-6.png?version=1&modificationDate=1652792706000&api=v2"]]
115 +
116 +[[image:image2020-6-16_10-54-16.png||height="41"]]
117 +
118 +**Description of the last example:**
119 +
120 +* Updating data for patient with ID 28620
121 +* Updating data on forms 775 and 774
122 +* Updating parameters 5119, 5120, 5122, 5123, and 6796
123 +
124 +