Data

Tools

Indexes

Applications

Experiments

Open Source Science

boffo

Boffo is an add-on for Google Sheets written by the Caltech Library. It lets you select item barcodes in a spreadsheet and retrieve information about the item records from a FOLIO server.

https://github.com/caltechlibrary/boffo

Science Score: 52.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • ✓
    CITATION.cff file
    Found CITATION.cff file
  • ✓
    codemeta.json file
    Found codemeta.json file
  • ✓
    .zenodo.json file
    Found .zenodo.json file
  • ○
    DOI references
  • ○
    Academic publication links
  • ○
    Academic email domains
  • ✓
    Institutional organization owner
    Organization caltechlibrary has institutional domain (www.library.caltech.edu)
  • ○
    JOSS paper metadata
  • ○
    Scientific vocabulary similarity
    Low similarity (14.3%) to scientific vocabulary

Keywords

folio folio-lsp google-apps-script google-scripts google-sheet google-sheets javascript library-automation
Last synced: 4 months ago · JSON representation ·

Repository

Boffo is an add-on for Google Sheets written by the Caltech Library. It lets you select item barcodes in a spreadsheet and retrieve information about the item records from a FOLIO server.

Basic Info
Statistics
  • Stars: 4
  • Watchers: 6
  • Forks: 0
  • Open Issues: 3
  • Releases: 16
Topics
folio folio-lsp google-apps-script google-scripts google-sheet google-sheets javascript library-automation
Created over 2 years ago · Last pushed almost 2 years ago
Metadata Files
Readme Changelog Contributing License Code of conduct Citation Security Support Codemeta

README.md

BoffoBoffo logo

Boffo (Barcodes from FOLIO) is a Google Sheet script for getting data about FOLIO items.

License made-with-javascript Google Sheets Latest release DOI Boffo

Table of contents

Introduction

Boffo (a loose acronym of Barcodes from FOLIO, and pronounced like the noun) is an add-on for Google Sheets. Among other things, it lets you select item barcodes in a spreadsheet and retrieve information about the item records from a FOLIO server.

Installation

If you're Caltech Library staff, Boffo is available to you from the Google Marketplace for add-ons as an "Internal" add-on; if you're not Caltech Library staff, you can still install Boffo using alternate methods, as described in the pages linked below:

Quick start

Once installed as an Add-on on a Google Sheet, Boffo will present itself as a menu item in the Extensions menu across the top of the sheet. Selecting the Boffo item in the Extensions menu will present several items in a submenu:

Screenshot of Boffo menu

Boffo's main function is Look up barcodes in FOLIO and its use is very simple:

  1. Select some item barcodes in your Google spreadsheet
  2. Pull down the Extensions menu
  3. Select Look up barcodes in FOLIO from the Boffo menu

Screenshot of spreadsheet with Boffo

Boffo will create a new sheet titled "Item Data" in the spreadsheet where you ran it, then add the results of the item lookups to the new sheet.

Screenshot of sample results from Boffo

If this is the first time you've used Boffo, it will first request your FOLIO account login and password in order to ask FOLIO for a token to use the network services. Boffo will store that token (and not your login or password), then proceed to look up the items whose barcodes are highlighted in the sheet. On subsequent invocations, Boffo will not ask you for FOLIO credentials unless something happens to make the token invalid (in which case, Boffo will ask you for the credentials again and generate a new token).

Usage

Please see the detailed usage section in the Boffo documentation for more information about Boffo's features and how to use them.

Known issues and limitations

Depending on your account type, Boffo will run into Google quotas limiting maximum execution time. For G Suite users such as the Caltech Library, this limit is 30 minutes. For non-G Suite users, the limit is 6 minutes. At the time of this writing, Boffo can retrieve item records at a rate of about 70–100 records/second, so the 6 minute time limit will limit non-G suite users to looking up somewhere between 25,000–35,000 item records at a time.

Getting help

If you find an issue, please submit it in the GitHub issue tracker for this repository.

Contributing

Your help and participation in enhancing Boffo is welcome! Please visit the guidelines for contributing for some tips on getting started.

License

Software produced by the Caltech Library is Copyright © 2024 California Institute of Technology. This software is freely distributed under a BSD-style license. Please see the LICENSE file for more information.

Acknowledgments

The vector artwork used as a starting point for the logo for this project was created by Sunarto Hamizan It is licensed under the Creative Commons Attribution 3.0 Unported license. The vector graphics was modified by Mike Hucka to change the color.

The spinner used in some HTML dialogs shown by Boffo came from SVG Spinners (CSS & SMIL) by Utkarsh Verma. The code was copied on 2023-08-01 and is licensed under the MIT license by the author.

This work was funded by the California Institute of Technology Library.


Caltech logo

Owner

  • Name: Caltech Library
  • Login: caltechlibrary
  • Kind: organization
  • Email: helpdesk@library.caltech.edu
  • Location: Pasadena, CA 91125

