[Web4lib] capturing data from Amazon in an Access database

Pons, Lisa (ponslm) PONSLM at UCMAIL.UC.EDU
Tue Jul 3 11:35:17 EDT 2007


The first thing that popped into my head was to use the "wishlist" function- that is, mark your purchases to the wishlist, then use a script to get that.

Doing a quick google search I did find:
http://www.splintered.co.uk/experiments/85/

Would this be a starting point?

-----Original Message-----
From: web4lib-bounces at webjunction.org on behalf of John Fitzgibbon
Sent: Tue 7/3/2007 5:36 AM
To: web4lib at webjunction.org
Subject: [Web4lib] capturing data from Amazon in an Access database
 
Hi,

In the old days when we compiled order lists we used Whitaker's Books in
Print on Cd-Rom and this allowed us to save a record into a text file
with fields delimited by commas and records delimited by carriage
returns. I believe that the US equivalent, Bowker, offered the same
functionality.

Now, we are using Amazon more and more. However, when we find a record
in Amazon there is no easy way of saving it into Access or Excel.

I don't think XML along with XSLT can be used because authors, titles,
and prices are not indicated with any special tags on the 'wish list' or
'shopping cart' pages of Amazon. For example, authors are not delineated
with <span class='author'> or some such tag.

Also, there is no RSS feed which would provide us with a ready made XML
page of the results.

Copying and pasting into Excel seems very cumbersome.

When I first considered some solutions to the problem the problem seemed
very trivial but now, that these solutions won't work, I am at a loss.

If only more web pages were based on XML...

I would welcome any ideas.

Regards
John

John Fitzgibbon

p: 00 353 91 562471
f: 00 353 91 565039
w: http://www.galwaylibrary.ie 

******************************************************************* 
Tá eolas atá príobháideach agus rúnda sa ríomhphost seo 
agus aon iatán a ghabhann leis agus is leis an duine/na daoine
sin amháin a bhfuil siad seolta chucu a bhaineann siad. 
Mura seolaí thú, níl tú údaraithe an ríomhphost nó aon iatán 
a ghabhann leis a léamh, a chóipáil ná a úsáid. 
Má tá an ríomhphost seo faighte agat trí dhearmad, 
cuir an seoltóir ar an eolas thrí aischur ríomhphoist 
agus scrios ansin é le do thoil. 

This e-mail and any attachment contains information which is 
private and confidential and is intended for the addressee 
only. If you are not an addressee, you are not authorised 
to read, copy or use the e-mail or any attachment. 
If you have received this e-mail in error, please notify 
the sender by return e-mail and then destroy it. 
*********************************************************************
_______________________________________________
Web4lib mailing list
Web4lib at webjunction.org
http://lists.webjunction.org/web4lib/



More information about the Web4lib mailing list