D-Net

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0"

	xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

	xmlns:datetime="http://exslt.org/dates-and-times" xmlns:exslt="http://exslt.org/common"

	xmlns:oai="http://www.openarchives.org/OAI/2.0/"

	exclude-result-prefixes="xsl datetime exslt xsi" xmlns:dri="http://www.driver-repository.eu/namespace/dri">

	<xsl:param name="datasourceId" />

	<xsl:template match="/">

		<record xmlns:dri="http://www.driver-repository.eu/namespace/dri">

  			<header>

	  			<dri:objIdentifier>

					<xsl:value-of select="concat($datasourceId, '::', normalize-space(//FIELD[@name='_dnet_resource_identifier_']))"/>

				</dri:objIdentifier>

				<dri:dateOfCollection>

					<xsl:value-of select="datetime:dateTime()" />

				</dri:dateOfCollection>

				<dri:repositoryId>

					<xsl:value-of select="$datasourceId" />

				</dri:repositoryId>

			</header>

			<metadata>

				<xsl:copy-of select="." />			

			</metadata>

		</record>

	</xsl:template>

</xsl:stylesheet>

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:dr="http://www.driver-repository.eu/namespace/dr"

	xmlns:dri="http://www.driver-repository.eu/namespace/dri" xmlns:oaa="http://namespace.openaire.eu/oaa" xmlns:oaf="http://namespace.openaire.eu/oaf" xmlns:fn="http://www.w3.org/2005/xpath-functions"

	xmlns:ands="http://ands.org.au/standards/rif-cs/registryObjects">

	<xsl:output indent="yes"/>

	<xsl:param name="parentDatasourceId" />

	<xsl:template match="/">

		<record xmlns:dr="http://www.driver-repository.eu/namespace/dr"

			xmlns:dri="http://www.driver-repository.eu/namespace/dri"

			xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

			xmlns:oaf="http://namespace.openaire.eu/oaf" xmlns:oai_dc="http://www.openarchives.org/OAI/2.0/oai_dc/">

			<xsl:copy-of select=".//*[local-name()='header']"/>

			<metadata>

				<ROWS>

					<xsl:for-each select="//ands:registryObject[@group='National Health and Medical Research Council']/ands:activity[@type='grant']">

						<xsl:variable name="projectId" select="concat('nhmrc_______::', normalize-space(./ands:identifier[@type='nhmrc']))"/>

						<xsl:variable name="fundingId">

							<xsl:choose>

								<xsl:when test="string-length(./ands:description[@type='fundingScheme']) &gt; 0">

									<xsl:value-of select="concat('nhmrc_______::NHMRC::', normalize-space(./ands:description[@type='fundingScheme']))"/>

								</xsl:when>

								<xsl:otherwise>

									<xsl:value-of select="string('nhmrc_______::NHMRC')"/>

								</xsl:otherwise>

							</xsl:choose>

						</xsl:variable>

						<ROW table="projects">

							<FIELD name="_dnet_resource_identifier_"><xsl:value-of select="$projectId" /></FIELD>

							<FIELD name="id"><xsl:value-of select="$projectId" /></FIELD>

							<FIELD name="code"><xsl:value-of select="normalize-space(.//ands:identifier[@type='nhmrc'])" /></FIELD>

							<FIELD name="title"><xsl:value-of select="./ands:name[@type='primary']/ands:namePart" /></FIELD>

							<FIELD name="websiteurl"><xsl:value-of select="./ands:identifier[@type='purl']"/></FIELD>

							<xsl:for-each select="./ands:existenceDates/ands:startDate[@dateFormat='W3CDTF']">

								<FIELD name="startdate" type="date" format="dd-MM-yyyy"><xsl:value-of select="concat('01-01-', normalize-space(.))" /></FIELD>

							</xsl:for-each>

							<xsl:for-each select="./ands:existenceDates/ands:endDate[@dateFormat='W3CDTF']">

								<FIELD name="enddate" type="date" format="dd-MM-yyyy"><xsl:value-of select="concat('31-12-', normalize-space(.))" /></FIELD>

							</xsl:for-each>

							<xsl:variable name="keywords">

								<xsl:for-each select="./ands:subject[@type='local']">

									<xsl:if test="position() != 1">, </xsl:if>

									<xsl:value-of select="."/>

								</xsl:for-each>

							</xsl:variable>

							<FIELD name="keywords"><xsl:value-of select="normalize-space($keywords)" /></FIELD>

							<FIELD name="collectedfrom"><xsl:value-of select="$parentDatasourceId" /></FIELD>

							<FIELD name="provenanceActionClass">sysimport:crosswalk:entityregistry</FIELD>

							<FIELD name="provenanceActionScheme">dnet:provenanceActions</FIELD>

						</ROW>

						<ROW table="project_fundingpath">

							<FIELD name="_dnet_resource_identifier_"><xsl:value-of select="concat($fundingId, '@@', $projectId)" /></FIELD>

							<FIELD name="funding"><xsl:value-of select="$fundingId" /></FIELD>

							<FIELD name="project"><xsl:value-of select="$projectId" /></FIELD>

							<xsl:for-each select="./ands:existenceDates/ands:startDate[@dateFormat='W3CDTF']">

								<FIELD name="startdate" type="date" format="dd-MM-yyyy"><xsl:value-of select="concat('01-01-', normalize-space(.))" /></FIELD>

							</xsl:for-each>

							<xsl:for-each select="./ands:existenceDates/ands:endDate[@dateFormat='W3CDTF']">

								<FIELD name="enddate" type="date" format="dd-MM-yyyy"><xsl:value-of select="concat('31-12-', normalize-space(.))" /></FIELD>

							</xsl:for-each>

						</ROW>

					</xsl:for-each>

				</ROWS>

			</metadata>

		</record>

	</xsl:template>

</xsl:stylesheet>

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

                xmlns:fn="http://www.w3.org/2005/xpath-functions" exclude-result-prefixes="fn">

	<xsl:variable name="namespacePrefix" select="string('irb_hr______')"/>

	<xsl:template match="/">

		<xsl:choose>

			<xsl:when test="//csvRecord/column[@name = 'FUNDER_NAME']/text() = 'HRZZ'">

				<fundingtree>

					<funder>

						<id>

							<xsl:value-of select="concat($namespacePrefix, '::HRZZ')"/>

						</id>

						<shortname>HRZZ</shortname>

						<name>Croatian Science Foundation (CSF)</name>

						<originalname>Hrvatska zaklada za znanost</originalname>

						<jurisdiction>HR</jurisdiction>

					</funder>

				</fundingtree>

			</xsl:when>

			<xsl:otherwise>

				<fundingtree/>

			</xsl:otherwise>

		</xsl:choose>

	</xsl:template>

</xsl:stylesheet>

<?xml version="1.0" ?>

