I now have the database up and running, but when I try to do this:
db.export_to_csv_file(open('/home/www-data/web2py/applications/welcome/uploads/file.csv',
'wb'))
db2.import_from_csv_file(open('/home/www-data/web2py/applications/welcome/uploads/file.csv',
'rb'))
It tells me:
Traceback(most recent call last):
File"/home/www-data/web2py/gluon/restricted.py",line205,inrestricted
execccodeinenvironment
File"/home/www-data/web2py/applications/welcome/models/wiki_page.py"
<https://interestid.com/admin/default/edit/welcome/models/wiki_page.py>,line23,in<module>
db2.import_from_csv_file(open('/home/www-data/web2py/applications/welcome/uploads/file.csv','rb'))
File"/home/www-data/web2py/gluon/dal.py",line6446,inimport_from_csv_file
raiseSyntaxError,'invalid file format'
SyntaxError:invalid file format
I opened the file and it seems to look ok. Ends with END :)
BR,
Jason