In progress

Php report

Published on the June 29, 2020 in IT & Programming

About this project

USD 250 - 500

Requirement: existing text file found on the server will be converted to sql data  on a set time
the data will be appended to the server sql the system will match existing item with  branch barcode and add the quantity to the total qty
sample text file
2|sungears sales, inc.|2|estancia|00001000|46|05/31/2020|00001000|gift card|others|giftcard|giftcard|0.00|1000.00
2|sungears sales, inc.|2|estancia|0067500214|0|05/31/2020|0067500214|fsv 1.61 white hmc s:-3.25 C:-1.75|lens|aspheric lens|sv hmc|0.00|0.00
2|sungears sales, inc.|2|estancia|0067505198|0|05/31/2020|0067505198|fsv 1.61 as white hmc s:0.25 C:-0.00|lens|aspheric lens|sv hmc|0.00|0.00
2|sungears sales, inc.|2|estancia|0067505206|0|05/31/2020|0067505206|fsv 1.61 as white hmc s:0.25 C:-0.25|lens|aspheric lens|sv hmc|0.00|0.00
2|sungears sales, inc.|2|estancia|0067505214|0|05/31/2020|0067505214|fsv 1.61 as white hmc s:0.25 C:-0.50|lens|aspheric lens|sv hmc|0.00|0.00
2|sungears sales, inc.|2|estancia|0067505222|0|05/31/2020|0067505222|fsv 1.61 as white hmc s:0.25 C:-0.75|lens|aspheric lens|sv hmc|0.00|0.00
2|sungears sales, inc.|2|estancia|0067505230|0|05/31/2020|0067505230|fsv 1.61 as white hmc s:0.25 C:-1.00|lens|aspheric lens|sv hmc|0.00|0.00
2|sungears sales, inc.|2|estancia|0067505248|0|05/31/2020|0067505248|fsv 1.61 as white hmc s:0.25 C:-1.25|lens|aspheric lens|sv hmc|0.00|0.00
output file will send via excel attachment

Category IT & Programming
Subcategory Web development
What is the scope of the project? Medium-sized change
Is this a project or a position? Project
I currently have I have specifications
Required availability As needed
API Integrations Other (Other APIs)
Roles needed Developer

Deadline: August 10, 2020

Skills needed

MySQL PHP

Want to start working on this project?

Log into your Workana account or Register today. Boost your freelance work!

Other projects posted by D. T.