[web2py] Re: web2py as a frontend for monitoring serial ports

2016-02-08 Thread Oliver Holmes
Thanks to you both. I should clear up a slight misunderstanding. I have written the part, where the serial port is read (using pyserial). I am now trying to figure out, how to connect this to web2py, so that it can serve the data nicely. It was my understanding, Massimo, that the scheduler was

[web2py] Re: Make certain fields hidden within a table. Custom form

2016-02-08 Thread Anthony
http://web2py.com/books/default/chapter/29/07/forms-and-validators#Conditional-fields On Monday, February 8, 2016 at 8:50:40 PM UTC-5, Ron Chatterjee wrote: > > Wondering if there is a way to keep certain fields within a table be > hidden based on checkbox entry in a field. For example, in the ta

Re: [web2py] web2py as a frontend for monitoring serial ports

2016-02-08 Thread Massimo Di Pierro
You can use this module https://pypi.python.org/pypi/pyserial but as I understand it reading the post if a blocking operation and it may not be threadsafe. You should not call it from the web app itself. You should created a separate service that reads the serial post and writes the results in a

[web2py] Re: Spreadsheet.py documentation and status

2016-02-08 Thread Massimo Di Pierro
don't. Use handsontable.js On Saturday, 6 February 2016 15:04:38 UTC-6, Henk huisman wrote: > > I am looking for a way to visualize and enter/update longitudinal data > (see my post Q4Web2Py). > A tabular/ grid like feature where the columns are the records of a > database table and the rows ar

[web2py] Re: learning curve?

2016-02-08 Thread Massimo Di Pierro
It depends. what does the data look like? On Monday, 8 February 2016 20:35:41 UTC-6, Literate Aspects wrote: > > I tried django ... to discover HUGE learning curve > I tried Qt ... to discover moderate learning curve > > I can amateur code in VBA and want to transfer that same code function to >

[web2py] Re: Web2py-appreport

2016-02-08 Thread Massimo Di Pierro
do not know. Can you post this plugin? I have never seen it. Perhaps assumes a library that is not installed. On Monday, 8 February 2016 02:24:38 UTC-6, Anthony Smith wrote: > > Hi Massimo, > > Tried that and now getting this error > > 1. > 2. > 3. > 4. > 5. > 6. > 7. > 8. > 9. > 10. > 11. > 1

[web2py] Re: Q4web2py

2016-02-08 Thread pang
You need to edit the values, no? If the values are all numeric, then handsontable will work. I posted one example here: http://www.web2pyslices.com/slice/show/2042/handsontable-plugin-for-a-spreadsheet I modified that code sample to paginate the results and a few other minor things, but you'll g

[web2py] learning curve?

2016-02-08 Thread Literate Aspects
I tried django ... to discover HUGE learning curve I tried Qt ... to discover moderate learning curve I can amateur code in VBA and want to transfer that same code function to a webapp with database. My question, how many hours or days or months would it take to develop a simple application tha

[web2py] Re: Spreadsheet.py documentation and status

2016-02-08 Thread Rimantas Nedzinskas
Try this: > http://w2ui.com/web/demos/#!combo/combo-3 > -- 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 subscr

[web2py] How to set default country in dropdown list

