The issue is when you export the entire web2py database. It exports it into a "meta" csv file.
So its csv, but it has web2py generated metadata about what goes where, try opening your exported csv file in a text editor and you will see what I mean. This is why when you open in excel, it is unable to import back into web2py. You have two options, export each table separately/import separately, or chop up your db export into little files, edit them, then join it back together to re import. -Thadeus On Thu, Feb 4, 2010 at 12:30 PM, Miguel <[email protected]> wrote: > Hi > > I am running into weird issues with the csv import/export of the db. > > To start I use the following code to check the "dialect" of the csv > files: > import csv > > def DisplayDialect(file): > csvfile = open(file) > smple = csvfile.read() > dialect = csv.Sniffer().sniff(smple) > > print " Delimiter :" + str(dialect.delimiter) > print " Doublequote : "+ str(dialect.doublequote) > print " Escapechar :" + str(dialect.escapechar) > print " LineTerminator :" + str(dialect.lineterminator) > print " Quotechar :" + str(dialect.quotechar) > print " quoting :" + str(dialect.quoting) > print " skipinitialspace :" + str(dialect.skipinitialspace) > > > Here is what happens: > > CASE A: > - Export the entire db to csv > - The csv.sniffer generates an exception "Could not determine > delimiter" > - However I can import the file back in web2py > > CASE B: > - Export the entire db to csv > - Open the excel > - The csv.sniffer can recognize the format > - However I CANNOT import the file back in web2py > > > Any suggestions here? This makes it impossible for me to add testing > data in excel and import it back into web2py. > > Thanks > Miguel > If I export my entire DB and then I try to check the format with > csv.sniffer using the following cod > > -- > You received this message because you are subscribed to the Google Groups > "web2py-users" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/web2py?hl=en. > > -- You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.
