...

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. The system is comprised of an ASP.NET MVC web application that uses a SQL Server database back-end to function.  Importing to SQL Server and Oracle databases are supported.

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)File cannot contain any nulls
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).

...

1. Go to the link https://usfweb.usf.edu/DSS/BIADataload/ and press “Start Submission”
2. Log in with your NetidNetId
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.
   Image Modified

   Warning
   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.

...

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?