<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">

    <parent>

        <groupId>eu.dnetlib</groupId>

        <artifactId>dnet-parent</artifactId>

        <version>1.0.0</version>

        <relativePath />

    </parent>

    <modelVersion>4.0.0</modelVersion>

    <groupId>eu.dnetlib</groupId>

    <artifactId>dnet-openaireplus-workflows</artifactId>

    <packaging>jar</packaging>

    <version>5.4.16</version>

    <scm>

        <developerConnection>scm:svn:https://svn.driver.research-infrastructures.eu/driver/dnet40/modules/dnet-openaireplus-workflows/tags/dnet-openaireplus-workflows-5.4.16</developerConnection>

    </scm>

    <repositories>

        <repository>

            <id>dfm-releases</id>

            <url>http://maven.research-infrastructures.eu/nexus/content/repositories/dfm-releases</url>

        </repository>

    </repositories>

    <dependencies>

        <dependency>

            <groupId>eu.dnetlib</groupId>

            <artifactId>cnr-data-flow-monitoring-core</artifactId>

            <version>[0.1.0,1.0.0)</version>

            <exclusions>

                <exclusion>

                    <artifactId>wstx-asl</artifactId>

                    <groupId>org.codehaus.woodstox</groupId>

                </exclusion>

            </exclusions>

        </dependency>

        <dependency>

            <groupId>eu.dnetlib</groupId>

            <artifactId>cnr-enabling-database-api</artifactId>

            <version>[2.0.0,3.0.0)</version>

        </dependency>

        <dependency>

            <groupId>eu.dnetlib</groupId>

            <artifactId>dnet-msro-service</artifactId>

            <version>[3.0.0,4.0.0)</version>

        </dependency>

        <dependency>

            <groupId>eu.dnetlib</groupId>

            <artifactId>cnr-resultset-service</artifactId>

            <version>[2.0.0,3.0.0)</version>

        </dependency>

        <dependency>

            <groupId>eu.dnetlib</groupId>

            <artifactId>dnet-openaireplus-datasource-manager-service</artifactId>

            <version>[5.0.0,6.0.0)</version>

        </dependency>

        <dependency>

            <groupId>eu.dnetlib</groupId>

            <artifactId>dnet-openaireplus-mapping-utils</artifactId>

            <version>[5.0.0,6.0.0)</version>

        </dependency>

        <dependency>

            <groupId>eu.dnetlib</groupId>

            <artifactId>dnet-hadoop-service-rmi</artifactId>

            <version>[1.0.0,2.0.0)</version>

        </dependency>

        <dependency>

            <groupId>eu.dnetlib</groupId>

            <artifactId>dnet-index-solr-common</artifactId>

            <version>[1.0.0,2.0.0)</version>

        </dependency>

        <dependency>

            <groupId>eu.dnetlib</groupId>

            <artifactId>dnet-collector-plugins</artifactId>

            <version>[1.0.0,2.0.0)</version>

        </dependency>

        <dependency>

            <groupId>eu.dnetlib</groupId>

            <artifactId>dnet-actionmanager-api</artifactId>

            <version>[4.0.0,5.0.0)</version>

        </dependency>

        <dependency>

            <groupId>eu.dnetlib</groupId>

            <artifactId>dnet-oai-common-workflows</artifactId>

            <version>[3.0.0,4.0.0)</version>

        </dependency>

        <dependency>

            <groupId>eu.dnetlib</groupId>

            <artifactId>dnet-index-solr-client</artifactId>

            <version>[2.0.0,2.9.9)</version>

        </dependency>

        <dependency>

            <groupId>eu.dnetlib</groupId>

            <artifactId>dnet-validator-workflows</artifactId>

            <version>[1.0.0,2.0.0)</version>

        </dependency>

        <dependency>

            <groupId>eu.dnetlib</groupId>

            <artifactId>dnet-deduplication</artifactId>

            <version>[1.0.0,2.0.0)</version>

        </dependency>

        <!-- modular ui and servlet api are here because of the stats controller -->

        <dependency>

            <groupId>eu.dnetlib</groupId>

            <artifactId>dnet-modular-vocabularies-ui</artifactId>

            <version>[2.0.0,3.0.0)</version>

        </dependency>

        <dependency>

            <groupId>org.apache.velocity</groupId>

            <artifactId>velocity</artifactId>

            <version>1.7</version>

        </dependency>

        <dependency>

            <groupId>org.apache.velocity</groupId>

            <artifactId>velocity-tools</artifactId>

            <version>2.0</version>

        </dependency>

        <dependency>

            <groupId>javax.servlet</groupId>

            <artifactId>javax.servlet-api</artifactId>

            <version>${javax.servlet.version}</version>

            <scope>provided</scope>

        </dependency>

        <dependency>

            <groupId>junit</groupId>

            <artifactId>junit</artifactId>

            <version>${junit.version}</version>

            <scope>test</scope>

        </dependency>

 		<dependency>

			<groupId>eu.dnetlib</groupId>

			<artifactId>dnet-openaireplus-profiles</artifactId>

			<version>[1.0.0,2.0.0)</version>

			<scope>test</scope>

		</dependency>

	</dependencies>

</project>

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

                xmlns:fn="http://www.w3.org/2005/xpath-functions" exclude-result-prefixes="fn">

	<xsl:variable name="namespacePrefix" select="string('ec__________')"/>

	<xsl:variable name="funderID" select="concat($namespacePrefix, '::EC')"/>

	<xsl:template match="/">

		<fundingtree>

			<funder>

				<id>

					<xsl:value-of select="$funderID"/>

				</id>

				<shortname>EC</shortname>

				<name>European Commission</name>

				<jurisdiction>EU</jurisdiction>

			</funder>

			<xsl:variable name="toaCode" select=".//ProjectTOACode"/>

			<xsl:choose>

				<xsl:when test="$toaCode and starts-with($toaCode, 'ERC-')">

					<xsl:call-template name="ERC">

						<xsl:with-param name="toaCode" select="$toaCode"/>

					</xsl:call-template>

				</xsl:when>

				<xsl:when test="$toaCode and not(starts-with($toaCode, 'ERC-'))">

					<xsl:call-template name="other">

						<xsl:with-param name="toaCode" select="$toaCode"/>

					</xsl:call-template>

				</xsl:when>

				<xsl:otherwise>

					<xsl:call-template name="h2020"/>

				</xsl:otherwise>

			</xsl:choose>

		</fundingtree>

	</xsl:template>

	<xsl:template name="h2020">

		<funding_level_0>

			<id>

				<xsl:value-of select="concat($funderID, '::H2020')"/>

			</id>

			<name>H2020</name>

			<description>Horizon 2020 Framework Programme</description>

			<parent/>

			<class>ec:h2020fundings</class>

		</funding_level_0>

	</xsl:template>

	<xsl:template name="ERC">

		<xsl:param name="toaCode"/>

		<xsl:variable name="toaId" select="concat($funderID, '::H2020::ERC::', $toaCode)"/>

		<funding_level_2>

			<id>

				<xsl:value-of select="$toaId"/>

			</id>

			<description>

				<xsl:value-of select=".//ProjectTOADescr"/>

			</description>

			<name>

				<xsl:value-of select="$toaCode"/>

			</name>

			<class>ec:h2020toas</class>

			<parent>

				<funding_level_1>

					<id>

						<xsl:value-of select="concat($funderID, '::H2020::ERC')"/>

					</id>

					<description>

						<xsl:value-of select="string('European Research Council')"/>

					</description>

					<name>

						<xsl:value-of select="string('ERC')"/>

					</name>

					<class>ec:h2020fundings</class>

					<parent>

						<funding_level_0>

							<id>

								<xsl:value-of select="concat($funderID, '::H2020')"/>

							</id>

							<name>H2020</name>

							<description>Horizon 2020 Framework Programme</description>

							<parent/>

							<class>ec:h2020fundings</class>

						</funding_level_0>

					</parent>

				</funding_level_1>

			</parent>

		</funding_level_2>

	</xsl:template>

	<xsl:template name="other">

		<xsl:param name="toaCode"/>

		<xsl:variable name="toaId" select="concat($funderID, '::H2020::', $toaCode)"/>

		<funding_level_1>

			<id>

				<xsl:value-of select="$toaId"/>

			</id>

			<description>

				<xsl:value-of select=".//ProjectTOADescr"/>

			</description>

			<name>

				<xsl:value-of select="$toaCode"/>

			</name>

			<class>ec:h2020toas</class>

			<parent>

				<funding_level_0>

					<id>

						<xsl:value-of select="concat($funderID, '::H2020')"/>

					</id>

					<name>H2020</name>

					<description>Horizon 2020 Framework Programme</description>

					<parent/>

					<class>ec:h2020fundings</class>

				</funding_level_0>

			</parent>

		</funding_level_1>

	</xsl:template>

</xsl:stylesheet>

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

                xmlns:fn="http://www.w3.org/2005/xpath-functions" version="1.0"

                exclude-result-prefixes="fn">

	<xsl:variable name="namespacePrefix" select="string('wt__________')"/>

	<xsl:variable name="funderID" select="concat($namespacePrefix, '::WT')"/>

	<xsl:template match="/">

		<xsl:variable name="funding">

			<xsl:choose>

				<xsl:when test="normalize-space(.//Grant/Stream)">

					<xsl:value-of select="normalize-space(.//Grant/Stream)"/>

				</xsl:when>

				<xsl:otherwise>

					<xsl:value-of select="string('UNKNOWN')"/>

				</xsl:otherwise>

			</xsl:choose>

		</xsl:variable>

		<fundingtree>

			<funder>

				<id>

					<xsl:value-of select="$funderID"/>

				</id>

				<shortname>WT</shortname>

				<name>Wellcome Trust</name>

				<jurisdiction></jurisdiction>

			</funder>

			<funding_level_0>

				<id>

					<xsl:value-of select="concat($funderID, '::', $funding)"/>

				</id>

				<description>

					<xsl:value-of select="$funding"/>

				</description>

				<name>

					<xsl:value-of select="$funding"/>

				</name>

				<parent></parent>

				<class>wt:fundingStream</class>

			</funding_level_0>

		</fundingtree>

	</xsl:template>

