I am able to save some information with the code you gave but when i try read from that file i get back *None *values: Am i missing something???
*CONTROLLER FOR READING THE FILE:* def viewInfo(): db = DAL('sqlite:memory') db.define_table('Clients', Field('Name'), Field('Surname')) backfile = os.path.join(request.folder, 'Client_Bookings_Backup.csv') db.Clients.import_from_csv_file(open(backfile)) grid = SQLFORM.grid(db.Clients, args=[db.Clients], editable=False, deletable=False, user_signature=False) return locals() Regards Mostwanted On Tuesday, October 23, 2018 at 10:11:55 PM UTC+2, Dave S wrote: > > > > On Tuesday, October 23, 2018 at 11:44:41 AM UTC-7, mostwanted wrote: >> >> I have a folder in my desktop that contains a CSV file that backs up >> information everytime something gets saved into the database. What i wanna >> know is how can I instead have this folder and CSV backup file saved in the >> app somewhere so that even if i relocate the application or take it online >> i don't have redefine the folder path or have it missing because the path >> was not defined correctly. >> >> > Something like the change below: > > >> *CONTROLLER SAVING TO THE EXTERNAL CSV FILE:* >> def index(): >> form=SQLFORM(db.Customer) >> if form.accepts(request.vars, session): >> customer=db(db.Customer).select(db.Customer.ALL) >> > > >> backfile = os.path.join(request.folder, ' >> Client_Bookings_Backup.csv') >> customer.export_to_csv_file(open(backfile, 'wb')) >> > > >> >> response.flash = T("CLIENT BOOKED") >> elif form.errors: >> response.flash = T("BOOKING FAILED! Please observe the form!") >> return locals() >> >> Regards: >> >> Mostwanted >> > > Good luck! > > Dave "somewhat wanted" > /dps > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.