Providing Data Using the Data Upload Option

How do I submit Data using the Data Upload option?

In order to provide data via the Data Upload option, you must first download the desired data type template.  To do this:

  • Navigate to the Data Management Menu.
  • From the Data Management Menu select (click on) the Data Upload option from the left menu.
  • From the Data Upload screen find and select (click on) the desired data type template. 
  • The file that downloads is in a ".xlsx" (Excel) format.   Find that file on your local computer and open it using whichever program you use for Excel files.
  • There are 2 types of templates.
    • Side label templates which allows you to fill out the columns starting at column E.   Columns A through D are there to provide guidance to the user.
      • Example:
Top row labeled templates.   These templates need to be filled out starting at row 2 and allow for multiple rows per event.
Example:

NOTES:
  • Please enter any values that start with a 0 (zero) like this:
    • Value 01234 should be entered as '01234 with a single quote proceeding the value itself.
  • Once you have completed filling in the template you must save it as a CSV file.
    • You can name the file in a manner that makes sense to you, but it must be saved as a CSV file.
    • Once the file is saved return to the Data Upload screen, select (click on) the "Select a File" button.
      • Chose the file you just saved.
    • The file you selected will automatically upload and will be examined to confirm the file meets the stated requirements.
      • If the file does not meet the stated requirements an error message will be displayed.    The error message will indicate the first missing requirement detected.  Once you have corrected the file you can repeat the process.
        • Here is an example of an error message:Dropbox Error
      • If the file meets the stated requirement you will receive a "File uploaded successfully message.
        • Here is an example of that message:File Uploaded Successfully Screen
      • Once a file has been successfully uploaded you can check the status of that file by selecting (clicking on) the Data Management button.  Data Managment Button
      • This will take you to a screen showing the file up uploaded and it's current status.Data Audit Screen