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 7 Next »

Location

\\hscetl\data\USMLE\Y1CE

 

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

  • Loading Area - Folder where the data files need to be placed for loading.
  • Archive - Contains the files that have been loaded to the database in the past.
  • Error Logs - Contains the following 2 files
    • Y1CE_Invalid_data_error_log.csv - Contains invalid data records in the file when data was last loaded.
    • Y1CE_Invalid_Unumber_error_log.csv - Contains invalid U-number records in the file when data was last loaded.
  • Required File Format - Please use the file in the folder (Y1CE_Scores_AYXXXX.xlsx) as a template to generate any files that need to be loaded to the database. 
  • Original File Archive - Contains files that were provided by the client in a different format than what is required.

Rules for Data

  1. Must have a test date for each record.
  2. Must have a valid Examinee Id (U-number) for a USF Health student.
  3. Must have a valid (not blank or non-zero) Total Percent Correct value for each record.
  4. Columns must be in the order indicated on the files in the Required file format folder.
  5. The excel sheet name should not have a '&' character.
  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 check for file format.
  3. Create/Download the new NBME Course 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 Loading Area folder. 
    If there are multiple files for same course they all can be placed in the same location.

Data Correction and Loading Process

Note

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 the error log will be in a .csv format and you will need to save the corrected data into a .xlsx format as indicated in the process.

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

  1. Go to the folder location.
  2. Go to the Error Logs sub-folder.
  3. Locate the error log file name mentioned in the email.
  4. Open the file and check for the error records.
  5. Use the file in the Required file format folder, and create new file(s) with the corrected data with scores.
  6. Rename the file(s) appropriately with a date appended in the end.
  7. Save the file(s) as an 'Excel Workbook' (*.xlsx) to the Loading Area folder.

Load Schedule

It is important that the Excel files be closed and are not open for editing before the load process begins. The load is expected to happen XXXXXXXXXX.

  • No labels