We manage the physical and digital holdings of the California Institute of Technology, provide services and training, and develop open-source software.

Citation (CITATION.cff) 

cff-version: 1.2
message: If you use this software, please cite it using these metadata.
authors:
  - family-names: Hucka
    given-names: Michael
    affiliation: Caltech Library
    orcid: https://orid.org/0000-0001-9105-5960
title: Boffo
abstract: Boffo (Barcodes from FOLIO) is a Google Apps script that looks up item barcodes in a FOLIO instance.
version: 1.9.1
date-released: 2024-03-12
doi: 10.22002/dqmsp-w5591
url: https://caltechlibrary.github.io/boffo
repository-code: https://github.com/caltechlibrary/boffo
license-url: https://github.com/caltechlibrary/boffo/blob/main/LICENSE
type: software
keywords:
  - FOLIO
  - Google Apps Scripts
  - Google Sheets
  - automation
  - library
  - software

CodeMeta (codemeta.json) 

{
  "@context": "https://doi.org/10.5063/schema/codemeta-2.0",
  "@type": "SoftwareSourceCode",
  "name": "Boffo",
  "identifier": "boffo",
  "description": "Boffo (Barcodes from FOLIO) is a Google Apps script that looks up item barcodes in a FOLIO instance.",
  "version": "1.9.1",
  "datePublished": "2024-03-12",
  "dateCreated": "2023-06-08",
  "author": [
    {
      "@type": "Person",
      "givenName": "Michael",
      "familyName": "Hucka",
      "affiliation": {
        "@type": "Organization",
        "name": "California Institute of Technology Library"
      },
      "email": "mhucka@caltech.edu",
      "@id": "https://orcid.org/0000-0001-9105-5960"
    }
  ],
  "maintainer": [
    {
      "@type": "Person",
      "givenName": "Michael",
      "familyName": "Hucka",
      "affiliation": {
        "@type": "Organization",
        "name": "California Institute of Technology Library"
      },
      "email": "mhucka@caltech.edu",
      "@id": "https://orcid.org/0000-0001-9105-5960"
    }
  ],
  "funder": {
    "@id": "https://ror.org/05dxps055",
    "@type": "Organization",
    "name": "California Institute of Technology Library"
  },
  "copyrightHolder": [
    {
      "@id": "https://ror.org/05dxps055",
      "@type": "Organization",
      "name": "California Institute of Technology"
    }
  ],
  "copyrightYear": 2024,
  "license": "https://github.com/caltechlibrary/boffo/blob/main/LICENSE",
  "isAccessibleForFree": true,
  "url": "https://caltechlibrary.github.io/boffo",
  "codeRepository": "https://github.com/caltechlibrary/boffo",
  "readme": "https://github.com/caltechlibrary/boffo/blob/main/README.md",
  "releaseNotes": "https://github.com/caltechlibrary/boffo/blob/main/CHANGES.md",
  "issueTracker": "https://github.com/caltechlibrary/boffo/issues",
  "downloadUrl": "https://github.com/caltechlibrary/boffo/releases",
  "softwareHelp": "http://caltechlibrary.github.io/boffo",
  "relatedLink": "https://data.caltech.edu/records/dqmsp-w5591",
  "programmingLanguage": {
    "@type": "ComputerLanguage",
    "name": "JavaScript",
    "version": "V8",
    "url": "https://developers.google.com/apps-script/overview"
  },
  "keywords": [
    "FOLIO",
    "Google Apps Scripts",
    "Google Sheets",
    "automation",
    "library",
    "software"
  ],
  "developmentStatus": "active"
}

GitHub Events

Total
  • Watch event: 1
Last Year
  • Watch event: 1

Issues and Pull Requests

Last synced: 9 months ago

All Time
  • Total issues: 9
  • Total pull requests: 0
  • Average time to close issues: 21 days
  • Average time to close pull requests: N/A
  • Total issue authors: 2
  • Total pull request authors: 0
  • Average comments per issue: 1.0
  • Average comments per pull request: 0
  • Merged pull requests: 0
  • Bot issues: 1
  • Bot pull requests: 0
Past Year
  • Issues: 0
  • Pull requests: 0
  • Average time to close issues: N/A
  • Average time to close pull requests: N/A
  • Issue authors: 0
  • Pull request authors: 0
  • Average comments per issue: 0
  • Average comments per pull request: 0
  • Merged pull requests: 0
  • Bot issues: 0
  • Bot pull requests: 0
View more stats
Top Authors
Issue Authors
  • mhucka (8)
  • github-actions[bot] (1)
Pull Request Authors
Top Labels
Issue Labels
Enhancement ✨ (5) Priority ★★ (3) Priority ★★★ (2) Bug 🐛 (2) Priority ★ (1) bug (1)
Pull Request Labels