[wdmmg-dev] Problems with CSV import

Fri Sep 2 16:34:25 UTC 2011

Please ignore this. I needed to stand up and take few steps to understand
the error.

Sorry,
Peio

On Fri, Sep 2, 2011 at 19:17, Peio Popov <peio at peio.org> wrote:

> Dear list,
> I have the following problem importing data in openspending:
>
> I am using the command line executing:
> (pyenv)okfn at us6:~/var/srvc/sandbox.openspending.org$ paster
> --plugin=openspending.etl csvimport -c cli.ini -v --model=
> http://peio.org/bgbudget/bg-budget-expenses-2000-2009-model.js
> http://peio.org/bgbudget/bg-budget-expenses-2000-2009-head.csv
>
> The first three lines of the csv are:
>
> function,group,activity,year,id,amount
> "Общи държавни служби","Изпълнителни и законодателни органи","Централни
> държавни органи",2000,1,89069052
> Общи държавни служби,Изпълнителни и законодателни органи, Политически
> кабинет ,2000, 2 ,1017053
>
> And OS produces an error:
> 2011-09-02 15:54:02,963 ERROR [openspending.etl.importer.base]  - Line 1:
> Column `activity': 'AttributeError("\'NoneType\' object has no attribute
> \'lower\'",)'
> 2011-09-02 15:54:02,963 ERROR [openspending.etl.importer.base]  - Line 2:
> Column `activity': 'AttributeError("\'NoneType\' object has no attribute
> \'lower\'",)'
>
> I drop the dataset:
> paster --plugin=openspending db -c cli.ini -v dropdataset
> bg-budget-expenses-2000-2009
>
> Change the column name from activity to just "act" and it still refers to
> the old column name:
> 2011-09-02 16:14:05,954 ERROR [openspending.etl.importer.base]  - Line 1:
> Column `activity': 'AttributeError("\'NoneType\' object has no attribute
> \'lower\'",)'
>
> Would you please take a look and let me know what's wrong!
>
> Thank you
>
> Peio Popov
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/openspending-dev/attachments/20110902/1d8eb7b7/attachment.html>