XLS to CSV conversion in PHP/SQL
This project received 9 bids from talented freelancers with an average bid price of $183 USD.Get free quotes for a project like this
Project Budget$30 - $250 USD
I would like a script/form that allows input for a local xls file
script will autosort 'Item Type' column as 'inventory
script will autopopulate a dropdown input of 'Vendor Name' column and 'All' will be an option nd multiple items will be an option
script will autopoulate a multiselect box for 'Department Name' Column and 'All' and multiple items will be an option
script will sort by above fields
It will display product data for a specific manufacturer and department(s)
It must include a dropdown menu in HTML to select the manufacturer and department we're interested in
If the results are large, they will be paginated (show only a certain number per page)
It will then allow the user to click a "generate" button
It will generate a csv named [url removed, login to view] and all columns will retain its current heading and be placed in the magento installation location in var/import
Speed optimizations will be included in the form of a temporary database (if needed).
I actually have a phpexcel script that converts xls to csv to get you started. I have attached a copy of a sample xls file.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online