[web2py] Re: Unable to import CSV file in appadmin

2012-05-04 Thread Massimo Di Pierro
It is supposed to have columns with headers, the headers must be the names of the fields of the table to import. You cannot have have columns with headers which are not names of fields. On Friday, 4 May 2012 07:07:12 UTC-5, pbreit wrote: > > I can't seem to get a CSV file imported in appadmin.

[web2py] Re: Unable to import CSV file in appadmin

2012-05-04 Thread pbreit
Actually still not able to import. I'm guessing the appadmin import/export is not the right tool for importing random data, just database dumps.

[web2py] Re: Unable to import CSV file in appadmin

2012-05-04 Thread pbreit
I think I figured it out. The importer is *extremely* sensitive. I have auth.signature on the table and assumed the default/update actions would apply but found out I need to populate those fields. Excel had switched True to TRUE which did not work. Also watch our for Excel reformatting the dat