Changes for page Batch Uploads

Last modified by Matthew Deceunynck on 2015/07/02 17:24
From version Icon 13.1 Icon
edited by Matthew Deceunynck
on 2014/07/10 09:37
Change comment: There is no comment for this version
To version Icon 4.1 Icon
edited by karimpirani
on 2014/06/20 15:31
Change comment: There is no comment for this version

Summary

Details

Icon Page properties
Author
... ... @@ -1,1 +1,1 @@
1 -XWiki.mdeceunynck
1 +XWiki.karimpirani
Content
... ... @@ -2,35 +2,24 @@
2 2  
3 3  
4 4  
5 -The batch data upload process allows you to quickly populate the system database with existing data that is already recorded in electronic format on one of your other data systems. The following is a step-by-step guide to making your way through this process.
5 +The batch data upload process allows you to quickly populate the SMR database with existing data that is already recorded in electronic format on one of your other data systems. The following is a step by step guide to making your way through this process with a minimum of wear and tear.
6 6  
7 +
7 7  
8 -Prerequisites -
9 +You must review and fulfill these [[Prerequisites >>doc:Prerequisites]]prior to proceeding with this Batch Upload Process.
9 9  
11 +
10 10  
11 -* (% style="font-size: 14px; background-color: rgb(245, 245, 245);" %)Use of CSV file.
12 -* (% style="font-size: 14px; background-color: rgb(245, 245, 245);" %)Export of client's data to CSV file format
13 -* (% style="font-size: 14px; background-color: rgb(245, 245, 245);" %)Show a few columns on a fake and limited spreadsheet.
13 +Use these [[Batch Upload Data Formats>>doc:Batch Upload Data Formats]] and examples to guide you through the process of uploading your organization's data.
14 14  
15 -(% style="font-size: 14px; background-color: rgb(245, 245, 245);" %) Batch Upload Data Formats
15 +
16 16  
17 +**General Uploading Process**
17 17  
18 -* List most common upload formats.
19 -* Some customized formats may be available or could be developed.
19 +~1. Log into the SMR application
20 20  
21 -
22 -
23 -(% style="font-size: 14px; background-color: rgb(245, 245, 245);" %)**General Uploading Process**
24 -
25 -~1. Log into the application
26 -
27 27  2. Select the Batch Uploads option under the Administration sidebar
28 28  
29 -[[image:batch uploads - admin bar.PNG]]
30 -
31 -
32 -The following screen should appear.
33 -
34 34  [[image:bu 1.PNG||width="100%"]]
35 35  
36 36  
... ... @@ -44,31 +44,33 @@
44 44  
45 45  5. Confirm successful upload
46 46  
47 -[[image:batch uploads - 7.PNG]]
36 +[[image:Missing.png]]
48 48  
49 49  
50 50  
51 -6. Select the uploaded data and click on 'Process Selected'
40 +6. Select the uploaded data and click on Process Selected
52 52  
53 53  7. If there are errors, view the error details by clicking on the Show Error Details option
54 54  
55 -[[image:batch uploads - 5.PNG]]
44 +[[image:Missing.png]]
56 56  
57 57  You will need to correct the data in the CSV file, or obtain a new, corrected copy of the data.
58 58  
59 59  
60 60  
61 -8. If there are no errors (Success Count = Total Count), then you are done!
50 +8. If no errors (Success Count = Total Count), then you are done!
62 62  
63 63  
64 64  
54 +
55 +
65 65  **General File and Field Format/Content Rules**
66 66  
67 67  1. All fields are comma delimited.
68 68  1. The first row of the file is the 'header' record that specifies which fields are in the subsequent rows.
69 -1. The possible fields are case sensitive. E.g. 'name' does not equal 'NaMe'
60 +1. The possible fields are case sensitive. E.g. name does not equal NaMe
70 70  1. Fields can be escaped using Microsoft escaping or standard escaping.
71 -1. Dates are to be formatted in YYYY/MM/DD format. E.g. 2009/01/23
62 +1. Dates are to be formatted in yyyy/mm/dd format. E.g. 2009/01/23
72 72  1. Boolean values are either TRUE or FALSE.
73 73  1. Operation fields are not required and default to UPDATE when not specified. Here are the possible values for operation:
74 74  11. UPDATE: inserts or updates the record in the system
Icon batch uploads - 5.PNG
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.karimpirani
Size
... ... @@ -1,1 +1,0 @@
1 -256.3 KB
Content Icon
Icon batch uploads - 7.PNG
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.karimpirani
Size
... ... @@ -1,1 +1,0 @@
1 -257.3 KB
Content Icon
Icon batch uploads - admin bar.PNG
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.karimpirani
Size
... ... @@ -1,1 +1,0 @@
1 -89.3 KB
Content Icon