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

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

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

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

+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

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: Australian Users

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

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

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!!!

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

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

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

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

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

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

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

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

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

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

+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

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

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

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

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

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!

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

> > 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 ?

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?

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

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.

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.

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.

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.

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

, 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

+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

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

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?

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

+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.

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.

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.

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

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?

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] Re: Loaded SQLForm.grid file upload fails

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

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

> > +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] Re: Example of web2py integration with an AJAX grid (preferably jquery based) which updates backend db ?

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 ?

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

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

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: Example of web2py integration with an AJAX grid (preferably jquery based) which updates backend db ?

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 ?

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 ?

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

Re: [web2py] Jquery 404 error

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

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

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] plugin_clientapi

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 t

[web2py] Re: accounting appliance

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

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

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

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

Have been playing with Kendo UI and have an issue where a GET request to a w2p service returns an invalid argument error. Kendo places a callback at the end of the address in the form of: http://127.0.0.1:8000/dogsfleas/dogs/api/dogs* ?callback=jQuery1910806812594877556_1375342185702&_=1375342185

Re: [web2py] Re: Memory leak, SQLite, Windows (7, 2008)

Thanks, that's good to know ... -- --- 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 more options, visit https://groups

[web2py] Re: Memory leak, SQLite, Windows (7, 2008)

Thanks, its clearer now. (coming from a different environment, takes a while for aspects to sink it.) Have converted main tables off SQLite and reduced the updates down to a minute. Sorry about the db(query).update(**arguments) (didn't read it properly - wasn't actually my code ...) Apprec

[web2py] Re: Memory leak, SQLite, Windows (7, 2008)

Thanks Simone, A little more on this. Seems to to be an issue with windows consuming memory and grinding the system to semi halt. The characteristic isn't there in Linux. (ubuntu under vmware hosted by win7) Are you sure on db(query).update(**arguments) ? (seems to fall over with too many

[web2py] Re: Memory leak, SQLite, Windows (7, 2008)

Ok, here's the reality. Benchmarking on 10k records (either method), you get a through put of approximately 100 records a second (should complete in 1.5 hours). The row.update completes in 3.5 hours. The update_or_insert takes > 7 hours. (with available memory maxed out, no caching involved.

[web2py] Re: Memory leak, SQLite, Windows (7, 2008)

