Document (#42443)

Author

Suranofsky, M.
McColl, L.

Title

a Google sheets add-on that uses the WorldCat search API : MatchMarc

Source

Code4Lib journal. Issue 46(2019), [http://journal.code4lib.org]

Year

2019

Abstract

Lehigh University Libraries has developed a new tool for querying WorldCat using the WorldCat Search API. The tool is a Google Sheet Add-on and is available now via the Google Sheets Add-ons menu under the name "MatchMarc." The add-on is easily customizable, with no knowledge of coding needed. The tool will return a single "best" OCLC record number, and its bibliographic information for a given ISBN or LCCN, allowing the user to set up and define "best." Because all of the information, the input, the criteria, and the results exist in the Google Sheets environment, efficient workflows can be developed from this flexible starting point. This article will discuss the development of the add-on, how it works, and future plans for development.

Content

Vgl.: https://journal.code4lib.org/articles/14813.

Theme

Metadaten

Object

Google
MARC
WorldCat
MatchMarc

Similar documents (content)

1. Hodges, D.W.; Schlottmann, K.: better archival migration outcomes with Python and the Google Sheets API : Reporting from the archives (2019) 0.13

   0.13409886 = sum of:
     0.13409886 = product of:
       0.67049426 = sum of:
         0.03627722 = weight(abstract_txt:easily in 444) [ClassicSimilarity], result of:
           0.03627722 = score(doc=444,freq=1.0), product of:
             0.09590023 = queryWeight, product of:
               6.0524936 = idf(docFreq=283, maxDocs=44421)
               0.015844747 = queryNorm
             0.37828085 = fieldWeight in 444, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.0524936 = idf(docFreq=283, maxDocs=44421)
               0.0625 = fieldNorm(doc=444)
         0.041065108 = weight(abstract_txt:flexible in 444) [ClassicSimilarity], result of:
           0.041065108 = score(doc=444,freq=1.0), product of:
             0.104162715 = queryWeight, product of:
               1.0421886 = boost
               6.30784 = idf(docFreq=219, maxDocs=44421)
               0.015844747 = queryNorm
             0.39424 = fieldWeight in 444, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.30784 = idf(docFreq=219, maxDocs=44421)
               0.0625 = fieldNorm(doc=444)
         0.034188084 = weight(abstract_txt:developed in 444) [ClassicSimilarity], result of:
           0.034188084 = score(doc=444,freq=2.0), product of:
             0.092182145 = queryWeight, product of:
               1.3865278 = boost
               4.1959753 = idf(docFreq=1817, maxDocs=44421)
               0.015844747 = queryNorm
             0.37087533 = fieldWeight in 444, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.1959753 = idf(docFreq=1817, maxDocs=44421)
               0.0625 = fieldNorm(doc=444)
         0.10094473 = weight(abstract_txt:google in 444) [ClassicSimilarity], result of:
           0.10094473 = score(doc=444,freq=1.0), product of:
             0.3011661 = queryWeight, product of:
               3.5442407 = boost
               5.3628736 = idf(docFreq=565, maxDocs=44421)
               0.015844747 = queryNorm
             0.3351796 = fieldWeight in 444, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.3628736 = idf(docFreq=565, maxDocs=44421)
               0.0625 = fieldNorm(doc=444)
         0.4580191 = weight(abstract_txt:sheets in 444) [ClassicSimilarity], result of:
           0.4580191 = score(doc=444,freq=2.0), product of:
             0.5952277 = queryWeight, product of:
               4.315115 = boost
               8.705735 = idf(docFreq=19, maxDocs=44421)
               0.015844747 = queryNorm
             0.76948553 = fieldWeight in 444, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               8.705735 = idf(docFreq=19, maxDocs=44421)
               0.0625 = fieldNorm(doc=444)
       0.2 = coord(5/25)
   

2. Peek, R.: Web page design standards : Part 1: CCS (Cascading Style Sheets) is the cornerstone of standards to come (1998) 0.10

   0.10375842 = sum of:
     0.10375842 = product of:
       0.86465347 = sum of:
         0.023553498 = weight(abstract_txt:will in 6104) [ClassicSimilarity], result of:
           0.023553498 = score(doc=6104,freq=1.0), product of:
             0.07807355 = queryWeight, product of:
               1.276019 = boost
               3.8615482 = idf(docFreq=2539, maxDocs=44421)
               0.015844747 = queryNorm
             0.30168346 = fieldWeight in 6104, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.8615482 = idf(docFreq=2539, maxDocs=44421)
               0.078125 = fieldNorm(doc=6104)
         0.13990423 = weight(abstract_txt:sheet in 6104) [ClassicSimilarity], result of:
           0.13990423 = score(doc=6104,freq=1.0), product of:
             0.2032408 = queryWeight, product of:
               1.4557796 = boost
               8.811096 = idf(docFreq=17, maxDocs=44421)
               0.015844747 = queryNorm
             0.6883669 = fieldWeight in 6104, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               8.811096 = idf(docFreq=17, maxDocs=44421)
               0.078125 = fieldNorm(doc=6104)
         0.7011957 = weight(abstract_txt:sheets in 6104) [ClassicSimilarity], result of:
           0.7011957 = score(doc=6104,freq=3.0), product of:
             0.5952277 = queryWeight, product of:
               4.315115 = boost
               8.705735 = idf(docFreq=19, maxDocs=44421)
               0.015844747 = queryNorm
             1.1780293 = fieldWeight in 6104, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               8.705735 = idf(docFreq=19, maxDocs=44421)
               0.078125 = fieldNorm(doc=6104)
       0.12 = coord(3/25)
   

3. Nilges, C.: ¬The Online Computer Library Center's Open WorldCat program (2006) 0.10

   0.10058434 = sum of:
     0.10058434 = product of:
       0.8382029 = sum of:
         0.023959132 = weight(abstract_txt:search in 591) [ClassicSimilarity], result of:
           0.023959132 = score(doc=591,freq=1.0), product of:
             0.069929466 = queryWeight, product of:
               1.2076339 = boost
               3.654598 = idf(docFreq=3123, maxDocs=44421)
               0.015844747 = queryNorm
             0.34261855 = fieldWeight in 591, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.654598 = idf(docFreq=3123, maxDocs=44421)
               0.09375 = fieldNorm(doc=591)
         0.15141709 = weight(abstract_txt:google in 591) [ClassicSimilarity], result of:
           0.15141709 = score(doc=591,freq=1.0), product of:
             0.3011661 = queryWeight, product of:
               3.5442407 = boost
               5.3628736 = idf(docFreq=565, maxDocs=44421)
               0.015844747 = queryNorm
             0.5027694 = fieldWeight in 591, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.3628736 = idf(docFreq=565, maxDocs=44421)
               0.09375 = fieldNorm(doc=591)
         0.66282666 = weight(abstract_txt:worldcat in 591) [ClassicSimilarity], result of:
           0.66282666 = score(doc=591,freq=5.0), product of:
             0.42820644 = queryWeight, product of:
               3.6599689 = boost
               7.3839793 = idf(docFreq=74, maxDocs=44421)
               0.015844747 = queryNorm
             1.5479138 = fieldWeight in 591, product of:
               2.236068 = tf(freq=5.0), with freq of:
                 5.0 = termFreq=5.0
               7.3839793 = idf(docFreq=74, maxDocs=44421)
               0.09375 = fieldNorm(doc=591)
       0.12 = coord(3/25)
   

4. Theise, A.: Possibilities for standardized cataloging of prints : the collection of engravings at the Hamburg State and University Library (2016) 0.08

   0.07515548 = sum of:
     0.07515548 = product of:
       0.6262957 = sum of:
         0.023553498 = weight(abstract_txt:will in 125) [ClassicSimilarity], result of:
           0.023553498 = score(doc=125,freq=1.0), product of:
             0.07807355 = queryWeight, product of:
               1.276019 = boost
               3.8615482 = idf(docFreq=2539, maxDocs=44421)
               0.015844747 = queryNorm
             0.30168346 = fieldWeight in 125, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.8615482 = idf(docFreq=2539, maxDocs=44421)
               0.078125 = fieldNorm(doc=125)
         0.030218283 = weight(abstract_txt:developed in 125) [ClassicSimilarity], result of:
           0.030218283 = score(doc=125,freq=1.0), product of:
             0.092182145 = queryWeight, product of:
               1.3865278 = boost
               4.1959753 = idf(docFreq=1817, maxDocs=44421)
               0.015844747 = queryNorm
             0.3278106 = fieldWeight in 125, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.1959753 = idf(docFreq=1817, maxDocs=44421)
               0.078125 = fieldNorm(doc=125)
         0.5725239 = weight(abstract_txt:sheets in 125) [ClassicSimilarity], result of:
           0.5725239 = score(doc=125,freq=2.0), product of:
             0.5952277 = queryWeight, product of:
               4.315115 = boost
               8.705735 = idf(docFreq=19, maxDocs=44421)
               0.015844747 = queryNorm
             0.9618569 = fieldWeight in 125, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               8.705735 = idf(docFreq=19, maxDocs=44421)
               0.078125 = fieldNorm(doc=125)
       0.12 = coord(3/25)
   

5. Aydin, Ö.; Karaarslan, E.: OpenAI ChatGPT generated literature review: : digital twin in healthcare (2022) 0.07

   0.070431165 = sum of:
     0.070431165 = product of:
       0.2515399 = sum of:
         0.027997445 = weight(abstract_txt:input in 1852) [ClassicSimilarity], result of:
           0.027997445 = score(doc=1852,freq=1.0), product of:
             0.09774662 = queryWeight, product of:
               1.0095807 = boost
               6.110481 = idf(docFreq=267, maxDocs=44421)
               0.015844747 = queryNorm
             0.28642878 = fieldWeight in 1852, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.110481 = idf(docFreq=267, maxDocs=44421)
               0.046875 = fieldNorm(doc=1852)
         0.044830088 = weight(abstract_txt:allowing in 1852) [ClassicSimilarity], result of:
           0.044830088 = score(doc=1852,freq=2.0), product of:
             0.106184036 = queryWeight, product of:
               1.052252 = boost
               6.3687487 = idf(docFreq=206, maxDocs=44421)
               0.015844747 = queryNorm
             0.42219234 = fieldWeight in 1852, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.3687487 = idf(docFreq=206, maxDocs=44421)
               0.046875 = fieldNorm(doc=1852)
         0.011979566 = weight(abstract_txt:search in 1852) [ClassicSimilarity], result of:
           0.011979566 = score(doc=1852,freq=1.0), product of:
             0.069929466 = queryWeight, product of:
               1.2076339 = boost
               3.654598 = idf(docFreq=3123, maxDocs=44421)
               0.015844747 = queryNorm
             0.17130928 = fieldWeight in 1852, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.654598 = idf(docFreq=3123, maxDocs=44421)
               0.046875 = fieldNorm(doc=1852)
         0.028264197 = weight(abstract_txt:will in 1852) [ClassicSimilarity], result of:
           0.028264197 = score(doc=1852,freq=4.0), product of:
             0.07807355 = queryWeight, product of:
               1.276019 = boost
               3.8615482 = idf(docFreq=2539, maxDocs=44421)
               0.015844747 = queryNorm
             0.36202013 = fieldWeight in 1852, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               3.8615482 = idf(docFreq=2539, maxDocs=44421)
               0.046875 = fieldNorm(doc=1852)
         0.01813097 = weight(abstract_txt:developed in 1852) [ClassicSimilarity], result of:
           0.01813097 = score(doc=1852,freq=1.0), product of:
             0.092182145 = queryWeight, product of:
               1.3865278 = boost
               4.1959753 = idf(docFreq=1817, maxDocs=44421)
               0.015844747 = queryNorm
             0.19668634 = fieldWeight in 1852, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.1959753 = idf(docFreq=1817, maxDocs=44421)
               0.046875 = fieldNorm(doc=1852)
         0.044629063 = weight(abstract_txt:tool in 1852) [ClassicSimilarity], result of:
           0.044629063 = score(doc=1852,freq=1.0), product of:
             0.19237195 = queryWeight, product of:
               2.4531362 = boost
               4.9491973 = idf(docFreq=855, maxDocs=44421)
               0.015844747 = queryNorm
             0.23199362 = fieldWeight in 1852, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.9491973 = idf(docFreq=855, maxDocs=44421)
               0.046875 = fieldNorm(doc=1852)
         0.075708546 = weight(abstract_txt:google in 1852) [ClassicSimilarity], result of:
           0.075708546 = score(doc=1852,freq=1.0), product of:
             0.3011661 = queryWeight, product of:
               3.5442407 = boost
               5.3628736 = idf(docFreq=565, maxDocs=44421)
               0.015844747 = queryNorm
             0.2513847 = fieldWeight in 1852, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.3628736 = idf(docFreq=565, maxDocs=44421)
               0.046875 = fieldNorm(doc=1852)
       0.28 = coord(7/25)