Sweet! It works great after commenting out the auth tables and making that minor change to the import action. It had crossed my mind that the auth tables did not have uuid's but I did not realize that you could do without them completely. I will do some more poking around to find the parameters required to define my own auth tables in db.py with uuid's and see how that works.
Thank You, Chris On Oct 5, 10:33 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > I added the corresponding arguments to db.import_from_csv_file in > trunk so that the example works as listed (but without auth) > Sorry for this error. > > Massimo > > On Oct 5, 9:10 pm, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > GRRRRRR this is a major error in the manual > > > In book page 172 > > > db.import_to_csv_file(form.vars.data.file,unique=False) > > > is supposed to be: > > > db.import_from_csv_file(form.vars.data.file) > > > only db[table].import_from_csv_file take the unique argument. not the > > import of the entire DB. > > > You get the KeyError because you probably have auth_tables that do not > > have a uuid. The example only works if you do not have auth enabled > > (comment auth.define_tables()) > > > Massimo > > > On Oct 5, 12:38 pm, CJSteel <chris.st...@gmail.com> wrote: > > > > Database Synchronization and UUID's > > > > I am wondering if I need to do searches by uuid's in a different way. > > > I have been experimenting with them and frequently run into the error -> > > > KeyError: 'uuid' when attempting to do queries or when trying to > > > > pass them as variables from controllers to views and vice-versa. > > > > At the moment I am working with the example in the book (171-173) and > > > seem to be getting the same error again with the book example in > > > addition to one other error: > > > > TypeError: import_from_csv_file() got an unexpected keyword > > > argument 'unique' > > > > OR > > > > KeyError: 'uuid' > > > > I can eliminate the first error by changing the following line in the > > > import function: > > > > db.import_from_csv_file(form.vars.data.file,unique=False) > > > > to be > > > > db.import_from_csv_file(form.vars.data.file) #removed unique=False > > > > but then the now dreaded KeyError: 'uuid' shows up again. Here are > > > some links to my current db.py and default.py which are basically from > > > the book, although I needed to import some additional modules to get > > > it working and needed to change "now" to be "request.now" : > > > > db.py > > > view http://vishpala.com/resources/web2py/db.py/view > > > download http://vishpala.com/resources/web2py/db.py/at_download/file > > > > default.py > > > view http://vishpala.com/resources/web2py/default.py/view > > > > > > downloadhttp://vishpala.com/resources/web2py/default.py/at_download/file > > > > This line in the book intrigued me but I was not sure about how to go > > > about creating an index manually to make searching by uuid's go > > > faster, especially since I seem to be unable to search by uuid's at > > > all. I have a feeling it is a formatting issue (standard index int vs > > > the uuid format which includes dashes. > > > > "Create an index manually to make the search by uuid faster." > > > > I would appreciate any assistance and or suggestions, especially in > > > regards to a functioning query search by uuid and getting the import > > > function working. > > > > Web2py rocks! > > > > Cheers, > > > > Christopher Steel --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
