Project

General

Profile

« Previous | Next » 

Revision 48946

changed to match the change in the db

View differences:

nsf_2_db.xsl
17 17
						<xsl:variable name="startDate" select=".//AwardEffectiveDate"/>
18 18
						<xsl:variable name="endDate" select=".//AwardExpirationDate"/>
19 19

  
20

  
21

  
22

  
20 23
						<ROW table="projects">
21 24
							<FIELD name="_dnet_resource_identifier_">
22 25
								<xsl:value-of select="$projectId"/>
......
36 39
							<FIELD name="title">
37 40
								<xsl:value-of select=".//AwardTitle"/>
38 41
							</FIELD>
42
							<xsl:for-each select=".//Investigator[./RoleCode='Principal Investigator'] | .//Investigator[./RoleCode='Co-Principal Investigator'] | .//Investigator[./RoleCode='Former Principal Investigator'] | .//Investigator[./RoleCode='Former Co-Principal Investigator']">
43
								<xsl:if test="position() = 1">
44
									<xsl:variable name="personName" select="normalize-space(./FirstName)"/>
45
									<xsl:variable name="personSurname" select="normalize-space(./LastName)"></xsl:variable>
46
									<xsl:variable name="email" select="./EmailAddress"/>
47
									<xsl:choose>
48
										<xsl:when test="$personName != '' and  $personName != 'NO DATA AVAILABLE'">
49
											<xsl:choose>
50
												<xsl:when test="$personSurname != '' and $personSurname != 'NO DATA AVAILABLE'">
51
													<FIELD name="contactfullname">
52
														<xsl:value-of select="concat($personSurname,', ' ,$personName)"/>
53
													</FIELD>
54
												</xsl:when>
55
												<xsl:otherwise>
56
													<FIELD name="contactfullname">
57
														<xsl:value-of select="$personName"/>
58
													</FIELD>
59
												</xsl:otherwise>
60
											</xsl:choose>
61
										</xsl:when>
62
										<xsl:otherwise>
63
											<xsl:if test="$personSurname != '' and $personSurname != 'NO DATA AVAILABLE'">
64
												<FIELD>
65
													<FIELD name="contactfullname">
66
														<xsl:value-of select="$personSurname"/>
67
													</FIELD>
68
												</FIELD>
69
											</xsl:if>
70
										</xsl:otherwise>
71
									</xsl:choose>
72

  
73
								</xsl:if>
74
							</xsl:for-each>
75

  
76

  
39 77
							<FIELD name="contracttypeclass">
40 78
								<xsl:value-of select=".//AwardInstrument/Value"/>
41 79
							</FIELD>
......
77 115
							</FIELD>
78 116
						</ROW>
79 117

  
80
						<xsl:for-each select=".//Investigator[./RoleCode='Principal Investigator'] | .//Investigator[./RoleCode='Co-Principal Investigator'] | .//Investigator[./RoleCode='Former Principal Investigator'] | .//Investigator[./RoleCode='Former Co-Principal Investigator']">
118
					<!--	<xsl:for-each select=".//Investigator[./RoleCode='Principal Investigator'] | .//Investigator[./RoleCode='Co-Principal Investigator'] | .//Investigator[./RoleCode='Former Principal Investigator'] | .//Investigator[./RoleCode='Former Co-Principal Investigator']">
81 119
							<xsl:if test="position() = 1">
82 120
								<xsl:variable name="personName" select="normalize-space(./FirstName)"/>
83 121
								<xsl:variable name="personSurname" select="normalize-space(./LastName)"></xsl:variable>
......
110 148
									</ROW>
111 149
								</xsl:if>
112 150
							</xsl:if>
113
						</xsl:for-each>
151
						</xsl:for-each> -->
114 152

  
115 153
						<ROW table="project_organization">
116 154
							<FIELD name="_dnet_resource_identifier_">
......
129 167
							<FIELD name="resporganization">
130 168
								<xsl:value-of select="$orgId"/>
131 169
							</FIELD>
132
							<xsl:for-each select=".//Investigator[./RoleCode='Principal Investigator'] | .//Investigator[./RoleCode='Co-Principal Investigator'] | .//Investigator[./RoleCode='Former Principal Investigator'] | .//Investigator[./RoleCode='Former Co-Principal Investigator']">
170
						<!--	<xsl:for-each select=".//Investigator[./RoleCode='Principal Investigator'] | .//Investigator[./RoleCode='Co-Principal Investigator'] | .//Investigator[./RoleCode='Former Principal Investigator'] | .//Investigator[./RoleCode='Former Co-Principal Investigator']">
133 171
								<xsl:if test="position() = 1">
134 172
									<xsl:variable name="personName" select="normalize-space(./FirstName)"/>
135 173
									<xsl:variable name="personSurname" select="normalize-space(./LastName)"></xsl:variable>
......
139 177
										</FIELD>
140 178
									</xsl:if>
141 179
								</xsl:if>
142
							</xsl:for-each>
180
							</xsl:for-each>-->
143 181

  
144 182
							<FIELD name="semanticclass">coordinator</FIELD>
145 183
							<FIELD name="semanticscheme">dnet:project_organization_relations</FIELD>

Also available in: Unified diff