This will not be a problem since this parameter only affects export not import. Because of the way it works, you will be able to import despite the type of quoting except you will not be able to import those csv that you were already unable to import before.
On Jan 27, 8:06 pm, Thadeus Burgess <[email protected]> wrote: > 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 > > 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.
