Importing, Exporting, and Updating VIVO Data

2017-08-04T19:43:43Z (GMT) by Rodney Jacobson
Getting data into and out of VIVO remains a challenge for both new and existing VIVO implementations. This presentation will introduce an extension to VIVO's Site Administration page which allows data to be easily imported and exported from VIVO. Additionally, researchers' publications can be identified through the Profiles RNS Disambiguation Engine and loaded into VIVO. Data can be imported into VIVO from standard CSV files. Data in the file is compared to what is already in VIVO and a report is generated with a list of records to be added, removed, and updated in VIVO. The administrator can then choose to perform any or all of the changes as desired. Data can similarly be exported from VIVO in CSV format, and an optional REST API can be activated to provide the data in JSON format. This makes it possible to make changes to VIVO data by exporting to a CSV file, editing the data in a spreadsheet, and importing the data back into VIVO. Preset configurations are provided to handle CSV files with common data such as HR records, publication lists, and grant data. Customized CSV files can also be configured by manually entering a row of data into VIVO and providing basic information about the CSV file format. Researchers' publications can be identified and loaded into VIVO by interfacing with the Profiles RNS Disambiguation Engine and PubMed APIs. Information about a researcher in VIVO, including known publications, is sent to the Disambiguation Engine in order to identify more of the researcher's publications. Details about the identified publications are automatically obtained from PubMed's API, and can be automatically added to the researcher's VIVO profile. These open source tools are currently being developed to be built with VIVO 1.9.