dbTalk Databases Forums  

Would Filemaker be Good For?

comp.databases.filemaker comp.databases.filemaker


Discuss Would Filemaker be Good For? in the comp.databases.filemaker forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Sug
 
Posts: n/a

Default Re: Would Filemaker be Good For? - 12-05-2005 , 03:01 PM






Matt -

I'd love to be able to grab album covers from the web for my tunes
database, but I haven't found a source with a predictable naming
convention. I have no problem getting the db to automatically look for
album cover art on Google, Sloth Radio or All Music, but then I have to
manually copy the image to the db. How do you use yooWeb to do it
automatically? Let me know. It'd be a big time saver.

Thanks in advance.

-S.


Reply With Quote
  #12  
Old   
Matt Wills
 
Posts: n/a

Default Re: Would Filemaker be Good For? - 12-05-2005 , 07:56 PM






Either YooWeb or Troi URL work great if you have a specific thing to
pull in repeatedly. For instance, I am experimenting with YooWeb to
grab the home page of x-rates.com, from which I can parse out the
current US/Canadian exange rates. A script runs to do that as the file
opens, and it works like a charm in that scheme. The page is always in
the same place, and the rates are always preceded by the same patterns:
USD/CAD or CAD/USD.

Grabbing album covers, though, would be a bit more involved. There will
still be a certain amount of manual selection, given the number of
returns one gets when searching for an artist or an album title.

What would have to happen:

Get the text of the page containing album you want. With that text in a
holding field, parse out the location of the image. You would need to
look for a pattern to know where the image url is in the page:

The Beatles "Revolver"

http://image.allmusic.com/00/amg/cov...529398u89k.jpg

Manhattan Transfer "Offbeat of Avenues"

http://image.allmusic.com/00/amg/cov...437235j49m.jpg

"O Brother, Where Art Thou" Soundtrack:

http://image.allmusic.com/00/amg/cov...69667z3kre.jpg

Rafael Kubelik conducting the Belgian Radio Symphony Orchestra in
Mozart's Symphonies 40 & 41:

http://image.allmusic.com/00/acg/cov...07548f98bq.jpg

Basia "Time and Tide"

http://image.allmusic.com/00/amg/cov...74792v9y9f.jpg

(Yes, all in my collection)

So far, they all begin with "http://image.allmusic.com/00/" and end
with ".jpg". No telling what others may be until you run across them.

But, for the moment, parse out the text from "http" to ".jpg" and give
that to YooWeb to retrieve the image.

In the end, it is probably easier to simply copy the image and paste it
into your container field.

Matt

Sug wrote:

Quote:
Matt -

I'd love to be able to grab album covers from the web for my tunes
database, but I haven't found a source with a predictable naming
convention. I have no problem getting the db to automatically look
for album cover art on Google, Sloth Radio or All Music, but then I
have to manually copy the image to the db. How do you use yooWeb to
do it automatically? Let me know. It'd be a big time saver.

Thanks in advance.

-S.


--



Reply With Quote
  #13  
Old   
Sug
 
Posts: n/a

Default Re: Would Filemaker be Good For? - 12-05-2005 , 08:01 PM



I see what you're up to here. Good one. Thanks.


Reply With Quote
  #14  
Old   
Hwy101
 
Posts: n/a

Default Re: Would Filemaker be Good For? - 12-05-2005 , 08:50 PM



Thanks Matt - Think I'll lobby for 6 :-) Tom

Matt Wills wrote:
Quote:
YoWeeb is presently 7 only, but the developer implies that they might
put out a 6 version if there was enough interest. That probably doesn't
help you. http://www.YooPlugs.com.

Meanwhile, a similar plug is available (Troi URL) that has been out
there since 5/6. Slightly more expensive. http://www.troi.com

Matt

Hwy101 wrote:


