[Web4lib] capturing data from Amazon in an Access database

Leslie Johnston johnston at virginia.edu
Tue Jul 3 09:27:54 EDT 2007


A kludgy way might be to use the "Add to Library 
Thing" Firefox extension, build your set in LT, 
and take advantage of LIT's tab-delimited 
export.  It comes out in a table with categorized 
rows representing LT's structure for the records.

Leslie

At 05:36 AM 7/3/2007, John Fitzgibbon 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/

------------
Leslie Johnston
Head, Digital Access Services
University of Virginia Library
http://lib.virginia.edu/digital/
http://lib.virginia.edu/digital/das/
johnston at virginia.edu 



More information about the Web4lib mailing list