Changes for page Batch Upload Formats

Last modified by Matthew Deceunynck on 2015/06/05 16:12
From version Icon 49.1 Icon
edited by Matthew Deceunynck
on 2015/06/05 16:11
Change comment: There is no comment for this version
To version Icon 38.1 Icon
edited by Davide Bonicelli
on 2015/03/25 10:13
Change comment: Upload new attachment client_tag.csv

Summary

Details

Icon Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.mdeceunynck
1 +XWiki.dbonicelli
Content
... ... @@ -55,7 +55,7 @@
55 55  * (% style="font-size: 14px;" %)code
56 56  * (% style="font-size: 14px;" %)description
57 57  
58 -[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:role.csv]]
58 +[[(% class="wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:Role - Batch File Example-1348454930.html]]
59 59  
60 60  {{code}}
61 61  operation,name,code,description
... ... @@ -76,10 +76,10 @@
76 76  **Batch File Fields**:
77 77  
78 78  * (% style="font-size: 14px;" %)operation
79 -* (% style="font-size: 14px;" %)role.code
79 +* (% style="font-size: 14px;" %)ROLE.code
80 80  * [[permission.name>>url:file:///Assignable-Permission-List||style="font-size: 14px;"]](% style="font-size: 14px;" %) - These permissions are defined configured for your specific version of SMR
81 81  
82 -[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample File**>>attach:role_permission.csv]]
82 +[[(% class="wikiattachmentlink" %)**Sample File**>>attach:Role Permission - Batch File Example-1348454930.html]]
83 83  
84 84  {{code}}
85 85  operation,role.code,permission.name
... ... @@ -134,7 +134,7 @@
134 134  * (% style="font-size: 14px;" %)providerID
135 135  * (% style="font-size: 14px;" %)memberID
136 136  
137 -[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:client.csv]]
137 +[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Client - Batch File Example.csv]]
138 138  
139 139  {{code}}
140 140  operation, firstName, lastName, identifier, active, gender, dob, payerID, providerID, memberID
... ... @@ -165,29 +165,26 @@
165 165  
166 166  
167 167  * (% style="font-size: 14px;" %)operation
168 -* (% style="font-size: 14px;" %)client.identifier
169 -* (% style="font-size: 14px;" %)orgUnit.code
170 -* (% style="font-size: 14px;" %)startDate
171 -* (% style="font-size: 14px;" %)endDate
172 -* (% style="font-size: 14px;" %)externalId
168 +* (% style="font-size: 14px;" %)CLIENT.identifier
169 +* (% style="font-size: 14px;" %)ORGUNIT.code
173 173  
174 -[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:client_placement.csv]]
171 +[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Client Placement - Batch File Example.csv]]
175 175  
176 176  {{code}}
177 -operation, client.identifier, orgUnit.code,startDate,endDate,externalId
178 -UPDATE, 1234, OU-1, 2014/01/01,2014/07/01, abcd_20140101120000
179 -UPDATE, 1235, OU-1, 2013/02/01, , abcd_20130201120000
180 -UPDATE, 1251, OU-1, 2014/02/01, 2015/02/01, abcd_20140201131545
181 -UPDATE, 1252, OU-1, 2014/03/01, 2015/03/01, abcd_20140301170000
182 -UPDATE, 1253, OU-1, 2014/04/01, , abcd_20140101000000
183 -UPDATE, 1254, OU-1, 2014/05/01, 2014/05/02, abcd_20140501120000
184 -UPDATE, 1255, OU-2, 2013/01/01, 2014/01/01, efgh_00001
185 -UPDATE, 1256, OU-2, 2013/02/01, 2014/02/01, efgh_00002
186 -UPDATE, 1257, OU-2, 2013/03/01, 2014/03/01, efgh_00003
187 -UPDATE, 1258, OU-2, 2013/04/01, , efgh_00558
188 -UPDATE, 1259, OU-2, 2013/05/01, , efgh_01098
189 -UPDATE, 1260, OU-2, 2013/06/01, 2015/01/01, efgh_01714
190 -UPDATE, 1261, OU-2, 2013/07/01, 2014/12/31, efgh_00000_00000
174 +operation, client.identifier, orgUnit.code
175 +UPDATE, 1234, OU-1
176 +UPDATE, 1235, OU-1
177 +UPDATE, 1251, OU-1
178 +UPDATE, 1252, OU-1
179 +UPDATE, 1253, OU-1
180 +UPDATE, 1254, OU-1
181 +UPDATE, 1255, OU-2
182 +UPDATE, 1256, OU-2
183 +UPDATE, 1257, OU-2
184 +UPDATE, 1258, OU-2
185 +UPDATE, 1259, OU-2
186 +UPDATE, 1260, OU-2
187 +UPDATE, 1261, OU-2
191 191  {{/code}}
192 192  
193 193  
... ... @@ -207,7 +207,7 @@
207 207  * (% style="font-size: 14px;" %)CLIENT.identifier
208 208  * (% style="font-size: 14px;" %)TAG.code
209 209  
210 -[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:client_tag.csv]]
207 +[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Client Tag - Batch File Example.csv]]
211 211  
212 212  {{code}}
213 213  operation,client.identifier,tag.code
... ... @@ -252,7 +252,7 @@
252 252  * (% style="font-size: 14px;" %)firstName
253 253  * (% style="font-size: 14px;" %)lastName
254 254  
255 -[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:caregiver.csv]]
252 +[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Caregiver - Batch File Example.csv]]
256 256  
257 257  {{code}}
258 258  operation,client.identifier,relationshipToClient,firstName,lastName
... ... @@ -287,7 +287,7 @@
287 287  * (% style="font-size: 14px;" %)email
288 288  * (% style="font-size: 14px;" %)active
289 289  
290 -[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:staff_member.csv]]
287 +[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Staff Member - Batch File Example.csv]]
291 291  
292 292  {{code}}
293 293  operation,firstName,lastName,middleName,login,email,active
... ... @@ -318,7 +318,7 @@
318 318  * (% style="font-size: 14px;" %)ROLE.code
319 319  * (% style="font-size: 14px;" %)active
320 320  
321 -[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:staff_member_role.csv]]
318 +[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Staff Member Role - Batch File Upload.csv]]
322 322  
323 323  {{code}}
324 324  operation,user.login,role.code,active
... ... @@ -346,7 +346,7 @@
346 346  * (% style="font-size: 14px;" %)STAFF.login
347 347  * (% style="font-size: 14px;" %)ORGUNIT.code
348 348  
349 -[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:staff_member_placement.csv]]
346 +[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Staff Member Placement - Batch File Upload.csv]]
350 350  
351 351  {{code}}
352 352  operation,user.login,orgUnit.code
... ... @@ -376,7 +376,7 @@
376 376  * (% style="font-size: 14px;" %)childUserRole.STAFF.login
377 377  * (% style="font-size: 14px;" %)childUserRole.ROLE.code
378 378  
379 -[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:staff_member_responsibility.csv]]
376 +[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Staff Member Responsibility - Batch Upload Example.csv]]
380 380  
381 381  {{code}}
382 382  operation,parentUserRole.user.login,parentUserRole.role.code,childUserRole.user.login,childUserRole.role.code
... ... @@ -404,7 +404,7 @@
404 404  * (% style="font-size: 14px;" %)userRole.ROLE.code
405 405  * (% style="font-size: 14px;" %)ORGUNIT.code
406 406  
407 -[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:organizational_unit_responsibility.csv]]
404 +[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Organizational Unit Responsibility - Batch File Example.csv]]
408 408  
409 409  {{code}}
410 410  operation,userRole.user.login,userRole.role.code,orgUnit.code
... ... @@ -430,7 +430,7 @@
430 430  * (% style="font-size: 14px;" %)userRole.ROLE.code
431 431  * (% style="font-size: 14px;" %)CLIENT.identifier
432 432  
433 -[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:client_responsibility.csv]]
430 +[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Client Responsibility - Batch File Example.csv]]
434 434  
435 435  {{code}}
436 436  operation,userRole.user.login,userRole.role.code,client.identifier
Icon caregiver.csv
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.dbonicelli
Size
... ... @@ -1,1 +1,0 @@
1 -1.0 KB
Content
... ... @@ -1,20 +1,0 @@
1 -"operation","client.identifier","relationshipToClient","firstName","lastName","identifier"
2 -"UPDATE","1249","Stepfather","Joshua","Cook","1"
3 -"UPDATE","1250","Adoptive","Father","Thomas","Morgan","2"
4 -"UPDATE","1251","Adoptive","Father","James","Bell","3"
5 -"UPDATE","1252","Biological","Father","Daniel","Murphy","4"
6 -"UPDATE","1253","Biological","Father","Samuel","Bailey","5"
7 -"UPDATE","1254","Godparent","Oliver","Rivera","6"
8 -"UPDATE","1255","Legal","Guardian","William","Cooper","7"
9 -"UPDATE","1256","Legal","Guardian","Benjamin","Richardson","8"
10 -"UPDATE","1257","Godparent","Joseph","Cox","9"
11 -"UPDATE","1258","Godparent","Harry","Howard","10"
12 -"UPDATE","1259","Godparent","Matthew","Ward","11"
13 -"UPDATE","1260","Adoptive","Mother","Emily","Torres","12"
14 -"UPDATE","1261","Legal","Guardian","Ellie","Peterson","13"
15 -"UPDATE","1262","Legal","Guardian","Jessica","Gray","14"
16 -"UPDATE","1263","StepMother","Sophie","Ramirez","15"
17 -"UPDATE","1264","StepMother","Chloe","James","16"
18 -"UPDATE","1265","StepMother","Lucy","Reed","17"
19 -"UPDATE","1266","StepMother","Olivia","Rogers","18:"
20 -
Icon client_responsibility.csv
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.dbonicelli
Size
... ... @@ -1,1 +1,0 @@
1 -260 bytes
Content
... ... @@ -1,7 +1,0 @@
1 -"operation","userRole.user.login","userRole.role.code","client.identifier"
2 -"UPDATE","john.williams","cw","1234"
3 -"UPDATE","john.williams","cw","1235"
4 -"UPDATE","john.williams","cw","1236"
5 -"UPDATE","john.williams","cw","1237"
6 -"UPDATE","john.williams","cw","1238"
7 -
Icon organizational_unit_responsibility.csv
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.dbonicelli
Size
... ... @@ -1,1 +1,0 @@
1 -183 bytes
Content
... ... @@ -1,5 +1,0 @@
1 -"operation","userRole.user.login","userRole.role.code","orgUnit.code"
2 -"UPDATE","david.anderson","su","OU-1"
3 -"UPDATE","mary.clark","su","OU-2"
4 -"UPDATE","shirley.rodriguez","su","OU-1"
5 -
Icon staff_member.csv
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.dbonicelli
Size
... ... @@ -1,1 +1,0 @@
1 -3.0 KB
Content
... ... @@ -1,42 +1,0 @@
1 -"operation","firstName","lastName","login","email","active"
2 -"UPDATE","Robert","Smith","robert.smith","robert.smith@oademo.com","TRUE"
3 -"UPDATE","James","Johnson","james.johnson","james.johnson@oademo.com","TRUE"
4 -"UPDATE","John","Williams","john.williams","john.williams@oademo.com","TRUE"
5 -"UPDATE","William","Jones","william.jones","william.jones@oademo.com","TRUE"
6 -"UPDATE","Richard","Brown","richard.brown","richard.brown@oademo.com","TRUE"
7 -"UPDATE","Charles","Davis","charles.davis","charles.davis@oademo.com","TRUE"
8 -"UPDATE","Donald","Miller","donald.miller","donald.miller@oademo.com","TRUE"
9 -"UPDATE","George","Wilson","george.wilson","george.wilson@oademo.com","TRUE"
10 -"UPDATE","Thomas","Moore","thomas.moore","thomas.moore@oademo.com","FALSE"
11 -"UPDATE","Joseph","Taylor","joseph.taylor","joseph.taylor@oademo.com","TRUE"
12 -"UPDATE","David","Anderson","david.anderson","david.anderson@oademo.com","TRUE"
13 -"UPDATE","Ronald","Thomas","ronald.thomas","ronald.thomas@oademo.com","TRUE"
14 -"UPDATE","Edward","Jackson","edward.jackson","edward.jackson@oademo.com","TRUE"
15 -"UPDATE","Paul","White","paul.white","paul.white@oademo.com","TRUE"
16 -"UPDATE","Kenneth","Harris","kenneth.harris","kenneth.harris@oademo.com","TRUE"
17 -"UPDATE","Frank","Martin","frank.martin","frank.martin@oademo.com","TRUE"
18 -"UPDATE","Raymond","Thompson","raymond.thompson","raymond.thompson@oademo.com","TRUE"
19 -"UPDATE","Jack","Garcia","jack.garcia","jack.garcia@oademo.com","TRUE"
20 -"UPDATE","Billy","Martinez","billy.martinez","billy.martinez@oademo.com","TRUE"
21 -"UPDATE","Harold","Robinson","harold.robinson","harold.robinson@oademo.com","TRUE"
22 -"UPDATE","Mary","Clark","mary.clark","mary.clark@oademo.com","TRUE"
23 -"UPDATE","Shirley","Rodriguez","shirley.rodriguez","shirley.rodriguez@oademo.com","TRUE"
24 -"UPDATE","Barbara","Lewis","barbara.lewis","barbara.lewis@oademo.com","TRUE"
25 -"UPDATE","Betty","Lee","betty.lee","betty.lee@oademo.com","TRUE"
26 -"UPDATE","Patricia","Walker","partricia.walker","partricia.walker@oademo.com","TRUE"
27 -"UPDATE","Dorothy","Hall","dorothy.hall","dorothy.hall@oademo.com","TRUE"
28 -"UPDATE","Joan","Allen","joan.allen","joan.allen@oademo.com","TRUE"
29 -"UPDATE","Margaret","Young","margaret.young","margaret.young@oademo.com","TRUE"
30 -"UPDATE","Nancy","Hernandez","nancy.hernandez","nancy.hernandez@oademo.com","TRUE"
31 -"UPDATE","Helen","King","helen.king","helen.king@oademo.com","FALSE"
32 -"UPDATE","Carol","Wright","carol.wright","carol.wright@oademo.com","TRUE"
33 -"UPDATE","Joyce","Lopez","joyce.lopez","joyce.lopez@oademo.com","TRUE"
34 -"UPDATE","Doris","Hill","doris.hill","doris.hill@oademo.com","TRUE"
35 -"UPDATE","Marilyn","Scott","marilyn.scott","marilyn.scott@oademo.com","TRUE"
36 -"UPDATE","Ruth","Green","ruth.green","ruth.green@oademo.com","TRUE"
37 -"UPDATE","Virginia","Adams","virginia.adams","virginia.adams@oademo.com","TRUE"
38 -"UPDATE","Elizabeth","Baker","elizabeth.baker","elizabeth.baker@oademo.com","TRUE"
39 -"UPDATE","Jean","Gonzalez","jean.gonzalez","jean.gonzalez@oademo.com","TRUE"
40 -"UPDATE","Frances","Nelson","frances.nelson","frances.nelson@oademo.com","TRUE"
41 -"UPDATE","Beverly","Carter","beverly.carter","beverly.carter@oademo.com","TRUE"
42 -
Icon staff_member_placement.csv
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.dbonicelli
Size
... ... @@ -1,1 +1,0 @@
1 -1.3 KB
Content
... ... @@ -1,42 +1,0 @@
1 -"operation","user.login","orgUnit.code"
2 -"UPDATE","robert.smith","OU-1"
3 -"UPDATE","james.johnson","OU-1"
4 -"UPDATE","john.williams","OU-1"
5 -"UPDATE","william.jones","OU-1"
6 -"UPDATE","richard.brown","OU-1"
7 -"UPDATE","charles.davis","OU-1"
8 -"UPDATE","donald.miller","OU-1"
9 -"UPDATE","george.wilson","OU-1"
10 -"UPDATE","thomas.moore","OU-1"
11 -"UPDATE","joseph.taylor","OU-2"
12 -"UPDATE","david.anderson","OU-2"
13 -"UPDATE","ronald.thomas","OU-2"
14 -"UPDATE","edward.jackson","OU-2"
15 -"UPDATE","paul.white","OU-2"
16 -"UPDATE","kenneth.harris","OU-2"
17 -"UPDATE","frank.martin","OU-2"
18 -"UPDATE","raymond.thompson","OU-2"
19 -"UPDATE","jack.garcia","OU-2"
20 -"UPDATE","billy.martinez","OU-2"
21 -"UPDATE","harold.robinson","OU-2"
22 -"UPDATE","mary.clark","OU-2"
23 -"UPDATE","shirley.rodriguez","OU-2"
24 -"UPDATE","barbara.lewis","OU-2"
25 -"UPDATE","betty.lee","OU-2"
26 -"UPDATE","partricia.walker","OU-2"
27 -"UPDATE","dorothy.hall","OU-2"
28 -"UPDATE","joan.allen","OU-2"
29 -"UPDATE","margaret.young","OU-2"
30 -"UPDATE","nancy.hernandez","OU-2"
31 -"UPDATE","helen.king","OU-2"
32 -"UPDATE","carol.wright","OU-2"
33 -"UPDATE","joyce.lopez","OU-2"
34 -"UPDATE","doris.hill","OU-2"
35 -"UPDATE","marilyn.scott","OU-2"
36 -"UPDATE","ruth.green","OU-2"
37 -"UPDATE","virginia.adams","OU-2"
38 -"UPDATE","elizabeth.baker","OU-2"
39 -"UPDATE","jean.gonzalez","OU-2"
40 -"UPDATE","frances.nelson","OU-2"
41 -"UPDATE","beverly.carter","OU-2"
42 -
Icon staff_member_responsibility.csv
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.dbonicelli
Size
... ... @@ -1,1 +1,0 @@
1 -733 bytes
Content
... ... @@ -1,14 +1,0 @@
1 -"operation","parentUserRole.user.login","parentUserRole.role.code","childUserRole.user.login","childUserRole.role.code"
2 -"UPDATE","david.anderson","su","robert.smith","cw"
3 -"UPDATE","david.anderson","su","james.johnson","cw"
4 -"UPDATE","david.anderson","su","john.williams","cw"
5 -"UPDATE","david.anderson","su","william.jones","cw"
6 -"UPDATE","david.anderson","su","richard.brown","cw"
7 -"UPDATE","david.anderson","su","charles.davis","cw"
8 -"UPDATE","mary.clark","su","raymond.thompson","cw"
9 -"UPDATE","mary.clark","su","jack.garcia","cw"
10 -"UPDATE","mary.clark","su","billy.martinez","cw"
11 -"UPDATE","mary.clark","su","harold.robinson","cw"
12 -"UPDATE","shirley.rodriguez","su","barbara.lewis","cw"
13 -"UPDATE","shirley.rodriguez","su","betty.lee","cw"
14 -
Icon staff_member_role.csv
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.dbonicelli
Size
... ... @@ -1,1 +1,0 @@
1 -1.7 KB
Content
... ... @@ -1,42 +1,0 @@
1 -"operation","user.login","role.code","active","accountId"
2 -"UPDATE","robert.smith","cw","TRUE","100"
3 -"UPDATE","james.johnson","cw","TRUE","100"
4 -"UPDATE","john.williams","cw","TRUE","100"
5 -"UPDATE","william.jones","cw","TRUE","100"
6 -"UPDATE","richard.brown","cw","TRUE","100"
7 -"UPDATE","charles.davis","cw","TRUE","100"
8 -"UPDATE","donald.miller","cw","TRUE","100"
9 -"UPDATE","george.wilson","cw","TRUE","100"
10 -"UPDATE","thomas.moore","cw","TRUE","100"
11 -"UPDATE","joseph.taylor","cw","TRUE","100"
12 -"UPDATE","david.anderson","su","TRUE","100"
13 -"UPDATE","ronald.thomas","cw","TRUE","100"
14 -"UPDATE","edward.jackson","cw","TRUE","100"
15 -"UPDATE","paul.white","cw","TRUE","100"
16 -"UPDATE","kenneth.harris","cw","TRUE","100"
17 -"UPDATE","frank.martin","cw","TRUE","100"
18 -"UPDATE","raymond.thompson","cw","TRUE","100"
19 -"UPDATE","jack.garcia","cw","TRUE","100"
20 -"UPDATE","billy.martinez","cw","TRUE","100"
21 -"UPDATE","harold.robinson","cw","TRUE","100"
22 -"UPDATE","mary.clark","su","TRUE","100"
23 -"UPDATE","shirley.rodriguez","su","TRUE","100"
24 -"UPDATE","barbara.lewis","cw","TRUE","100"
25 -"UPDATE","betty.lee","cw","TRUE","100"
26 -"UPDATE","partricia.walker","cw","TRUE","100"
27 -"UPDATE","dorothy.hall","cw","TRUE","100"
28 -"UPDATE","joan.allen","cw","TRUE","100"
29 -"UPDATE","margaret.young","cw","TRUE","100"
30 -"UPDATE","nancy.hernandez","cw","TRUE","100"
31 -"UPDATE","helen.king","cw","TRUE","100"
32 -"UPDATE","carol.wright","cw","TRUE","100"
33 -"UPDATE","joyce.lopez","cw","TRUE","100"
34 -"UPDATE","doris.hill","cw","TRUE","100"
35 -"UPDATE","marilyn.scott","cw","TRUE","100"
36 -"UPDATE","ruth.green","cw","TRUE","100"
37 -"UPDATE","virginia.adams","cw","TRUE","100"
38 -"UPDATE","elizabeth.baker","cw","TRUE","100"
39 -"UPDATE","jean.gonzalez","de","TRUE","100"
40 -"UPDATE","frances.nelson","de","TRUE","100"
41 -"UPDATE","beverly.carter","de","TRUE","100"
42 -