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.13402121 = sum of:
     0.13402121 = product of:
       0.670106 = sum of:
         0.036263872 = weight(abstract_txt:easily in 5444) [ClassicSimilarity], result of:
           0.036263872 = score(doc=5444,freq=1.0), product of:
             0.095881626 = queryWeight, product of:
               6.0514402 = idf(docFreq=282, maxDocs=44218)
               0.01584443 = queryNorm
             0.37821501 = fieldWeight in 5444, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.0514402 = idf(docFreq=282, maxDocs=44218)
               0.0625 = fieldNorm(doc=5444)
         0.04098204 = weight(abstract_txt:flexible in 5444) [ClassicSimilarity], result of:
           0.04098204 = score(doc=5444,freq=1.0), product of:
             0.10402755 = queryWeight, product of:
               1.0416132 = boost
               6.30326 = idf(docFreq=219, maxDocs=44218)
               0.01584443 = queryNorm
             0.39395374 = fieldWeight in 5444, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.30326 = idf(docFreq=219, maxDocs=44218)
               0.0625 = fieldNorm(doc=5444)
         0.03418919 = weight(abstract_txt:developed in 5444) [ClassicSimilarity], result of:
           0.03418919 = score(doc=5444,freq=2.0), product of:
             0.09218887 = queryWeight, product of:
               1.3867129 = boost
               4.195805 = idf(docFreq=1809, maxDocs=44218)
               0.01584443 = queryNorm
             0.37086028 = fieldWeight in 5444, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               4.195805 = idf(docFreq=1809, maxDocs=44218)
               0.0625 = fieldNorm(doc=5444)
         0.101303875 = weight(abstract_txt:google in 5444) [ClassicSimilarity], result of:
           0.101303875 = score(doc=5444,freq=1.0), product of:
             0.3018955 = queryWeight, product of:
               3.5488744 = boost
               5.3689504 = idf(docFreq=559, maxDocs=44218)
               0.01584443 = queryNorm
             0.3355594 = fieldWeight in 5444, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.3689504 = idf(docFreq=559, maxDocs=44218)
               0.0625 = fieldNorm(doc=5444)
         0.457367 = weight(abstract_txt:sheets in 5444) [ClassicSimilarity], result of:
           0.457367 = score(doc=5444,freq=2.0), product of:
             0.5946931 = queryWeight, product of:
               4.3135953 = boost
               8.701155 = idf(docFreq=19, maxDocs=44218)
               0.01584443 = queryNorm
             0.7690807 = fieldWeight in 5444, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               8.701155 = idf(docFreq=19, maxDocs=44218)
               0.0625 = fieldNorm(doc=5444)
       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.10361493 = sum of:
     0.10361493 = product of:
       0.86345774 = sum of:
         0.023552729 = weight(abstract_txt:will in 5104) [ClassicSimilarity], result of:
           0.023552729 = score(doc=5104,freq=1.0), product of:
             0.078075856 = queryWeight, product of:
               1.2761616 = boost
               3.8613079 = idf(docFreq=2528, maxDocs=44218)
               0.01584443 = queryNorm
             0.30166468 = fieldWeight in 5104, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.8613079 = idf(docFreq=2528, maxDocs=44218)
               0.078125 = fieldNorm(doc=5104)
         0.13970767 = weight(abstract_txt:sheet in 5104) [ClassicSimilarity], result of:
           0.13970767 = score(doc=5104,freq=1.0), product of:
             0.20306082 = queryWeight, product of:
               1.455276 = boost
               8.806516 = idf(docFreq=17, maxDocs=44218)
               0.01584443 = queryNorm
             0.688009 = fieldWeight in 5104, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               8.806516 = idf(docFreq=17, maxDocs=44218)
               0.078125 = fieldNorm(doc=5104)
         0.70019734 = weight(abstract_txt:sheets in 5104) [ClassicSimilarity], result of:
           0.70019734 = score(doc=5104,freq=3.0), product of:
             0.5946931 = queryWeight, product of:
               4.3135953 = boost
               8.701155 = idf(docFreq=19, maxDocs=44218)
               0.01584443 = queryNorm
             1.1774095 = fieldWeight in 5104, product of:
               1.7320508 = tf(freq=3.0), with freq of:
                 3.0 = termFreq=3.0
               8.701155 = idf(docFreq=19, maxDocs=44218)
               0.078125 = fieldNorm(doc=5104)
       0.12 = coord(3/25)
   

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

   0.100521915 = sum of:
     0.100521915 = product of:
       0.83768266 = sum of:
         0.024030838 = weight(abstract_txt:search in 5591) [ClassicSimilarity], result of:
           0.024030838 = score(doc=5591,freq=1.0), product of:
             0.07007252 = queryWeight, product of:
               1.2089857 = boost
               3.6580524 = idf(docFreq=3098, maxDocs=44218)
               0.01584443 = queryNorm
             0.34294242 = fieldWeight in 5591, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.6580524 = idf(docFreq=3098, maxDocs=44218)
               0.09375 = fieldNorm(doc=5591)
         0.15195581 = weight(abstract_txt:google in 5591) [ClassicSimilarity], result of:
           0.15195581 = score(doc=5591,freq=1.0), product of:
             0.3018955 = queryWeight, product of:
               3.5488744 = boost
               5.3689504 = idf(docFreq=559, maxDocs=44218)
               0.01584443 = queryNorm
             0.5033391 = fieldWeight in 5591, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.3689504 = idf(docFreq=559, maxDocs=44218)
               0.09375 = fieldNorm(doc=5591)
         0.661696 = weight(abstract_txt:worldcat in 5591) [ClassicSimilarity], result of:
           0.661696 = score(doc=5591,freq=5.0), product of:
             0.42774132 = queryWeight, product of:
               3.6583354 = boost
               7.3793993 = idf(docFreq=74, maxDocs=44218)
               0.01584443 = queryNorm
             1.5469537 = fieldWeight in 5591, product of:
               2.236068 = tf(freq=5.0), with freq of:
                 5.0 = termFreq=5.0
               7.3793993 = idf(docFreq=74, maxDocs=44218)
               0.09375 = fieldNorm(doc=5591)
       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.075057685 = sum of:
     0.075057685 = product of:
       0.6254807 = sum of:
         0.023552729 = weight(abstract_txt:will in 5125) [ClassicSimilarity], result of:
           0.023552729 = score(doc=5125,freq=1.0), product of:
             0.078075856 = queryWeight, product of:
               1.2761616 = boost
               3.8613079 = idf(docFreq=2528, maxDocs=44218)
               0.01584443 = queryNorm
             0.30166468 = fieldWeight in 5125, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.8613079 = idf(docFreq=2528, maxDocs=44218)
               0.078125 = fieldNorm(doc=5125)
         0.03021926 = weight(abstract_txt:developed in 5125) [ClassicSimilarity], result of:
           0.03021926 = score(doc=5125,freq=1.0), product of:
             0.09218887 = queryWeight, product of:
               1.3867129 = boost
               4.195805 = idf(docFreq=1809, maxDocs=44218)
               0.01584443 = queryNorm
             0.32779726 = fieldWeight in 5125, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.195805 = idf(docFreq=1809, maxDocs=44218)
               0.078125 = fieldNorm(doc=5125)
         0.57170874 = weight(abstract_txt:sheets in 5125) [ClassicSimilarity], result of:
           0.57170874 = score(doc=5125,freq=2.0), product of:
             0.5946931 = queryWeight, product of:
               4.3135953 = boost
               8.701155 = idf(docFreq=19, maxDocs=44218)
               0.01584443 = queryNorm
             0.96135086 = fieldWeight in 5125, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               8.701155 = idf(docFreq=19, maxDocs=44218)
               0.078125 = fieldNorm(doc=5125)
       0.12 = coord(3/25)
   

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

   0.07053886 = sum of:
     0.07053886 = product of:
       0.2519245 = sum of:
         0.02809365 = weight(abstract_txt:input in 851) [ClassicSimilarity], result of:
           0.02809365 = score(doc=851,freq=1.0), product of:
             0.09797543 = queryWeight, product of:
               1.0108597 = boost
               6.1171575 = idf(docFreq=264, maxDocs=44218)
               0.01584443 = queryNorm
             0.28674176 = fieldWeight in 851, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               6.1171575 = idf(docFreq=264, maxDocs=44218)
               0.046875 = fieldNorm(doc=851)
         0.044740334 = weight(abstract_txt:allowing in 851) [ClassicSimilarity], result of:
           0.044740334 = score(doc=851,freq=2.0), product of:
             0.1060477 = queryWeight, product of:
               1.0516783 = boost
               6.3641686 = idf(docFreq=206, maxDocs=44218)
               0.01584443 = queryNorm
             0.42188877 = fieldWeight in 851, product of:
               1.4142135 = tf(freq=2.0), with freq of:
                 2.0 = termFreq=2.0
               6.3641686 = idf(docFreq=206, maxDocs=44218)
               0.046875 = fieldNorm(doc=851)
         0.012015419 = weight(abstract_txt:search in 851) [ClassicSimilarity], result of:
           0.012015419 = score(doc=851,freq=1.0), product of:
             0.07007252 = queryWeight, product of:
               1.2089857 = boost
               3.6580524 = idf(docFreq=3098, maxDocs=44218)
               0.01584443 = queryNorm
             0.17147121 = fieldWeight in 851, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               3.6580524 = idf(docFreq=3098, maxDocs=44218)
               0.046875 = fieldNorm(doc=851)
         0.028263273 = weight(abstract_txt:will in 851) [ClassicSimilarity], result of:
           0.028263273 = score(doc=851,freq=4.0), product of:
             0.078075856 = queryWeight, product of:
               1.2761616 = boost
               3.8613079 = idf(docFreq=2528, maxDocs=44218)
               0.01584443 = queryNorm
             0.3619976 = fieldWeight in 851, product of:
               2.0 = tf(freq=4.0), with freq of:
                 4.0 = termFreq=4.0
               3.8613079 = idf(docFreq=2528, maxDocs=44218)
               0.046875 = fieldNorm(doc=851)
         0.018131558 = weight(abstract_txt:developed in 851) [ClassicSimilarity], result of:
           0.018131558 = score(doc=851,freq=1.0), product of:
             0.09218887 = queryWeight, product of:
               1.3867129 = boost
               4.195805 = idf(docFreq=1809, maxDocs=44218)
               0.01584443 = queryNorm
             0.19667837 = fieldWeight in 851, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.195805 = idf(docFreq=1809, maxDocs=44218)
               0.046875 = fieldNorm(doc=851)
         0.044702373 = weight(abstract_txt:tool in 851) [ClassicSimilarity], result of:
           0.044702373 = score(doc=851,freq=1.0), product of:
             0.19259244 = queryWeight, product of:
               2.4547799 = boost
               4.951651 = idf(docFreq=849, maxDocs=44218)
               0.01584443 = queryNorm
             0.23210865 = fieldWeight in 851, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               4.951651 = idf(docFreq=849, maxDocs=44218)
               0.046875 = fieldNorm(doc=851)
         0.07597791 = weight(abstract_txt:google in 851) [ClassicSimilarity], result of:
           0.07597791 = score(doc=851,freq=1.0), product of:
             0.3018955 = queryWeight, product of:
               3.5488744 = boost
               5.3689504 = idf(docFreq=559, maxDocs=44218)
               0.01584443 = queryNorm
             0.25166956 = fieldWeight in 851, product of:
               1.0 = tf(freq=1.0), with freq of:
                 1.0 = termFreq=1.0
               5.3689504 = idf(docFreq=559, maxDocs=44218)
               0.046875 = fieldNorm(doc=851)
       0.28 = coord(7/25)