Re: [web2py] Re: table, grid, smartgrid, getting better

2011-10-19 Thread Martín Mulone
I think buttons are under T(), fill a ticket perhaps some are missing 2011/10/18 Tito Garrido > Is there a way to translate the buttons and etc? Is there any documentation > about smartgrid? This thread is so big... it complicated to follow it... > > Regards, > > Tito > > > On Mon, Oct 3, 2011 a

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-10-18 Thread Tito Garrido
Is there a way to translate the buttons and etc? Is there any documentation about smartgrid? This thread is so big... it complicated to follow it... Regards, Tito On Mon, Oct 3, 2011 at 4:49 PM, Phyo Arkar wrote: > Very nice work ongoing .. > > Only sad thing is i am moving into Qooxdoo framew

[web2py] Re: table, grid, smartgrid, getting better

2011-10-06 Thread Anthony
On Thursday, October 6, 2011 3:15:41 AM UTC-4, guruyaya wrote: > > Hummm... multiple databases won't work this way. > Can add the db as a request argument -- something like: @auth.requires_membership('admin') def appadmin(): db = globals().get(request.args(0)) if db and isinstance(db, DAL

[web2py] Re: table, grid, smartgrid, getting better

2011-10-06 Thread guruyaya
Hummm... multiple databases won't work this way. On Aug 18, 7:28 pm, Massimo Di Pierro wrote: > basically we almost get rid of appadmin completely and just do > > @auth.requires_membership('admin') > def appadmin(): >      return dict(form=SQLFORM.grid(db[request.args(0)])) > > On Aug 18, 12:26 p

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-10-04 Thread joseph simpson
Cool. On Tue, Oct 4, 2011 at 3:07 PM, Massimo Di Pierro < massimo.dipie...@gmail.com> wrote: > Wait > > > On Oct 4, 1:15 pm, joseph simpson wrote: > > Just a not to check of the current status of: > > > > The basket book listed below and > > > > The Official Version 4 Web2py book. > > > > Wo

[web2py] Re: table, grid, smartgrid, getting better

