[web2py] Re: web2py 3.0.8 bug

2024-12-13 Thread simon...@gmail.com
r appears immediately - >> File ".../web2py/applications/admin/controllers/default.py", line 1774, in >> make_link >> return to_native(A('"' + tryFile + '"', >> ^ >> NameError: name 'to_native' is not defined >>

[web2py] Re: converting from LDAP to SAML2 authentication

2024-12-05 Thread simon...@gmail.com
, 'attribute_map_dir': full_path('attribute_map_dir'), # where the remote metadata is stored 'metadata': { 'local': [IDP_METADATA], }, } 5) add an "attribute_map_dir" folder with a "saml_unspecified.py" that mapps the field names o

[web2py] Re: web2py 2.99.0-beta

2024-12-02 Thread simon...@gmail.com
quot;') for name in col.split(".")] field = self.rows.db[t][f] Massimo Di Pierro schrieb am Montag, 2. Dezember 2024 um 00:44:59 UTC+1: > Can you please help test version 3.0.7. This port has been painful. > > On Thursday, 28 November 2024 at 03:43:13 UTC-8 simon...@gmail.

[web2py] Re: web2py 3.0.8 is OUT

2024-12-02 Thread simon...@gmail.com
Hi Massimo, I am testing with Python 3.11 and so far, I found one bug in the admin-application: the view on todolist.load uses reduce() which is undefined: name 'reduce' is not defined Version web2py™ Version 3.0.8-stable+timestamp.2024.12.01.23.08.05 Python Python 3.11.2: /home/web2py/myappenv

[web2py] Re: web2py 2.99.0-beta

2024-11-28 Thread simon...@gmail.com
I have a few legacy apps on web2py and I am testing them with Web2Py 3.0.0 on py 3.11 (Debian 12). So far, I found two bugs: 1) Error in ExportClass of sqlhtml.py when using rows.setvirtualfields(). It appears, "_extra" is no longer used by DAL: Traceback (most recent call last): File "/home/w

[web2py] Re: https://web2py.com/book failing with internal error

2024-11-28 Thread simon...@gmail.com
I pulled the latest source from github to test web2py 3.0.0 and there welcome and admin apps are broken. Maybe that's related? Clemens schrieb am Mittwoch, 27. November 2024 um 23:45:45 UTC+1: > I think it's Massimo, but also think it's hosted on PythonAnywhere. > Therefore, if there's a techni

[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 pr

[web2py] no-email edit in profile

2018-12-14 Thread Simon Riek
n't it 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)

[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 I

[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() redirect(URL('he

[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 d

[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 o

[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 cod

[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') db.define_table('

[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
/view/view/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

[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 "E:\web2p

[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 btn-default',_href=URL("supplie

[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 c

[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 rec

[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-30 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. On Sunday, 31 May 2015 02:37:25 UTC

[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 = db(db.images.id==re

[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) - http://githu

[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 G

[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
7;: 'Team Preference', } #Default sort order in grid default_sort_order=[db.auth_user.IOA_number] #query to select the user profile and player stats query = (db.auth_user) form = SQLFORM.grid(query=query, fields=fields, headers=headers, orderby=defau

[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

[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) - https://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 (Rep

[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 t

[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 Group

Re: [web2py] getting " [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 wi

Re: [web2py] getting " [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) - https://c

[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 Go

[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] 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 solutio

[web2py] Re: rname and reserved names

2014-07-20 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-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.

[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 ('position', rname='"this_is_the_field_name"'), rname='"this_is_the_easy_name_

[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 Goo

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) - http://gith

[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 Issues

[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 subscr

[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 expen

[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 messag

[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-21 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/web

[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* ar

[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" g

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

2014-02-02 Thread Simon Ashley
e should seriously be looked 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

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 E

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

2014-02-02 Thread Simon Ashley
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 >

[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) -

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

2014-01-16 Thread Simon Ashley
, value=XML(value), _cols=80) Field('description','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 opin

[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 (Rep

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 ones

[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 - http:

[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

[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) - https://code.google.com/p/web2py/issues/list

[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 fil

[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
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 into

[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 (Sour

[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 (So

[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] 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" g

[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 fa

[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 subsc

[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.) WSGIScript

[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... On

[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 fe

[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) - https://code.google.com/p/web2py

[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/lis

[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] 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.after_ajax(xhr);

[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. *Model* db.define_table('dogs', Field('dog_name','string')) *Controller:* def populate(): db.dogs.truncate() db.fleas.truncate() db.dogs.insert(dog_name='dagwood') db.dogs.insert(dog_name='

[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 Goog

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

2013-08-29 Thread simon
headers were intended for use specifically with >> components. If we want to enable such functionality more generally, perhaps >> we should use alternative headers for that purpose. Please open an issue >> about this and link back to this thread. >> >> Anthony >>

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

2013-08-29 Thread simon
ore generally, perhaps >> we should use 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 som

[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 respons

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, sen

[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', Field('dog_

[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+unsubscr...@googlegroup

[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 c

[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 receiv

[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 E

[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

  1   2   3   4   5   >