[openspending-dev] [OpenSpending] Importing Data unclear format.
lucy.chambers at okfn.org
Wed Sep 5 09:12:14 UTC 2012
I'm moving this onto the OpenSpending dev list  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?
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:
> 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?
> openspending mailing list
> openspending at lists.okfn.org
OpenSpending & Data Journalism
Open Knowledge Foundation
More information about the openspending-dev