</xsl:stylesheet>

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0"

	xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fn="http://www.w3.org/2005/xpath-functions"

	exclude-result-prefixes="fn">

	<xsl:variable name="namespacePrefix" select="string('sfi_________')" />

	<xsl:variable name="funderId" select="concat($namespacePrefix, '::SFI')" />

	<xsl:template match="/">

		<fundingtree>

			<funder>

				<id><xsl:value-of select="$funderId" /></id>

				<shortname>SFI</shortname>

				<name><xsl:value-of select=".//column[@name='Funder Name']" /></name>

				<jurisdiction>IE</jurisdiction>

			</funder>

			<xsl:variable name="funding" select="normalize-space(.//column[@name='Programme'])" />

			<xsl:if test="$funding">

				<funding_level_0>

					<id><xsl:value-of select="concat($funderId, '::', $funding)" /></id>

					<description><xsl:value-of select="$funding" /></description>

					<name><xsl:value-of select="$funding" /></name>

					<parent></parent>

					<class>sfi:fundingStream</class>

				</funding_level_0>

			</xsl:if>

		</fundingtree>

	</xsl:template>

</xsl:stylesheet>

SELECT d.id AS datasourceid,

regexp_replace(d.id, '^.*::', '') AS originalid,

d.officialname AS officialname,

d.englishname AS englishname,

CASE

WHEN (array_agg( DISTINCT tcc.compliance :: TEXT ) @> ARRAY ['driver', 'openaire2.0'])

THEN

				'driver-openaire2.0@@@OpenAIRE 2.0+ (DRIVER OA, EC funding)@@@dnet:datasourceCompatibilityLevel@@@dnet:datasourceCompatibilityLevel'

WHEN (array_agg( DISTINCT tcc.compliance :: TEXT ) @> ARRAY ['driver'])

THEN

				'driver@@@OpenAIRE Basic (DRIVER OA)@@@dnet:datasourceCompatibilityLevel@@@dnet:datasourceCompatibilityLevel'

WHEN (array_agg( DISTINCT tcc.compliance :: TEXT ) @> ARRAY ['openaire2.0'])

THEN

				'openaire2.0@@@OpenAIRE 2.0 (EC funding)@@@dnet:datasourceCompatibilityLevel@@@dnet:datasourceCompatibilityLevel'

WHEN (array_agg( DISTINCT tcc.compliance :: TEXT ) @> ARRAY ['openaire3.0'])

THEN

				'openaire3.0@@@OpenAIRE 3.0 (OA, funding)@@@dnet:datasourceCompatibilityLevel@@@dnet:datasourceCompatibilityLevel'

WHEN (array_agg( DISTINCT tcc.compliance :: TEXT ) @> ARRAY ['openaire2.0_data'])

THEN

'openaire2.0_data@@@OpenAIRE Data (funded, referenced datasets)@@@dnet:datasourceCompatibilityLevel@@@dnet:datasourceCompatibilityLevel'

WHEN (array_agg( DISTINCT tcc.compliance :: TEXT ) @> ARRAY ['native'])

THEN

				'native@@@proprietary@@@dnet:datasourceCompatibilityLevel@@@dnet:datasourceCompatibilityLevel'

WHEN (array_agg( DISTINCT tcc.compliance :: TEXT ) @> ARRAY ['hostedBy'])

THEN

	'hostedBy@@@collected from a compatible aggregator@@@dnet:datasourceCompatibilityLevel@@@dnet:datasourceCompatibilityLevel'

WHEN (array_agg( DISTINCT tcc.compliance :: TEXT ) @> ARRAY ['notCompatible'])

THEN

				'notCompatible@@@under validation@@@dnet:datasourceCompatibilityLevel@@@dnet:datasourceCompatibilityLevel'

ELSE

				'UNKNOWN@@@not available@@@dnet:datasourceCompatibilityLevel@@@dnet:datasourceCompatibilityLevel'

END AS openairecompatibility,

d.websiteurl AS websiteurl,

d.logourl AS logourl,

d.contactemail AS contactemail,

array_agg( DISTINCT CASE

			WHEN apc.param='baseUrl' and api.protocolclass='oai' THEN

				CASE WHEN COALESCE(apc.edited, '') = ''  THEN apc.original ELSE apc.edited END

			ELSE

				NULL

END ) AS accessinfopackage, -- we need baseUrl param only -when available-, but we can not use WHERE clause on apc.param, otherwise we exclude datasources without a baseUrl param and the returned rows are less than we expect.

		d.latitude					as latitude,

		d.longitude					as longitude,

		d.namespaceprefix			as namespaceprefix,

		d.od_numberofitems			as odnumberofitems,          	

		d.od_numberofitemsdate		as odnumberofitemsdate,      		

		array_agg(DISTINCT s.name || '###' || sc.code || '@@@' || sc.name || '@@@' || ss.code || '@@@' || ss.name) as subjects,

		d.description				as description,

		d.od_policies				as odpolicies,

		ARRAY(select trim(s) from unnest(string_to_array(d.od_languages, ',')) as s)  as odlanguages,

		ARRAY(select trim(s) from unnest(string_to_array(d.od_contenttypes, '-')) as s) as odcontenttypes,

		d.inferred					as inferred,

		d.deletedbyinference		as deletedbyinference,

		d.trust						as trust,

		d.inferenceprovenance		as inferenceprovenance,

		d.dateofcollection			as dateofcollection,

		d.dateofvalidation			as dateofvalidation,

		-- re3data fields

		d.releasestartdate			as releasestartdate,

		d.releaseenddate			as releaseenddate,

		d.missionstatementurl		as missionstatementurl,

		d.dataprovider				as dataprovider,

		d.serviceprovider			as serviceprovider,

		d.databaseaccesstype		as databaseaccesstype,

		d.datauploadtype			as datauploadtype,

		d.databaseaccessrestriction	as databaseaccessrestriction,

		d.datauploadrestriction		as datauploadrestriction,

		d.versioning				as versioning,

		d.citationguidelineurl		as citationguidelineurl,

		d.qualitymanagementkind		as qualitymanagementkind,

		d.pidsystems				as pidsystems,

		d.certificates				as certificates,

		array_agg(DISTINCT p.name || '&&&' || p.url) as policies,

		-- end of re3data fields

		dc.id					as collectedfromid,

		dc.officialname			as collectedfromname,

		tc.code || '@@@' || tc.name || '@@@' || ts.code || '@@@' || ts.name	as datasourcetype,

		pac.code || '@@@' || pac.name || '@@@' || pas.code || '@@@' || pas.name	as provenanceaction,

		array_agg(DISTINCT i.pid || '###' || idc.code || '@@@' || idc.name || '@@@' || ids.code || '@@@' || ids.name) as pid

FROM datasources d

	left outer join class tc on (tc.code = d.datasourceclass)	

	left outer join scheme ts on (ts.code = d.datasourcescheme)

	left outer join class pac on (pac.code = d.provenanceactionclass)	

	left outer join scheme pas on (pas.code = d.provenanceactionscheme)		

	left outer join datasourcepids dps on (dps.datasource = d.id)

	left outer join identities i on (i.pid = dps.pid)

	left outer join class idc on (idc.code = i.issuertypeclass)

	left outer join scheme ids on (ids.code = i.issuertypescheme)

	left outer join datasources dc on (dc.id = d.collectedfrom)

	left outer join api on (api.datasource = d.id)

	left outer join apicollections apc on (apc.api = api.id)	

	left outer join temp_compliances tcc on (tcc.api = api.id)	

	left outer join datasource_subject ds on (ds.datasource = d.id)

	left outer join subjects s on (s.id = ds.subject) 

	left outer join class sc on (sc.code = s.semanticclass)

	left outer join scheme ss on (ss.code = s.semanticscheme)

	left outer join datasource_policy dp on (dp.datasource = d.id)

	left outer join policies p on (p.id = dp.policy)

--  These clauses have been commented to allow the import of all the datasource on the index 

-- WHERE d.datasourceclass != 'entityregistry'

--	AND d.openairecompatibilityclass IS NOT null

--	AND d.openairecompatibilityclass != 'UNKNOWN'

--	AND d.openairecompatibilityclass != 'notCompatible'

