[web2py] execute python script

2018-03-28 Thread ArtDijk
LS, I've written a print to pdf python script. How can I execute this script via a button on a web2py screen? -- 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)

[web2py] Re: legacy sqlite only shows id field in appadmin

2017-04-12 Thread ArtDijk
Thanks Anthony for your time. I doesn't work with the new hit line. I wrote some simple code to print the columns of a dataframe and then some minor manual work. The tables are defined and now I get (an obvious) error table exist. Yes that normal with a legacy db is used. What to do ? Arthur --

[web2py] Re: legacy sqlite only shows id field in appadmin

2017-04-12 Thread ArtDijk
Thanks Anthony. I'm surprised there is no working solution for this. I try to prevent the need to define all 250+fileds by hand... In DB Browser for SQLite I have the SQL statement to create this db. Is it possible to create the DAL database definitions with a SQL statement ? -- Resources: - http

[web2py] legacy sqlite only shows id field in appadmin

2017-04-12 Thread ArtDijk
Hi, I use a sqlite db which is build by another pyhton app. The table has 254 fields and one id field. I define the db via the output of extract_sqlite_model.py (a script of web2py). legacy_db = DAL('sqlite://story.sqlite') legacy_db.define_table('inbox_encrypted', migrate=False) #

[web2py] Column width and row height in smartgrid

2017-01-25 Thread ArtDijk
LS, I have long text field in one column. Is it possible to set word-wrap in the column ? Additional a variable row height (based on the number of text lines) would be very nice. It can be seen at work here: https://datatables.net/examples/basic_init/zero_configuration.html If you reduce the wi

[web2py] Survey app (that allows the user to go offline to answer the survey)

2015-11-11 Thread artdijk
LS, How feasible is it to make a survey app as web page that uses local storage on the client to store the page and the answers ? The case description is: The client goes to the survey webpage. The webpage is stored in local storage. The user completes the survey whenever he wants no matter if h

[web2py] Re: javascript problem (in load called via response js)

2015-01-07 Thread ArtDijk
I see via the browser network activities that jqx-all.js is loaded. It is located in the static/js folder. The json file does not contain a singlequote. I hardcopied the json into a html page with this grid and that worked ok. -- Resources: - http://web2py.com - http://web2py.com/book (Documen

[web2py] javascript problem (in load called via response js)

2015-01-06 Thread ArtDijk
Via a response after a form selection I call: response.js = "jQuery(web2py_component('%s','graph3'))" % ( URL('graphs', 'graph3') ) then in: def graph3(): left out some code ... ... json format is tested and OK ... df_drill_asr_to_json = df_drill_asr.to_json(orient='records',

[web2py] Re: response.js leads to error

2015-01-06 Thread ArtDijk
I tweaked a bit and problem is gone...(for the time) Op zaterdag 3 januari 2015 19:30:31 UTC+1 schreef Anthony: > > Your code doesn't show any use of response.js. In any case, what leads you > to believe response.js is related to the problem? -- Resources: - http://web2py.com - http://web2py.co

[web2py] Re: response.js leads to error

2015-01-03 Thread ArtDijk
Don't know. Rephrased the title. -- 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] response.js leads to error

2015-01-03 Thread ArtDijk
LS I have an index page with a table wit 2 columns and 3 rows. (form1, graph1, form2, graph2, form3, graph3) In the top left cell I select some data (type, month etc) In the top right a graph is shown (bokeh Bar chart) In the left middle cell I select a values from the index from the graph. Th

[web2py] Kendo UI

2014-10-25 Thread ArtDijk
LS We are developing a kind of business application. The standard w2p application user interface is not rich enough for our needs. We nee more widgets. Kendo UI seems a nice jQuery based JS framework. Our questions: 1. Do you consider Kendo ui a suitable choice taking into account features versu

[web2py] load file from folder

2014-04-07 Thread ArtDijk
I want to do some pandas analysis on a csv. I've manually put the file in the '/static' folder. Later I want to show a plot based on the analysis. What should be the correct syntax to load the csv file in the default.py ? Thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documen

[web2py] Use of Upper- and Lower case in table and field definitions

2014-02-05 Thread ArtDijk
LS, We noticed issues with Upper and Lower case field and table defintions. It looks that when we use web2py in combination with postgres all table and field names must be in lowercase. Is it correct that when using postgres and table and field definitions must be in lowercase ? Is this also t

[web2py] DAL Function in select

2014-02-05 Thread artdijk
How can we make this to work: group = math.floor(x/25) rows = db("table").select(group, y, groupby = group) The above throws an exeption: funtion has no attribute type. Ultimately we would like to group on a numeric value that is in a range. e.g. group the records for x >0 and <500 and for x >

[web2py] How can you put computed fields in select statements and specifically groupby ?

2014-02-05 Thread artdijk
Consider the following query rows = db(db.table).select(x,y groupby = x) If x and y are table fields this obviously works. Now consider group = x/100 rows = db(db.table).select(group,y, groupby = group) This also works nicely and will group into groups for each x with a value of x divided by

[web2py] Matplotlib webagg in web2py

2014-01-07 Thread ArtDijk
Hi, I want to do data analysis in pandas and show results via web2py to managers. Is it possible to use the new webagg from matplot lib in web2py ? http://matplotlib.org/users/whats_new.html?highlight=webagg#backends If the answer is yes can you show an example ? Thanks very much Art -- Resour

[web2py] Application GUI

2013-05-10 Thread ArtDijk
I want to develop a business web app. I want the user interface (gui) to be like a windows interface more or less the same as the app windows version build with qt (pyside). What gui library do I need ? Thanks Arthur -- --- You received this message because you are subscribed to the Google G

[web2py] User application GUI

2013-05-10 Thread ArtDijk
LS I (am new and) want to develop a web business application. The user interface (gui) should look like a windows application, just like the pyside app I've build. How can this be done ? What library should I use ? Do you know of an example ? This library shows that it is possible. Can this libr