2011-10-04 Thread Massimo Di Pierro
Wait On Oct 4, 1:15 pm, joseph simpson wrote: > Just a not to check of the current status of: > > The basket book listed below and > > The Official Version 4 Web2py book. > > Would it be best to buy the Web2py 3.1 edition in paper ... > > Or wait for version 4... > > Take care, > > Joe > > On Th

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-10-04 Thread joseph simpson
Just a not to check of the current status of: The basket book listed below and The Official Version 4 Web2py book. Would it be best to buy the Web2py 3.1 edition in paper ... Or wait for version 4... Take care, Joe On Thu, Aug 18, 2011 at 4:41 PM, Massimo Di Pierro < massimo.dipie...@gmail.

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-10-03 Thread Anthony
On Monday, October 3, 2011 4:42:17 PM UTC-4, Jim S wrote: > > Thanks Anthony, works perfect. Yes, it needs to changeable. > I just submitted a patch. Anthony

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-10-03 Thread Jim Steil
Thanks Anthony, works perfect. Yes, it needs to changeable. I have the following tables: member, campaign and memberCampaign When I'm using SmartGrid to display members, I need the memberCampaign label to say Campaigns, but when I'm using SmartGrid for Campaigns, the memberCampaign label ne

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-10-03 Thread Anthony
>From the code, it looks like you would define _plural at table definition time: db.define_table('memberCampaign', singular='Campaign', plural='Campaigns', ...) But it should probably be made changeable. Actually, for now you can do: db.memberCampaign['_plural'] = 'Campaigns' Anthony On Mond

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-10-03 Thread Phyo Arkar
Very nice work ongoing .. Only sad thing is i am moving into Qooxdoo framework and am getting more and more into it , i am not going to be able to use any of smartgrid .. It have an excellent Table with well written remote model. Hope i can use in web2py way, On 10/4/11, Jim Steil wrote: > Thi

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-10-03 Thread Jim Steil
This didn't work for me, but maybe I'm applying it in the wrong spot. My controller is: @auth.requires_login() def members(): response.view = 'list.html' columns = ['member.firstName', 'member.lastName', 'member.city', 'member.state', 'member.phone', 'member.joinedOn',

[web2py] Re: table, grid, smartgrid, getting better

2011-10-03 Thread Massimo Di Pierro
On Oct 3, 5:07 am, andrej burja wrote: > hi > > how could i add a sum in the linked table? > i have person, linked table payments. Opening the payments table from person > table, displaying only payments from that person, i would like to display > the sum for that person. How can i do that? Tha

[web2py] Re: table, grid, smartgrid, getting better

2011-10-03 Thread andrej burja
hi how could i add a sum in the linked table? i have person, linked table payments. Opening the payments table from person table, displaying only payments from that person, i would like to display the sum for that person. How can i do that? and how to change the label on button 't_payments'? an

[web2py] Re: table, grid, smartgrid, getting better

2011-09-27 Thread Niphlod
yes, in web2py_ajax.js and web2py_ajax.html there are changes (most notably invalidating the "delete" functionality) needed to have smartgrid fully work. So if anyone is coming from an application "initialized" with an old release, adding smartgrid will require at least the declaration of the var

[web2py] Re: table, grid, smartgrid, getting better

2011-09-27 Thread apple
I was adding to an existing application and had not realised I needed to update the static files in the application following the web2py upgrade. Both functions now work fine. On Sep 27, 5:34 pm, Jim Steil wrote: > Delete works fine for me, but I'm not specifying deletable=True.  That > is the d

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-09-27 Thread Jim Steil
Delete works fine for me, but I'm not specifying deletable=True. That is the default. What are you setting for your links parameter? -Jim On 9/27/2011 11:17 AM, apple wrote: There seem to be a few wrinkles to iron out. If I set the links parameter it seems to make no difference to the b

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-09-27 Thread Jim Steil
I believe the default value for ui is now ui='web2py'. So, if you just don't include ui='jquery-ui' then it will default to the web2py ui for the grid. -Jim On 9/27/2011 11:24 AM, Michele Comitini wrote: How do I disable ui='jquery-ui' ?? ui=None does not work --> not a dictionary ui={}

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-09-27 Thread Michele Comitini
How do I disable ui='jquery-ui' ?? ui=None does not work --> not a dictionary ui={} does not work --> error also if the dictionary is not complete I suspect errors all over because of string formatting code. mic 2011/9/27 apple : > There seem to be a few wrinkles to iron out. > > If I set the li

[web2py] Re: table, grid, smartgrid, getting better

2011-09-27 Thread apple
There seem to be a few wrinkles to iron out. If I set the links parameter it seems to make no difference to the behaviour. If I set deletable=True then I get a delete button but the link does not contain an id and does not delete the record automatically. On Sep 27, 2:40 pm, Massimo Di Pierro w

[web2py] Re: table, grid, smartgrid, getting better

2011-09-27 Thread Massimo Di Pierro
Oops, should have be T('%(nrows)s records found') % dict(nrows=nrows) On Sep 27, 8:36 am, Roberto Perdomo wrote: > Can change the line 1556 of sqlhtml.py from: > > message = error or T('%(nrows)s records found' % dict(nrows=nrows)) > > to: > > message = error or '%(nrows)s' % dict(nrows=nrows) +

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-09-27 Thread Roberto Perdomo
Can change the line 1556 of sqlhtml.py from: message = error or T('%(nrows)s records found' % dict(nrows=nrows)) to: message = error or '%(nrows)s' % dict(nrows=nrows) + T(' records found') because every time a new row appear y get 1 records found, 2 records found ... n records found, and i ha

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-09-26 Thread Bruno Rocha
You can set showbuttontext=False you will get only icons. http://zerp.ly/rochacbruno Em 26/09/2011 07:56, "António Ramos" escreveu: > can i create a collapsible/expandable column ? > > Also the edit button and delete button takes a lot of space in the right > side of the table.Also they repeat fo

[web2py] Re: table, grid, smartgrid, getting better

2011-09-26 Thread apple
This grid is fantastic! Is there some documentation? Some specific questions: 1) I am setting "fields" to be displayed based on a configuration file. However if you use the navigation buttons to go to second page then it calls the controller with a "signature" and the table name is no longer in re

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-09-26 Thread António Ramos
can i create a collapsible/expandable column ? Also the edit button and delete button takes a lot of space in the right side of the table.Also they repeat for each row. This i think is not pretty and functional. Could it be improved ? 2011/9/26 JmiXIII > +1 Powertable intant search for each col

