Document (#42444)

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.1334137 = sum of:
      0.1334137 = product of:
        0.6670685 = sum of:
          0.036349475 = weight(abstract_txt:easily in 445) [ClassicSimilarity], result of:
            0.036349475 = score(doc=445,freq=1.0), product of:
              0.09600272 = queryWeight, product of:
                6.058074 = idf(docFreq=274, maxDocs=43254)
                0.01584707 = queryNorm
              0.37862962 = fieldWeight in 445, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.058074 = idf(docFreq=274, maxDocs=43254)
                0.0625 = fieldNorm(doc=445)
          0.041144885 = weight(abstract_txt:flexible in 445) [ClassicSimilarity], result of:
            0.041144885 = score(doc=445,freq=1.0), product of:
              0.10427064 = queryWeight, product of:
                1.0421716 = boost
                6.313553 = idf(docFreq=212, maxDocs=43254)
                0.01584707 = queryNorm
              0.39459705 = fieldWeight in 445, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                6.313553 = idf(docFreq=212, maxDocs=43254)
                0.0625 = fieldNorm(doc=445)
          0.0341787 = weight(abstract_txt:developed in 445) [ClassicSimilarity], result of:
            0.0341787 = score(doc=445,freq=2.0), product of:
              0.09214147 = queryWeight, product of:
                1.3854817 = boost
                4.1966753 = idf(docFreq=1768, maxDocs=43254)
                0.01584707 = queryNorm
              0.3709372 = fieldWeight in 445, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                4.1966753 = idf(docFreq=1768, maxDocs=43254)
                0.0625 = fieldNorm(doc=445)
          0.10191697 = weight(abstract_txt:google in 445) [ClassicSimilarity], result of:
            0.10191697 = score(doc=445,freq=1.0), product of:
              0.30301848 = queryWeight, product of:
                3.5532255 = boost
                5.381426 = idf(docFreq=540, maxDocs=43254)
                0.01584707 = queryNorm
              0.33633912 = fieldWeight in 445, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                5.381426 = idf(docFreq=540, maxDocs=43254)
                0.0625 = fieldNorm(doc=445)
          0.45347843 = weight(abstract_txt:sheets in 445) [ClassicSimilarity], result of:
            0.45347843 = score(doc=445,freq=2.0), product of:
              0.5911345 = queryWeight, product of:
                4.2979565 = boost
                8.679112 = idf(docFreq=19, maxDocs=43254)
                0.01584707 = queryNorm
              0.7671324 = fieldWeight in 445, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                8.679112 = idf(docFreq=19, maxDocs=43254)
                0.0625 = fieldNorm(doc=445)
        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.103079855 = sum of:
      0.103079855 = product of:
        0.85899884 = sum of:
          0.023500338 = weight(abstract_txt:will in 105) [ClassicSimilarity], result of:
            0.023500338 = score(doc=105,freq=1.0), product of:
              0.0779359 = queryWeight, product of:
                1.2742128 = boost
                3.859638 = idf(docFreq=2477, maxDocs=43254)
                0.01584707 = queryNorm
              0.3015342 = fieldWeight in 105, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                3.859638 = idf(docFreq=2477, maxDocs=43254)
                0.078125 = fieldNorm(doc=105)
          0.1412543 = weight(abstract_txt:sheet in 105) [ClassicSimilarity], result of:
            0.1412543 = score(doc=105,freq=1.0), product of:
              0.20449337 = queryWeight, product of:
                1.459479 = boost
                8.841632 = idf(docFreq=16, maxDocs=43254)
                0.01584707 = queryNorm
              0.6907525 = fieldWeight in 105, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                8.841632 = idf(docFreq=16, maxDocs=43254)
                0.078125 = fieldNorm(doc=105)
          0.6942442 = weight(abstract_txt:sheets in 105) [ClassicSimilarity], result of:
            0.6942442 = score(doc=105,freq=3.0), product of:
              0.5911345 = queryWeight, product of:
                4.2979565 = boost
                8.679112 = idf(docFreq=19, maxDocs=43254)
                0.01584707 = queryNorm
              1.1744268 = fieldWeight in 105, product of:
                1.7320508 = tf(freq=3.0), with freq of:
                  3.0 = termFreq=3.0
                8.679112 = idf(docFreq=19, maxDocs=43254)
                0.078125 = fieldNorm(doc=105)
        0.12 = coord(3/25)
    
  3. Nilges, C.: ¬The Online Computer Library Center's Open WorldCat program (2006) 0.10
    0.100704685 = sum of:
      0.100704685 = product of:
        0.83920574 = sum of:
          0.02390785 = weight(abstract_txt:search in 592) [ClassicSimilarity], result of:
            0.02390785 = score(doc=592,freq=1.0), product of:
              0.069811605 = queryWeight, product of:
                1.2059715 = boost
                3.6529322 = idf(docFreq=3046, maxDocs=43254)
                0.01584707 = queryNorm
              0.3424624 = fieldWeight in 592, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                3.6529322 = idf(docFreq=3046, maxDocs=43254)
                0.09375 = fieldNorm(doc=592)
          0.15287545 = weight(abstract_txt:google in 592) [ClassicSimilarity], result of:
            0.15287545 = score(doc=592,freq=1.0), product of:
              0.30301848 = queryWeight, product of:
                3.5532255 = boost
                5.381426 = idf(docFreq=540, maxDocs=43254)
                0.01584707 = queryNorm
              0.5045087 = fieldWeight in 592, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                5.381426 = idf(docFreq=540, maxDocs=43254)
                0.09375 = fieldNorm(doc=592)
          0.6624224 = weight(abstract_txt:worldcat in 592) [ClassicSimilarity], result of:
            0.6624224 = score(doc=592,freq=5.0), product of:
              0.42792177 = queryWeight, product of:
                3.6567986 = boost
                7.3843856 = idf(docFreq=72, maxDocs=43254)
                0.01584707 = queryNorm
              1.5479989 = fieldWeight in 592, product of:
                2.236068 = tf(freq=5.0), with freq of:
                  5.0 = termFreq=5.0
                7.3843856 = idf(docFreq=72, maxDocs=43254)
                0.09375 = fieldNorm(doc=592)
        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.07
    0.074466996 = sum of:
      0.074466996 = product of:
        0.6205583 = sum of:
          0.023500338 = weight(abstract_txt:will in 126) [ClassicSimilarity], result of:
            0.023500338 = score(doc=126,freq=1.0), product of:
              0.0779359 = queryWeight, product of:
                1.2742128 = boost
                3.859638 = idf(docFreq=2477, maxDocs=43254)
                0.01584707 = queryNorm
              0.3015342 = fieldWeight in 126, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                3.859638 = idf(docFreq=2477, maxDocs=43254)
                0.078125 = fieldNorm(doc=126)
          0.030209986 = weight(abstract_txt:developed in 126) [ClassicSimilarity], result of:
            0.030209986 = score(doc=126,freq=1.0), product of:
              0.09214147 = queryWeight, product of:
                1.3854817 = boost
                4.1966753 = idf(docFreq=1768, maxDocs=43254)
                0.01584707 = queryNorm
              0.32786524 = fieldWeight in 126, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                4.1966753 = idf(docFreq=1768, maxDocs=43254)
                0.078125 = fieldNorm(doc=126)
          0.566848 = weight(abstract_txt:sheets in 126) [ClassicSimilarity], result of:
            0.566848 = score(doc=126,freq=2.0), product of:
              0.5911345 = queryWeight, product of:
                4.2979565 = boost
                8.679112 = idf(docFreq=19, maxDocs=43254)
                0.01584707 = queryNorm
              0.9589155 = fieldWeight in 126, product of:
                1.4142135 = tf(freq=2.0), with freq of:
                  2.0 = termFreq=2.0
                8.679112 = idf(docFreq=19, maxDocs=43254)
                0.078125 = fieldNorm(doc=126)
        0.12 = coord(3/25)
    
  5. Bartczak, J.; Glendon, I.: Python, Google Sheets, and the Thesaurus for Graphic Materials for efficient metadata project workflows (2017) 0.07
    0.06620623 = sum of:
      0.06620623 = product of:
        0.5517186 = sum of:
          0.023500338 = weight(abstract_txt:will in 5358) [ClassicSimilarity], result of:
            0.023500338 = score(doc=5358,freq=1.0), product of:
              0.0779359 = queryWeight, product of:
                1.2742128 = boost
                3.859638 = idf(docFreq=2477, maxDocs=43254)
                0.01584707 = queryNorm
              0.3015342 = fieldWeight in 5358, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                3.859638 = idf(docFreq=2477, maxDocs=43254)
                0.078125 = fieldNorm(doc=5358)
          0.12739621 = weight(abstract_txt:google in 5358) [ClassicSimilarity], result of:
            0.12739621 = score(doc=5358,freq=1.0), product of:
              0.30301848 = queryWeight, product of:
                3.5532255 = boost
                5.381426 = idf(docFreq=540, maxDocs=43254)
                0.01584707 = queryNorm
              0.4204239 = fieldWeight in 5358, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                5.381426 = idf(docFreq=540, maxDocs=43254)
                0.078125 = fieldNorm(doc=5358)
          0.40082207 = weight(abstract_txt:sheets in 5358) [ClassicSimilarity], result of:
            0.40082207 = score(doc=5358,freq=1.0), product of:
              0.5911345 = queryWeight, product of:
                4.2979565 = boost
                8.679112 = idf(docFreq=19, maxDocs=43254)
                0.01584707 = queryNorm
              0.67805564 = fieldWeight in 5358, product of:
                1.0 = tf(freq=1.0), with freq of:
                  1.0 = termFreq=1.0
                8.679112 = idf(docFreq=19, maxDocs=43254)
                0.078125 = fieldNorm(doc=5358)
        0.12 = coord(3/25)