GROUP BY 

		d.id,

		d.officialname, 

		d.englishname,

		d.websiteurl,

		d.logourl,

		d.contactemail,

		d.namespaceprefix,

		d.description,

		d.od_numberofitems,          	

		d.od_numberofitemsdate,      		

		d.od_policies,

		d.od_languages,         		

		d.od_contenttypes,

		d.latitude,

		d.longitude,

		d.inferred,

		d.deletedbyinference,

		d.trust,

		d.inferenceprovenance,

		d.dateofcollection,

		d.dateofvalidation,

		dc.id,

		d.releasestartdate,

		d.releaseenddate,

		d.missionstatementurl,

		d.dataprovider,

		d.serviceprovider,

		d.databaseaccesstype,

		d.datauploadtype,

		d.databaseaccessrestriction,

		d.datauploadrestriction,

		d.versioning,

		d.citationguidelineurl,

		d.qualitymanagementkind,

		d.pidsystems,

		d.certificates,

		dc.officialname,

		tc.code, tc.name, ts.code, ts.name, 

		pac.code, pac.name, pas.code, pas.name,

		sc.code, sc.name, ss.code, ss.name

--WITH RECURSIVE fundingtree(id, parent_id, payload, depth) 

--AS (

--	SELECT  f.id, 

--		ff.funding1, 

--		'{"funding_level_0":{"class":"' || f.semanticclass || '", "id":"' || f.id || '", "description":"' || f.description || '", "name":"' || f.name || '", "parent":{}}}', 

--		1

--		FROM fundings f LEFT OUTER JOIN funding_funding ff ON f.id = ff.funding1 

--		WHERE ff.funding2 IS NULL

--	UNION 

--	SELECT  f1.id, 

--		ff.funding2,

--		'{"funding_level_'||depth||'":{"class":"' || f1.semanticclass || '", "id":"' || f1.id || '", "description":"' || f1.description || '", "name":"' || f1.name || '", "parent":'|| ft.payload ||'}}',

--		ft.depth + 1

--		FROM funding_funding ff, fundingtree ft, fundings f2, fundings f1

--		WHERE ft.id = ff.funding2 AND f2.id = ft.id AND ff.funding1 = f1.id AND depth <= 10)		

SELECT 	p.id 					                    as projectid,

		p.code										as code,

		p.websiteurl               					as websiteurl,		

		p.acronym                  					as acronym,

		p.title                    					as title,

		p.startdate									as startdate,

		p.enddate                 					as enddate,

		p.call_identifier          					as callidentifier,

		p.keywords									as keywords,		

		p.duration									as duration,

		p.ec_sc39				                    as ecsc39,

		p.oa_mandate_for_publications               as oamandatepublications,

		p.ec_article29_3                            as ecarticle29_3,

		p.dateofcollection							as dateofcollection,

		p.inferred									as inferred,

		p.deletedbyinference						as deletedbyinference,

		p.trust										as trust,

		p.inferenceprovenance						as inferenceprovenance,

		p.optional1										as optional1,

		p.optional2										as optional2,

		p.jsonextrainfo         as jsonextrainfo,

		dc.id										as collectedfromid,

		dc.officialname								as collectedfromname,

		cc.code || '@@@' || cc.name || '@@@' || cs.code || '@@@' || cs.name	as contracttype,

		pac.code || '@@@' || pac.name || '@@@' || pas.code || '@@@' || pas.name	as provenanceaction,

		array_agg(DISTINCT i.pid  || '###' || idc.code || '@@@' || idc.name || '@@@' || ids.code || '@@@' || ids.name)	as pid,

		array_agg(DISTINCT s.name || '###' || sc.code  || '@@@' || sc.name  || '@@@' || ss.code  || '@@@' || ss.name)   as subjects,

		array_agg(fp.path)		                as fundingtree

FROM projects p

	left outer join class cc on (cc.code = p.contracttypeclass)	

	left outer join scheme cs on (cs.code = p.contracttypescheme)

	left outer join class pac on (pac.code = p.provenanceactionclass)	

	left outer join scheme pas on (pas.code = p.provenanceactionscheme)		

	left outer join projectpids pp on (pp.project = p.id)

	left outer join identities i on (i.pid = pp.pid)

	left outer join class idc on (idc.code = i.issuertypeclass)

	left outer join scheme ids on (ids.code = i.issuertypescheme)

	left outer join datasources dc on (dc.id = p.collectedfrom)

	left outer join project_fundingpath pf on (pf.project = p.id)

	left outer join fundingpaths fp on (fp.id = pf.funding)

	left outer join project_subject ps on (ps.project = p.id)

	left outer join subjects s on (s.id = ps.subject)

	left outer join class sc on (sc.code = s.semanticclass)

	left outer join scheme ss on (ss.code = s.semanticscheme)

