Develop a interface to integrate two systems -- 2
S-au achitat serviciile după ce au fost prestate
Develop a interface to integrate two systems using MySQL and Python, based on an excel file as input.
Main activities of the new script:
1. Import an excel file with the list of contracts and fields to be updated;
2. Using API of the destination system (ERP Omie), search the listed contracts in the Excel file and store the current values on ERP Omie of the desired fileds;
3. Merge the current values of desires fields with the values in excel file;
4. Show in the interface all the contracts that will be updated before execution (for validation) - print verson needed;
5. Execute the update:
5.1. Delete all itens (products) in the contracts listed in excel file, in ERP Omie;
5.2. Update all contracts with the merged fields (excel file + API search), in ERP Omie;
6. Show in the interface the response for each contract update (fail ou success) - print verson needed.
ID Proiect: #37248996