Re: [web2py] Re: how to create pdf report in web2py???

2016-05-19 Thread prashant joshi
how to download appreport_plugin ..??? this show in video On Thu, May 19, 2016 at 10:51 AM, prashant joshi wrote: > https://vimeo.com/18601633 > according to this video i have already done shown in this video after > adding appreport plugins i,m getting error: > Cannot import module > 'ap

Re: [web2py] Re: how to create pdf report in web2py???

2016-05-19 Thread prashant joshi
https://github.com/lucasdavila/web2py-appreport/wiki also download from it will be not work Cannot import module 'applications.bbb.modules.modules' this error show again On Thu, May 19, 2016 at 2:59 PM, prashant joshi wrote: > how to download appreport_plugin ..??? this show in video > >

[web2py] Re: How can I make a calculation in the view?

2016-05-19 Thread Anthony
Though generally it is good to minimize the logic in views, as the are more difficult to read, test, and debug. So, prefer moving such calculations to the controller, or at least to a function that is simply called from the view. Anthony -- Resources: - http://web2py.com - http://web2py.com/bo

[web2py] info: bootstrap3 compact form

2016-05-19 Thread Mirek Zvolský
For me was problem with formstyle=bootstrap3_inline that each field is to much high: just first 5-7 items (from lets say ~20 form fields) were visible on the standard monitor. Now I use this as clone of the inline style: Problem is the movement of the label (with control-label css class) to muc

[web2py] Re: st_dwithin

2016-05-19 Thread Pierre
Hi DenesL, I didn't test *st_dwithin* with use_spheroid because I changed my "strategy" to use geometry fields instead of geography's for GIS calculations. The function I really miss and am willing to test is *st_transform ( st_interpolate* could be good too*)*. So far I did some calculati

[web2py] Re: unique=True not working

2016-05-19 Thread Pierre
thanks, I did a *db.table.drop()* and by magic a unique key constraint appeared in *pgAdmin* I use *postgresql* but problem exists in* sqlite *as well -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google

[web2py] stuck up on Deployment on CentOS 6.7

2016-05-19 Thread Rahul
Hi All, I have root access for the VPS server which is on centOS6.7 I have installed web2py in /home/www/ directory and Apache2 is by default installed in /usr/local/apache2. Now accessing my website shows me the Apache welcome screen which says - You may now add content to the directory

[web2py] create dummy users programmatically

2016-05-19 Thread Pierre
for testing purposes: creation works but dummy users cannot login. There seems to be a password problem (not encrypted) how do I encrypt dummy passwords in a *db.auth_user.insert* instruction ? my dummy users are complaining a lot about this : They all want to become *unique* and *real*:))

[web2py] parse

2016-05-19 Thread Pierre
Hi, I have a variable *r = request.post_vars *of the form* { 'a':1, 'b':2, 'ab': { 'aba':10 , 'abb':20 } }* it's a gluon.storage.Storage object. how do I extract *r['ab']?* this doesn't work : *r.pop('ab',None) , r.ab , r['ab']['aba'] , r.ab.aba* -- Resources: - http://web2py.com

[web2py] parse

2016-05-19 Thread Anthony
Are you sure you have the structure correct? How is it populated, and what do you get when you print it? -- 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] create dummy users programmatically

2016-05-19 Thread Richard Vézina
Use dedicated web2py function auth.register_bare() for instance... Look at test case here : https://github.com/web2py/web2py/blob/master/gluon/tests/test_tools.py#L647 Richard On Thu, May 19, 2016 at 9:34 AM, Pierre wrote: > for testing purposes: > > creation works but dummy users cannot login.

[web2py] Re: parse

2016-05-19 Thread Pierre
here is the view output displaying the object r : address : 17 Rue Farges, 13008 Marseille, France admlev_one : Provence-Alpes-Côte d'Azur admlev_two : Bouches-du-Rhône country : FR latlon[lat] : 43.2806116 latlon[lon] : 5.38451159996 locality : Marseille postalcode : 13008 t : it'

