wiki:CSVExport

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

  • 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
Last modified 15 years ago Last modified on 03/08/10 02:33:17

Attachments (3)

Download all attachments as: .zip

Note: See TracWiki for help on using the wiki.