Skip to Content
Last modified by Mr on 2025/08/13 11:46
From version 2.2
edited by Mr
on 2025/08/05 13:30
Change comment: Update document after refactoring.
To 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}

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,0 @@
1 -Data update with batch file
Parent
... ... @@ -1,1 +1,0 @@
1 -PUB.ClinLab.Clinlab user manual.02\. Data manager manual.4\. Data update.WebHome
Content
... ... @@ -1,124 +1,0 @@
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 -