[ECODP-dev] The export of the full content of CKAN database in a spreadsheet

Wed Oct 16 15:02:05 UTC 2013

Dear Darwin,

Thank you very much. That's very useful. I'll ask our administrator for it.

Will it include also the metadata like title, description etc or just a list of catalogue records?

Regards,

Agnieszka Zając
Open Data Portal Section
Tel: +352 2929.42834

From: Darwin Peltan [mailto:darwin.peltan at okfn.org]
Sent: Wednesday, October 16, 2013 2:25 PM
To: ZAJAC Agnieszka (OP); Project list for EC ODP CKAN project; HOHN Norbert (OP); SABETE Vafa (OP); KONYA Jaroslav (OP-EXT)
Subject: Re: The export of the full content of CKAN database in a spreadsheet

Hi Agnieszka,

Within CKAN there is a command to create a CSV dump of the datasets.
http://docs.ckan.org/en/ckan-1.8.2/database-dumps.html

Note that this command will include private and deleted datasets etc so you'll need to manually review the CSV to remove any datasets that you don't want to include. You may also want to remove some of the columns which won't be relevant for the user who requested the list of datasets.

Best,

Darwin

---------- Forwarded message ----------
From: ZAJAC Agnieszka (OP) <Agnieszka.ZAJAC at publications.europa.eu<mailto:Agnieszka.ZAJAC at publications.europa.eu>>
Date: 16 October 2013 09:30
Subject: The export of the full content of CKAN database in a spreadsheet
To: "'John Glover' (john.glover at okfn.org<mailto:john.glover at okfn.org>)" <john.glover at okfn.org<mailto:john.glover at okfn.org>>, "Bert.Van.Nuffelen at tenforce.com<mailto:Bert.Van.Nuffelen at tenforce.com>" <Bert.Van.Nuffelen at tenforce.com<mailto:Bert.Van.Nuffelen at tenforce.com>>
Cc: "HOHN Norbert (OP)" <Norbert.HOHN at publications.europa.eu<mailto:Norbert.HOHN at publications.europa.eu>>, "FRATTO Valentina (OP)" <Valentina.FRATTO at publications.europa.eu<mailto:Valentina.FRATTO at publications.europa.eu>>, "SABETE Vafa (OP)" <Vafa.SABETE at publications.europa.eu<mailto:Vafa.SABETE at publications.europa.eu>>, "KONYA Jaroslav (OP-EXT)" <Jaroslav.KONYA at ext.publications.europa.eu<mailto:Jaroslav.KONYA at ext.publications.europa.eu>>

Dear Bert and John,

We've got a request from a user to provide the content of ODP catalogue in a spreadsheet. As most of the data is still missing in Virtuoso could you inform us if such an export could be done directly from CKAN? If so, how?

Thanks in advance for an advice.

Best regards,

Agnieszka Zając
Open Data Portal Section
Tel: +352 2929.42834<tel:%2B352%202929.42834>

-----Original Message-----
From: ODP HELPDESK On Behalf Of bniemann at cox.net<mailto:bniemann at cox.net>
Sent: mardi 15 octobre 2013 17:56
To: ODP HELPDESK
Subject: [Contact Us] Request: Please send the catalogue of the 6135 data sets in a spreadsheet

Brand Niemann (bniemann at cox.net<mailto:bniemann at cox.net>) sent a message using the contact form at http://open-data.europa.eu/en/contact.

I am not sure my request was received so I am sending it again.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.okfn.org/mailman/private/ecodp-dev/attachments/20131016/3fe69bb4/attachment.html>