[web2py] Is it a good idea to convert a jhomla website to web2py app for WHMCS integration?

2015-05-27 Thread at
Hi, I've been asked to integrate WHMCS with a jhomla website. The website currently consists of just a few pages of information on the business, its services, products, clients and feedback/contact form. My most of the recent work experience is on python & web2py and I am intermediate-level de

[web2py] Re: project hire

2015-05-27 Thread rāma
Looking for something like this too On Sunday, 15 March 2015 22:34:06 UTC+8, pumplerod wrote: > > The web2py support page lists experts4solutions as a group to inquire > about consulting or development, however, their home page has no method of > contact? My coding chops are really just good en

[web2py] wsgi / apache error

2015-05-27 Thread Johann Spies
Most parts of the app work on our server running apache2.4 and wsgi but on after a query which takes some time I get this in the apache error log and 504 Gateway Timeout on my browser: [Wed May 27 14:20:46.617759 2015] [wsgi:error] [pid 18286:tid 140225013630720] [remote x.x.x.x:10678] mod_wsgi (p

[web2py] MARKMIN problem with email addresses

2015-05-27 Thread David Manns
Using MARKMIN helper, if the string includes something like "... text some...@somewhere.com. Another sentence ..." the period following the email address is incorrectly included in the email link. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/we

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

2015-05-27 Thread Jose C
Greetings, My postgresql server was upgraded from 9.1 to 9.3. Web2py now crashes on startup with this error code: Traceback (most recent call last): File "/home/jose/python-environments/silves/web2py/gluon/restricted.py", line 227, in restricted exec ccode in environment File "/home/j

[web2py] Re: var names in vars

2015-05-27 Thread Alex Glaros
So the data is generated and captured in vars correctly {{=A('Delete whole meeting group', _href=URL('default','delete_object', args=specificMeetingGroup.superObjectID, vars= dict(displayHeader=specificMeetingGroup.meetingGroupTitle, objectCreatedBy=specificMeetingGro

Re: [web2py] wsgi / apache error

2015-05-27 Thread Marco Mansilla
El Wed, 27 May 2015 14:37:43 +0200 Johann Spies escribió: > Most parts of the app work on our server running apache2.4 and wsgi > but on after a query which takes some time I get this in the apache > error log and 504 Gateway Timeout on my browser: > > [Wed May 27 14:20:46.617759 2015] [wsgi:err

[web2py] Re: Robots.txt paramete router

2015-05-27 Thread Jose C
On Thursday, 21 May 2015 19:58:53 UTC+1, Ruud Schroen wrote: > > Hi, > > I'm using a parameter based router like this: > > routers = dict( >> >> >>> # base router >> >> BASE=dict( >> >> default_application='welcome', >> >> default_controller = "default", >> >> defa

[web2py] synchronizning databases

2015-05-27 Thread Dave S
I've done a quick scan of the archives about "synchronizing databases", but there seem to have been few posts on it since https://groups.google.com/d/msg/web2py/myTf5eedMc8/6xLmScVVH48J> in 2011. And that post, referencing http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction

[web2py] how to put a controller name in a var if later want to execute the the controller name

2015-05-27 Thread Alex Glaros
is there a trick to putting a controller name in a var so that it can be executed? let's say "list_people_and_thier_dogs" is a controller name I put the the string "list_people_and_thier_dogs" in var "name_of_contoller" then when code redirect(URL(name_of_contoller)) I get None as name_of_c

[web2py] Re: how to put a controller name in a var if later want to execute the the controller name

2015-05-27 Thread Anthony
Please show some code. On Wednesday, May 27, 2015 at 3:07:50 PM UTC-4, Alex Glaros wrote: > > is there a trick to putting a controller name in a var so that it can be > executed? > > let's say "list_people_and_thier_dogs" is a controller name > > I put the the string "list_people_and_thier_dogs"

[web2py] Re: how to put a controller name in a var if later want to execute the the controller name

2015-05-27 Thread Alex Glaros
I'm trying to pass controller name and var name to vars you can follow one of the vars in yellow highlight cancel_1A = request.get_vars.NAME_of_var_1_to_return_if_CANCEL cancel_1B = request.get_vars.var_1_to_return_if_cancel form = FORM.confirm('Are you sure?',{'Cancel and go back':

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

2015-05-27 Thread Niphlod
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 away. The

Re: [web2py] wsgi / apache error

2015-05-27 Thread Niphlod
I suspect instead it's due to https://code.google.com/p/modwsgi/issues/detail?id=29&can=1 for reference (i.e. even if I don't think it's the issue at hand) web2py just needs to write: - to the cache/ folder (if you're using cache.disk) - the session/ folder (if you're using the default file-sto

[web2py] Re: how to put a controller name in a var if later want to execute the the controller name

2015-05-27 Thread Derek
cancel_1A=cancel_1B, cancel_2A=cancel_2B))}) uh, you aren't setting 'specificMeetingGroup.id' equal to 10 by doing that, you know... you're setting cancel_1A and your FORM is called without anything assigned to cancel_1B or cancel_2B. On Wednesday, May 27, 2015 at 12:46:58 PM UTC-7, Alex Glaros

[web2py] Re: how to put a controller name in a var if later want to execute the the controller name

2015-05-27 Thread Niphlod
a simple example can be better than a thousand words >>> a = 'hello' >>> b = 'world' >>> example = dict(a=a, b=b) >>> print example {'a': 'hello', 'b': 'world'} >>> example2 = {a : a, b : b} >>> print example2 {'world': 'world', 'hello': 'hello'} >>> -- Resources: - http://web2py.com - http:

[web2py] Re: how to put a controller name in a var if later want to execute the the controller name

2015-05-27 Thread Alex Glaros
you're right Derek so how would have the end result be vars(dict(specificMeetingGroupID=10)) thanks, Alex -- 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) -

[web2py] Structure of compiled apps

2015-05-27 Thread Scott Hunter
When an app gets compiled, each function in each controller that takes no arguments (i.e. has an exposed URL) is represented by a .pyc file. But where do the controller functions that do not correspond to exposed URLs go? - Scott -- Resources: - http://web2py.com - http://web2py.com/book (Doc

[web2py] Re: how to put a controller name in a var if later want to execute the the controller name

2015-05-27 Thread Derek
varsdict = dict() varsdict[cancel_1a]=cancel_1b vars=varsdict something like that. On Wednesday, May 27, 2015 at 1:15:56 PM UTC-7, Alex Glaros wrote: > > you're right Derek > > so how would have the end result be > > vars(dict(specificMeetingGroupID=10)) > > thanks, > > Alex > -- Resources:

[web2py] Re: synchronizning databases

2015-05-27 Thread Dan Feeney
My experience with replication is primarily with Oracle in a non-web2py environment. Oracle's Multi-Master Replication has a ton of parameters that let you customize the replication window, but my systems are configured for a 5 minute delay target, but the databases are rarely out of sync more t

[web2py] Re: synchronizning databases

2015-05-27 Thread Dave S
On Wednesday, May 27, 2015 at 2:37:28 PM UTC-7, Dan Feeney wrote: > But TL;DR: Oracle Multi-Master Replication, once you get through the > complexities of setting up the replication process itself, would have no > problem running the setup you described. But it'd be more like using a 7 > to

[web2py] Re: how to put a controller name in a var if later want to execute the the controller name

2015-05-27 Thread Alex Glaros
correct data now appears for first var, but what is syntax for two vars in dictionary? E.g., varsdict[cancel_1a]=cancel_1b* + varsdict[cancel_2a]=cancel_2b* I've tried looking it up and every possible combination -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - htt

[web2py] Re: how to put a controller name in a var if later want to execute the the controller name

2015-05-27 Thread Dave S
On Wednesday, May 27, 2015 at 3:39:33 PM UTC-7, Alex Glaros wrote: > > correct data now appears for first var, but what is syntax for two vars in > dictionary? > > E.g., varsdict[cancel_1a]=cancel_1b* + varsdict[cancel_2a]=cancel_2b* > > I've tried looking it up and every possible combination >

[web2py] Re: how to put a controller name in a var if later want to execute the the controller name

2015-05-27 Thread Alex Glaros
no Dave, I didn't try the '+' sign; was just to describe intent thanks Dave and Niphlod for the lesson code works great! Alex -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/lis

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

2015-05-27 Thread Paul Coy
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 as 15 characters followed by "...". this happens with the results "rows" al

[web2py] Object request isn't working

2015-05-27 Thread Marlysson Silva
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': NameError: name 'request' is not defined Theoretically was to working,What I'm making of the wrong? -- Resource

[web2py] GAE list:integer fields on v2.10.4 and beyond

2015-05-27 Thread Donald McClymont
I am having major problems using Google App Engine with v2.10.4 as I use a number of list integer types field types. It seems the only way to get zero to be stored as a value on a list integer field is to send it as a character string eg ['0','0','0'] - surely it should be possible to send

[web2py] Specifying which fields are searchable with Smartgrid

2015-05-27 Thread Peter Gibson
The default search widget gives option to search on every field on the table. How do I restrict it to just a couple of fields (title, description). -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.c

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

2015-05-27 Thread Fabian Haeger
Hello there, I am getting despair on this problem after 6 hours now and I hope I can get some help here. After creating 3 models of a legacy database, and adding a SQLFORM in my controller, I'm always getting the error message (1452, u'Cannot add or update a child row: a foreign key constrain

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

2015-05-27 Thread Lasya Venneti
So I made a small app that sends emails from web2py, connected to the gmail smtp server. The problem here is that it always gives me a success message! Even when the email-id is invalid. I have tested the bounce back feature of gmail by sending mails from gmail to invalid email ids to which gmai

[web2py] smartgrid 'searchable' options

2015-05-27 Thread Peter Gibson
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 searchable=True in the smartgrid then it allows searching on all these fields which is n

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

2015-05-27 Thread Juozas Masiulis
I've upgraded web2py to version 2.9.12-stable+timestamp.2015.01.17.06.11.03 via web interface. Now, when I go to any admin page it looks broken, because it fails to load any static files. It tries to load the files from the wrong path, for example it tries to load jquery from https://mydomain.c

[web2py] Datetime fields in 2.11.0 Alpha

2015-05-27 Thread Donald McClymont
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 between MM and SS which I am assuming is part of the problem - but I can't readily see how to fix it. Regards Donald -- Resources: - http://web2

[web2py] Reportlab, Platypus and tables

2015-05-27 Thread Felix Penetrante
I have just started using Reportlab for my app's pdf report needs and I can't find examples on how to control the table appearance (i.e. border, alignment, color, etc). I already scoured through the web2py's documentation but it has a minimal example and is of no help on my table needs. Is th

[web2py] issues loading sessions

2015-05-27 Thread Wim Fournier
I'm having regular issues with the loading of sessions. Sometimes this happens after restarting the webserver, sometimes in the middle of a session. I would see errors like; Traceback (most recent call last): File "/var/web/xxx/web2py-2.10/gluon/main.py", line 484, in wsgibase session._tr

[web2py] Bug in scheduler.py ?

2015-05-27 Thread Meessen Christophe
Hello, I recently encounter a problem when trying to serialize the model including the scheduler tables. The default value of the uuid field in the scheduler_task table is set to the function web2py_uuid. Shouldn't it be the value returned by web2py_uuid and thus web2py_uuid() ? -- Resource

[web2py] Re: question about onvalidation function

2015-05-27 Thread chaitanya
Hi Iam very new to web2py. According to my understanding, if the c value is greater than zero the c value has to be displayed. I used the same code as yours but I did not see the c value printed. Can you please clarify if Iam understanding it wrong. On Friday, December 23, 2011 at 3:13:04 PM UTC-

[web2py] smartgrid constraints not working on the linked table

2015-05-27 Thread icodk
Hold your hat:-) I have an SQLFORM.smartgrid with 'dog' as the main table and 'puppy' as the linked_table that has a reference to the 'dog' table. This will add an extra columne with a link 'puppy' on each dog row in the the dog grid. Clicking on that link will show a new grid containing rows wi

[web2py] Re: PostgreSQL connection hangs on insert

2015-05-27 Thread Bilal Hasan
Thing is, when I check any processes with open connections, the database connection is idle. Even if I stop the server, the connection process is still there until I kill the process manually. Not sure where it's hanging. I'm using other databases on the same machine with PostgreSQL which have

[web2py] Initialise a list integer field with zeros on GAE with 2.10.4

2015-05-27 Thread Donald McClymont
It seems the following field definition in a model file doesn't currently work with GAE - however it is fine on SQLite? Field('questcounts','list:integer',default=[0, 0, 0, 0, 0], I think I can work around it by sticking an extra element that I don't use at the end and giving it a value. Fie

Re: [web2py] return locals()

2015-05-27 Thread Felix Penetrante
Thanks for this post. Now I know how to secure views. -- 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 subscribe

[web2py] SQLFORM.smartgrid with linked_table and constraints ot working 100%

2015-05-27 Thread icodk
Hold your hat:-) I have an SQLFORM.smartgrid with 'dog' as the main table and 'puppy' as the linked_table that has a reference to the 'dog' table. This will add an extra communal with a link 'puppy' on each dog row of the main table. Clicking on that link will show a grid containing rows with on

[web2py] _before_insert / update question

2015-05-27 Thread Ian Ryder
Hi, I'd like to modify the data on a record before it is inserted / updated. I was hoping I could do this with _before_insert / update but I don't think it's possible. As an example from a previous life, in Salesforce on a before trigger you can change field values in memory on the way into the

[web2py] Database

2015-05-27 Thread Dan Hett
When I connect to an existing database, do I need to define the tables in DB.py? -- 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 messag

[web2py] web2py Google Group

2015-05-27 Thread Ian Ryder
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 down the list - the upshot is I avoid using the list. Assuming it's not something

[web2py] Re: Email invite users - peer review

2015-05-27 Thread Massimo Di Pierro
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 code I put together for email > inviting users to join an application. I couldn't find anything suitable > looking around,

[web2py] Re: on_define in dummy table

2015-05-27 Thread Massimo Di Pierro
I do not think on_define is ever called in this case. On Thursday, 21 May 2015 10:14:15 UTC-5, 黄祥 wrote: > > hi, > > i want to create table inheritance using dummy table (from web2py book), > but when i try to mix it with on_define, the result is not expected (no > errors occured) > e.g. > *not

[web2py] Re: Recommended strategy for passing complex query parameters to a REST API

2015-05-27 Thread Massimo Di Pierro
I assume what you mean by rest principles is that you want to do a GET and not a POST. Problem is some browsers (for example IE) have limits on the size of the path_info in GET methods. So if you do not care about that you can do .../api/available_resources?query={...} where query here is a u

[web2py] Re: Multiple apps with different DB and auth on same web2py

2015-05-27 Thread Massimo Di Pierro
You must have routes or some wrong redirection in one of the apps. On Saturday, 23 May 2015 12:32:02 UTC-5, Saifuddin Rangwala wrote: > > Hi, > > I have got 2 apps on my web2py. Both the apps are different and > having their own separate database and users. > > In this situati

[web2py] Re: great system login

2015-05-27 Thread Massimo Di Pierro
+1 On Sunday, 24 May 2015 19:43:34 UTC-5, 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 (Repo

[web2py] Re: Extra field in the register form

2015-05-27 Thread Massimo Di Pierro
To add fields to auth forms you have to use auth.settings.extra_fields['auth_user'] = [ Field(...), Field(...) ] On Monday, 25 May 2015 03:09:10 UTC-5, mweissen wrote: > > I want to have an extra field in the register form but not in the > auth_user table. > There has been some threads about

[web2py] Re: tornado 403 with websocket messaging

2015-05-27 Thread Massimo Di Pierro
Can you submit a pull request? On Monday, 25 May 2015 11:54:35 UTC-5, Serbitar wrote: > > > > to fix this: > > > http://stackoverflow.com/questions/24851207/tornado-403-get-warning-when-opening-websocket > > with current web2py and tornado 4+ > > you have to modify: gluon/contrib/websocket_messa

[web2py] Re: GAE SDK: Getting ImportError for gluon.contrib.populate import populate

2015-05-27 Thread Massimo Di Pierro
There is this line in app.yaml: skip_files: (contrib/(populate|taskbar_widget)\.py)| by default we do not deploy populate on GAE because of its size. remove that line. On Thursday, 29 September 2011 04:52:16 UTC-5, glomde wrote: > > Hi, > > I am trying to use GAE but I get import error

Re: [web2py] Reportlab, Platypus and tables

2015-05-27 Thread Jason (spot) Brower
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? On Thu, May 28, 2015, 08:16 Felix Penetrante wrote: > I have just started using Reportlab for my app's pdf report needs and I > can't find exam

[web2py] Database

2015-05-27 Thread Nico de Groot
Hello Dan, You can only see and use tables and fields you define in a model file, see the web2py book for details. Nico de Groot -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/li