Welcome to WebmasterWorld Guest from 54.163.23.73

Forum Moderators: phranque

Message Too Old, No Replies

Mapping spreadsheet to printable form

Calling data from a cell in excel file to a form

     

Kannasu

5:20 pm on Jan 15, 2008 (gmt 0)

5+ Year Member



Hello everyone, this is my first time posting here at Webmaster World.

I hope someone can help me find a solution to this problem.

I work for a company that handles online orders. When orders come in from our Virtual Cart I have to manually write the order on our sales order form. I have been thinking of ways to automatically take the data and map it to a printable sales sheet.

I can view orders in .csv format for easy importing into MS Excel. Is there anyway to take data from an Excel spreadsheet and put it into fields on a form. The orders are separated into sections like address, part number etc. When I import them to excel they are each in their own cells, I would just need to find a program that can take individual cells and map them to different fields in a form.

Thank you for taking the time to read, and for any advice you can give me.

ceestand

5:41 pm on Jan 15, 2008 (gmt 0)

5+ Year Member



What server technologies are you running? PHP, ASP(.Net)?

Kannasu

5:54 pm on Jan 15, 2008 (gmt 0)

5+ Year Member



Well this is just on my desktop, it's really not going through a server since we only get about 10 orders a day.

The Virtual Cart we use is cgi but it emails me the orders, that I view in .csv. I can't view the actual cgi because they aren't hosted on our server.

I'm not 100% sure when you ask me that question though.

ceestand

6:11 pm on Jan 15, 2008 (gmt 0)

5+ Year Member



When you say insert the Excel fields into a form, do you mean a web form on somebody else's site (in your web browser)?

Kannasu

6:13 pm on Jan 15, 2008 (gmt 0)

5+ Year Member



I mean inserting into a form in Microsoft Word or Access.

jtara

11:56 pm on Jan 15, 2008 (gmt 0)

WebmasterWorld Senior Member jtara is a WebmasterWorld Top Contributor of All Time 5+ Year Member



I would just need to find a program that can take individual cells and map them to different fields in a form.

Yes, there is such a program. It's called "Excel".

I'd suggest you start with the built-in help, and possibly buy a good book on Excel.

Sorry to be so curt, but there are a thousand ways to do this - there is no one best answer. But the best place to start is to learn a little Excel.

The whole PURPOSE of Excel is to rearrange and perform calculations on numbers. It's very existence is to solve the kind of problem you are trying to solve.

coopster

2:59 am on Jan 16, 2008 (gmt 0)

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member



Welcome to WebmasterWorld, Kannasu.

I would tend to agree, why not just use the features built-in to your software (Microsoft Word, for instance) to develop a form and then use the "mail merge" or other utilities to process your .csv files? Seems like your best option at this point. If not, the custom code that goes into a project such as this can get costly.