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!

-- 



Reply via email to