GROUP BY 	

		p.id,

		p.code,

		p.websiteurl,		

		p.acronym,

		p.title,

		p.startdate,

		p.enddate,

		p.call_identifier,

		p.keywords,		

		p.duration,

		p.ec_sc39,

		p.oa_mandate_for_publications,

		p.ec_article29_3,

		p.dateofcollection,

		p.inferred,

		p.deletedbyinference,

		p.trust,

		p.inferenceprovenance,

		dc.id,

		dc.officialname,		

		cc.code, cc.name, cs.code, cs.name,

		pac.code, pac.name, pas.code, pas.name

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:dr="http://www.driver-repository.eu/namespace/dr"

	xmlns:dri="http://www.driver-repository.eu/namespace/dri" xmlns:oaa="http://namespace.openaire.eu/oaa" xmlns:oaf="http://namespace.openaire.eu/oaf" xmlns:fn="http://www.w3.org/2005/xpath-functions">

	<xsl:param name="parentDatasourceId" />

	<xsl:template name="dateCorda">

		<xsl:param name="datename" />

		<xsl:param name="datevalue" />

		<FIELD name="{$datename}" type="date" format="dd-MMM-yyyy"><xsl:value-of select="concat(substring($datevalue, 1, 2),'-',substring($datevalue,3,3),'-',substring($datevalue,6,4))" /></FIELD>

	</xsl:template>

	<xsl:variable name="namespacePrefix" select="string('ec__________')" />

	<xsl:variable name="funderID" select="concat($namespacePrefix, '::EC')" />

	<xsl:template match="/">

		<record xmlns:dr="http://www.driver-repository.eu/namespace/dr"

			xmlns:dri="http://www.driver-repository.eu/namespace/dri"

			xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

			xmlns:oaf="http://namespace.openaire.eu/oaf" xmlns:oai_dc="http://www.openarchives.org/OAI/2.0/oai_dc/">

			<xsl:copy-of select=".//*[local-name()='header']"/>

			<metadata>

				<ROWS>

					<xsl:for-each select="//CoordinatorContactPerson">

						<xsl:if test="string-length(./PersonFirstName) &gt; 0 and string-length(./PersonLastName) &gt; 0">

							<xsl:variable name="personId" select="concat('corda_______::', ../ProjectId, '::', ./PersonFirstName, '_', ./PersonLastName)"></xsl:variable>

							<ROW table="persons">

								<FIELD name="_dnet_resource_identifier_"><xsl:value-of select="$personId" /></FIELD>

								<FIELD name="id"><xsl:value-of select="$personId" /></FIELD>

								<FIELD name="firstname"><xsl:value-of select="./PersonFirstName" /></FIELD>

								<FIELD name="secondnames"><xsl:value-of select="./PersonLastName" /></FIELD>

								<FIELD name="fax"><xsl:value-of select="./ContactFax" /></FIELD>

								<FIELD name="email"><xsl:value-of select="./ContactEmail" /></FIELD>

								<FIELD name="phone"><xsl:value-of select="./ContactPhone" /></FIELD>

								<FIELD name="collectedfrom"><xsl:value-of select="$parentDatasourceId" /></FIELD>

								<FIELD name="provenanceActionClass">sysimport:crosswalk:entityregistry</FIELD>

								<FIELD name="provenanceActionScheme">dnet:provenanceActions</FIELD>

							</ROW>

						</xsl:if>

					</xsl:for-each>

					<xsl:for-each select="//Project">

						<xsl:variable name="specificName">

							<xsl:choose>

								<xsl:when test="normalize-space(./ProjectSpecificProgram)">

									<xsl:value-of select="normalize-space(./ProjectSpecificProgram)"/>

								</xsl:when>

								<xsl:otherwise>

									<xsl:value-of select="string('UNKNOWN')"/>

								</xsl:otherwise>

							</xsl:choose>

						</xsl:variable>

						<xsl:variable name="specificDesc" select="./ProjectSpecificProgramDescr" />

						<xsl:variable name="specificId" select="normalize-space(concat($funderID, '::FP7::', $specificName))"/>	

						<xsl:variable name="projectProgramName">

							<xsl:choose>

								<xsl:when test="normalize-space(./ProjectProgram)">

									<xsl:value-of select="normalize-space(./ProjectProgram)"/>

								</xsl:when>

								<xsl:otherwise>

									<xsl:value-of select="string('UNKNOWN')"/>

								</xsl:otherwise>

							</xsl:choose>

						</xsl:variable>

						<xsl:variable name="projectProgramDesc" select="./ProjectProgramDescr" />

						<xsl:variable name="projectProgramId" select="concat($funderID, '::FP7::', $specificName, '::', $projectProgramName)"/>

						<xsl:variable name="projectId" select="concat('corda_______::', normalize-space(./ProjectId))"/>

						<!-- 

						<ROW table="fundings">

							<FIELD name="_dnet_resource_identifier_"><xsl:value-of select="$specificId" /></FIELD>

							<FIELD name="id"><xsl:value-of select="$specificId" /></FIELD>

							<FIELD name="name"><xsl:value-of select="$specificName" /></FIELD>

							<FIELD name="description"><xsl:value-of select="$specificDesc" /></FIELD>

							<FIELD name="semanticclass">ec:specificprogram</FIELD>

							<FIELD name="semanticscheme">ec:funding_typologies</FIELD>

						</ROW>

						<ROW table="fundings">

							<FIELD name="_dnet_resource_identifier_"><xsl:value-of select="$projectProgramId" /></FIELD>

							<FIELD name="id"><xsl:value-of select="$projectProgramId" /></FIELD>

							<FIELD name="name"><xsl:value-of select="$projectProgramName" /></FIELD>

							<FIELD name="description"><xsl:value-of select="$projectProgramDesc" /></FIELD>

							<FIELD name="semanticclass">ec:program</FIELD>

							<FIELD name="semanticscheme">ec:funding_typologies</FIELD>

						</ROW>

						<ROW table="funding_funding">

							<FIELD name="_dnet_resource_identifier_"><xsl:value-of select="concat($specificId, '@@corda_______::FP7')" /></FIELD>

							<FIELD name="funding1"><xsl:value-of select="$specificId" /></FIELD>

							<FIELD name="funding2">corda_______::FP7</FIELD>

							<FIELD name="semanticclass">ec:hasframeworkprogram</FIELD>

							<FIELD name="semanticscheme">ec:funding_relations</FIELD>

						</ROW>

						<ROW table="funding_funding">

							<FIELD name="_dnet_resource_identifier_"><xsl:value-of select="concat($projectProgramId, '@@', $specificId)" /></FIELD>

							<FIELD name="funding1"><xsl:value-of select="$projectProgramId" /></FIELD>

							<FIELD name="funding2"><xsl:value-of select="$specificId" /></FIELD>

							<FIELD name="semanticclass">ec:hasspecificprogram</FIELD>

							<FIELD name="semanticscheme">ec:funding_relations</FIELD>

						</ROW>

						-->

						<ROW table="projects">

							<FIELD name="_dnet_resource_identifier_"><xsl:value-of select="$projectId" /></FIELD>

							<FIELD name="id"><xsl:value-of select="$projectId" /></FIELD>

							<FIELD name="code"><xsl:value-of select="./ProjectId" /></FIELD>

							<FIELD name="acronym"><xsl:value-of select="./ProjectAcronym" /></FIELD>

							<FIELD name="title"><xsl:value-of select="./ProjectTitle" /></FIELD>

							<xsl:call-template name="dateCorda">

								<xsl:with-param name="datename">startdate</xsl:with-param>

								<xsl:with-param name="datevalue" select="./ProjectStartDate"></xsl:with-param>

							</xsl:call-template>

							<xsl:call-template name="dateCorda">

								<xsl:with-param name="datename">enddate</xsl:with-param>

								<xsl:with-param name="datevalue" select="./ProjectEndDate"></xsl:with-param>

							</xsl:call-template> 

							<FIELD name="call_identifier"><xsl:value-of select="./ProjectCallIdentifier" /></FIELD>

							<FIELD name="ec_sc39" type="boolean"><xsl:value-of select="./SpecialClause39" /></FIELD>

							<FIELD name="oa_mandate_for_publications" type="boolean"><xsl:value-of select="./SpecialClause39" /></FIELD>

							<FIELD name="collectedfrom"><xsl:value-of select="$parentDatasourceId" /></FIELD>

							<FIELD name="contracttypeclass"><xsl:value-of select="./ProjectFundingScheme" /></FIELD>

							<FIELD name="contracttypescheme">ec:FP7contractTypes</FIELD>

							<FIELD name="provenanceActionClass">sysimport:crosswalk:entityregistry</FIELD>

							<FIELD name="provenanceActionScheme">dnet:provenanceActions</FIELD>

							<FIELD name="websiteurl"><xsl:value-of select="./ProjectInternetAddress" /></FIELD>

							<FIELD name="optional1"><xsl:value-of select="./ProjectSubFundingScheme" /></FIELD>

							<FIELD name="optional2"><xsl:value-of select="./ProjectCallWebpageUrl" /></FIELD>

						</ROW>

						<!-- 

						<ROW table="project_funding">

							<FIELD name="_dnet_resource_identifier_"><xsl:value-of select="concat($projectProgramId, '@@', $projectId)" /></FIELD>

							<FIELD name="funding"><xsl:value-of select="$projectProgramId" /></FIELD>

							<FIELD name="project"><xsl:value-of select="$projectId" /></FIELD>

							<xsl:call-template name="dateCorda">

								<xsl:with-param name="datename">startdate</xsl:with-param>

								<xsl:with-param name="datevalue" select="./ProjectStartDate"></xsl:with-param>

							</xsl:call-template>

							<xsl:call-template name="dateCorda">

								<xsl:with-param name="datename">enddate</xsl:with-param>

								<xsl:with-param name="datevalue" select="./ProjectEndDate"></xsl:with-param>

							</xsl:call-template> 

							<FIELD name="semanticclass"><xsl:value-of select="./ProjectFundingScheme" /></FIELD>

							<FIELD name="semanticscheme">ec:FP7contractTypes</FIELD>

						</ROW>

						-->

						<ROW table="project_fundingpath">

							<FIELD name="_dnet_resource_identifier_"><xsl:value-of select="concat($projectProgramId, '@@', $projectId)" /></FIELD>

							<FIELD name="funding"><xsl:value-of select="$projectProgramId" /></FIELD>

							<FIELD name="project"><xsl:value-of select="$projectId" /></FIELD>

							<xsl:call-template name="dateCorda">

								<xsl:with-param name="datename">startdate</xsl:with-param>

								<xsl:with-param name="datevalue" select="./ProjectStartDate"></xsl:with-param>

							</xsl:call-template>

							<xsl:call-template name="dateCorda">

								<xsl:with-param name="datename">enddate</xsl:with-param>

								<xsl:with-param name="datevalue" select="./ProjectEndDate"></xsl:with-param>

							</xsl:call-template> 

							<FIELD name="semanticclass"><xsl:value-of select="./ProjectFundingScheme" /></FIELD>

							<FIELD name="semanticscheme">ec:FP7contractTypes</FIELD>

						</ROW>

					</xsl:for-each>

					<xsl:for-each select="//OrganisationParticipant">

						<xsl:variable name="organizationId" select="concat('corda_______::', ./OrganisationPIC)" />

						<xsl:variable name="projectId" select="concat('corda_______::', normalize-space(../ProjectId))" />

						<xsl:variable name="whitelist" select="'0123456789'"/>

						<ROW table="organizations">

							<FIELD name="_dnet_resource_identifier_"><xsl:value-of select="$organizationId" /></FIELD>

							<FIELD name="id"><xsl:value-of select="$organizationId" /></FIELD>

							<FIELD name="legalshortname"><xsl:value-of select="./OrganisationShortName" /></FIELD>

							<FIELD name="legalname"><xsl:value-of select="./OrganisationLegalName" /></FIELD>

							<FIELD name="websiteurl">

								<xsl:choose>

									<xsl:when test="starts-with(normalize-space(./OrganisationWebPage), 'http')">

										<xsl:value-of select="./OrganisationWebPage" />

									</xsl:when>

									<xsl:when test="string-length(normalize-space(./OrganisationWebPage)) &gt; 0">

										<xsl:value-of select="concat('http://', normalize-space(./OrganisationWebPage))" />

									</xsl:when>

								</xsl:choose>

							</FIELD>

							<FIELD name="ec_legalbody" type="boolean"><xsl:value-of select="./PublicBody" /></FIELD>

							<FIELD name="ec_legalperson" type="boolean"><xsl:value-of select="./LegalPerson" /></FIELD>

							<FIELD name="ec_nonprofit" type="boolean"><xsl:value-of select="./NonProfit" /></FIELD>

							<FIELD name="ec_researchorganization" type="boolean"><xsl:value-of select="./ResearchOrganisation" /></FIELD>

							<FIELD name="ec_highereducation" type="boolean"><xsl:value-of select="./HigherEducation" /></FIELD>

							<FIELD name="ec_internationalorganizationeurinterests" type="boolean"><xsl:value-of select="./InternationalOrgEurInterest" /></FIELD>

							<FIELD name="ec_internationalorganization" type="boolean"><xsl:value-of select="./InternationalOrgEurInterest" /></FIELD>

							<FIELD name="ec_enterprise" type="boolean"><xsl:value-of select="./Enterprise" /></FIELD>

							<FIELD name="ec_smevalidated" type="boolean"><xsl:value-of select="./SMEValidated" /></FIELD>

							<FIELD name="countryclass"><xsl:value-of select="./OrganisationCountry" /></FIELD>

							<FIELD name="countryscheme">dnet:countries</FIELD>

							<FIELD name="collectedfrom"><xsl:value-of select="$parentDatasourceId" /></FIELD>

							<FIELD name="provenanceActionClass">sysimport:crosswalk:entityregistry</FIELD>

							<FIELD name="provenanceActionScheme">dnet:provenanceActions</FIELD>

							<FIELD name="trust" type="float"><xsl:value-of select="0.91" /></FIELD>

						</ROW>

						<ROW table="project_organization">

							<FIELD name="_dnet_resource_identifier_"><xsl:value-of select='concat($projectId, "@@", $organizationId)' /></FIELD>

							<xsl:choose>

								<xsl:when test="string-length(translate(./ParticipantOrder, $whitelist, '')) &gt; 0" > 

									<FIELD name="participantnumber" type="int">9999</FIELD>

								</xsl:when>

								<xsl:otherwise>

									<FIELD name="participantnumber" type="int"><xsl:value-of select="./ParticipantOrder" /></FIELD>

								</xsl:otherwise>

							</xsl:choose>

							<FIELD name="project"><xsl:value-of select="$projectId" /></FIELD>

							<FIELD name="resporganization"><xsl:value-of select="$organizationId" /></FIELD>

							<xsl:choose>

								<xsl:when test="./ParticipantOrder = 1">

									<FIELD name="contactperson"><xsl:value-of select="concat($projectId, '::', ..//CoordinatorContactPerson/PersonFirstName, '_', ../CoordinatorContactPerson/PersonLastName)"></xsl:value-of></FIELD>

									<FIELD name="semanticclass">coordinator</FIELD>

								</xsl:when>

								<xsl:otherwise>

									<FIELD name="contactperson"></FIELD>

									<FIELD name="semanticclass">participant</FIELD>

								</xsl:otherwise>

							</xsl:choose>

							<FIELD name="semanticscheme">dnet:project_organization_relations</FIELD>

						</ROW>

					</xsl:for-each>		

				</ROWS>

			</metadata>

		</record>

	</xsl:template>

