Welcome to WebmasterWorld Guest from 220.127.116.11
Forum Moderators: phranque
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.
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.
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.
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.