[web2py] Re: how to include "created_on" within table definition?

2016-01-24 Thread Alex Glaros
thanks, Niphlod it works now. maybe the first time I created without the datetime attribute confused PostGres. Then when I added datetime, it kept saying it was a string and no auto-calendar popped up. I deleted the physical table and the re-created one is fine. thanks, Alex --

[web2py] loging web2py

2016-01-24 Thread eric cuver
Hello everybody, I need to know how I can do to avoid that users must loging to each time for using an application. i would like the user login only one time after he can connect to the application without login each time. Thank you -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] how to include "created_on" within table definition?

2016-01-24 Thread Alex Glaros
is there syntax for including the "created_on" field within a table definition? I need to define a label for "created_on" like this: db.VerifiedConnection.created_on.label = 'Date invited' this works outside of the define_table area. Is there a way to include it inside the define_table area

[web2py] Re: compute and after_insert callback on table

2016-01-24 Thread Niphlod
I think the main point is that for a computed field you need to pass fields which happens to be the factors of the calculation: how can pydal compute the value if you don't pass the actual values are needed to compute ??? that being said, if you are using database callbacks you can just use

[web2py] Re: how to include "created_on" within table definition?

2016-01-24 Thread Niphlod
Field('created_on', 'datetime', label='date invited') is absolutely the correct way to do it. What's the error that comes up ? On Sunday, January 24, 2016 at 9:23:24 AM UTC+1, Alex Glaros wrote: > > is there syntax for including the "created_on" field within a table > definition? > > I need to

[web2py] Re: loging web2py

2016-01-24 Thread eric cuver
I think I misspoke I would extend the length of sessions. As facebook or gmail if we are not disconnected we are connected all the time Le dimanche 24 janvier 2016 20:11:55 UTC+1, Massimo Di Pierro a écrit : > > What do you mean "login each time". After the first login, the system > remembers

[web2py] FOREIGN KEY constraint failed error when "Click to delete" user account

2016-01-24 Thread Yi Liu
Dear fellow w2p users, First, thank you so much for providing this great app Web2Py for *free*. Recently I updated my app to allow user to delete account themselves. auth.settings.allow_delete_accounts= True Today, I received feedback from user that that function is broken on my site. Then

[web2py] Re: saving multiple forms in a dict and giving them out in the view

2016-01-24 Thread Dave S
On Sunday, January 24, 2016 at 10:08:48 AM UTC-8, Lucas Schreiber wrote: > > Hey, > i would like to save some values in a dict and give them out together with > a form. it should look something like this: > ([] marks a button, the name n are the values, and links) > > name1 [Remove?] > name2

[web2py] Re: web2py on AWS

2016-01-24 Thread Dave S
On Saturday, January 23, 2016 at 12:58:25 PM UTC-8, Mark Graves wrote: > > Re reading your answer, > > check the access logs. > > See if rocket is getting overwhelmed by robots or other spam traffic. > I'm not expecting that to be the case, but I will check. > > consider installing ip tables

[web2py] Re: web2py on AWS

2016-01-24 Thread Dave S
On Saturday, January 23, 2016 at 12:56:49 PM UTC-8, Mark Graves wrote: > > Hey Dave, > > Any reason why you are choosing to use the rocket server and manual > install? > Familiarity. And the recipe for manual install is: 1. Download web2py. 2. Unzip. 3. Tell python to run web2py. > >

Re: [web2py] Re: web2py on AWS

2016-01-24 Thread Mark Graves
Can you do ps -aux and see whether you can see rocket listening on port 80? -Mark On Mon, Jan 25, 2016 at 12:44 AM, Dave S wrote: > > > On Saturday, January 23, 2016 at 12:58:25 PM UTC-8, Mark Graves wrote: >> >> Re reading your answer, >> >> check the access logs. >> >>

[web2py] Cart module for web2py.

2016-01-24 Thread Marcelo Theodoro
I've just started to work on a cart module for web2py. It's not higly tested and It's not in production yet. But I'll be working on this modules for the next days. Any kind of suggestion or help would be appreciated. https://github.com/Marcelo-Theodoro/web2py_cart -- Resources: -

[web2py] Re: Print all items from inner join while grouping them

2016-01-24 Thread 'DenesL' via web2py-users
Hi Hermann You can add an inner loop to each user found by the original code: for row in db(db.person.id==db.thing.owner_id).select(db.person.id, db. person.name, count, groupby=db.person.name): print row.person.name, row[count] for t in

Re: [web2py] Re: download csv and excel file in zip

