Re: [web2py] Re: web2py Google Group

2015-05-28 Thread Gour
Ian Ryder writes: > Any chance of it being removed from history? You can remove it from web UI ('More message options actions'). Sincerely, Gour -- As the embodied soul continuously passes, in this body, from boyhood to youth to old age, the soul similarly passes into another body at deat

[web2py] Re: web2py Google Group

2015-05-28 Thread Ian Ryder
Hi, sorry - thought this was just to the group owner so wasn't supposed to be a general post, especially as it has my contact details in :) Any chance of it being removed from history? On Thursday, May 28, 2015 at 7:16:55 AM UTC+2, Ian Ryder wrote: > > Hi there > > I wonder if you could help - I

Re: [web2py] web2py 2.11.1 is OUT

2015-05-28 Thread Gour
Massimo Di Pierro writes: > web2py 2.11.1 is OUT. Heh, I pulled from the master yesterday and it was still alpha. :-) > Just in time for the DePy conference tomorrow. All the best promoting web2py!! Sincerely, Gour p.s. I notice that your signature contains: - https://code.google.com/p/web

[web2py] Re: _before_insert / update question

2015-05-28 Thread Ian Ryder
OK - I think I have the answer. I discovered it wasn't table-specific, it worked with this same method / table elsewhere in the app. The place it was failing was using bulk_insert. I changed to insert individually and all works fine. Bug? On Friday, May 29, 2015 at 6:39:56 AM UTC+2, Ian Ryder

[web2py] Re: _before_insert / update question

2015-05-28 Thread Ian Ryder
Hi, the key point is I'm not getting passed a dict, I'm getting passed a list. Here's a dump of what the _is_before handler gets passed: [(, datetime.datetime(2015, 5, 29, 6, 32, 27, 732420)), (, 1L), (, 8L), (, 2L), (, 5.0), (, 14093L), (, 'APPEAL'), (, 1L), (, 358001L), (, datetime.datetim

[web2py] web2py 2.11.1 is OUT

2015-05-28 Thread Massimo Di Pierro
web2py 2.11.1 is OUT. Just in time for the DePy conference tomorrow. It mostly contains small improvements and bug fixes, particularly in the DAL, including better Mongodb support. And more tests. Thanks to Niphlod, Giovanni, Paolo, Richard and all those who contributed. Massimo -- Resources:

[web2py] Strip Spaces

2015-05-28 Thread Jerry Liu
Hello, all I want to update all of records of a table. Basically, what I want to update is just a string Field. I want to strip all spaces out of that Field. I have tried: db(db.table.id > 0).update(field = db.table.field.strip()) But looks like Field object doesn't have a strip method. Any i

[web2py] Re: Q: Efficiently searching by tag / field widths

2015-05-28 Thread Paul Coy
Thanks for the reply. I can't find anything that looks like your reply so I think I'm going to try Example 29 from the Web2py site instead. It looks very similar to what I'm trying to accomplish. On Thursday, May 28, 2015 at 1:16:53 AM UTC-4, Paul Coy wrote: > > In the Web2Py Cookbook, Ch3 there

Re: [web2py] getting " [Errno 13] Permission denied" over and over

2015-05-28 Thread Gene
Encountered the same ticket on windows 8.1, web2py 2.9. 'Fixed' by uninstalling McAfee, no tickets thereafter. On Monday, September 15, 2014 at 11:22:15 PM UTC+8, Willoughby wrote: > > I'm late to this thread but one issue I always run into with web2py on > Windows (well, anything with SQLite) a

[web2py] Re: great system login

2015-05-28 Thread Joe Barnhart
+1 On Sunday, May 24, 2015 at 5:43:34 PM UTC-7, villas wrote: > > This looks like an excellent project. > Replace Janrain? > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] Re: Email invite users - peer review

2015-05-28 Thread James Burke
Sorry I probably should have posted this in the Developer group instead. Ron, this is a possible enhancement to the web2py framework itself, not a suggested application. On Friday, May 29, 2015 at 7:38:16 AM UTC+12, Ron Chatterjee wrote: > > I am little confused. Isn't what bitbucket does anyway

[web2py] Online Manual vs Pdf download - are they both 6th Edition?