</xsl:stylesheet>

SELECT

	regexp_replace(xml, '<\?xml version="1\.0" encoding="UTF-8"\?>', '', 'i') AS xml,

	provenance

FROM claims

WHERE type = 'updates2actions' AND set = 'userclaim_dmf'

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:dr="http://www.driver-repository.eu/namespace/dr"

				xmlns:dri="http://www.driver-repository.eu/namespace/dri" xmlns:oaa="http://namespace.openaire.eu/oaa"

				xmlns:oaf="http://namespace.openaire.eu/oaf" xmlns:fn="http://www.w3.org/2005/xpath-functions"

				xmlns:dnet="eu.dnetlib.data.transform.xml.AbstractDNetXsltFunctions" version="1.0">

	<xsl:param name="parentDatasourceId"/>

	<xsl:param name="namespacePrefix"/>

	<xsl:template match="/">

		<record xmlns:dr="http://www.driver-repository.eu/namespace/dr"

				xmlns:dri="http://www.driver-repository.eu/namespace/dri"

				xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

				xmlns:oaf="http://namespace.openaire.eu/oaf" xmlns:oai_dc="http://www.openarchives.org/OAI/2.0/oai_dc/">

			<xsl:copy-of select=".//*[local-name()='header']"/>

			<metadata>

				<xsl:variable name="rid" select="normalize-space(//repository/@rID)"/>

				<xsl:variable name="datasourceId" select="concat($namespacePrefix, '::', $rid)"/>

				<xsl:variable name="oUrl" select="normalize-space(//oUrl)"/>

				<xsl:variable name="oName" select="normalize-space(//oName)"/>

				<xsl:variable name="organizationId" select="translate(concat($namespacePrefix, '::', $oName), ' ', '_')"/>

				<xsl:variable name="repositoryType">

					<xsl:choose>

						<xsl:when test="normalize-space(//repositoryType) = 'Institutional'">

							<xsl:value-of select="string('pubsrepository::institutional')"/>

						</xsl:when>

						<xsl:when test="normalize-space(//repositoryType) = 'Disciplinary'">

							<xsl:value-of select="string('pubsrepository::thematic')"/>

						</xsl:when>

						<xsl:otherwise>

							<xsl:value-of select="string('pubsrepository::unknown')"/>

						</xsl:otherwise>

					</xsl:choose>

				</xsl:variable>

				<xsl:variable name="contenttypes">

					<xsl:for-each select=".//contentType">

						<xsl:if test="position() &gt; 1">-</xsl:if>

						<xsl:value-of select="."/>

					</xsl:for-each>

				</xsl:variable>

				<xsl:variable name="languages">

					<xsl:for-each select=".//lName">

						<xsl:if test="position() &gt; 1">,</xsl:if>

						<xsl:value-of select="."/>

					</xsl:for-each>

				</xsl:variable>

				<ROWS>

					<ROW table="datasources">

						<FIELD name="id">

							<xsl:value-of select="$datasourceId"/>

						</FIELD>

						<FIELD name="_dnet_resource_identifier_">

							<xsl:value-of select="$datasourceId"/>

						</FIELD>

						<FIELD name="officialname">

							<xsl:value-of select="normalize-space(//rName)"/>

						</FIELD>

						<FIELD name="englishname">

							<xsl:value-of select="normalize-space(//rAcronym)"/>

						</FIELD>

						<FIELD name="od_contenttypes">

							<xsl:value-of select="normalize-space($contenttypes)"/>

						</FIELD>

						<FIELD name="od_languages">

							<xsl:value-of select="normalize-space($languages)"/>

						</FIELD>

						<FIELD name="od_numberofitems">

							<xsl:value-of select="normalize-space(//rNumOfItems)"/>

						</FIELD>

						<FIELD name="od_numberofitemsdate">

							<xsl:value-of select="normalize-space(//rDateHarvested)"/>

						</FIELD>

						<FIELD name="description">

							<xsl:value-of select="normalize-space(//rDescription)"/>

						</FIELD>

						<FIELD name="contactEmail">

							<xsl:value-of select="normalize-space(//pEmail)"/>

						</FIELD>

						<FIELD name="latitude" type="float">

							<xsl:value-of select="normalize-space(//paLatitude)"/>

						</FIELD>

						<FIELD name="longitude" type="float">

							<xsl:value-of select="normalize-space(//paLongitude)"/>

						</FIELD>

						<FIELD name="websiteurl">

							<xsl:value-of select="normalize-space(//rUrl)"/>

						</FIELD>

						<FIELD name="logourl"></FIELD>

						<FIELD name="namespaceprefix">

							<xsl:value-of select="dnet:generateNsPrefix('od', $rid)"/>

						</FIELD>

						<FIELD name="datasourceclass">

							<xsl:value-of select="$repositoryType"/>

						</FIELD>

						<FIELD name="datasourcescheme">dnet:datasource_typologies</FIELD>

						<FIELD name="provenanceActionClass">sysimport:crosswalk:entityregistry</FIELD>

						<FIELD name="provenanceActionScheme">dnet:provenanceActions</FIELD>

						<FIELD name="typology">

							<xsl:value-of select="normalize-space(//rSoftWareName)"/>

						</FIELD>

						<FIELD name="optional1"></FIELD>

						<FIELD name="optional2"></FIELD>

						<FIELD name="collectedfrom">

							<xsl:value-of select="$parentDatasourceId"/>

						</FIELD>

					</ROW>

					<xsl:for-each select=".//class">

						<xsl:variable name="subjectId" select="normalize-space(concat($parentDatasourceId, '::', ./clCode))"/>

						<xsl:variable name="subjectValue" select="normalize-space(./clTitle)"/>

						<ROW table="subjects">

							<FIELD name="id">

								<xsl:value-of select="$subjectId"/>

							</FIELD>

							<FIELD name="name">

								<xsl:value-of select="$subjectValue"/>

							</FIELD>

							<FIELD name="semanticclass">dnet:od_subjects</FIELD>

							<FIELD name="semanticscheme">dnet:subject_classification_typologies</FIELD>

							<FIELD name="_dnet_resource_identifier_">

								<xsl:value-of select="$subjectId"/>

							</FIELD>

						</ROW>

						<ROW table="datasource_subject">

							<FIELD name="datasource">

								<xsl:value-of select="$datasourceId"/>

							</FIELD>

							<FIELD name="subject">

								<xsl:value-of select="$subjectId"/>

							</FIELD>

							<FIELD name="_dnet_resource_identifier_">

								<xsl:value-of select="concat($datasourceId, '@@', $subjectId)"/>

							</FIELD>

						</ROW>

					</xsl:for-each>

					<xsl:variable name="apiId" select="concat('api_________::', $datasourceId, '::0')"/>

					<ROW table="api">

						<FIELD name="id">

							<xsl:value-of select="$apiId"/>

						</FIELD>

						<FIELD name="_dnet_resource_identifier_">

							<xsl:value-of select="$apiId"/>

						</FIELD>

						<FIELD name="protocolclass">oai</FIELD>

						<FIELD name="datasource">

							<xsl:value-of select="$datasourceId"/>

						</FIELD>

						<FIELD name="contentdescriptionclass">metadata</FIELD>

						<FIELD name="typologyclass">

							<xsl:value-of select="$repositoryType"/>

						</FIELD>

					</ROW>

					<ROW table="apicollections">

						<FIELD name="api">

							<xsl:value-of select="$apiId"/>

						</FIELD>

						<FIELD name="param">baseUrl</FIELD>

						<FIELD name="_dnet_resource_identifier_">

							<xsl:value-of select="concat($apiId, '@@baseUrl')"/>

						</FIELD>

						<xsl:choose>

							<xsl:when test="string-length(normalize-space(//rOaiBaseUrl)) &gt; 0">

								<FIELD name="original">

									<xsl:value-of select="normalize-space(//rOaiBaseUrl)"/>

								</FIELD>

							</xsl:when>

							<xsl:otherwise>

								<FIELD name="original">unknown</FIELD>

							</xsl:otherwise>

						</xsl:choose>

					</ROW>

					<ROW table="apicollections">

						<FIELD name="api">

							<xsl:value-of select="$apiId"/>

						</FIELD>

						<FIELD name="param">format</FIELD>

						<FIELD name="_dnet_resource_identifier_">

							<xsl:value-of select="concat($apiId, '@@format')"/>

						</FIELD>

						<FIELD name="original">oai_dc</FIELD>

					</ROW>

					<ROW table="apicollections">

						<FIELD name="api">

							<xsl:value-of select="$apiId"/>

						</FIELD>

						<FIELD name="param">metadata_identifier_path</FIELD>

						<FIELD name="_dnet_resource_identifier_">

							<xsl:value-of select="concat($apiId, '@@metadata_identifier_path')"/>

						</FIELD>

						<FIELD name="original">//*[local-name()='header']/*[local-name()='identifier']</FIELD>

						<FIELD name="accessparam" type="boolean">false</FIELD>

					</ROW>

					<ROW table="organizations">

						<FIELD name="id">

							<xsl:value-of select="$organizationId"/>

						</FIELD>

						<FIELD name="_dnet_resource_identifier_">

							<xsl:value-of select="$organizationId"/>

						</FIELD>

						<FIELD name="legalname">

							<xsl:value-of select="$oName"/>

						</FIELD>

						<FIELD name="legalshortname">

							<xsl:value-of select="normalize-space(//oAcronym)"/>

						</FIELD>

						<FIELD name="websiteurl">

							<xsl:choose>

								<xsl:when test="starts-with(normalize-space(//oUrl), 'http')">

									<xsl:value-of select="normalize-space(//oUrl)" />

								</xsl:when>

								<xsl:when test="string-length(normalize-space(//oUrl)) &gt; 0">

									<xsl:value-of select="concat('http://', normalize-space(//oUrl))" />

								</xsl:when>

							</xsl:choose>

						</FIELD>

						<FIELD name="countryClass">

							<xsl:choose>

								<xsl:when test="normalize-space(//cIsoCode) = 'GB'">UK</xsl:when>

								<xsl:otherwise>

									<xsl:value-of select="normalize-space(//cIsoCode)"></xsl:value-of>

								</xsl:otherwise>

							</xsl:choose>

						</FIELD>

						<FIELD name="countryScheme">dnet:countries</FIELD>

						<FIELD name="collectedfrom">

							<xsl:value-of select="$parentDatasourceId"/>

						</FIELD>

						<FIELD name="provenanceActionClass">sysimport:crosswalk:entityregistry</FIELD>

						<FIELD name="provenanceActionScheme">dnet:provenanceActions</FIELD>

						<FIELD name="trust" type="float">0.8</FIELD>

					</ROW>

					<ROW table="datasource_organization">

						<FIELD name="datasource">

							<xsl:value-of select="$datasourceId"/>

						</FIELD>

						<FIELD name="organization">

							<xsl:value-of select="$organizationId"/>

						</FIELD>

						<FIELD name="_dnet_resource_identifier_">

							<xsl:value-of select="concat($datasourceId,'@@',$organizationId)"/>

						</FIELD>

					</ROW>

				</ROWS>

			</metadata>

		</record>

	</xsl:template>

