Skip to content

Home

Jump to bottom
atabel edited this page Oct 26, 2012 · 4 revisions

What is this?

This is a simple tool to translate from the CVN format to a CERIF relational database. CVN is a proposed standard for research-oriented curricula promoted by FECYT and the Ministry of Economy and Competitiveness. CERIF is a European standard for Current Research Information Systems maintained by EuroCRIS.

Concretely, it takes as input a CVN XML and stores it in a CERIF relational database by first converting to CERIF XML.

How can I use it?

In three steps:

  • Convert CVN XML file into CERIF XML file
  • Convert CERIF xml file into SQL script
  • Use the SQL script to populate your CERIF database.

CVN to CERIF conversion process.

Conversion to CERIF XML can be done as follows for example:

saxonb-xslt -ext:on CVN.xml cvn-to-cerif.xslt > CERIF.xml

Then converting the CERIF XML is done using the scripts provided by EuroCRIS:

saxonb-xslt -ext:on CERIF.xml cerif-xml-to-db.xslt > CERIF_DB.sql

cerif-xml-to-db.xslt file is developed by EuroCRIS and will be provided under an open-source license, to be decided.

Is it complete?

Not yet. This is for now just a prototype serving as a proof-of-concept. It concretely supports the following CERIF data elements:

Person data [cfPers]

  • Name [cfPersName.cfFirstNames]
  • Birthdate [cfPers.cfBirthdate]
  • Gender [cfPers.cfGender]

Organization data [cfOrgUnit]

  • Name [cfOrgUnitName.cfName]

Person position [cfPers_OrgUnit]

  • Position [cfPers_OrgUnit.cfClassId]
  • Start date: [cfPers_OrgUnit.cfStartDate]
  • End date: [cfPers_OrgUnit.cfEndDate]

Project data [cfProj]

  • Title [cfProjTitle.cfTitle]

Person in project [cfProj_Pers]

  • Start date: [cfProj_Pers.cfStartDate]
  • End date: [cfProj_Pers.cfEndDate]
Clone this wiki locally