...

• 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.
  
  Image Added

New File Loading Process

Follow the following 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 new corrected file for loading to database: