[web2py] Web2py - How would I monitor an existing running script?

2020-01-20 Thread Simon Dreyer
Hi Folks, I have an existing python application that reads data from industrial controllers and publishes it to a message queue. The application is currently headless and logs errors and events to a log file. I would like to add a web interface to the application so that I can log into the app

[web2py] Re: no-email edit in profile

2018-12-19 Thread Simon Riek
Thanks Leonel, very helpful for my next application. In my current production applications I have no user self registration, therefor it is sufficient for me to make the email field writable again (though I wouldn't edit gluon/tools.py, instead I used my own derived Auth class with a custom

[web2py] no-email edit in profile

2018-12-14 Thread Simon Riek
make sense to control this via settings? e.g "self.settings.email_field_writable" (with default = false? Or am I missing something? Best regards Simon -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code

[web2py] Problem with Grid Exporter since upgrade from 2.14.6 to 2.15.2 / 2.15.3

2017-08-07 Thread Simon Riek
Since updating from 2.14.6 to 2.15.2 (and also 2.15.3 released just moments ago) I have some problems with the default ExportClasses in SQLFORM.grid. I am using MSSQL as database. The grid displays just fine, only the export failed. I'll spare you the complete traceback and get directly to what

[web2py] Re: Processing taking a long time in web2py?

2016-11-17 Thread Simon Andersson
I'm asking why opening a process in a python script takes much less time than opening the same python code/process in a web2py application. Also yes I will consider your second point but I think I will hide it behind authentication On Thursday, 17 November 2016 22:53:50 UTC, Niphlod wrote: > >

[web2py] Re: Processing taking a long time in web2py?

2016-11-17 Thread Simon Andersson
def run(): import os import subprocess ex = os.path.join('/home/user', "executable") for i in range(2500): a = -5. b = 50.0 proc = subprocess.Popen([ex, str(a), str(b),],stdout=subprocess.PIPE ) (out, err) = proc.communicate()

[web2py] Processing taking a long time in web2py?

2016-11-17 Thread Simon Andersson
Hi I have a function that runs an executable using subprocess. I want to run it in a loop, say 2500 times. When I run this loop in a python script it takes 5 seconds. When I run this loop on a web2py page it takes 23 seconds. When I run this loop in web2py with reading and writing to an sqlite

[web2py] Re: Copy and insert a row in a database

2016-11-09 Thread Simon Andersson
On Tuesday, 8 November 2016 17:54:48 UTC, Anthony wrote: > > > The second argument to .store() should be the original filename (which > will then be encoded again), not a full file path. To get the original > filename, use the .retrieve() method instead of manually constructing the > file path

[web2py] Copy and insert a row in a database

2016-11-08 Thread Simon Andersson
Hi guys, I'm making a function to copy and insert a row of a database. I want to copy and rename a file but the automatic b16 renaming becomes too long and breaks when you make a copy of a copy. It also breaks some of my later processing of the file. Here is some code: def copy(): import

[web2py] Re: data processing conditional on form input

2016-11-08 Thread Simon Andersson
Solution was: def processing(): if db.dbname(db.dbname.id == request.args(0)).file == 'file1': pathDir = /path/to/file1 else: pathDir = /path/to/file2 -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] data processing conditional on form input

2016-11-01 Thread Simon Andersson
Hey guys I have a relatively simple question to ask: I have a form storing my input in an sqlite database. Based on the response in the form I want to choose a certain file stored on the server. How do I go about writing the if statement? eg db = DAL('sqlite://storage.sqlite')

[web2py] Re: SQLFORM.grid links not working

2016-05-09 Thread Simon Carr
Thanks Anthony, I actually got it working using request.args(len(request.args)-1) Your solution is far more elegant. I have not used python for a few years and I forgot about slicing. Thanks Simon On Monday, 9 May 2016 16:37:10 UTC+1, Anthony wrote: > > See my response here: &

[web2py] Re: SQLFORM.grid links not working

2016-05-08 Thread Simon Carr
/supplier_contacts/1 As you can see the supplier_id is not collected by request.args(0). Is it possible for SQLFORM.grid to use url vars i.e. http://127.0.0.1:8000/srm/supplier/view/view/supplier_contacts?supplier_id=1 On Sunday, 8 May 2016 19:45:22 UTC+1, Simon Carr wrote: > > I have an SQLFOR

[web2py] SQLFORM.grid links not working

2016-05-08 Thread Simon Carr
I have an SQLFORM.grid in a view to display a list of supplier contacts When I click "Add Record", I get the error below. Traceback 1. 2. 3. 4. 5. 6. Traceback (most recent call last): File "E:\web2py\gluon\restricted.py", line 227, in restricted exec ccode in environment File

[web2py] Re: Not Authorized - but I don't know why

2016-05-08 Thread Simon Carr
ors#login-required-by-default-for-data-updates > By default all the URLs generated by the grid are digitally signed and > verified. This means one cannot perform certain actions (create, update, > delete) without being logged-in. > > > On Sunday, May 8, 2016 at 11:58:08

[web2py] Not Authorized - but I don't know why

2016-05-08 Thread Simon Carr
Here is the code in my controller. # -*- coding: utf-8 -*- # try something like def index(): return dict(message="hello from supplier.py") def manage_suppliers(): links = [lambda row: A(SPAN(_class='glyphicon glyphicon-search'),' View',_class='button btn

[web2py] How to define tables in a new model file

2016-05-08 Thread Simon Carr
I created a new model and called it data.py I created a definition for a table db.define_table('suppliers', Field('company_name','string'), Field('address1','string'), Field('address2','string'), Field('town','string'),

[web2py] Re: Error No module named copy_reg after upgrading web2py

2016-02-05 Thread Simon Ashley
Having a similar issue this morning. OS: windows 10. Python distribution: Anaconda Have an older project under version 2.9.11 / 214.09.15.23.35.11 which runs OK Have downloaded a fresh copy of web2py from source this morning, and installed in a freshly created directory (c:\w2p_12 rather than

[web2py] Re: Do I need to Install a Date base program

2015-10-29 Thread Simon Ashley
No, just use sqlite. Already configured for it. On Friday, 30 October 2015 09:51:26 UTC+10, Glenn Plummer wrote: > > Since I am very new to web2py software am I correct in saying it does not > contain an actual database and you need to install one if you wish to use > the relational database to

[web2py] Re: Thanks for pydal in pypi, python 3

2015-10-18 Thread Simon Ashley
If you're doing a lot of spreadsheet work, pydal and ipython notebook is a excellent combination. -- 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

[web2py] Re: web2py inspired framework

2015-07-31 Thread Simon Ashley
+1. Quite like it for our use case and plan to direct more resources to it. -- 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

[web2py] Re: web2py 2.11.2 is OUT

2015-05-31 Thread Simon Ashley
On windows 8.1 and Chrome, I'm finding the Welcome screen badly formatted (no visible menus, unusual buttons etc). Under Firefox and IE11. its fine. https://lh3.googleusercontent.com/-yQKhCtaMTqo/VWqtmgjCH9I/Aaw/hcHQ7F-pxCs/s1600/chrome%2B2.11.2.png On Sunday, 31 May 2015 02:37:25

[web2py] Re: Linking directly to an uploaded image

2015-05-04 Thread Simon Marshall
i've been trying to work this out but so far no image is showing, below is my mvc: Model: db.define_table('images', Field('picture', 'upload', uploadfolder=request.folder+'static/uploaded')) Controller: def index(): res = db(db.images).select() #res =

[web2py] if I use the one step production deployment will it overwrite these existing settings?

2015-03-05 Thread Simon Redmond
quick install question, I have postfix,dovecot apache and an ssl cert already installed and configured on my server, if I use the one step production deployment will it overwrite these existing settings? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: web2py static files and bootstrap 3

2015-03-04 Thread Simon Marshall
i would also like to know this please -- 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 Google

[web2py] Web2py deployment with installer script.

2015-02-16 Thread Simon Marshall
Hi All, When installing on a ubuntu server with the install script does it configure the postgresql correctly? if it does what is the default DAL config to use it instead of SQLite? is there any harm in using SQLite in a production environment? Many Thanks, Simon -- Resources: - http

[web2py] queries from SQLFORM.grid and smart grid with related views

2015-02-13 Thread Simon Marshall
on the view/edit buttons i would like to show field from both auth_user and player_stats. would i need to creating a custom view file. Thanks in Advance, Simon -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https

[web2py] Re: Showing menu only after successful login

2015-02-11 Thread Simon Marshall
thank you to you both, i tried each solution and the second one works best for me! Simon -- 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

[web2py] Showing menu only after successful login

2015-02-10 Thread Simon Marshall
Hi All, is there a way to hide the top menu until a person has logged in, i have a requirement that present a user just with a login page before the can do anything on the site. Any suggestion or pointer would be grateful. Thanks Simon -- Resources: - http://web2py.com - http://web2py.com

[web2py] correct way to add more fields to db

2015-02-08 Thread Simon Marshall
the with another file when creating a new layout for specific pages? Best Regards, Simon -- 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

[web2py] extnding tables and modifying layouts

2015-02-08 Thread Simon Marshall
and registration pages? 3. can i override the web2py.css file or is it better to create my own .css and layout file? Many Thanks Best Regards, Simon -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com

[web2py] Re: Australian Users

2014-12-22 Thread Simon Ashley
That's a negative but went to school both ends of Johnston St. Family's in Vic for the holidays while I slave away on the GC on EOY system changes. :) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: Australian Users

2014-12-17 Thread Simon Ashley
Where are you at? -- 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 Google Groups web2py-users

[web2py] Re: presenting None values in SQLFORM.grid

2014-12-11 Thread Simon Ashley
something like this may help: db.table.field.represent = lambda value, row: DIV(value if value else '-', etc...) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] Re: RSVP: Massimo @ Bay Area web2py meetup (refreshments) -- 12/5/2014, 6:30PM - 9:00PM -- BE THERE!!!

2014-11-09 Thread Simon Ashley
Unfortunately, I'm out (snowed under with work). -- 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

[web2py] Re: web2py meetup with Massimo in north Bay Area

2014-09-16 Thread Simon Ashley
Tempted. Feel like an adventure. -- 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 Google

Re: [web2py] getting type 'exceptions.IOError' [Errno 13] Permission denied over and over

2014-09-13 Thread Simon Ashley
Had installed the anaconda distribution so couldn't uninstall just pywin32. (needed it for other apps). No mention of it in the 8.1 registries. Renamed all pywin32 related files to non-descipt file extentions (on Win8.1) and have hammered it for the last 8 hours without issue. Another machine

Re: [web2py] getting type 'exceptions.IOError' [Errno 13] Permission denied over and over

2014-09-11 Thread Simon Ashley
quite painful on win8.1 and web2py™Version 2.9.5-stable+timestamp.2014.03.16.02.35.39PythonPython 2.7.7: C:\Anaconda\python.exe (prefix: C:\Anaconda) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: rname and reserved names

2014-07-22 Thread Simon Ashley
The missing piece was check_reserved=None. -- 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

[web2py] Re: rname and reserved names

2014-07-21 Thread Simon Ashley
Thanks. I could, but need to check this for postgres. Seems a little bit strange when I have a look at the sql.log file: timestamp: 2014-07-21T15:57:35.749000 CREATE TABLE auth_cas( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER REFERENCES auth_user (id) ON DELETE CASCADE,

[web2py] Re: rname and reserved names

2014-07-21 Thread Simon Ashley
Thanks but basically, all we're trying to do is to specifically map the DAL field name to the name as stored in the database, and ascertain why our original scenario/ approach fails. (reserved names maybe only a subset of issues we're trying to avoid. Have a feeling that a QUOTE_TEMPLATE

[web2py] Re: rname and reserved names

2014-07-21 Thread Simon Ashley
Thanks Niphlod, its the latter. A question just concerning rname/ quoting 101. Haven't used it before, and trying baby steps to see how it works. A simple working example would give me a push in the right direction. While Limedrop raises interesting points which I''ll explore but its not where

[web2py] rname and reserved names

2014-07-20 Thread Simon Ashley
Haven't used rname before but the way I read it it should work with reserved names. Have changed a given example to read: db.define_table('easy_name', Field http://127.0.0.1:8000/examples/global/vars/Field('position', rname='this_is_the_field_name'),

[web2py] Re: rname and reserved names

2014-07-20 Thread Simon Ashley
Yep, agree with that but to quote Niphlod *For the ones in need of:* *- accessing legacy tables with some funny names * *- use reserved keywords for table and field names * https://groups.google.com/forum/#!msg/web2py/_q5qcARON4E/6JLCHM3eQHAJ -- Resources: - http://web2py.com -

[web2py] Re: SQLEDITABLE plugin

2014-07-01 Thread Simon Ashley
+1. Very nice work. Thanks you for sharing -- 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

[web2py] Re: cannot access web2py.com today

2014-06-26 Thread Simon Ashley
Finding it flaky as well. Probably AWS playing up again. -- 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: Error while inserting in table with custom id

2014-06-26 Thread Simon Ashley
Believe it will be failing with the id=1 etc. Interfering with the primary key/ auto increment. Try it without. -- 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

Re: [web2py] Re: Error while inserting in table with custom id

2014-06-26 Thread Simon Ashley
I tend to agree with this. We ended up dropping the id field from bulk_insert routines and if we need integrity (for references) in the target databases, we would/ should base it on other fields. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: PyCon AU

2014-04-30 Thread Simon Ashley
No, not an organiser, but thinking/ willing to organise some off agenda web2py functions for those who are interested (papers are about to close, so maybe a bit late for something official). The main issue where you are is the travelling time (30 hours each way ex Chicago), rather than the

[web2py] PyCon AU

2014-04-29 Thread Simon Ashley
Anyone interested in attending http://2014.pycon-au.org/ in Brisbane, in August? -- 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

[web2py] Re: web2py conference, next week!

2014-04-28 Thread Simon Ashley
Wouldn't be adverse to canvassing the idea of a weekend get together somewhere along the east coast ... On Saturday, 26 April 2014 19:47:21 UTC+10, Greg Vaughan wrote: Make the next one in Sydney (Australia) Massimo :) Just joking... all the best for it and looking forward to seeing the

[web2py] Re: Can the DAL produce pivot table query (for use with Google Charts Plugin)?

2014-03-22 Thread Simon Ashley
or if you're not restricted to Google Charts, output the data as json in a request from dc.js. If you're doing a bit of multidimensional analysis, it can be a nice solution. -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Re: Example of web2py integration with an AJAX grid (preferably jquery based) which updates backend db ?

2014-03-07 Thread Simon Ashley
Try the simple things first (good exercise in debugging): 1. ensure that jeditable is being loaded (check the code, and paths) 2. if that passes, put a breakpoint (and the debugger) on the second line (beginning with* id, column*) of *upd_dog_name*. 1. check what *request.vars*

[web2py] Re: I'm speaking at Melbourne PUG about web2py, 30 mins. Tips/e.g. slides?

2014-03-06 Thread Simon Ashley
Where's it being held? -- 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 Google Groups

[web2py] Re: Roadmap

2014-02-27 Thread Simon Ashley
Try some dc.js -- 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 Google Groups web2py-users

[web2py] Re: Problems with the server stalling out. Setting up debuging.

2014-02-02 Thread Simon Ashley
Spin up an instance on Rackspace/ Linmode/ Digital Ocean and compare the result. (have had unpleasant experiences with AWS and elements of this have a similar smell) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] Re: Problems with the server stalling out. Setting up debuging.

2014-02-02 Thread Simon Ashley
runs and it would be a large annoyance to have to transition just one of them. BR, Jason On Sun, 2014-02-02 at 13:26 -0800, Simon Ashley wrote: Spin up an instance on Rackspace/ Linmode/ Digital Ocean and compare the result. (have had unpleasant experiences with AWS and elements

Re: [web2py] Re: Problems with the server stalling out. Setting up debuging.

2014-02-02 Thread Simon Ashley
On Monday, February 3, 2014 8:00:53 AM UTC+10, Simon Ashley wrote: Not saying to move, but to identify where it could be infrastructure related. If so, you can take it up with Amazon support. (YMMV, but we had significant issues leading to deprecation of 8 of our EC2 instances

Re: [web2py] Re: Problems with the server stalling out. Setting up debuging.

2014-02-02 Thread Simon Ashley
at because I use Amazon on many sites my business runs and it would be a large annoyance to have to transition just one of them. BR, Jason On Sun, 2014-02-02 at 13:26 -0800, Simon Ashley wrote: Spin up an instance on Rackspace/ Linmode/ Digital Ocean and compare the result. (have

[web2py] Re: Need opinions/reviews about embedded jquery/javascript XHTML editor

2014-01-16 Thread Simon Ashley
','text',widget=advanced_editor ), .description.represent = lambda v, r: XML(v); On Thursday, 16 January 2014 17:23:18 UTC+10, weheh wrote: Good to hear that, since I just downloaded it. THANKS. Any more opinions? On Thursday, January 16, 2014 2:18:35 PM UTC+8, Simon Ashley wrote: +1

[web2py] Re: Need opinions/reviews about embedded jquery/javascript XHTML editor

2014-01-15 Thread Simon Ashley
+1 CKeditor seems to work fine, generically linked to text based widgets in models. No heavy demands/ extensions through. -- 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] Re: Writing Web2Py specification and finding free lance Web2Py coders

2014-01-13 Thread Simon Ashley
Yep but more community based and focused. W2p is still just a small subset of the hire a contractor market. Elements could be open sourced and used by the wider community as slices. Maybe bounties/ rewards/ competitions to push applications that are currently thought bubbles (albeit mature

[web2py] Re: Writing Web2Py specification and finding free lance Web2Py coders

2014-01-11 Thread Simon Ashley
Often thought that it would be good to push this to another level. We have projects from time to time that would be good to outsource, if people were interested. Something like a project post board, with bidders, assignment, monitoring and completion. -- Resources: - http://web2py.com -

[web2py] Re: Why web2py and AnguljarJS?

2014-01-06 Thread Simon Ashley
One point of view and YMMV. It depends on your application. You can build very effective one page apps (typically the domain of client side tools) with standard w2p components (.js, jquery). After all it's a framework using a mix of tools. One can argue that w2p has broader scope, is more

[web2py] Re: slice added showing technique for inline SQLFORM.grid editing (no plugin)

2013-12-31 Thread Simon Ashley
+1 ... inspired a solution to a long standing issue. May have to take back a few things I've said about Collingwood of late :) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: I'm really struggling - Upload file, parse out variables, display in a table.

2013-12-27 Thread Simon Ashley
Failing any other replies, this is what we do: 1. copy the file to the server (read then write; we get the files first and store them natively, outside a db, for later batch processing ) 2. use ElementTree to parse the file to get a decent dict 3. use the dict in a bulk_insert

[web2py] Re: I'm really struggling - Upload file, parse out variables, display in a table.

2013-12-27 Thread Simon Ashley
A little difficult to share to code (done for a client, its similar and but not exactly what you're doing i.e. maybe a lot more complicated than what you need), but I think you're almost there. You need to upload the files to the server, then parse them to get each dict. My understanding is

[web2py] Re: I'm really struggling - Upload file, parse out variables, display in a table.

2013-12-27 Thread Simon Ashley
1. We just do it in the controller as a function . Try an .insert but .bulk_insert should be fine for individual records. 2. You may need a path to find the file. Following code is cut, pasted and sanitised from a working controller. (for illustration only) ## initiates getting

[web2py] Re: How to represent dynamic fields in table

2013-12-25 Thread Simon Ashley
On a related note, is there a way to control the order/ sequence of the generated fields? (i.e. each time the model is run, generated fields will be returned in a different order) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Pycon 2014?

2013-12-19 Thread Simon Ashley
Just contemplating the 4+ days to get to and from Pycon '14 (Montreal) and although its not on the schedule, wondering if there will be any web2py involvement (official or otherwise) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Format date after selecting field from database

2013-12-09 Thread Simon Carr
I have this line comment_RS = self.db(self.db.aol_comments.aol_id == item.text(0)).select( orderby=~self.db.aol_comments.comment_date) I want to format the date field like dd/mm/ How would I do this in Python? Thanks Simon

[web2py] Loaded SQLForm.grid file upload fails

2013-11-07 Thread Simon Ashley
Have an issue where files can't be uploaded via a SQLFORM.grid form that is loaded/ called via ajax. The update/ create write to the table fails. If a file isn't selected, and other fields are updated, the write is successful. A non ajax called form works OK. The error message following a

[web2py] Re: Loaded SQLForm.grid file upload fails

2013-11-07 Thread Simon Ashley
Thanks Niphlod -- 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 Google Groups web2py-users

[web2py] Re: OLAP python style

2013-11-05 Thread Simon Ashley
+1. Thanks for sharing. Worth further investigation. -- 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: wsgi on directory

2013-11-02 Thread Simon Berry
Please could someone who has actually set up an Apache server with WSGI and successfully mounted www.[domain].com/web2py kindly weigh in on this topic? As a newbie to this group, there seem to be a lot of people requesting this - however none of the solutions posted has worked for me yet...

[web2py] Web2Py, Apache, WSGI and a mount point other than /

2013-11-02 Thread Simon Berry
Does the latest version of Web2Py using Apache and WSGI support a mount point of anything other than /? The following works on my system i.e. when I go to www.[mydomain].com the hello world app comes up. (This is a line from my /etc/apache2/sites-available/www.[mydomain].com file.)

[web2py] Re: Example of web2py integration with an AJAX grid (preferably jquery based) which updates backend db ?

2013-10-07 Thread Simon Ashley
w2p is a great framework with many bells and whistles. Examples/ defaults are full of them. One of the issue when you're learning the framework, you need to take baby steps, and study them one at a time. (particularly if, like myself, you are new to python, js, CSS3, Bootstrap, etc, etc and

[web2py] Re: Example of web2py integration with an AJAX grid (preferably jquery based) which updates backend db ?

2013-10-05 Thread Simon Ashley
Just remark out/ delete the truncate fleas line. If the 'upd_dog_name' function is not called, check installation and calling of jeditable -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: how to assign classes to TDs in SQLFORM.grid

2013-09-24 Thread Simon Ashley
Suspect that a jquery onclick event may be involved, followed by a calculateSum. Would help if you posted a simple example of what you need to happen. (based on lateral thinking/interpretation of your first paragraph) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: how to assign classes to TDs in SQLFORM.grid

2013-09-24 Thread Simon Ashley
May not work out of the box but a hint could include something like $(this).find('td').eq(1).addClass('highlighted') -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list

[web2py] response.js is executed twice unless I set web2py-component-content

2013-09-07 Thread simon
When I set response.js it seems to get executed twice. This is because of the following code in web2py.js: /* run this here only if this Ajax request is NOT for a web2py component. */ if(xhr.getResponseHeader('web2py-component-content') == null) {

[web2py] Re: Example of web2py integration with an AJAX grid (preferably jquery based) which updates backend db ?

2013-09-06 Thread Simon Ashley
Thanks, enjoy. Most of our forms are loaded and still works fine. -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For

[web2py] Re: Example of web2py integration with an AJAX grid (preferably jquery based) which updates backend db ?

2013-09-04 Thread Simon Ashley
Download jeditable, Install in the static/js folder. Include in layout.html i.e. script src={{=URL('static','js/jquery.jeditable.js')}}/script *Model* db.define_table('dogs', Field('dog_name','string')) *Controller:* def populate(): db.dogs.truncate() db.fleas.truncate()

[web2py] Re: Example of web2py integration with an AJAX grid (preferably jquery based) which updates backend db ?

2013-09-03 Thread Simon Ashley
jeditable is reasonably easy to work with for a cell at a time editing, and works with SQLFORM.grids. Have played around with kendoui grids and their editing is some of the nicest. Could put together some crude examples. -- --- You received this message because you are subscribed to the

[web2py] Re: new web2py.js changes the sequence of execution

2013-08-29 Thread simon
On Wednesday, August 28, 2013 1:20:53 PM UTC-7, simon wrote: I have some very simple jquery scripts for creating dialog boxes. This was all working fine until the replacement of web2py.js in release 5113. However now it no longer works. The pre-5113 version had a web2py_ajax_page complete

[web2py] Re: new web2py.js changes the sequence of execution

2013-08-29 Thread simon
alternative headers for that purpose. Please open an issue about this and link back to this thread. Anthony On Wednesday, August 28, 2013 1:20:53 PM UTC-7, simon wrote: I have some very simple jquery scripts for creating dialog boxes. This was all working fine until the replacement of web2py.js

[web2py] new web2py.js changes the sequence of execution

2013-08-28 Thread simon
I have some very simple jquery scripts for creating dialog boxes. This was all working fine until the replacement of web2py.js in release 5113. However now it no longer works. The pre-5113 version had a web2py_ajax_page complete function that first filled my dialog box and then executed

[web2py] Jquery 404 error

2013-08-26 Thread Simon Ashley
Having an issue with passing javascript variables to a controller (as in a click or button call). A common thread running through all the attempts is an error in loading jquery, returning a 404 error. As a simple example, consider the following: *MODEL:* db.define_table('dogs',

Re: [web2py] Jquery 404 error

2013-08-26 Thread Simon Ashley
Thanks for the link. You were right. The error was elsewhere in the example. Will revisit the actual/ primary issue. -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send

[web2py] Re: auth.wiki() allow guests to view the wiki

2013-08-20 Thread Simon Carr
Very sorry, I know now what I was doing. I changed the name of the page from index to Hello World, so when I tried to visit the page it was asking me to create the index page, which of course required me to login. Thanks Simon On Monday, 19 August 2013 21:36:20 UTC+1, Alan Etkin wrote: Hi

[web2py] auth.wiki how to align and resize images

2013-08-20 Thread Simon Carr
I have added a photo to my page using Edit Page Media I have added the following line to my page to display the image @1/road.jpg This gives me the image full size and centered. Is there something I can include on this line to add style such as size and alignment? -- --- You

[web2py] Re: auth.wiki how to align and resize images

2013-08-20 Thread Simon Carr
200px]]. On Tuesday, 20 August 2013 10:28:36 UTC+1, Simon Carr wrote: I have added a photo to my page using Edit Page Media I have added the following line to my page to display the image @1/road.jpg This gives me the image full size and centered. Is there something I can include

[web2py] Re: plugin_clientapi

2013-08-20 Thread Simon Ashley
Thanks Alan, will do so in the next couple of days (after current deadlines) -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to

[web2py] auth.wiki() allow guests to view the wiki

2013-08-19 Thread Simon Carr
Hi, I am trying to make use of auth.wiki() but I am finding that to even a view a wiki page I have to be logged in. I want visitors to be able to view the wiki pages without having to first register an account. How do I do this? Thanks Simon -- --- You received this message because you

[web2py] plugin_clientapi

2013-08-18 Thread Simon Ashley
Alan, you you have a simple example app, that just goes through the basics. Have looking at it and trying to learn it but have come up against configuration issues/ errors. It would help me out if I could study a simple app, that works, to see where I've gone wrong. TIA -- --- You received

[web2py] Re: accounting appliance

2013-08-09 Thread Simon Ashley
You could get a head start by forking this: https://github.com/mdipierro/pacioli -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to

[web2py] is this is postgres issue with groupby?

2013-08-07 Thread Simon Carr
Hi, in the docs it uses this code as an example. for row in db().select( db.person.ALL, orderby=db.person.name, groupby=db.person.name): print row.name Alex Bob Carl When I run this code it fails. rsSuppliers = db().select( db.weekly_data.ALL,

Re: [web2py] is this is postgres issue with groupby?

2013-08-07 Thread Simon Carr
So the web2py documentation is incorrect then and the db.person.ALL line removed from the example. -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from this group and stop receiving emails from it, send an email to

Re: [web2py] is this is postgres issue with groupby?

2013-08-07 Thread Simon Carr
2013 13:15, Simon Carr simon...@gmail.com javascript:wrote: So the web2py documentation is incorrect then and the db.person.ALL line removed from the example. -- --- You received this message because you are subscribed to the Google Groups web2py-users group. To unsubscribe from

[web2py] Re: GET request from kendo ui returning an invalid argument

2013-08-04 Thread Simon Ashley
Solution: This _=1375342185703 is appended by jQuery.ajax which the Kendo DataSource uses under the hood. That thing is used as a cache buster (prevents browser caching). The fix is simple - disable jQuery caching: transport: { read: { url: your service, dataType: jsonp,

  1   2   3   4   5   >