Changes for page Batch Upload Formats

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

Summary

Details

Icon Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.dbonicelli
1 +XWiki.mdeceunynck
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" %)**Sample file**>>attach:Role - Batch File Example-1348454930.html]]
58 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:role.csv]]
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" %)**Sample File**>>attach:Role Permission - Batch File Example-1348454930.html]]
82 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample File**>>attach:role_permission.csv]]
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" %)**Sample file**>>attach:Client - Batch File Example.csv]]
137 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:client.csv]]
138 138  
139 139  {{code}}
140 140  operation, firstName, lastName, identifier, active, gender, dob, payerID, providerID, memberID
... ... @@ -165,26 +165,29 @@
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
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
170 170  
171 -[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Client Placement - Batch File Example.csv]]
174 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:client_placement.csv]]
172 172  
173 173  {{code}}
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
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
188 188  {{/code}}
189 189  
190 190  
... ... @@ -204,7 +204,7 @@
204 204  * (% style="font-size: 14px;" %)CLIENT.identifier
205 205  * (% style="font-size: 14px;" %)TAG.code
206 206  
207 -[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Client Tag - Batch File Example.csv]]
210 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:client_tag.csv]]
208 208  
209 209  {{code}}
210 210  operation,client.identifier,tag.code
... ... @@ -249,7 +249,7 @@
249 249  * (% style="font-size: 14px;" %)firstName
250 250  * (% style="font-size: 14px;" %)lastName
251 251  
252 -[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Caregiver - Batch File Example.csv]]
255 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:caregiver.csv]]
253 253  
254 254  {{code}}
255 255  operation,client.identifier,relationshipToClient,firstName,lastName
... ... @@ -284,7 +284,7 @@
284 284  * (% style="font-size: 14px;" %)email
285 285  * (% style="font-size: 14px;" %)active
286 286  
287 -[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Staff Member - Batch File Example.csv]]
290 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:staff_member.csv]]
288 288  
289 289  {{code}}
290 290  operation,firstName,lastName,middleName,login,email,active
... ... @@ -315,7 +315,7 @@
315 315  * (% style="font-size: 14px;" %)ROLE.code
316 316  * (% style="font-size: 14px;" %)active
317 317  
318 -[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Staff Member Role - Batch File Upload.csv]]
321 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:staff_member_role.csv]]
319 319  
320 320  {{code}}
321 321  operation,user.login,role.code,active
... ... @@ -343,7 +343,7 @@
343 343  * (% style="font-size: 14px;" %)STAFF.login
344 344  * (% style="font-size: 14px;" %)ORGUNIT.code
345 345  
346 -[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Staff Member Placement - Batch File Upload.csv]]
349 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:staff_member_placement.csv]]
347 347  
348 348  {{code}}
349 349  operation,user.login,orgUnit.code
... ... @@ -373,7 +373,7 @@
373 373  * (% style="font-size: 14px;" %)childUserRole.STAFF.login
374 374  * (% style="font-size: 14px;" %)childUserRole.ROLE.code
375 375  
376 -[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Staff Member Responsibility - Batch Upload Example.csv]]
379 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:staff_member_responsibility.csv]]
377 377  
378 378  {{code}}
379 379  operation,parentUserRole.user.login,parentUserRole.role.code,childUserRole.user.login,childUserRole.role.code
... ... @@ -401,7 +401,7 @@
401 401  * (% style="font-size: 14px;" %)userRole.ROLE.code
402 402  * (% style="font-size: 14px;" %)ORGUNIT.code
403 403  
404 -[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Organizational Unit Responsibility - Batch File Example.csv]]
407 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:organizational_unit_responsibility.csv]]
405 405  
406 406  {{code}}
407 407  operation,userRole.user.login,userRole.role.code,orgUnit.code
... ... @@ -427,7 +427,7 @@
427 427  * (% style="font-size: 14px;" %)userRole.ROLE.code
428 428  * (% style="font-size: 14px;" %)CLIENT.identifier
429 429  
430 -[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Client Responsibility - Batch File Example.csv]]
433 +[[(% class="wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink wikiattachmentlink" %)**Sample file**>>attach:client_responsibility.csv]]
431 431  
432 432  {{code}}
433 433  operation,userRole.user.login,userRole.role.code,client.identifier
Icon client_responsibility.csv
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.dbonicelli
Size
... ... @@ -1,0 +1,1 @@
1 +260 bytes
Content
... ... @@ -1,0 +1,7 @@
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,0 +1,1 @@
1 +XWiki.dbonicelli
Size
... ... @@ -1,0 +1,1 @@
1 +183 bytes
Content
... ... @@ -1,0 +1,5 @@
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,0 +1,1 @@
1 +XWiki.dbonicelli
Size
... ... @@ -1,0 +1,1 @@
1 +3.0 KB
Content
... ... @@ -1,0 +1,42 @@
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,0 +1,1 @@
1 +XWiki.dbonicelli
Size
... ... @@ -1,0 +1,1 @@
1 +1.3 KB
Content
... ... @@ -1,0 +1,42 @@
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,0 +1,1 @@
1 +XWiki.dbonicelli
Size
... ... @@ -1,0 +1,1 @@
1 +733 bytes
Content
... ... @@ -1,0 +1,14 @@
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,0 +1,1 @@
1 +XWiki.dbonicelli
Size
... ... @@ -1,0 +1,1 @@
1 +1.7 KB
Content
... ... @@ -1,0 +1,42 @@
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 +