Thanks Niphlod Yep, sorry for the typos (@ 4am the brain doesn't function correctly). Main point was to describe the 2 methods. (*update_or_insert *and *row.update_record*) Actual code would have been too heavy. Routines were tested with limitby=(0,1000) in the selects. Caching only involved i

[web2py] Memory leak, SQLite, Windows (7, 2008)

Experiencing memory leaks when updating 500k records using either of the following routines. Quite reproducible, and running tests on both windows 7 and 2008 servers (servers with 8 and 12G ram) Initial speed tests suggest 100 recs per second, but routines fail to complete after 3 hours. Have

[web2py] Re: Scheduler - calling functions outside a model?

Thanks Simone, Turned out to be the following: path = os.path.join(request.folder, 'data\\') - os.chdir(path) - for files in os.listdir('*.*'): + for files in os.listdir(path): -- --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubs

[web2py] Re: Scheduler - calling functions outside a model?

2.4.6 - stable -- --- 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 more options, visit https://groups.google.com/group

[web2py] Re: Scheduler - calling functions outside a model?

Went close with the LOAD('controller', 'yourfunction'), but fell at the environment when trying to write to the sql.log i.e. Traceback (most recent call last): File "C:\web2py19\gluon\scheduler.py", line 237, in executor result = dumps(_function(*args, **vars)) File "applications\xml2\mod

[web2py] Re: Scheduler - calling functions outside a model?

Extending on from my earlier reply, (which hasn't shown up yet), I think what you're suggesting is to store the code as a module, and import it as required from a model. Am I correct in assuming that this would have less performance impact than storing the code in a model? -- --- You receive

[web2py] Re: Scheduler - calling functions outside a model?

irements... how can a "controller" > function can be scheduled as a task? > On the last comma you talk about extensive routines: aren't they in a > module ? > > On Saturday, May 4, 2013 4:12:21 PM UTC+2, Simon Ashley wrote: >> >> Have a query on the scheduler

[web2py] Scheduler - calling functions outside a model?

Have a query on the scheduler and whether functions need to be defined inside a model or can be offload to a controller? (have seen a passing comment by Niphlod - which I can no longer find - that it may not be the case with ComfortScheduler but haven't been able to confirm it or worked out how

[web2py] Re: DAL update with a accumated field

Sorry, the error should have read: File "C:/web2py16/applications/lconfirm/controllers/dogs.py" , line 27, in update_flea_count db.dogs.update_or_insert(db.dogs.dog_name == row.dog_name, AttributeError: 'Row' object has

[web2py] DAL update with a accumated field

Having problems updating from with a row with a db.table.field.count() field (similarly with sum(), min(), max() etc.) i.e. def update_flea_count(): query = db(db.fleas.id>0).select(db.fleas.dog_name, db.fleas.flea_name.count(), orderby=db.fleas.dog_name, groupby=db.fleas.dog_name) for

[web2py] Re: 2 grids loaded in a single form: back button reference

Thanks Niphlod, that worked. (Eventually. Had some weird caching going on. The submit was originally redirecting to an unrelated controller and function. Eventually cleared itself after deleting and reinserting the formname attribute. Using current trunk) -- --- You received this message

Re: [web2py] Date null display

Thanks Bruno, that works. (had tried that earlier, but didn't get it. Time to flex off for the weekend, me thinks) -- --- 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 e

[web2py] Date null display

Traditionally in other field types you could display a null value with an expression similar to the following: db.table.datefield.represent = lambda value, row: A(value) if value else 'unknown' Occasional we have a requirement to display null values as alternatively i.e. None, Unknown, Not rec

[web2py] 2 grids loaded in a single form: back button reference

Trying to embed multiple grids (or at least 2 of them) on a single page using load statements as per the following controller, functions and views. It seems to work fine until you click view or edit, from the called grid, on the calling grid (step2). The related edit and view seem to be rendered

[web2py] Re: smartgrid - display linked_tables link as a dropdown button instead

My original post hasn't turned up yet, so this may be a duplicate. There was an earlier request (last year) by Massimo, with code written by Martin Mulone to address the dropdown button issue. It may have slipped through the system and never implemented. https://groups.google.com/forum/#!search

[web2py] Re: smartgrid - display linked_tables link as a dropdown button instead

Its high on our list as well. That plus a denser edit/create/view layout similar to Scubism's Solid Form. --

[web2py] Re: Amazon RDS

Never mind - RTFL. Above string works fine .Issue in the security groups. --

[web2py] Amazon RDS

Wondering if it is possible to connect an EC2 instance/ application to a RDS instance (MYSQL), and what the connection string should be? There is some discussions here implying that it may be possible but uncertain of the connection string. What's been suggested is db = DAL('mysql//"*connection

Re: [web2py] Re: cpdb errors

> > *Final conclusion:* memory leak confined to pg8000. psycopg2 works fine in Windows and Linux. > > > --

Re: [web2py] Re: cpdb errors

I hate this. Its fixed (stable) for the time being, but cant clearly identify the cause. I'm sure that there is a still memory leak and it may appear again.. Early in the process, Ubuntu was acting similarly to Windows 7 i.e. consuming memory when importing the csv file and eventually failing.

Re: [web2py] Re: cpdb errors

9.1 (fresh install yesterday) --

Re: [web2py] Re: cpdb errors

Just confirming that csv imports fail with Postgres on Ubuntu 12.10, but both sqlite and mysql import fine. Suspect its a postgres issue, and will attempt different adapters/ refactor of the DAL table def to try and identify the cause Error message is fairly generic.

[web2py] Re: Web2Py on AWS Elastic Beanstalk

Isaac, if you do a search on this group, you'll find a bit more info. Failing that, we may need to do the same in the next few days ... --

[web2py] Re: cpdb errors

That's a negative on cache.py. It's from a nightly build pulled about 5 days ago. The csv in question is about 150k records. (have pruned it down to a test of 10 records, and they import OK). Has about 140 fields, quite a few nulls, and have compensated for the adapter's postgres decimal precisi

[web2py] Re: cpdb errors

Thanks Mart, That gives me some clues and a renewed focus. Issue may be with postgres (at least the install I had - has been deleted and will be installed). Will also try ubuntu environment. Will report back ... --

[web2py] Re: cpdb errors

Thanks Mart, That's sort of fixed it, but starting to get additional issues with the auth tables. Think have seen this before with csv imports and have gotten around by deleting suspe

[web2py] Re: cpdb errors

Interesting but encountering similar problems to *backseat *on windows 7 using the following command from a prompt in web2py root folder: i.e. c:\web2py> set path=%path%;c:\web2py\gluon c:\web2py> c:\python27\python scripts\cpdb.py -d gluon -f application\app\databases -y 'sqlite://storage.sqli

Re: [web2py] Multiple connections/ databases with same app

Sorry Alec, I saw that just as posted it and tried to delete it. It came through again afterwards. This wasn't the issue, just an example returning the same error. Solved it ... was in the query=db() statements, which should have been changed to query=db1() etc. Thanks for your reply.

Re: [web2py] Multiple connections/ databases with same app

Ok then, should this work? (Version 2.3.2 (2012-12-17 15:03:30) stable, source, nightly build, from 12/31) *Connection* db = DAL('sqlite://storage.sqlite',pool_size=1,check_reserved=['all']) db1 = DAL('mysql://root:www@localhost:3306/xxx', migrate=True, fake_migrate= False, check_reserved=['commo

[web2py] Multiple connections/ databases with same app

Quick question - is this do able i.e. some tables - e.g. db = DAL('sqlite://storage.sqlite), other tables - db1 = DAL('mysql://root: ) etc, within the same application/controller/function? If so, will write up an issue we're having. TIA --

Re: [web2py] Conditional {{extend layout.html}}?

Thanks, excellent, that works .. (compiling wont been an immediate issue) >> >> > > --

[web2py] Conditional {{extend layout.html}}?

Wondering if it is possible to have a conditional {{extend layout.html}} similar to the following? {{if session.call:}} {{extend 'layout_XXX.html'}} {{pass}} {{if not session.call:}} {{extend 'layout.html'}} {{include 'YYY.html'}} {{pass}} Required for users with requiring diff

Re: [web2py] Re: we should support this in DAL

The bottom line seems to be that we/ others need to start to use nosql engines to sort the issues. My guess is that, currently, critical mass is not present to rely on it for production sites. --

Re: [web2py] Re: we should support this in DAL

In the not to distant future we need to refactor reasonable large SQL databases. Current open source choices are limited to MySQL and PostgreSQL. (trying to avoid vendor lock in issues). Interest in this thread is as a prompt to explore nosql pros and cons. Both SQL options are mature, well de

[web2py] Re: we should support this in DAL

+1 for moving in this direction. On Saturday, November 17, 2012 10:19:15 PM UTC+10, Massimo Di Pierro wrote: > > http://labs.codernity.com/codernitydb/index.html > --

  1   2   >