Need help with Access/HTML

[NimBiotics]

I'm a VBA programmer, barely starting to scratch the surface of html.

I've got almost 1000 pictures on snapfish.com whose originals I lost. Being
that many, it would take me way too long to save them all manually so I
thought there must be a way to crawl my albums in order to download all
pictures.

I can access a page where all albums can be seen. Each album has a link
like:
http://www2.snapfish.com/thumbnailshare/AlbumID=166196409/a=22438844_22438844/t_=22438844

Every thumbnail in an album has a link like:
javascript:gotoSlideShow('http://www2.snapfish.com/slideshow/...ID=3331611788/a=22438844_22438844/t_=22438844')

And I can open the page:
http://www2.snapfish.com/slideshow/...ID=3331611788/a=22438844_22438844/t_=22438844

Finally, this link on the page shows the picture I need to save:
http://render1.snapfish.com/render2...?*KUp7BHSHqqy7XH6gXPeQ|Rup6lQQ|/of=50,590,442

Can anybody please give me a hint on how can I do this, if at all possible?

Please keep in mind that it's MS Access and VBA I know how to use best, but
I could try VBA.

 

[MedMan1]

I'm a VBA programmer, barely starting to scratch the surface of html.

I've got almost 1000 pictures on snapfish.com whose originals I lost.
Being that many, it would take me way too long to save them all manually
so I thought there must be a way to crawl my albums in order to download
all pictures.

I can access a page where all albums can be seen. Each album has a link
like:
http://www2.snapfish.com/thumbnailshare/AlbumID=166196409/a=22438844_22438844/t_=22438844

Every thumbnail in an album has a link like:
javascript:gotoSlideShow('http://www2.snapfish.com/slideshow/...ID=3331611788/a=22438844_22438844/t_=22438844')

And I can open the page:
http://www2.snapfish.com/slideshow/...ID=3331611788/a=22438844_22438844/t_=22438844

Finally, this link on the page shows the picture I need to save:
http://render1.snapfish.com/render2...?*KUp7BHSHqqy7XH6gXPeQ|Rup6lQQ|/of=50,590,442

Can anybody please give me a hint on how can I do this, if at all
possible?

Please keep in mind that it's MS Access and VBA I know how to use best,
but I could try VBA.

 

[MikeR]

I'm a VBA programmer, barely starting to scratch the surface of html.

I've got almost 1000 pictures on snapfish.com whose originals I lost.
Being that many, it would take me way too long to save them all manually
so I thought there must be a way to crawl my albums in order to download
all pictures.

I can access a page where all albums can be seen. Each album has a link
like:
http://www2.snapfish.com/thumbnailshare/AlbumID=166196409/a=22438844_22438844/t_=22438844


Every thumbnail in an album has a link like:
javascript:gotoSlideShow('http://www2.snapfish.com/slideshow/...ID=3331611788/a=22438844_22438844/t_=22438844')


And I can open the page:
http://www2.snapfish.com/slideshow/...ID=3331611788/a=22438844_22438844/t_=22438844


Finally, this link on the page shows the picture I need to save:
http://render1.snapfish.com/render2...?*KUp7BHSHqqy7XH6gXPeQ|Rup6lQQ|/of=50,590,442


Can anybody please give me a hint on how can I do this, if at all possible?

Please keep in mind that it's MS Access and VBA I know how to use best,
but I could try VBA.

I don't see the connection this has to Access, but here's some info.

If you can view the page, you have already downloaded the pictures. If you use
Internet Explorer here's how to find them.
http://compnetworking.about.com/od/windowsnetworking/ht/findtempfiles.htm

To cut down the number you'll have to wade thru, delete the temporary files before
you go to the website, using whichever browser you use.

HTH
Mike

 

[NimBiotics]

Thanks a lot for your answer Mike,

I don't see the connection this has to Access, but here's some info.

The only reason I post this question here is because I can program with VBA,
but I don't quite yet bite into HTML. I think that probably somebody here
might have had to do something similar to what I need.

If you can view the page, you have already downloaded the pictures. If you
use Internet Explorer here's how to find them.

I definetly cannot find the file(s) in the temp directory, but I've opened
the link
http://render1.snapfish.com/render2...?*KUp7BHSHqqy7XH6gXPeQ|Rup6lQQ|/of=50,590,442
And I've been able to save the image.

I think what I'm missing here is a way to control ie or ff so I can open
each album, traverse it's links and open them so I can "save to" each image.
I wouldn't want to do that manually for 1000 images ...
I've been doing some research on the net and now I can there's an
internetexplorer object I can create, I just don't know all the methods I
can use.

 

[MikeR]

Thanks a lot for your answer Mike,

The only reason I post this question here is because I can program with
VBA, but I don't quite yet bite into HTML. I think that probably
somebody here might have had to do something similar to what I need.

I definetly cannot find the file(s) in the temp directory, but I've
opened the link
http://render1.snapfish.com/render2...?*KUp7BHSHqqy7XH6gXPeQ|Rup6lQQ|/of=50,590,442

And I've been able to save the image.

I think what I'm missing here is a way to control ie or ff so I can open
each album, traverse it's links and open them so I can "save to" each
image. I wouldn't want to do that manually for 1000 images ...
I've been doing some research on the net and now I can there's an
internetexplorer object I can create, I just don't know all the methods
I can use.

That image is somewhere in your temporary internet files.
What you want to do is far from a trivial task. Do-able almost certainly. You would
have to load the page into a string variable, then parse it to find the image you're
looking for, then download and save it. There may be other ways. The first hurdle is
finding the link to the image.

On a web page, the html for displaying an image is:

<img
src="http://static.snapfish.com/MD5=d41d8cd98f00b204e9800998ecf8427e/default/images/spacer.gif"
border=0 width=20 height=1>

which displays an image called 'spacer.gif'
which came from the link below. You can see it by right clicking on the page and then
choose 'View source". Search the page for
http://www2.snapfish.com/viewshared...C;jsessionid=6DED084E8596A6089477388AB951CA81

As you can see, there are a TON on the img tags. Finding the correct tag is the
problem. Looks like the site is somehow mangling the name of the pic of the Jeep.

You can use wininet.dll for the internet interaction. Some details may be found here.
http://msdn.microsoft.com/en-us/library/aa385473.aspx
At a minimum you'll need to call InternetOpen, InternetConnect, InternetReadFile
Google for wininet and VB or VBA.
I can't help with the syntax, I don't program in VB.

Is there perhaps a UI on your SnapFish account?

HTH
Mike