PHP Script to FTP, Parse & Import an Excel File to MySQL 4.1 DB
$30-100 USD
Færdiggjort
Slået op over 14 år siden
$30-100 USD
Betales ved levering
I need a small script written to FTP a vendor's inventory spreadsheet written in XLS (Excel format) to my server and then parse and import that spreadsheet directly into a table with the matching fields. Basically just take the Excel data and put it into a table in the DB. My server runs MySQL 4.1 so the script needs to be written for that version. I'm not interested in upgrading to a later version of MySQL.
## Deliverables
The script needs to be fully commented so each function is well defined and specific. All arrays should also be commented for future development.
The FTP login information will be provided and uses a secure login. The Excel file is currently just under 4mb.
The Excel file contains 8 columns so the db table will contain 8 fields. It contains about 15,000 rows of data keyed on the SKU which is unique.
Good performance ensures future contracts. We build websites every week and always needing small scripts written.
Thank you for your consideration.