[openspending-dev] [OpenSpending] Importing Data unclear format.
friedrich.lindenberg at okfn.org
Wed Sep 5 18:43:47 UTC 2012
Hey, I haven't seen that bug yet either, but the more I think of it
the more it seems possible we haven't had decimals in data yet :(
I can't see anything in the code that would cause this, though, are
you sure this is set up as a numeric column?
On Wed, Sep 5, 2012 at 5:49 PM, Lucy Chambers <lucy.chambers at okfn.org> wrote:
> 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
> Lucy Chambers
> Community Coordinator,
> OpenSpending & Data Journalism
> Open Knowledge Foundation
> Skype: lucyfediachambers
> Twitter: @lucyfedia
> openspending-dev mailing list
> openspending-dev at lists.okfn.org
More information about the openspending-dev