PHP Script to Format CSV file to spec, and upload to mysql
- or -
Post a project like this1572
£70(approx. $88)
- Posted:
- Proposals: 15
- Remote
- #2640516
- Awarded
Top rated PHP Web Development | WordPress | Magento | Drupal | OpenCart | PrestaShop | Joomla
Leicester
6329174404059618074238310507541084133246148925692742792334294953730155493310943
Description
Experience Level: Entry
I require a PHP script making that will fetch a CSV file from a third party web server, format the file into the required layout, columns and data, and upload it into an existing mysql table on our own web server.
The original file (please see attached file called original.csv) contains approx 80,000+ rows of data and some of the data is in xml format within columns.
The file needs to be formatted, and the relevent data extracted from the xml format columns, and some data needs changing, e.g where the data says "Vodafone", it needs replacing with "1" (we can provide the relevent replacement values).
In short, you need to code a php file to make the attached file "original.csv" format out and produce the file "final.csv" and for it to be uploaded into an existing mysql table.
Please be aware the attached file is just a sample of the data format and the actual file contains 80,000+ rows of data so the php script needs to be robust enough to handle this amount of data. The output file/sql table needs to be in exactly the same format as the final.csv file
Please take the time to view the attached files and be sure you can do the work exactly as required. Script needs to be written in PHP as we will using a cron job on our server to run it once per day.
Looking for someone that can complete this job asap and exactly as required.
The original file (please see attached file called original.csv) contains approx 80,000+ rows of data and some of the data is in xml format within columns.
The file needs to be formatted, and the relevent data extracted from the xml format columns, and some data needs changing, e.g where the data says "Vodafone", it needs replacing with "1" (we can provide the relevent replacement values).
In short, you need to code a php file to make the attached file "original.csv" format out and produce the file "final.csv" and for it to be uploaded into an existing mysql table.
Please be aware the attached file is just a sample of the data format and the actual file contains 80,000+ rows of data so the php script needs to be robust enough to handle this amount of data. The output file/sql table needs to be in exactly the same format as the final.csv file
Please take the time to view the attached files and be sure you can do the work exactly as required. Script needs to be written in PHP as we will using a cron job on our server to run it once per day.
Looking for someone that can complete this job asap and exactly as required.
Barry P.
100% (31)Projects Completed
26
Freelancers worked with
17
Projects awarded
25%
Last project
27 Dec 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Barry,
This should be fairly simple however I can't see any examples of xml formatted data in the original csv. Is there another sample that can show the structure of these xml data columns?
Thanks,
John
873680
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies