Changes for page Batch Upload Formats

Last modified by Matthew Deceunynck on 2015/06/05 16:12
From version Icon 3.1 Icon
edited by Davide Bonicelli
on 2015/03/25 09:31
Change comment: Upload new attachment Role Permission - Batch File Example-1348454930.html
To version Icon 8.1 Icon
edited by Davide Bonicelli
on 2015/03/25 09:42
Change comment: Upload new attachment Client - Batch File Example.csv

Summary

Details

Icon Page properties
Title
... ... @@ -1,0 +1,1 @@
1 +Batch Upload Formats
Parent
... ... @@ -1,0 +1,1 @@
1 +Documentation.WebHome
Content
... ... @@ -1,0 +1,482 @@
1 +== **Batch Data File Formats and Examples** ==
2 +
3 +* Each batch file contains a set of related items that represent an aspect of your organization - your clients, your staff, the roles your staff will fulfill using the system.
4 +* Some batch files must be loaded before others so that a particular aspect of your organization can be linked to another, for example, client data must be uploaded prior to the client placement data.
5 +* Organization Units (ORGUNIT) does not have a batch upload and must be defined through the SMR application
6 +* Taxonomy tags (TAG) do not have a batch upload and must be defined through the SMR application.
7 +* The following table briefly describes each batch file according to the aspect of the organization it contains.
8 +
9 +
10 +
11 +|**Organizational Aspect**|**Description **|**Prerequisite Item(s)**
12 +|**1. Role**|What are the distinct groups of users in your organization? |None
13 +|**2. Role Permission**|What specific permissions are allowed for each role? |Role
14 +|**3. Client** |Identify the clients your organization is serving |None
15 +|**4. Client Placement** |Where do your clients belong for in your organization structure?|Client, Org Unit
16 +|**5. Client Tag** |Associate clients with non-OU tags/taxonomy items |Client, Tag
17 +|**6. Caregiver** |Associate caregivers to specific clients |Client
18 +|**7. Staff **|Identify the staff members in your organization.|staff members' email addresses
19 +|**8. Staff Role**|What role does a specific staff member serve?|Staff, Role
20 +|**9. Staff Placement**|Where do your staff belong in your organization structure?|Staff, Org Unit
21 +|**10. Staff Responsibility**|Who supervises each staff member?|Staff, Role
22 +|**11. Organizational Unit Responsibility**|Which organizational unit does each staff member belong to?|Staff, Role, Org Unit
23 +|**12. Staff-Client Assignment** |Which clients are specifically assigned to a staff member?|Staff, Role, Client
24 +
25 +* The following diagram provides a visual roadmap of the prerequisites for loading each batch file:(% style="font-family: sans-serif; font-size: 14px;" %)
26 +
27 + [[image:BatchUploadTablesAndKeys-1330540947.png]]
28 +
29 +
30 +
31 +The sections below describe specific upload information about each organizational batch upload file:
32 +
33 +* Name of organization items and link to an example of batch upload content
34 +* Description
35 +* Upload fields
36 +* Sample upload file - These samples were used to successfully populate a test version of the SMR system.
37 +* Screenshot of the appropriate admin page after successful upload
38 +
39 +==== **Role** ====
40 +
41 +**Description**: define Roles in the system.
42 +
43 +**Same as**: Roles... admin screen.
44 +
45 +**Prerequisite**: None
46 +
47 +**Batch File Fields**:
48 +
49 +
50 +* (% style="font-size: 14px;" %)operation
51 +* (% style="font-size: 14px;" %)name
52 +* (% style="font-size: 14px;" %)code
53 +* (% style="font-size: 14px;" %)description
54 +
55 +[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Role - Batch File Example-1348454930.html]]
56 +
57 +{{code}}
58 +operation,name,code,description
59 +
60 +UPDATE,BatchUploadSampleRole1,BUSR1,Example role #1
61 +
62 +UPDATE,BatchUploadSampleRole2,BUSR2,Example role #2
63 +
64 +UPDATE,BatchUploadSampleSupervisor,BUSPV,Example role #3
65 +{{/code}}
66 +
67 +
68 +==== (% style="font-size: 14px;" %)**Role Permission**(%%) ====
69 +
70 +**Description**: assign permissions to Roles.
71 +
72 +**Same as**: Roles... admin screen ~-~-> Assigned Permissions tab.
73 +
74 +**Prerequisite**: ROLE
75 +
76 +**Batch File Fields**:
77 +
78 +
79 +* (% style="font-size: 14px;" %)operation
80 +* (% style="font-size: 14px;" %)ROLE.code
81 +* [[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
82 +
83 +[[Sample File>>attach:Role Permission - Batch File Example-1348454930.html]]
84 +
85 +{{code}}
86 +operation,role.code,permission.name
87 +UPDATE,BUSR1,CANS_CREATE
88 +UPDATE,BUSR1,CANS_EDIT
89 +UPDATE,BUSR1,CANS_VIEW
90 +UPDATE,BUSR1,CLIENTS_VIEW
91 +UPDATE,BUSR1,OU_VIEW
92 +UPDATE,BUSR1,REPORTS_VIEW
93 +UPDATE,BUSPV,CANS_APPROVE
94 +UPDATE,BUSPV,CANS_AUTO_APPROVE
95 +UPDATE,BUSPV,CANS_CREATE
96 +UPDATE,BUSPV,CANS_EDIT
97 +UPDATE,BUSPV,CANS_VIEW
98 +UPDATE,BUSPV,CLIENTS_CREATE
99 +UPDATE,BUSPV,CLIENTS_DELETE
100 +UPDATE,BUSPV,CLIENTS_EDIT
101 +UPDATE,BUSPV,CLIENTS_OU_VIEW
102 +UPDATE,BUSPV,CLIENTS_TAG_VIEW
103 +UPDATE,BUSPV,CLIENTS_VIEW
104 +UPDATE,BUSPV,REPORTS_VIEW
105 +UPDATE,BUSR2,ANSA_CREATE
106 +UPDATE,BUSR2,ANSA_EDIT
107 +UPDATE,BUSR2,ANSA_VIEW
108 +UPDATE,BUSR2,CLIENTS_VIEW
109 +UPDATE,BUSR2,OU_VIEW
110 +UPDATE,BUSR2,REPORTS_VIEW
111 +{{/code}}
112 +
113 +
114 +
115 +**Client** ([[Example>>url:file:///Client+-+Batch+File+Example]])
116 +
117 +Description: define basic client information.
118 +
119 +Same as Clients... admin screen ~-~-> Basic Information tab.
120 +
121 +Notes: The "active" field is a Boolean.
122 +
123 +Prerequisite: None
124 +
125 +Batch File Fields:
126 +
127 +operation
128 +
129 +firstName
130 +
131 +lastName
132 +
133 +identifier
134 +
135 +active
136 +
137 +gender
138 +
139 +dob
140 +
141 +payerID
142 +
143 +providerID
144 +
145 +memberID
146 +
147 +Sample file
148 +
149 +{{code}}
150 +operation, firstName, lastName, identifier, active, gender, dob, payerID, providerID, memberID
151 +UPDATE,Test,Client1,TC1,TRUE,MALE,1995/01/12,3PPID01, ProvID1, Mem117
152 +UPDATE,Test,Client2,TC2,TRUE,FEMALE,1995/06/18,3PPID11, ProvID2, Mem121
153 +UPDATE,Test,Client3,TC3,TRUE,MALE,1995/07/23,3PPID01, ProvID3, Mem233
154 +UPDATE,Test,Client4,TC4,TRUE,FEMALE,1996/02/19,3PPID38, ProvID1, Mem257
155 +UPDATE,Test,Client5,TC5,TRUE,MALE,1996/06/25,3PPID432, ProvID2, Mem301
156 +UPDATE,Test,Client6,TC6,TRUE,FEMALE,1996/08/25,3PPID010, ProvID3, Mem443
157 +UPDATE,Test,Client7,TC7,TRUE,MALE,1996/12/02,01010101, ProvID1, Mem43
158 +UPDATE,Test,Client8,TC8,TRUE,FEMALE,1997/01/27,3PPID01, ProvID2, Mem228
159 +UPDATE,Test,Client9,TC9,TRUE,MALE,1997/01/31~,~, ProvID3, Mem73
160 +UPDATE,Test,Client10,TC10,TRUE,FEMALE,1997/08/01,3PPID01~,~, Mem11
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}}
164 +
165 +
166 +
167 +**Client Placement** ([[Example>>url:file:///Client+Placement+-+Batch+File+Example]])
168 +
169 +Description: define client placements at org units.
170 +
171 +Same as Clients... admin screen ~-~-> Organizational Placements tab.
172 +
173 +Prerequisite: CLIENT, Organizational Units
174 +
175 +[[See the OU structure used for this sample>>url:file:///Sample-OU-structure]]
176 +
177 +Batch File Fields:
178 +
179 +operation
180 +
181 +CLIENT.identifier
182 +
183 +ORGUNIT.code
184 +
185 +Sample file
186 +
187 +{{code}}
188 +operation, client.identifier, orgUnit.code
189 +UPDATE, 1234, OU-1
190 +UPDATE, 1235, OU-1
191 +UPDATE, 1251, OU-1
192 +UPDATE, 1252, OU-1
193 +UPDATE, 1253, OU-1
194 +UPDATE, 1254, OU-1
195 +UPDATE, 1255, OU-2
196 +UPDATE, 1256, OU-2
197 +UPDATE, 1257, OU-2
198 +UPDATE, 1258, OU-2
199 +UPDATE, 1259, OU-2
200 +UPDATE, 1260, OU-2
201 +UPDATE, 1261, OU-2
202 +{{/code}}
203 +
204 +
205 +
206 +**Client Tag** ([[Example>>url:file:///Client+Tag+-+Batch+File+Example]])
207 +
208 +Description: assign taxonomy tags to client
209 +
210 +Same as Clients... admin screen ~-~-> Tags tab.
211 +
212 +Prerequisites: CLIENT, TAG
213 +
214 +[[See the sample set of Tags used for this example.>>url:file:///Sample-set-of-Tags]]
215 +
216 +Batch File Fields:
217 +
218 +operation
219 +
220 +CLIENT.identifier
221 +
222 +TAG.code
223 +
224 +Sample file
225 +
226 +{{code}}
227 +operation,client.identifier,tag.code
228 +UPDATE,TC1,TT1
229 +UPDATE,TC1,TT1.1
230 +UPDATE,TC1,TT1.2
231 +UPDATE,TC1,TT2
232 +UPDATE,TC1,TT3
233 +UPDATE,TC1,TT3.1
234 +UPDATE,TC1,TT3.2
235 +UPDATE,TC1,TT1
236 +UPDATE,TC1,TT1.1
237 +UPDATE,TC1,TT1.2
238 +UPDATE,TC2,TT2
239 +UPDATE,TC3,TT3
240 +UPDATE,TC4,TT2
241 +UPDATE,TC5,TT3
242 +UPDATE,TC6,TT3.1
243 +UPDATE,TC7,TT3.2
244 +UPDATE,TC8,TT1
245 +UPDATE,TC9,TT1.1
246 +UPDATE,TC10,TT1.2
247 +UPDATE,TC11,TT2
248 +UPDATE,TC12,TT3
249 +{{/code}}
250 +
251 +
252 +**Caregiver** ([[Example>>url:file:///Caregiver+-+Batch+File+Example]])
253 +
254 +Description: define/assign caregivers for clients.
255 +
256 +Same as CANS Assessment ~-~-> Client details ~-~-> caregivers tab.
257 +
258 +Prerequisites: CLIENT
259 +
260 +Batch File Fields:
261 +
262 +operation
263 +
264 +CLIENT.identifier
265 +
266 +[[relationshipToClient>>url:file:///Caregiver-RelationshipToClient]]
267 +
268 +firstName
269 +
270 +lastName
271 +
272 +Sample file
273 +
274 +{{code}}
275 +operation,client.identifier,relationshipToClient,firstName,lastName
276 +UPDATE,TC2,Adoptive Father,Adopt,Father
277 +UPDATE,TC2,Adoptive Mother,Adopt,Mother
278 +UPDATE,TC2,Godparent,Greg,Smith
279 +UPDATE,TC2,Godparent,Gina,Smith
280 +UPDATE,TC2,Biological Father,Bio,Father
281 +UPDATE,TC2,Biological Mother,Bio,Mother
282 +{{/code}}
283 +
284 +
285 +**Staff** ([[Example>>url:file:///Staff+Member+-+Batch+File+Example]])
286 +
287 +Description: define staff members/users of the system.
288 +
289 +Same as Staff... admin screen.
290 +
291 +Prerequisites: valid email address
292 +
293 +Notes: The password is set to the **lastName**.
294 +
295 +The "active" field is a Boolean - TRUE or FALSE
296 +
297 +Batch File Fields:
298 +
299 +operation
300 +
301 +firstName
302 +
303 +lastName
304 +
305 +login
306 +
307 +email
308 +
309 +active
310 +
311 +Sample file
312 +
313 +{{code}}
314 +operation,firstName,lastName,middleName,login,email,active
315 +UPDATE,Test,Staff1,teststaff1,test1@test.com,TRUE
316 +UPDATE,Test,Staff2,teststaff2,test2@test.com,TRUE
317 +UPDATE,Test,Staff3,teststaff3,test3@test.com,TRUE
318 +UPDATE,Test,Staff4,teststaff4,test4@test.com,TRUE
319 +UPDATE,Test,Staff5,teststaff5,test5@test.com,TRUE
320 +UPDATE,Test,Staff6,teststaff6,test6@test.com,TRUE
321 +{{/code}}
322 +
323 +
324 +**Staff Role** ([[Example>>url:file:///Staff+Member+Role+-+Batch+File+Upload]])
325 +
326 +Description: assign roles to staff members
327 +
328 +Same as Staff... admin screen ~-~-> Assigned Roles tab.
329 +
330 +Prerequisites: STAFF, ROLE
331 +
332 +Notes: The "active" field is a Boolean.
333 +
334 +Batch File Fields:
335 +
336 +operation
337 +
338 +STAFF.login
339 +
340 +ROLE.code
341 +
342 +active
343 +
344 +Sample file
345 +
346 +{{code}}
347 +operation,user.login,role.code,active
348 +UPDATE,teststaff1,BUSR1,TRUE
349 +UPDATE,teststaff2,BUSR1,TRUE
350 +UPDATE,teststaff3,BUSR1,TRUE
351 +UPDATE,teststaff4,BUSR1,TRUE
352 +UPDATE,teststaff5,BUSR1,TRUE
353 +UPDATE,teststaff6,BUSPV,TRUE
354 +{{/code}}
355 +
356 +
357 +**Staff Placement** ([[Example>>url:file:///Staff+Member+Placement+-+Batch+File+Upload]])
358 +
359 +Description: define staff member placements at org units.
360 +
361 +Same as Staff... admin screen ~-~-> Placement tab
362 +
363 +Prerequisites: STAFF, ORGUNIT
364 +
365 +[[See the OU structure used for this sample>>url:file:///Sample-OU-structure]]
366 +
367 +Batch File Fields:
368 +
369 +operation
370 +
371 +STAFF.login
372 +
373 +ORGUNIT.code
374 +
375 +Sample file
376 +
377 +{{code}}
378 +operation,user.login,orgUnit.code
379 +UPDATE,teststaff1,SC.B1
380 +UPDATE,teststaff2,SC.B2
381 +UPDATE,teststaff3,SC.B1
382 +UPDATE,teststaff4,SC.B2
383 +UPDATE,teststaff5,R1W
384 +UPDATE,teststaff6,R1E
385 +{{/code}}
386 +
387 +
388 +**Staff Responsibility** ([[Example>>url:file:///Staff+Member+Responsibility+-+Batch+Upload+Example]])
389 +
390 +Description: assign staff member responsibility for other staff members.
391 +
392 +Same as Responsibilities... ~-~-> Staff tab
393 +
394 +Prerequisites: STAFF, ROLE
395 +
396 +Batch File Fields:
397 +
398 +operation
399 +
400 +parentUserRole.STAFF.login
401 +
402 +parentUserRole.ROLE.code
403 +
404 +childUserRole.STAFF.login
405 +
406 +childUserRole.ROLE.code
407 +
408 +Sample file
409 +
410 +{{code}}
411 +operation,parentUserRole.user.login,parentUserRole.role.code,childUserRole.user.login,childUserRole.role.code
412 +UPDATE,teststaff6,BUSPV,teststaff1,BUSR1
413 +UPDATE,teststaff6,BUSPV,teststaff2,BUSR1
414 +UPDATE,teststaff6,BUSPV,teststaff3,BUSR1
415 +UPDATE,teststaff6,BUSPV,teststaff4,BUSR1
416 +UPDATE,teststaff6,BUSPV,teststaff5,BUSR1
417 +{{/code}}
418 +
419 +
420 +**Organizational Unit Responsibility** ([[Example>>url:file:///Organizational+Unit+Responsibility+-+Batch+File+Example]])
421 +
422 +Description: assign staff member direct responsibility for org units.
423 +
424 +Same as Responsibilities... ~-~-> OU tab
425 +
426 +Prerequisites: STAFF, ROLE, ORGUNIT
427 +
428 +Batch File Fields:
429 +
430 +operation
431 +
432 +userRole.STAFF.login
433 +
434 +userRole.ROLE.code
435 +
436 +ORGUNIT.code
437 +
438 +Sample file
439 +
440 +{{code}}
441 +operation,userRole.user.login,userRole.role.code,orgUnit.code
442 +UPDATE,teststaff6,BUSPV,SC
443 +UPDATE,teststaff6,BUSPV,NC
444 +UPDATE,teststaff6,BUSPV,R1
445 +UPDATE,teststaff6,BUSPV,R2
446 +{{/code}}
447 +
448 +**Staff - Client Assignment** ([[Example>>url:file:///Client+Responsibility+-+Batch+File+Example]])
449 +
450 +Description: assign staff member direct responsibility for clients.
451 +
452 +Same as Responsibilities... ~-~-> Clients tab.
453 +
454 +Prerequisites: STAFF, ROLE, CLIENT
455 +
456 +Batch File Fields:
457 +
458 +operation
459 +
460 +userRole.STAFF.login
461 +
462 +userRole.ROLE.code
463 +
464 +CLIENT.identifier
465 +
466 +Sample file
467 +
468 +{{code}}
469 +operation,userRole.user.login,userRole.role.code,client.identifier
470 +UPDATE,teststaff1,BUSR1,TC1
471 +UPDATE,teststaff1,BUSR1,TC2
472 +UPDATE,teststaff1,BUSR1,TC3
473 +UPDATE,teststaff1,BUSR1,TC4
474 +UPDATE,teststaff1,BUSR1,TC5
475 +UPDATE,teststaff1,BUSR1,TC6
476 +UPDATE,teststaff1,BUSR1,TC7
477 +UPDATE,teststaff1,BUSR1,TC8
478 +UPDATE,teststaff1,BUSR1,TC9
479 +UPDATE,teststaff1,BUSR1,TC10
480 +UPDATE,teststaff1,BUSR1,TC11
481 +UPDATE,teststaff1,BUSR1,TC12
482 +{{/code}}
Icon Client - Batch File Example.csv
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.dbonicelli
Size
... ... @@ -1,0 +1,1 @@
1 +6.3 KB
Content
... ... @@ -1,0 +1,247 @@
1 +<table style="border-collapse:collapse;" border="0" cellspacing="0" cellpadding="0" width="525"><tbody><tr><td width="75" height="13">operation</td>
2 +<td width="75">firstName</td>
3 +<td width="75">lastName</td>
4 +<td width="75">login</td>
5 +<td width="75">email</td>
6 +<td width="75">active</td>
7 +</tr><tr><td height="13">UPDATE</td>
8 +<td>Robert</td>
9 +<td>Smith</td>
10 +<td>robert.smith</td>
11 +<td>robert.smith@oademo.com</td>
12 +<td align="center">TRUE</td>
13 +</tr><tr><td height="13">UPDATE</td>
14 +<td>James</td>
15 +<td>Johnson</td>
16 +<td>james.johnson</td>
17 +<td>james.johnson@oademo.com</td>
18 +<td align="center">TRUE</td>
19 +</tr><tr><td height="13">UPDATE</td>
20 +<td>John</td>
21 +<td>Williams</td>
22 +<td>john.williams</td>
23 +<td>john.williams@oademo.com</td>
24 +<td align="center">TRUE</td>
25 +</tr><tr><td height="13">UPDATE</td>
26 +<td>William</td>
27 +<td>Jones</td>
28 +<td>william.jones</td>
29 +<td>william.jones@oademo.com</td>
30 +<td align="center">TRUE</td>
31 +</tr><tr><td height="13">UPDATE</td>
32 +<td>Richard</td>
33 +<td>Brown</td>
34 +<td>richard.brown</td>
35 +<td>richard.brown@oademo.com</td>
36 +<td align="center">TRUE</td>
37 +</tr><tr><td height="13">UPDATE</td>
38 +<td>Charles</td>
39 +<td>Davis</td>
40 +<td>charles.davis</td>
41 +<td>charles.davis@oademo.com</td>
42 +<td align="center">TRUE</td>
43 +</tr><tr><td height="13">UPDATE</td>
44 +<td>Donald</td>
45 +<td>Miller</td>
46 +<td>donald.miller</td>
47 +<td>donald.miller@oademo.com</td>
48 +<td align="center">TRUE</td>
49 +</tr><tr><td height="13">UPDATE</td>
50 +<td>George</td>
51 +<td>Wilson</td>
52 +<td>george.wilson</td>
53 +<td>george.wilson@oademo.com</td>
54 +<td align="center">TRUE</td>
55 +</tr><tr><td height="13">UPDATE</td>
56 +<td>Thomas</td>
57 +<td>Moore</td>
58 +<td>thomas.moore</td>
59 +<td>thomas.moore@oademo.com</td>
60 +<td align="center">FALSE</td>
61 +</tr><tr><td height="13">UPDATE</td>
62 +<td>Joseph</td>
63 +<td>Taylor</td>
64 +<td>joseph.taylor</td>
65 +<td>joseph.taylor@oademo.com</td>
66 +<td align="center">TRUE</td>
67 +</tr><tr><td height="13">UPDATE</td>
68 +<td>David</td>
69 +<td>Anderson</td>
70 +<td>david.anderson</td>
71 +<td>david.anderson@oademo.com</td>
72 +<td align="center">TRUE</td>
73 +</tr><tr><td height="13">UPDATE</td>
74 +<td>Ronald</td>
75 +<td>Thomas</td>
76 +<td>ronald.thomas</td>
77 +<td>ronald.thomas@oademo.com</td>
78 +<td align="center">TRUE</td>
79 +</tr><tr><td height="13">UPDATE</td>
80 +<td>Edward</td>
81 +<td>Jackson</td>
82 +<td>edward.jackson</td>
83 +<td>edward.jackson@oademo.com</td>
84 +<td align="center">TRUE</td>
85 +</tr><tr><td height="13">UPDATE</td>
86 +<td>Paul</td>
87 +<td>White</td>
88 +<td>paul.white</td>
89 +<td>paul.white@oademo.com</td>
90 +<td align="center">TRUE</td>
91 +</tr><tr><td height="13">UPDATE</td>
92 +<td>Kenneth</td>
93 +<td>Harris</td>
94 +<td>kenneth.harris</td>
95 +<td>kenneth.harris@oademo.com</td>
96 +<td align="center">TRUE</td>
97 +</tr><tr><td height="13">UPDATE</td>
98 +<td>Frank</td>
99 +<td>Martin</td>
100 +<td>frank.martin</td>
101 +<td>frank.martin@oademo.com</td>
102 +<td align="center">TRUE</td>
103 +</tr><tr><td height="13">UPDATE</td>
104 +<td>Raymond</td>
105 +<td>Thompson</td>
106 +<td>raymond.thompson</td>
107 +<td>raymond.thompson@oademo.com</td>
108 +<td align="center">TRUE</td>
109 +</tr><tr><td height="13">UPDATE</td>
110 +<td>Jack</td>
111 +<td>Garcia</td>
112 +<td>jack.garcia</td>
113 +<td>jack.garcia@oademo.com</td>
114 +<td align="center">TRUE</td>
115 +</tr><tr><td height="13">UPDATE</td>
116 +<td>Billy</td>
117 +<td>Martinez</td>
118 +<td>billy.martinez</td>
119 +<td>billy.martinez@oademo.com</td>
120 +<td align="center">TRUE</td>
121 +</tr><tr><td height="13">UPDATE</td>
122 +<td>Harold</td>
123 +<td>Robinson</td>
124 +<td>harold.robinson</td>
125 +<td>harold.robinson@oademo.com</td>
126 +<td align="center">TRUE</td>
127 +</tr><tr><td height="13">UPDATE</td>
128 +<td>Mary</td>
129 +<td>Clark</td>
130 +<td>mary.clark</td>
131 +<td>mary.clark@oademo.com</td>
132 +<td align="center">TRUE</td>
133 +</tr><tr><td height="13">UPDATE</td>
134 +<td>Shirley</td>
135 +<td>Rodriguez</td>
136 +<td>shirley.rodriguez</td>
137 +<td>shirley.rodriguez@oademo.com</td>
138 +<td align="center">TRUE</td>
139 +</tr><tr><td height="13">UPDATE</td>
140 +<td>Barbara</td>
141 +<td>Lewis</td>
142 +<td>barbara.lewis</td>
143 +<td>barbara.lewis@oademo.com</td>
144 +<td align="center">TRUE</td>
145 +</tr><tr><td height="13">UPDATE</td>
146 +<td>Betty</td>
147 +<td>Lee</td>
148 +<td>betty.lee</td>
149 +<td>betty.lee@oademo.com</td>
150 +<td align="center">TRUE</td>
151 +</tr><tr><td height="13">UPDATE</td>
152 +<td>Patricia</td>
153 +<td>Walker</td>
154 +<td>partricia.walker</td>
155 +<td>partricia.walker@oademo.com</td>
156 +<td align="center">TRUE</td>
157 +</tr><tr><td height="13">UPDATE</td>
158 +<td>Dorothy</td>
159 +<td>Hall</td>
160 +<td>dorothy.hall</td>
161 +<td>dorothy.hall@oademo.com</td>
162 +<td align="center">TRUE</td>
163 +</tr><tr><td height="13">UPDATE</td>
164 +<td>Joan</td>
165 +<td>Allen</td>
166 +<td>joan.allen</td>
167 +<td>joan.allen@oademo.com</td>
168 +<td align="center">TRUE</td>
169 +</tr><tr><td height="13">UPDATE</td>
170 +<td>Margaret</td>
171 +<td>Young</td>
172 +<td>margaret.young</td>
173 +<td>margaret.young@oademo.com</td>
174 +<td align="center">TRUE</td>
175 +</tr><tr><td height="13">UPDATE</td>
176 +<td>Nancy</td>
177 +<td>Hernandez</td>
178 +<td>nancy.hernandez</td>
179 +<td>nancy.hernandez@oademo.com</td>
180 +<td align="center">TRUE</td>
181 +</tr><tr><td height="13">UPDATE</td>
182 +<td>Helen</td>
183 +<td>King</td>
184 +<td>helen.king</td>
185 +<td>helen.king@oademo.com</td>
186 +<td align="center">FALSE</td>
187 +</tr><tr><td height="13">UPDATE</td>
188 +<td>Carol</td>
189 +<td>Wright</td>
190 +<td>carol.wright</td>
191 +<td>carol.wright@oademo.com</td>
192 +<td align="center">TRUE</td>
193 +</tr><tr><td height="13">UPDATE</td>
194 +<td>Joyce</td>
195 +<td>Lopez</td>
196 +<td>joyce.lopez</td>
197 +<td>joyce.lopez@oademo.com</td>
198 +<td align="center">TRUE</td>
199 +</tr><tr><td height="13">UPDATE</td>
200 +<td>Doris</td>
201 +<td>Hill</td>
202 +<td>doris.hill</td>
203 +<td>doris.hill@oademo.com</td>
204 +<td align="center">TRUE</td>
205 +</tr><tr><td height="13">UPDATE</td>
206 +<td>Marilyn</td>
207 +<td>Scott</td>
208 +<td>marilyn.scott</td>
209 +<td>marilyn.scott@oademo.com</td>
210 +<td align="center">TRUE</td>
211 +</tr><tr><td height="13">UPDATE</td>
212 +<td>Ruth</td>
213 +<td>Green</td>
214 +<td>ruth.green</td>
215 +<td>ruth.green@oademo.com</td>
216 +<td align="center">TRUE</td>
217 +</tr><tr><td height="13">UPDATE</td>
218 +<td>Virginia</td>
219 +<td>Adams</td>
220 +<td>virginia.adams</td>
221 +<td>virginia.adams@oademo.com</td>
222 +<td align="center">TRUE</td>
223 +</tr><tr><td height="13">UPDATE</td>
224 +<td>Elizabeth</td>
225 +<td>Baker</td>
226 +<td>elizabeth.baker</td>
227 +<td>elizabeth.baker@oademo.com</td>
228 +<td align="center">TRUE</td>
229 +</tr><tr><td height="13">UPDATE</td>
230 +<td>Jean</td>
231 +<td>Gonzalez</td>
232 +<td>jean.gonzalez</td>
233 +<td>jean.gonzalez@oademo.com</td>
234 +<td align="center">TRUE</td>
235 +</tr><tr><td height="13">UPDATE</td>
236 +<td>Frances</td>
237 +<td>Nelson</td>
238 +<td>frances.nelson</td>
239 +<td>frances.nelson@oademo.com</td>
240 +<td align="center">TRUE</td>
241 +</tr><tr><td height="13">UPDATE</td>
242 +<td>Beverly</td>
243 +<td>Carter</td>
244 +<td>beverly.carter</td>
245 +<td>beverly.carter@oademo.com</td>
246 +<td align="center">TRUE</td>
247 +</tr></tbody></table><p>&nbsp;</p>
Icon Role - Batch File Example.csv
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.dbonicelli
Size
... ... @@ -1,0 +1,1 @@
1 +6.3 KB
Content
... ... @@ -1,0 +1,247 @@
1 +<table style="border-collapse:collapse;" border="0" cellspacing="0" cellpadding="0" width="525"><tbody><tr><td width="75" height="13">operation</td>
2 +<td width="75">firstName</td>
3 +<td width="75">lastName</td>
4 +<td width="75">login</td>
5 +<td width="75">email</td>
6 +<td width="75">active</td>
7 +</tr><tr><td height="13">UPDATE</td>
8 +<td>Robert</td>
9 +<td>Smith</td>
10 +<td>robert.smith</td>
11 +<td>robert.smith@oademo.com</td>
12 +<td align="center">TRUE</td>
13 +</tr><tr><td height="13">UPDATE</td>
14 +<td>James</td>
15 +<td>Johnson</td>
16 +<td>james.johnson</td>
17 +<td>james.johnson@oademo.com</td>
18 +<td align="center">TRUE</td>
19 +</tr><tr><td height="13">UPDATE</td>
20 +<td>John</td>
21 +<td>Williams</td>
22 +<td>john.williams</td>
23 +<td>john.williams@oademo.com</td>
24 +<td align="center">TRUE</td>
25 +</tr><tr><td height="13">UPDATE</td>
26 +<td>William</td>
27 +<td>Jones</td>
28 +<td>william.jones</td>
29 +<td>william.jones@oademo.com</td>
30 +<td align="center">TRUE</td>
31 +</tr><tr><td height="13">UPDATE</td>
32 +<td>Richard</td>
33 +<td>Brown</td>
34 +<td>richard.brown</td>
35 +<td>richard.brown@oademo.com</td>
36 +<td align="center">TRUE</td>
37 +</tr><tr><td height="13">UPDATE</td>
38 +<td>Charles</td>
39 +<td>Davis</td>
40 +<td>charles.davis</td>
41 +<td>charles.davis@oademo.com</td>
42 +<td align="center">TRUE</td>
43 +</tr><tr><td height="13">UPDATE</td>
44 +<td>Donald</td>
45 +<td>Miller</td>
46 +<td>donald.miller</td>
47 +<td>donald.miller@oademo.com</td>
48 +<td align="center">TRUE</td>
49 +</tr><tr><td height="13">UPDATE</td>
50 +<td>George</td>
51 +<td>Wilson</td>
52 +<td>george.wilson</td>
53 +<td>george.wilson@oademo.com</td>
54 +<td align="center">TRUE</td>
55 +</tr><tr><td height="13">UPDATE</td>
56 +<td>Thomas</td>
57 +<td>Moore</td>
58 +<td>thomas.moore</td>
59 +<td>thomas.moore@oademo.com</td>
60 +<td align="center">FALSE</td>
61 +</tr><tr><td height="13">UPDATE</td>
62 +<td>Joseph</td>
63 +<td>Taylor</td>
64 +<td>joseph.taylor</td>
65 +<td>joseph.taylor@oademo.com</td>
66 +<td align="center">TRUE</td>
67 +</tr><tr><td height="13">UPDATE</td>
68 +<td>David</td>
69 +<td>Anderson</td>
70 +<td>david.anderson</td>
71 +<td>david.anderson@oademo.com</td>
72 +<td align="center">TRUE</td>
73 +</tr><tr><td height="13">UPDATE</td>
74 +<td>Ronald</td>
75 +<td>Thomas</td>
76 +<td>ronald.thomas</td>
77 +<td>ronald.thomas@oademo.com</td>
78 +<td align="center">TRUE</td>
79 +</tr><tr><td height="13">UPDATE</td>
80 +<td>Edward</td>
81 +<td>Jackson</td>
82 +<td>edward.jackson</td>
83 +<td>edward.jackson@oademo.com</td>
84 +<td align="center">TRUE</td>
85 +</tr><tr><td height="13">UPDATE</td>
86 +<td>Paul</td>
87 +<td>White</td>
88 +<td>paul.white</td>
89 +<td>paul.white@oademo.com</td>
90 +<td align="center">TRUE</td>
91 +</tr><tr><td height="13">UPDATE</td>
92 +<td>Kenneth</td>
93 +<td>Harris</td>
94 +<td>kenneth.harris</td>
95 +<td>kenneth.harris@oademo.com</td>
96 +<td align="center">TRUE</td>
97 +</tr><tr><td height="13">UPDATE</td>
98 +<td>Frank</td>
99 +<td>Martin</td>
100 +<td>frank.martin</td>
101 +<td>frank.martin@oademo.com</td>
102 +<td align="center">TRUE</td>
103 +</tr><tr><td height="13">UPDATE</td>
104 +<td>Raymond</td>
105 +<td>Thompson</td>
106 +<td>raymond.thompson</td>
107 +<td>raymond.thompson@oademo.com</td>
108 +<td align="center">TRUE</td>
109 +</tr><tr><td height="13">UPDATE</td>
110 +<td>Jack</td>
111 +<td>Garcia</td>
112 +<td>jack.garcia</td>
113 +<td>jack.garcia@oademo.com</td>
114 +<td align="center">TRUE</td>
115 +</tr><tr><td height="13">UPDATE</td>
116 +<td>Billy</td>
117 +<td>Martinez</td>
118 +<td>billy.martinez</td>
119 +<td>billy.martinez@oademo.com</td>
120 +<td align="center">TRUE</td>
121 +</tr><tr><td height="13">UPDATE</td>
122 +<td>Harold</td>
123 +<td>Robinson</td>
124 +<td>harold.robinson</td>
125 +<td>harold.robinson@oademo.com</td>
126 +<td align="center">TRUE</td>
127 +</tr><tr><td height="13">UPDATE</td>
128 +<td>Mary</td>
129 +<td>Clark</td>
130 +<td>mary.clark</td>
131 +<td>mary.clark@oademo.com</td>
132 +<td align="center">TRUE</td>
133 +</tr><tr><td height="13">UPDATE</td>
134 +<td>Shirley</td>
135 +<td>Rodriguez</td>
136 +<td>shirley.rodriguez</td>
137 +<td>shirley.rodriguez@oademo.com</td>
138 +<td align="center">TRUE</td>
139 +</tr><tr><td height="13">UPDATE</td>
140 +<td>Barbara</td>
141 +<td>Lewis</td>
142 +<td>barbara.lewis</td>
143 +<td>barbara.lewis@oademo.com</td>
144 +<td align="center">TRUE</td>
145 +</tr><tr><td height="13">UPDATE</td>
146 +<td>Betty</td>
147 +<td>Lee</td>
148 +<td>betty.lee</td>
149 +<td>betty.lee@oademo.com</td>
150 +<td align="center">TRUE</td>
151 +</tr><tr><td height="13">UPDATE</td>
152 +<td>Patricia</td>
153 +<td>Walker</td>
154 +<td>partricia.walker</td>
155 +<td>partricia.walker@oademo.com</td>
156 +<td align="center">TRUE</td>
157 +</tr><tr><td height="13">UPDATE</td>
158 +<td>Dorothy</td>
159 +<td>Hall</td>
160 +<td>dorothy.hall</td>
161 +<td>dorothy.hall@oademo.com</td>
162 +<td align="center">TRUE</td>
163 +</tr><tr><td height="13">UPDATE</td>
164 +<td>Joan</td>
165 +<td>Allen</td>
166 +<td>joan.allen</td>
167 +<td>joan.allen@oademo.com</td>
168 +<td align="center">TRUE</td>
169 +</tr><tr><td height="13">UPDATE</td>
170 +<td>Margaret</td>
171 +<td>Young</td>
172 +<td>margaret.young</td>
173 +<td>margaret.young@oademo.com</td>
174 +<td align="center">TRUE</td>
175 +</tr><tr><td height="13">UPDATE</td>
176 +<td>Nancy</td>
177 +<td>Hernandez</td>
178 +<td>nancy.hernandez</td>
179 +<td>nancy.hernandez@oademo.com</td>
180 +<td align="center">TRUE</td>
181 +</tr><tr><td height="13">UPDATE</td>
182 +<td>Helen</td>
183 +<td>King</td>
184 +<td>helen.king</td>
185 +<td>helen.king@oademo.com</td>
186 +<td align="center">FALSE</td>
187 +</tr><tr><td height="13">UPDATE</td>
188 +<td>Carol</td>
189 +<td>Wright</td>
190 +<td>carol.wright</td>
191 +<td>carol.wright@oademo.com</td>
192 +<td align="center">TRUE</td>
193 +</tr><tr><td height="13">UPDATE</td>
194 +<td>Joyce</td>
195 +<td>Lopez</td>
196 +<td>joyce.lopez</td>
197 +<td>joyce.lopez@oademo.com</td>
198 +<td align="center">TRUE</td>
199 +</tr><tr><td height="13">UPDATE</td>
200 +<td>Doris</td>
201 +<td>Hill</td>
202 +<td>doris.hill</td>
203 +<td>doris.hill@oademo.com</td>
204 +<td align="center">TRUE</td>
205 +</tr><tr><td height="13">UPDATE</td>
206 +<td>Marilyn</td>
207 +<td>Scott</td>
208 +<td>marilyn.scott</td>
209 +<td>marilyn.scott@oademo.com</td>
210 +<td align="center">TRUE</td>
211 +</tr><tr><td height="13">UPDATE</td>
212 +<td>Ruth</td>
213 +<td>Green</td>
214 +<td>ruth.green</td>
215 +<td>ruth.green@oademo.com</td>
216 +<td align="center">TRUE</td>
217 +</tr><tr><td height="13">UPDATE</td>
218 +<td>Virginia</td>
219 +<td>Adams</td>
220 +<td>virginia.adams</td>
221 +<td>virginia.adams@oademo.com</td>
222 +<td align="center">TRUE</td>
223 +</tr><tr><td height="13">UPDATE</td>
224 +<td>Elizabeth</td>
225 +<td>Baker</td>
226 +<td>elizabeth.baker</td>
227 +<td>elizabeth.baker@oademo.com</td>
228 +<td align="center">TRUE</td>
229 +</tr><tr><td height="13">UPDATE</td>
230 +<td>Jean</td>
231 +<td>Gonzalez</td>
232 +<td>jean.gonzalez</td>
233 +<td>jean.gonzalez@oademo.com</td>
234 +<td align="center">TRUE</td>
235 +</tr><tr><td height="13">UPDATE</td>
236 +<td>Frances</td>
237 +<td>Nelson</td>
238 +<td>frances.nelson</td>
239 +<td>frances.nelson@oademo.com</td>
240 +<td align="center">TRUE</td>
241 +</tr><tr><td height="13">UPDATE</td>
242 +<td>Beverly</td>
243 +<td>Carter</td>
244 +<td>beverly.carter</td>
245 +<td>beverly.carter@oademo.com</td>
246 +<td align="center">TRUE</td>
247 +</tr></tbody></table><p>&nbsp;</p>
Icon Role Permission - Batch File Example.csv
Author
... ... @@ -1,0 +1,1 @@
1 +XWiki.dbonicelli
Size
... ... @@ -1,0 +1,1 @@
1 +2.3 KB
Content
... ... @@ -1,0 +1,159 @@
1 +<table width="200" cellspacing="1" cellpadding="1" class="pbNotSortable">
2 +<tbody>
3 +<tr>
4 +<td>
5 +<table width="225" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse;">
6 +
7 +<tbody>
8 +<tr>
9 +<td width="75" height="13">operation</td>
10 +<td width="75">role.code</td>
11 +<td width="75">permission.name</td>
12 +</tr>
13 +<tr>
14 +<td height="13">UPDATE</td>
15 +<td>cw</td>
16 +<td>CANS_CREATE</td>
17 +</tr>
18 +<tr>
19 +<td height="13">UPDATE</td>
20 +<td>cw</td>
21 +<td>CANS_EDIT</td>
22 +</tr>
23 +<tr>
24 +<td height="13">UPDATE</td>
25 +<td>cw</td>
26 +<td>CANS_VIEW</td>
27 +</tr>
28 +<tr>
29 +<td height="13">UPDATE</td>
30 +<td>cw</td>
31 +<td>CLIENTS_VIEW</td>
32 +</tr>
33 +<tr>
34 +<td height="13">UPDATE</td>
35 +<td>su</td>
36 +<td>CANS_CREATE</td>
37 +</tr>
38 +<tr>
39 +<td height="13">UPDATE</td>
40 +<td>su</td>
41 +<td>CANS_EDIT</td>
42 +</tr>
43 +<tr>
44 +<td height="13">UPDATE</td>
45 +<td>su</td>
46 +<td>CANS_VIEW</td>
47 +</tr>
48 +<tr>
49 +<td height="13">UPDATE</td>
50 +<td>su</td>
51 +<td>CLIENTS_VIEW</td>
52 +</tr>
53 +<tr>
54 +<td height="13">UPDATE</td>
55 +<td>su</td>
56 +<td>CLIENTS_CREATE</td>
57 +</tr>
58 +<tr>
59 +<td height="13">UPDATE</td>
60 +<td>su</td>
61 +<td>CLIENTS_EDIT</td>
62 +</tr>
63 +<tr>
64 +<td height="13">UPDATE</td>
65 +<td>su</td>
66 +<td>CLIENTS_DELETE</td>
67 +</tr>
68 +<tr>
69 +<td height="13">UPDATE</td>
70 +<td>su</td>
71 +<td>CLIENTS_TAG_VIEW</td>
72 +</tr>
73 +<tr>
74 +<td height="13">UPDATE</td>
75 +<td>su</td>
76 +<td>REPORTS_VIEW</td>
77 +</tr>
78 +<tr>
79 +<td height="13">UPDATE</td>
80 +<td>sm</td>
81 +<td>CANS_CREATE</td>
82 +</tr>
83 +<tr>
84 +<td height="13">UPDATE</td>
85 +<td>sm</td>
86 +<td>CANS_EDIT</td>
87 +</tr>
88 +<tr>
89 +<td height="13">UPDATE</td>
90 +<td>sm</td>
91 +<td>CANS_VIEW</td>
92 +</tr>
93 +<tr>
94 +<td height="13">UPDATE</td>
95 +<td>sm</td>
96 +<td>CLIENTS_VIEW</td>
97 +</tr>
98 +<tr>
99 +<td height="13">UPDATE</td>
100 +<td>sm</td>
101 +<td>CLIENTS_CREATE</td>
102 +</tr>
103 +<tr>
104 +<td height="13">UPDATE</td>
105 +<td>sm</td>
106 +<td>CLIENTS_EDIT</td>
107 +</tr>
108 +<tr>
109 +<td height="13">UPDATE</td>
110 +<td>sm</td>
111 +<td>CLIENTS_DELETE</td>
112 +</tr>
113 +<tr>
114 +<td height="13">UPDATE</td>
115 +<td>sm</td>
116 +<td>CLIENTS_TAG_VIEW</td>
117 +</tr>
118 +<tr>
119 +<td height="13">UPDATE</td>
120 +<td>sm</td>
121 +<td>REPORTS_VIEW</td>
122 +</tr>
123 +<tr>
124 +<td height="13">UPDATE</td>
125 +<td>sm</td>
126 +<td>STAFF_EDIT</td>
127 +</tr>
128 +<tr>
129 +<td height="13">UPDATE</td>
130 +<td>sm</td>
131 +<td>STAFF_OU_EDIT</td>
132 +</tr>
133 +<tr>
134 +<td height="13">UPDATE</td>
135 +<td>sm</td>
136 +<td>STAFF_VIEW</td>
137 +</tr>
138 +<tr>
139 +<td height="13">UPDATE</td>
140 +<td>de</td>
141 +<td>CANS_CREATE</td>
142 +</tr>
143 +<tr>
144 +<td height="13">UPDATE</td>
145 +<td>de</td>
146 +<td>CANS_EDIT</td>
147 +</tr>
148 +<tr>
149 +<td height="13">UPDATE</td>
150 +<td>de</td>
151 +<td>CANS_VIEW</td>
152 +</tr>
153 +</tbody>
154 +</table>
155 +</td>
156 +</tr>
157 +</tbody>
158 +</table>
159 +