Thanks for the fast reply!
At this point, I know very little about the website proper (as it was
developed by someone else)... although I see it uses PHP, so perhaps there
is some sort of SQL going on there.
The only information I have is from the client (well, potential client - as
we are still in the proposing stage!) who simply gets an email message with
the data as the message content.
Prior to going forward (and estimating my cost to implement it) - I was
hoping to get some education as to the options available to me so I could
have a better idea of what I am dealing with.
The client understands that the web developer will most likely need to get
involved and make some changes to the site to accomodate my needs - but I
would like some input as to best practices etc. so I can make
recommendations that will work for me.
In answer to your questions:
The information is pretty time sensitive (ie: the website visitors should be
put into the local system ASAP) - but the information is not overly
sensitive (ie: no credit cards... or information that needs to be 100%
secure... just name, address etc.) as it is currently sent via plain-text
email.
Again, TIA,
Aliza
"Chuck Grimsby" <c.*******@worldnet.att.net.invalid> wrote in message
news:5v********************************@4ax.com...
This sort of depends more on what your client has access to on the
website, what the website "user" has access to, and how often data
needs to be transferred over.
CSV files are certainly one way, another is XML files, or even a
"shared" database (MSDE or SQL).
How "time critical" is the information? How "sensitive" is it? These
questions need to be addressed as well.
On Mon, 15 Nov 2004 19:06:09 GMT, "Aliza Klein"
<ab*****@optonline.net> wrote:A client of mine has a website with a standard "Contact Us" form page
withname, address etc.
The information is currently sent via email to the client and is then
dataentered into their Access (2000) system.
I am sure there is a better way of doing this.
I do not know if there is any CSV file or database file that resides
online,but assuming there is - is it possible to link/download information from
this online source and populate a local database?
The only way I can think of doing this is to save the online file as a
CSV,then import it into the table each time.
Hopefully someone out there has a better idea because my way is pretty
laborintensive to do on a regular basis (as they receive dozens of
web-contactsat a time).
--
A Wise Man Never Plays Leapfrog With A Unicorn.