[web2py] Embed Plotly Express in Web2PY

2024-01-25 Thread Jitun John
I would like to embed something on the following lines *import plotly.express as pxfig = px.line(df_dataframe, x="datetime", y="load_avg_fifteen")* show it in html page similar to ** At present I am using HighCharts js, but as I totally work on pandas dataframes.. I imagine it is far more

[web2py] Plotly Express Charts in web2py

2024-01-25 Thread Jitun John
I would like to embed something on the following lines *import plotly.express as pxfig = px.line(df_dataframe, x="datetime", y="load_avg_fifteen")* show it in html page similar to ** At present I am using HighCharts js, but as I totally work on pandas dataframes.. I imagine it is far more

[web2py] Re: Built-in helpers on session.flash

2021-07-29 Thread Jitun John
I can live without it as well. Just wondering .. should I give up. On Saturday, July 24, 2021 at 8:31:07 AM UTC+5:30 Jitun John wrote: > Thanks for the reply @Jim S > > session.flash = XML(CENTER(DIV(H4('sFTP Error: ' + ftp_error_parse(e)), >

[web2py] Re: Built-in helpers on session.flash

2021-07-23 Thread Jitun John
Thanks for the reply @Jim S session.flash = XML(CENTER(DIV(H4('sFTP Error: ' + ftp_error_parse(e)), HR(), 'FTP Address|Username|Login|Password may be not correct.', BR(), 'Check if the DropBox still

[web2py] Built-in helpers on session.flash

2021-07-23 Thread Jitun John
Hi, This piece of code worked in older version of web2py... session.flash = CENTER(DIV(H4('sFTP Error: ' + ftp_error_parse(e)), HR(), 'FTP Address|Username|Login|Password may be not correct.', BR(), 'Check if the DropBox still exists.',

[web2py] Re: SQLFORM.grid - Readable True, but hide the column in table

2021-07-19 Thread Jitun John
Excellent. Exactly what I wanted. Thanks a lot @cdbaron On Saturday, July 17, 2021 at 6:22:36 PM UTC+5:30 cdbaron wrote: > You should not use db.ftp_simplivity_log_db.log_path.readable = False > You have to use db.ftp_simplivity_log_db.log_path.listable = False > > If you want to cancel the

[web2py] Re: Loader/waiting indeterminate progressbar

2020-07-06 Thread Jitun John
. Tried reading the scheduler.. but an example would have helped get my head around it. It would be kind of someone to provide an example (if it is handy) Thanks a lot. On Friday, June 17, 2016 at 1:50:17 AM UTC+5:30, Dave S wrote: > > > > On Thursday, June 16, 2016 at 8:52:34 AM UTC-7

[web2py] ValueError: invalid literal for int() with base 10 for 'id' Field

2019-11-27 Thread Jitun John
Hi, Here is my code. *postgres_db = DAL("postgres://postgres@localhost:5432/" + get_postgres_db_filename(), auto_import=True, pool_size=10, migrate_enabled=False, fake_migrate_all=True)* "get_postgres_db_filename()" will get you "CaptureOutput-2019-11-15_03-25-19-MN" I have defined the

Re: [web2py] Web2py Windows edition with 3.x Interpreter

2019-03-12 Thread Jitun John
ded (I only have a Win box), >> plus testing everything. >> >> Cheers, >> Nico >> >> Il giorno mer 27 feb 2019 alle ore 11:45 elisha bere > > ha scritto: >> >>> Hie, >>> >>> Is it possible to change from 2.7 to 3.x in my web2py app >

[web2py] Re: Web2py Windows edition with 3.x Interpreter

2019-02-27 Thread Jitun John
Fixed the pickle issue by deleting "databases" folder in the app. Wondering if we will ever (if it is possible) to get a 3.x python version of web2py windows ("python37.dll" and "pywintypes37.dll" files.) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Web2py Windows edition with 3.x Interpreter

2019-02-17 Thread Jitun John
"It requires Python 2.6 (no more supported), Python 2.7 (stable) or Python 3.5+ (*recommended for new projects*) already installed on your system. There are also *binary packages for Windows* and Mac OS X.* They include the Python 2.7 interpreter* so you do not need to have it pre-installed."

[web2py] Divider in

2018-11-19 Thread Jitun John
web2py 2.16.1 broke LI(_class="divider"), in response.menu I followed Leonel Câmara, added BS4MENU in menu.py and "LI(_class='dropdown-divider')" in the response.menu but the navbar is lost. Just wondering if we have any way to add divider in menu. -- Resources: - http://web2py.com -

[web2py] Re: AttributeError: 'SQLite' object has no attribute 'file_open'

2017-09-01 Thread Jitun John
:47:39 UTC-5, Jitun John wrote: >> >> Hi Massimo, >> >> I have the 2.15.3 version installed, but the issue remains. >> I confirm the same code works on 2.14.6 >> >> >> >> <https://lh3.googleusercontent.com/-HVkJkUDVqYs/W

[web2py] Re: AttributeError: 'SQLite' object has no attribute 'file_open'

2017-08-29 Thread Jitun John
Hi Massimo, I have the 2.15.3 version installed, but the issue remains. I confirm the same code works on 2.14.6 On Sunday, August 13, 2017

[web2py] AttributeError: 'SQLite' object has no attribute 'file_open'

2017-07-15 Thread Jitun John
Here is a Code that worked fine on 2.14.6 but doesn't on 2.15.1 import datetime import gc import os from gluon import * from current_config import * from memory_profiler import memory_usage manager_rows = '' dummy_path = os.path.abspath('.') + '/applications/enLIGHTen/static/dummy/' def

[web2py] Re: google analytics

2016-07-02 Thread Jitun John
I think you can use as follows ## your http://google.com/analytics id response.google_analytics_id = 'UA-80XX-1' On Tuesday, May 6, 2014 at 9:14:26 PM UTC+5:30, lucas wrote: > > if we are using the analytics.min.js one, do we include the "UA-" in > the response.google_analytics_id string

[web2py] Loader/waiting indeterminate progressbar

2016-06-16 Thread Jitun John
>From the main page, once a form is submitted, there is heavy python code doing lots of steps which takes from seconds to minutes to finish. It then moves to the next page. Between the 2 pages, I am trying to see if there can be a indication on the HTML page indicating working in background.

[web2py] Re: Size of SQLFORM.grid items

2016-06-14 Thread Jitun John
erwritten for each >field using maxtextlengths, a dictionary of >'tablename.fieldname':length e.g. {'auth_user.email' : 50} > > Anthony > > On Monday, June 13, 2016 at 10:41:15 AM UTC-4, Jitun John wrote: >> >> >> <https://lh3.g

[web2py] Size of SQLFORM.grid items

2016-06-13 Thread Jitun John
Above is a simple SQL.grid I have used. I added "headers={'store_log_stats.cluster_name' : 'Cluster__Name'}," to make sure that the column

[web2py] Re: Rows not releasing all the memory back

2016-02-18 Thread Jitun John
Issue is kind of resolved. I created a dummy.. small sqlite file and read that sqlite the same way as large ones are done. and then do for row in some_rows.exclude(lambda row: row.id > 0) again. This tends to free up memory. -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: Rows not releasing all the memory back

2016-02-11 Thread Jitun John
I am using to remove rows... for row in alerts_rows.exclude(lambda row: row.id > 0): pass On Friday, February 12, 2016 at 5:49:38 AM UTC+5:30, Alfonso Serra wrote: > > You can try "del rows" to remove the reference from memory before > collecting > del a single row raises a TypeError but

[web2py] Re: Rows not releasing all the memory back

2016-02-09 Thread Jitun John
I believe it is caching everything to memory. Here is the code I have. But yes, not a web2py issue. def read_manager_rows(): manager_db_conn = DAL('sqlite://manager.sqlite', folder=get_current_path(), auto_import=True) global manager_rows manager_rows =

[web2py] Rows not releasing all the memory back

2016-02-04 Thread Jitun John
My application, basically parses log files and presents that using web2py So each flat file is read line by line and inserted to a sqlite file. I use a global variable rows to read complete sqlite files later and do various filters and present data. So after creating rows as a global variable,

[web2py] Re: using custom upload button when using SQLFORM

2016-01-02 Thread Jitun John
Hi Anthony, I would prefer the last option to replace the upload element. But even after reading "Server-side DOM and parsing" a few times I am unable to comprehend it. I guess we would like to replace with It would be kind of you to just give me an example of the code. Thanks a Lot. On

[web2py] Re: using custom upload button when using SQLFORM

2015-12-14 Thread Jitun John
Here is the Code from the Model defining the table db.define_table('logs_db', Field('case_num'), Field('case_desc'), Field('log_gen_time', writable=False, readable=False), Field('log_uniq_name', writable=False, readable=False,

[web2py] using custom upload button when using SQLFORM

2015-12-13 Thread Jitun John
I was trying to replace the Normal Upload button in {{form}} with a button with nice jquery Browse/File button I can see the view correctly, but the Submit button does not Submit the fields to the Database. Following is the code I am trying > > > > method="post"> > > > > >

[web2py] Need help with inno Plugin/Web2pyPackagingApp

2015-12-11 Thread Jitun John
Hi, I am using Web2pyPackagingApp to build a binary distribution of the app. I have searched for the"inno plugin" on the web.. but cant find anything. 1. Download and install the inno plugin into your web2py development environment. So I thought it might be the "inno.py" file provided in

Re: [web2py] Need help with inno Plugin/Web2pyPackagingApp

2015-12-11 Thread Jitun John
Thanks for the reply Massimiliano. You were correct. That needed a change. That brought up the myapp/default/inno interface. But it looks like the inno.py has lot more issues. Some files needed change Source: "tcl\*"; DestDir: "{app}\tcl"; Flags: ignoreversion recursesubdirs createallsubdirs

[web2py] Unable to make primary/unique

2015-12-10 Thread Jitun John
Hi, I am trying to create a table which accepts log files. One of the entries that should be unique is log path. No Duplicate entries. db.define_table('logs_db', Field('case_num', requires=IS_NOT_EMPTY()), Field('case_desc',), Field('log_gen_time',

[web2py] Re: Unable to make primary/unique

2015-12-10 Thread Jitun John
rm input with nice error messages displayed in the > form, you must use validators, documented in the Forms chapter. In this > case, you want requires=IS_NOT_IN_DB(...). > > Anthony > > On Thursday, December 10, 2015 at 12:58:28 PM UTC-5, Jitun John wrote: >> >> Hi, >>

[web2py] Re: Using apsw with web2py

2015-12-09 Thread Jitun John
lative import. > > Massimo > > > > On Monday, 7 December 2015 17:03:36 UTC-6, Jitun John wrote: >> >> >> Hi I am an amateur programmer and new to web2py. >> >> I have written python scripts with apsw imported. ( >> http://rogerbinns.githu

[web2py] Is it possible to use APSW or have a similar feature

2015-12-07 Thread Jitun John
Hi, I am new to web2py and am an amateur programmer. I have working python script with APSW imported. (http://rogerbinns.github.io/apsw/) I wanted to make use of the same script in web2py. But I guess I cannot import it in the module. (apsw works with 2.x version of python as well though)

[web2py] Using apsw with web2py

2015-12-07 Thread Jitun John
Hi I am an amateur programmer and new to web2py. I have written python scripts with apsw imported. (http://rogerbinns.github.io/apsw/) It allows me to create a db in the memory and once all processing/insertion is done, one can backup the date to an .sqlite file on the disk. This .sqlite file