Many thanks for your help all, i'm slowly getting my head around it. I'll post the code once it's finished in case anyone needs it in future
cheers Matt On Wed, Aug 1, 2018 at 7:41 AM, sandeep patel <[email protected]> wrote: > @Mattew J Watts, > #Model > > db.define_table('person', > Field('name'), > Field('age'), > Field('country'), > format='%(name)s') > > db.define_table('thing', > > Field('person_id,'reference preson') > Field('thing_name'), > Field('value'), > Field('location')) > > #controller > def import_csv(): > form = FORM(DIV(LABEL('file input',_for='exampleInputFile' > ),INPUT(_type='file',_name='csvsheet',_id="exampleInputFile"),_class=' > from-group'),BUTTON('click',_type='submit',_class="btn btn-default")) > if form.process().accepted: > try: > for i in csv.DictReader(request.vars.csvsheet.file): > # db['things'].insert(person_id= db['person'].insert(**i) > ,.........) > a = db['person'].insert(**i) > db['things'].insert(person_id=a,.........) > except: > form.errors.csvfile = 'Invalid file format.' > return locals() > > Hope, this will help you! > > Best/ > > On Wed, Aug 1, 2018 at 12:51 AM Anthony <[email protected]> wrote: > >> On Tuesday, July 31, 2018 at 2:24:51 PM UTC-4, pbreit wrote: >>> >>> I know db.thing.insert will return the ID of the newly created record >>> and am pretty sure update_or_insert does as well. I'm not exactly sure how >>> you would determine if an update or insert was performed (but perhaps you >>> do not need to know?). >>> >> >> Actually, update_or_insert does *not* return the ID in case of an >> update. If you need the ID, then don't use update_or_insert but instead >> write your own logic (the method is fairly simple -- see >> https://github.com/web2py/pydal/blob/c954d1a22a0b83d90f728a4ab2daaa >> 954e3f16c8/pydal/objects.py#L822). >> >> Anthony >> >> -- >> 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. >> > -- > 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 a topic in the > Google Groups "web2py-users" group. > To unsubscribe from this topic, visit https://groups.google.com/d/ > topic/web2py/EIFyKq78le4/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- 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.