2015-05-28 Thread greenpoise
Noticed the PDF one has 5th edition in it while the Online one says 6th Edition Pre Release. Is the content on both the same? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] Re: _before_insert / update question

2015-05-28 Thread Niphlod
the book shows how to print every argument passed to those functions I dunno how to make the book clearer :°°°D before_insert def this_is_before_insert(some_dict): if 'last_name' in some_dict: some_dict['last_name'] = 'altering' + some_dict['last_name'] db.auth_user._bef

Re: [web2py] Re: Multiple submit buttons using selectable in SQLFORM.grid

2015-05-28 Thread Ben Lawrence
Can you send a link to this? Here is solution I have used for action items( this_point is one action item record): ptform = SQLFORM(db.point,this_point, buttons=[TAG.button("Submit",_value=True,_type="submit",_name="no_followup",_class="btn btn-primary"),TAG.bu

[web2py] Re: Insert with where condition query web2py sqlite

2015-05-28 Thread Anthony
Inserts create new records, so there is no sense in which a "where" condition would apply. Perhaps instead you want to do an update to an existing record or set of records, in which case, see the .update() method of the Set class here: http://web2py.com/books/default/chapter/29/06/the-database-

[web2py] Re: smartgrid 'searchable' options

2015-05-28 Thread Ron Chatterjee
I guess we need to set the permission a layer above and then call the grid like massimo explained in his video. On Thursday, May 28, 2015 at 3:33:33 PM UTC-4, Ron Chatterjee wrote: > > On that note, can we specify "permission" to view, edit and/or delete. In > other words, only some people wil

[web2py] Re: Email invite users - peer review

2015-05-28 Thread Ron Chatterjee
I am little confused. Isn't what bitbucket does anyway. Someone can put their application there and invite others to join? How is this any different? On Thursday, May 28, 2015 at 9:50:31 AM UTC-4, Anthony wrote: > > I like the idea, but I wonder if the use case is common enough to justify > i

[web2py] Re: smartgrid 'searchable' options

2015-05-28 Thread Ron Chatterjee
On that note, can we specify "permission" to view, edit and/or delete. In other words, only some people will have access to delete (membership) but everyone can see. I can always put them on a table to do them separately but just asking if these can be done using grid as well. I don't see tha

[web2py] Re: web2py Google Group

2015-05-28 Thread Anthony
When you first posted, whichever moderator approved your post should have changed your permission from "moderated" to "allowed", but looks like that never happened (not even on subsequent posts). Your permission has now been changed, so future posts should appear instantly. Anthony On Thursday

[web2py] Re: _before_insert / update question

2015-05-28 Thread Ian Ryder
OK, think I've solved it. The documentation says a dict passed is into the _before_insert - seems it's a list of lists of [field, value]. I can manipulate the list and the result is what gets written. So perfect - I can do what I need, just I think the documentation needs checking (or I need c

[web2py] Re: _before_insert / update question

2015-05-28 Thread Ian Ryder
Thanks - I couldn't find any documentation / examples and my tests didn't seem to work as expected. Do you know of any examples anywhere I can scan over? I'll have another test in the mean time and update if I get it working On Thursday, May 28, 2015 at 12:02:52 PM UTC+2, Niphlod wrote: > > "mo

[web2py] file manager with private download area

2015-05-28 Thread Gour
Hello, I'm starting to learn Python and have need for, hopefully, not too complicated web app which should allow admin to upload multimedia files (mostly *.mp3 files) to the server and provide private download area for each user. I anticipate to have 10 - 20 active users at a time and it's very im

[web2py] Web2py on shared hosting.

2015-05-28 Thread Vinny Mautone
Hello everyone sorry but I am new to web2py, but I see very interesting, having a space of shared hosting OVH, let me know if you can use "web2py" hosting of this, I used the guide on the official website, but does not function. Could someone help me, thanks. P.S. This is a translation on-line

[web2py] Insert with where condition query web2py sqlite

2015-05-28 Thread Alessio Varalta
Hi i don't find on the guide the method to execute a query with where condition... i see db.class.insert but i don t find a method to use this with where condition or i use db.executesql("Insert into auth_user('person') values(4) where auth_user.id=38;") but i receive a error -- Reso

Re: [web2py] web2py Google Group

2015-05-28 Thread Philip Kilner
Hi Ian, On 26/05/15 07:19, Ian Ryder wrote: Is there anything I can do? It's generally holding back our use of web2py as we effectively don't have access to the community and we're building a pretty big application using it. If the web UI frustrates you, I can heartily recommend subscribing v

[web2py] Re: smartgrid 'searchable' options

2015-05-28 Thread Dave S
On Wednesday, May 27, 2015 at 10:16:59 PM UTC-7, Peter Gibson wrote: > > Hopefully a simple question... > > I have a smartgrid on a table which contains a lot of fields that are only > for internal use of the application and are of no direct interest/relevance > to the user. > > When I set sear

[web2py] Re: web2py Google Group

2015-05-28 Thread Dave S
On Wednesday, May 27, 2015 at 10:16:55 PM UTC-7, Ian Ryder wrote: > > Hi there > > I wonder if you could help - I've posted to the user group several times, > I think my last 2 posts have never been posted. Normally the ones that have > worked might take a day to arrive by which point they're d

[web2py] Re: Q: Efficiently searching by tag / field widths

2015-05-28 Thread Dave S
On Wednesday, May 27, 2015 at 10:16:53 PM UTC-7, Paul Coy wrote: > > In the Web2Py Cookbook, Ch3 there is a section called "Efficiently > searching by tag" which works quite well, thanks. I've been playing with it > and when I enter more than 16 characters to the data.value the data shows > up

[web2py] Re: Email invite users - peer review

2015-05-28 Thread Anthony
I like the idea, but I wonder if the use case is common enough to justify including in the framework (where it will have to be tested and maintained by the developers indefinitely). Instead, maybe this could be a plugin. Anthony On Thursday, May 28, 2015 at 1:19:07 AM UTC-4, Massimo Di Pierro w

[web2py] Re: question about onvalidation function

2015-05-28 Thread Anthony
No, in this case, the "c" field is neither readable nor writable, so it won't appear in forms (including readonly forms) or the grid unless explicitly added. The code in question calculates and inserts a value for "c" based on the values for "a" and "b", but this is not displayed anywhere. Anth

[web2py] Re: Object request isn't working

2015-05-28 Thread Anthony
Where are you running that code? On Thursday, May 28, 2015 at 1:16:59 AM UTC-4, Marlysson Silva wrote: > > People I'm trying to verify the host of user, and make this way: > > if request.env.server_name == '127.0.0.1': > > But the admin show me a error: > > if request.env.server_name == '127.0.0.1

[web2py] Re: Web2py adding additional and not wanted orderby

2015-05-28 Thread Anthony
On Thursday, May 28, 2015 at 6:33:25 AM UTC-4, Johann Spies wrote: > > > The problem with the abovementioned query is that it adds a lot of load to > the server as there are 130+ million records in the rresearch table and > about as much in the isi_alt_names table making the query very slow. >

Re: [web2py] Re: Web2py adding additional and not wanted orderby

2015-05-28 Thread Anthony
On Thursday, May 28, 2015 at 7:17:29 AM UTC-4, Johann Spies wrote: > > > > On 28 May 2015 at 12:42, Niphlod wrote: > > auto_pagination = False. >> > > When did this become part of Web2py? I do not find it in the Changelog. > It works in the latest version but no in 2.9.5. > Was originally disc

Re: [web2py] Re: Web2py adding additional and not wanted orderby

2015-05-28 Thread Anthony
On Thursday, May 28, 2015 at 6:53:58 AM UTC-4, Johann Spies wrote: > > > > On 28 May 2015 at 12:42, Niphlod wrote: > > auto_pagination = False. >> >> That being said, mind that without ordering, pagination is inherently >> incorrect >> >> > Thanks. Will that not respect my orderby = ~db.isi_alt

Re: [web2py] Re: Web2py adding additional and not wanted orderby

2015-05-28 Thread Johann Spies
On 28 May 2015 at 12:42, Niphlod wrote: auto_pagination = False. > When did this become part of Web2py? I do not find it in the Changelog. It works in the latest version but no in 2.9.5. Regards Johann -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github

[web2py] Re: Web2py adding additional and not wanted orderby

2015-05-28 Thread 黄祥
perhaps you can turn of the sortable in grid and just use orderby e.g. sortable=False best regards, stifan -- 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) -

Re: [web2py] Re: Web2py adding additional and not wanted orderby

2015-05-28 Thread Johann Spies
On 28 May 2015 at 12:42, Niphlod wrote: auto_pagination = False. > > That being said, mind that without ordering, pagination is inherently > incorrect > > Thanks. Will that not respect my orderby = ~db.isi_alt_names.code? I just do not want the extra ordering added. Maybe one can patch the cod

[web2py] what is the best approach to have auto generate document number or codification (e.g. product code)?

2015-05-28 Thread 黄祥
hi, what is the best approach to have auto generate document number or codification (e.g. product code) using web2py? what i've done right now is something like : *document numbercontrollers/purchase_transaction.py* if 'purchase_order' in request.function : # purchase_order_header id_max

[web2py] Re: Web2py adding additional and not wanted orderby

2015-05-28 Thread Niphlod
auto_pagination = False. That being said, mind that without ordering, pagination is inherently incorrect On Thursday, May 28, 2015 at 12:33:25 PM UTC+2, Johann Spies wrote: > > Apologies for the unfinished message. The Gmail interface in the browser > and I am not really friends. > > The prob

[web2py] Re: Insert record in foreign DB

2015-05-28 Thread Gael Princivalle
Thanks Niphlod, it resolve the error. Il giorno lunedì 25 maggio 2015 17:40:08 UTC+2, Niphlod ha scritto: > > just define it with migrate=False and web2py won't issue any ddl statement. > > On Monday, May 25, 2015 at 2:21:21 PM UTC+2, Gael Princivalle wrote: >> >> Hello all. >> >> I use a PHP open

[web2py] Re: Web2py adding additional and not wanted orderby

2015-05-28 Thread Johann Spies
Apologies for the unfinished message. The Gmail interface in the browser and I am not really friends. The problem with the abovementioned query is that it adds a lot of load to the server as there are 130+ million records in the rresearch table and about as much in the isi_alt_names table making

[web2py] Web2py adding additional and not wanted orderby

2015-05-28 Thread Johann Spies
The following code: query = ((db.rresearch.id == db.isi_alt_names.rsc_id)& (db.rresearch.nu.upper().like(request.vars.country + '%'))) data = SQLFORM.grid(query, searchable = False, links = links, fields = fields, editable = False, deletable = False, det

[web2py] Re: _before_insert / update question

2015-05-28 Thread Niphlod
"modify data on a record before it's inserted/updated" _before_insert and _before_update take your "near to be committed record" and alter it in memory, then it inserts/update it. Don't know what are you asking for that is different from what web2py does. -- Resources: - http://web2py.com -

[web2py] Re: admin static files fail to load after web2py upgrade

2015-05-28 Thread Niphlod
nearly 2 years later, you should update your webserver config. check http://web2py.com/books/default/chapter/29/04/the-core#Static-asset-management On Thursday, May 28, 2015 at 7:16:55 AM UTC+2, Juozas Masiulis wrote: > > I've upgraded web2py to version 2.9.12-stable+timestamp.2015.01.17.06.11.0

[web2py] Re: Datetime fields in 2.11.0 Alpha

2015-05-28 Thread Niphlod
can you check your translation of the string %Y-%m-%d %H:%M:%S ? On Thursday, May 28, 2015 at 7:16:53 AM UTC+2, Donald McClymont wrote: > > I am getting an error on form validation of a datetime field with latest > version. Error is must be -MM-DD HH:MM::SS! Note there are two > colons betw

[web2py] Re: mail.send() feature in web2py for bounced email/ email address that doesnt exist

2015-05-28 Thread Niphlod
if the smtp from gmail shows that the email has been sent, there's nothing web2py can do. you can specify a bounce address and check it at a later time to see if the mail has been correctly delivered, but there's no way around it . On Thursday, May 28, 2015 at 7:16:55 AM UTC+2, Lasya Venneti wro

[web2py] Re: Bug in scheduler.py ?

2015-05-28 Thread Niphlod
nope, it's the same as default=datetime.datetime() . if default is callable, each time the function gets called, hence a new uuid is created. If instead is the result of a function, it's the same result of the same initiated instance. On Thursday, May 28, 2015 at 7:16:59 AM UTC+2, Christophe Me

[web2py] Re: Object request isn't working

2015-05-28 Thread Jose C
> > > But the admin show me a error: > > if request.env.server_name == '127.0.0.1': > NameError: name 'request' is not defined > > > Are you perhaps using python 3? (Type `python --version` at the command to check) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Database

2015-05-28 Thread Jose C
You can only see and use tables and fields you define in a model file, see > the web2py book for details. > Specifically the Legacy database section: http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer?search=legacy#markmin_LegacyDatabases Pay special attention to

[web2py] Re: ProgrammingError: column "worker_stats__tmp" is of type json but expression is of type text

2015-05-28 Thread Jose C
Please drop the scheduler_worker table from the database and remove the > file *_scheduler_worker.table from the databases/ folder of your > application, then set migrate to True (a single request with migrate=True > will suffice). The table will be recreated properly and the error will go >

[web2py] Re: question about onvalidation function

2015-05-28 Thread 黄祥
not sure if not viewing your code but i guess, you didn't explicit print the variable c on the views. best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (R

[web2py] Re: on_define in dummy table

2015-05-28 Thread 黄祥
yes, on_define is not work when it comes to dummy tables, thank you best regards, stifan -- 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 thi

[web2py] Re: Problem in SQLFORM.factory with foreignkeys in multiple tables

2015-05-28 Thread 黄祥
had you tried to put the fields in sqlform.factory? or at least create dummy tables? e.g. dummy tables detail_0 = db.Table(db, 'detail_0', Field('product', 'reference product', label = T('123') ) ) ref: http://web2py.com/books/default/chapter/29/07/forms-and-validators#SQLFORM-factory best

[web2py] Re: smartgrid constraints not working on the linked table

2015-05-28 Thread 黄祥
please try *not tested* def dog(): query = (db.dog.owner == auth.user_id) grid = SQLFORM.smartgrid(db.dog, constraints = dict(dog = query) ) return locals() best regards, stifan -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web

[web2py] Re: Email invite users - peer review

2015-05-28 Thread James Burke
Will do. Thank you for your feedback. On Thursday, May 28, 2015 at 5:19:07 PM UTC+12, Massimo Di Pierro wrote: > > think this is an excellent idea. Please submit a pull request. > > On Wednesday, 20 May 2015 03:12:24 UTC-5, James Burke wrote: >> >> Hi, >> >> I'm looking for a peer review of some c

Re: [web2py] Specifying which fields are searchable with Smartgrid

2015-05-28 Thread Johann Spies
Try: search_options = [] #see gluon/sqlhtml. where it is defined as search_options = search_options or { 'string': ['=', '!=', '<', '>', '<=', '>=', 'starts with', 'contains', 'in', 'not in'], 'text': ['=', '!=', '<', '>', '<=', '>=', 'starts with', 'contains', 'in

Re: [web2py] Reportlab, Platypus and tables

2015-05-28 Thread Johann Spies
Sorry I ommitted one import: import os -- 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

Re: [web2py] Reportlab, Platypus and tables

2015-05-28 Thread Johann Spies
On 28 May 2015 at 07:40, Jason (spot) Brower wrote: > Pdf reporting can take a lot of work. Is this for a single page report or > many pages. How are formated? And do you have an examole report in pdf > format? > > I have used it once and it works. Here is the code as example: In the controller

Re: [web2py] wsgi / apache error

2015-05-28 Thread Johann Spies
Thanks Marko and Niphlod. I do not think it is a permissions problem in the app somewhere. I did not have a cache/ directory but then I do not use cache.disk. The issue Niphlod refers to seems to be related. I could see no solution there though :( My problem is not (as suggested in some messa

[web2py] Re: Extra field in the register form

2015-05-28 Thread Martin Weissenboeck
Thank you. But this adds extra fields to the table. I am look for a way to extend only the registration form and to check the input with an onvalidation function. 2015-05-28 7:33 GMT+02:00 Massimo Di Pierro : > To add fields to auth forms you have to use > > auth.settings.extra_fields['auth_user