Closed

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
Employer working
Project Budget
$30 - $250 USD
Total Bids
9
Project Description

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online