</xsl:stylesheet>

<NODE name="COLLECT" isStart="true" type="FetchMDStoreRecords">

	<DESCRIPTION>Fetch records from MDStore</DESCRIPTION>

	<PARAMETERS>

		<PARAM required="true" type="string" name="mdId" managedBy="system" category="MDSTORE_ID">$params.("orig_id")$</PARAM>

		<PARAM required="true" type="string" name="mdFormat" managedBy="system">$params.("orig_format")$</PARAM>

		<PARAM required="true" type="string" name="eprParam" managedBy="system">collected_epr</PARAM>

	</PARAMETERS>

	<ARCS>

		<ARC to="FIND_CONTEXTS"/>

	</ARCS>

</NODE>

<NODE name="FIND_CONTEXTS" type="ApplyXslt">

	<DESCRIPTION>Find project contexts</DESCRIPTION>

	<PARAMETERS>

		<PARAM required="true" type="string" name="xsltClasspath" managedBy="user" function="listFiles('/eu/dnetlib/msro/openaireplus/workflows/repo-hi/entityreg-contexts/xsl','xsl')"></PARAM>

		<PARAM required="true" type="string" name="inputEprParam" managedBy="system">collected_epr</PARAM>

		<PARAM required="true" type="string" name="outputEprParam" managedBy="system">contexts_epr</PARAM>

	</PARAMETERS>

	<ARCS>

		<ARC to="PROCESS_CONTEXTS"/>

	</ARCS>

</NODE>

<NODE name="PROCESS_CONTEXTS" type="ProcessContexts">

	<DESCRIPTION>Process project contexts</DESCRIPTION>

	<PARAMETERS>

		<PARAM required="true" type="string" name="eprParam" managedBy="system">contexts_epr</PARAM>

		<PARAM required="true" type="string" name="contextObj" managedBy="system">contexts</PARAM>

		<PARAM required="true" type="string" name="contextId" managedBy="user"></PARAM>

		<PARAM required="true" type="string" name="contextLabel" managedBy="user"></PARAM>

		<PARAM required="true" type="string" name="contextType" managedBy="user">funding</PARAM>

	</PARAMETERS>

	<ARCS>

		<ARC to="PREPARE_DB_ENTRIES"/>

	</ARCS>

