Re: [web2py] Embed Plotly Express in Web2PY

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')

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

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

[web2py] test message

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

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:

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

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

Re: [web2py] Re: left outer join

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:

[web2py] left outer join

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

Re: [web2py] Re: Not my type

able to tell the version by the startup message. If you are > actually running Python 2 and the code fails, copy and paste the actual > error message you get and we'll puzzle it out. > > Warm regards, > Joe > > > > > On Friday, March 29, 2019 at 7:32:52 AM UT

[web2py] Not my type

Hi folks, if you'll pardon the corny title, I am brand new to web2py (so excited to discover it) and I'm just working may way through the book. In Chapter two, the section on types, I tried to run the examples, but I got error messages. Googling around it seemed to work better if I went one of

Re: [web2py] Autocomplete widget match middle of word

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,

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

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 times is_a and is_b

[web2py] multiple SUM IF in a single DAL

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 -

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

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

Re: [web2py] new style of welcome app

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

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

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,

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

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) > -

Re: [web2py] Re: pdf output of web2py-book app

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

[web2py] pdf output of web2py-book app

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

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

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 <abasta...@gmail.com> <abasta...@gmail.com> R

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

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,

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

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

[web2py] internationalization of url

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

Re: [web2py] internationalization of url

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 tha language is spanish, it returns the url as domain/text-in-spanish

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

/ctr/fnc', r'/AAA'), ) 2015-02-02 11:23 GMT+01:00 al ex a22...@gmail.com: 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

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

: invalid request On Mon, Feb 2, 2015 at 7:50 PM, Michele Comitini michele.comit...@gmail.com 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 ex a22...@gmail.com: I have setup this route in /web2py/applications

[web2py] How to mimic routes.py with nginx

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

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

[web2py] https and rescr.it responsive image

I am trying resrc.it (http://www.resrc.it/tutorials/preview) to manage responsive images. I use the scheme they suggest, on img tag: img src= 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

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

/static/images/myimage.jpg / -- Forwarded message -- From: al ex a22...@gmail.com 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

Re: [web2py] Re: sublime text 3

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

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 a22...@gmail.com wrote: Hi all, In a SQLFORM.factory

[web2py] Multiple uploads in single form?

Hello, I'm new to web2py, and I do not know how to do multiple file uploads in a single form. For example, the loading of multiple images. If a simple model of the following fields: db.define_table ('img', Field ('title'), Field ('img', 'upload'), ) What exactly should I write in the controller

[web2py] Re: Multiple uploads in single form?

I was hoping to find some recipe like django tabularinline or other ready-made widgets...

[web2py] Re: Multiple uploads in single form?

Thank you, I know about him. But I could not get it to work.

[web2py] Many To Many Select

has a set containing the rows of link_table that contain the entries of table2 that I want. But I can't figure out how to leverage that set into a shorter query. Thanks, Al

[web2py] Re: Many To Many Select

Ah, belongs() + a clever select SQL. Thanks. Al On Jun 29, 7:04 pm, mdipierro mdipie...@cs.depaul.edu wrote: If I understand: for row in db(db.link_table.table1==r.id) (db.table2.id==db.linked_table.table2).select(db.table2.id,db.table2.other)­:     print row.id, row.other if no double

[web2py] SEO

Hi, I have built my web site, now how does web2py enable people be able to find it? is there any helper function or built-in variables which I can use? Also in my SQLite database, there is a column called keywords which I like to be indexed, is there any simple SEO techniques I can follow? Al

[web2py] Re: Displaying Foreign Key

Would this work in GAE which does not handle table join? or the DAL automatically handle this for you? -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group,

[web2py] Re: Relase of the first HL7 based on web2py framework

Is there a data model of this demo? -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more

[web2py] Re: Migrating web2py to GAE

Thanks mdipierro. It is indeed the URL causing the problem, as it defaults to localhost rather than 127.0.0.1 when I click the Browse button after Run. I did not realise the code inside appadmin.py actually checks for 127.0.0.1. Now I can really troubleshoot myownapp to make it work on GAE Al

[web2py] Re: custom validation problem

thank you all I will try me best I hope I can fix it Kind Regards On Mar 17, 2:52 pm, Mengu whalb...@gmail.com wrote: to your console. On 17 Mart, 13:41, mohammed al-moustady mohd.moust...@gmail.com wrote: thank you hamdy but it is irrelevant to the code. BTW mdipierro do you

[web2py] Re: Migrating web2py to GAE

Change the port does get me to the welcome screen on the local GAE, click into admin interface gives admin is disabled because insecure channel; if I change http to https then it gives me Secure Connection Failed: SSL received a record that exceed the max possible length: Could some one share

[web2py] Re: Migrating web2py to GAE

Sorry I forgot to post the console error for the previous message: *** Running dev_appserver with the following flags: --admin_console_server= --port=8012 Python command: /usr/bin/python2.5 INFO 2010-03-18 13:30:11,558 dev_appserver_main.py:399] Running application myownapp on port 8012:

[web2py] Re: custom validation problem

