Old Release

This documentation relates to an old version of VIVO, version 1.13.x.
Looking for another version? See all documentation.


The Reconciliation API or Reconciliation Endpoint provides the ability to reconcile data in OpenRefine with that from a VIVO and prepare it for import into VIVO. 

OpenRefine describes itself as a “powerful tool for working with messy data: cleaning it; transforming it from one format into another; and extending it with web services and external data”. One use case of OpenRefine is to match tabular data with data in a VIVO, export it as RDF and then import it into a VIVO.






Usage with OpenRefine

  1. Click on “Start reconciling” in OpenRefine

  2. Click on “Add Standard Service”

  3. Enter the url of the reconciliation service and click on Add Service

  4. The VIVO Reconciliation Service should now show up in OpenRefine.

In the menu you can choose the type in VIVO, against which you want to reconcile your data. Click on the button “Start reconciling” to process the matching.

For further information please consult the OpenRefine documentation: https://docs.openrefine.org/manual/reconciling

Configuration of the VIVO Reconciliation API

A list of types that are delivered via the API can be configured in the runtime properties. For instance, the property Vitro.reconcile.defaultTypeList can be configured as follows:

http://vivoweb.org/ontology/core#Role, core:Role; http://vivoweb.org/ontology/core#AcademicDegree, core:Academic Degree; http://purl.org/NET/c4dm/event.owl#Event, event:Event; http://vivoweb.org/ontology/core#Location, core:Location; http://xmlns.com/foaf/0.1/Organization, foaf:Organization; http://xmlns.com/foaf/0.1/Person, foaf:Person; http://purl.obolibrary.org/obo/IAO_0000030, obo:IAO_0000030

A documentation of the technical implementation can be found here: Extending Google Refine for VIVO. Please note that this documentation has not been updated in a long time.
  • No labels