I am also unable to import a CSV file using the list:reference format (exporting then importing with no changes still doesn't work). I get the error message :
Unable to parse CSV file 'nonetype'object has no attribute '__getitem__' On Tuesday, July 17, 2012 2:44:58 PM UTC-7, Mark Li wrote: > > I would like to know how I would add an import csv (from excel) option to > appadmin that would update multiple database tables (one of them a > relational/intermediate table). > > For example, the CSV file would look like this (in excel) > > ID | posttitle | category | > 1 | title1 | cat1, cat2 | > 2 | title2 | cat2, cat3 | > 3 | title3 | cat1, cat3 | > > Uploading this would update table 1 with the ID and posttitle, and also > the intermediate/relational table with the relationship between posttitle > and category (as described here: > http://web2py.com/books/default/chapter/29/6#Many-to-many). > > I'm new to web2py and couldn't find anything in the book, also the > questions previously asked already had a good grasp of what to do add a CSV > upload feature. I'd appreciate any help as I'm not really sure where to > start with this, thanks! > --