Changes for page Batch Uploads

Last modified by Matthew Deceunynck on 2015/07/02 17:24
From version Icon 18.2 Icon
edited by karimpirani
on 2014/07/15 14:37
Change comment: There is no comment for this version
To version Icon 15.1 Icon
edited by karimpirani
on 2014/07/14 17:58
Change comment: Upload new image batch uploads - sample.PNG

Summary

Details

Icon Page properties
Content
... ... @@ -3,30 +3,21 @@
3 3  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.
4 4  
5 5  
6 -__Prepare your file for uploading:__
6 +csv process - batch uploads - common looking/format data (export/import)
7 +usually, CSV: text file, 1 line in file per assessment ;;; client id, date, score, assessor ~-~-- way to transfer assessment data
7 7  
8 -0. A note on the CSV file type: you will be required to upload all data to the system as a CSV file. Short for comma-separated values file, these files enable both parties (i.e. those responsible for importing and exporting the data) to have common expectations as to the data that must be uploaded and what the data signifies. They also prove to be the simplest and most effective way to transfer assessment data for clients. In the batch upload process, therefore, your CSV file will contain all the necessary and pertinent information for clients. Each CSV file (usually a text file) can contain information about many different clients. An outline for what to include and what format to use in your file is shown below.
9 +Prepare your file for uploading:
9 9  
10 -~1. The first step you will need to take for batch uploads is to export all of your client data to the CSV file format. As stated above, the file can be a simple text file. Moreover, it can include information and assessment data for multiple clients. However, you **must **follow the subsequently outline standard to ensure that your data is understood and accepted by the system //(see the sample below for any clarifications)//
11 +~1. CSV file type: please note that you will be required to upload all data to the system as a CSV file. Short for comma-separated values file, these files enable both parties (i.e. those responsible for importing and exporting the data) to have common expectations as to the data that must be uploaded and what the data signifies. They also prove to be the simplest and most effective way to transfer assessment data for clients. In the batch upload process, therefore, your CSV file will contain all the necessary and pertinent information for clients. Each CSV file, usually a text file, can contain information about many different clients. An outline for what to include and what format to use is shown below.
11 11  
12 -(((
13 -* Each client's assessment should be on a different line
14 -* Hence, there should be 1 line in the file per assessment
15 -* In this line, please be sure to include 4 things (in this order) separated only by commas: CLIENT ID, DATE (in MM/DD/YYYY format), SCORE, ASSESSOR
16 -* When you have included assessment information for all the clients, save your CSV file
17 -* Your CSV file is now ready to upload onto the system. See the General Uploading Process below to continue...
18 -* \\
19 -* [[image:batch uploads - sample.PNG||style="font-size: 14px; background-color: rgb(245, 245, 245);"]] __**A DATA SET LIKE THE ONE ON THE LEFT BECOMES... **__[[image:batch uploads - sample csv.PNG||style="font-size: 14px; background-color: rgb(245, 245, 245);"]]
20 20  
21 -(((
14 +* Use of CSV file.
15 +* Export of client's data to CSV file format
16 +* Show a few columns on a fake and limited spreadsheet.
22 22  
23 -)))
24 -)))
25 -
26 26  Batch Upload Data Formats
27 27  
28 28  * Most common upload formats include: Role, Client, Staff Member, etc.
29 -* Each of these options have very specific and definite formats, so please contact OA support to receive the exact template for your selected option.
30 30  * Some customized formats may be available or could be developed. Please contact OA for more information.
31 31  
32 32  **General Uploading Process**
Icon batch uploads - sample csv.PNG
Author
... ... @@ -1,1 +1,0 @@
1 -XWiki.karimpirani
Size
... ... @@ -1,1 +1,0 @@
1 -7.1 KB
Content Icon