| 5:41 pm on Jan 15, 2008 (gmt 0)|
What server technologies are you running? PHP, ASP(.Net)?
| 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.
| 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)?
| 6:13 pm on Jan 15, 2008 (gmt 0)|
I mean inserting into a form in Microsoft Word or Access.
| 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.
| 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.