2016-01-24 Thread Vid Ogris
I write to sheet with xls_dat = xlwt.Workbook(encoding='utf-8') sheet = xls_dat.add_sheet('sheet 1', cell_overwrite_ok = True) for i,rec in enumerate(workers): sheet.write(i + 1, 0, rec, style1) for a, rr in enumerate(dates): sheet.write(0, a+1, rr,

[web2py] Re: Print all items from inner join while grouping them

2016-01-24 Thread Hermann Tchehoun
Thanks Denes, it's ok ! > > > -- 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] User Autentication App engine

2016-01-24 Thread Charles tenorio
authentication does not work in Google App engine, can not create new User -- 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

[web2py] Re: export data to OOO and Excel

2016-01-24 Thread Yebach
Is it possible to stram the file without creating a temp file and how can I zip it (without temp file) On Wednesday, July 1, 2015 at 4:45:36 PM UTC+2, Massimo Di Pierro wrote: > > i like handsontable. It displays data like excel and allows cut > to/from excel. It has a select all button > > On

[web2py] Re: how to programatically create virtual fields in aliased table

2016-01-24 Thread 'DenesL' via web2py-users
Iif you want virtual fields to show up in a query over a single table they have to be defined in that table, otherwise you need to join a table where they exist. The definition of a virtual field needs a name and usually a lambda function over fields in a row. Lets add a virtual field to the

[web2py] Re: User Autentication App engine

2016-01-24 Thread Massimo Di Pierro
Which web2py version? datastore of mysql? On Sunday, 24 January 2016 09:15:01 UTC-6, Charles tenorio wrote: > > authentication does not work in Google App engine, can not create new User > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: loging web2py

2016-01-24 Thread Massimo Di Pierro
What do you mean "login each time". After the first login, the system remembers you until the session expires. Is this not working for you? What do you experience? On Sunday, 24 January 2016 03:31:26 UTC-6, eric cuver wrote: > > Hello everybody, > I need to know how I can do to avoid that

[web2py] Re: export data to OOO and Excel

2016-01-24 Thread Massimo Di Pierro
Can you tell us more. What do you want to zip? uploads/downloads should be automatically gzipped by browser. On Sunday, 24 January 2016 11:27:39 UTC-6, Yebach wrote: > > Is it possible to stram the file without creating a temp file and how can > I zip it (without temp file) > > On Wednesday,

[web2py] saving multiple forms in a dict and giving them out in the view

2016-01-24 Thread Lucas Schreiber
Hey, i would like to save some values in a dict and give them out together with a form. it should look something like this: ([] marks a button, the name n are the values, and links) name1 [Remove?] name2 [Remove?] name3 [Remove?] . . . name n [Remove?] my idea looks like this: [code]

[web2py] Re: gstreamer embedded in web2py

2016-01-24 Thread Massimo Di Pierro
Via HTTP/HTTPS you can upload files up to 2GB (web2py supports this). You can stream them but you need to know the size in advance. Here is a web2py app that detects motion from your webcam, makes short videos, and uploads them to web2py. If you need some actual streaming, you have to do it

Re: [web2py] Re: Enabling Google Sign-In

2016-01-24 Thread Massimo Di Pierro
from gluon.storage import Storage On Thursday, 21 January 2016 08:42:47 UTC-6, dirman wrote: > > hi > am getting global name 'Storage' is not > defined > when using Storage(json.load(f)['web']) > > > > On Thursday, October 22, 2015 at 11:27:35 AM UTC, mcm wrote: >> >> >>

[web2py] Re: Cart module for web2py.

2016-01-24 Thread Massimo Di Pierro
perhaps this is useful, has a cart: http://experts4solutions.com/estore3 https://github.com/mdipierro/estore3 On Sunday, 24 January 2016 10:16:19 UTC-6, Marcelo Theodoro wrote: > > I've just started to work on a cart module for web2py. It's not higly > tested and It's not in production yet.

[web2py] Re: compute and after_insert callback on table

2016-01-24 Thread Anthony
Are you showing your exact code, because the particular error reported will only appear if the computed field is required, and you have not set the total_square_meter field to be required? Anthony On Saturday, January 23, 2016 at 9:31:18 PM UTC-5, 黄祥 wrote: > > still face the same error : >

[web2py] Re: compute and after_insert callback on table

2016-01-24 Thread 黄祥
my exact code : def on_define_default_size(table): # compute #table.total_square_meter.compute = lambda r: (float(r['length_in_cm'] ) * float(r['width_in_cm'] ) ) / 1 # label table.name.label = T('Name') table.length_in_cm.label = T('Length in Cm') table.width_in_cm.label = T('Width in Cm')