Revision 38156
Added by Michele Artini about 9 years ago
| modules/cnr-openaire-exporter/trunk/src/main/resources/eu/dnetlib/openaire/exporter/sql/projects_tsv.sql.st | ||
|---|---|---|
| 6 | 6 |
pr.enddate AS "Start Date", |
| 7 | 7 |
pr.startdate AS "End Date", |
| 8 | 8 |
pr.ec_sc39 AS "ec_sc39", |
| 9 |
pr.oa_mandate_for_publications AS "oa_mandate_for_publications", |
|
| 10 |
pr.ec_article29_3 AS "ec_article29_3", |
|
| 9 | 11 |
f.description AS "Discipline", |
| 10 | 12 |
org.legalname AS "Organization", |
| 11 | 13 |
org.countryclass AS "Country", |
| modules/cnr-openaire-exporter/trunk/src/main/resources/eu/dnetlib/openaire/exporter/applicationContext-openaire-exporter.properties | ||
|---|---|---|
| 1 | 1 |
openaire.exporter.dspace.xslt=classpath:/eu/dnetlib/openaire/exporter/xslt/projects_dspace.xslt |
| 2 | 2 |
openaire.exporter.eprints.xslt=classpath:/eu/dnetlib/openaire/exporter/xslt/projects_eprints.xslt |
| 3 | 3 |
openaire.exporter.projects2tsv.sql.template=classpath:/eu/dnetlib/openaire/exporter/sql/projects_tsv.sql.st |
| 4 |
openaire.exporter.projects2tsv.fields = Grant Agreement Number, Project Acronym, Project Title, Call ID, Start Date, End Date, ec_sc39, Discipline, Organization, Country, Role, Person Name, Person Second Names, Person Email |
|
| 4 |
openaire.exporter.projects2tsv.fields = Grant Agreement Number, Project Acronym, Project Title, Call ID, Start Date, End Date, ec_sc39, oa_mandate_for_publications, ec_article29_3, Discipline, Organization, Country, Role, Person Name, Person Second Names, Person Email
|
|
| 5 | 5 |
openaire.exporter.projectsfundings.sql.template=classpath:/eu/dnetlib/openaire/exporter/sql/projects_fundings.sql.st |
Also available in: Unified diff
update sql query for projects