[web2py] Re: table, grid, smartgrid, getting better

2011-09-26 Thread JmiXIII
+1 Powertable intant search for each column is really powerfull

[web2py] Re: table, grid, smartgrid, getting better

2011-09-26 Thread JmiXIII
+1 so do I

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-09-26 Thread António Ramos
can i create a collapsible/expandable column ? 2011/9/26 RAMKRISHAN BHATT BACK IN ACTION in bangalore < ramkrishan.bh...@gmail.com> > That would better if add Ajax Globel serch in that. I impressed with > the power table plug in search . > > On Sep 24, 10:48 pm, Ivica Kralj wrote: > > Hi, > > >

[web2py] Re: table, grid, smartgrid, getting better

2011-09-25 Thread RAMKRISHAN BHATT BACK IN ACTION in bangalore
That would better if add Ajax Globel serch in that. I impressed with the power table plug in search . On Sep 24, 10:48 pm, Ivica Kralj wrote: > Hi, > > I'm quite impressed with the features in this release (also it didn't break > anything :) ) > > Just a question for Martin or Bruno, or anybody w

[web2py] Re: table, grid, smartgrid, getting better

2011-09-25 Thread Massimo Di Pierro
You should thank Bruno and Martin for this feature. ;-) On Sep 25, 7:22 am, Ivica Kralj wrote: > Thanks Massimo. > > On 25 September 2011 00:02, Massimo Di Pierro > wrote: > > > > > > > > > Yes they are: > > > grid=SQLFORM.smartgrid(db.person,ui='jquery-ui') > > > On Sep 24, 12:48 pm, Ivica Kral

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-09-25 Thread Ivica Kralj
Thanks Massimo. On 25 September 2011 00:02, Massimo Di Pierro wrote: > Yes they are: > > grid=SQLFORM.smartgrid(db.person,ui='jquery-ui') > > On Sep 24, 12:48 pm, Ivica Kralj wrote: > > Hi, > > > > I'm quite impressed with the features in this release (also it didn't > break > > anything :) ) >

[web2py] Re: table, grid, smartgrid, getting better

2011-09-24 Thread Massimo Di Pierro
Yes they are: grid=SQLFORM.smartgrid(db.person,ui='jquery-ui') On Sep 24, 12:48 pm, Ivica Kralj wrote: > Hi, > > I'm quite impressed with the features in this release (also it didn't break > anything :) ) > > Just a question for Martin or Bruno, or anybody who knows the answer > regarding smartr

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-09-24 Thread Ivica Kralj
Hi, I'm quite impressed with the features in this release (also it didn't break anything :) ) Just a question for Martin or Bruno, or anybody who knows the answer regarding smartrgid/grid and Jquery UI themes application. I've spent few hours searching through this group and couldn't find the an

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-09-23 Thread Roberto Perdomo
Thanks you 2011/9/23 Jim Steil > Ok, do this. > > linked_tables = ['memberTag'] > grid = SQLFORM.smartgrid(db.member, linked_tables=linkedTables) > > Only the related tables included in the list will be displayed. > > -Jim > > On 9/23/2011 2:59 PM, Roberto Perdomo wrote: > > Hi, > > Can I

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-09-23 Thread Jim Steil
Ok, do this. linked_tables = ['memberTag'] grid = SQLFORM.smartgrid(db.member, linked_tables=linkedTables) Only the related tables included in the list will be displayed. -Jim On 9/23/2011 2:59 PM, Roberto Perdomo wrote: Hi, Can I Hide the aditional links created at every row related to

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-09-23 Thread Jim Steil
Yes, you can. Let me look it up... Get back in a few minutes. -Jim On 9/23/2011 2:59 PM, Roberto Perdomo wrote: Hi, Can I Hide the aditional links created at every row related to foreign heys in SQLFORM.smartgrid? I have many tables relationed to the table that I using with smartgrid

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-09-23 Thread Roberto Perdomo
Hi, Can I Hide the aditional links created at every row related to foreign heys in SQLFORM.smartgrid? I have many tables relationed to the table that I using with smartgrid and this added button to that tables making the row very long 2011/9/23 Jim Steil > Add paginate=5 to your smartgrid cal

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-09-23 Thread Jim Steil
Add paginate=5 to your smartgrid call: grid = SQLFORM.smartgrid(db.member, paginate=5) -Jim On 9/23/2011 9:51 AM, António Ramos wrote: But imagine i want a web page with 4 smartgrids. I need space for the 4 smartgrids so i have to make them smaller. How do i resize them to only show for

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-09-23 Thread António Ramos
But imagine i want a web page with 4 smartgrids. I need space for the 4 smartgrids so i have to make them smaller. How do i resize them to only show for example 5 records each? 2011/9/23 Massimo Di Pierro > It paginates automatically > > On Sep 23, 6:50 am, António Ramos wrote: > > how to p

[web2py] Re: table, grid, smartgrid, getting better

2011-09-23 Thread Massimo Di Pierro
It paginates automatically On Sep 23, 6:50 am, António Ramos wrote: > how to paginate with the smartgrid? > > 2011/8/29 stephanl > > > > > > > > > Hi, > > > I found a small bug: > > > You can get to the edit form by clicking the 'Edit' button in one row of > > the grid. > > It calls this URL: >

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-09-23 Thread António Ramos
how to paginate with the smartgrid? 2011/8/29 stephanl > Hi, > > I found a small bug: > > You can get to the edit form by clicking the 'Edit' button in one row of > the grid. > It calls this URL: > http://127.0.0.1:8000/test/default/index/person/edit/person/1?_signature=. > .. > So far so goo

[web2py] Re: table, grid, smartgrid, getting better

2011-08-29 Thread stephanl
Hi, I found a small bug: You can get to the edit form by clicking the 'Edit' button in one row of the grid. It calls this URL: http://127.0.0.1:8000/test/default/index/person/edit/person/1?_signature=... So far so good Using the view button in a row you can get to the non editable form of a

[web2py] Re: table, grid, smartgrid, getting better

2011-08-29 Thread Cliff
No need to do a fresh install. Why clobber all your test data? Check out one or more of the sqlite gui interfaces at this link: http://stackoverflow.com/questions/1507506/what-are-good-open-source-gui-sqlite-database-managers Then drop the column using the gui. On Aug 28, 9:51 am, Juan Tiger

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-28 Thread Juan Tiger
I using sqlite, alter table does not support drop columns, so you must try a fresh install 2011/8/24 Johann Spies > > TypeError: () takes exactly 1 argument (2 given) >> >> >> > I still get this error with the following model (all 'represent' lines > commented out): > > db.define_table('akb_ar

[web2py] Re: table, grid, smartgrid, getting better

2011-08-26 Thread peter
making the 'records found' display conditional upon keywords not being null would be good. Thanks Peter On Aug 26, 11:35 am, peter wrote: > Thanks to Massimo and Bruno for this. It is very nice to be able to > choose the style of the table. A couple of suggestions. It would be > good if the 'vars'

[web2py] Re: table, grid, smartgrid, getting better

2011-08-26 Thread peter
Thanks to Massimo and Bruno for this. It is very nice to be able to choose the style of the table. A couple of suggestions. It would be good if the 'vars' are passed with the 'view', 'edit' etc and then passed back again, so the order and keywords are persistent. It would also be useful if the 'pag

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-24 Thread Johann Spies
> TypeError: () takes exactly 1 argument (2 given) > > > I still get this error with the following model (all 'represent' lines commented out): db.define_table('akb_articles', Field('title'), Field('primaryauthor'), Field('authors', 'text'),

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-24 Thread Johann Spies
On 24 August 2011 13:47, Massimo Di Pierro wrote: > Feature! > > it used to be that represent = lambda value:... > but then we moved on to represent = lambda value, row:... > > previous code has been made backward compatible (will accept both) but > new code (grid and smartgrid) will expect the ne

[web2py] Re: table, grid, smartgrid, getting better

2011-08-24 Thread Massimo Di Pierro
Feature! it used to be that represent = lambda value:... but then we moved on to represent = lambda value, row:... previous code has been made backward compatible (will accept both) but new code (grid and smartgrid) will expect the new syntax. On Aug 24, 5:54 am, Johann Spies wrote: > > TypeErr

[web2py] Re: table, grid, smartgrid, getting better

2011-08-24 Thread GoldenTiger
> Is that a bug or a feature? LOL, good moment to remembering this. Bugs are referred to jokingly as undocumented features "A Bug is Just an Undocumented Feature!" http://en.wikipedia.org/wiki/Undocumented_feature

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-24 Thread Bruno Rocha
Working demo: http://labs.blouweb.com/web2pygrid (Choose a theme) Note that darker themes conflicts with base.css (but this is not a problem, users can override it with !important, in case of use darker themes)

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-24 Thread Bruno Rocha
I solved the typo and I will send it with the patch, because I changed few lines in CSS. On Wed, Aug 24, 2011 at 7:52 AM, Martín Mulone wrote: > Another typo: > > > http://code.google.com/p/web2py/source/browse/applications/welcome/static/css/base.css#593 > > tbody instead ybody. > > It's very ni

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-24 Thread Johann Spies
> > TypeError: () takes exactly 1 argument (2 given) > > It seems this is only when I use certain models. With some other it works nicely. Further experimentation showed that if I removed *format = lambda r: r.nameor T("Unknown") * as well as a *.represent*-line using lambda to show a link it wor

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-24 Thread Martín Mulone
Another typo: http://code.google.com/p/web2py/source/browse/applications/welcome/static/css/base.css#593 tbody instead ybody. It's very nice, another thing yesterday I have an exception using with table auth_membership. 2011/8/24 Bruno Rocha > JqueryUI Applied! (Any Theme from http://jqueryui

Re : Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-24 Thread JmiXIII
Nice Look, I would appreciate sortable function and why not column specific search as you have in PowerTable but I think it might be a bit heavy for minimalist app.

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-24 Thread Johann Spies
With this code: tabel = SQLFORM.grid(db.akb_articles) or tabel = SQLFORM.smartgrid(db.akb_articles) I get the same result except that the reference to line 1631 in sqlhtml.py is not there when I use .grid: Traceback (most recent call last): File "/home/js/web2py/gluon/restricted.py", line 194,

[web2py] Re: table, grid, smartgrid, getting better

2011-08-23 Thread Anthony
By default (with searchable=True), it looks like you just enter keywords, and it finds records that contain the keywords in any of the table fields. The 'searchable' argument can also be a callable that takes a keyword and a list of fields and returns a subquery. Anthony On Tuesday, August 23

[web2py] Re: table, grid, smartgrid, getting better

2011-08-23 Thread Massimo Di Pierro
By default the search performs looks that every keyword that you type appears in any of the fields (string and text only). BUT SQLFORM.grid(,searchable=True) SQLFORM.smartgrid(,searchable=True) take an argument searchable which can be replaced by your own search function which will do:

[web2py] Re: table, grid, smartgrid, getting better

2011-08-23 Thread DenesL
Question: how do you use the search?. I tried query like statements but it did not work Also, there is a typo in the source, sqlhtml.py line 1099 self.accpted = ret should be self.accepted = ret Denes.

[web2py] Re: table, grid, smartgrid, getting better

2011-08-22 Thread Anaconda
For us newbe's, will there be a small tutorial or blogpost showing us how to use it. That will be really cool...good work guys!! On Aug 22, 8:29 pm, Massimo Di Pierro wrote: > So you agree this can be done by simply using custom links? > Would be nice to see an example. > > On Aug 22, 9:4

[web2py] Re: table, grid, smartgrid, getting better

2011-08-22 Thread Massimo Di Pierro
So you agree this can be done by simply using custom links? Would be nice to see an example. On Aug 22, 9:44 pm, Bruno Rocha wrote: > > Anyway, let me know how you think it should work, perhaps I am missing > > something and I am sure it can be improved. > > Welcome already comes with default/dat

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-22 Thread Bruno Rocha
> > Anyway, let me know how you think it should work, perhaps I am missing > something and I am sure it can be improved. Welcome already comes with default/data which is an API for crud, I do that in PowerGrid plugin, buttons calls default/data passing record id (with signature). No need to writ

[web2py] Re: table, grid, smartgrid, getting better

2011-08-22 Thread Massimo Di Pierro
The problem with modal is there are two ways to implement it: 1) using an ajax callback 2) loading one form per item with the page 1) is not a good solution because would require the programmer to create the callback. It is one more step and one that scares lots of people. 2) will make ages heavy

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-22 Thread Bruno Rocha
I am using nyroModal which I think is a very nice modal plugin, but I really think it is time to include jQuery UI in to web2py scaffold. so we an use jQueryUI dialog.

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-22 Thread Kenneth Lundström
+1 for modal option. Why not make it optional. Kenneth On Sunday, August 21, 2011 11:10:23 PM UTC-4, pbreit wrote: That seems unnecessary to me. Easy enough to command-click a link to open in a new tab/window. I think most users won't know/bother to command-click, so a modal might

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-22 Thread Anthony
On Sunday, August 21, 2011 11:10:23 PM UTC-4, pbreit wrote: > > That seems unnecessary to me. Easy enough to command-click a link to open > in a new tab/window. I think most users won't know/bother to command-click, so a modal might be a reasonable option. > And you might not want to reload

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-21 Thread pbreit
That seems unnecessary to me. Easy enough to command-click a link to open in a new tab/window. And you might not want to reload the table window since it could add unnecessary activity on the DB.

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-21 Thread Roberto Perdomo
and new link too 2011/8/21 Roberto Perdomo > Great work, thanks > > I just wanted to make a suggestion, you can place the links to to view and > edit as modal windows , and when close it, reload the table page? > > > > 2011/8/21 mart > >> Hi Massimo, >> >> So all is working great! I just have o

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-21 Thread Roberto Perdomo
Great work, thanks I just wanted to make a suggestion, you can place the links to to view and edit as modal windows , and when close it, reload the table page? 2011/8/21 mart > Hi Massimo, > > So all is working great! I just have one question :) > > i think I am making a real mess of things wh

