[web2py] Re: SQLFORM.grid input fields size in auto generated Edit/New forms

2016-07-25 Thread Dave S
On Monday, July 25, 2016 at 2:25:32 PM UTC-7, rajjm...@gmail.com wrote: > > I have the same question. But for DAL in general. How to limit the string > or text? > Field('myfield', 'string', length=32, ...) This is described in the Field constructor documentation, but I'm not sure there are

[web2py] Re: Adding custom fields and their location to auth users

2016-07-25 Thread 黄祥
please check the book ref : http://web2py.com/books/default/chapter/29/09/access-control#Customizing-Auth best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: SQLFORM.grid input fields size in auto generated Edit/New forms

2016-07-25 Thread rajjmatthur
I have the same question. But for DAL in general. How to limit the string or text? On Monday, July 25, 2016 at 5:00:49 PM UTC-4, icodk wrote: > > How can I change the input field size (what is visible to the user) of > SQLFORM.grid auto generated Edit/New forms. > Tried with length=50 but the

[web2py] Re: list of time zones

2016-07-25 Thread icodk
Thanks for the tips On Monday, July 25, 2016 at 7:50:25 PM UTC+2, mai...@gmail.com wrote: > > How can I present to user a list of available timezons for him to choose > from, in a web2py application. > nothing to do with user's own time zone or server's time zone. > Basically I could create a

[web2py] SQLFORM.grid input fields size in auto generated Edit/New forms

2016-07-25 Thread icodk
How can I change the input field size (what is visible to the user) of SQLFORM.grid auto generated Edit/New forms. Tried with length=50 but the fields are still about 20 chars long. Also: IS_LENGTH(minsize=5,maxsize=50) had no visible effect. None of the settings limits the number of chars user

[web2py] Amazon Redshift

2016-07-25 Thread Alex Glaros
Am not well versed in architecture so hope this question even makes sense I like how Amazon Redshift looks and was wondering if it's possible to have my web2py transactional Postgres database on PythonAnywhere continually copy data in real time to Amazon Redshift for users to create their own

[web2py] Re: list of time zones

2016-07-25 Thread Dave S
On Monday, July 25, 2016 at 10:50:25 AM UTC-7, mai...@gmail.com wrote: > > How can I present to user a list of available timezons for him to choose > from, in a web2py application. > nothing to do with user's own time zone or server's time zone. > Basically I could create a table with all time

[web2py] Re: Specific validation on custom auth user table

2016-07-25 Thread Massimo Di Pierro
A validator must be a class, not a method. custom_auth_table.dt_b.requires = IS_INT_IN_RANGE(18, 120) On Sunday, 24 July 2016 13:56:27 UTC-5, Morganti wrote: > > Hello, > > I am new in python and web2py also. > > I tryed to create a custom auth because I have a project and it is needing > a lot

[web2py] Re: Importing Current

2016-07-25 Thread Massimo Di Pierro
in gluon/__init__.py there is a "from globals import current" On Saturday, 23 July 2016 11:44:38 UTC-5, Carlos Zenteno wrote: > > Stupid question... > > When we run > > From gluon import current > > Where does current is imported from? > > I have only found current defined in globals.py as : > >

[web2py] Re: start_time in web2py scheduler task seems to be ignored on Windows

