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

Friedrich Lindenberg 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?

Cheers,

 - Friedrich

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 [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
>> general.
>>
>> 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?
>>
>> Lucy
>>
>> [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
>
>
>
> --
> Lucy Chambers
> Community Coordinator,
> OpenSpending & Data Journalism
> Open Knowledge Foundation
> Skype: lucyfediachambers
> Twitter: @lucyfedia
>
> _______________________________________________
> openspending-dev mailing list
> openspending-dev at lists.okfn.org
> http://lists.okfn.org/mailman/listinfo/openspending-dev




More information about the openspending-dev mailing list