[web2py] Re: table, grid, smartgrid, getting better

2011-08-21 Thread mart
Hi Massimo, So all is working great! I just have one question :) i think I am making a real mess of things while trying to add an xtra link. this is in my test controller function: def test() table=SQLFORM.grid(db.buildSpec,links=[lambda r:A('build',_href=(f=queue_it ... --> the rest is w

[web2py] Re: table, grid, smartgrid, getting better

2011-08-21 Thread JaapP
Thanks a lot; this works like a charm!! On Aug 21, 4:59 pm, Massimo Di Pierro wrote: > SQLFORM.grid(db.locatie,query=db.locatie.mutatie_user_id==auth.user.id) > > should be > > SQLFORM.grid(query=db.locatie.mutatie_user_id==auth.user.id) > > it will figure out the table automatically > > On Aug 2

[web2py] Re: table, grid, smartgrid, getting better

2011-08-21 Thread Massimo Di Pierro
SQLFORM.grid(db.locatie,query=db.locatie.mutatie_user_id==auth.user.id) should be SQLFORM.grid(query=db.locatie.mutatie_user_id==auth.user.id) it will figure out the table automatically On Aug 21, 7:19 am, JaapP wrote: > Hi Massimo, > > i tried to play a little bit with the 'query=...' part bu

[web2py] Re: table, grid, smartgrid, getting better

2011-08-21 Thread JaapP
Hi Massimo, i tried to play a little bit with the 'query=...' part but i can't get it working; #CONTROLLER def locaties(): locaties = SQLFORM.grid(db.locatie,query=db.locatie.mutatie_user_id==auth.user.id) return dict(locaties=locaties) Error: locaties = SQLFORM.grid(db.locatie,query=

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-19 Thread Richard Vézina
;-D Think we will be needing a recent advance briefing email througth the list... Richard On Fri, Aug 19, 2011 at 5:57 AM, Martín Mulone wrote: > The web2py is advancing so fast, that the documentation get deprecated > before get published. :) > > > 2011/8/18 Massimo Di Pierro > >> Actually I

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-19 Thread Martín Mulone
The web2py is advancing so fast, that the documentation get deprecated before get published. :) 2011/8/18 Massimo Di Pierro > Actually I just killed myself in the foot... I am writing a packt book > with some other members of the list. Have to deliver it in 5 days. > Today 10-20% of the book rec

[web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread mart
hum... i see the predicament... but ;) on the up side, you're Massimo! :) hope it helps :) Mart On Aug 18, 7:41 pm, Massimo Di Pierro wrote: > Actually I just killed myself in the foot... I am writing a packt book > with some other members of the list. Have to deliver it in 5 days. > Today 10-2

[web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Massimo Di Pierro
It now also has a [export] button at the bottom to download in csv. It no longer needs to be passed upload=URL('download'). It handles images and other uploaded files out of the box (if logged in). That's it for today. Sleep time. Massimo On Aug 18, 5:23 pm, Massimo Di Pierro wrote: > New feat

[web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Massimo Di Pierro
Actually I just killed myself in the foot... I am writing a packt book with some other members of the list. Have to deliver it in 5 days. Today 10-20% of the book recipes become obsolete and I have to rewrite them. At the same time I am not ready to commit to the API of the new SQLFORM.grid. :-(

[web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread mart
WOW! Thank you! this is awesome! :) Mart :) On Aug 18, 5:03 pm, Massimo Di Pierro wrote: > This is a new API so it expects a new syntax for represent that takes > two arguments. The second argument is the record. > > On Aug 18, 2:47 pm, pbreit wrote: > > > > > > > > > I'm getting errors on

[web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Massimo Di Pierro
New features added: You can how do db.define_table('x',Field('y')) db.define_table('z',Field('t'),Field('x',db.x)) table=SQLFORM.grid(db.x) as well as db.define_table('x',Field('y')) db.define_table('z',Field('t'),Field('x',db.x)) table=SQLFORM.grid(db.x.id==db.y.x) you

[web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Massimo Di Pierro
This is a new API so it expects a new syntax for represent that takes two arguments. The second argument is the record. On Aug 18, 2:47 pm, pbreit wrote: > I'm getting errors on my tables. auth_user works OK but I get these errors > on three of my other tables. > > Traceback (most recent call las

[web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Massimo Di Pierro
work in progress will be done in 1h On Aug 18, 2:39 pm, mart wrote: > Hi Massimo, > > this looks great! :) > > I have been using the web2pygrid (from the slices page) and I added a > link to the grid. So now I have lunch_build/view/edit/delete where > 'launch_build' will call a function that

[web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Massimo Di Pierro
True. There should be. Will work on it. On Aug 18, 2:39 pm, Daniel Aguayo wrote: > I meant: > when deleting an item from the grid view, is not showing a confirmation box

[web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Massimo Di Pierro
please do On Aug 18, 1:56 pm, Bruno Rocha wrote: > Suggetions: > > include 'button' as class for the links 'view | edit | del' this way we can > use css3buttons or another styles on this, or provide an API to provide our > own classes as: > > table = SQLFORM.grid(db.table, view_class="buttton pos

[web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread mart
sorry for the reports, my post came up mid-way in the thread and wasn't sure if Massimo would see it :) Hi Massimo, this looks great! :) I have been using the web2pygrid (from the slices page) and I added a link to the grid. So now I have lunch_build/view/edit/delete where 'launch_build' will call

[web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Daniel Aguayo
I meant: when deleting an item from the grid view, is not showing a confirmation box

[web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread mart
Hi Massimo, this looks great! :) I have been using the web2pygrid (from the slices page) and I added a link to the grid. So now I have lunch_build/view/edit/delete where 'launch_build' will call a function that simply dumps a file in a local queue. Would it be a hard thing to do the same thing w

[web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Daniel Aguayo
when deleting an item it's not showing a confirmation box as suppose to default (deletable=True)

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread António Ramos
in the book online i searched sqltable Info about "sqltable" No Information Attributes This page is dynamically generated from the source code docstring Where to go to master it? 2011/8/18 Jim Steil > Is there a way to control which columns are displayed in the grid? > > Thanks! > >

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Jim Steil
Is there a way to control which columns are displayed in the grid? Thanks! -Jim On 8/18/2011 12:51 PM, Massimo Di Pierro wrote: More examples SQLFORM.grid(db.mytable,query=db.mytable.somefield=='somevalue') SQLFORM.grid(db.mytable,deletable=False) # default True SQLFORM.grid(db.mytable,ed

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Bruno Rocha
2011/8/18 António Ramos > where can i download this plugin? > This is not a plugin, this is included in web2py in trunk.

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Bruno Rocha
Suggetions: include 'button' as class for the links 'view | edit | del' this way we can use css3buttons or another styles on this, or provide an API to provide our own classes as: table = SQLFORM.grid(db.table, view_class="buttton positive", edit_class="button pill", del_class="button negative")

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread António Ramos
where can i download this plugin? the link http://www.web2py.com/plugins is up to date? thank you António 2011/8/18 Richard Vézina > This sounds so good, like good music to my ears... ;-) > > Richard > > > On Thu, Aug 18, 2011 at 2:21 PM, Bruno Rocha wrote: > >> just tested! very nice! I see

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Richard Vézina
This sounds so good, like good music to my ears... ;-) Richard On Thu, Aug 18, 2011 at 2:21 PM, Bruno Rocha wrote: > just tested! very nice! I see a new version of PowerTable coming based on > this! thanks. > > would be very nice to have a jquery-iu=True|False (default to false) option > to in

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Bruno Rocha
just tested! very nice! I see a new version of PowerTable coming based on this! thanks. would be very nice to have a jquery-iu=True|False (default to false) option to include ThemeRoller classes in to this http://jqueryui.com/themeroller/

[web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Massimo Di Pierro
More examples SQLFORM.grid(db.mytable,query=db.mytable.somefield=='somevalue') SQLFORM.grid(db.mytable,deletable=False) # default True SQLFORM.grid(db.mytable,editable=False) # default True SQLFORM.grid(db.mytable,details=False) # default True SQLFORM.grid(db.mytable,create=False) # default True S

[web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Ross Peoples
This is AWESOME! I haven't tried it yet, but sounds awesome. I have to do this all the time, which is why I created plugin_crud for doing it via AJAX. I will look forward to trying this out and will submit patches for anything that could make it better or more customizable. You guys have done a

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Martín Mulone
Great!. 2011/8/18 Bruno Rocha > this should be SQLTABLE.smart SQLFORM.grid or both? > > -- http://martin.tecnodoc.com.ar

Re: [web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Bruno Rocha
this should be SQLTABLE.smart SQLFORM.grid or both?

[web2py] Re: table, grid, smartgrid, getting better

2011-08-18 Thread Massimo Di Pierro
basically we almost get rid of appadmin completely and just do @auth.requires_membership('admin') def appadmin(): return dict(form=SQLFORM.grid(db[request.args(0)])) On Aug 18, 12:26 pm, Massimo Di Pierro wrote: > You used to do > > def index(): >       rows=db(db.mytable).select() >  

  1   2   >