Bill, this 'yooWeb plug-in' work with Filemaker 6?
(Thanks Everyone for the Ideas -Still Learning what I need, and can,
Do.

Tom

Bill Marriott wrote:

Ok, sometimes Site A has the pic you want, sometimes Site B has the
pic you want, and sometimes it's found out in the wild blue yonder
on Google. You never have a predictable URL to use.

So you write a script to have your yooWeb plug-in take the contents
of the artist field and album field, then perform multiple
searches for them on multiple sites. Aggregate and distill the
results (often in a predictable format) so that you have a list of
pictures, which you can then browse through and click the one you
want to use. That one gets put into your container field.

Clearer?

"Matt Wills" <Im (AT) Witz (DOT) End> wrote in message

news:M%Ckf.1390$ew5.1195 (AT) trndny04 (DOT) ..

Not sure I'm following you.

Presently, I will go to AllMusic.com or sometimes CDNow.com,
search for the album, copy the image and paste it into the FM
container.

Matt

Bill Marriott wrote:



Here's an idea... why not do a search for the artist and or
album name on Google images, snag the results page and present
in FileMaker... then click on the image you want to use as
cover art?

"Matt Wills" <Im (AT) Witz (DOT) End> wrote in message
news:3zzkf.657$605.104 (AT) trndny09 (DOT) ..


Hwy101 wrote:



Data Base for Books -to go out to the Internet get Book
Cover Picture and put on a Card for the Book?

No reason not.

I am presently doing a similar project for my music. With
several hundred CDs in a jukebox, I don't have the jewel
cases handy to refer to for song selection. I am grabbing
cover art and song titles, sometimes from more than one
source. The end result will be a printed reference in a
three-ring binder.

With a lot of records, it is somewhat time consuming to do it
manually. If you can rely on a good source for the images
(that is to say, one which has a consistent and predictable
naming convention for the images) you might consider a plugin
like yooWeb, which can retrieve an image from the internet
and place it in a container field (in addition to the
complete text of a web page).

Matt



--








Reply With Quote
  #15  
Old   
Hwy101
 
Posts: n/a

Default Re: Would Filemaker be Good For? - 12-05-2005 , 09:03 PM



Matt, is there a Demo Period and some examples to work from?

Matt Wills wrote:
Quote:
Either YooWeb or Troi URL work great if you have a specific thing to
pull in repeatedly. For instance, I am experimenting with YooWeb to
grab the home page of x-rates.com, from which I can parse out the
current US/Canadian exange rates. A script runs to do that as the file
opens, and it works like a charm in that scheme. The page is always in
the same place, and the rates are always preceded by the same patterns:
USD/CAD or CAD/USD.

Grabbing album covers, though, would be a bit more involved. There will
still be a certain amount of manual selection, given the number of
returns one gets when searching for an artist or an album title.

What would have to happen:

Get the text of the page containing album you want. With that text in a
holding field, parse out the location of the image. You would need to
look for a pattern to know where the image url is in the page:

The Beatles "Revolver"

http://image.allmusic.com/00/amg/cov...529398u89k.jpg

Manhattan Transfer "Offbeat of Avenues"

http://image.allmusic.com/00/amg/cov...437235j49m.jpg

"O Brother, Where Art Thou" Soundtrack:

http://image.allmusic.com/00/amg/cov...69667z3kre.jpg

Rafael Kubelik conducting the Belgian Radio Symphony Orchestra in
Mozart's Symphonies 40 & 41:

http://image.allmusic.com/00/acg/cov...07548f98bq.jpg

Basia "Time and Tide"

http://image.allmusic.com/00/amg/cov...74792v9y9f.jpg

(Yes, all in my collection)

So far, they all begin with "http://image.allmusic.com/00/" and end
with ".jpg". No telling what others may be until you run across them.

But, for the moment, parse out the text from "http" to ".jpg" and give
that to YooWeb to retrieve the image.

In the end, it is probably easier to simply copy the image and paste it
into your container field.

Matt

Sug wrote:


Matt -

I'd love to be able to grab album covers from the web for my tunes
database, but I haven't found a source with a predictable naming
convention. I have no problem getting the db to automatically look
for album cover art on Google, Sloth Radio or All Music, but then I
have to manually copy the image to the db. How do you use yooWeb to
do it automatically? Let me know. It'd be a big time saver.

Thanks in advance.

-S.





Reply With Quote
  #16  
Old   
Matt Wills
 
Posts: n/a

Default Re: Would Filemaker be Good For? - 12-06-2005 , 05:24 AM



One of those typical nags that gives you a choice of registering or
doing it later. It says 30 days, and gives you a countdown.

http://www.yooplugs.com/products/1

Matt

Hwy101 wrote:

Quote:
Matt, is there a Demo Period and some examples to work from?

Matt Wills wrote:
Either YooWeb or Troi URL work great if you have a specific thing to
pull in repeatedly. For instance, I am experimenting with YooWeb to
grab the home page of x-rates.com, from which I can parse out the
current US/Canadian exange rates. A script runs to do that as the
file opens, and it works like a charm in that scheme. The page is
always in the same place, and the rates are always preceded by the
same patterns: USD/CAD or CAD/USD.

Grabbing album covers, though, would be a bit more involved. There
will still be a certain amount of manual selection, given the
number of returns one gets when searching for an artist or an album
title.

What would have to happen:

Get the text of the page containing album you want. With that text
in a holding field, parse out the location of the image. You would
need to look for a pattern to know where the image url is in the
page:

The Beatles "Revolver"

http://image.allmusic.com/00/amg/cov...529398u89k.jpg

Manhattan Transfer "Offbeat of Avenues"

http://image.allmusic.com/00/amg/cov...437235j49m.jpg

"O Brother, Where Art Thou" Soundtrack:

http://image.allmusic.com/00/amg/cov...69667z3kre.jpg

Rafael Kubelik conducting the Belgian Radio Symphony Orchestra in
Mozart's Symphonies 40 & 41:

http://image.allmusic.com/00/acg/cov...07548f98bq.jpg

Basia "Time and Tide"

http://image.allmusic.com/00/amg/cov...74792v9y9f.jpg

(Yes, all in my collection)

So far, they all begin with "http://image.allmusic.com/00/" and end
with ".jpg". No telling what others may be until you run across
them.

But, for the moment, parse out the text from "http" to ".jpg" and
give that to YooWeb to retrieve the image.

In the end, it is probably easier to simply copy the image and
paste it into your container field.

Matt

Sug wrote:


Matt -

I'd love to be able to grab album covers from the web for my tunes
database, but I haven't found a source with a predictable naming
convention. I have no problem getting the db to automatically
look for album cover art on Google, Sloth Radio or All Music, but
then I have to manually copy the image to the db. How do you use
yooWeb to do it automatically? Let me know. It'd be a big time
saver.

Thanks in advance.

-S.






--



Reply With Quote
  #17  
Old   
Matt Wills
 
Posts: n/a

Default Re: Would Filemaker be Good For? - 12-06-2005 , 05:25 AM



Oops, sorry.

Yes, there is a good example file.

Matt

Matt Wills wrote:

Quote:
One of those typical nags that gives you a choice of registering or
doing it later. It says 30 days, and gives you a countdown.

http://www.yooplugs.com/products/1

Matt

Hwy101 wrote:

Matt, is there a Demo Period and some examples to work from?

Matt Wills wrote:
Either YooWeb or Troi URL work great if you have a specific thing
to pull in repeatedly. For instance, I am experimenting with
YooWeb to grab the home page of x-rates.com, from which I can
parse out the current US/Canadian exange rates. A script runs to
do that as the file opens, and it works like a charm in that
scheme. The page is always in the same place, and the rates are
always preceded by the same patterns: USD/CAD or CAD/USD.

Grabbing album covers, though, would be a bit more involved. There
will still be a certain amount of manual selection, given the
number of returns one gets when searching for an artist or an
album title.

What would have to happen:

Get the text of the page containing album you want. With that text
in a holding field, parse out the location of the image. You would
need to look for a pattern to know where the image url is in the
page:

The Beatles "Revolver"

http://image.allmusic.com/00/amg/cov...c529398u89k.jp
g

Manhattan Transfer "Offbeat of Avenues"

http://image.allmusic.com/00/amg/cov...c437235j49m.jp
g

"O Brother, Where Art Thou" Soundtrack:

http://image.allmusic.com/00/amg/cov...f69667z3kre.jp
g

Rafael Kubelik conducting the Belgian Radio Symphony Orchestra in
Mozart's Symphonies 40 & 41:

http://image.allmusic.com/00/acg/cov...07548f98bq.jpg

Basia "Time and Tide"

http://image.allmusic.com/00/amg/cov...f74792v9y9f.jp
g

(Yes, all in my collection)

So far, they all begin with "http://image.allmusic.com/00/" and
end with ".jpg". No telling what others may be until you run
across them.

But, for the moment, parse out the text from "http" to ".jpg" and
give that to YooWeb to retrieve the image.

In the end, it is probably easier to simply copy the image and
paste it into your container field.

Matt

Sug wrote:


Matt -

I'd love to be able to grab album covers from the web for my
tunes database, but I haven't found a source with a predictable
naming convention. I have no problem getting the db to
automatically look for album cover art on Google, Sloth Radio
or All Music, but then I have to manually copy the image to the
db. How do you use yooWeb to do it automatically? Let me
know. It'd be a big time saver.

Thanks in advance.

-S.






--



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.