[web2py] Experience with pywhatsapp, yowsup and web2py

2017-02-26 Thread Henk huisman
I have written an application in web2py that sends SMS messages from an agenda of an outpatient clinic to remind patients of their appointment. I am using Clickatell as provider and their API. Now I would like to extend this service to Whatsapp messaging. Is there anyone who has experience

[web2py] How to migrate with MySQL database?

2017-01-25 Thread Henk huisman
I want to migrate an application to another computer. The app's database is in MySQl. Could anyone explain me step by step how to perform this operation in Web2py? Thank's a lot Henk -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Re: Syntax question: db(db.mytable.id == request.post_vars["id"]).update(**{key:value})

2016-12-08 Thread Henk huisman
Thanks, I wrote this code and seems to work well...from an ajax call. Post is with or without id; depending on if its a new record or an update def save_selected(): a={} if request.vars["id"]: for key, value in request.vars.items(): if key!="id":

[web2py] Syntax question: db(db.mytable.id == request.post_vars["id"]).update(**{key:value})

2016-12-06 Thread Henk huisman
Is this correct syntax? if request.post_vars["id"]: > for key, value in request.post_vars.items(): > db(db.mytable.id == request.post_vars["id"]).update(**{key:value}) > > > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Best and simpler approach to Inline editing / deleting / appending (jqGrid, Jeditable,etc)

2016-08-29 Thread Henk huisman
Hi Clara, I have been looking for a powerful grid component too. Started using jqGrid. It's really nice and very powerful; I recommend it. Depends a bit on what license you looking for. For non-commercial organisations it's free. Henk > > > -- Resources: - http://web2py.com -

[web2py] Experiences with alternative starter app of Michael Beller

2016-07-31 Thread Henk huisman
I want to share some of my experiences of the last few days trying to get the alternative starter app of Michael Beller to work. It realy looks great and the templates by almsaeedstudio are very nice; it gives your site a professional feel and look. I used the latest version of the app that's

[web2py] Re: jqgrid Gurrido any experience

2016-05-18 Thread Henk huisman
Solved! In my controller that updated/deleted/added a row from the grid I changed the *return dict()* into just *return* Anyway, a very nice plugin. Op woensdag 18 mei 2016 21:30:27 UTC-4 schreef Henk huisman: > > jqgrid from Gurrido.net is a realy nice grid plugin. > > > I d

[web2py] jqgrid Gurrido any experience

2016-05-18 Thread Henk huisman
jqgrid from Gurrido.net is a realy nice grid plugin. I do not know what causes the issue I am having with a grid I have a jqgrid that works fine on my local development machine with web2py 2.14.3. The load and edit ajax functions all work fine. If I put the same application on a remote

[web2py] Re: web2py slices down

2016-04-24 Thread Henk huisman
Yes already 3 days down. Anybody home? Op zondag 24 april 2016 11:29:57 UTC-4 schreef luis.va...@metamaxzone.com: > > Web2py slices (http://www.web2pyslices.com/home) is down, shows a ticket > when try to access > > Internal errorTicket issued: unknown >

[web2py] Re: ckeditor error

2016-04-21 Thread Henk huisman
Hmm, buggy night 2 nite.. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] ckeditor error

2016-04-19 Thread Henk huisman
I installed ckEditor from the repository. When I try to use it with a simple SQLFORM like def test(): form = SQLFORM.factory( Field('requiredfield', required=True, notnull=True), Field('textfield', 'text', widget=ckeditor.widget) ) return dict(form=form) I

[web2py] generate menu web2pycookbook

