[openspending-dev] [OpenSpending] Importing Data unclear format.

Lucy Chambers lucy.chambers at okfn.org
Wed Sep 5 09:12:14 UTC 2012

Hi Marco,

I'm moving this onto the OpenSpending dev list [1]  as that is where
we are now discussing OpenSpending specific issues, while the
discussion list is mainly being used for topics around spending in

I haven't come across this problem before. Although you look like you
have semi-colon separated rather than CSV data and I'm not sure if
that makes a difference.

Can you send us a link to the dataset you are working with and I will
try and help you from there?


[1] http://lists.okfn.org/mailman/listinfo/openspending-dev

On Wed, Sep 5, 2012 at 12:39 AM, Marco Horstmann
<marco.horstmann.de at googlemail.com> wrote:
> Hi everybody,
> I've just startet to import the financial data from the city Hanover in Germany.
> This is my very first project with openspending.
> But when I import the data the system doesn't understand the data:
> ID;ID-Text;Sub-ID;Sub-Name;Amount;Year
> 5;öffentlich-rechtliche Entgelte;33110000;Verwaltungsgebühren;22064706.37;2011
> The amount of "22064706.37" will be misinterpreted to "2206470637". This is
> stupid, because I've learnd regex to change comma to dot. -.-
> It does not work with comma and it does not work with dot.
> BTW. The help pages are not very helpful.
> Has anybody an idea, what happens here?
> Regards
> Marco
> _______________________________________________
> openspending mailing list
> openspending at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/openspending

Lucy Chambers
Community Coordinator,
OpenSpending & Data Journalism
Open Knowledge Foundation
Skype: lucyfediachambers
Twitter: @lucyfedia

More information about the openspending-dev mailing list