[web2py] Re: if I use the "one step production deployment" will it overwrite these existing settings?

2015-03-05 Thread Niphlod
yes On Friday, March 6, 2015 at 12:30:36 AM UTC+1, Simon Redmond wrote: > > quick install question, I have postfix,dovecot apache and an ssl cert > already installed and configured on my server, if I use the "one step > production deployment" will it overwrite these existing settings? > -- Res

Re: [web2py] Re: IMPORTANT - WEB2PY CONSULTING

2015-03-05 Thread José Luis Redrejo
2015-03-04 22:26 GMT+01:00 Manuele Pesenti : > Il 04/03/15 17:40, Chris ha scritto: > > I do web2py consulting work on the side but I'm an individual. Can I > > include just an email address, and not a webpage? > me too... in Italy. > > And me too, in Spain... > M. > > -- > Resources: > -

[web2py] Re: How to properly import Active Directory users into web2py auth_user table?

2015-03-05 Thread Dave S
Glad to hear that you were successful. Return types can keep us on our toes, can't they? /dps On Thursday, March 5, 2015 at 3:30:02 PM UTC-8, Grzegorz Dzień wrote: > > Found it, it was that values I was importing were tuples, it works given I > access "first tuple item" e.g.: > first_name=use

[web2py] Re: two (or more) applications using the same database

2015-03-05 Thread lucas
wouldn't SQL based be better? especially with searching through indexes. like i use postgresql and i wouldn't mind sticking with that. lucas On Thursday, March 5, 2015 at 9:39:21 PM UTC-5, Ron Chatterjee wrote: > > Once solution I can think of, you can save them all on a csv file and > write t

[web2py] Re: two (or more) applications using the same database

2015-03-05 Thread Ron Chatterjee
Once solution I can think of, you can save them all on a csv file and write them on a csv file. import and export on demand and create tables that way. There are some links I saw about how to create DAL object using csv file. On Thursday, March 5, 2015 at 8:57:13 PM UTC-5, lucas wrote: > > hey

[web2py] Re: Adding

2015-03-05 Thread Massimo Di Pierro
On second thought... there is one way. You can create your own mail object which has a send_mail method and all it does is to queue its arguments. Then configure auth.settings.mailer to user your mailer object. On Thursday, 5 March 2015 17:30:03 UTC-6, James O' Driscoll wrote: > > I am trying to

[web2py] Re: Adding

2015-03-05 Thread Massimo Di Pierro
please open a github ticket about this. On Thursday, 5 March 2015 17:30:03 UTC-6, James O' Driscoll wrote: > > I am trying to place all email sent from app into queue. > > I am using scheduler and this works fine. > > I want to add the email for verifying email, detailed below, to the queue. > > I

[web2py] Re: Any way to push error tickets in web2p to the database?

2015-03-05 Thread Massimo Di Pierro
Yes and not. web2py always stores them in files but we provide a script (scripts/tickets2db.py) which you can run and periodically copy existing tickets to db. This also allows you to use a separate db for tickets which do not belong with the app data. There is also a tickets2email which you ma

[web2py] Re: websocket: Send data when connect

2015-03-05 Thread Massimo Di Pierro
You are missing the point of the websocket system. You do not pass data when you connect it. You pass data using JS after you connect to it. You can change this behavior (and I can see use cases when you have to) but you would have rewrite your own server side code. Massimo On Thursday, 5 Ma

[web2py] two (or more) applications using the same database

2015-03-05 Thread lucas
hey one and all, i have a table or zip codes and another of counties. i am thinking of moving those tables to their own database so that two or more of my applications can use those quite general tables. what are the implications of doing that? would i have copies of the database structures

Re: [web2py] .grid() my own search widget possible? How?

2015-03-05 Thread Ron Chatterjee
I just posted a question in the web2py group. Searching I came to this post. Since you guys worked on this. What if I do like the default search and want to stick with it and display the search box that comes out of SQLFORM.grid or smartgrid but I don't want to display the table underneath. Do

[web2py] Re: Current status of adapting OrientDB for web2py

2015-03-05 Thread Pumplerod
I had a look, thanks. Wow. I think I would need a much better understanding of all the parts before I could take that on. What are the odds I could make a contribution toward web2py in order to fast-track the adapter? On Monday, February 13, 2012 at 9:54:05 AM UTC-8, Nolan Nichols wrote: > >

[web2py] Re: how to sanitize ckeditor and then test it

2015-03-05 Thread Alex Glaros
Am I supposed to put this a top of edit page view? {{=XML(tableName.fieldName,sanitize=True)}} ??? seems like sanitize should be located in controller, not in view... -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - h

