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 »

Note

You need to have access to the following shared drive folder to proceed:

\\hscnet\etl\USMLE\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 such data was available last.
    • Invalid_Unumber_error_log.csv - Contains invalid Unumber records in the file, when such data was available last.
  • Required file format - Contains the template file 'CBSE_File_Format.xlsx'. Please use it to generate any files that need to be uploaded. Note that the file has to be in .xlsx format, with all the columns present in the template.

New File Loading Process

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

  1. Check access to the shared drive folder (\\hscnet\etl\USMLE\CBSE). Go to the folder.
  2. Go to 'Required file format folder and use the 'CBSE_File_Format.xlsx'. template file to format the CBSE data that needs to be uploaded. The file should be named appropriately with a date appended in the end.
  3. Once the file has been created save it to the (\\hscnet\etl\USMLE\CBSE) folder. If there are multiple files they all can be placed in the same location.

Data Correction and Corrected Records File loading Process

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

 

 

  • No labels