[web2py] get new user's email and data

Hello After a new user registers, I would like to send his data to my email (user email and database where it was created) I have user requires confirmation set to true and I have a couple of databases so that is a must, also to check on user I need to get his e-mail to inform him his registrat

Re: [web2py] Edit button behavior with sqlform.grid and multiple joins

On 23 January 2013 20:27, Jason Martens wrote: > Hello All, >I have a SQLFORM.grid with multiple joins that looks something like > this: > > query = (db.locations.id == 10) & (db.rooms.id == db.locations.room_id) & > (db.other.id == db.rooms.other_id) > SQLFORM.grid(query) > > The problem is

[web2py] Re: How to multi-line session.flash

I send string to flash from my model on auth.messages.registration_pending. Since it is quite long i want to make it multiline. \n in my string do not work how to handle that? thank you best regarst On Tuesday, November 24, 2009 5:23:38 PM UTC+1, mdipierro wrote: > > response.flash = DIV("he

Re: [web2py] Re: SQLFORM.factory and uploaded files. where is the link?

i added upload=URL('default', 'download'), uploadfolder=os.path.join(request.folder,'uploads') form=SQLFORM.factory(db.auth_user,db.e_docs, submit_button="Gravar", fields=['empresa','email','telefone','alvara','alvaraval','segrespcivil','segrespcivilval','segactra

Re: [web2py] Re: SQLFORM.factory and uploaded files. where is the link?

A litle more explaining First i create my form.factory then i query the database form a record and set the fields in my form This is a form to edit a record here is my code form=SQLFORM.factory(db.trabalhador,db.t_docs, submit_button="Gravar", fields=['nome','bi','ncart','ncartval','apt

[web2py] Is there a way to use query in autocomplete with SQLFORM.factory?

I would like autocomplete to show just a subset of data, not all rows in table. Is it possible to use query in autocomplete like this? query = db.recipe.user_id==auth.user_id form=SQLFORM.factory(Field('title', 'string', required=True, requires= IS_NOT_EMPTY()), Field('type', 'st

Re: [web2py] get new user's email and data

def myfunc(form): # here you get form.vars auth.settings.register_onaccept = myfunc Em 24/01/2013 06:24, "Yebach" escreveu: > Hello > > After a new user registers, I would like to send his data to my email > (user email and database where it was created) > I have user requires confirmation set t

[web2py] autoroutes.py and static files on GAE

Hi All, I'm deploying an app to GAE, and am exploring the routing options. Because my needs are simple (just need to map to app based on hostname) auroroutes.py would be my preferred option. I've used auroroutes.py before behind Apachge without problems, but on GAE my pages work but the CSS,

Re: [web2py] get new user's email and data

Do I insert this code in my model (db.py)? my auth.setting.register_onaccept = lambda form: mail.send(to=['x...@xxx.net'], subject='web2py registration', # If reply_to is omitted, then mail.settings.sender is used reply_to='u...@example.com', message= u'A n

Re: [web2py] Re: SQLFORM.factory and uploaded files. where is the link?

> > form=SQLFORM.factory(db.trabalhador,db.t_docs, submit_button="Gravar", > > fields=['nome','bi','ncart','ncartval','apt_medica','apt_medicaval','val_formacao','f_doc'], > table_name='trabalhador', > upload=URL('default', 'download'), > uploadfolder=os.

Re: [web2py] get new user's email and data

auth.setting.register_onaccept = lambda form: mail.send(to=['x...@xxx.net'], subject='web2py registration', # If reply_to is omitted, then mail.settings.sender is used reply_to='u...@example.com', message= u'A new user has been created on database %s and has

Re: [web2py] Re: automatic email when registration_requires_approval =True

i tried auth.settings.verify_email_onaccept = lambda form: mail.send(to='antonio.ra...@cires.pt',subject='Conta pendente de Aprovação. Portal Empreiteiros',message=repr(form.vars)) but i get the error!!! AttributeError: 'Row' object has no attribute 'vars' 2013/1/10 Massimo Di Pierro >

Re: [web2py] Re: automatic email when registration_requires_approval =True

auth.settings.verify_email_onaccept = lambda user: mail.send(to='antonio.ra...@cires.pt',subject='Conta pendente de Aprovação. Portal Empreiteiros',message=repr(user)) --

Re: [web2py] get new user's email and data

Thank you you saved my day :) On Thursday, January 24, 2013 2:31:16 PM UTC+1, rochacbruno wrote: > > auth.setting.register_onaccept = lambda form: > mail.send(to=['x...@xxx.net > '], > subject='web2py registration', > # If reply_to is omitted, then mail.settings.sender is us

Re: [web2py] Re: automatic email when registration_requires_approval =True

auth.settings.verify_email_onaccept = lambda form: mail.send(to='antonio.ra...@cires.pt',subject='Conta pendente de Aprovação. Portal Empreiteiros',message=repr(users)) NameError: global name 'users' is not defined 2013/1/24 Bruno Rocha > > auth.settings.verify_email_onaccept = lambda user:

Re: [web2py] Re: SQLFORM.factory and uploaded files. where is the link?

You are telling me that sqlform.factory is not good for editing records with uploaded files because the link does not show up in the view? I kill myself. :) 2013/1/24 Anthony > form=SQLFORM.factory(db.**trabalhador,db.t_docs, > > submit_button="Gravar", >> fields=['nome','bi'

Re: [web2py] Re: automatic email when registration_requires_approval =True

auth.settings.verify_email_onaccept = lambda USER: mail.send(to='antonio.ra...@cires.pt',subject='Conta pendente de Aprovação. Portal Empreiteiros',message=repr(USER)) --

Re: [web2py] Re: automatic email when registration_requires_approval =True

GLOBAL NAME USER IS NOT DEFINED! :) i tried also "USERS" but same error!!! 2013/1/24 Bruno Rocha > > auth.settings.verify_email_onaccept = lambda USER: > mail.send(to='antonio.ra...@cires.pt',subject='Conta pendente de Aprovação. > Portal Empreiteiros',message=repr(USER)) > > -- > > >

Re: [web2py] Re: automatic email when registration_requires_approval =True

i replaced form.vars by just form in the message and the email i get shows me that form has no vars so i use form.email and it works. Is this correct? 2013/1/24 António Ramos > GLOBAL NAME USER IS NOT DEFINED! > :) > > i tried also "USERS" but same error!!! > > > > 2013/1/24 Bruno

[web2py] form on error clears upload fields

Hello IS there any way to avoid clearing upload fields when the form detects errors in fields? Only uploaded fields are cleared. the others are not In a form with 10 upload fields if the users forgets one of them and submits the form, has to repeat all of them . Thats anoying.. Thank you --

[web2py] Re: error in alwaydata ?

We do not have that file. Never did according to my logs. Do they mean this perhaps fcgihandler.py On Wednesday, 23 January 2013 19:51:32 UTC-6, samuel bonilla wrote: > > i am trying this command in alwaysdata hosting with ssh, for up my web2py > application, but i get this error: > > http://fo

[web2py] Re: How to track where the MySql error 2014 is occuring?

Do you have try... except in your program? This may be cause by a wrong query in a try...except not followed by a db.rollback(). On Thursday, 24 January 2013 01:03:37 UTC-6, Saurabh Kumar wrote: > > Hi, > > I have a Web2py app running on Mysql. In my apache logs, I get to see a > lot of mysql er

[web2py] Re: form on error clears upload fields

The fields are not rememberd serverside, they are sent back to client as new default values. This cannot be done for upload fields. This about the client uploading a large file. If the validation fails, you do not want to send the large file back to the client. On Thursday, 24 January 2013 08:4

[web2py] Re: How do I use web2py to make a simple GUI?

> > Hi, the answer to this question may well be that I should leave web2py > alone and use something else, so I had better start > Note that there's a special mobile plugin for web2py. See the instructions at /admin/plugin_jqmobile/about --

[web2py] Re: Saving language files

Click in the background of the page to lost focus on every field, press then "End" key and you are at the bottom of the page. If you press the "Home" key you go to the top of the page. Regards > On Wednesday, 23 January 2013 05:33:45 UTC-6, Ramos wrote: >> >> Hello >> >> I live in Portugal, an

[web2py] Re: autoroutes.py and static files on GAE

Hi, I couldn't make any sense of the issue with autoroutes.py, so had a look in the cookbook, only to find that the functionality I was after (map a host-name to an app) is in the "normal" parameter-based router, and have tested and confirmed that this works as expected on GAE. If I can help

Re: [web2py] Re: How to track where the MySql error 2014 is occuring?

Yes, I do have try/catch blocks. I will make the changes as suggested by you. On Thu, Jan 24, 2013 at 8:24 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Do you have try... except in your program? This may be cause by a wrong > query in a try...except not followed by a db.rollback()

Re: [web2py] Re: autoroutes.py and static files on GAE

On 24 Jan 2013, at 7:09 AM, Philip Kilner wrote: > > I couldn't make any sense of the issue with autoroutes.py, so had a look in > the cookbook, only to find that the functionality I was after (map a > host-name to an app) is in the "normal" parameter-based router, and have > tested and confir

[web2py] Troubles with the database administration and sidebars

Hi, about two moth ago I couldn't access the Database administration for some reason I can not find this topic anymore. Well the problem was that I had defined a variable in the left and in the right sidebar. (only one sidebar was turned on) the default controler didn't care but the appadmin co

Re: [web2py] Re: session.flash not working?

I am also experiencing this issue, however I tried to recreate it with a simple view/controller, and was unable to do so, but I have a much larger application with the problem. I'm currently using v 2.2.1. Is there any way to "watch" the session.flash variable to see where it is getting unset a

Re: [web2py] Re: SQLFORM.factory and uploaded files. where is the link?

With SQLFORM edit forms, the link for upload fields appears automatically when a record (or record id) is passed to the SQLFORM constructor via the "record" argument. You are not using that argument, hence you get no link. You can either pass a record (or a dict or Storage object whose keys are

[web2py] selecting database entries

Hi I got two tables in my application one for images and one for articles. an artical can have multiple images attached to it. What I want to do is displaying a list of the newest images but there should only be one per article db.define_table('Images', Field('Headline',length=1024), Fiel

Re: [web2py] Re: autoroutes.py and static files on GAE

Hi Jonathan, On 24/01/13 15:27, Jonathan Lundell wrote: Have you disabled static file mapping in app.yaml? I hadn't, no - only the app name and the Python version are changed there. -- Regards, PhilK 'a bell is a cup...until it is struck' --

[web2py] Re: form on error clears upload fields

Keep in mind that on the client side, the values of upload fields point to file locations on the user's computer. For security reasons, these locations are not communicated to the server, so there is no way for the server to send them back and therefore re-populate the fields with those locatio

Re: [web2py] Re: automatic email when registration_requires_approval =True

I don't think you noticed that Bruno changed the name of the lambda argument to USER: auth.settings.verify_email_onaccept = lambda USER: mail.send(to='antoni...@cires.pt',subject='Conta pendente de Aprovação. Portal Empreiteiros',message=repr(USER)) Anthony On Thursday, January 24, 2013 9:04

Re: [web2py] Re: automatic email when registration_requires_approval =True

Actually, it is not the form that gets passed to the auth.settings.verify_email_onaccept function -- instead it is the user record itself. That's why Bruno used the name "user" instead of "form" for the argument to the lambda. You can see below that the email message is showing a serialization

[web2py] Autocomplete problem ...

I'm trying my first application in web2py. I've this model db.define_table('Person', Field('name'), format='%(name)s') db.define_table('Relation', Field('name',db.Person), ('contact',db.Person)) db.Relation.name.widget=SQLFORM.widgets.autocomplete(request,db.Person,id_field=db.Person.id) db.Relat

[web2py] Re: SQLFORM.smartgrid: TSV & CSV export with hidden cols only shows visible cols

> > When using the CSV export with hidden cols or the TSV export with hidden > cols, I have none of the hidden columns in the view. I think they applied a patch to .smartgrid to export hidden cols in the trunk version --

Re: [web2py] Re: SQLFORM.factory and uploaded files. where is the link?

Could you please show me a sample script or point me some links to study? I´m out of ideas now. I´m using sqlform.factory to show 2 tables in the same form.Is factory the best option? Can i just use sqlform to do the same thing? sqlform has the option of passing a record.But how about links to uplo

Re: [web2py] Re: autoroutes.py and static files on GAE

On 24 Jan 2013, at 7:55 AM, Philip Kilner wrote: > > On 24/01/13 15:27, Jonathan Lundell wrote: >> Have you disabled static file mapping in app.yaml? >> > > I hadn't, no - only the app name and the Python version are changed there. You'll see sections like this: - url: /(?P.+?)/static/(?P.+)

Re: [web2py] Re: automatic email when registration_requires_approval =True

Ok , thank you Also when a user registers and i have in my model auth.settings.registration_requires_verification = True The user when submiting the form is redirected to index and never sees a flash message saying "Please check your email" How can i have a flash message telling the user to check

Re: [web2py] Re: SQLFORM.factory and uploaded files. where is the link?

> > *1 - You can either pass a record (or a dict or Storage object whose keys > are the same as the field names in your tables) to SQLFORM and let it fill > in all the field values for you (including creating the link for the upload > field)* > *How does a SQLFORM create the link for the upload

Re: [web2py] Re: SQLFORM.factory and uploaded files. where is the link?

All of this can be used with SQLFORM.FACTORY? or do i have to use just SQLFORM? 2013/1/24 Anthony > *1 - You can either pass a record (or a dict or Storage object whose keys >> are the same as the field names in your tables) to SQLFORM and let it fill >> in all the field values for you (inclu

[web2py] Re: records as fields in a single form

@Massimo, Thanks for your reply. I gave the code a try I had to remove name= from the Field definition, now I am stuck at form=SQLFORM.factory(*fields_list) it gives me the following error: Traceback (most recent call last): File "/Users/annet/web2py/gluon/restricted.py", line 212, in restrict

Re: [web2py] Re: SQLFORM.factory and uploaded files. where is the link?

I think it should work with factory -- haven't tried it. Anthony On Thursday, January 24, 2013 12:26:03 PM UTC-5, Ramos wrote: > > All of this can be used with SQLFORM.FACTORY? > or do i have to use just SQLFORM? > > > > > 2013/1/24 Anthony > > >> *1 - You can either pass a record (or a dict or S

[web2py] Re: Autocomplete problem ...

db.Relation.name.widget=SQLFORM.widgets.autocomplete(request,db.Person,id_field= db.Person.id ) db.Relation.contact.widget=SQLFORM.widgets.autocomplete(request,db.Person,id_field= db.Person.id ) should be db.Relation.name.widget=SQLFORM.widgets.autocomp

[web2py] web2py manual vs. screen size/res?

What size/res screen is the web2py manual supposed to display on, without having to scroll side-to-side to see everything? I'm using FF 18.01, and IE 8 (no choice on the latter), and whether @ 1024x768 or 1152x864, regular fonts, large fonts, etc. the web2py manual still takes up *everything* p

[web2py] skeleton css sidebar under content

Hi, I just tried to reach my application via my android phone and my sidebar is for some reason under the content(I'm using the right sidebar) with my computer there is no problem. its displaying perfectly as it should any ideas why this is happening? --

[web2py] Re: web2py manual vs. screen size/res?

Can you help us fix the css? The online book is supposed to be using twitter bootstrap and resize itself. On Thursday, 24 January 2013 12:29:06 UTC-6, Monte Milanuk wrote: > > What size/res screen is the web2py manual supposed to display on, without > having to scroll side-to-side to see everyth

[web2py] Re: records as fields in a single form

When I return fields_list in dict to the view, this is what fields-list contains: fields_list: Is there a way to see what's in the gluon.dal.Field objects? Kind regards, Annet. --

[web2py] Re: web2py manual vs. screen size/res?

Well, I'm pretty fuzzy on a lot of this stuff... is there something I can check to provide feedback, etc. for you? On Thursday, January 24, 2013 10:49:39 AM UTC-8, Massimo Di Pierro wrote: > > Can you help us fix the css? The online book is supposed to be using > twitter bootstrap and resize its

[web2py] extended bootstrap

http://jasny.github.com/bootstrap/ --

[web2py] Re: records as fields in a single form

> > Is there a way to see what's in the gluon.dal.Field objects? > [index]. Where is one of default, represent, type, compute, ... (field attributes set i.e. in the model) See here a snippet to returning Field/Table/DAL as dictionary or xml (it's a working prototype) http://www.web2pyslice

[web2py] Re: selecting database entries

Well, you don't want to select images then, you want to select articles - then get a single image attached to the article. On Thursday, January 24, 2013 8:51:42 AM UTC-7, BlueShadow wrote: > > Hi I got two tables in my application one for images and one for articles. > an artical can have multi

[web2py] Re: Official site quotes

What about this: (is it legal english?) web2py: a highly complex ecumenical body of computing knowledge devised for user happiness. --

Re: [web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

ok, made it more modular, and now web2py config for uwsgi is in ini-style (far more readable). If you come from previous script, before executing this please delete /etc/uwsgi/web2py.xml . the new /etc/uwsgi/web2py.ini will be created with the exact same options. thanks Paolo, patch attached.

Re: [web2py] update easy_install

sorry I meant pypi. On Wednesday, January 23, 2013 3:09:11 PM UTC-7, Richard wrote: > > Did you try pip? > > Richard > > > On Wed, Jan 23, 2013 at 4:56 PM, Derek >wrote: > >> I know how to get the latest version. I was just mentioning that when I >> run easy_install, it tries to install an older

Re: [web2py] update easy_install

Hmm, I just tried pip and same thing, installs 2.1.1 On Wednesday, January 23, 2013 3:09:11 PM UTC-7, Richard wrote: > > Did you try pip? > > Richard > > > On Wed, Jan 23, 2013 at 4:56 PM, Derek >wrote: > >> I know how to get the latest version. I was just mentioning that when I >> run easy_insta

Re: [web2py] update easy_install

The web2py on PyPi should be a meta-package, in setup.py it should download the latest version from website and include on users site-package. --

Re: [web2py] extended bootstrap

Really nice!, this is going to my current project, thanks for sharing. > http://jasny.github.com/bootstrap/ > --

[web2py] Re: SQLFORM.smartgrid: TSV & CSV export with hidden cols only shows visible cols

Thanks Alan, Just tried the nightly build, and it's not (yet) fixed. Regards, --

[web2py] Enable my workstation as admin on remote web2py server

I have web2py installed on a remote box (QNAP Server). I'm doing some testing with it and want to enable appAdmin from my workstation to the web2py instance. I can't seem to find how I can do that. Can I add my ip as an admin client someone in web2py? --

[web2py] Re: SQLFORM.smartgrid: TSV & CSV export with hidden cols only shows visible cols

Here http://code.google.com/p/web2py/issues/detail?id=1294 a very similar issue was reported (and fixed in trunk) --

Re: [web2py] Enable my workstation as admin on remote web2py server

Nevermind, found this on stackoverflow http://stackoverflow.com/questions/12834550/simplest-way-to-setup-remote-admin-access-to-a-web2py-process -Jim On Thu, Jan 24, 2013 at 4:36 PM, Jim S wrote: > I have web2py installed on a remote box (QNAP Server). I'm doing some > testing with it and wan

[web2py] websocket_messaging.py over ssl

websocket_messaging.py looks nice, and the example in the comments immediately works in chrome. (not in ff) But how can I encapsulate that in https or using it through ssl? Regards, --

[web2py] Re: Official site quotes

LOL On Thursday, 24 January 2013 14:36:42 UTC-6, Alan Etkin wrote: > > What about this: (is it legal english?) > > web2py: a highly complex ecumenical body of computing knowledge devised > for user happiness. > > --

Re: [web2py] update easy_install

How? On Thursday, 24 January 2013 15:00:39 UTC-6, rochacbruno wrote: > > The web2py on PyPi should be a meta-package, in setup.py it should > download the latest version from website and include on users site-package. > --

[web2py] Re: web2py manual vs. screen size/res?

So you're saying that it is normal and correct for the page to need to be scrolled left and right to see everything even with the window maximized? Or should some portion of the page resize itself according to the available space? On Thursday, January 24, 2013 11:30:46 AM UTC-8, Niphlod wrote:

Re: [web2py] Re: error in alwaydata ?

I create web2py.fcgi file. http://wiki.alwaysdata.com/wiki/D%C3%A9ployer_une_application_web2py code chmod +x web2py/web2py.fcgi chmod: cannot acess 'web2py/web2py.fcgi' : no such file or directory #!/usr/bin/python import os, sys _PROJECT_DIR = os.path.dirname(os.path.dirname(os.path.abspath(

Re: [web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

Great to see this coming along ! Few questions: 1. Would it be moduralized enough to separate the redmine and web2py parts? 2. if not, can I use it on 2 servers, and then remove redmine in one and web2py on the other? 3. Does this supports older web2py versions (say, 1.8) ? 4. Can somebody port

Re: [web2py] update easy_install

On Thu, Jan 24, 2013 at 9:34 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > How? > http://peak.telecommunity.com/DevCenter/setuptools#automatic-script-creation --

Re: [web2py] Re: error in alwaydata ?

ready, but a get this error in my page samuel.alwaysdata.net/ Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, [no address given] and inform them of the time the error occurred, an

Re: [web2py] Re: new setup-web2py-nginx-uwsgi-ubuntu.sh

I will look at Niphold changes and update my script when I get time. I have no intention to port the w2p-redmine script to CentOS. I would not put redmine and web2py on 2 differents servers, I would put all the web app on one server (one html server) and the database on an other server. But that is

[web2py] Re: records as fields in a single form

Hi Alan, Thanks for your reply. the gluon.dal.Field objects contain the correct data: {{i=0}} {{for f in fields_list:}} {{=fields_list[i].name}} {{=fields_list[i].type}} {{=fields_list[i].default}} {{=fields_list[i].label}} {{i=i+1}} {{pass}} renders into: 17 boolean True hero-unit_tekst 18