Hello,
I have a csv that comes from another program that I then import into a
web2py database. It has header names with spaces and that seems to prevent
it from being imported. I can make a macro in excel to format it before it
gets imported, but ideally that wouldn't be necessary mainly because then
the other clerks will have to know and remember to do that step.
I thought I could maybe stick something in the def import_csv like this:
def import_csv(table, file):
import csv
csvData = csv.reader(open(file))
isHeader = True
for row in csvData:
if isHeader:
isHeader = False
headerRow = row
for i in range(len(headerRow)):
# replace spaces w/ underscores in column headers
headerRow[i] = headerRow[i].replace(' ', '_')
table.import_from_csv_file(file)
But that doesn't work, and I really don't know if I'm on the right track.
--
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 [email protected].
For more options, visit https://groups.google.com/d/optout.
