Revision 48945
Added by Miriam Baglioni over 6 years ago
| modules/dnet-openaireplus-workflows/trunk/src/main/resources/eu/dnetlib/msro/openaireplus/workflows/repo-hi/xslt/conicyt2db.xsl | ||
|---|---|---|
| 49 | 49 |
<FIELD name="websiteurl"> |
| 50 | 50 |
<xsl:value-of select=".//column[@name='URL DE INFORME FINAL']"/> |
| 51 | 51 |
</FIELD> |
| 52 |
|
|
| 53 |
<FIELD name="contactfullname"> |
|
| 54 |
<xsl:choose> |
|
| 55 |
<xsl:when test=".//column[@name='DIRECTOR Nombre'] = ''"> |
|
| 56 |
|
|
| 57 |
<xsl:value-of select="concat(.//column[@name='DIRECTOR Apellido1'],' ' ,.//column[@name='DIRECTOR Apellido2'])"/> |
|
| 58 |
</xsl:when> |
|
| 59 |
<xsl:otherwise> |
|
| 60 |
<xsl:choose> |
|
| 61 |
<xsl:when test=".//column[@name='DIRECTOR Apellido1']=''"> |
|
| 62 |
<xsl:value-of select=".//column[@name='DIRECTOR Nombre']"/> |
|
| 63 |
</xsl:when> |
|
| 64 |
<xsl:otherwise> |
|
| 65 |
<xsl:value-of select="concat(normalize-space(concat(.//column[@name='DIRECTOR Apellido1'],' ' ,.//column[@name='DIRECTOR Apellido2'])),', ',.//column[@name='DIRECTOR Nombre'])"/> |
|
| 66 |
</xsl:otherwise> |
|
| 67 |
</xsl:choose> |
|
| 68 |
|
|
| 69 |
</xsl:otherwise> |
|
| 70 |
</xsl:choose> |
|
| 71 |
|
|
| 72 |
</FIELD> |
|
| 73 |
|
|
| 52 | 74 |
<FIELD name="collectedfrom"> |
| 53 | 75 |
<xsl:value-of select="$parentDatasourceId"/> |
| 54 | 76 |
</FIELD> |
| ... | ... | |
| 59 | 81 |
<FIELD name="oa_mandate_for_publications" type="boolean">false</FIELD> |
| 60 | 82 |
</ROW> |
| 61 | 83 |
|
| 62 |
<xsl:variable name="personId"> |
|
| 63 |
<xsl:variable name="tmp"> |
|
| 64 |
<xsl:value-of select="concat(.//column[@name='DIRECTOR Apellido1'],.//column[@name='DIRECTOR Apellido2'],.//column[@name='DIRECTOR Nombre'])"/> |
|
| 65 |
</xsl:variable> |
|
| 66 |
<xsl:value-of select="concat($namespacePrefix,'::',utils:md5($tmp))"/> |
|
| 67 |
</xsl:variable> |
|
| 68 |
<xsl:if test="not($personId = '')"> |
|
| 69 |
<ROW table="persons"> |
|
| 70 |
<FIELD name="_dnet_resource_identifier_"> |
|
| 71 |
<xsl:value-of select="$personId"/> |
|
| 72 |
</FIELD> |
|
| 73 |
<FIELD name="id"> |
|
| 74 |
<xsl:value-of select="$personId"/> |
|
| 75 |
</FIELD> |
|
| 76 |
<xsl:if test="not(.//column[@name='DIRECTOR Nombre'] = '')"> |
|
| 77 |
<FIELD name="firstname"> |
|
| 78 |
<xsl:value-of select=".//column[@name='DIRECTOR Nombre']"/> |
|
| 79 |
</FIELD> |
|
| 80 |
</xsl:if> |
|
| 81 | 84 |
|
| 82 |
<FIELD name="secondnames"> |
|
| 83 |
<xsl:value-of select="concat(.//column[@name='DIRECTOR Apellido1'],' ' ,.//column[@name='DIRECTOR Apellido2'])"/> |
|
| 84 |
</FIELD> |
|
| 85 | 85 |
|
| 86 |
<FIELD name="collectedfrom"> |
|
| 87 |
<xsl:value-of select="$parentDatasourceId"/> |
|
| 88 |
</FIELD> |
|
| 89 |
<FIELD name="provenanceActionClass">sysimport:crosswalk:entityregistry</FIELD> |
|
| 90 |
<FIELD name="provenanceActionScheme">dnet:provenanceActions</FIELD> |
|
| 91 |
</ROW> |
|
| 92 |
</xsl:if> |
|
| 93 |
|
|
| 94 | 86 |
<xsl:for-each select="tokenize(.//column[@name='PARTICIPANT INSTITUTIONS2'],';')"> |
| 95 | 87 |
<xsl:variable name="organizationId" select="concat($namespacePrefix,'::',utils:md5(normalize-space(.)))"/> |
| 96 | 88 |
<ROW table = "organizations"> |
| ... | ... | |
| 120 | 112 |
<xsl:value-of select="$organizationId"/> |
| 121 | 113 |
</FIELD> |
| 122 | 114 |
|
| 123 |
<xsl:choose> |
|
| 124 | 115 |
|
| 125 |
<xsl:when test="not($personId = '') and position() = 1"> |
|
| 126 |
<FIELD name="contactperson"> |
|
| 127 |
<xsl:value-of select="$personId"/> |
|
| 128 |
</FIELD> |
|
| 129 |
</xsl:when> |
|
| 130 |
<xsl:otherwise> |
|
| 131 |
<FIELD name="contactperson"/> |
|
| 132 |
</xsl:otherwise> |
|
| 133 |
</xsl:choose> |
|
| 134 | 116 |
|
| 135 |
|
|
| 136 | 117 |
<FIELD name="semanticclass">participant</FIELD> |
| 137 | 118 |
<FIELD name="semanticscheme">dnet:project_organization_relations</FIELD> |
| 138 | 119 |
</ROW> |
Also available in: Unified diff
change for upgrade in the db