Changes for page Batch Upload Formats

Last modified by Matthew Deceunynck on 2015/06/05 16:12

From 6.1 to 5.1

From version

5.1

edited by Davide Bonicelli
on 2015/03/25 09:37

Change comment: There is no comment for this version

To version 1.1

edited by Davide Bonicelli
on 2015/03/25 09:25

Change comment: Upload new image BatchUploadTablesAndKeys-1330540947.png

Raw
Rendered

Summary

Page properties (3 modified, 0 added, 0 removed)
Attachments (0 modified, 0 added, 2 removed)
- Role - Batch File Example-1348454930.html
- Role Permission - Batch File Example-1348454930.html

Details

Page properties

Title

...	...	@@ -1,1 +1,0 @@
1		-Batch Upload Formats

Parent

...	...	@@ -1,1 +1,0 @@
1		-Documentation.WebHome

Content

@@ -1,482 +1,0 @@
--== **Batch Data File Formats and Examples** ==
--
--* 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.
--* 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.
--* Organization Units (ORGUNIT) does not have a batch upload and must be defined through the SMR application
--* Taxonomy tags (TAG) do not have a batch upload and must be defined through the SMR application.
--* The following table briefly describes each batch file according to the aspect of the organization it contains.
--
--
--
--|**Organizational Aspect**|**Description **|**Prerequisite Item(s)**
--|**1. Role**|What are the distinct groups of users in your organization? |None
--|**2. Role Permission**|What specific permissions are allowed for each role? |Role
--|**3. Client** |Identify the clients your organization is serving |None
--|**4. Client Placement** |Where do your clients belong for in your organization structure?|Client, Org Unit
--|**5. Client Tag** |Associate clients with non-OU tags/taxonomy items |Client, Tag
--|**6. Caregiver** |Associate caregivers to specific clients |Client
--|**7. Staff **|Identify the staff members in your organization.|staff members' email addresses
--|**8. Staff Role**|What role does a specific staff member serve?|Staff, Role
--|**9. Staff  Placement**|Where do your staff belong in your organization structure?|Staff,  Org Unit
--|**10. Staff  Responsibility**|Who supervises each staff member?|Staff, Role
--|**11. Organizational Unit Responsibility**|Which organizational unit does each staff member belong to?|Staff, Role, Org Unit
--|**12. Staff-Client Assignment** |Which clients are specifically assigned to a staff member?|Staff, Role, Client
--
--* The following diagram provides a visual roadmap of the prerequisites for loading each batch file:(% style="font-family: sans-serif; font-size: 14px;" %)
--
-- [[image:BatchUploadTablesAndKeys-1330540947.png]]
--
--
--
--The sections below describe specific upload information about each organizational batch upload file:
--
--* Name of organization items and link to an example of batch upload content
--* Description
--* Upload fields
--* Sample upload file - These samples were used to successfully populate a test version of the SMR system.
--* Screenshot of the appropriate admin page after successful upload
--
--==== **Role** ====
--
--**Description**: define Roles in the system.
--
--**Same as**: Roles... admin screen.
--
--**Prerequisite**: None
--
--**Batch File Fields**:
--
--
--* (% style="font-size: 14px;" %)operation
--* (% style="font-size: 14px;" %)name
--* (% style="font-size: 14px;" %)code
--* (% style="font-size: 14px;" %)description
--
--[[(% class="wikiattachmentlink" %)**Sample file**>>attach:Role - Batch File Example-1348454930.html]]
--
--{{code}}
--operation,name,code,description
--
--UPDATE,BatchUploadSampleRole1,BUSR1,Example role #1
--
--UPDATE,BatchUploadSampleRole2,BUSR2,Example role #2
--
--UPDATE,BatchUploadSampleSupervisor,BUSPV,Example role #3
--{{/code}}
--
--
--==== (% style="font-size: 14px;" %)**Role Permission**(%%) ====
--
--**Description**: assign permissions to Roles.
--
--**Same as**: Roles... admin screen ~-~-> Assigned Permissions tab.
--
--**Prerequisite**: ROLE
--
--**Batch File Fields**:
--
--
--* (% style="font-size: 14px;" %)operation
--* (% style="font-size: 14px;" %)ROLE.code
--* [[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
--
--[[Sample File>>attach:Role Permission - Batch File Example-1348454930.html]]
--
--{{code}}
--operation,role.code,permission.name
--UPDATE,BUSR1,CANS_CREATE
--UPDATE,BUSR1,CANS_EDIT
--UPDATE,BUSR1,CANS_VIEW
--UPDATE,BUSR1,CLIENTS_VIEW
--UPDATE,BUSR1,OU_VIEW
--UPDATE,BUSR1,REPORTS_VIEW
--UPDATE,BUSPV,CANS_APPROVE
--UPDATE,BUSPV,CANS_AUTO_APPROVE
--UPDATE,BUSPV,CANS_CREATE
--UPDATE,BUSPV,CANS_EDIT
--UPDATE,BUSPV,CANS_VIEW
--UPDATE,BUSPV,CLIENTS_CREATE
--UPDATE,BUSPV,CLIENTS_DELETE
--UPDATE,BUSPV,CLIENTS_EDIT
--UPDATE,BUSPV,CLIENTS_OU_VIEW
--UPDATE,BUSPV,CLIENTS_TAG_VIEW
--UPDATE,BUSPV,CLIENTS_VIEW
--UPDATE,BUSPV,REPORTS_VIEW
--UPDATE,BUSR2,ANSA_CREATE
--UPDATE,BUSR2,ANSA_EDIT
--UPDATE,BUSR2,ANSA_VIEW
--UPDATE,BUSR2,CLIENTS_VIEW
--UPDATE,BUSR2,OU_VIEW
--UPDATE,BUSR2,REPORTS_VIEW
--{{/code}}
--
--
--
--**Client** ([[Example>>url:file:///Client+-+Batch+File+Example]])
--
--Description: define basic client information.
--
--Same as Clients... admin screen ~-~-> Basic Information tab.
--
--Notes: The "active" field is a Boolean.
--
--Prerequisite: None
--
--Batch File Fields:
--
--operation
--
--firstName
--
--lastName
--
--identifier
--
--active
--
--gender
--
--dob
--
--payerID
--
--providerID
--
--memberID
--
--Sample file
--
--{{code}}
--operation, firstName, lastName, identifier, active, gender, dob, payerID, providerID, memberID
--UPDATE,Test,Client1,TC1,TRUE,MALE,1995/01/12,3PPID01, ProvID1, Mem117
--UPDATE,Test,Client2,TC2,TRUE,FEMALE,1995/06/18,3PPID11, ProvID2, Mem121
--UPDATE,Test,Client3,TC3,TRUE,MALE,1995/07/23,3PPID01, ProvID3, Mem233
--UPDATE,Test,Client4,TC4,TRUE,FEMALE,1996/02/19,3PPID38, ProvID1, Mem257
--UPDATE,Test,Client5,TC5,TRUE,MALE,1996/06/25,3PPID432, ProvID2, Mem301
--UPDATE,Test,Client6,TC6,TRUE,FEMALE,1996/08/25,3PPID010, ProvID3, Mem443
--UPDATE,Test,Client7,TC7,TRUE,MALE,1996/12/02,01010101, ProvID1, Mem43
--UPDATE,Test,Client8,TC8,TRUE,FEMALE,1997/01/27,3PPID01, ProvID2, Mem228
--UPDATE,Test,Client9,TC9,TRUE,MALE,1997/01/31~,~, ProvID3, Mem73
--UPDATE,Test,Client10,TC10,TRUE,FEMALE,1997/08/01,3PPID01~,~, Mem11
--UPDATE,Test,Client11,TC11,TRUE,MALE,1997/12/19~,~, ProvID2, Mem127
--UPDATE,Test,Client12,TC12,TRUE,FEMALE,1998/03/27,3PPID03, ProvID1, Mem877
--{{/code}}
--
--
--
--**Client Placement** ([[Example>>url:file:///Client+Placement+-+Batch+File+Example]])
--
--Description: define client placements at org units.
--
--Same as Clients... admin screen ~-~-> Organizational Placements tab.
--
--Prerequisite: CLIENT, Organizational Units
--
--[[See the OU structure used for this sample>>url:file:///Sample-OU-structure]]
--
--Batch File Fields:
--
--operation
--
--CLIENT.identifier
--
--ORGUNIT.code
--
--Sample file
--
--{{code}}
--operation, client.identifier, orgUnit.code
--UPDATE, 1234, OU-1
--UPDATE, 1235, OU-1
--UPDATE, 1251, OU-1
--UPDATE, 1252, OU-1
--UPDATE, 1253, OU-1
--UPDATE, 1254, OU-1
--UPDATE, 1255, OU-2
--UPDATE, 1256, OU-2
--UPDATE, 1257, OU-2
--UPDATE, 1258, OU-2
--UPDATE, 1259, OU-2
--UPDATE, 1260, OU-2
--UPDATE, 1261, OU-2
--{{/code}}
--
--
--
--**Client Tag** ([[Example>>url:file:///Client+Tag+-+Batch+File+Example]])
--
--Description: assign taxonomy tags to client
--
--Same as Clients... admin screen ~-~-> Tags tab.
--
--Prerequisites: CLIENT, TAG
--
--[[See the sample set of Tags used for this example.>>url:file:///Sample-set-of-Tags]]
--
--Batch File Fields:
--
--operation
--
--CLIENT.identifier
--
--TAG.code
--
--Sample file
--
--{{code}}
--operation,client.identifier,tag.code
--UPDATE,TC1,TT1
--UPDATE,TC1,TT1.1
--UPDATE,TC1,TT1.2
--UPDATE,TC1,TT2
--UPDATE,TC1,TT3
--UPDATE,TC1,TT3.1
--UPDATE,TC1,TT3.2
--UPDATE,TC1,TT1
--UPDATE,TC1,TT1.1
--UPDATE,TC1,TT1.2
--UPDATE,TC2,TT2
--UPDATE,TC3,TT3
--UPDATE,TC4,TT2
--UPDATE,TC5,TT3
--UPDATE,TC6,TT3.1
--UPDATE,TC7,TT3.2
--UPDATE,TC8,TT1
--UPDATE,TC9,TT1.1
--UPDATE,TC10,TT1.2
--UPDATE,TC11,TT2
--UPDATE,TC12,TT3
--{{/code}}
--
--
--**Caregiver** ([[Example>>url:file:///Caregiver+-+Batch+File+Example]])
--
--Description: define/assign caregivers for clients.
--
--Same as CANS Assessment ~-~-> Client details ~-~-> caregivers tab.
--
--Prerequisites: CLIENT
--
--Batch File Fields:
--
--operation
--
--CLIENT.identifier
--
--[[relationshipToClient>>url:file:///Caregiver-RelationshipToClient]]
--
--firstName
--
--lastName
--
--Sample file
--
--{{code}}
--operation,client.identifier,relationshipToClient,firstName,lastName
--UPDATE,TC2,Adoptive Father,Adopt,Father
--UPDATE,TC2,Adoptive Mother,Adopt,Mother
--UPDATE,TC2,Godparent,Greg,Smith
--UPDATE,TC2,Godparent,Gina,Smith
--UPDATE,TC2,Biological Father,Bio,Father
--UPDATE,TC2,Biological Mother,Bio,Mother
--{{/code}}
--
--
--**Staff** ([[Example>>url:file:///Staff+Member+-+Batch+File+Example]])
--
--Description: define staff members/users of the system.
--
--Same as Staff... admin screen.
--
--Prerequisites: valid email address
--
--Notes: The password is set to the **lastName**.
--
--The "active" field is a Boolean - TRUE or FALSE
--
--Batch File Fields:
--
--operation
--
--firstName
--
--lastName
--
--login
--
--email
--
--active
--
--Sample file
--
--{{code}}
--operation,firstName,lastName,middleName,login,email,active
--UPDATE,Test,Staff1,teststaff1,test1@test.com,TRUE
--UPDATE,Test,Staff2,teststaff2,test2@test.com,TRUE
--UPDATE,Test,Staff3,teststaff3,test3@test.com,TRUE
--UPDATE,Test,Staff4,teststaff4,test4@test.com,TRUE
--UPDATE,Test,Staff5,teststaff5,test5@test.com,TRUE
--UPDATE,Test,Staff6,teststaff6,test6@test.com,TRUE
--{{/code}}
--
--
--**Staff Role** ([[Example>>url:file:///Staff+Member+Role+-+Batch+File+Upload]])
--
--Description: assign roles to staff members
--
--Same as Staff... admin screen ~-~-> Assigned Roles tab.
--
--Prerequisites: STAFF, ROLE
--
--Notes: The "active" field is a Boolean.
--
--Batch File Fields:
--
--operation
--
--STAFF.login
--
--ROLE.code
--
--active
--
--Sample file
--
--{{code}}
--operation,user.login,role.code,active
--UPDATE,teststaff1,BUSR1,TRUE
--UPDATE,teststaff2,BUSR1,TRUE
--UPDATE,teststaff3,BUSR1,TRUE
--UPDATE,teststaff4,BUSR1,TRUE
--UPDATE,teststaff5,BUSR1,TRUE
--UPDATE,teststaff6,BUSPV,TRUE
--{{/code}}
--
--
--**Staff Placement** ([[Example>>url:file:///Staff+Member+Placement+-+Batch+File+Upload]])
--
--Description: define staff member placements at org units.
--
--Same as Staff... admin screen ~-~-> Placement tab
--
--Prerequisites: STAFF, ORGUNIT
--
--[[See the OU structure used for this sample>>url:file:///Sample-OU-structure]]
--
--Batch File Fields:
--
--operation
--
--STAFF.login
--
--ORGUNIT.code
--
--Sample file
--
--{{code}}
--operation,user.login,orgUnit.code
--UPDATE,teststaff1,SC.B1
--UPDATE,teststaff2,SC.B2
--UPDATE,teststaff3,SC.B1
--UPDATE,teststaff4,SC.B2
--UPDATE,teststaff5,R1W
--UPDATE,teststaff6,R1E
--{{/code}}
--
--
--**Staff Responsibility** ([[Example>>url:file:///Staff+Member+Responsibility+-+Batch+Upload+Example]])
--
--Description: assign staff member responsibility for other staff members.
--
--Same as Responsibilities... ~-~-> Staff tab
--
--Prerequisites: STAFF, ROLE
--
--Batch File Fields:
--
--operation
--
--parentUserRole.STAFF.login
--
--parentUserRole.ROLE.code
--
--childUserRole.STAFF.login
--
--childUserRole.ROLE.code
--
--Sample file
--
--{{code}}
--operation,parentUserRole.user.login,parentUserRole.role.code,childUserRole.user.login,childUserRole.role.code
--UPDATE,teststaff6,BUSPV,teststaff1,BUSR1
--UPDATE,teststaff6,BUSPV,teststaff2,BUSR1
--UPDATE,teststaff6,BUSPV,teststaff3,BUSR1
--UPDATE,teststaff6,BUSPV,teststaff4,BUSR1
--UPDATE,teststaff6,BUSPV,teststaff5,BUSR1
--{{/code}}
--
--
--**Organizational Unit Responsibility** ([[Example>>url:file:///Organizational+Unit+Responsibility+-+Batch+File+Example]])
--
--Description: assign staff member direct responsibility for org units.
--
--Same as Responsibilities... ~-~-> OU tab
--
--Prerequisites: STAFF, ROLE, ORGUNIT
--
--Batch File Fields:
--
--operation
--
--userRole.STAFF.login
--
--userRole.ROLE.code
--
--ORGUNIT.code
--
--Sample file
--
--{{code}}
--operation,userRole.user.login,userRole.role.code,orgUnit.code
--UPDATE,teststaff6,BUSPV,SC
--UPDATE,teststaff6,BUSPV,NC
--UPDATE,teststaff6,BUSPV,R1
--UPDATE,teststaff6,BUSPV,R2
--{{/code}}
--
--**Staff - Client Assignment** ([[Example>>url:file:///Client+Responsibility+-+Batch+File+Example]])
--
--Description: assign staff member direct responsibility for clients.
--
--Same as Responsibilities... ~-~-> Clients tab.
--
--Prerequisites: STAFF, ROLE, CLIENT
--
--Batch File Fields:
--
--operation
--
--userRole.STAFF.login
--
--userRole.ROLE.code
--
--CLIENT.identifier
--
--Sample file
--
--{{code}}
--operation,userRole.user.login,userRole.role.code,client.identifier
--UPDATE,teststaff1,BUSR1,TC1
--UPDATE,teststaff1,BUSR1,TC2
--UPDATE,teststaff1,BUSR1,TC3
--UPDATE,teststaff1,BUSR1,TC4
--UPDATE,teststaff1,BUSR1,TC5
--UPDATE,teststaff1,BUSR1,TC6
--UPDATE,teststaff1,BUSR1,TC7
--UPDATE,teststaff1,BUSR1,TC8
--UPDATE,teststaff1,BUSR1,TC9
--UPDATE,teststaff1,BUSR1,TC10
--UPDATE,teststaff1,BUSR1,TC11
--UPDATE,teststaff1,BUSR1,TC12
--{{/code}}

Role - Batch File Example-1348454930.html

Author

...	...	@@ -1,1 +1,0 @@
1		-XWiki.dbonicelli

Size

...	...	@@ -1,1 +1,0 @@
1		-2.9 KB

Content

@@ -1,158 +1,0 @@
--<table width="450" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse;">
--
--<tbody>
--<tr>
--<td width="75" height="13">operation</td>
--<td width="75">client.identifier</td>
--<td width="75">relationshipToClient</td>
--<td width="75">firstName</td>
--<td width="75">lastName</td>
--<td width="75">identifier</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1249</td>
--<td>Stepfather</td>
--<td>Joshua</td>
--<td>Cook</td>
--<td align="right">1</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1250</td>
--<td>Adoptive Father</td>
--<td>Thomas</td>
--<td>Morgan</td>
--<td align="right">2</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1251</td>
--<td>Adoptive Father</td>
--<td>James</td>
--<td>Bell</td>
--<td align="right">3</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1252</td>
--<td>Biological Father</td>
--<td>Daniel</td>
--<td>Murphy</td>
--<td align="right">4</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1253</td>
--<td>Biological Father</td>
--<td>Samuel</td>
--<td>Bailey</td>
--<td align="right">5</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1254</td>
--<td>Godparent</td>
--<td>Oliver</td>
--<td>Rivera</td>
--<td align="right">6</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1255</td>
--<td>Legal Guardian</td>
--<td>William</td>
--<td>Cooper</td>
--<td align="right">7</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1256</td>
--<td>Legal Guardian</td>
--<td>Benjamin</td>
--<td>Richardson</td>
--<td align="right">8</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1257</td>
--<td>Godparent</td>
--<td>Joseph</td>
--<td>Cox</td>
--<td align="right">9</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1258</td>
--<td>Godparent</td>
--<td>Harry</td>
--<td>Howard</td>
--<td align="right">10</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1259</td>
--<td>Godparent</td>
--<td>Matthew</td>
--<td>Ward</td>
--<td align="right">11</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1260</td>
--<td>Adoptive Mother</td>
--<td>Emily</td>
--<td>Torres</td>
--<td align="right">12</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1261</td>
--<td>Legal Guardian</td>
--<td>Ellie</td>
--<td>Peterson</td>
--<td align="right">13</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1262</td>
--<td>Legal Guardian</td>
--<td>Jessica</td>
--<td>Gray</td>
--<td align="right">14</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1263</td>
--<td>StepMother</td>
--<td>Sophie</td>
--<td>Ramirez</td>
--<td align="right">15</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1264</td>
--<td>StepMother</td>
--<td>Chloe</td>
--<td>James</td>
--<td align="right">16</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1265</td>
--<td>StepMother</td>
--<td>Lucy</td>
--<td>Reed</td>
--<td align="right">17</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td align="right">1266</td>
--<td>StepMother</td>
--<td>Olivia</td>
--<td>Rogers</td>
--<td align="right">18</td>
--</tr>
--</tbody>
--</table>
--

Role Permission - Batch File Example-1348454930.html

Author

...	...	@@ -1,1 +1,0 @@
1		-XWiki.dbonicelli

Size

...	...	@@ -1,1 +1,0 @@
1		-797 bytes

Content

@@ -1,46 +1,0 @@
--<p>&nbsp;</p>
--<table width="200" cellspacing="1" cellpadding="1" class="pbNotSortable">
--<tbody>
--<tr>
--<td>
--<table width="300" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse;">
--
--<tbody>
--<tr>
--<td width="75" height="13">operation</td>
--<td width="75">name</td>
--<td width="75">code</td>
--<td width="75">description</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td>Caseworker</td>
--<td>cw</td>
--<td>Caseworker</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td>Supervisor</td>
--<td>su</td>
--<td>Caseworker's Supervisor</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td>Site Manager</td>
--<td>sm</td>
--<td>OU - Manager</td>
--</tr>
--<tr>
--<td height="13">UPDATE</td>
--<td>Data Entry</td>
--<td>de</td>
--<td>Data Entry Clerk</td>
--</tr>
--</tbody>
--</table>
--</td>
--</tr>
--</tbody>
--</table>
--<p>&nbsp;</p>
--