Connecting Tech Pros Worldwide Forums | Help | Site Map

? How to populate database with online data ?

HalifaxPinball
Guest
 
Posts: n/a
#1: Nov 13 '05
I want to collect data about some music in a database. Few tricky things
that I have questions about...

I'd like to start to populate the database with some info from a website.
The web site is fed from another database that I do not have direct access
to. I'd like to populate my lists such as genre, artist name, and song
title. I'd also like to grab a thumbnail of the album cover, and in some
cases an MP3 clip from the album. Can I automate this or does it have to be
done by cut and paste? I would then fill in my own data such as higher
resolution scans of the album cover and other MP3's

Just as tricky, I'd like the database to create folders for me based on the
genre, artist, and album name so that I can keep the info organized.

Then, to shoot for the moon, I'd like to share the database structure with
friends so that my database will then correlate and fill in info from their
databases.

I'm sure this is asking alot but it seems so practical that maybe someone
has somehting like this already set up?

Thanks in advance..
Greg



Tom van Stiphout
Guest
 
Posts: n/a
#2: Nov 13 '05

re: ? How to populate database with online data ?


On Mon, 10 Jan 2005 02:54:37 GMT, "HalifaxPinball"
<HalifaxPinballNOSPAM@NOSPAMhotmail.com> wrote:

You can use a webbrowser control on your form, navigate to the URL
you're interested in, and use code like
http://support.microsoft.com/default...b;en-us;238313 to
access the DOM and extract what you need.

-Tom.

[color=blue]
>I want to collect data about some music in a database. Few tricky things
>that I have questions about...
>
>I'd like to start to populate the database with some info from a website.
>The web site is fed from another database that I do not have direct access
>to. I'd like to populate my lists such as genre, artist name, and song
>title. I'd also like to grab a thumbnail of the album cover, and in some
>cases an MP3 clip from the album. Can I automate this or does it have to be
>done by cut and paste? I would then fill in my own data such as higher
>resolution scans of the album cover and other MP3's
>
>Just as tricky, I'd like the database to create folders for me based on the
>genre, artist, and album name so that I can keep the info organized.
>
>Then, to shoot for the moon, I'd like to share the database structure with
>friends so that my database will then correlate and fill in info from their
>databases.
>
>I'm sure this is asking alot but it seems so practical that maybe someone
>has somehting like this already set up?
>
>Thanks in advance..
>Greg
>[/color]

Closed Thread