Page Comparison

...

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):  https://usfweb.usf.edu/DSS/BIADataload/Import/DownloadTemplate/1031
3. File must contain 4 columns.
4. File must contain a row header.
5. All columns must have data for each row.
6. File cannot contain any duplicates. (Any row of data that contains the same Access Date, Access time, Status and User with be considered a duplicate).

...

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 can be uploaded as and when needed.  After the file upload is complete, the information will be processed and saved thru ETL to save a person with its current department so that in the future we can saved to a table. The ETL job will then process the data in the table, linking a person to its current department. That data then can be used to create reports with employees and the departments they were associated with at the time.