Re: [web2py] Embed Plotly Express in Web2PY

2024-01-25 Thread Al Ex
in controller ``` import plotly.express as px def my_view(): # Assuming df_dataframe is your Pandas DataFrame fig = px.line(df_dataframe, x="datetime", y="load_avg_fifteen") # Convert the figure to HTML plotly_chart = fig.to_html(full_html=False, include_plotlyjs='cdn') retur

Re: [web2py] Re: app not loading external python library

2023-10-27 Thread Al Ex
pip install urllib3_secure_extra in my virtual env solved the problem. Thank you Tom for pointing to the solution, I had missed that thread. On October 27, 2023 at 16:59:18, Tom Clerckx (tcler...@gmail.com) wrote: I think this is the same issue as was discussed a few months ago: See this threa

[web2py] test message

2023-10-24 Thread Al Ex
Hi Jim, this is a test message -- 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 Groups

[web2py] app not loading external python library

2023-10-23 Thread Al Ex
Hi, I am running web2py Version 2.25.1-stable in virtualenv (python 3.9.5, it happens also in python 3.10.10) After activating the virtualenv, I installed requests $ pip install request $ pip show requests Name: requests Version: 2.31.0 Summary: Python HTTP for Humans. Home-page: https://request

[web2py] AssertionError: Header names/values must be of type str

2023-10-23 Thread Al Ex
Hi, Running web2py in virtualenviroment (python 3.9.5, it happens also in python 3.10.10) ERROR:Rocket.Errors.Thread-3:Traceback (most recent call last): File "/Users/z/dev/web2py/gluon/rocket.py", line 1294, in run self.run_app(conn) File "/Users/z/dev/web2

Re: [web2py] Re: left outer join

2022-02-20 Thread Al Ex
Thank you But what if the left join is made on an arbitrary select, not an already defined table? Maybe I am missing something evident On February 20, 2022 at 18:15:50, jonatha...@whatho.net ( jonathan.cl...@whatho.net) wrote: http://www.web2py.com/books/default/chapter/29/06/the-database-abs

[web2py] left outer join

2022-02-18 Thread Al Ex
Hi, How can I reproduce this LEFT OUTER JOIN in PyDAL ? SELECT name FROM doc LEFT JOIN ( SELECT name FROM X INNER JOIN ... WHERE ... ) T ON ( T.name = name) WHERE T.name IS NULL -- Resources: - http://web2py.com - http://web2py.com/book (Documentation

Re: [web2py] Autocomplete widget match middle of word

2018-09-17 Thread Al Ex
SQLFORM.widgets.autocomplete has the parameter: at_beginning that you can set to False https://web2py.readthedocs.io/en/latest/_modules/gluon/sqlhtml.html#AutocompleteWidget widget = SQLFORM.widgets.autocomplete(request, ..., at_beginning=False, ) On September 15, 2018 at 10:15:25 PM, An

[web2py] Fwd: multiple SUM IF in a single DAL

2018-06-27 Thread Al Ex
It seems it did not show up in the list yet. On June 22, 2018 at 16:46:48, Al Ex (a22...@gmail.com) wrote: Is there a way to translate into a single DAL this sql query? SELECT SUM(IF(is_a = 'T',1,0)) as a, SUM(IF(is_b = 'T',1,0)) as b FROM table; It counts the tim

[web2py] multiple SUM IF in a single DAL

2018-06-22 Thread Al Ex
Is there a way to translate into a single DAL this sql query? SELECT SUM(IF(is_a = 'T',1,0)) as a, SUM(IF(is_b = 'T',1,0)) as b FROM table; It counts the times is_a and is_b are True. Fields 'is_a' and 'is_b' are declared in DAL as boolean. Thank you -- Resources: - http://web2py.com - ht

Re: [web2py] auth.settings.actions_disabled.append('register')

2018-03-10 Thread Al Ex
What about removing this: {{=T('Sign up')}} from layout.html? On March 11, 2018 at 4:42:52, Andrea Fae' (and...@gmail.com) wrote: Sometimes problems arises. I need to eliminate "sign up" menu item from LOGIN but nevertheless I inserted this line auth.settings.actions_disabled.append('register

Re: [web2py] new style of welcome app

2018-03-09 Thread Al Ex
Probably, you also need to add "dropdown-menu-right" to this: Final: For explanations see: https://v4-alpha.getbootstrap.com/components/dropdowns/#menu-alignment On March 5, 2018 at 2:12:54, Andrea Fae' (and...@gmail.com) wrote: I have different apps in my web2py environments. Web2py app

Re: [web2py] Re: new style of welcome app

2018-03-09 Thread Al Ex
In layout.html, instead of you can try: On March 9, 2018 at 05:12:50, Andrea Fae' (and...@gmail.com) wrote: Yes, I clear the cache Look attached file. Thanks Il giorno giovedì 8 marzo 2018 03:00:53 UTC+1, Anthony ha scritto: > > > > On Wednesday, March 7, 2018 at 2:40:02 PM UTC-5, Andre

Re: [web2py] Re: How many concurrent requests can a web2py instance handle?

2018-03-06 Thread Al Ex
On Mar 6, 2018 09:02, wrote: > Then one web2py instance can only handle one request, that's right? > > -- > 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: pdf output of web2py-book app

2017-04-17 Thread Al Ex
Yes, I saw them. At the end I am trying to get along with convert_book.py (which is in web2py_book/private). Thank you From: Marlysson Silva Reply: web2py@googlegroups.com Date: April 10, 2017 at 22:57:04 To: web2py-users Subject: [web2py] Re: pdf output of web2py-book app Here have so

[web2py] pdf output of web2py-book app

2017-04-08 Thread Al Ex
I have downloaded and used the book app https://github.com/web2py/web2py-book to write some documentation. The document's markmins and images are in the folder /sources/xx-doc-lang, together with updated chapters.txt, info.txt and latex_template.tex mimicking the original web2py documentations fol

Re: [web2py] Re: search results returned by SQLFORM.grid in loaded component {{=LOAD( ....

2016-06-17 Thread Al Ex
Thank you. Formname was already assigned. Yes I need to show the code, I will simplify it a little, at the moment it does not look so nice to read, maybe during this process the bug will also show up ;-) -- Al Ex From: Anthony Reply: web2py@googlegroups.com Date: June 17, 2016 at 10:28:39

[web2py] search results returned by SQLFORM.grid in loaded component {{=LOAD( ....

2016-06-17 Thread Al Ex
In a index.html view I load a component "test.load" containing an SQLFORM.grid with searchable=True. When I perform a search, the results do not appear inside the index.html any more. A new page "test.load” opens with the results. For sure I am doing something wrong, or I am missing something, bec

Re: [web2py] Re: how to generate PDF documents in web2py???

2016-03-13 Thread Al Ex
One alternative could be to 1) install princexml in your server (http://www.princexml.com), check the licence for commercial use 2) in controller: def print_pdf(): response.headers['Content-Type']='application/pdf' from subprocess import Popen, PIPE # on windows (full path of binary)

Re: [web2py] internationalization of url

2015-02-14 Thread al ex
> Kiran Subbaramanhttp://subbaraman.wordpress.com/about/ > > On Sun, 15-02-2015 4:58 AM, al ex wrote: > > How can I make that when the accepted language is english the same > app/ctr/fnc returns the url as > > domain/text-in-english > > and when

[web2py] internationalization of url

2015-02-14 Thread al ex
How can I make that when the accepted language is english the same app/ctr/fnc returns the url as domain/text-in-english and when tha language is spanish, it returns the url as domain/text-in-spanish With pattern routes I can correctly route the incoming request from domain/text-in-english dom

Re: [web2py] How to mimic routes.py with nginx

2015-02-03 Thread al ex
/routes.py, it works but randomly. >> >> Once every two or three times I refresh the page, I get: >> >> "invalid request" >> >> >> >> >> On Mon, Feb 2, 2015 at 7:50 PM, Michele Comitini >> wrote: >> >>> you still need yo

Re: [web2py] How to mimic routes.py with nginx

2015-02-02 Thread al ex
resh the page, I get: "invalid request" On Mon, Feb 2, 2015 at 7:50 PM, Michele Comitini wrote: > you still need your routes.py in place: > > routes_out = ( > ('/app/ctr/fnc', r'/AAA'), > > ) > > > 2015-02-02 11:23 GMT+01:00 al

[web2py] How to mimic routes.py with nginx

2015-02-02 Thread al ex
I have setup this route in /web2py/applications/app routes_in = ( (r'/AAA/?', '/app/ctr/fnc'), ) routes_out = ( ('/app/ctr/fnc', r'/AAA'), ) With rockets, on localhost, it works fine. On production server nginx 1.7.9, uwsgi 2.0.8, python 2.7.6, if I repeatedly refresh /AAA, sometimes

[web2py] routes.py and current.T

2015-01-14 Thread al ex
Is it possible to use current.T in routes.py, to recognize an incoming request based on current.T.current_language and reroute it to the correct controller / function? Can you give me an example using pattern-based routing? -- Resources: - http://web2py.com - http://web2py.com/book (Documentatio

[web2py] Fwd: https and rescr.it responsive image

2015-01-11 Thread al ex
myimage.jpg>" /> -- Forwarded message -- From: al ex Date: Mon, Jan 12, 2015 at 5:11 AM Subject: https and rescr.it responsive image To: web2py@googlegroups.com I am trying resrc.it (http://www.resrc.it/tutorials/preview) to manage responsive images. I use the scheme they sugge

[web2py] https and rescr.it responsive image

2015-01-11 Thread al ex
I am trying resrc.it (http://www.resrc.it/tutorials/preview) to manage responsive images. I use the scheme they suggest, on img tag: https://trial.resrc.it/s=w300m/https://mydomain/myapp/static/images/myimage.jpg"; /> where s=w300m is a paramter/value to get the image resized. This works fine w

Re: [web2py] Re: sublime text 3

2014-12-24 Thread al ex
I use Sublime Text 3 and installed Pakage Manager, SublimeLinter and Pylint as indicated in http://www.sublimelinter.com/en/latest/installation.html Then, in Sublime Text | Preferences | Package Settings | SublimeLinter | Settings - User I have set "linters" / "pylint" / "paths" as follows {

Re: [web2py] Re: Formatting SQLFORM.factory

2011-06-25 Thread al ex
Thank you. It worked, On Sun, Jun 26, 2011 at 11:22 AM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Try > > form=SQLFORM.factory( Field('address', label=T('Address')), > formstyle='table2cols') > > > > > On Jun 25, 11:59 pm, alex wrote: > > Hi all, > > > > In a SQLFORM.factory gene