2016-04-07 Thread Henk huisman
I am trying to replicate the example in the web2py cookbook on Creating a navigation bar (page 89) i.e. a menu based on rows in database table So I have build the model db.define_table('navbar', Field("title", type='string',length='25', notnull=True, required=True), Field("url", type='string',

[web2py] Re: Some help with computed field in a query

2016-04-05 Thread Henk huisman
Sometimes it's simple, just use the function *CONCAT('../rentals_manage/',rentals.id)* this is at least valid for the MySQl database I am using. So if I understand well If you are using the db.executesql statement the SQL you use must be specific for the database in the back? -- Resources:

[web2py] Some help with computed field in a query

2016-04-03 Thread Henk huisman
Could anyone show me how to build a query with a computed field that consists of a constant and a value of the ID of the records. The constant is an URL and the value is the ID of the row. I tried this (among several other attempts). rowsb=db.executesql("SELECT 'dikke bmw' as caption, startdate

[web2py] Re: DHTMLX javascript library

2016-03-27 Thread Henk huisman
Hi me again, It appears that the Timeline functionality that I was looking for is only included in the DHTMLX Pro Commercial Version which costs 490$. I have been looking into a lot of products for functionality to present resources with a scheduler/ timeline. So far I have only found

[web2py] Re: DHTMLX javascript library

2016-03-27 Thread Henk huisman
The view looks now as follows: {{extend 'layout.html'}} Example of scheduler scheduler.config.xml_date="%Y-%m-%d %H:%i"; scheduler.init('scheduler_here', new Date(),"month");

[web2py] Re: DHTMLX javascript library

2016-03-27 Thread Henk huisman
You're right. I changed the return in the controller to *return response.json(rows)* and now it works as expected. Thanx. Still... what to do with all that PHP the dataConnector is written in, in order to get data back tot the server Op zondag 27 maart 2016 07:56:15 UTC-4 schreef

[web2py] Re: DHTMLX javascript library

2016-03-26 Thread Henk huisman
I have been studying the documentation and forums of the DHTMLX javascript library a bit further. So it seems they are completely focussed on PHP for server side processing. Python is not on their horizon. I don't think it is worthwhile putting much more energy in this... Too bad. The client

[web2py] DHTMLX javascript library

2016-03-26 Thread Henk huisman
I am trying to use the DHTMLX javascript library in order to present and work with a resource/ timeline scheduler. see image. There are 2 methods to load data into the

[web2py] Re: Spreadsheet.py documentation and status

2016-02-10 Thread Henk huisman
Nice combo! web2py and w2ui. Looks great. Going to try it. Thanks for the link. Op maandag 8 februari 2016 23:35:41 UTC-3 schreef Rimantas Nedzinskas: > > Try this: > >> http://w2ui.com/web/demos/#!combo/combo-3 >> > -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Spreadsheet.py documentation and status

2016-02-06 Thread Henk huisman
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 are variables I stumbled in Github on a optional component spreadsheet.py written by Massimo Is

[web2py] Q4web2py

2016-02-04 Thread Henk huisman
As we are left to right readers in the western hemisphere, I want to build a form grid with variables as rows and e.g. dates as columns. This kind of representation is very common and usefull in for example medical applications where you want to see the longitudinal results of a test. Patient

[web2py] Re: Fancytree lazyload

2015-12-03 Thread Henk huisman
> > Solved the issue. > I found a post on http://salesforce.stackexchange.com/questions/41917/trying-to-implement-lazy-loading-with-fancytree It appeared that the format of the items in the

[web2py] Re: How to use fancytree?

2015-12-02 Thread Henk huisman
> > It does work! Mille Grazie! >>> >> Thanks DenesL and Anthony. -- 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

[web2py] Fancytree lazyload

2015-12-02 Thread Henk huisman
I am trying to use the javascript library Fancytree to generate a tree of an organization hierarchy. I manage to load the data in the tree to the first level of the organization with a JSON result dictionary. So I have a tree already. The rest of the children nodes I only want to load if

Re: [web2py] How to use fancytree?

2015-12-01 Thread Henk huisman
? Henk Op dinsdag 1 december 2015 04:30:21 UTC-3 schreef Johann Spies: > > On 1 December 2015 at 04:08, Henk huisman <huisman...@gmail.com > > wrote: > >> >> This is the code I tried: >> >> >> > "text/javascript"> >>

[web2py] How to use fancytree?

2015-11-30 Thread Henk huisman
Fancytree looks to me as a nice javascript library to generate trees ( https://github.com/mar10/fancytree/wiki). Unfortunatily I don't get it to work in Web2py. I just installed the libraries etc and copied some code from the examples websites, but the function fancytree doesnothing. This