Greetings!
I have a simple form, which takes in a CSV file name and upload the file for
import to database.
This is the code to import uploaded data:
if form.accepts(request.vars, session):
response.flash = 'Form accepted'
db.import_from_csv_file(request.vars.csvfile.file)
In the database db, I have a table "unit":
db.define_table('unit',
Field('org', db.org, requires=IS_NOT_EMPTY()),
Field('type', type='integer', label=T('Unit Type'),
requires=IS_NOT_EMPTY(),),
Field('name', type='string', label=T('Unit Name'),
requires=IS_NOT_EMPTY(),))
The problem is: When I upload the file below, I get all NULL's for the
unit.type field.
TABLE unit
unit.org,unit.type,unit.name
1,1,"Unit 10"
1,1,"Unit 12"
1,1,"Unit 13"
1,1,"Unit 14"
1,1,"Unit 15"
1,1,"Unit 16"
1,1,"Unit 17"
1,1,"Unit 18"
1,1,"Unit 7"
1,1,"Unit 8"
1,1,"Unit 9"
1,2,"Unit 10"
1,2,"Unit 19"
1,3,"Unit 13"
1,3,"Unit 14"
1,3,"Unit 15"
1,3,"Unit 17"
1,3,"Unit 18"
1,3,"Unit 19"
1,3,"Unit 4"
1,3,"Unit 6"
1,3,"Unit 8"
1,3,"Unit 9"
2,1,"Unit 22"
2,1,"Unit 23"
2,2,"Unit 20"
2,3,"Unit 21"
3,1,"Unit 32"
3,1,"Unit 34"
3,3,"Unit 31"
3,3,"Unit 33"
4,1,"Unit 37"
4,1,"Unit 42"
4,2,"Unit 39"
4,2,"Unit 44"
4,2,"Unit 47"
4,3,"Unit 45"
4,3,"Unit 48"
END
Help is much appreciated.
