what if I have old csv backups laying around :) Ok +1 for QOUTES_NONNUMERIC as default.
-Thadeus On Wed, Jan 27, 2010 at 7:45 PM, mdipierro <[email protected]> wrote: > I do not think this change will cause any backward compatibility > problems. > > On Jan 27, 3:58 pm, Thadeus Burgess <[email protected]> wrote: >> Doesn't that break backwards compatibility ? >> >> -Thadeus >> >> On Wed, Jan 27, 2010 at 1:38 PM, mdipierro <[email protected]> wrote: >> > I just made this default in trunk. >> >> > On Jan 27, 10:42 am, Thadeus Burgess <[email protected]> wrote: >> >> You need to define the appropriate csv.QOUTES type. You probably have >> >> csv.QOUTES_MINIMAL (which is the web2py default) >> >> >> Try the following >> >> >> import csv >> >> db(query).select().export_to_csv_file(s, delimiter=',', quotechar='"', >> >> quoting=csv.QUOTE_NONNUMERIC) >> >> db.import_from_csv_file(s, delimiter=',', quotechar='"', >> >> qouting=csv.QOUTE_NONNUMERIC) >> >> >> -Thadeus >> >> >> On Wed, Jan 27, 2010 at 10:11 AM, mdipierro <[email protected]> >> >> wrote: >> >> > this sounds like a bug but more of a bug in the csv module than in >> >> > web2py. >> >> > Anyway, it needs some testing. I will put this in my queue but it >> >> > would help if somebody else can also look into this. The only export/ >> >> > import functions are in gluon/sql.py (for Table and for SQLDB). >> >> >> > On Jan 27, 8:55 am, Praneeth <[email protected]> wrote: >> >> > > Hello folks, >> >> >> > > I was wondering if anyone faced this problem before. I was migrating a >> >> > > database from sqlite to MySQL and had to do a db.export_to_csv_file. >> >> > > My >> >> > > database contains strings with a carriage return. Seems like the >> >> > > export >> >> > > creates carriage returns in the CSV file resulting in a failure when >> >> > > doing a db.import_from_csv_file. I manually removed the carriage >> >> > > returns >> >> > > from my file for a successful import. >> >> >> > > -- >> >> > > Praneeth >> >> >> > -- >> >> > 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]<web2py%[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 >> > athttp://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. > > -- 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.
