print('========================= Created by Dmytro Zimin =============================')
print('################################################################################\n\n')
print('***Please make sure you have read the instruction manual before using this program***')
run = input('To proceed press <y> or any other button to exit\n')
if run.lower()[0] == 'y':
print('combining basware *.csv files to excel ')
for file in glob.glob('basware/*.csv'):
basware_file = DataFile(file)
basware_file.combine_to_excel('basware', 'basware/combined.xlsx')
print('combining flow *.csv files to excel ')
for file in glob.glob('flow/*.csv'):
flow_file = DataFile(file)
flow_file.combine_to_excel('flow', 'flow/flow.xlsx')
print('retrieving data...')
retrieve_gfis_data('gfis/*.xlsx')
data_from_combined('basware/combined.xlsx')
data_from_flow('flow/flow.xlsx')
get_inv_status('check_invoices.xlsx')
print('writing statuses...')
write_status('check_invoices.xlsx')
print('deleting temporary files...')
DataFile.remove_temporary_files('basware/combined.xlsx')
DataFile.remove_temporary_files('flow/flow.xlsx')
input('Statuses have been added to check_invoices.xlsx! Press any key to exit')
exit()
else:
exit()
