[Web4lib] capturing data from Amazon in an Access database

Ross Singer ross.singer at library.gatech.edu
Tue Jul 3 07:43:36 EDT 2007


John,

Is the information you're talking about not available via the AWS
ECommerce service?
http://docs.amazonwebservices.com/AWSECommerceService/2007-06-13/DG/ListSearch.html

http://docs.amazonwebservices.com/AWSECommerceService/2007-06-13/DG/

-Ross.

On 7/3/07, John Fitzgibbon <jfitzgibbon at galwaylibrary.ie> wrote:
> 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