Re: [web2py] lock table record

2020-11-25 Thread AGRogers
eas how to do that? > > V V sre., 25. nov. 2020 ob 12:39 je oseba AGRogers > napisala: > >> I am not aware that web2py has anything built in to do that. And it is a >> tricky task - to do it properly you need all sorts of real time feedback >> going to every grid t

Re: [web2py] lock table record

2020-11-25 Thread AGRogers
I am not aware that web2py has anything built in to do that. And it is a tricky task - to do it properly you need all sorts of real time feedback going to every grid that is already opened. It's conceptually not too hard for grids that will be opened in the future - just set a flag when someone

Re: [web2py] Login via an link/URL

2020-11-24 Thread AGRogers
Thanks for the extra info :D ___ *www.TenOutOfTen.org* rogers...@gmail.com (+95) 09 250018669 (Myanmar) On Fri, 20 Nov 2020 at 05:39, valq...@gmail.com wrote: > login_bare is a normal function, it is intended to login through ajax, but >

Re: [web2py] Re: Update dropdown list in SQLFORM.grid based on selection in another dropdown list

2020-11-24 Thread AGRogers
Glad you got it working. I send javascript from my controller back to the view for some custom control widgets. That sounds similar to what you want to do. I dont know where i found the original code sample to do that - not in the book I dont think. This page

Re: [web2py] SQLform.grid request not sending bool valuis

2020-11-24 Thread AGRogers
Are the boolean fields writable? I think unwritable fields are excluded from request.vars. ___ *www.TenOutOfTen.org* rogers...@gmail.com (+95) 09 250018669 (Myanmar) On Tue, 24 Nov 2020 at 22:21, Yebach wrote: > Hello > > I have a

Re: [web2py] Cron instead of Scheduler

2020-11-24 Thread AGRogers
Glad to hear you got it sorted. ___ *www.TenOutOfTen.org* rogers...@gmail.com (+95) 09 250018669 (Myanmar) On Tue, 24 Nov 2020 at 18:02, Gaël Princivalle wrote: > Thank you for your reply. > > The problem was in the psycop2 library. >

Re: [web2py] Cron instead of Scheduler

2020-11-23 Thread AGRogers
Have you tried running it as sudo? What does it say in the nohup.out file? Maybe a permissions issue? ___ *www.TenOutOfTen.org* rogers...@gmail.com (+95) 09 250018669 (Myanmar) On Sat, 21 Nov 2020 at 05:51, Gaël Princivalle wrote: > Hi. >

Re: [web2py] Re: Dashboard library for Web2py performance/recommendation python vs. js

2020-11-18 Thread AGRogers
Some nice looking pages there. Thanks. On Wed, 18 Nov 2020, 11:38 pm Alex Beskopilny, wrote: > dasjboards for web2py https://github.com/ali96343/facew2p > dashboards for py4web https://github.com/ali96343/facep4w > charts Highcharts.js > On Tuesday, November 17, 2020 at 11:47:04 AM UTC+3

Re: [web2py] Login via an link/URL

2020-11-18 Thread AGRogers
Thanks Carlos I couldnt find the login_user() function in the book but i did find it here: https://web2py.readthedocs.io/en/latest/_modules/gluon/tools.html#Auth.login_user Does login_user(self, user) essentially bypass the normal authentication process? And is login_bare(self, username,

Re: [web2py] Where to find Alert/Flash messages

2020-11-17 Thread AGRogers
You can see error tickets from the Admin module (screenshot below). I believe they are stored on the filesystem, not in a table. I have never looked. Re Flash messages, unless they are generated from error tickets, i doubt they are stored anywhere. I have a function that logs errors (and

Re: [web2py] Login via an link/URL

2020-11-17 Thread AGRogers
Hi Kenneth The following are guesses 1. I have never seen anything that is remotely similar to this in web2py. But i like the idea. 2. Maybe the 'impersonate' option might work. Someone how log in as a user whose account details you know and then impersonate the user identified in the link.

Re: [web2py] Re: Push Notifications

2020-11-16 Thread AGRogers
Thanks for the tip Antonio. The free version could work well for me. I dont mind reinventing the wheel - I just dont like fixing it when it breaks :) ___ *www.TenOutOfTen.org* rogers...@gmail.com (+95) 09 250018669 (Myanmar) On Tue, 17 Nov

