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

[John Glover]

Hi Agnieszka,

I can confirm that the command to dump the datasets to a CSV file should
work fine on release 09.

For reference:

/applications/ecodp/users/ecodp/ckan/ecportal/bin/paster --plugin=ckan db
simple-dump-csv <path to output CSV file> -c
/applications/ecodp/users/ecodp/ckan/conf/ecportal.ini

Regards,
John


> ---------- Forwarded message ----------
> From: ZAJAC Agnieszka (OP) <Agnieszka.ZAJAC at publications.europa.eu>
>  Date: 22 October 2013 14:36
> Subject: FW: The export of the full content of CKAN database in a
> spreadsheet
> To: "Bert.Van.Nuffelen at tenforce.com" <Bert.Van.Nuffelen at tenforce.com>, "
> darwin.peltan at okfn.org" <darwin.peltan at okfn.org>
> Cc: "KONYA Jaroslav (OP-EXT)" <Jaroslav.KONYA at ext.publications.europa.eu>,
> "SABETE Vafa (OP)" <Vafa.SABETE at publications.europa.eu>, "HOHN Norbert
> (OP)" <Norbert.HOHN at publications.europa.eu>, "PASTOR CAMARASA José Juan
> (OP)" <Jose.PASTOR-CAMARASA at publications.europa.eu>, "MEYER André
> (OP-EXT)" <Andre.MEYER at ext.publications.europa.eu>
>
>
>  Dear Bert and Darwin,****
>
> ** **
>
> Thank you for the general information about CKAN CSV dump of the database.
> Could you provide André with an answer to his question?****
>
> ** **
>
> Thank you in advance.****
>
> ** **
>
> Best regards,****
>
> ** **
>
> *Agnieszka Zając*
>
> Open Data Portal Section****
>
> Tel: +352 2929.42834****
>
> ** **
>
> *From:* MEYER André (OP-EXT)
> *Sent:* Thursday, October 17, 2013 1:31 PM
> *To:* ZAJAC Agnieszka (OP)
> *Cc:* HOHN Norbert (OP); SABETE Vafa (OP); KONYA Jaroslav (OP-EXT);
> PASTOR CAMARASA José Juan (OP); ZADRA Julien (OP-EXT)
> *Subject:* RE: The export of the full content of CKAN database in a
> spreadsheet****
>
> ** **
>
> Hello,****
>
> ** **
>
> As this comes from OKF directly I do not know if this is working with any
> possible changes done by TenForce. I’d prefer to have TenForce to give us
> precise instructions on what to do for the OPD environment as only they
> have the complete overview of what has been changed.****
>
> ** **
>
> Kind regards,****
>
> ** **
>
> *André Meyer*
>
> Application Team - Integration engineer****
>
> *_**__**_**__**_**__**__**_**__**_**__***
>
> * *
>
> *Publications Office of the European Union *
>
> *Unit A4 - Infrastructure and IT Security Systems***
>
> * *
>
> *Halian S.à.r.l.  (under contract with the Publications Office)*****
>
> ( (+352) 2929-42442****
>
> +  andre.meyer at ext.publications.europa.eu****
>
> ** **
>
> *From:* ZAJAC Agnieszka (OP)
> *Sent:* 17 October, 2013 12:18 PM
> *To:* MEYER André (OP-EXT)
> *Cc:* HOHN Norbert (OP); SABETE Vafa (OP); KONYA Jaroslav (OP-EXT);
> PASTOR CAMARASA José Juan (OP)
> *Subject:* FW: The export of the full content of CKAN database in a
> spreadsheet****
>
> ** **
>
> Dear Andre,****
>
> ** **
>
> Could you please provide us with a dump of ckan database as described by
> Darwin below?****
>
> ** **
>
> Thanks in advance.****
>
> ** **
>
> Best regards,****
>
> ** **
>
> *Agnieszka Zając*
>
> Open Data Portal Section****
>
> Tel: +352 2929.42834****
>
> ** **
>
> *From:* Darwin Peltan [mailto:darwin.peltan at okfn.org<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>
> 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/20131023/1b1a014b/attachment.html>