Suzanne wrote:
> We're developing a web site for a small multimedia developer. They want
> to be able to crunch the data from an file of orders similar to the one
> below into a customer database, and at the same time to be able to print
> out mailing labels. They would need to download each day's orders from a
> secure server. All the orders would be listed sequentially in one
> long file
> (and if it's like orders we get for Shrapnel, lots of blank
> orders would be
> submitted by people with itchy trigger fingers). They would like
> to be able
> to dump the data from a file of orders into a database, and at the same
> time to print mailing labels. They're using PCs, which I know
> nothing about
> and, I suppose, would need to use a database program such as Filemaker,
> which I know even less about.
>
> Can some kind, helpful soul out there tell me how the client
> would go about
> doing this? The clients are very computer literate, and I'm sure could
> figure it out if I could just tell them where to start. It would
> be nice it
> they didn't have to manually copy each separate order into a file of its
> own.
A few questions:
What type of server are they on?
Are they currently using a database on the server to save order records, or
are they just writing to a file? If they are writing to a file, is a copy of
the script being used available (sans any private info)?
> Also, the client wants the date of the order added automatically.
> How would
> one go about doing that? Can it somehow be done with the HTML
> setup for the
> form?
Dependably, you want to get the time from your server and save it to your
database or file when first saving the order. You could use javascript to
get the time from the user's machine, but they may have no javascript
ability, may have their time/date set wrong, etc...problems.
Your form below looks like an email. Are the orders currently just being
emailed to your client, or do they have some kind of web interface for
viewing orders? If so, is the interface something developed in-house, or is
it a third party (maybe the same one that does the credit card approval?)
thing? If it's a third party thing, is this a copy of a typical order as you
see it when you access the third party reports? If you're using a third
party, do they provide any daily reports of all sales? Does the third party
give you any options for selecting the format that you want to view your
orders in? Do they provide any downloadable files, or just viewing of
reports via the web?
Jack
> ******************************************************************
>
> Here's that sample order from Shrapnel's web site.
>
> From: Open Door Networks Webmaster <[EMAIL PROTECTED]>
> To: Shrapnel
> Subject:
> WDversion=Custom Secure Form
> WebDoorSSLRecipient=Shrapnel
> WebDoorNextLink=https://ssl.opendoor.com/Shrapnel/ThankYou.html
> Name=John Mogens Jacobsen
> StreetAddress=Frisegade 18 B, 3-th
> POBox=
> City=Nykxbing F.
> State=DK
> Zip=4800
> Phone=+45 54851796
> Fax=
> E-mail=
> Credit Card Number=XXXX XXXX XXXX XXXX
> Expiration Date=06/99 v
> Artist=Hoew II
> size==High Gear
> Quantity=2
> Item Number=sh-1044
> CD=on
> Artist=Howe II
> size==Now Hear This
> Quantity=2
> Item Number=SH-1053
> CD=on
> ShipToName=
> StreetAddress=
> POBox=
> City=
> State=
> Zip=
> Phone=
> Fax=
> Email=
>
____________________________________________________________________
--------------------------------------------------------------------
Join The Web Consultants Association : Register on our web site Now
Web Consultants Web Site : http://just4u.com/webconsultants
If you lose the instructions All subscription/unsubscribing can be done
directly from our website for all our lists.
---------------------------------------------------------------------
