o ނi{ @s<ddlZddlZddlZddZddZddZdd ZdS) Nc Csrzt|d}t|WdWS1swYWdSty8}ztd|WYd}~dSd}~ww)NrzError reading JSON file: )openjsonload Exceptionprint) file_pathfileer 8/home/acert/hirelines/app_api/functions/excel_mapping.py read_jsons (r c CsBzt|WSty }ztd|WYd}~dSd}~ww)NzError reading Excel file: )pd read_excelrr)rr r r r rs rc Csd}d}|dd}|D]A\}}t|rq|d7}d|vr-|d}t|t|s-qd|vrs  !