2016-07-25 Thread Dave S
On Monday, July 25, 2016 at 10:50:25 AM UTC-7, cam schn wrote: > > Hello everyone. > > I am trying to schedule a task to run only once at a specific time. I am > using the "start_time" argument in the function queue_task of the scheduler > as below: > > scheduler.queue_task( >

[web2py] Re: suggestion for naming web2py version

2016-07-25 Thread Massimo Di Pierro
Whatever version you have, it is a good idea to upgrade to the latest. It will be easier for us to help you. When you register. Do you get the email with the verification link? Does registration required verficaition? does it required administrator approval? This is in db.py On Friday, 22

Re: [web2py] Re: Is there a way to find ID of inserted row if there is trigger after insert?

2016-07-25 Thread Massimo Di Pierro
Can you show the full traceback? On Thursday, 21 July 2016 15:53:04 UTC-5, Richard wrote: > > Did we open a ticket and solve this one... I think I have this issue... I > try to create an archive table and I fall on this error > > dal/pydal/adapters/postgres.py", line 181, in lastrowid > >

[web2py] Re: custom register and verify_email

2016-07-25 Thread Massimo Di Pierro
Sorry. Do not understand. Can you explain again how the verification would work without the link? On Wednesday, 20 July 2016 02:24:39 UTC-5, Annet wrote: > > I have this settings: > > auth.settings.actions_disabled = ['register', 'impersonate', 'groups'] >

[web2py] Re: save image from get request

2016-07-25 Thread Massimo Di Pierro
replace with: response_image = requests.get(' https://kc.kobotoolbox.org/attachment/large?media_file=%s' % (x['filename']),stream=True) img2 = db.insect_images.image.store(response_image.content,x['filename']) db.insect_images.insert(image=img2, accession_code=dat['accession_code_']) You do not

Re: [web2py] Re: DAL is dropping column when not supposed to

2016-07-25 Thread Alex Glaros
better description of the problem: DAL updates to change/add columns don't work when Postgres has data in it If I create duplicate empty version of Postgres schema, then collumns get created/changed correctly If I try on production copy of schema that has data, it doesn't take does this

Re: [web2py] Re: Again: virtual field requires type-attribute

2016-07-25 Thread Massimo Di Pierro
In select() you can pass the list of fields that you want. Are you asking for an automated way to exclude virtual fields? On Tuesday, 19 July 2016 14:54:10 UTC-5, Julio del Barrio wrote: > > Hi, Massimo. > If I not want any virtual fields in row object returned by select? If I > use the

[web2py] start_time in web2py scheduler task seems to be ignored on Windows

2016-07-25 Thread cam schn
Hello everyone. I am trying to schedule a task to run only once at a specific time. I am using the "start_time" argument in the function queue_task of the scheduler as below: scheduler.queue_task( mytask, pargs=[], pvars= dict(a=2,

[web2py] Stream output on the fly

2016-07-25 Thread Sagar Shah
Hi, I was wondering if there was a way to return the output from a particular function on the fly. I am requesting logs from an external firewall and it is supposed to take a while for the whole thing to complete. I want to return the output to the frontend as data is returned to the backend.

[web2py] list of time zones

2016-07-25 Thread mailqnx
How can I present to user a list of available timezons for him to choose from, in a web2py application. nothing to do with user's own time zone or server's time zone. Basically I could create a table with all time zones (found on wikipidia) and populate a listbox to choose from. Is there a

[web2py] Adding custom fields and their location to auth users

2016-07-25 Thread Oasis Agano
Greetings i have added a custom field to the auth users table but i want to move its position in the middle maybe after email how can i do it? Thanks in advance -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Using web2py with GreenPlum: Returning clause error

2016-07-25 Thread Madhavi
I am trying to connect web2py to GreenPlum 4.3.8.2, which does not support the RETURNING clause of PostGreSQL by using the below DAL string: db=DAL('postgres://user1:password@serverip/mydatabase') The connection is established successfully, and auth tables are created. However, when I attempt

[web2py] Rethinkdb on Web2py

2016-07-25 Thread Oasis Agano
Is there a way of using rethinkdb on web2py framework -- 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

[web2py] Re: jQuery(document).ready presence kills bootstrap pulldown main menu

2016-07-25 Thread lucas
ok, stupid me. brain fart and such. the jQuery.ui.version user interface js file needs to be loaded under the head section of the view for the jQuery(document).ready function to run all of the way through. if it doesn't run through properly to the end and bug out, the main menu will not

[web2py] Re: jQuery(document).ready presence kills bootstrap pulldown main menu

2016-07-25 Thread lucas
> > actually, if i comment out the two lines under the ready function, the > main menu drop downs work again. in fact, if i do: > jQuery(document).ready( function () { //var sx = "jQuery.version: "+jQuery.fn.jquery+" | jQuery.ui.version: "+jQuery.ui.version; //console.log(sx);

[web2py] Re: jQuery(document).ready presence kills bootstrap pulldown main menu

2016-07-25 Thread Ron Chatterjee
This does as well. https://github.com/davatron5000/FitText.js Found it the hard way. lol On Monday, July 25, 2016 at 11:38:25 AM UTC-4, lucas wrote: > > hello one and all, > > interesting thing i have encountered. if i include: > > {{block head}} > > jQuery(document).ready( function () { >

[web2py] jQuery(document).ready presence kills bootstrap pulldown main menu

2016-07-25 Thread lucas
hello one and all, interesting thing i have encountered. if i include: {{block head}} jQuery(document).ready( function () { var sx = "jQuery.version: "+jQuery.fn.jquery+" | jQuery.ui.version: "+jQuery.ui.version console.log(sx); }); {{end}} under a view, the main menu doesn't pull

[web2py] Re: web2py on android

2016-07-25 Thread Francisco García
Hello, Yes, you can write your backend Restful service with Web2py, and connect consumer web applications, android or iOS apps, etc. I use to read ODoo web services, process data with Web2py and publish to customers with a Restfull service. Web2py is perfect for this tasks. It is very fast and

[web2py] Re: web2py and sparkpost : :Mail.send failure:SMTP AUTH extension not supported by server

2016-07-25 Thread icodk
Thank It is working now On Monday, July 25, 2016 at 3:11:20 PM UTC+2, Mirek Zvolský wrote: > > Such setting format is from private/appconfig.ini. > In db.py I have: > mail = auth.settings.mailer > mail.settings.server = 'logging' if request.is_local else myconf.take( > 'smtp.server') >

[web2py] Re: web2py and sparkpost : :Mail.send failure:SMTP AUTH extension not supported by server

2016-07-25 Thread Mirek Zvolský
Such setting format is from private/appconfig.ini. In db.py I have: mail = auth.settings.mailer mail.settings.server = 'logging' if request.is_local else myconf.take( 'smtp.server') mail.settings.sender = myconf.take('smtp.sender') mail.settings.login = myconf.take('smtp.login') Dne pondělí

[web2py] Re: web2py and sparkpost : :Mail.send failure:SMTP AUTH extension not supported by server

2016-07-25 Thread Mirek Zvolský
Try the port :587 setting. My settings are: [smtp] server = smtp.sparkpostmail.com:587 sender = mojekniho...@mojeknihovna.eu login = SMTP_Injection:4d..92 Dne neděle 24. července 2016 16:52:17 UTC+2 icodk napsal(a): > > I try to use sparkpost with web2py. However I get the following error: >