XLS to CSV conversion in PHP/SQL

  • Status Closed
  • 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.

Get free quotes for a project like this

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