Add a CSV export option in search results

Date	2010/03/01
Contact(s)	Francois
Last edited	Timestamp
Status	Draft
Assigned to release	2.5
Resources	GéoSource [BRGM], swisstopo
Ticket

Overview

CSV search results export.

Default formatting will be column header + all tags. Sort order is schema based due to formatting which could be different according to schema.

In order to override default formatting, create a template with mode="csv" in the metadata-schema.xsl matching the root element in order to create a one level tree structure :

Example to export only title from ISO19139 records.

				<xsl:template match="gmd:MD_Metadata" mode="csv">
					<xsl:param name="internalSep"/>
					
					<metadata>
						<xsl:copy-of select="geonet:info"/>
						
						<xsl:copy-of select="gmd:identificationInfo/gmd:MD_DataIdentification/gmd:citation/gmd:CI_Citation/gmd:title"/>
						...
					</metadata>
				</xsl:template>
					

The internal separator is used to join multiple objects in one columns (eg. keywords will be keyword1###keyword2... and could be explode if needed in a spreadsheet).

Proposal Type

• Type: Search
• App: GeoNetwork
• Module: GUI

Links

• Email discussions:
• IRC discussions:

Voting History

• Vote proposed the 02/03/2010 by Francois
• +1 from PSC member : Patrizia, Emmanuel, Jeroen, Francois

Motivations

• Useful to get main metadata informations in a spreadsheet for quick analysis & statistics

Risks

Participants

• Francois & Mathieu