[web2py] Re: parse

2016-05-19 Thread Anthony
Looks like maybe whatever process generates the post request is representing a nested data structure via brackets -- so the key "latlon[lat]" is meant to represent an object like {'latlon': {'lat': the_value}}. However, web2py doesn't know to parse keys containing brackets into a nested data st

[web2py] Re: parse

2016-05-19 Thread Pierre
ok I'll flatten the object and I expect it's not going to complain. thanks Anthony -- 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 receiv

[web2py] Re: How can I make a calculation in the view?

2016-05-19 Thread greenpoise
Thanks a million. On Wednesday, May 18, 2016 at 10:11:40 PM UTC-7, 黄祥 wrote: > > just do like usual in controller > e.g. > *controllers/default.py* > def report_investor(): > choose_investor = request.args(0) > # query > query_account = (db.account.investor == choose_investor) > > # row > rows_a

[web2py] Re: How can I make a calculation in the view?

2016-05-19 Thread greenpoise
I see. Thanks Anthony On Thursday, May 19, 2016 at 3:09:52 AM UTC-7, Anthony wrote: > > Though generally it is good to minimize the logic in views, as they are > more difficult to read, test, and debug. So, prefer moving such > calculations to the controller, or at least to a function that is

[web2py] Advice on handling positive and negative decimals?

2016-05-19 Thread pbreit
What's the prevailing best practice for storing financial debits and credits in the DB? 1 table of both or 2 tables (1 for each)? 1 column of positive and negative values or 2 columns (amount and type)? store as integers (cents) or decimals (dollars)? -- Resources: - http://web2py.com - http://

[web2py] Re: Advice on handling positive and negative decimals?

2016-05-19 Thread villas
I have given this quite a bit of thought in the past. In the end, I decided one column of decimals, positive and negative does a good job. It has always worked well for me and I have never had any reason to doubt it was the right thing to do. There are no doubt other opinions, and other c

[web2py] Re: Web2PY server is hanging

2016-05-19 Thread Massimo DiPierro
Can you tell us more? What server? What database? What is the app about. Usually it hags because of code error: - you access something that is not thread safe, for example os.chdir(...) - you lock some object and do not release Please tell us more and we can help debug. On Thu, May 19, 2016 at 5

Re: [web2py] Re: how to create pdf report in web2py???

2016-05-19 Thread Dave S
On Wednesday, May 18, 2016 at 10:21:24 PM UTC-7, prashant joshi wrote: > > https://vimeo.com/18601633 > according to this video i have already done shown in this video after > adding appreport plugins i,m getting error: > Cannot import module > 'applications.report.modules.modules' > > please su

[web2py] Re: stuck up on Deployment on CentOS 6.7

2016-05-19 Thread Dave S
On Thursday, May 19, 2016 at 6:03:18 AM UTC-7, Rahul wrote: > > Hi All, > I have root access for the VPS server which is on centOS6.7 I have > installed web2py in /home/www/ directory and Apache2 is by default > installed in /usr/local/apache2. Now accessing my website shows me the > Ap

Re: [web2py] Re: how to create pdf report in web2py???

2016-05-19 Thread prashant joshi
db- db = DAL("postgres://postgres:postgres@localhost:5432/report1") from gluon.tools import Auth auth = Auth(db) auth.define_tables(username=True,signature=False) db.define_table('register', Field('first_name', requires=IS_NOT_EMPTY()), Field('last_name', requires=IS_NOT_EMPTY()), Fiel

[web2py] Re: stuck up on Deployment on CentOS 6.7

2016-05-19 Thread Rahul
Thanks! Dave. That section deals with centOS7, I will check nginx section and try to make it work for me. Starting the web2py manually with nohup command over my public IP works but that would have a port where I would need to access it. I want a cleaner way to make it work automatically. 1. S