I do not think this change will cause any backward compatibility problems. On Jan 27, 3:58 pm, Thadeus Burgess <thade...@thadeusb.com> wrote: > Doesn't that break backwards compatibility ? > > -Thadeus > > On Wed, Jan 27, 2010 at 1:38 PM, mdipierro <mdipie...@cs.depaul.edu> wrote: > > I just made this default in trunk. > > > On Jan 27, 10:42 am, Thadeus Burgess <thade...@thadeusb.com> 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 <mdipie...@cs.depaul.edu> > >> 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 <life...@gmail.com> 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 web...@googlegroups.com. > >> > To unsubscribe from this group, send email to > >> > web2py+unsubscr...@googlegroups.com<web2py%2bunsubscr...@googlegroups.com> > >> > . > >> > 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 web...@googlegroups.com. > > To unsubscribe from this group, send email to > > web2py+unsubscr...@googlegroups.com. > > 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 web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/web2py?hl=en.