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

Wed Oct 16 12:25:05 UTC 2013

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>
> 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)" <john.glover at okfn.org>, "
> Bert.Van.Nuffelen at tenforce.com" <Bert.Van.Nuffelen at tenforce.com>
> Cc: "HOHN Norbert (OP)" <Norbert.HOHN at publications.europa.eu>, "FRATTO
> Valentina (OP)" <Valentina.FRATTO at publications.europa.eu>, "SABETE Vafa
> (OP)" <Vafa.SABETE at publications.europa.eu>, "KONYA Jaroslav (OP-EXT)" <
> 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****
>
> ** **
>
> ** **
>
> ** **
>
> -----Original Message-----
> From: ODP HELPDESK On Behalf Of 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) 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/a2b1b53b/attachment.html>