Re: [web2py] Scheduler on Opalstack

2020-11-12 Thread AGRogers
Regarding Scheduler code in, I understand you can put it in any Model file. On Fri, 13 Nov 2020, 5:01 am Gaël Princivalle, wrote: > I can see if I create a new app in Webpy 2.20.4 that the db file have this: > if configuration.get('scheduler.enabled'): > from gluon.scheduler import

Re: [web2py] On Windows I am trying to delete an application that uses logging but the delete fails because the log file is "in use"

2020-11-10 Thread AGRogers
Good tip. Thanks. Seems like something that should end up in the public version. ___ *www.TenOutOfTen.org* rogers...@gmail.com (+95) 09 250018669 (Myanmar) On Tue, 10 Nov 2020 at 23:09, Davidiam wrote: > We found that by modifying the

Re: [web2py] Hosting my web2py application

2020-11-09 Thread AGRogers
I have just set up a Google cloud virtual machine with Debian 9 and Apache and python 3.7.6. It wasn't easy. Seems to be fast though. If you want a vm image I can try and work out how to share it with you. On Sun, 8 Nov 2020, 8:56 am Dave S, wrote: > > > On Tuesday, October 27, 2020 at 11:21:28

Re: [web2py] Displaying content based on the id attribute

2020-11-09 Thread AGRogers
That was a long thread which I didn't read fully. But what I did read made me think that maybe the original problem was that you needed a slight delay between when you showed the span and when you made the ajax call. I do that by putting the ajax call in a setTimeout function. If I don't, the

Re: [web2py] music and programming

2020-11-08 Thread AGRogers
It looks great Stifan. Well done. I am not musical but it looks like a pretty comprehensive research. I like the tabulator control as well. ___ *www.TenOutOfTen.org* rogers...@gmail.com (+95) 09 250018669 (Myanmar) On Sun, 8 Nov 2020 at

Re: [web2py] On Windows I am trying to delete an application that uses logging but the delete fails because the log file is "in use"

2020-10-26 Thread AGRogers
Ah, i see. Can you temporarily shutdown() the logger and then restart it when the uninstall is complete? Or does it need to stay running also? I think it is possible to close a specific handler as well - but i dont know how the logging works in web2py - maybe there is a single handler for all the

Re: [web2py] On Windows I am trying to delete an application that uses logging but the delete fails because the log file is "in use"

2020-10-25 Thread AGRogers
Hi David I am not sure that i have ever used the Uninstall option. I just delete the application folder and the application disappears. I am not sure if that leaves any residual information in files somewhere. But i have not noticed a problem. Does that work for you? Andrew

Re: [web2py] SQLFLORMGRID

2020-10-04 Thread AGRogers
Hi I have used the DAL to execute code before or after I make database changes. Maybe that might work in your situation: http://www.web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#callbacks-on-record-insert-delete-and-update Cheers Andrew ___

Re: [web2py] OT PollyReports generate PDF using bands from DB

2020-10-04 Thread AGRogers
Thanks Denes. I have often looked for reporting solutions over the years. I will keep it in mind. ___ *www.TenOutOfTen.org* rogers...@gmail.com (+95) 09 250018669 (Myanmar) On Fri, 2 Oct 2020 at 00:58, 'DenesL' via web2py-users <

Re: [web2py] Re: Freshly cloned web2py, grid example says "not authorized"

2020-09-22 Thread AGRogers
Yes, I got bitten by this too. My opinion is that this decorator (and others like it) should start commented out. These little obstacles can make those first weeks unnecessarily harder. On Wed, 23 Sep 2020, 1:18 pm BigBaaadBob, wrote: > Yes, thanks. I’m just surprised this doesn’t work In the

[web2py] FYI this is a useful website for extra Web2py info and examples

2020-08-26 Thread AGRogers
Hi I find myself ending up on this site every now and then: https://web2py.wordpress.com/tag/reference/ There are examples there that have really helped me. Interestingly, after I see the example i often discover that the same info was available in the book, i was just not smart enough to work

Re: [web2py] Re: Auto-generate PUT and DELETE methods

