[wdmmg-dev] Problems with CSV import

Fri Sep 2 16:17:08 UTC 2011

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/ee5fece8/attachment.html>