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 5.1
edited by Mr
on 2025/08/13 11:46
Change comment: There is no comment for this version

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,136 @@
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 +Identification
20 +)))|=(((
21 +Description
22 +)))|=(((
23 +Format
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]]
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]]
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 +**Update batch file example of record not specified by idPatient**
125 +
126 +Update of record not identified with idPatient, but by user unique paramter specified in column "key". Please beware if more matches for key parameter are find, only value of first finding is updated.
127 +
128 +[[image:1755067395862-464.png||height="75" width="657"]]
129 +
130 +**Update batch file example of repeated parameter**
131 +
132 +Update of record with idPatient 100000 within specific repeating. Name of repeating parameter is defined in column "key" and specific value needs to be defined in separate column. In this case "form19_param20264".
133 +
134 +[[image:1755067117984-199.png||height="70" width="800"]]
135 +
136 +
1755067117984-199.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Mr
Size
... ... @@ -1,0 +1,1 @@
1 +17.5 KB
Content
1755067395862-464.png
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.Mr
Size
... ... @@ -1,0 +1,1 @@
1 +14.9 KB
Content