Versions Compared

Old Version 12

changes.mady.by.user Kautuk Gupta

Saved on

compared with

New Version 13

changes.mady.by.user trichar2

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

titleNote

...

Location

\\hscetl\data\USMLE\CBSE

Expand
titleSubfolders

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

...

  1. .

...

New File Loading Process

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

  1. Check access to the shared drive folder (\\hscetl\data\USMLE\CBSE). Go to the folder location.
  2. Go to 'Required file format' sub-folder (\\hscetl\data\USMLE\CBSE\Required file format) and 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 (\hscetl\data\USMLE\CBSE) CBSE main folder.
    If there are multiple files they all can be placed in the same location.

Data Correction and

...

Loading Process

Info
titleNote

You will be notified if there are any source data errors while loading the file(s). The email will mention the location and file name of the error log. Please Note note the error log will be in a .csv format and you will need to save it to a .xlsx format as per indicated in the process. Please check instructions below;


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

  1. Check access to the shared drive folder (\\hscetl\data\USMLE\CBSE). Go to the folder location.
  2. Go to the 'Error Logs' sub-folder (\\hscetl\data\USMLE\CBSE\Error Logs). .
  3. Locate the error log file name mentioned in the email.
  4. Open the file(s) and fix the error records in the file(s). 
  5. Rename the file(s) appropriately with a date appended in the end.
  6. Save the file(s) as an 'Excel Workbook' (*.xlsx) to the (\\hscnet\etl\USMLE\CBSE) location. (Note the error log will be in a .csv format and you will need to save it to a .xlsx format as per process)
  7. Rename the file(s) appropriately with a date appended in the end.

...

  1. the CBSE main folder.