it looks like the id_map will tell it which column to use to map IDs, so it
may do update or insert as appropriate. How convenient!
On Thursday, November 7, 2013 11:38:57 AM UTC-7, Derek wrote:
>
> pass it the 'restore=True' to truncate the table before inserting.
> Otherwise, it doesn't appear that the CSV import would do an 'insert or
> update'.
>
> On Monday, November 4, 2013 8:07:44 PM UTC-7, Sarbjit wrote:
>>
>> 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.
