[web2py] Re: How to debug appadmin CSV uploading

2020-05-01 Thread Andrew Rogers
Can't help you Jon sorry. I tried to upload a while back but got a different issue (see https://groups.google.com/forum/#!topic/web2py/03-7xKAioD8) So maybe that feature has fallen into disuse? On Friday, 1 May 2020 16:57:38 UTC+10, Jonsubs wrote: > > Hi everyone, > I'm trying to upload a

[web2py] Re: SQLFORM with extra_fields

2020-05-01 Thread Jim S
S, I'm wondering if this is a bug in web2py. In the traceback above you can see the error is on line 1505 in sqlhtml.py. In looking at the code, it appears as though it is just setting the default value for each field based on the record that was retrieved. Here is that block of code: if

[web2py] Re: SQLFORM with extra_fields

2020-05-01 Thread Jim S
Clemens Thanks for this. Have you ever used extra_fields in SQLFORM? I'm wondering what it is for if it doesn't work the way I'm using it. -Jim On Friday, May 1, 2020 at 1:16:36 PM UTC-5, Clemens wrote: > > Hi Jim, > > I've solved it as follows (for an additional field to select the >

Re: [web2py] Re: web2py and ubuntu 20lts

2020-05-01 Thread Maurice Waka
Noted guys Works well. regards On Friday, May 1, 2020 at 4:57:11 PM UTC+3, Lovedie JC wrote: > > On system restart, the previous pyc files for python 2+ were deleted and > it works OK. > Let me observe for now. > Regards > > On Fri, May 1, 2020, 11:26 Lovedie JC > > wrote: > >> Let me try >>

Re: [web2py] Re: "TypeError: sequence of byte string values expected, value of type str found" when accessing admin

2020-05-01 Thread João Matos
Hello, Nope. What I did was use another port with HTTPS (not 443, eg. 8000) for the client's application. Best regards, João Matos On 01/05/2020 19:15, Ian W. Scott wrote: Did you ever solve this problem? I'm running into the same thing. On Monday, April 8, 2019 at 12:56:49 PM UTC-4,

[web2py] Re: SQLFORM with extra_fields

2020-05-01 Thread Clemens
Hi Jim, I've solved it as follows (for an additional field to select the corresponding business unit, here stored in a dictionary): biz_unit = TR(TD(LABEL(T('Responsible'), XML(''))), \ TD(SELECT(_name='biz_unit', value='', *[OPTION(biz_unit_title, _value=biz_unit_dict[biz_unit_title]) \ for

[web2py] Re: "TypeError: sequence of byte string values expected, value of type str found" when accessing admin

2020-05-01 Thread Ian W. Scott
Did you ever solve this problem? I'm running into the same thing. On Monday, April 8, 2019 at 12:56:49 PM UTC-4, João Matos wrote: > > When using Apache 2.4 (HTTPS using port 443) with web2py the application > works fine, but the admin interface always returns and error "Internal > Server

[web2py] Likely causes of admin server error?

2020-05-01 Thread Ian W. Scott
What are the "likely culprits" I should be looking at when I get an "Internal server error" accessing admin or appadmin on a fresh web2py installation? Here's what I've been trying so far. - Apache2 config file correctly configured? - I'm - accessing over https? - admin password set? -

[web2py] SQLFORM with extra_fields

2020-05-01 Thread Jim S
Anyone have experience with using 'extra_fields' in a SQLFORM? Here is my code: def edit_demo(): response.view = 'producer/edit/edit_demo.load' producer_id = request.get_vars.producer_id producer = db(db.producer.id == producer_id).select().first() form = None if

Re: [web2py] Re: Server error when accessing admin

2020-05-01 Thread Ian W. Scott
Okay, I'm narrowing down what the problem might be. The site is presently using webfaction's shared SSL certificate for https, which browsers don't recognize as secure. Could that be causing the admin interface to throw the 500 error? On Thursday, April 30, 2020 at 3:02:58 PM UTC-4, Ian W.

[web2py] Re: The virtual fields are not accessible until I convert my records to a list

2020-05-01 Thread Andrew Rogers
Ugg, I'm a goose. Silly mistake. It works exactly as it should. Sadly i dont. On Saturday, 2 May 2020 00:09:50 UTC+10, Andrew Rogers wrote: > > (I posted this question here as well: >

[web2py] The virtual fields are not accessible until I convert my records to a list

2020-05-01 Thread Andrew Rogers
(I posted this question here as well: https://stackoverflow.com/questions/61544049/the-virtual-fields-are-not-accessible-until-i-convert-my-records-to-a-list ) The book here gives this example for

Re: [web2py] Re: web2py and ubuntu 20lts

2020-05-01 Thread Lovedie JC
On system restart, the previous pyc files for python 2+ were deleted and it works OK. Let me observe for now. Regards On Fri, May 1, 2020, 11:26 Lovedie JC wrote: > Let me try > > On Fri, May 1, 2020, 11:00 Clemens > wrote: > >> Hi Maurice, >> >> obviously you're trying to execute your

[web2py] Re: Visual Studio Code

2020-05-01 Thread Andrew Rogers
Thanks for the reminder re the intellisense. Do you think it still works fine? I tried to out just now and had some issues. But the problem may well be me and not it. On Friday, 1 May 2020 19:55:39 UTC+10, villas wrote: > > Further to Andrew's reply you could also try these ideas: > > >

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

2020-05-01 Thread Andrew Rogers
Hi again I am having a similar problem again. I havent compiled the app - i have learnt from that mistake, thanks. I am now trying to import some of my custom functions from other python files in the same app. After i got an __init.py__ file in place i was able to see and use my imported

[web2py] Re: How to debug appadmin CSV uploading

2020-05-01 Thread Clemens
Hi Jon, I prefer to upload csv files to the database via the python console, starting it as follows: python **/web2py.py -S ** -M -P There you can import the csv as follows (assuming your database is reference by db, i.e. db = DAL(...)): filename = **/**.csv'; print(filename) *python2:*

[web2py] Re: Visual Studio Code

2020-05-01 Thread villas
Further to Andrew's reply you could also try these ideas: http://www.web2py.com/books/default/chapter/29/14/other-recipes?search=ide+#Using-general-purpose-IDEs-with-web2py https://github.com/Andyhasit/web2py_intellisense -- Resources: - http://web2py.com - http://web2py.com/book

Re: [web2py] Re: web2py and ubuntu 20lts

2020-05-01 Thread Lovedie JC
Let me try On Fri, May 1, 2020, 11:00 Clemens wrote: > Hi Maurice, > > obviously you're trying to execute your pythone-2-compiled code with > python 3 (Ubuntu 20 default). Have a try recompiling it with python 3.x. > > Does this solve the problem? > > Regards > Clemens > > On Friday, May 1,

[web2py] Re: web2py and ubuntu 20lts

2020-05-01 Thread Clemens
Hi Maurice, obviously you're trying to execute your pythone-2-compiled code with python 3 (Ubuntu 20 default). Have a try recompiling it with python 3.x. Does this solve the problem? Regards Clemens On Friday, May 1, 2020 at 7:24:34 AM UTC+2, Maurice Waka wrote: > > I recently moved to

[web2py] How to debug appadmin CSV uploading

2020-05-01 Thread Jon Subscripted
Hi everyone, I'm trying to upload a CSV file to my MySQL database using appadmin. I do get a "data uploaded" flash message as if I succeeded, but data is not there. Could anyone suggest me how to debug this operation? Thanks, Jon.