Changes for page Batch Upload Formats
Last modified by Matthew Deceunynck on 2015/06/05 16:12
From version
5.1


edited by Davide Bonicelli
on 2015/03/25 09:37
on 2015/03/25 09:37
Change comment:
There is no comment for this version
To version
4.1


edited by Davide Bonicelli
on 2015/03/25 09:35
on 2015/03/25 09:35
Change comment:
There is no comment for this version
Summary
Details
- Page properties
-
- Content
-
... ... @@ -52,17 +52,16 @@ 52 52 * (% style="font-size: 14px;" %)code 53 53 * (% style="font-size: 14px;" %)description 54 54 55 + 55 55 [[(% class="wikiattachmentlink" %)**Sample file**>>attach:Role - Batch File Example-1348454930.html]] 56 56 57 -{{code}} 58 -operation,name,code,description 58 +{{code}}operation,name,code,description 59 59 60 60 UPDATE,BatchUploadSampleRole1,BUSR1,Example role #1 61 61 62 62 UPDATE,BatchUploadSampleRole2,BUSR2,Example role #2 63 63 64 -UPDATE,BatchUploadSampleSupervisor,BUSPV,Example role #3 65 -{{/code}} 64 +UPDATE,BatchUploadSampleSupervisor,BUSPV,Example role #3{{/code}} 66 66 67 67 68 68 ==== (% style="font-size: 14px;" %)**Role Permission**(%%) ==== ... ... @@ -82,36 +82,58 @@ 82 82 83 83 [[Sample File>>attach:Role Permission - Batch File Example-1348454930.html]] 84 84 85 -{{code}} 86 - operation,role.code,permission.name84 +{{code}}operation,role.code,permission.name 85 + 87 87 UPDATE,BUSR1,CANS_CREATE 87 + 88 88 UPDATE,BUSR1,CANS_EDIT 89 + 89 89 UPDATE,BUSR1,CANS_VIEW 91 + 90 90 UPDATE,BUSR1,CLIENTS_VIEW 93 + 91 91 UPDATE,BUSR1,OU_VIEW 95 + 92 92 UPDATE,BUSR1,REPORTS_VIEW 97 + 93 93 UPDATE,BUSPV,CANS_APPROVE 99 + 94 94 UPDATE,BUSPV,CANS_AUTO_APPROVE 101 + 95 95 UPDATE,BUSPV,CANS_CREATE 103 + 96 96 UPDATE,BUSPV,CANS_EDIT 105 + 97 97 UPDATE,BUSPV,CANS_VIEW 107 + 98 98 UPDATE,BUSPV,CLIENTS_CREATE 109 + 99 99 UPDATE,BUSPV,CLIENTS_DELETE 111 + 100 100 UPDATE,BUSPV,CLIENTS_EDIT 113 + 101 101 UPDATE,BUSPV,CLIENTS_OU_VIEW 115 + 102 102 UPDATE,BUSPV,CLIENTS_TAG_VIEW 117 + 103 103 UPDATE,BUSPV,CLIENTS_VIEW 119 + 104 104 UPDATE,BUSPV,REPORTS_VIEW 121 + 105 105 UPDATE,BUSR2,ANSA_CREATE 123 + 106 106 UPDATE,BUSR2,ANSA_EDIT 125 + 107 107 UPDATE,BUSR2,ANSA_VIEW 127 + 108 108 UPDATE,BUSR2,CLIENTS_VIEW 129 + 109 109 UPDATE,BUSR2,OU_VIEW 110 -UPDATE,BUSR2,REPORTS_VIEW 111 -{{/code}} 112 112 132 +UPDATE,BUSR2,REPORTS_VIEW{{/code}} 113 113 114 114 135 + 115 115 **Client** ([[Example>>url:file:///Client+-+Batch+File+Example]]) 116 116 117 117 Description: define basic client information. ... ... @@ -146,8 +146,7 @@ 146 146 147 147 Sample file 148 148 149 -{{code}} 150 -operation, firstName, lastName, identifier, active, gender, dob, payerID, providerID, memberID 170 +{{code}}operation, firstName, lastName, identifier, active, gender, dob, payerID, providerID, memberID 151 151 UPDATE,Test,Client1,TC1,TRUE,MALE,1995/01/12,3PPID01, ProvID1, Mem117 152 152 UPDATE,Test,Client2,TC2,TRUE,FEMALE,1995/06/18,3PPID11, ProvID2, Mem121 153 153 UPDATE,Test,Client3,TC3,TRUE,MALE,1995/07/23,3PPID01, ProvID3, Mem233 ... ... @@ -159,8 +159,7 @@ 159 159 UPDATE,Test,Client9,TC9,TRUE,MALE,1997/01/31~,~, ProvID3, Mem73 160 160 UPDATE,Test,Client10,TC10,TRUE,FEMALE,1997/08/01,3PPID01~,~, Mem11 161 161 UPDATE,Test,Client11,TC11,TRUE,MALE,1997/12/19~,~, ProvID2, Mem127 162 -UPDATE,Test,Client12,TC12,TRUE,FEMALE,1998/03/27,3PPID03, ProvID1, Mem877 163 -{{/code}} 182 +UPDATE,Test,Client12,TC12,TRUE,FEMALE,1998/03/27,3PPID03, ProvID1, Mem877{{/code}} 164 164 165 165 166 166 ... ... @@ -184,23 +184,34 @@ 184 184 185 185 Sample file 186 186 187 -{{code}} 188 - operation, client.identifier, orgUnit.code206 +{{code}}operation, client.identifier, orgUnit.code 207 + 189 189 UPDATE, 1234, OU-1 209 + 190 190 UPDATE, 1235, OU-1 211 + 191 191 UPDATE, 1251, OU-1 213 + 192 192 UPDATE, 1252, OU-1 215 + 193 193 UPDATE, 1253, OU-1 217 + 194 194 UPDATE, 1254, OU-1 219 + 195 195 UPDATE, 1255, OU-2 221 + 196 196 UPDATE, 1256, OU-2 223 + 197 197 UPDATE, 1257, OU-2 225 + 198 198 UPDATE, 1258, OU-2 227 + 199 199 UPDATE, 1259, OU-2 229 + 200 200 UPDATE, 1260, OU-2 201 -UPDATE, 1261, OU-2 202 -{{/code}} 203 203 232 +UPDATE, 1261, OU-2{{/code}} 233 + 204 204 205 205 206 206 **Client Tag** ([[Example>>url:file:///Client+Tag+-+Batch+File+Example]]) ... ... @@ -223,32 +223,51 @@ 223 223 224 224 Sample file 225 225 226 -{{code}} 227 - operation,client.identifier,tag.code256 +{{code}}operation,client.identifier,tag.code 257 + 228 228 UPDATE,TC1,TT1 259 + 229 229 UPDATE,TC1,TT1.1 261 + 230 230 UPDATE,TC1,TT1.2 263 + 231 231 UPDATE,TC1,TT2 265 + 232 232 UPDATE,TC1,TT3 267 + 233 233 UPDATE,TC1,TT3.1 269 + 234 234 UPDATE,TC1,TT3.2 271 + 235 235 UPDATE,TC1,TT1 273 + 236 236 UPDATE,TC1,TT1.1 275 + 237 237 UPDATE,TC1,TT1.2 277 + 238 238 UPDATE,TC2,TT2 279 + 239 239 UPDATE,TC3,TT3 281 + 240 240 UPDATE,TC4,TT2 283 + 241 241 UPDATE,TC5,TT3 285 + 242 242 UPDATE,TC6,TT3.1 287 + 243 243 UPDATE,TC7,TT3.2 289 + 244 244 UPDATE,TC8,TT1 291 + 245 245 UPDATE,TC9,TT1.1 293 + 246 246 UPDATE,TC10,TT1.2 295 + 247 247 UPDATE,TC11,TT2 248 -UPDATE,TC12,TT3 249 -{{/code}} 250 250 298 +UPDATE,TC12,TT3{{/code}} 251 251 300 + 252 252 **Caregiver** ([[Example>>url:file:///Caregiver+-+Batch+File+Example]]) 253 253 254 254 Description: define/assign caregivers for clients. ... ... @@ -271,17 +271,21 @@ 271 271 272 272 Sample file 273 273 274 -{{code}} 275 - operation,client.identifier,relationshipToClient,firstName,lastName323 +{{code}}operation,client.identifier,relationshipToClient,firstName,lastName 324 + 276 276 UPDATE,TC2,Adoptive Father,Adopt,Father 326 + 277 277 UPDATE,TC2,Adoptive Mother,Adopt,Mother 328 + 278 278 UPDATE,TC2,Godparent,Greg,Smith 330 + 279 279 UPDATE,TC2,Godparent,Gina,Smith 332 + 280 280 UPDATE,TC2,Biological Father,Bio,Father 281 -UPDATE,TC2,Biological Mother,Bio,Mother 282 -{{/code}} 283 283 335 +UPDATE,TC2,Biological Mother,Bio,Mother{{/code}} 284 284 337 + 285 285 **Staff** ([[Example>>url:file:///Staff+Member+-+Batch+File+Example]]) 286 286 287 287 Description: define staff members/users of the system. ... ... @@ -310,17 +310,21 @@ 310 310 311 311 Sample file 312 312 313 -{{code}} 314 - operation,firstName,lastName,middleName,login,email,active366 +{{code}}operation,firstName,lastName,middleName,login,email,active 367 + 315 315 UPDATE,Test,Staff1,teststaff1,test1@test.com,TRUE 369 + 316 316 UPDATE,Test,Staff2,teststaff2,test2@test.com,TRUE 371 + 317 317 UPDATE,Test,Staff3,teststaff3,test3@test.com,TRUE 373 + 318 318 UPDATE,Test,Staff4,teststaff4,test4@test.com,TRUE 375 + 319 319 UPDATE,Test,Staff5,teststaff5,test5@test.com,TRUE 320 -UPDATE,Test,Staff6,teststaff6,test6@test.com,TRUE 321 -{{/code}} 322 322 378 +UPDATE,Test,Staff6,teststaff6,test6@test.com,TRUE{{/code}} 323 323 380 + 324 324 **Staff Role** ([[Example>>url:file:///Staff+Member+Role+-+Batch+File+Upload]]) 325 325 326 326 Description: assign roles to staff members ... ... @@ -343,17 +343,21 @@ 343 343 344 344 Sample file 345 345 346 -{{code}} 347 - operation,user.login,role.code,active403 +{{code}}operation,user.login,role.code,active 404 + 348 348 UPDATE,teststaff1,BUSR1,TRUE 406 + 349 349 UPDATE,teststaff2,BUSR1,TRUE 408 + 350 350 UPDATE,teststaff3,BUSR1,TRUE 410 + 351 351 UPDATE,teststaff4,BUSR1,TRUE 412 + 352 352 UPDATE,teststaff5,BUSR1,TRUE 353 -UPDATE,teststaff6,BUSPV,TRUE 354 -{{/code}} 355 355 415 +UPDATE,teststaff6,BUSPV,TRUE{{/code}} 356 356 417 + 357 357 **Staff Placement** ([[Example>>url:file:///Staff+Member+Placement+-+Batch+File+Upload]]) 358 358 359 359 Description: define staff member placements at org units. ... ... @@ -374,17 +374,21 @@ 374 374 375 375 Sample file 376 376 377 -{{code}} 378 - operation,user.login,orgUnit.code438 +{{code}}operation,user.login,orgUnit.code 439 + 379 379 UPDATE,teststaff1,SC.B1 441 + 380 380 UPDATE,teststaff2,SC.B2 443 + 381 381 UPDATE,teststaff3,SC.B1 445 + 382 382 UPDATE,teststaff4,SC.B2 447 + 383 383 UPDATE,teststaff5,R1W 384 -UPDATE,teststaff6,R1E 385 -{{/code}} 386 386 450 +UPDATE,teststaff6,R1E{{/code}} 387 387 452 + 388 388 **Staff Responsibility** ([[Example>>url:file:///Staff+Member+Responsibility+-+Batch+Upload+Example]]) 389 389 390 390 Description: assign staff member responsibility for other staff members. ... ... @@ -407,16 +407,19 @@ 407 407 408 408 Sample file 409 409 410 -{{code}} 411 - operation,parentUserRole.user.login,parentUserRole.role.code,childUserRole.user.login,childUserRole.role.code475 +{{code}}operation,parentUserRole.user.login,parentUserRole.role.code,childUserRole.user.login,childUserRole.role.code 476 + 412 412 UPDATE,teststaff6,BUSPV,teststaff1,BUSR1 478 + 413 413 UPDATE,teststaff6,BUSPV,teststaff2,BUSR1 480 + 414 414 UPDATE,teststaff6,BUSPV,teststaff3,BUSR1 482 + 415 415 UPDATE,teststaff6,BUSPV,teststaff4,BUSR1 416 -UPDATE,teststaff6,BUSPV,teststaff5,BUSR1 417 -{{/code}} 418 418 485 +UPDATE,teststaff6,BUSPV,teststaff5,BUSR1{{/code}} 419 419 487 + 420 420 **Organizational Unit Responsibility** ([[Example>>url:file:///Organizational+Unit+Responsibility+-+Batch+File+Example]]) 421 421 422 422 Description: assign staff member direct responsibility for org units. ... ... @@ -437,14 +437,16 @@ 437 437 438 438 Sample file 439 439 440 -{{code}} 441 - operation,userRole.user.login,userRole.role.code,orgUnit.code508 +{{code}}operation,userRole.user.login,userRole.role.code,orgUnit.code 509 + 442 442 UPDATE,teststaff6,BUSPV,SC 511 + 443 443 UPDATE,teststaff6,BUSPV,NC 513 + 444 444 UPDATE,teststaff6,BUSPV,R1 445 -UPDATE,teststaff6,BUSPV,R2 446 -{{/code}} 447 447 516 +UPDATE,teststaff6,BUSPV,R2{{/code}} 517 + 448 448 **Staff - Client Assignment** ([[Example>>url:file:///Client+Responsibility+-+Batch+File+Example]]) 449 449 450 450 Description: assign staff member direct responsibility for clients. ... ... @@ -465,18 +465,28 @@ 465 465 466 466 Sample file 467 467 468 -{{code}} 469 - operation,userRole.user.login,userRole.role.code,client.identifier538 +{{code}}operation,userRole.user.login,userRole.role.code,client.identifier 539 + 470 470 UPDATE,teststaff1,BUSR1,TC1 541 + 471 471 UPDATE,teststaff1,BUSR1,TC2 543 + 472 472 UPDATE,teststaff1,BUSR1,TC3 545 + 473 473 UPDATE,teststaff1,BUSR1,TC4 547 + 474 474 UPDATE,teststaff1,BUSR1,TC5 549 + 475 475 UPDATE,teststaff1,BUSR1,TC6 551 + 476 476 UPDATE,teststaff1,BUSR1,TC7 553 + 477 477 UPDATE,teststaff1,BUSR1,TC8 555 + 478 478 UPDATE,teststaff1,BUSR1,TC9 557 + 479 479 UPDATE,teststaff1,BUSR1,TC10 559 + 480 480 UPDATE,teststaff1,BUSR1,TC11 481 - UPDATE,teststaff1,BUSR1,TC12482 -{{/code}} 561 + 562 +UPDATE,teststaff1,BUSR1,TC12{{/code}}