2020-08-24 Thread AGRogers
Hi Rahul I haven't done much at all with the rest api. But I would have assumed that you would need to decorate it with @requires to control who can access what. I can't see that in your code. On Tue, 25 Aug 2020, 3:06 am Rahul, wrote: > Hi All, >Not sure if this is the right

Re: [web2py] Re: count() with left join

2020-08-20 Thread AGRogers
I have just resorted to pure SQL using db.executesql (I know that doesnt help you). Can't get much faster than that though. I like how the results can be returned as a simple dictionary. But i realised i need to be careful if i ever target a different DB provider. And permissions and common

Re: [web2py] Re: modules: NameError("name 'reload' is not defined",)

2020-08-18 Thread AGRogers
I am completely out of my depth re this issue. But I just read the following on the py4web group and wondered whether it might be related. Proper use of modules Q from Richard: Where do modules go? A I think proper modules should be installed with pip but if you want to distribute the source of

Re: [web2py] Re: Server SQL non existent or access denied

2020-08-18 Thread AGRogers
Hi Andrea According to https://docs.microsoft.com/en-us/sql/connect/python/pyodbc/step-3-proof-of-concept-connecting-to-sql-using-pyodbc?view=sql-server-ver15 *pyODBC uses* the *Microsoft ODBC* driver for SQL Server. If your version of the *ODBC* driver *is* 17.1 or later, you *can use* the

Re: [web2py] Re: Nested menu item

2020-08-18 Thread AGRogers
I'm pretty sure that bootstrap doesn't allow nesting menus more than a single level. If you need more you need to use a custom menu system. I'm not sure how that applies to web2py's menu system. But I suspect it too only accommodates a single level by design. On Wed, 19 Aug 2020, 7:24 am Vlad,

[web2py] How to improve a widget select list that allows new options to be added?

2020-08-18 Thread AGRogers
Hi I want a drop down list that shows all the values from existing records AND allows the user to add a new value if they want. I have got something working using https://select2.org/ . But my approach is questionable. The problem i have is that when a new value is added and the form is

Re: [web2py] Re: pyDAL looks abandoned?

2020-08-17 Thread AGRogers
That's good news. On Mon, 17 Aug 2020 at 17:08, Massimo Di Pierro wrote: > yes Peewee is more actcie but I would not say pydal is abandoned. pydal is > more mature and there were commits as recent as last week. In my opinion it > needs very little work and I am reluctant to change things. Many

Re: [web2py] Re: Altering reference table format in SQLFORM

2020-08-11 Thread AGRogers
I just tried the format option change to the table to see if it worked for me... but it didn't. Thanks Villas for the 'requires' tip. I am sure i will need that knowledge at some point.. On Wed, 12 Aug 2020 at 01:30, David Orme wrote: > Thanks! I had played with the represent attribute, with no

Re: [web2py] Re: Has anybody had experience with Visual Studio Code Remote Development?

2020-08-10 Thread AGRogers
> On Friday, 7 August 2020 06:45:16 UTC+1, AGRogers wrote: >> >> Hi >> >> Has anyone used this sort of config before with web2py? That is, VSC >> connecting via SSH to a remote server (Google Cloud Debian VM for me) and >> then being able to debug an app o

Re: [web2py] Re: Has anybody had experience with Visual Studio Code Remote Development?

2020-08-10 Thread AGRogers
y with web2py and like it, so I'm thinking to do the same. >> >> >> >> On Friday, 7 August 2020 06:45:16 UTC+1, AGRogers wrote: >>> >>> Hi >>> >>> Has anyone used this sort of config before with web2py? That is, VSC >>> connect

[web2py] Has anybody had experience with Visual Studio Code Remote Development?

2020-08-06 Thread AGRogers
Hi Has anyone used this sort of config before with web2py? That is, VSC connecting via SSH to a remote server (Google Cloud Debian VM for me) and then being able to debug an app on the remote system. I am getting ready to deploy my app for the first time and have been somewhat fearful that if

Re: [web2py] Re: How to send contenteditable to web2py AJAX call

2020-08-03 Thread AGRogers
Thanks for update. On Sun, 2 Aug 2020, 6:38 am Rob Paire, wrote: > So I stepped through the Web2py AJAX call in the debugger and found that > the hang-up was due to jquery serialize method. That method wants a form > variable name as input. The easiest solution is to wrap the table in a set >

Re: [web2py] WAF2PY 1.0

2020-08-03 Thread AGRogers
Looks cool. Thanks for sharing. On Mon, 3 Aug 2020, 4:25 pm Christian Varas, wrote: > Hello all. > I'm glad to announce WAF2PY 1.0  > > *What is this?* > > WAF2PY is a Web Application Firewall using NGINX and ModSecurity. WAF2PY > provides a nice and easy to use web interface *powered by*

Re: [web2py] Re: How to send contenteditable to web2py AJAX call

2020-08-01 Thread AGRogers
Is there a reason you can't use the standard js or jquery ajax calls? Then you can build your own data structures easily and see exactly what is going where. I found things easier to debug that way. The only time I use the web2py one is when I want to send a web2py form back to the controller. It

Re: [web2py] Use cron

2020-07-23 Thread AGRogers
Sorry, can't help there. I have just started to use the Scheduler which is part of web2py. It was easy to setup and seems to work well. Is there a reason you can't use it? On Thu, 23 Jul 2020, 1:53 pm Martin Weissenboeck, wrote: > I use web2py with nginx.Now I need cron . I have read, that habe

Re: [web2py] Starting 2 web2py standalone applications at the same time

2020-07-23 Thread AGRogers
I think you just need to run each on a different port. On Thu, 23 Jul 2020, 3:57 pm mostwanted, wrote: > Hi Guys, how can i install 2 web2py binary standalone applications in one > computer & start them at the same time without them interfering with one > another? > > I am asking this because

Re: [web2py] Re: How to define constraints DAL Beginner

2020-07-22 Thread AGRogers
Maybe Ivan was just thinking of the Reference fields? http://web2py.com/books/default/chapter/29/06/the-database-abstraction-layer#Field-types If so try: db.define_table('jogador', Field('nome', 'reference equipe'), Field('posicao','string'), Field('altura','double'), Field('peso','double'),

Re: [web2py] No module named error

2020-07-22 Thread AGRogers
I think I'm on the latest versions of web2py and python. And i have problems getting modules to recompile (not sure how related that is to this topic). I gave up and just put all my modules in the Models folder. That always works for me. I'm going to need to sort that out though at some point.

Re: [web2py] Any alternative to installing web2py on laptop

2020-07-19 Thread AGRogers
Sure. pythonanywhere.com is where I started. Maybe it can run from a USB stick? I think it is pretty portable - but i have never done that and you would be better listening to someone else. On Mon, 20 Jul 2020 at 15:24, Nishant Bansal wrote: > Hi, > I have a company provided laptop and I

Re: [web2py] display items only entered by a logged in user in a dropdown menu of a reference table

2020-07-19 Thread AGRogers
oup members > > Please advise how to create multiple rows insert by usung SQL form . > > On Mon 20 Jul, 2020, 05:37 AGRogers, wrote: > >> Great. It's a cool feature. >> >> You would have read that you can turn it off in code temporarily just by >> setting com

Re: [web2py] display items only entered by a logged in user in a dropdown menu of a reference table

2020-07-19 Thread AGRogers
Great. It's a cool feature. You would have read that you can turn it off in code temporarily just by setting common_filter =none. That has caught me a few times. On Sun, 19 Jul 2020, 11:06 pm mostwanted, wrote: > Hey AGRogers, thanks for that suggestion, I added the highlited lines to &

Re: [web2py] display items only entered by a logged in user in a dropdown menu of a reference table

2020-07-19 Thread AGRogers
I would try using a common_filter on the drop down list table. Could that work? On Sun, 19 Jul 2020, 6:10 pm mostwanted, wrote: > In my application I have 4 tables, 3 of them referenced in the fourth > table but every user should be able to view only what they have entered > into the database.

Re: [web2py] Re: smart grid

2020-07-18 Thread AGRogers
Great On Sat, 18 Jul 2020 at 22:35, T.R.Rajkumar wrote: > Thank you AGRogers. It works. > > -- > Resources: > - http://web2py.com > - http://web2py.com/book (Documentation) > - http://github.com/web2py/web2py (Source code) > - https://code.google.com/p/web2py/is

Re: [web2py] Re: smart grid

2020-07-18 Thread AGRogers
. format = lambda r: ("%s [$s]") % (r.equipment_detail, db.pm_location(r.location_id).location_name) ) On Sat, 18 Jul 2020 at 15:33, T.R.Rajkumar wrote: > Thank you AGRogers > As you said the equipment record format to include the location, that > would do for me. &g

Re: [web2py] Nested menu item

2020-07-17 Thread AGRogers
I don't think bootstrap (which is what web2py utilises I think) allows for the second nested level. So to do it you would need to implement your own custom menu structure. On Sat, 18 Jul 2020, 12:33 am Vlad, wrote: > Missing something basic, but seems to me that the following code should >

Re: [web2py] smart grid

2020-07-17 Thread AGRogers
One option would be to set the Format of the Equipment record to also include the location - eg 'My Equipment (It's Location)' Then your selection drop down list should include the location. On Fri, 17 Jul 2020, 9:49 pm T.R.Rajkumar, wrote: > db.define_table('pm_events', >

Re: [web2py] Re: Under what circumstances would db.define_table() return None

2020-07-17 Thread AGRogers
That's for sure! His stack exchange posts really helped me get around some problems early on... and now :-) I should pray for a special blessing for him tomorrow  On Fri, 17 Jul 2020, 9:05 pm villas, wrote: > That's great Andrew. > BTW great to see that Anthony is helping - he is someone who

Re: [web2py] Re: web2py online debugger under python3

2020-07-16 Thread AGRogers
>> >> On Wed, 6 May 2020 at 07:04, Clemens >> wrote: >> >>> Hi Andrew, >>> >>> well, I would say, it's because I ever used it and it's okay for me. But >>> which one would you recommend? And how to connect your favorite debugger >&g

Re: [web2py] Re: how to update a database field with a random value selected from a list using random.choice()

2020-07-15 Thread AGRogers
>>>My motto is: get something working and move on! Haha. A modified version I need to remember: Get something working and don't go back and break it! On Thu, 16 Jul 2020, 7:20 am villas, wrote: > We all have our styles of programming. I would probably create a dict of > times. > But any idea

Re: [web2py] count() as a field in sqlform.grid

2020-07-14 Thread AGRogers
Can you add a virtual field to the Cart table to do the counting for you? On Tue, 14 Jul 2020, 4:34 pm Vlad, wrote: > The following doesn't work: > > fields = [db.cart.id, db.cart.id.count()] > > > grid = SQLFORM.grid(db.cart, > fields=fields, >

Re: [web2py] Setting options in IS_IN_SET() as links to pages with more links

2020-07-10 Thread AGRogers
I solved the challenge of having too many options by using the multiselect option recommended in the book. http://web2py.com/books/default/chapter/29/07#IS_IN_SET-and-Tagging ( http://loudev.com/) "We strongly suggest using the jQuery multiselect plugin to render multiple fields." It's designed

Re: [web2py] In a custom html form of SQLFORM in web2py, how to copy the request argument of the url into a form field input?

2020-07-08 Thread AGRogers
t; > I hope this helps. > > -Jim > > On Tuesday, July 7, 2020 at 7:33:30 PM UTC-5, AGRogers wrote: >> >> OK. After you declare the form but before you process it you can set the >> form.vars.FieldName property. I think that might help. >> >> On Wed, 8 Jul

Re: [web2py] In a custom html form of SQLFORM in web2py, how to copy the request argument of the url into a form field input?

2020-07-07 Thread AGRogers
OK. After you declare the form but before you process it you can set the form.vars.FieldName property. I think that might help. On Wed, 8 Jul 2020, 4:36 am Anusha Narayan, wrote: > Yeah! The first question, is what I am talking about. > > On Mon, 6 Jul 2020, 8:56 pm AGRogers, wrote

Re: [web2py] In a custom html form of SQLFORM in web2py, how to copy the request argument of the url into a form field input?

2020-07-06 Thread AGRogers
Do you mean you want to set the EVENT_ID so that it's already selected when the form opens? Or are you saying that after you select the Event and submit the form you get an error? On Sat, 4 Jul 2020, 3:27 pm Anusha Narayan, wrote: > *The code of my model db.py is:* > > db.define_table( >

