[openspending-dev] [OpenSpending] incorrect csv format?

Tue Sep 25 20:42:57 UTC 2012

>> Moving to openspending-dev for technobabble :)

Hi Christian!

two comments: I think you have a lot of columns with umlauts, one of
them even seems to have a line break. OS currently has some issues
with this, perhaps you could normalize things down to ae/ue/oe with
underscores? Also, while you can load the data like this, you may want
to transpose it first: Make "Bereich" the first level of your dataset
and then establish a new column, say "Economic Type", with the current
column names as values and the actual number in a third column. This
will also allow you to aggregate the numbers to get overall revenue
for a Bereich. Also, as a matter of convention, OS requires each
dataset to have a temporal column. If you don't have one, just add a
fake one with "2012" in all rows.

Hope this helps,

 - Friedrich

On Tue, Sep 25, 2012 at 10:37 PM, Christian Sawatzki
<sawatzki at osnanet.de> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
>
> Hello ML,
>
> we are trying to set up a test server for presenting OpenSpending to
> our local community. But we are feacing some problems. Maybe anyone
> can help us?
>
> We can import the csv-file. Bute after that we can't build a
> datamodel. OS is not recognizing any columns. Is the format of the
> data right?
>
> https://dl.dropbox.com/u/26652418/PP/Ertraege_gesamt.csv
>
> We thank you for some hints.
>
> Regards
> Christian
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.11 (GNU/Linux)
> Comment: Using GnuPG with Mozilla - http://www.enigmail.net/
>
> iQIcBAEBAgAGBQJQYhXuAAoJEJr6Xy2/miZeAZEQAJ4sol4A/hNkMlm1cLeUhues
> 6fMI+3q/56ZXhOlNVGM3d1xw+TBJj86nuHticI7ZFTXSvcgl6p2dBU2Dl6KV9ozf
> JQ8BM8zgeOgM4JYQgO4LHXUHkH82jN8PLGVNSttCwcpLZlN0IrsittkFX5IPRpuI
> AsvBQ0G98+Dj4GzoMreq7eSgkn/i/nuFulosbEaYqevpy9Rj7AyTjja4UE+4pAku
> KSVRLy3O1Dn7aRdVdAnnL6gJF7QrUgqLdQ0loXD6msE6I8u0sKUhyFnJKrnz1tnP
> 9kfJDCl0wnmNyJNy19ZM/xynykaqTuDizT7KX3h9iWFqtmpji6eUzBM6WktVg8ui
> /YcPRyQgEUxe06In3/qPzJc5HPu1stFAr8lUBZ23gzmiQuNRjWdmCEPkJRml9J4N
> nSxZXkexXESCUQmUpcr6/H+Adza6mjjNa9B3S8yDJWPsz2iGX5FumhuoSIsL1dKO
> cjqnxzb3JRw3uPTSetkDayXdL2mrtAo5jaUiE8I25V/o73KMVXqFsSGpunq8uPgE
> u/dFeSjsAk3ihS53cSA6OrM/HJfVNA9vZy8PFbPel7VgbBKH7JsallWpcMbczenY
> eIfO5rGHC3lbCNCbhtuJ0Jh4Rw3qz3ZNJZUpplJPUrkp3mUGB7Jo70wZUlFsRTCR
> qBj4cfN86LnLf6p6CIc5
> =o/0C
> -----END PGP SIGNATURE-----
>
> _______________________________________________
> openspending mailing list
> openspending at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/openspending