Location

\\hscetl\cbse

The above shared drive folder has the following sub-folders:

• • Archive - Contains the files that have been loaded to the database in the past.
  • Error Logs - Contains the following 2 files
    • Invalid_data_error_log.csv - Contains invalid data records in the file when data was last available.
    • Invalid_Unumber_error_log.csv - Contains invalid U-number records in the file when data was last available.
  • Required file format - Contains the template file 'CBSE_File_Format.xlsx'. Please use it to generate any files that need to be loaded to the database.

Rules for Data

1. Must have a test date for each record.
2. Must have a valid U-number for a USF Health student.
3. Must have an attempt number for each record.
4. Scores must be within a valid range
5. Columns must be in the order indicated on the 'CBSE_File_Format.xlsx' in the Required file format folder.
6. File must be in .xlsx format.

New File Loading Process

Follow these steps to provide a new CBSE data file for loading to database:

1. Go to the folder location.
2. Go to Required file format sub-folder and open the 'CBSE_File_Format.xlsx' file.
3. Create/Download the new CBSE data file(s) and save them with the same format as the above template file. 
4. The file(s) should be named appropriately with a date appended in the end and saved as an 'Excel Workbook' (*.xlsx) to the CBSE main folder.
   If there are multiple files they all can be placed in the same location.

Data Correction and Loading Process

...