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

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 [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