homepage Welcome to WebmasterWorld Guest from 54.166.111.111
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member
Visit PubCon.com
Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
Forum Library, Charter, Moderators: phranque

Website Technology Issues Forum

    
Mapping spreadsheet to printable form
Calling data from a cell in excel file to a form
Kannasu




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

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




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

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

Kannasu




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

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




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

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




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

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

jtara




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

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




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

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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Hardware and OS Related Technologies / Website Technology Issues
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved