[web2py] GAE list:integer fields on v2.10.4 and beyond

2015-05-27 Thread Donald McClymont
I am having major problems using Google App Engine with v2.10.4 as I use a number of list integer types field types. It seems the only way to get zero to be stored as a value on a list integer field is to send it as a character string eg ['0','0','0'] - surely it should be possible to send

[web2py] Datetime fields in 2.11.0 Alpha

2015-05-27 Thread Donald McClymont
I am getting an error on form validation of a datetime field with latest version. Error is must be -MM-DD HH:MM::SS! Note there are two colons between MM and SS which I am assuming is part of the problem - but I can't readily see how to fix it. Regards Donald -- Resources: -

[web2py] Initialise a list integer field with zeros on GAE with 2.10.4

2015-05-27 Thread Donald McClymont
It seems the following field definition in a model file doesn't currently work with GAE - however it is fine on SQLite? Field('questcounts','list:integer',default=[0, 0, 0, 0, 0], I think I can work around it by sticking an extra element that I don't use at the end and giving it a value.

[web2py] Appconfig - what's the best way to handle missing values

2015-10-24 Thread Donald McClymont
I like the appconfig file approach however I am not clear if there is a recommended approach to handling missing values in the file. It seems reasonable and convenient that you might want to update the code and the appconfig separately and use a default value if the key isn't present.

Re: [web2py] Re: Enabling Google Sign-In

2015-10-24 Thread Donald McClymont
It is on github at https://github.com/bnmnetp/w2p-social-auth but doesn't appear to be getting maintained. I agree it would be good if it was more promoted - it seems to work but is using version 0.1.24 or so of psa which is a good bit behind latest version - but it seems to work fine with

[web2py] Re: conditional fields with jquery and form fields

2015-12-23 Thread Donald McClymont
I guess if you are always wanting to show or hide the next 5 rows of the form then it would be possible to build a less repetitive function that does this and probably possible to make it accept a parameter rather than 5 which might mean it is a bit more flexible. In general the change event

[web2py] Re: Python Social Auth - example site working with downlevel version of PSA

2016-06-06 Thread Donald McClymont
his point. > > -- Joe > > > On Sunday, June 5, 2016 at 3:08:23 PM UTC-7, Donald McClymont wrote: >> >> I would really like some progress on this - however I have extremely >> limited knowledge of both auth and Python Social Auth so was rather hoping >> some

[web2py] Re: Python Social Auth - example site working with downlevel version of PSA

2016-06-10 Thread Donald McClymont
that do could perhaps chip-in with suggestions on where this should be heading and how it should be properly tested that would be appreciated. Donald On Monday, June 6, 2016 at 10:43:18 PM UTC+1, Donald McClymont wrote: > > Sounds good - possibly worth trying to contact someone on the ps

[web2py] Re: Python Social Auth - example site working with downlevel version of PSA

2016-06-05 Thread Donald McClymont
auth should > handle Google authentication in addition to Facebook and Twitter. I need > these three in addition to web2py logon for my application. Have you seen > any progress on this front? We may have to collaborate and do it ourselves. > > -- Joe > > On Monday, March 7,

[web2py] Re: Python Social Auth - example site working with downlevel version of PSA

2016-06-23 Thread Donald McClymont
planning to do much more with this unless there are issues or suggestions on what needs done next. Regards Donald On Friday, June 10, 2016 at 9:49:05 PM UTC+1, Donald McClymont wrote: > > I have now forked and pruned w2p-social-auth at the following: > https://github.com/DonaldMcC/w

[web2py] Re: Python Social Auth - example site working with downlevel version of PSA

2016-06-23 Thread Donald McClymont
On Friday, June 10, 2016 at 9:49:05 PM UTC+1, Donald McClymont wrote: > > I have now forked and pruned w2p-social-auth at the following: > https://github.com/DonaldMcC/w2p-social-auth basically only two changes > of substance: > > 1 It now uses appconfig to store the keys i

[web2py] Python Social Auth - example site working with downlevel version of PSA

2016-03-07 Thread Donald McClymont
I am sharing an example site http://www.netdecisionmaking.com that uses Python Social Auth for authentication, based on the following code and https://github.com/omab/python-social-auth and the web2py integration developed at https://github.com/bnmnetp/w2p-social-auth

[web2py] Re: Bootstrap datepicker plugin

2016-07-06 Thread Donald McClymont
This is nice and a great improvement for dates. I thought I could easily replicate for datetime by using this which seems to be a fork of the original to allow time input as well http://www.malot.fr/bootstrap-datetimepicker/demo.php?utm_source=siteweb_medium=demo_campaign=Site%2BWeb

[web2py] Re: Bootstrap datepicker plugin

2016-07-06 Thread Donald McClymont
if there is a better way. /* To revernt font 2em in web2py calendar component */ .hour, .minute {font-size: 14px;} On Wednesday, July 6, 2016 at 1:17:59 PM UTC+1, Donald McClymont wrote: > > This is nice and a great improvement for dates. I thought I could easily > replicate for datetime

[web2py] Re: Customize multiselect widget

2016-08-16 Thread Donald McClymont
I have got something like this working - basically based on the hradio widget which was developed by s-cubism so I define a widget in a module along the following lines: def hcheckbutton_widget(field, value, **attributes): rows = SQLFORM.widgets.checkboxes.widget(field,

Re: [web2py] Which file to upload an analytics platform?

2017-01-26 Thread Donald McClymont
I don't think there is any overall pythonanwhere rule to use init. I have sites on pythonanywhere and no init folder. Donald -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

Re: [web2py] Which file to upload an analytics platform?

2017-01-26 Thread Donald McClymont
As far as I can see pythonanywhere still doesn't provide php and piwik has this as required. So I think that can be asked back to pythonanywhere guys. Possibly it can be installed somehow. Otherwise you would need to host piwik at least elsewhere or use another analytics solution. Donald

[web2py] Re: Python Social Auth - example site working with downlevel version of PSA

2017-02-17 Thread Donald McClymont
> <https://lh3.googleusercontent.com/-wfp7IjUMZCI/WKZcsa2KECI/AnM/E2QugZa2ytc6QAi60ylxnpm9Jy5iszp5gCLcB/s1600/Login.tiff> > > > What are your thoughts? > > -- Joe > > > On Saturday, February 11, 2017 at 9:35:53 AM UTC-8, Donald McClymont wrote: >> >> H

[web2py] Form submission not working using ajax to display form in content div

2017-02-13 Thread Donald McClymont
I haven't studied all of this but can you change the name of your controller function to something other than form. I have had issues with Ajax when I had a similar sort of name collision. Donald -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: Python Social Auth - example site working with downlevel version of PSA

2017-02-11 Thread Donald McClymont
Hi Joe The repo is a minimum Web2py app with most of the code in a plug-in so as long as you have social-auth-core installed it should run ok. However I am not sure if you can fully setup and test from a laptop. Most of the providers that you need to register your app with seem to like you

[web2py] Re: Python Social Auth - example site working with downlevel version of PSA

2017-02-11 Thread Donald McClymont
Hi Joe The repo is a minimum Web2py app with most of the code in a plug-in so as long as you have social-auth-core installed it should run ok. However I am not sure if you can fully setup and test from a laptop. Most of the providers that you need to register your app with seem to like you

[web2py] Re: Python Social Auth - example site working with downlevel version of PSA

2017-02-11 Thread Donald McClymont
Hi Joe The repo is a minimum Web2py app with most of the code in a plug-in so as long as you have social-auth-core installed it should run ok. However I am not sure if you can fully setup and test from a laptop. Most of the providers that you need to register your app with seem to like you

[web2py] Re: Python Social Auth - example site working with downlevel version of PSA

2017-02-11 Thread Donald McClymont
Hi Joe The repo is a minimum Web2py app with most of the code in a plug-in so as long as you have social-auth-core installed it should run ok. However I am not sure if you can fully setup and test from a laptop. Most of the providers that you need to register your app with seem to like you

[web2py] Re: Admin console doesn't work on iPad (blank screen)

2017-01-16 Thread Donald McClymont
Indeed I can confirm I get the same experience. However if you change line 3 of the default.py such that EXPERMINTAL_STUFF is False then you should at least get back to the desktop version which looks to be fairly useable on an ipad but probably not anything much smaller. I don't have much in

[web2py] Re: New system like web2pyslices ( redesign and remodel maybe ) to web2py

2017-02-26 Thread Donald McClymont
I think something should be done - the current site never seems to be up any more - I just get ticket issue unrecoverable when I access. I also think we could look at a different approach with basically just using github for storing everything and the slices just provides a searchable

[web2py] Re: Open Sourced dating website

2017-02-26 Thread Donald McClymont
Thanks for sharing - I will take a look. No plans to start a dating website for people - however currently quite enjoying reading "The evolution of everything" and this argues that human progress arises when ideas have sex - so perhaps it could be adapted to a dating site for ideas. Donald

[web2py] Re: server for load web2py application

2017-02-26 Thread Donald McClymont
Why not just start with the free pythonanywhere option? - if only a few users and few pages it should be fine - unless there are features that you need that are not on free accounts. As far as pythonanywhere are concerned web2py is the app so you can still have a number of web2py applications

Re: [web2py] Re: Graph Model (proposal to contribute)

2017-02-27 Thread Donald McClymont
Has anyone had a chance to try this out and advise if it is suitable to incorporate in main web2py or if there are some other changes that should be made before it would be acceptable. There's lots more that could be done with it but it seems quite useful and usable in present form? Donald

[web2py] Re: how to change color and case of form buttons

2016-09-07 Thread Donald McClymont
Downloading your own bootstrap theme is also an option - this can obviously change a lot more than just the button styles and there is also a choice of formstyles eg web2py, bootstrap, bootstrap3 which you could also tweak as more comprehensive solutions than just changing the button style --

[web2py] Re: Web2py Solr UI

2016-09-15 Thread Donald McClymont
Massimo has also posted this as a starting point https://github.com/mdipierro/web2py-haystack which may be a useful starting point- I haven't used with solr but did manage to extend to GAE Search without too much difficulty. Regards Donald On Wednesday, September 14, 2016 at 4:42:55 PM

[web2py] Re: Plugin providing a Location picker widget for geometry fields

2016-09-22 Thread Donald McClymont
Just for reference I have hacked about with this a bit at the following link: https://github.com/DonaldMcC/w2p_location_widget It now provides an example app with reverse geocoding, ability to pickup users location per html5 and a method of working with non-geospatial databases by moving the

[web2py] Re: Python Social Auth - example site working with downlevel version of PSA

2016-11-06 Thread Donald McClymont
additional steps to query this after authentication at some point. Regards Donald On Saturday, November 5, 2016 at 3:12:37 PM UTC, mweissen wrote: > > It is a very interesting project. Are there any news? > > Am Freitag, 24. Juni 2016 00:45:51 UTC+2 schrieb Donald McClymont: >> >

Re: [web2py] Re: Graph Model (proposal to contribute)

2016-11-19 Thread Donald McClymont
Had a look at this and seems far better way to go as pygraphviz was beyond me to install on windows. I've been using d3 for some other things with web2py and some degree of interactivity with the graph eg creating new nodes and saving the layout as force directed typically gives you a good

[web2py] Subquery question

2016-12-11 Thread Donald McClymont
Computed fields are not stored in the database so I don't think you can do the sort of query you are trying to do. The computed field is only useful once you have a row set to work with. My understanding of this is that you need to run the queries against the latitude and longitude fields you

[web2py] Re: Python Social Auth - example site working with downlevel version of PSA

2017-01-11 Thread Donald McClymont
, 2016 at 11:38:45 PM UTC, Donald McClymont wrote: > > Not a great deal from me - it is still generally working fine with latest > version of psas on www.netdecisionmaking.com - this is really a hobby > project to demo a different approach to running the world or any part of > it.

[web2py] Re: Geo location in the Address field of SQL form

2017-01-01 Thread Donald McClymont
Hi Joe This may help: https://github.com/DonaldMcC/w2p_location_widget - mainly based on work Leonel Camara did a while back - but I updated to make it do a few more things. Regards Donald On Sunday, January 1, 2017 at 3:47:22 PM UTC, Joe Lwe wrote: > > Hi Friends, > Thanks so much for

[web2py] Re: UPDATE BOOTSTRAP VERSION FROM 3 TO 4

2017-04-24 Thread Donald McClymont
I think there are use cases for both sqlform and client side frameworks. In terms of bs4 there seem to be sites that will do a conversion so I would think it must be possible to make new form styles for bs4 as was done for bs3? Albeit I imagine this is not a particularly fun job it can't be

[web2py] Re: web2py 2.15.0b1

2017-07-06 Thread Donald McClymont
Excellent work with this and lots of new features. No major issues with doing some testing so far - but just sharing an observation that a field definition along the lines of: below will cause an error if you insert a record and it attempts to use the default value. Field('plan_editor',

[web2py] Re: Communication between server and python script help

2017-05-01 Thread Donald McClymont
I did this a while back https://github.com/DonaldMcC/pronto which was a small and very simple way to send commands direct from web2py server to an arduino which was controlling a cubetto prototype. I appreciate this is not your current use case but thought I'd share in any case. Cubtetto

[web2py] Re: WEB2PY iOS install APP

2017-05-12 Thread Donald McClymont
Is it still required to jailbreak iOS if you want to install Web2py on iOS? Was considering giving this a go with Pythonista but I have not really done much investigation. I am not particularly keen on jailbreak as I don't trust apple to not brick the device at some point if I do this. But

[web2py] Re: Error while running web2py.py

2017-05-31 Thread Donald McClymont
I would also recommend checking your python version it really should be 2.7.something and the Tk error suggests it is probably python 3 which will definitely not be a productive experience with web2py 2.0.8 it can be experimented with the latest trunk version but anything less will probably be

[web2py] Re: Need help with student attendance app

2017-05-05 Thread Donald McClymont
I am not sure about your data model as classes and students may well be a many to many relationship and you may be better with an intermediate table to support this. Current setup each student can only belong to a single class. With current setup there are still a number of ways that you

[web2py] Re: Registration & Login through Google

2017-11-17 Thread Donald McClymont
You could also consider python social auth https://github.com/DonaldMcC/w2p-social-auth this does work with google and should be reasonably easy to setup however at present it only does the authentication it doesn’t populate email addresses and so on as that is supposed to be done subsequently

[web2py] list:string field length

2017-11-17 Thread Donald McClymont
I don’t think you can set this but not sure why you would want to. However beware if testing the length of the field as I think if you only have 1 item in the list then this is a string and you get the number of chars in the string. While if you have more than 1 you get the length of the

[web2py] Re: list:string field length

2017-11-18 Thread Donald McClymont
still the case with 2.16.1 Donald On Friday, November 17, 2017 at 11:47:49 PM UTC, Anthony wrote: > On Friday, November 17, 2017 at 3:53:02 PM UTC-5, Donald McClymont wrote: > >> I don’t think you can set this but not sure why you would want to. >> However beware if testing the

Re: [web2py] European General data protection act and web2py

2018-05-19 Thread Donald McClymont
I just went with cookie consent - from github - it just goes into layout.html and is only about 5 lines for simple setup - all JavaScript but works fine with Web2py. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Geolocation: how to execute js script (navigator.geolocation, ecc) before controller code?

2018-06-17 Thread Donald McClymont
You could have a look at this - https://github.com/DonaldMcC/gdms/blob/master/views/default/user.html It integrates a javascript geolocation plugin to web2py user registration and also Leonel Camara's excellent plugin_location_picker which together allowed me to do everything I was wanting to

[web2py] Re: Geolocation: how to execute js script (navigator.geolocation, ecc) before controller code?

2018-08-25 Thread Donald McClymont
://www.netdecisionmaking.com/w2p_location_widget Regards Donald On Monday, June 18, 2018 at 10:17:58 AM UTC+1, Fabio Ceccarani wrote: > > Thanks Donald, I will look itseem very interesting. > Fabio > > Il giorno domenica 17 giugno 2018 23:02:08 UTC+2, Donald McClymont ha > scritto: >>

[web2py] Re: Geolocation: how to execute js script (navigator.geolocation, ecc) before controller code?

2018-08-26 Thread Donald McClymont
I have now fixed a few things to avoid some errors and set to require https as IOS/Safari will only render locations under https. For laptops etc the proposed locations are not terribly accurate unless the wifi has been logged or they have GPS chip installed. However that's really a separate

[web2py] Re: Allowing users to delete their profiles

2018-08-28 Thread Donald McClymont
On Tuesday, August 28, 2018 at 12:16:59 PM UTC+1, Anthony wrote: > > Please post the traceback here. The error ticket fil Error ticket for "gdms"Ticket ID 127.0.0.1.2018-08-27.21-31-21.fbba2e6a-7e7d-4081-b191-b07d009d01c4 'NoneType' object is not iterableVersion web2py™ Version

[web2py] Allowing users to delete their profiles

2018-08-27 Thread Donald McClymont
It seems there is a setting: auth.settings.allow_delete_accounts=True This does expose the deletion checkbox which is good - however on submission it generates an error and user not deleted. Is there something else required to make this work or should I open an issue? Donald --

[web2py] Re: Python 3.7 Compiled Apps

2018-09-04 Thread Donald McClymont
The key bit of the error is: File "C:\web2py\gluon\compileapp.py", line 470, in read_pyc return marshal.loads(data[marshal_header_size:]) ValueError: bad marshal data (invalid reference) I have also done a bit more digging and this seems to be caused by PEP 552 and for python 3.7 it

[web2py] Re: Allowing users to delete their profiles

2018-08-29 Thread Donald McClymont
ession_user, > which generates an error. > > Please open a Github issue and refer back to this post. > > Anthony > > On Tuesday, August 28, 2018 at 6:13:53 PM UTC-4, Donald McClymont wrote: >> >> >> >> On Tuesday, August 28, 2018 at 12:16:59 PM UTC+1, Antho

[web2py] Python 3.7 Compiled Apps

2018-09-02 Thread Donald McClymont
Has anyone successfully ran a compiled app under python 3.7? As far as I can see this doesn’t work - compilation is fine but running for example the welcome app complains about some Marshal error. It’s not obvious that much has changed between 3.6 which works fine and 3.7 as regards

[web2py] Re: lose focus events in form fields

2018-09-26 Thread Donald McClymont
Hi Rahul You could just do this with Jquery as events that run when any of the 3 fields are exited however I am not convinced that's really a great approach - I haven't seen an example of doing this as part of the actual SQLFORM. Another question would be do you really need to concatenate

[web2py] Re: lose focus events in form fields

2018-09-27 Thread Donald McClymont
There is some example script here which may help with the idea - both a setup for countries and subdivisions with Ajax and also a couple of range controls for urgency and importance where I then backfill the values into form fields for the actual values. As far as I am aware web2py does not

Re: [web2py] Re: Upload CSV file though app admin getting an error in 2.17.2

2019-01-01 Thread Donald McClymont
There is an open issue #2015 about this and some proposed changes that get it working on python 3 - however would like some confirmation that this is the best way to fix it. https://github.com/web2py/web2py/issues/2015 Donald -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] Re: [web2py-users] pygraphviz

2018-11-22 Thread Donald McClymont
I will try and have a look at this over the next few weeks - I think improving D3 solution is probably easier for me than installing pygraphviz on windows! Donald On Thursday, November 22, 2018 at 4:15:24 PM UTC, Richard wrote: > > Hi, > > I understand that we move to 3djs... Although right

[web2py] Re: Python 3 - Traceback problems

2019-02-18 Thread Donald McClymont
Be good if there could be a new release with this fixed fairly soon as many people seem to be getting going with py3 now and the traceback and cvs imports seem to be the main issues. Donald -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] 2.18.2 translate function has gone from gluon.validators

2019-02-26 Thread Donald McClymont
I use Leonel Camara's excellent plugin location picker however it includes the following line from gluon.validators import Validator, translate it seems translate has become translator - but I haven't looked at in detail or fully followed - but need some guidance on how this is supposed to

[web2py] Re: 2.18.2 translate function has gone from gluon.validators

2019-02-26 Thread Donald McClymont
Many thanks - I will resume testing once merged Donald -- 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

[web2py] Re: web2py on Raspbian and Python 2 or 3?

2019-06-11 Thread Donald McClymont
Why not just use the built in rocket server on a pi? Seems far simpler and performance is always going to be fairly limited given the hardware you are running on? On Saturday, June 8, 2019 at 12:31:28 AM UTC+1, Val K wrote: > > uWSGI is very cool, but since you are on Raspbian maybe gunicorn

Re: [web2py] Re: web2py on Raspbian and Python 2 or 3?

2019-08-24 Thread Donald McClymont
I just start it with systemd but there are various options to run scripts at startup - I did need to put some sort of instructions in to make sure Web2py starts after the network is up and running - having done this it did start fine. Donald -- Resources: - http://web2py.com -

[web2py] Gantt for python/Web2py

2019-09-06 Thread Donald McClymont
I used jsGanttimproved it’s all JavaScript but fairly straightforward to integrate and just populate the details. It still seems to be getting updated but example code from a while ago is here. https://github.com/DonaldMcC/gdms May well be better options but this worked for me. Donald --

[web2py] Re: Web2py with python 3.8.0

2019-11-02 Thread Donald McClymont
So this seems to be because cgi.escape which was deprecated has now been removed. I think there may have been a fix submitted for this - however if not it should be fairly simple to include - looks like we just need to use html.escape which will work for all reasonable versions of python 3.

[web2py] Re: web2py 2.18.5 breaks mysql connection

2020-03-17 Thread Donald McClymont
Any update on when 2.18.6 will be released - or is there an accepted workaround other than taking latest version? This seems a rather fundamental bug when you upgrade a mysql setup? Regards Donald On Friday, April 12, 2019 at 4:59:55 AM UTC+1, Massimo Di Pierro wrote: > > will release 2.18.6

Re: [web2py] Digest for web2py@googlegroups.com - 3 updates in 2 topics

2024-02-07 Thread Donald McClymont
Moving web2py from py2 to py3 should be very straightforward.  What may or may not be straightforward is moving your web2py applications from py2 to py3 as that depends a fair bit on how they have been written and certainly encoding and changes to string handling between py2 and py3 could need

[web2py] Re: Front end framework

2024-02-18 Thread Donald McClymont
I think BS5 will be fine - the classes and so forth should be the same as BS4 and I’ve not encountered any real issues with BS5 and py4web. https://superdevresources.com/bootstrap5-vs-bootstrap4-whats-new/ Donald On Saturday, February 17, 2024 at 3:55:26 AM UTC Massimo Di Pierro wrote: > I