. On Mar 16, 3:39 am, mohammed al-moustady mohd.moust...@gmail.com wrote: here is my db.py db.define_table('time_table',     Field('time_in','time'),     Field('time_out','time') ) db.define_table('years',     Field('year_number','string') ) db.define_table('buildings

[web2py] Re: gae appadmin

/af65b49a747bfd38?lnk=gstq=gae+migrate#af65b49a747bfd38 Al On Mar 17, 12:16 pm, mattynoce mattyn...@gmail.com wrote: hi, i've looked at some posts but can't seem to make this work. i can get appadmin to work on my local version of gae launcher (on a mac), but when i upload it, i can't get

[web2py] Re: custom validation problem

thank you hamdy but it is irrelevant to the code. BTW mdipierro do you mean print statement in the code itself? I thought it was s special function.. ok even If I do these print statements were would it print to? On Mar 17, 10:16 am, hamdy.a.farag hamdy.a.fa...@inbox.com wrote: Hi Mohammed,

[web2py] Re: Migrating web2py to GAE

The appadmin can be run on GAE, but it cannot run on local GAE SDK. (note: I have been thinking it might due to some basic settings, not just my code, which I have overlooked, as running T3 and C.R.M appliances have the same problem). I have customised myapp according to the web2py manual to suit

[web2py] custom validation problem

here is my db.py db.define_table('time_table', Field('time_in','time'), Field('time_out','time') ) db.define_table('years', Field('year_number','string') ) db.define_table('buildings', Field('b_number','string') ) db.define_table('levels', Field('l_number','string') )

[web2py] Deploy web2py on Mac

Hi, Can anyone advise how I can setup web2py to start automatically when the machine is turned on? i.e the services should all be started without having to login. How can that be done with plist and startup items? Cheers Al -- You received this message because you are subscribed to the Google

[web2py] Setting up Apache with SSL

Hi, Has anyone deploy apache with SSL for web2py successfully? All the scripts available seems to be linux oriented. Al -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe

[web2py] Re: How to deploy my first app

Brian, Finally I found the mistake which causes all this trouble in accessing the non-admin pages, I had the following line in the default.py in myapp: return dict(form=form, images=images, admin = admin) On Feb 22, 6:11 am, Brian M bmere...@gmail.com wrote: Al, I setup a stunnel server

[web2py] Re: How to deploy my first app

home page of myapp. As for the Mac, what you mentioned was correct, I installed the stunnel 4.27_0 package using macports, but the executables are in the / opt/local/bin are called stunnel and stunnel3. Haven't got time to solve this yet... Cheers Al On Feb 22, 6:11 am, Brian M bmere...@gmail.com

[web2py] Not sure how stunnel works with web2py

up stunnel, but when I run sudo stunnel3 I got the following error: inetd mode must define a remote host or an executable Anyone familiar with mac can give some tips on how to solve this Cheers Al -- You received this message because you are subscribed to the Google Groups web2py-users group

[web2py] Re: How to deploy my first app

to remove. I also have another mac which I tried to set up stunnel, but when I run sudo stunnel3 I got the following error: anyone familiar with mac can give some tips on how to solve this: inetd mode must define a remote host or an executable Cheers Al On Feb 12, 8:09 am, Brian M bmere...@gmail.com

[web2py] Re: How to deploy my first app

download and run this:http://web2py.googlecode.com/hg/scripts/setup-web2py-ubuntu.sh It will setup everything for you behind a single apache server. I think this easier than rails actually. Massimo On Feb 10, 9:27 am, Al albertsec...@gmail.com wrote: Hi, Now that I get my secure channel

[web2py] How to deploy my first app

to me or point me to the right documentations. Thanks. Cheers Al -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr

[web2py] Re: admin access from remote machine

kept getting some tickets, I must have deleted more than what is required. Al -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py

[web2py] Re: admin access from remote machine

I tried to follow the instructions on http://www.web2py.com/AlterEgo/default/show/140, but on the second step I get an error: Unable to load config info from /usr/local/ssl/openssl.cnf when creating the certificate Was the instruction meant for linux/Mac OS X? Any advise? Al On Feb 2, 11:37 pm

[web2py] admin access from remote machine

- e.g, commenting a few lines of codes. As the person who will be doing some data entry into my application cannot sit close to the windows server, so I am kind of stuck. Al -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send

[web2py] Search function

function (ajax, controllers, views, etc), I have spent the whole day and can't get it to work. I just want to search on two fields - Title and Keywords of a table - a generic search would also be good if the performance is not too bad Al -- You received this message because you are subscribed

[web2py] Re: admin access from remote machine

I have not integrate it with the w2k3 server, I just click the web2py.exe and run the built-in server. Do I need to start the server in a special way so that I can use https to gain admin access? Any setting I have to twist in this Cherry web server? Al -- You received this message because you

[web2py] Re: admin access from remote machine

I did try https but also with no success. Also querying the port of this server (using portqry) gives NOT LISTENING. If the web2py built- in server is running on port 8000, why does it say not listening? -- You received this message because you are subscribed to the Google Groups web2py-users

[web2py] Reading JSON file every minute

a lot of magic functions which can be used to make things a lot simpler than other framework or languages. Cheers Al -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from