Forums

Hello,

I've searched everywhere and I tried every EXT recommended but I found them all to be a little too complicated for my needs. Basically, I'm search for a way to import an excel file with 6 columns and about 700 rows into a form that can be used as an order form. The excel file is basically a listing of items someone can request from me with a check box at the end of each item, and I would like to offer that in Joomla as easily as possible so that it will email the customer and myself. There is no charge for the items so a shopping cart shouldn't be required (I think...) ChronoForms seems like it can do it, but has anyone done this before and can you tell a newb how to do it?

Any ideas would be greatly appreciated...

Thank you,

Jathor9000

Hi Jathor 9000,

There are a couple of possibilities here.

One is to export from your Excel file to a CSV file, upload that to your server and then use a little PHP to read the CSV file and turn it into rows of form inputs. This is quite practical - but a 700 row form is impracticably big for any normal user.

A better solution would be to import the CSV data into a Database table and then use the ChronoForms tools to read data from the table and create a paginated and/or filtered listing.

Bob