pardon, might i know, how do you export and import *.csv?
after, export the *.csv the best way is not touch or edit the contents,
except you know what to do and what you use, sometimes when you edit or
open it with spreadsheet like excel or libre/openoffice, when you close, it
automatically change your data
e.g.
- for empty field it would add , (comma) or ; (semicolon), depends on your
configuration for *.csv in spreadsheet program
- for date or time data it will be convert into your localization format
not database format yyyy-mm-dd
e.g. for export/import *.csv in controller
controllers/default.py
def download_csv():
stream = StringIO.StringIO()
db.export_to_csv_file(stream,
delimiter = ',',
quotechar = '"',
write_colnames = True,
represent = False)
response.headers['Content-Type'] = 'text/csv'
return stream.getvalue()
def upload_csv():
header = wino_system.header(T('Upload CSV') )
form = FORM(INPUT(_type = 'file', _name = 'csv_file'),
INPUT(_type = 'submit', _value = T('Import') ) )
if form.process().accepted:
if request.vars.csv_file != None:
csv_file = request.vars.csv_file.file
db.import_from_csv_file(csv_file)
response.flash = T('Form accepted')
elif form.errors:
response.flash = T('Form has errors')
else:
response.flash = T('Please fill the form')
return dict(header = header, form = form)
best regards,
stifan
--
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.
