[openspending-dev] [OpenSpending] Importing Data unclear format.
lucy.chambers at okfn.org
Wed Sep 5 15:49:43 UTC 2012
Cc'ing Marco this time....
On Wed, Sep 5, 2012 at 11:12 AM, Lucy Chambers <lucy.chambers at okfn.org> wrote:
> Hi Marco,
> 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?
>  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:
>> 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
> Lucy Chambers
> Community Coordinator,
> OpenSpending & Data Journalism
> Open Knowledge Foundation
> Skype: lucyfediachambers
> Twitter: @lucyfedia
OpenSpending & Data Journalism
Open Knowledge Foundation
More information about the openspending-dev