[web2py] Re: need custom auth form to not require unique email

2016-08-01 Thread Massimo Di Pierro
No need. Simply use auth.define_tables(username=True) and if you need db.auth_user.username.label = 'My Username' On Monday, 1 August 2016 17:04:23 UTC-5, b.l. masters wrote: > > Hi > > I am new to Web2py, so I apologize in advance if this is basic. > > So, I am wanting to create a

[web2py] need custom auth form to not require unique email

2016-08-01 Thread b.l. masters
Hi I am new to Web2py, so I apologize in advance if this is basic. So, I am wanting to create a custom login, that does not require someone to enter an email. So, following some of the examples I have found out there, I created a custom auth table, with a username, etc. (I paste the code

[web2py] MySQL DAL questions

2016-08-01 Thread Dave S
Trying to translate someone else's MySQL CREATE TABLE into a define_table, which of course means I need to know what to do with 2 left shoes. 1) Can I translate a BIT field as a 'boolean'? 2) For legacy tables, does a keyed table work when the ID-like field on the MySQL side is a VARCHAR

[web2py] Re: Can we use a web2py app on Android mobile?

2016-08-01 Thread rajjmatthur
Very interesting topic guys. Wonder how we make a web2py app downloadable to google playstore or iphone App Store? Does Kivi or cordova both does that? On Saturday, January 30, 2016 at 11:56:18 AM UTC-5, eric cuver wrote: > > You create your application mobile friendly > > for kivy > > After

[web2py] run a process inside factory but before field definitions

2016-08-01 Thread Alex Glaros
Is there a way to include a process inside factory but before the field definitions start? Example: assign_to_party = SQLFORM.factory( I WANT TO INCLUDE THIS LINE ABOVE THE LINE BELOW: limited_choices = ((db.Party.id > 0) & (~db.Party.id.belongs(all_current_assignees)))

[web2py] list:reference table but filtered based on row.field?

2016-08-01 Thread António Ramos
Hello how can i have a requires=XXX to filter data on the referenced table based on the field entities selected by the user? db.define_table( 'usersubentities', Field('auth_user', db.auth_user), Field('entities' , "list:reference db.dbentities",requires=IS_IN_DB(db,

[web2py] DAL suggestion with relations to list fields under a list:reference

2016-08-01 Thread António Ramos
Hello i have this situation and need some good ideas I have table :auth_user ("John","Oliver","Trump") table :dbentities ( for example Person,Equipment,Company) each entity on entities table has subentities field of type: list:string for example for Person , subentities=["A","B","C"] My case is

[web2py] Re: Grid export csv

2016-08-01 Thread Kostas M
I have the same problem with the CSV, HTML, TSV export buttons. The Ticket for the CSV is pasted below. The problem at least with the csv export button seems to be with the REGEX_TABLE_DOT_FIELD. Normally, this constant is defined in regex.py as: REGEX_TABLE_DOT_FIELD =

[web2py] Re: Grid export csv

2016-08-01 Thread Ryan Hood
DB.PY db.define_table('test', Field('name', 'string', length=50, notnull=True), Field('email', 'string', notnull=True), format="%(name)s") DEFAULT.PY query=(db.test.id>0) fields=[db.test.id,db.test.name,db.test.email]

Re: [web2py] Re: python process consumes 100% cpu

2016-08-01 Thread St. Pirsch
Thanks!. I tested the web2py gui on a different mac machine with 10.11.5 & it's running hot as well. I'am going to try it with the Tcl/Tk versions recommended in your link instead of the ones provided by the OS. Kiran Subbaraman schrieb am Mo., 1. Aug. 2016 um 06:08