Have a webapp which is coded in PHP/MySQL which some minor changes are needed to be made to the output of the CSV files it generates.
The original files are exported from one program into a CSV file, and then converts the files so that they can be imported into another.
The export from the "Program A" can either be a detailed sales report or a summarised.
--- Summary Export ---
The summary export file from Program A is called: Sales (To Import) - 2017-04-01 to 2017-07-31 - ID 122
Currently when you run the export through the app it creates a file called:
Program B Standard "Store Name" (To Import) - 2017-04-01 to 2017-07-31 - ID [url removed, login to view]
"Store Name" is the name of the store - Defined within the app settings; the date range
The summarised the date in the file is the date of the export (which is incorrect). This needs to use the end date in the filename (ie 2017-07-31)
The narration needs to change to: PROGRAM B SUMMARY "Store Name" - Export Date - ID 122
Export Date in the narration needs to be the date which is date field from within the CSV file.
--- Detailed Export ---
Similar to the Summarised export - The Date field in the CSV file needs to change to the end date from the filename.
As Program B only can import 200 lines at a time, if a detailed export occurs the app will split the file into multiple parts.
For instance; the export filename / narration will be called:
Part 1 of 4 - Program B Standard "Store Name" (To Import) - 2017-04-01 to 2017-07-31 - ID [url removed, login to view] ID - 121
Narration needs to change to:
Part 1 of 4 - Program B DETAILED "Store Name" - TRANSACTION DATE - ID 121
TRANSACTION DATE - Is the individual transaction date from the date line items - So the narration will change based on the transaction date.
Filename will need to output to: Part 1 of 4 - Program B DETAILED "Store Name" - 2017-04-01 to 2017-07-31 - ID [url removed, login to view]
A change to the front end will then need to be made; as there is no way to differentiate between a summarised or detailed file.
So on the import selection tool - It will state: Sales
Need to now have 2 - One for Sales - Summary & other for Sales - Detailed.
Will provide more details on programs and also spreadsheet with both input and output.