[Okfn-ca] Introduction to CSV on data.okfn.org (Rufus Pollock)

Mon Aug 26 01:11:04 UTC 2013

Hi Pascal,

Very useful feedback and we'll try to work it in - I've recorded it in the
relevant issue here so we'll track progress:
https://github.com/okfn/data.okfn.org/issues/65#issuecomment-23239470

BTW direct patches are warmly welcomed - you can directly edit (and then
submit a pull request) via:
https://github.com/okfn/data.okfn.org/blob/master/templates/standards/csv.md

Rufus

On 25 August 2013 15:15, donneesouvertes101 at gmail.com <
donneesouvertes101 at gmail.com> wrote:

>  Hello Rufus,
>
> Here's some comments:
>
> - For apps to open the CSV, I would mention NotePad and the likes.
> - Would give an exemple row woth an empty field     1,,3
> - Would mention that the 1st row is usually the field's name
> - No support for relationships between different "tables" : Not directly,
> but if files containt IDs, the files could be liked afterwards
> - Would mention that csv can be compressed a lot and we could be surprised
> by the files original size. Thus, opening a file could be long, if not
> possible in some cases.
> - In the spreadsheet section
>     - would give some more explanations on the configurations that can be
> changed: separator, charactor set
>     - would explain how to export in csv
>     - Excel 2003 is limited to 65000 sometings rows
> - What about databases? From MSAccess to MariaDB, Postgres and the likes
> - Would be nice to provide a small .csv file and the equivalent in other
> format, so people could compare, try to convert by themself and check if
> they have the good result.
>
> Pascal
>

-- 
*

Rufus Pollock

Founder and Executive Director | skype: rufuspollock |
@rufuspollock<https://twitter.com/rufuspollock>

The Open Knowledge Foundation <http://okfn.org/>

Empowering through Open Knowledge
http://okfn.org/ | @okfn <http://twitter.com/OKFN> | OKF on
Facebook<https://www.facebook.com/OKFNetwork>|
Blog <http://blog.okfn.org/>  |  Newsletter<http://okfn.org/about/newsletter>

*
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/okfn-ca/attachments/20130826/079ebccf/attachment-0001.html>