I am using import csv option to insert records in the database. When I use
the csv file from the web application, then a single record is inserted in
the database with all the records being updated properly as per the headers.
But If I try to use "import_from_csv_file" outside the web2py, it inserts
multiple records in the database. This seems to be an bug to me.
Code for updating db outside web2py
libraryPath = r'D:\web2py'
dbPath = r'D:\web2py\applications\testapp\databases'
import sys
sys.path.append(libraryPath)
from gluon import DAL
db = DAL('sqlite://storage.sqlite',folder=dbPath,auto_import=True)
table = db['person']
file = r'D:\file.csv'
table.import_from_csv_file(file)
db.commit()
On using the same file (csv file) using the web2py, it works as expected,
code :-
file = request.vars.csvfile.file
table.import_from_csv_file(file)
Can some one please comment on this behavior, what am I missing here?
-Sarbjit
--
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/groups/opt_out.