</NODE>

<NODE name="PREPARE_DB_ENTRIES" type="PrepareContextDbEntries">

	<DESCRIPTION>Prepare the DB entries</DESCRIPTION>

	<PARAMETERS>

		<PARAM required="true" type="string" name="eprParam" managedBy="system">db_epr</PARAM>

		<PARAM required="true" type="string" name="contextObj" managedBy="system">contexts</PARAM>

	</PARAMETERS>

	<ARCS>

		<ARC to="UPDATE_DB"/>

	</ARCS>

</NODE>

<NODE name="UPDATE_DB" type="UpdateOpenaireDb">

	<DESCRIPTION>Update Db</DESCRIPTION>

	<PARAMETERS>

		<PARAM required="true" type="string" name="eprParam" managedBy="system">db_epr</PARAM>

	</PARAMETERS>

	<ARCS>

		<ARC to="SAVE_PROFILE"/>

	</ARCS>

</NODE>

<NODE name="SAVE_PROFILE" type="SaveContextProfile">

	<DESCRIPTION>Save the Context Profile</DESCRIPTION>

	<PARAMETERS>

		<PARAM required="true" type="string" name="contextObj" managedBy="system">contexts</PARAM>

	</PARAMETERS>

	<ARCS>

		<ARC to="success"/>

	</ARCS>

</NODE>

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

	xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:dc="http://purl.org/dc/elements/1.1/"

	xmlns:dr="http://www.driver-repository.eu/namespace/dr" xmlns:dri="http://www.driver-repository.eu/namespace/dri"

	xmlns:oaf="http://namespace.openaire.eu/oaf" xmlns:fn="http://www.w3.org/2005/xpath-functions"

	exclude-result-prefixes="xs" version="1.0">

	<xsl:param name="parentDatasourceId" />

	<xsl:param name="namespacePrefix" />

	<xsl:template match="/">

		<xsl:variable name="prefix" select="string('sfi_________')" />

		<record xmlns:dr="http://www.driver-repository.eu/namespace/dr"

			xmlns:dri="http://www.driver-repository.eu/namespace/dri" xmlns:dc="http://purl.org/dc/elements/1.1/"

			xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:oaf="http://namespace.openaire.eu/oaf"

			xmlns:oai_dc="http://www.openarchives.org/OAI/2.0/oai_dc/">

			<xsl:copy-of select=".//*[local-name()='header']" />

			<metadata>

				<ROWS>

					<xsl:if test="normalize-space(.//column[@name='Project Identifier']) and normalize-space(.//column[@name='Project Title'])">

						<xsl:variable name="projectId" select="concat($namespacePrefix, '::',  normalize-space(.//column[@name='Project Identifier']))" />

						<xsl:variable name="startDate" select=".//column[@name='Start date']" />

						<xsl:variable name="endDate" select=".//column[@name='End Date']" />

						<ROW table="projects">

							<FIELD name="_dnet_resource_identifier_"><xsl:value-of select="$projectId" /></FIELD>

							<FIELD name="id"><xsl:value-of select="$projectId" /></FIELD>

							<FIELD name="code"><xsl:value-of select=".//column[@name='Project Identifier']" /></FIELD>

							<FIELD name="title"><xsl:value-of select=".//column[@name='Project Title']" /></FIELD>

							<FIELD name="startdate" type="date" format="dd/MM/yyyy"><xsl:value-of select="$startDate" /></FIELD>

							<FIELD name="enddate" type="date" format="dd/MM/yyyy"><xsl:value-of select="$endDate" /></FIELD>

							<FIELD name="collectedfrom"><xsl:value-of select="$parentDatasourceId" /></FIELD>

							<FIELD name="provenanceactionclass">sysimport:crosswalk:entityregistry</FIELD>

						</ROW>

						<xsl:if test="normalize-space(.//column[@name='Programme'])">

							<xsl:variable name="funderId" select="concat($prefix, '::SFI')" />

							<xsl:variable name="fundingId" select="concat($funderId, '::', normalize-space(.//column[@name='Programme']))" />

							<ROW table="project_fundingpath">

								<FIELD name="_dnet_resource_identifier_"><xsl:value-of select="concat($fundingId, '@@', $projectId)" /></FIELD>

								<FIELD name="funding"><xsl:value-of select="$fundingId" /></FIELD>

								<FIELD name="project"><xsl:value-of select="$projectId" /></FIELD>

								<FIELD name="startdate" type="date" format="dd/MM/yyyy"><xsl:value-of select="$startDate" /></FIELD>

								<FIELD name="enddate" type="date" format="dd/MM/yyyy"><xsl:value-of select="$endDate" /></FIELD>

							</ROW>

						</xsl:if>

						<xsl:if test="normalize-space(.//column[@name='Research Body'])">

							<xsl:variable name="organizationId"	select="concat($namespacePrefix, '::', normalize-space(.//column[@name='Research Body']))" />

							<ROW table="organizations">

								<FIELD name="_dnet_resource_identifier_"><xsl:value-of select="$organizationId" /></FIELD>

								<FIELD name="id"><xsl:value-of select="$organizationId" /></FIELD>

								<FIELD name="legalname"><xsl:value-of select=".//column[@name='Research Body']" /></FIELD>

								<FIELD name="countryclass">IE</FIELD>

								<FIELD name="countryscheme">dnet:countries</FIELD>

								<FIELD name="collectedfrom"><xsl:value-of select="$parentDatasourceId" /></FIELD>

								<FIELD name="provenanceActionClass">sysimport:crosswalk:entityregistry</FIELD>

								<FIELD name="provenanceActionScheme">dnet:provenanceActions</FIELD>

							</ROW>

							<ROW table="project_organization">

								<FIELD name="_dnet_resource_identifier_"><xsl:value-of select='concat($projectId, "@@", $organizationId)' /></FIELD>

								<FIELD name="project"><xsl:value-of select="$projectId" /></FIELD>

								<FIELD name="resporganization"><xsl:value-of select="$organizationId" /></FIELD>

								<FIELD name="participantnumber" type="int">1</FIELD>

								<FIELD name="semanticclass">coordinator</FIELD>

								<FIELD name="semanticscheme">dnet:project_organization_relations</FIELD>

							</ROW>

						</xsl:if>

					</xsl:if>	

				</ROWS>

			</metadata>

		</record>

	</xsl:template>

</xsl:stylesheet>

<?xml version="1.0" encoding="UTF-8"?>

<xsl:stylesheet version="1.0"

	xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fn="http://www.w3.org/2005/xpath-functions"

	exclude-result-prefixes="fn">

	<xsl:variable name="namespacePrefix" select="string('fct_________')" />

	<xsl:variable name="funderID" select="concat($namespacePrefix, '::FCT')" />

	<xsl:template match="/">

		<xsl:variable name="p1"	select="normalize-space(.//funding/program)" />

		<xsl:variable name="p2" select="normalize-space(.//funding/program2)" />

		<fundingtree>

			<funder>

				<id><xsl:value-of select="$funderID" /></id>

				<shortname>FCT</shortname>

				<name>Fundação para a Ciência e a Tecnologia, I.P.</name>

				<jurisdiction>PT</jurisdiction>

			</funder>

			<xsl:if test="string-length($p1) &gt; 0">

				<xsl:choose>

					<xsl:when test="string-length($p2) &gt; 0">

						<xsl:variable name="level0" select="concat($funderID, '::', $p1)" />

						<xsl:variable name="level1" select="concat($funderID, '::', $p1, '::', $p2)" />

						<funding_level_1>

							<id><xsl:value-of select="$level1" /></id>

							<description><xsl:value-of select="$p2" /></description>

							<name><xsl:value-of select="$p2" /></name>

							<parent>

								<funding_level_0>

									<id><xsl:value-of select="$level0" /></id>

									<description><xsl:value-of select="$p1" /></description>

									<name><xsl:value-of select="$p1" /></name>

									<parent />

									<class>fct:program</class>

								</funding_level_0>

							</parent>

						</funding_level_1>

					</xsl:when>

					<xsl:otherwise>

						<xsl:variable name="level0" select="concat($funderID, '::', $p1)" />

						<funding_level_0>

							<id><xsl:value-of select="$level0" /></id>

							<description><xsl:value-of select="$p1" /></description>

							<name><xsl:value-of select="$p1" /></name>