Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

Location

https://usfweb.usf.edu/DSS/BIADataload/

 

The BIA Data Importer system allows authorized users to upload Excel documents to the Business Intelligence & Analytics department for data warehousing and reporting.  During the import process, a set of rules are applied to the data to ensure the data conforms to the data integrity standards.

Rules for Data

File Upload:

  1. File must be in excel format.
  2. File must follow specific format.  Template with format details can be downloaded from the application.  (Link when in prod)
  3. All columns must have data for each row.
  4. File cannot contain any duplicates. based on what field(s)?

Loading Process

During the 3-step process. You will be notified if there are any source data errors while loading the file(s).

Follow these steps to provide a successful upload file to the database:

  1. Go to the link https://usfweb.usf.edu/DSS/BIADataload/ and press “Start Submission”
  2. Log in with your NetId
  3. If needed, download the template. (if the file is already prepared using the template skip this step)
  4. Click on the “Upload File” button.
  5. Click on Browse and locate the file on your computer.

  6. After file is uploaded the message “The file was successfully uploaded and stored.” should be seen.

    What do I do if errors are found?


  7. If no errors are found click on Validate Data.
  8. If no errors were found, to complete the import, click “Finalize Import”
  9. After finalize import, an Import Completed message indicating how many records were updated show be shown.

 

Load Schedule

It is important that the Excel files be closed and not open for editing before the load process begins. When the data load begins if the file is open then the process will error out.  The file upload will be as needed. what happens if they upload the info, the etl doesn't run, then they upload more info?

  • No labels