Re: [web2py] Re: scheduler gives and error about datetime

2020-06-29 Thread AGRogers
Thanks for the update. Hopefully I won't need it  On Tue, 30 Jun 2020, 2:12 am Pierre, wrote: > For a temporary solution, i made an external python prg and used cron on > my pi to sync the databases everynight and works find with sqlite syntax. > It's way more extensive work but seems to be

Re: [web2py] scheduler gives and error about datetime

2020-06-23 Thread AGRogers
utting a = > datetime.datetime.now() and it gives the exact same error. > Tasks doesn't like datetime period :) > Not yet figured out how to jsonify the task yet based on your suggestion, > but still bumping my head on it :) > > > Le lundi 22 juin 2020 23:56

Re: [web2py] scheduler gives and error about datetime

2020-06-22 Thread AGRogers
n the field is formated like this '%Y-%m-%d : > %H:%M:%S' > wonder if the datetime format used in my sqlite table field is the > problem. So curius that everything works fine in the controler but not as > a task. > > Le lundi 22 juin 2020 20:54:34 UTC-4, AGRogers a é

Re: [web2py] scheduler gives and error about datetime

2020-06-22 Thread AGRogers
Hi I use this code to solve this problem: result = json.dumps(result, indent=4, sort_keys=True, default=str) Don't know what it does but it solves my problem. I found it here: https://stackoverflow.com/questions/11875770/how-to-overcome-datetime-datetime-not-json-serializable On Wed, 17

Re: [web2py] How to sort a smartgrid with your own custom sorted id list

2020-06-22 Thread AGRogers
The only thing that comes to mind is to put your sort data into the database so you have something to sort on. If it is a single user app then it's easy - add a new column called sortid and put your custom sort order their. Multi user needs a second table to join on which might mess with smart

Re: [web2py] Re: List | Create | Modify and Delete Users directly from Python controller without using HMI

2020-06-07 Thread AGRogers
Yes, thank you too. I will need that. On Fri, 5 Jun 2020 at 06:50, Nicolas Hiblot wrote: > Thanks Dave and Val > It's perfect !! > Web2py forever > > Le mardi 2 juin 2020 23:57:31 UTC+2, Nicolas Hiblot a écrit : >> >> Hello All, >> >> I have read a lot of cases and uses cases about web2py

Re: [web2py] Re: web2py online debugger under python3

2020-06-07 Thread AGRogers
to Visual Studio Code :) On Fri, 5 Jun 2020 at 05:48, Clemens wrote: > Hi Andrew, > > I've switched over to PyCharm and really like it. Thanks a lot for the > push! > > Best regards > Clemens > > > On Wednesday, May 6, 2020 at 3:11:00 AM UTC+2, AGRogers wrote:

Re: [web2py] Tip - Using multiple web2py templates

2020-06-07 Thread AGRogers
Thanks for sharing this. I might need it soon. On Tue, 2 Jun 2020 at 07:44, Rodrigo Attique wrote: > After a lot of brainstorming I found a way to allow web2py to use multiple > templates. Perhaps for the elderly it is not a novelty, but for the > youngest ... This will be a hand in the wheel.

Re: [web2py] web2py python3

2020-05-13 Thread AGRogers
Does this help? https://stackoverflow.com/questions/39146039/pickle-typeerror-a-bytes-like-object-is-required-not-str On Wed, 13 May 2020 at 04:43, patito feo wrote: > Hi, > > Having this error when using python3. > > File "//web2py/applications/admin/controllers/default.py" >

Re: [web2py] Re: pyDAL looks abandoned?

2020-05-11 Thread AGRogers
Hi Val. I can't add anything useful to this sorry... except to say that i have really enjoyed using the DAL in my current project. I have no experience with others and have not done anything tricky like I have had to do in SQL server procs and what not. But it has made development easy for me. So

Re: [web2py] Re: web2py online debugger under python3

2020-05-05 Thread AGRogers
gt; Regards > Clemens > > > On Tuesday, May 5, 2020 at 1:56:25 AM UTC+2, AGRogers wrote: >> >> Hi Clemens >> >> I definitely can't help you with this problem. Sorry. But I am interested >> in why you use the online debugger and not something else? >>

Re: [web2py] Re: web2py online debugger under python3

