Journal article Open Access

Managing Institutional Bibliographies with the ADS API: A new workflow using Google Sheets

Damon, James; Henneken, Edwin; Accomazzi, Alberto

Curating institutional bibliographies with the ADS web interface is currently a manual process that scales with the number of search terms. Long author lists and institutions with multiple sub-organizations or name variations increase the workload. Review work is monotonous and can take significant time depending on the size of the institution and the frequency of reviews. Consequently, bibliographies generated in this way are costly and may suffer from human error. We propose a semi-automated workflow that uses an iterative approach to discovery with ADS’s new search engine and a recently developed Google Sheets add on. First, affiliation strings from a user created spreadsheet are searched with the ADS API and for each result the matched affiliation and the paired author are retrieved. Next, each author name string is searched and items where that author is paired with an empty affiliation field are retrieved. The results from both queries are then compiled into output sheets with pertinent information for manual review. Finally, the selected items can be added to an ADS library from the Google Sheets interface. The tool can also use previously rejected affiliation strings to flag false positives in subsequent queries. Curators do not need to have extensive technical skills in order to use the workflow and they can help improve the ADS by opting to share ORCIDs, author synonyms, and affiliation synonyms.

NASA ADS is operated by the Smithsonian Astrophysical Observatory under NASA Cooperative Agreement NNX16AC86A
Files (184.8 kB)
Name Size
LISA VIII Poster.pdf
md5:74770628674e8fa27d077e3fdb8d7741
184.8 kB Download
8
3
views
downloads
All versions This version
Views 88
Downloads 33
Data volume 554.3 kB554.3 kB
Unique views 88
Unique downloads 33

Share

Cite as