[web2py] Re: How to use the new cpdb.py introduced in 1.97.1?

2014-05-09 Thread mart
well, there are 2 things to look at. 1) You need to be able to import the dal.py module (located in the /gluon dir) to setup your connection strings 2) just so you know, there are very few important lines of code in that script... Only the following matter: # obviously, you will need

[web2py] thumbnails plugin

2014-05-09 Thread Carlos A. Armenta Castro
I'll try it, it was ir looking For. -- 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 Gro

[web2py] Re: How to use the new cpdb.py introduced in 1.97.1?

2014-05-09 Thread Ben Lawrence
Hi, How did you get to that stage? I get: gluon path not found EXCEPTION: could not make a copy of the database global name 'DAL' is not defined On Saturday, July 23, 2011 12:17:22 AM UTC-7, Saurabh Sawant wrote: > > I am having a hard time migrating data from sqlite to postgres > > This is th

[web2py] represent in form field

2014-05-09 Thread 黄祥
hi, is it possible to make represent work in form field? e.g. db.product.price.represent = lambda price, field: format(price, ",d").replace(",", ".") this work only in view, not in the form field, my expectation is when user input the price in input field they will have . for thousand separated

[web2py] Re: color cells based on value in SQLFORM

2014-05-09 Thread Anthony
Might be easiest to do this with Javascript in the browser. You can also manipulate the grid DOM on the server -- maybe something like this: colors = {1: 'green', 2: 'yellow', 3: 'red'} grid = SQLFORM.grid(...) table = grid.element('.web2py_table') if table: [td.update(_style='background: ' +

[web2py] Re: What is a clear procedure to style web2py css files using Bootstrap theme generators/choosers?

2014-05-09 Thread LightDot
As far as Bootswatch 2 themes are concerned, the original, stock bootstrap-responsive.min.css must be loaded if you wish your page to be "responsive". Bootswatch 2 themes do not provide this functionality. So, regardless of the Bootswatch 2 theme used, they can all co-exist with the same, stock

[web2py] OPTION helper - custom class for the drop down

2014-05-09 Thread greenpoise
How can I add a custom class for a drop down? {{=SELECT(*[OPTION(r.detail,_value=r.id) for r in row.inventory],**dict( _name='id'))}} -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/is

[web2py] Re: T.accepted_language shows nl instead of nl_NL

2014-05-09 Thread Massimo Di Pierro
Which app? Perhaps we do not have a nl_NL.py file. On Thursday, 8 May 2014 09:21:01 UTC-5, Stefan van den Eertwegh wrote: > > Does anybody know how this happened? > > T.accepted_language shows nl instead of nl_NL > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - ht

[web2py] Re: question about video

2014-05-09 Thread Massimo Di Pierro
The only thing that you need that does not ship with web2py is a way to record their video and upload to your side. Some options include: - http://www.webrtc.org/ - http://www.screencast-o-matic.com/ Massimo On Thursday, 8 May 2014 13:59:19 UTC-5, eric cuver wrote: > > Hi, > I'm beginning to w

[web2py] Re: Bootstrap3 package - help to test

2014-05-09 Thread pjryan126
I'm using this in a project now and I even have it working on IE 8. Thanks, Paolo! The only thing I have had to do so far is to add "li_active='active' to bs3.menu(): menu = MENU(current_menu, _class='nav %s' % menu_class, li_active='active', li_c

[web2py] Re: How to run arbitrary scripts within the web2py environment?

2014-05-09 Thread Spencer Underwood
I'm not very good at putting into words what I'm thinking, so I do apologize for not being very clear. I was hoping there might be a way to do "one-off" type scripts using the DAL and Auth features to test code that can print to a console. You are right, for this particular use case an MVC fram

[web2py] Re: How to run arbitrary scripts within the web2py environment?

2014-05-09 Thread Spencer Underwood
Sorry for the delay in replying, I added a reply to this yesterday but it doesn't appear to have gone through for some reason. On the other hand, if this is a duplicate of yesterdays post feel free to ignore it. What I mean by running in the web2py environment is having access to the features s

[web2py] Re: configuring routes for web2py behind reverse proxy

2014-05-09 Thread Peter Lai
To your Apache config On Sunday, April 13, 2014 1:24:20 PM UTC-4, Jason Lee wrote: > > What file am I supposed to add this to? > > default, weby2py, default-sll? > > On Thursday, November 14, 2013 6:48:05 PM UTC-5, DeanK wrote: >> >> For anyone in the future trying to do this with Apache2 on Ubunt

[web2py] DAL: How to check for empty list:string when using mongodb

2014-05-09 Thread Juan Luis
This is in relation to http://stackoverflow.com/questions/23367218/web2py-dal-how-to-check-liststring-type-items-for-none Answer works when tested on sqlite but does not work for Mongodb In [4]: db.Tasks.email != [ ] Creates the mongo query : Out[4]: In mongo shell: > db.Ta

[web2py] question about video

2014-05-09 Thread eric cuver
Hi, I'm beginning to web2py, I would like to create a site that allows people to register on the site to be able to record their webcam and put the video on the account and customizes video will be viewed by people who have the right. how do you function module or with web2py I happen to cre

[web2py] Re: PIL software for win 64bit and python 2.7 64 bit

2014-05-09 Thread Rafael Santos
Have all versions > PIL-1.1.7.win-amd64-py2.x installers are available at > http://www.lfd.uci.edu/~gohlke/pythonlibs/#pil > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues

[web2py] Re: web2py report pdflatex template

2014-05-09 Thread Peter Pan
thanks! web2py create very good the pdf with the template.tex but without args in the pdf. Its right that i have to create a class like this: class LaTeXTemplate(string.Template): delimiter = "%%" Or understand the markmin a special operator to insert the args? My template.tex is: \documentc

[web2py] How to make SQLFORM generate INPUT type as 'date' instead 'text'

2014-05-09 Thread José Antonio Salazar Montenegro
My field is defined in db.py as Field('mydate', type='date', requires=IS_DATE(format=T('%Y-%m-%d'))), Using a custom FORM() I only need to do this: INPUT(_type='date', _name='mydate') To generate a great YMD INPUT with pop-up calendar and selectable date parts: ... ... Now I want to use SQLF

[web2py] T.accepted_language shows nl instead of nl_NL

2014-05-09 Thread Stefan van den Eertwegh
Does anybody know how this happened? T.accepted_language shows nl instead of nl_NL -- 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 mess

[web2py] Re: web2py report pdflatex template

2014-05-09 Thread Peter Pan
Ok, i find a way to work with the template and it works well: I use this code in web2py: def print_task(): task = db.task(request.args(0,cast=int)) from gluon.contrib.markmin.markmin2pdf import latex2pdf template = open('//home/user/web2py/applications/Tagesaufgaben/tex/tex/te

[web2py] Re: sqltable and aggregrate function

2014-05-09 Thread peteb3100
Done: see http://code.google.com/p/web2py/issues/detail?id=1932 Hope this helps. If you need more information please let me know.. And, Massimo and all other contributors: thanks a lot for Web2py framework! It's really such a gem... Am Mittwoch, 7. Mai 2014 23:44:39 UTC+2 schrieb Massimo Di Pier

[web2py] Web2py isn't loading my custom css file

2014-05-09 Thread ari northage-orr
Hey Everyone, So I'm working on a website for a few friends who make music together and I have a custom css file I'm trying to add and for some reason web2py isn't loading it, or at least the styles in the file are not being applied. Here are the details: The file is called wholeteam.css my l

Re: [web2py] Re: is it allowed/possible to replace the database within a controler ?

2014-05-09 Thread Stef Mientki
thanks Anthony. On 09-05-14 22:22, Anthony wrote: Sure, it should be allowed, but nothing will be returned to the browser while you're waiting for the copy to happen. If the copy takes too long, the HTTP request may time out. Anthony On Friday, May 9, 2014 4:17:05 PM UTC-4, aapaap wrote:

[web2py] Re: is CAT() causing RuntimeError: maximum recursion depth exceeded in cmp ?

2014-05-09 Thread SimonD
Anthony, thanks for the quick reply. Very appreciated. That confirms my suspicions. Thanks also for the alternative code. Simon On Friday, May 9, 2014 9:18:53 PM UTC+1, Anthony wrote: > > CAT is a helper object, so you are nesting CATs inside of CATs inside of > CATs, which is causing the recurs

[web2py] Re: is it allowed/possible to replace the database within a controler ?

2014-05-09 Thread Anthony
Sure, it should be allowed, but nothing will be returned to the browser while you're waiting for the copy to happen. If the copy takes too long, the HTTP request may time out. Anthony On Friday, May 9, 2014 4:17:05 PM UTC-4, aapaap wrote: > > thanks Anthony, > > Thought it was difficult to gen

[web2py] color cells based on value in SQLFORM

2014-05-09 Thread LoveWeb2py
Hello, I have a spreadsheet of items and I want to track their inventory based on color (similar to an excel spreadsheet). I have two columns for example: Item, Item_Status The item could be a desk, chair, etc... and for status I have 1 2 or 3. If the status is 1 I would like to make the cell c

[web2py] Re: is CAT() causing RuntimeError: maximum recursion depth exceeded in cmp ?

2014-05-09 Thread Anthony
CAT is a helper object, so you are nesting CATs inside of CATs inside of CATs, which is causing the recursion problem when everything has to be rendered. Your second approach is the way to go. Actually, you can skip making a separate list and instead just do: table = TABLE() for row in

[web2py] Re: is it allowed/possible to replace the database within a controler ?

2014-05-09 Thread Stef Mientki
thanks Anthony, Thought it was difficult to generate a scheduled task. But in PythonAnyWhere it'standard available. So I'll go that way. Still wondering if it's allowed to copy the default web2py database in a controler function ? cheers, Stef On 09-05-14 0:02, Anthony wrote: You probably

[web2py] is CAT() causing RuntimeError: maximum recursion depth exceeded in cmp ?

2014-05-09 Thread SimonD
Hi, I would like to seek knowledge/expertise. I have this function - which shows "all user activity in the previous 90 days" def all_activity(): tabledata=TR(B('Date/Time'),B('User'),B('Activity'),_style='background-color:lightblue;') #formatted header for row in db(db.activity.date_

Re: [web2py] Re: Does Web2py Postgres Adapter support JSON as native type ?

2014-05-09 Thread Mandar Vaze / मंदार वझे
On Thu, May 8, 2014 at 6:25 PM, Anthony wrote: > And here's where it happens in the code: > https://github.com/web2py/web2py/blob/master/gluon/dal.py#L2886 > Thanks for pointing the relevant piece of code. Definitely helps !!! -Mandar -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] thumbnails plugin

2014-05-09 Thread Carlos Cesar Caballero Díaz
Hi, this is a first aproach of a thumbnails plugin, needs PIL to work. Any recomendations will be apreciated (I don't like so much what I am doing with the database) -- Este mensaje le ha llegado mediante el servicio de correo electronico que ofrece Infomed para respaldar el cumplimiento de

[web2py] Re: Here's how to run Web2Py on IBM BlueMix

2014-05-09 Thread Willoughby
I love the vision, but my lawyers would never allow it! LOL On Friday, May 9, 2014 9:33:33 AM UTC-4, duncan macneil wrote: > > On Thursday, 8 May 2014 22:29:31 UTC+10, Willoughby wrote: >> >> Is Azure in your shoot-out? I'd be interested in hearing those results... >> >>> > Hey, woah, I'm th

[web2py] Re: What is a clear procedure to style web2py css files using Bootstrap theme generators/choosers?

2014-05-09 Thread JoeCodeswell
Dear LightDot and Ari, Thanks for the responses. The situation is getting clearer in my mind. I have some follow-on questions for LightDot. You said: Details such as whether you need to replace just bootstrap.min.css (and > keep the original bootstrap-responsive.min.css) or replace the > boots

Re: [web2py] Re: Here's how to run Web2Py on IBM BlueMix

2014-05-09 Thread Tito Garrido
Hi Duncan, It is my first time deploying web2py on a PaSS could you please let me know how to proceed on step 1? Step 1: Use the source version of Web2Py and copy the entire lot into a folder path: 'env/app' so that web2py.py is in the 'app' folder. Step 2: You need to have a requirements.txt f

Re: [web2py] Re: Here's how to run Web2Py on IBM BlueMix

2014-05-09 Thread Don O'Hara
Very nice "morning report"! It gives a framework that can be developed into a large paper explaining what each term means; the pros/cons of the available options (at this point in time); motivations for design choices; future technologies to become aware of; etc; etc. Then it can become an O

[web2py] Re: Here's how to run Web2Py on IBM BlueMix

2014-05-09 Thread duncan macneil
On Thursday, 8 May 2014 22:29:31 UTC+10, Willoughby wrote: > > Is Azure in your shoot-out? I'd be interested in hearing those results... > >> >>> Hey, woah, I'm the cloud shootout guy now? ;-) Cool! I have had a small-to-serious look at Azure, Google Compute, Amazon, Rackspace, Heroku, etc. Ther

Re: [web2py] Re: Do we need a "response.files" for footer as well as header?

2014-05-09 Thread Carlos Cesar Caballero Díaz
I think Joe has a valid point, put the javascript at the end does not show a real improvement in the loading time, but it gives users a feeling of greater speed, but we must be careful when selecting which javascript files can go to the end and which not. I'm not entirely sure if is necessary to

[web2py] Re: Here's how to run Web2Py on IBM BlueMix

2014-05-09 Thread duncan macneil
Hi Massimo, My pleasure. You may remember me from trying to get Web2Py running under Jython in a Websphere servlet container environment a while back. I didn't ever get there fully. So having this way to run in the IBM ecosystem is nice. I have been emailing a bit with one of the contacts from

Re: [web2py] Re: Reload page on component form submit

2014-05-09 Thread Carlos Cesar Caballero Díaz
Stewart, thanks for sharing such clear example!!! El 08/05/14 22:51, LaDarrius Stewart escribió: ---controller-- @auth.requires_login() def test(): a=request.args(0) form=SQLFORM(db.Notes).process() form.vars.TestID = a comments=db(db.Test

[web2py] Re: cannot operate on a closed database

2014-05-09 Thread Wonton
Hello aleonserra, Thank you very much for your answer. The problem is that I have no admin access to the server so I cannot execute that command, and in my local server everything works fine, so I cannot replicate the error. On the other hand I've searched through all my code and I never close

[web2py] Re: cannot operate on a closed database

2014-05-09 Thread aleonserra
The error suggest that dal couldnt connect to the database. It doesnt look like a web2py problem but a db one. at line 4 add .select() to execute the statement. row = db(db.auth_user.username == username).select() Also start a web2py shell session (web2py -a -M)and test the database by executi