By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,173 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,173 IT Pros & Developers. It's quick & easy.

Grabbing data from an online source and copy to local database?

P: n/a
Hi.

A client of mine has a website with a standard "Contact Us" form page with
name, address etc.

The information is currently sent via email to the client and is then data
entered 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 labor
intensive to do on a regular basis (as they receive dozens of web-contacts
at a time).

Thanks in advance,
Aliza

--
-----------------------------------
Aliza Klein
ab*****@optonline.net
-----------------------------------
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.