Amazon Function - andrewmca.xls

					  Amazon Function
  This spreadsheet contains two macros. The first one converts International Standard Book Numbers (ISBNs) which follow the 1
  function looks up various fields such as title and author in Amazon's database and returns the relevant value. This spreadsh
  books or to help a librarian of a small collection.

  The first step to using this spreadsheet is to register for a free Amazon Web Service (AWS) account and then register for a f
  http://aws.amazon.com/associates/
  This will give you an Amazon Access Key. The Amazon Access Key is 20 characters long and will give you free access to Ama
  user needs their own Amazon Access Key.
  Once you get that Key, enter it in the cell below. Then enter the ISBN 13s or ISBN 10s from the books you want to lookup.

  Amazon limits the lookups to 1 per second, and each attribute requires a separate look-up. Therefore it takes at least 19 secon
  Excel will recalculate the whole spreadsheet when you do certain actions, which will take a while if you have a lot of books.
  Tools -> Options ... -> Calculations and selecting "Manual". Then press "F9" on your keyboard to force a recalculation.

  The spreadsheet and some of the code was developed by Andrew Morgan and it is hosted at www.andrewm.ca/amazonfunction

  Credits:
  The ISBN13to10 code was adapted from:
  http://weblogs.asp.net/fmarguerie/archive/2007/12/23/isbn-13-to-isbn-10.aspx
  The Amazon Function was adapted from:
  http://www.s-anand.net/Web_lookup_using_Excel.html

  Disclaimer:
  Please keep in mind that some of the content that we make available to you through this application comes from Amazon Web S
  content and your use of it are subject to change and/or removal at any time.




                      = User input
                      = Formula output


Amazon Access Key

ISBN 13               ISNB 10                          Title
                                                       /a:ItemLookupResponse/a:Items/a:Item/a:Ite
                                                       mAttributes/a:Title




     9780764540721                #NAME?                                  #NAME?
     9780764539862                #NAME?                                  #NAME?
andard Book Numbers (ISBNs) which follow the 13 character standard (ISBN 31) to ISBN 10s. The second
and returns the relevant value. This spreadsheet is designed to help people create a list of their personal


ervice (AWS) account and then register for a free Amazon Associates Account. Both can be done here:

racters long and will give you free access to Amazon's database of books and other products. Sorry, each

SBN 10s from the books you want to lookup.

           up. Therefore it takes at least 19 seconds to look up all of the values listed below for one book.
ch will take a while if you have a lot of books. You can make Excel manually do calculations by going to
 n your keyboard to force a recalculation.

d it is hosted at www.andrewm.ca/amazonfunction.html




rough this application comes from Amazon Web Services. All such content is provided to you "as is." This




                       Author                Amazon Webpage                         Binding        DeweyDecimalNumber
                       /a:ItemLookupRespo /a:ItemLookupResponse/a:Items/a:I         /a:ItemLoo     /a:ItemLookupRespons
                       nse/a:Items/a:Item/a: tem/a:DetailPageURL                    kupRespon      e/a:Items/a:Item/a:Item
                       ItemAttributes/a:Auth                                        se/a:Items/    Attributes/a:DeweyDeci
                       or                                                           a:Item/a:Ite   malNumber
                                                                                    mAttributes
                                                                                    /a:Binding



                             #NAME?                         #NAME?                    #NAME?              #NAME?
                             #NAME?                         #NAME?                    #NAME?              #NAME?
Edition                   Label                     Manufacturer              Publisher
/a:ItemLookupRespons      /a:ItemLookupRespons      /a:ItemLookupRespons      /a:ItemLookupRespons
e/a:Items/a:Item/a:Item   e/a:Items/a:Item/a:Item   e/a:Items/a:Item/a:Item   e/a:Items/a:Item/a:Item
Attributes/a:Edition      Attributes/a:Label        Attributes/a:Manufactur   Attributes/a:Publisher
                                                    er




       #NAME?                    #NAME?                    #NAME?                    #NAME?
       #NAME?                    #NAME?                    #NAME?                    #NAME?
NumberOfPages        PublicationDate     Amount        CurrencyCode      FormattedPrice
/a:ItemLookupRe      /a:ItemLookupR      /a:ItemLo     /a:ItemLookup     /a:ItemLookupR
sponse/a:Items/a     esponse/a:Items     okupResp      Response/a:It     esponse/a:Item
:Item/a:ItemAttrib   /a:Item/a:ItemAtt   onse/a:Ite    ems/a:Item/a:It   s/a:Item/a:ItemA
utes/a:NumberOf      ributes/a:Publica   ms/a:Item/    emAttributes/a    ttributes/a:ListPr
Pages                tionDate            a:ItemAttri   :ListPrice/a:Cu   ice/a:Formatted
                                         butes/a:Li    rrencyCode        Price
                                         stPrice/a:
                                         Amount

    #NAME?               #NAME?          #NAME?           #NAME?             #NAME?
    #NAME?               #NAME?          #NAME?           #NAME?             #NAME?
Price Disclaimer
                 Browse 1          Browse 2         Browse 3                 SmallImage
                 /a:ItemLookupR    /a:ItemLookup    /a:ItemLookupRespon      /a:ItemLo
                 esponse/a:Items   Response/a:It    se/a:Items/a:Item/a:Br   okupResp
                 /a:Item/a:Brows   ems/a:Item/a:    owseNodes/a:Browse       onse/a:Ite
                 eNodes/a:Brows    BrowseNodes/     Node/a:Ancestors/a:B     ms/a:Item/
                 eNode/a:Name      a:BrowseNod      rowseNode/a:Ancesto      a:SmallIm
                                   e/a:Ancestors/   rs/a:BrowseNode/a:Na     age
                                   a:BrowseNod      me
                                   e/a:Name

8/1/2012 19:06      #NAME?           #NAME?               #NAME?             #NAME?
                    #NAME?           #NAME?               #NAME?             #NAME?
MediumImageLargeImage
/a:ItemLo /a:ItemLookupResponse/a:Items/a:Item/a:LargeImage
okupResp
onse/a:Ite
ms/a:Item/
a:MediumI
mage



#NAME?                                     #NAME?
#NAME?                                     #NAME?

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:0
posted:8/2/2012
language:
pages:7
zhaonedx zhaonedx http://
About