[web2py] Re: web2py.com/sqldesigner not working import export

2015-03-05 Thread Ron Chatterjee
I believe the developers are working to put a new sqldesigner that is more DAL specific. I have the same issue so I am assuming its a working progress. You can just look at the example file and start coding up DAL. Its not that difficult. But I do agree, it can be a handy tool to have. On Thurs

[web2py] Re: Web2py ckEditor

2015-03-05 Thread Massimo Di Pierro
it js so it would go into applications/yourapp/static/ On Wednesday, 4 March 2015 17:27:28 UTC-6, Alex Glaros wrote: > > hi Tim > > how do I install ck_editor? > > assume I don't know what directory to use or anything else > > thanks! > > Alex > -- Resources: - http://web2py.com - http://web2py.

[web2py] if I use the "one step production deployment" will it overwrite these existing settings?

2015-03-05 Thread Simon Redmond
quick install question, I have postfix,dovecot apache and an ssl cert already installed and configured on my server, if I use the "one step production deployment" will it overwrite these existing settings? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://githu

[web2py] Re: Bootstrap is really killing web2py

2015-03-05 Thread Moiz Nagpurwala
Hello, I'm using latest relaease of web2py on my local machine. ( 2.9.12-stable+timestamp.2015.02.15.23.04.25 (Running on Rocket 1.2.6, Python 2.7.9)) Unable to install the w2p file provided for BS 3. Please help. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - htt

[web2py] Re: How to properly import Active Directory users into web2py auth_user table?

2015-03-05 Thread Grzegorz Dzień
Found it, it was that values I was importing were tuples, it works given I access "first tuple item" e.g.: first_name=user[1]['givenName'][0] On Wednesday, March 4, 2015 at 8:59:32 PM UTC+1, Grzegorz Dzień wrote: > > I have tried doing it this way: > > def showthemall(): > # LDAP connection s

[web2py] websocket: Send data when connect

2015-03-05 Thread Manu Mora
In websocket_messaging.py there are the following code: class DistributeHandler(tornado.websocket.WebSocketHandler): def open(self, params): group, token, name = params.split('/') + [None, None] self.group = group or 'default' self.token = token or 'none' self.n

[web2py] Adding

2015-03-05 Thread James O' Driscoll
I am trying to place all email sent from app into queue. I am using scheduler and this works fine. I want to add the email for verifying email, detailed below, to the queue. I would have taught that I have to append a mail function to the request_reset_password.onaccept, but this is not availab

[web2py] Query Production Oracle database using DAL

2015-03-05 Thread Michel Krav
Hi , I need to dump some tables from oracle db let's call it *dbo *into sqlite *db *to allow a "disconnect/offline" mode for an app. I' ve already done this stuff using cx_oracle, building a cursor, then my own SQL requests..., now I'm looking to ease those tasks. [So no problem to connect or

[web2py] Re: IMPORTANT - WEB2PY CONSULTING

2015-03-05 Thread tahnoon pasha
As a user of web2py consultants, can I please just add what a great idea it is to do this. On Monday, 16 February 2015 06:21:36 UTC+8, Massimo Di Pierro wrote: > > We need to update the list of companies that provide web2py consulting. > This list is obsolete: > > http://web2py.com/init/default/s

[web2py] web2py.com/sqldesigner not working import export

2015-03-05 Thread ifM
Hello people Prompt, "web2py.com/sqldesigner" only I have not worked import or export? And web2py.com/sqldesigner is very different from that on "github.com/elcio/visualdal" -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

[web2py] Any way to push error tickets in web2p to the database?

2015-03-05 Thread Franky Davis Monroe Jr.
I noticed that error tickets in web2py are written to files but I have a load balanced environment. Is there a way to write these tickets to the database instead? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https:

[web2py] how to sanitize ckeditor and then test it

2015-03-05 Thread Alex Glaros
(1) what is syntax for sanitizing ckeditor input, (2) and afterwards what can I type into ckeditor form to test for XSS, to see if sanitize is working? thanks Alex Glaros -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code)

Re: [web2py] dbio=False proper way to update every fields not only the one that had changed

2015-03-05 Thread Anthony
On Thursday, March 5, 2015 at 4:18:06 PM UTC-5, Richard wrote: > > Yes I struggle with it to make compute works... > > I come up with something like this : > > after .accepted > > for f in db[request.args(0)].fields: > if f != db[request.args(0)]._id and f != > db[request.args(0)].reco

Re: [web2py] dbio=False proper way to update every fields not only the one that had changed

