D-Net

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

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

	<xsl:param name="parentDatasourceId"/>

	<xsl:param name="namespacePrefix" select="string('snsf_________')"/>

	<xsl:param name="quote">"</xsl:param>

	<xsl:template match="/">

		<record>

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

			<metadata>

				<ROWS>

					<xsl:if test="string-length(normalize-space(.//column[@name='Project Title'])) &gt; 0 and string-length(normalize-space(.//column[@name='Project Number'])) &gt; 0">

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

						<xsl:variable name="orgId" select="concat($namespacePrefix, '::', translate(normalize-space(.//column[@name='Institution']), ' ,.', '___'))"/>

						<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="normalize-space(.//column[@name='Project Number String'])"/>

							</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="title">

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

							</FIELD>

							<FIELD name="acronym"></FIELD>

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

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

							<FIELD name="collectedfrom">

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

							</FIELD>

							<!-- <FIELD name="???"><xsl:value-of select=".//AbstractNarration" /></FIELD> -->

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

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

								<FIELD name="contactfullname">

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

								</FIELD>

							</xsl:if>

						</ROW>

						<ROW table="organizations">

							<FIELD name="_dnet_resource_identifier_">

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

							</FIELD>

							<FIELD name="id">

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

							</FIELD>

							<FIELD name="legalname">

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

							</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="optional1">

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

							</FIELD>

						</ROW>

						<ROW table="project_organization">

							<FIELD name="_dnet_resource_identifier_">

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

							</FIELD>

							<FIELD name="participantnumber" type="int">1</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="project">

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

							</FIELD>

							<FIELD name="resporganization">

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

							</FIELD>

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

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

						</ROW>

						<xsl:variable name="p0" select="normalize-space(.//column[@name='Funding Instrument Hierarchy'])"/>

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

						<xsl:variable name="fundingId">

							<xsl:choose>

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

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

								</xsl:when>

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

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

								</xsl:when>

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

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

								</xsl:when>

							</xsl:choose>

						</xsl:variable>

						<ROW table="project_fundingpath">

							<FIELD name="_dnet_resource_identifier_">

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

							</FIELD>

							<FIELD name="funding">

								<xsl:value-of select="normalize-space($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>

				</ROWS>

			</metadata>

		</record>

	</xsl:template>

</xsl:stylesheet>