2020-05-04 Thread AGRogers
Hi Clemens I definitely can't help you with this problem. Sorry. But I am interested in why you use the online debugger and not something else? Thanks Andrew On Mon, 4 May 2020 at 23:50, Clemens wrote: > Hello Massimo, > > I hoped the latest web2py version would fix the problem. My current >

Re: [web2py] Re: Importing a CSV file from the Database form fails

2020-05-03 Thread AGRogers
Thanks for the tips. I wrote an import to get in what i needed. But i will try this out when i need to do my next simple import. Cheers Andrew On Mon, 4 May 2020 at 00:54, Clemens wrote: > Have a look on how you open the file to be imported: > > python2: > open(filename, 'rb') > > python3: >

Re: [web2py] Re: How do I hide automatically generated child columns in web2py's SmartGrid?

2020-04-28 Thread AGRogers
Many thanks Jim. Good idea. That should work for me fine. Cheers On Fri, 24 Apr 2020 at 22:51, Jim S wrote: > This is pretty ugly, but I think it should work if you're interested in > fixing this with jquery in your template. > > I use this technique to hide columns based on other things going

Re: [web2py] Which 4 or 2?

2020-04-18 Thread AGRogers
Hi David I have spent that last month and a half trying to learn web2py and python and javascript (and css and sqlite and html). I reckon the official web2py book has everything in it that you need. However my trouble was that my knowledge about everything was so minimal that i often couldn't

Re: [web2py] Web2py, react, typescript, visual studio code setup

2020-03-11 Thread AGRogers
Great. Thanks Larry. I hadn't asked but I wanted to. I'll check it out. On Thu, 12 Mar 2020, 01:59 Larry Weinberg, wrote: > Several people have asked about how to set up web2py to work with React > (and Typescript) on the front end. Others have asked how to use an IDE like > Visual Studio Code

Re: [web2py] pyweb login

2020-03-07 Thread AGRogers
Maybe reinstall python as well? On Sat, 7 Mar 2020, 22:26 Maurice Waka, wrote: > See attached, nothing shows that is installed yet. > Regards > > On Sat, Mar 7, 2020 at 3:23 PM Maurice Waka wrote: > >> Hello, any help out there >> >> This is all I get at the terminal, see below. >> I

Re: [web2py] Re: Why would new code be ignored and old code be executed?

2020-03-06 Thread AGRogers
>>> Code in the modules folder are compiled automatically when the python file is first invoked. So, after you change any file in modules, you should remove the correspondent .pyc file. Ah, i see, Thanks for the tip. On Fri, 6 Mar 2020 at 19:48, Carlos Correia wrote: > Às 09:38 de 06/03/20,

Re: [web2py] Re: LOAD in py4web

2020-02-27 Thread AGRogers
https://unpoly.com/ On Fri, 28 Feb 2020 at 16:22, Massimo Di Pierro wrote: > never heard of unpolly.js and cannot find it. Have a link? > > > On Wednesday, 26 February 2020 19:32:20 UTC-8, Carlos Costa wrote: >> >> LOAD is a very cool thing! And beginners just say WOW when they can >> create

Re: [web2py] Re: Setting a default reference value as that of a specific group the logging in user is a member of

2020-02-26 Thread AGRogers
Thanks for the extra info. In my scenario I have schools, teachers, subjects, classes and students. At the Classes level there will be hundreds eventually (new ones each term). Your school limits what subjects you can see. The teacher limits what classes she can see etc. If I understood you

Re: [web2py] Setting a default reference value as that of a specific group the logging in user is a member of

2020-02-25 Thread AGRogers
I am interested in the best practice way to do this as well. On Tue, 25 Feb 2020, 13:58 mostwanted, wrote: > I have 2 tables about a hotel, one table registers the hotel itself & the > other is about meals that are offered at the hotel but the idea is that > only group members of each hotel

Re: [web2py] Re: Web2py or py4web for a brand new project

2020-01-22 Thread AGRogers
OK, thanks. Re reporting errors, I suspect most errors will be due to my ignorance. But thanks for the encouragement. On Tue, Jan 21, 2020, 1:26 PM Massimo Di Pierro wrote: > You should use the py4web documentation. Also please report any error you > find. > > > On Tuesday, 14 January 2020