2015-03-05 Thread Richard Vézina
Yes I struggle with it to make compute works... I come up with something like this : after .accepted for f in db[request.args(0)].fields: if f != db[request.args(0)]._id and f != db[request.args(0)].record_review_status: form.vars[f] = form.vars.get(f, db[request.args

Re: [web2py] dbio=False proper way to update every fields not only the one that had changed

2015-03-05 Thread Niphlod
web2py doesn't know if a field has been edited or not. form.vars (for a standard web2py form) holds EVERY value, irregardless of the ones touched or not by the user... On Thursday, March 5, 2015 at 4:17:26 PM UTC+1, Richard wrote: > > Futher check make me confirm which I thought : > > **{f: v

Re: [web2py] Re: Ckeditor plugin - Update ckeditor

2015-03-05 Thread Alex Glaros
sanitize=True doesn't work on all styles/sizes/fonts. sanitize=False works consistently -- 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

Re: [web2py] Re: Ckeditor plugin - Update ckeditor

2015-03-05 Thread Alex Glaros
sanitize=TRUE works, don't need FALSE -- 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 G

Re: [web2py] Re: Ckeditor plugin - Update ckeditor

2015-03-05 Thread Alex Glaros
yes, I imported as stated on slices and github the only way to get it to display correctly is if escape out, in the view, e.g., {{=XML(personID.summarySelfDescription, sanitize=False)}} any ideas why others don't have to escape? is it safe to do that? thanks Alex -- Resources: - http://web

Re: [web2py] Re: Ckeditor plugin - Update ckeditor

2015-03-05 Thread Willoughby
Did you import and initialize it? https://github.com/timrichardson/web2py_ckeditor4#introduction On Thursday, March 5, 2015 at 1:26:14 PM UTC-5, Alex Glaros wrote: > > somehow I missed the simplicity of installation - it's installed now but > resulting web page displays the HTML code instead o

Re: [web2py] Re: Ckeditor plugin - Update ckeditor

2015-03-05 Thread Alex Glaros
somehow I missed the simplicity of installation - it's installed now but resulting web page displays the HTML code instead of implementing them how to make create the the HTML action and not display the HTML code? looks like: gov improvement   testing this text editor the db field that's used

[web2py] Re: Displaying request.vars

2015-03-05 Thread Anthony
On Thursday, March 5, 2015 at 11:15:27 AM UTC-5, Gael Princivalle wrote: > > Thanks a lot Leonel, it's exactly what I was searching for. > @Antony thanks but in this case it was not the current web2py url (a .load > file), but another that calla the .load file. > As long as it is a web2py URL, yo

Re: [web2py] Re: Ckeditor plugin - Update ckeditor

2015-03-05 Thread Willoughby
Have you reviewed the chapter on plugins? http://web2py.com/books/default/chapter/29/12#Plugins On Thursday, March 5, 2015 at 12:17:04 PM UTC-5, Alex Glaros wrote: > > can someone tell me how to install the plugin? > > assume I've never installed a plugin, don't know what directory to put it > i

[web2py] Re: sqlformfactory smartgrid just search field

2015-03-05 Thread Ron Chatterjee
In other words, On Thursday, March 5, 2015 at 12:26:32 PM UTC-5, Ron Chatterjee wrot

[web2py] sqlformfactory smartgrid just search field

2015-03-05 Thread Ron Chatterjee
I like the way the search field shows up using smartgrid in web2py. But I dont want the table to b listed below because I want to customize the table display. Does anyone one if there way to display just the search box using smartgrid without displaying the table underneath.I know there is a way

[web2py] sqlformfactory smartgrid just search field

2015-03-05 Thread Ron Chatterjee
I like the way the search field shows up using smartgrid in web2py. But I dont want the table to b listed below because I want to customize the table display. Does anyone one if there way to display just the search box using smartgrid without displaying the table underneath.I know there is a way

[web2py] sqlformfactory smartgrid just search field

2015-03-05 Thread Ron Chatterjee
I like the way the search field shows up using smartgrid in web2py. But I dont want the table to b listed below because I want to customize the table display. Does anyone one if there way to display just the search box using smartgrid without displaying the table underneath.I know there is a way

[web2py] sqlformfactory smartgrid just search field

2015-03-05 Thread Ron Chatterjee
I like the way the search field shows up using smartgrid in web2py. But I dont want the table to b listed below because I want to customize the table display. Does anyone one if there way to display just the search box using smartgrid without displaying the table underneath.I know there is a way

[web2py] sqlformfactory smartgrid just search field

2015-03-05 Thread Ron Chatterjee
I like the way the search field shows up using smartgrid in web2py. But I dont want the table to b listed below because I want to customize the table display. Does anyone one if there way to display just the search box using smartgrid without displaying the table underneath.I know there is a way

Re: [web2py] Re: Ckeditor plugin - Update ckeditor

2015-03-05 Thread Alex Glaros
can someone tell me how to install the plugin? assume I've never installed a plugin, don't know what directory to put it in, and don't know basic plugin concepts. Have tried downloading and inserting everywhere but need info gaps filled. thanks Alex Glaros -- Resources: - http://web2py.com

[web2py] Re: Displaying request.vars

2015-03-05 Thread Gael Princivalle
Thanks a lot Leonel, it's exactly what I was searching for. @Antony thanks but in this case it was not the current web2py url (a .load file), but another that calla the .load file. Il giorno giovedì 5 marzo 2015 12:20:25 UTC+1, Leonel Câmara ha scritto: > > {{import urllib}} > http://www.mydomain

[web2py] Re: SQLFORM.factory adding dynamic form

2015-03-05 Thread Ramkrishan Bhatt
table already defined: address Anyway i guess you are not understanding requirement :- SQLFORM.factory(table1,table2,table3) if form.process().accepted: do something. Now we want like we can add extra add table2 form in dynamically. like in view composit form of table1 table2 (op

Re: [web2py] dbio=False proper way to update every fields not only the one that had changed

2015-03-05 Thread Richard Vézina
Futher check make me confirm which I thought : **{f: v for f, v in form.vars.iteritems()} Prevent my compute to work since it return only the fields modify by the user... I need to understand how web2py really update on form submit and why compute works in this case... Or how can I make sure tha

[web2py] Re: how to define field so that it only pulls from auth_user those who have a certain auth_membership?

2015-03-05 Thread Oliver Holloway
This works perfectly, stifan, thank you very much. On Thursday, March 5, 2015 at 12:09:10 AM UTC-5, 黄祥 wrote: > > perhaps you can achieve it with query on IS_IN_DB validator: > e.g. > query_sessions = ( > (db.auth_user.id == db.auth_membership.user_id) & > (db.auth_membership.group_id == db.auth_

[web2py] Re: Displaying request.vars

2015-03-05 Thread Anthony
On Thursday, March 5, 2015 at 6:53:47 AM UTC-5, 黄祥 wrote: > > index.html > {{=A(_href = URL(vars = dict(product_id = request.vars) ) ) }} > > "product_id" is already in request.vars (which acts like a dict), so no need to create a new dict with a "product_id" key. Anthony -- Resources: - http

Re: [web2py] Re: Resizable SQLFORM grid columns?

2015-03-05 Thread Richard Vézina
It use to have an integration of jqgrid in web2py in the pass... It may still there... If you search the user group a bit you will find details about it I am pretty sure... Richard On Wed, Mar 4, 2015 at 3:21 PM, LoveWeb2py wrote: > Although I do like the layout of jqgrid I'm also using custom

[web2py] Re: Displaying request.vars

2015-03-05 Thread 黄祥
index.html {{=A(_href = URL(vars = dict(product_id = request.vars) ) ) }} 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 receiv

[web2py] Displaying request.vars

2015-03-05 Thread Anthony
Is it a web2py URL? If so, you can do URL(..., vars=request.vars). Antony -- 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 becau

[web2py] Re: Displaying request.vars

2015-03-05 Thread Leonel Câmara
{{import urllib}} http://www.mydomain.com/index?{{=urllib.urlencode(request.vars)}} "> Go -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google

Re: [web2py] Re: cache.disk.clear() crashes in appadmin

2015-03-05 Thread Eric Christiaanse
Hi Leonel, I've removed the cache folder from svn. Everything works fine now with cache removal :) Tnx! 2015-03-03 16:21 GMT+01:00 Leonel Câmara : > Yes, it is created on demand if it isn't there, go ahead and svn delete it. > > -- > Resources: > - http://web2py.com > - http://web2py.com/book

[web2py] Displaying request.vars

2015-03-05 Thread Gael Princivalle
Hello. I would like to build an URL using request.args. Something like that: http://www.mydomain.com/index?{{=request.vars}}";> Go But the result is: http://www.mydomain.com/index? Go And it should be: http://www.mydomain.com/index?product_id=8";> G

Re: [web2py] PDF view - set printing page size

2015-03-05 Thread Pavel
I am from Central Europe region with a lot of accented characters. U use your second solution: import sys reload(sys) sys.setdefaultencoding("utf-8") pdf.add_font('DejaVu', '',os.path.join(request.folder,'static', 'DejaVuSansCondensed.ttf'), uni=True) ... and now it is all working completely.