18-Aug-2023_12hrs-14ms-49s-->total DFO sheets uploaded is 3
This is the master region from sheets Maritimes
I am in the logic
This is the rename dictionary of thisfile1-------> {'LICENCE_ID': 'LIC_ID', 'LICENCE_PARTICIPANT_START_DATE': 'LICENCE_PARTICIPANT_START_DATE', 'LICENCE_VESSEL_START_DATE': 'LICENCE_VESSEL_START_DATE', 'LICENCE_PARTICIPANT_END_DATE': 'LICENCE_PARTICIPANT_END_DATE', 'LICENCE_VESSEL_END_DATE': 'LICENCE_VESSEL_END_DATE', 'VR_NUMBER': 'VR_NUMBER', 'LOA': 'LOA', 'SURNAME': 'SURNAME', 'PROVINCE': 'PROVINCE', 'COUNTY_NAME': 'COUNTY_NAME', 'LIC_GEAR_DESC': 'LIC_GEAR_DESC'}
this is the message from missing data in the columns logic for this file1-------> pdf not created withfile1because no missing columns
This is the rename dictionary of thisfile3-------> {'LICENCE_ID': 'LIC_ID', 'LICENCE_GEAR_START_DATE': 'LICENCE_GEAR_START_DATE', 'LICENCE_GEAR_END_DATE': 'LICENCE_GEAR_END_DATE', 'LIC_AREA_DESC': 'LIC_AREA_DESC', 'VR_NUMBER': 'VR_NUMBER', 'VESSEL_NAME': 'VESSEL_NAME', 'FIRSTNAME': 'FIRSTNAME', 'LIC_GEAR_DESC': 'LIC_GEAR_DESC'}
this is the message from missing data in the columns logic for this file3-------> pdf created withfile3successfully
This is the rename dictionary of thisfile2-------> {'LICENCE_ID': 'LIC_ID', 'LIC_TYPE_DESC': 'LIC_TYPE_', 'LIC_SPC_DESC': 'LIC_SPC_', 'LICENCE_AREA_START_DATE': 'LICENCE_AREA_START_DATE', 'LICENCE_AREA_END_DATE': 'LICENCE_AREA_END_DATE', 'VR_NUMBER': 'VR_NUMBER', 'STATISTICAL DISTRICT': 'STATISTICAL DISTRICT', 'GEAR_CODE': 'GEAR_CODE', 'LIC_GEAR_DESC': 'LIC_GEAR_DESC', 'GEAR_AMOUNT': 'GEAR_AMOUNT'}
this is the message from missing data in the columns logic for this file2-------> pdf not created withfile2successfully because no missing columns
this is the file which has less recordsfile1
These are  columns which contain restricted data----> []
These are number of licences not given by dfo but exist in our master 2
This is the message from pdf generator for missing licence ids------> pdf created for missing license id's w.r.tfile1successfully
These are the licenses which are new----> []
ALL files are generated with zohoones and updated master aswell
ZIP file created at: static/media/output_files/final_results_20230818_121449.zip
Programme Task Successfully completed in 0:00:01.551223 seconds.