Batch Upload Tips:
Check Securities. Is this an action you can take in ETO? Do you have proper securities to allow you to record/edit/update TouchPoint or Participants?
Start Fresh. Download a fresh template for Batch Uploads. Copy and Paste data without formatting,
Double Check Data. Complete all required fields, duplicate check information, make sure dates are accurate, double check data
Test. Upload 1-2 rows of test data to ensure a proper upload
Upload. We do not recommend uploading over 600 rows at once. Larger files may take longer to process.
Note: Modifying the generated template (i.e. deleting worksheets like ContactInfo or deleting columns) is not recommended and may cause issues. Please be sure to, at minimum, complete the EntityInfo tab and the program enrollments tab for your site. During your upload, you can choose to use null values for columns you did not input data for.
Entity Batch Upload
Insert new Entities: To insert a brand new Entity is very easy. Complete all required fields from your Manage Attributes page. The Batch Upload will recognize it is an insert from the Insert / Update column in the spreadsheet.
Update Entities in the System: To update an Entity choose "Update" and match your Entity with the Entity Site ID, Required Entity Attributes, and Duplicate Check Attributes from Manage Attributes.
Step by Step Guide
Generating Template
Step 1 – Expand Navigation Bar (if applicable)
Step 2 – Click Site Administration
Step 3 – Select Batch Upload
Step 4 – Under Generate Template, select Entity from the drop-down menu
Step 5 – Click Generate Template
Step 6 – Select the Site(s) and Program(s) to create the template for
A. Check the box next to Site Name to select ALL Sites in the Enterprise
B. Click the arrow toggle to expand each Site to see the Programs in that Site
C. Check the box next to Program Name to select ALL Programs in Site
D. Check the box next to an individual Program to only select one Program
E. Use the navigation to move between pages for Programs which contain more items than is displayed per page
F. Check the box next to a Site when not expanded to check all Programs in that Site
G. Search and filter Sites in the Enterprise
H. Search and filter Programs in a Site
Step 7 – Select the Entity Type(s) to create the template for
Step 8 – Click Generate Template button at the bottom of page
Step 9 – Click Open on the prompt to open the template
Step 10 – Insert data into the template and save the spreadsheet
Uploading
Step 11 – In ETO, under Upload File, select Entity from the drop-down menu
Step 12 – Click Select File
Step 13 – Locate file to be uploaded and click Open. Once it's ready, it will display "Done" with a green check mark
Step 14 – Click Begin Upload
Step 15 – Click Finish
Notes on Entity Batch Upload:
There will be multiple tabs in the spreadsheet. A spreadsheet will open with columns based on the attribute that are required for an Entity Batch Upload:
Insert Or Update: "Insert" a new Entity or "Update" an existing Entity. This field is required
Entity Id Or Name: The name of the Entity (new or update) OR the Entity ID (update only). The Entity ID is automatically assigned by ETO when the Entity is entered in the system
Entity Type: The standard or custom Entity types created by administrators via Manage Entity Types/Sub-types
Entity Sub-type: Different sub-types are available based on the Entity type you chose. You can upload the Entity with multiple sub-types by separating each sub-type with a semicolon
Entity Description: Enter a brief description for the Entity
Enterprise Level: Do you want the Entity to appear across the Enterprise? Enter Yes or No
Address 1, Address 2, Zip-code, Phone-number: Enter contact information for the Entity
Enterprise Level Custom Attributes: All custom attributes available at the Enterprise level will appear
Valid file types for use with the Entity Batch Upload feature are .XLSX
Entity Cross Reference Elements: Use Entity ID's to complete this column. The Entity ID of the cross referenced Entity will populate the name in ETO. If a custom attribute is set to Entity Cross Reference, ensure the Entity appears in the drop-down menu when accessing the View/Edit Entity page.
Multiple Types: When uploading multiple Entity types or sub-types you will need to use a semi-colon between types. There are to be no spaces before or after the semi-colon that are not written in ETO as part of the Entity type
Multiple Sub-Types: Should be in this format: [Type] SubType;[Type] SubType. There are to be no spaces before or after the semi-colon that are not written in ETO as part of the sub-type
Multiple Programs: When uploading multiple Entity Program enrollments, each enrollment will have its own row in the excel file. This occurs on the last tab of the excel sheet. If you are uploading 4 Entities with Program enrollments in 4 Sites, your Program tab will have 16 rows of data. Semicolons are not used in this part of the sheet.
Errors
If there is an error in the spreadsheet, the upload will not be successful
On the In Progress tab, click the Fix Errors button the Action column
On the Error Summary page, click the toggle arrow next to the Site Name. A list of errors will populate.
Click Next
Fix the noted areas in the "Did you mean...?" column by typing the correct value or selecting the correct value from the drop-down menu and click Next. Repeat this step for all errors
A. The first column will show the data uploaded. The Error Type column describes the error it produced. The Error Count column gives the number of times the error occurred.
B. You will not be able to click the Next button until all errors are corrected
C. If you must navigate away from fixing errors, your changes will not be saved
Click Finish on the confirmation screen
Success
If your file is successfully uploaded, you will see the information under the Complete tab
Clicking on the File Name will give you the log details