2016-02-08 Thread Winter Kryz
Hello everybody, I am new in web2py, I have 2 tables called 'Nationalities' and 'Person' db.define_table('Nationalities', Field('description', 'string'), common_filter = lambda query:db.Nationalities.description != 'United States', format='%(descri

[web2py] File picker

2016-02-08 Thread Heinrich Piard
Hi all, does anyone have an example of a web button which allows me to browse through the local file system on the web server to pick a file? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/we

[web2py] A dropdown box that filters.

2016-02-08 Thread superpirst
I created a website that you could post items and I'm having a lot of problem trying to figure out how to make a dropdown menu that can filter those posts. What I'm trying to do is that when you make a post, you can only pick from the 4 categories. Then in the main page, you will have a drop do

[web2py] upload fields and curl

2016-02-08 Thread Dave S
Loose end from https://groups.google.com/d/msg/web2py/CPcbgpK_6Ho/RBjXSMMwGAAJ>: I have an upload field, and 1 controller to upload to it via SQLFORM and 1 controller to access it via REST. Using the SQLFORM, the local filename is included in the file data (as seen in the JSON-like representat

[web2py] Make certain fields hidden within a table. Custom form

2016-02-08 Thread Ron Chatterjee
Wondering if there is a way to keep certain fields within a table be hidden based on checkbox entry in a field. For example, in the table below, I would like the Budget field to be hidden until someone click on weekly checkbox in frequency field. In other words, Budget fields doesn't show up in

Re: [web2py] web2py as a frontend for monitoring serial ports

2016-02-08 Thread Marcelo Theodoro
An web application will not have access to your serial port. Unless there's some kind of module/dll for that. I think the easiest way to do that is writing a script that you will run local in your machine and send the data to web2py through a post/get request. To send the data to an web application

[web2py] Re: Ways to make AJAX tab panel?

2016-02-08 Thread Ron Chatterjee
Does the tabbed panel works with grid? I noticed something strange. For example if I place a grid in panel one and another grid in panel 2. grid2 will end up going to panel one. Regardless those tables are referenced in the model or not. For example. If my view is as shown below. These grids (

[web2py] Re: need help connecting to a second database for a copy of application

2016-02-08 Thread Val K
Hi! 1. I believe one pg-install=one pg-server 2. I think that pg listens only one port until you set another one and restart server Why do you think you have to have another pg-server? One pg-server can services many databases - just use different names for DAL, i.e. db=DAL() db1=DAL() to c

[web2py] Re: how to make a reference field readonly ?

2016-02-08 Thread Anthony
You might consider the auto-complete widget. Anthony On Monday, February 8, 2016 at 2:55:38 PM UTC-5, Pierre wrote: > > problem is I want to input the reference field as its string > representation nor as an integer > > with this : > > db.define_table('trux', > Field('tuser', 're

Re: [web2py] Re: ubuntu web2py

2016-02-08 Thread Niphlod
there's this too http://uwsgi-docs.readthedocs.org/en/latest/Systemd.html On Monday, February 8, 2016 at 9:25:31 PM UTC+1, Jim S wrote: > > You're right, shouldn't be hard. But, for me it is. > > I'll post back if I can get it working... > > -Jim > > On Monday, February 8, 2016 at 10:06:36 AM UT

[web2py] Re: OFF TOPIC: Collaborative data modeling environment

2016-02-08 Thread Val K
It seems you haven't Python installed on your comp (Python isn't windows standard), you can try to use web2py/py.exe to process python-files On Monday, February 8, 2016 at 11:14:35 PM UTC+3, Alex Glaros wrote: > > looks like what I need Val > > can you direct me in how to run it? > > I typed Ma

Re: [web2py] Re: ubuntu web2py

2016-02-08 Thread Jim S
You're right, shouldn't be hard. But, for me it is. I'll post back if I can get it working... -Jim On Monday, February 8, 2016 at 10:06:36 AM UTC-6, Niphlod wrote: > > shouldn't be hard > > https://wiki.ubuntu.com/SystemdForUpstartUsers > > On Monday, February 8, 2016 at 5:02:33 PM UTC+1, Jim S

Re: [web2py] Embedding Rapydscript

2016-02-08 Thread Val K
I think that scheduler is designed for asynchronous tasks, but I want to see changes effect immediately after edit/save pyj-file(s) and update web page. So, all pyj-files must be checked for out-of-date and recompiled (if there is anyone) per request call. I believe that cool IDEs allow doing t

[web2py] Re: OFF TOPIC: Collaborative data modeling environment

2016-02-08 Thread Alex Glaros
looks like what I need Val can you direct me in how to run it? I typed Mariano's extract_pgsql_models.py command line in a windows machine and got:'python' is not recognized as an internal or external command, operable program or batch file. thanks Alex -- Resources: - http://web2py.com - h

Re: [web2py] Re: DAL is dropping column when not supposed to

2016-02-08 Thread Niphlod
do a pack all, install the app, run pg_restore, don't run any code. set fake_migrate_all=True, hit appadmin, set fake_migrate_all=False. voilĂ . On Monday, February 8, 2016 at 7:11:06 PM UTC+1, Alex Glaros wrote: > > no, I did not compile. > > Postgres changes created by DAL work correctly on site

[web2py] Re: how to make a reference field readonly ?

2016-02-08 Thread Pierre
problem is I want to input the reference field as its string representation nor as an integer with this : db.define_table('trux', Field('tuser', 'reference auth_user')) db.trux.tuser.requires=IS_IN_DB(db, 'auth_user.id','%(username)s') I get a string from a dropdown howewer wi

[web2py] Re: web2py UnicodeDecodeError: 'utf8' codec can't decode byte 0xc7 in position 15: invalid continuation

2016-02-08 Thread Val K
Hi! I had a similar problem with MS Access. Error like this means that your database encoding isn't utf-8, you should figure out which is it? After that, you can try to set db_codec to proper encoding (see DAL signature in the web2py book) On Thursday, February 4, 2016 at 5:52:02 PM UTC+3, F

Re: [web2py] Re: DAL is dropping column when not supposed to

2016-02-08 Thread Alex Glaros
Postgres changes created by DAL work correctly on site #1 local machine. They only do not work on site #2 when I copy the app from site #1. Could the problem be how I transfer the development to site #2? On site #1 I do a "pack all" in web2py, and a "pg_dump" on Postgres. Then at site #2, I d

[web2py] Re: how to make a reference field readonly ?

2016-02-08 Thread Anthony
On Monday, February 8, 2016 at 9:19:44 AM UTC-5, Pierre wrote: > > > I meant disable the dropdown and let the user input something > It gets a default IS_IN_DB validator, which results in a drop-down being generated by default. You can override that by putting the validator into a list (either u

Re: [web2py] Re: ubuntu web2py

2016-02-08 Thread Jim S
I played with this a bit over the weekend but was unable to get it working on Ubuntu 15.x. My production servers all run 14.4. I think the problem is the change from upstart to systemd on Ubuntu. Does anyone have experience getting uwsgi to start using systemd? I don't know enough about thes

Re: [web2py] Re: ubuntu web2py

2016-02-08 Thread Niphlod
shouldn't be hard https://wiki.ubuntu.com/SystemdForUpstartUsers On Monday, February 8, 2016 at 5:02:33 PM UTC+1, Jim S wrote: > > I played with this a bit over the weekend but was unable to get it working > on Ubuntu 15.x. > > My production servers all run 14.4. > > I think the problem is the c

[web2py] Re: Query for mutually linked id's

2016-02-08 Thread Niphlod
see http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Self-Reference-and-aliases On Monday, February 8, 2016 at 2:52:46 PM UTC+1, Annet wrote: > > I defined the following table: > > db.define_table('edg_edge', > Field('fromID', 'reference vtx_vertex''), > Field(

[web2py] Re: how to make a reference field readonly ?

2016-02-08 Thread Pierre
I meant disable the dropdown and let the user input something -- 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 s

[web2py] Re: how to make a reference field readonly ?

2016-02-08 Thread Pierre
I didn't think of this combination.I put these in a controller/function and it works !!! Is there a way to disable the drop down menu associated to a reference field ? thanks Anthony.it would be too painful without the forum -- Resources: - http://web2py.com - http://web2py.com/boo

[web2py] Query for mutually linked id's

2016-02-08 Thread Annet
I defined the following table: db.define_table('edg_edge', Field('fromID', 'reference vtx_vertex''), Field('toID', 'reference vtx_vertex'), Field('label', length=128), migrate = False) I have the following query: rows = db(edg_edge.toID==vertexID).select() What I would like to k

Re: [web2py] Re: disk cache behind IIS

2016-02-08 Thread Niphlod
ps: for anything in production, go redis. On Monday, February 8, 2016 at 2:26:33 PM UTC+1, Niphlod wrote: > > nope, it won't > > On Monday, February 8, 2016 at 3:19:01 AM UTC+1, Tim Richardson wrote: >> >> I guess, for completeness sake, that cache.ram would not be shared among >> the IIS process

Re: [web2py] Re: disk cache behind IIS

2016-02-08 Thread Niphlod
nope, it won't On Monday, February 8, 2016 at 3:19:01 AM UTC+1, Tim Richardson wrote: > > I guess, for completeness sake, that cache.ram would not be shared among > the IIS process pool. > > On 7 February 2016 at 20:25, Niphlod > > wrote: > >> if for "disk cache" you mean "cache.disk" yes, it's

[web2py] Re: Yellow box on screen following update

2016-02-08 Thread M Bailey
> > > Thanks guys, appreciate the feedback. -- 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 G

[web2py] web2py as a frontend for monitoring serial ports

2016-02-08 Thread Oliver Holmes
Hi, I'm new to web2py and quite frankly to python as well, so please bear with me ;) I would like to use web2py to serve data, that it has gathered and processed from the serial port. There is new data available once a second. Obviously I'll have to use the scheduler, to accomplish reading and

Re: [web2py] Re: DAL is dropping column when not supposed to

2016-02-08 Thread Anthony
Is your app compiled? If so, changes you make to the .py files will have no effect unless you remove the compiled files. Anthony On Monday, February 8, 2016 at 2:58:25 AM UTC-5, Alex Glaros wrote: > > okay, just tested on PythonAnywherre and it works perfectly as Anthony and > the manual descri

Re: [web2py] Embedding Rapydscript

2016-02-08 Thread Michele Comitini
Very nice. Did you evaluate running compile_pyjs() as a web2py's scheduler task? It could simplify your code and make it more resilient. 2016-02-08 0:20 GMT+01:00 Val K : > Hi! > Coding Python with switching to coding JS - really painful. > So, I tried Rapydscript (RS) and I like it very much! U

[web2py] Re: Web2py-appreport

2016-02-08 Thread Anthony Smith
Hi Massimo, Tried that and now getting this error 1. 2. 3. 4. 5. 6. 7. 8. 9. 10. 11. 12. 13. Traceback (most recent call last): File "/home/tony/web2py/gluon/restricted.py", line 227, in restricted exec ccode in environment File "/home/tony/web2py/applications/reports/models/plugin_app