[web2py] Re: css rules in database

2010-09-29 Thread annet
Ramjee and Bruno, Thanks for your replies, problem solved! Kind regards, Annet.

[web2py] insert/update multiple record in one form

2010-09-29 Thread annet
I have a table in which users can insert/update css declarations to customize a page's styling. Some sample records: declaration_id1 declaration.company_id 263 declaration_selector body declaration_property background-color declaration.value

[web2py] Re: Google groups posts and Google code changes gadgets?

2010-09-29 Thread Timmie
> I am solving with google groups using rss feed, parsing it with 'pyquery' > > I just need to find a solution to read latest 5 entries in code.google > I can do that using Yahoo Pipes, but it always depend on Yahoo. I tried something similar but could not finish. I'd like to see that type of funct

Re: [web2py] problem about session

2010-09-29 Thread Jason Brower
I think there is a way to save the sessions to a database. It's in the book if I am not mistaken. BR, Jason Brower On 09/29/2010 09:56 AM, hywang wrote: when some one visits my site , a new session file will be created. Then there is a risk : if somebody connects to my site with lots of robots

Re: [web2py] problem about session

2010-09-29 Thread b vivek
If you are on GAE, couldn't sesions be stored in the memcache.That way you would never have the trouble of clearing anything. On Wed, Sep 29, 2010 at 2:17 PM, Jason Brower wrote: > I think there is a way to save the sessions to a database. It's in the > book if I am not mistaken. > BR, > Jason

[web2py] sqlite and vaccum

2010-09-29 Thread winti
Hello, is there a way to reclaim free space in sqlite db's within web2py as described here: http://www.sqlite.org/pragma.html#pragma_auto_vacuum Stefan

Re: [web2py] Learning Management System survey

2010-09-29 Thread Tom Atkins
I am very interested in a web2py Learning Management System (LMS). In fact this is a large part of why I am learning web2py: For the last 6 years I have been delivering courses using Moodle here in Ireland. When I started using Moodle it felt modern and impressive. 6 years later, Moodle feels th

Re: [web2py] Re: welcome app normalize hack ie and html5 ready

2010-09-29 Thread Tom Atkins
Brilliant - many thanks Martin - this is very helpful and great to see web2py looking more beautiful. On 28 September 2010 23:29, Martin.Mulone wrote: > It's cost me a lot of time really, but I think i did it, after many > try, i think the only way we have proper columns (sidebars) is with > fix

Re: [web2py] Re: Learning Management System survey

2010-09-29 Thread Jason Brower
Just so you know. students in finland may make their own copies of books legally. Teachers and other may not, but when it's a book you have permission to copy it as a student. BR, Jason On 09/29/2010 07:34 AM, mdipierro wrote: There are two things to realize... most of the professors want the

Re: [web2py] sqlite and vaccum

2010-09-29 Thread rochacbruno
db.executesql('PRAGMA auto_vacuum = X') ? Enviado via iPhone Em 29/09/2010, às 06:01, winti escreveu: > Hello, > is there a way to reclaim free space in sqlite db's within web2py as > described here: > > http://www.sqlite.org/pragma.html#pragma_auto_vacuum > > > Stefan

[web2py] Re: problem about session

2010-09-29 Thread hywang
dirty connections may cramme in memcache. then, normal connections will be forced out On 9月29日, 下午5时00分, b vivek wrote: > If you are on GAE, couldn't sesions be stored in the memcache.That way you > would never have the trouble of clearing anything. > > On Wed, Sep 29, 2010 at 2:17 PM, Jason Bro

[web2py] Re: problem about session

2010-09-29 Thread hywang
This way reduce the harm but can not solve it. Session should be controlled by every controller but not by new connection. On 9月29日, 下午4时47分, Jason Brower wrote: > I think there is a way to save the sessions to a database. It's in the > book if I am not mistaken. > BR, > Jason Brower > > On 09/

Re: [web2py] sqlite and vaccum

2010-09-29 Thread Jason Brower
Yup, just execute that. :) On 09/29/2010 01:56 PM, rochacbruno wrote: db.executesql('PRAGMA auto_vacuum = X') ? Enviado via iPhone Em 29/09/2010, às 06:01, winti escreveu: Hello, is there a way to reclaim free space in sqlite db's within web2py as described here: http://www.sqlite.org/

[web2py] Re: Meeting Monkey Beta

2010-09-29 Thread slestak
On Sep 28, 9:19 pm, "david.waldrop" wrote: > wow that was quick.  the link is now there. > > On Sep 28, 9:17 pm, b vivek wrote: > > > There seem to be no links ! > > > On Wed, Sep 29, 2010 at 6:40 AM, david.waldrop > > wrote: > > > > Over the past month I have built Meeting Monkey.  It is mean

[web2py] Re: superfish

2010-09-29 Thread mdipierro
everything I see here appears correct. Can we see the generated html? Can you try load the page with firebug and see if you get any error? On Sep 28, 11:50 pm, Rick wrote: > Hi, > > I've put this into a viewer file named layout.html but it doesn't > work: >         > > {{response.files.append(UR

[web2py] Re: Retrieve Password Issue ????

2010-09-29 Thread mdipierro
The only issues I see are [CRYPT()] instead of crypt and 'registration_id' field is missing (but it should be optional). Anyway, try this db.define_table( auth.settings.table_user_name, Field('fullname', length=250, default=''), Field('email', length=128,de

[web2py] Re: VPS.net With Web2py.... Unable to install Application

2010-09-29 Thread mdipierro
You can change it from admin. There is a box on the right of the site page. On Sep 28, 11:56 pm, Yannick wrote: > Thousand thanks. yes this latest solution help. I can now create and > upload new application from admin page. Thanks > > By the way after the installation how can I change the web2py

[web2py] Re: Session data lose...

2010-09-29 Thread mdipierro
I am going to need your help debugging this. In gluon/globals.py if response.session_id: try: response.session_file = \ open(response.session_filename, 'rb+') portalocker.lock(response.session_file,

[web2py] Re: Many to Many TypeError: int() argument must be a string or a number, not 'list'

2010-09-29 Thread mdipierro
Models are executed alphabetically. Make sure that auth=Auth(...) auth.define_tables() are executed before your table definition. On Sep 29, 1:13 am, johntynan wrote: > Thank you for the suggestions, Massimo. > > I've tried to update the model here: > > http://code.google.com/p/publicradioroadt

[web2py] Re: problem about session

2010-09-29 Thread mdipierro
If not request.function=='user': session.forget() will prevent saving sessions for all controller functions but the 'user' one which handles login. On Sep 29, 1:56 am, hywang wrote: > when some one visits my site , a new session file will be created. > Then there is a risk : if somebody connects

[web2py] Re: sqlite and vaccum

2010-09-29 Thread mdipierro
should this be default? On Sep 29, 5:56 am, rochacbruno wrote: > db.executesql('PRAGMA auto_vacuum = X') ? > > Enviado via iPhone > > Em 29/09/2010, às 06:01, winti escreveu: > > > Hello, > > is there a way to reclaim free space in sqlite db's within web2py as > > described here: > > >http://www

Re: [web2py] Re: sqlite and vaccum

2010-09-29 Thread Jason Brower
Can it be done on a live database? If so i dont see why we couldn't. - Original message - > should this be default? > > On Sep 29, 5:56 am, rochacbruno wrote: > > db.executesql('PRAGMA auto_vacuum = X') ? > > > > Enviado via iPhone > > > > Em 29/09/2010, às 06:01, winti escreveu: > >

[web2py] Re: sqlite and vaccum

2010-09-29 Thread Anthony
"Note, however, that auto-vacuum only truncates the freelist pages from the file. Auto-vacuum does not defragment the database nor repack individual database pages the way that the VACUUM command does. In fact, because it moves pages around within the file, auto-vacuum can actually make fragmentati

[web2py] special characters in database credentials

2010-09-29 Thread Josh J
Hey all, I've found an issue with SQLDB when developing my application. The URI handling does not allow special characters in database passwords. Unfortunately, I must connect to the database from my application using a password with special characters. eg. Consider the URI for a database

[web2py] Re: special characters in database credentials

2010-09-29 Thread mdipierro
I think you are right. Can you send me a patch? Or I ca do it but not today. ;-) On Sep 29, 11:01 am, Josh J wrote: > Hey all, > >         I've found an issue with SQLDB when developing my application. The > URI handling does not allow special characters in database passwords. > Unfortunately, I

[web2py] Re: special characters in database credentials

2010-09-29 Thread mdipierro
Ignore my previous email... there is no need with a patch for what you are suggestion...let me think about this some more. On Sep 29, 11:01 am, Josh J wrote: > Hey all, > >         I've found an issue with SQLDB when developing my application. The > URI handling does not allow special characters

Re: [web2py] Re: Meeting Monkey Beta

2010-09-29 Thread Mariano Reingart
Is this useful to coordinate meeting venue, date and time? I send this to some guys from local python user group needing that, someone replied: "complicate UI" and registration required... Why a meeting password? Can it be simplified? As an example, we are using doodle for this now: http://www.dood

[web2py] Re: Learning Management System survey

2010-09-29 Thread Jose Hurtado
That is main reason i am learning web2py :) Features...hmmm... i see 3 points of view: 1. Student. what i want as a student? - Autonomy, i should use it whenever i want, without schedules constrains. - A nice experience, interactivity, keep me engaged. - Use of advanced technologies to improve

[web2py] Searching and indexing a microsoft office documents

2010-09-29 Thread Napoleon Moreno
Good day I will work in a system to save office documents. It is all ok about it with web2py. But i need a feature to searching in those documents. I believe that i need read de documents and keep some kind of index of them. maybe could you help me with a advice to start?.

[web2py] Re: Learning Management System survey

2010-09-29 Thread Jose Hurtado
On 28 sep, 17:53, mdipierro wrote: > web2py.com/survey > > does this already. needs cleanup. Should me turned into a widget so > that quizzes can be embedded into pages via ajax. yes please, would be great!

Re: [web2py] Re: Learning Management System survey

2010-09-29 Thread Tom Atkins
The 'design flaw' relating to course content that you describe Massimo is a very important problem to solve. It comes up a lot in Moodle discussions - how can I reuse content (across courses and / or groups) but not have the wrong people access it at the wrong time. The new Moodle 2 has attempted

Re: [web2py] Searching and indexing a microsoft office documents

2010-09-29 Thread Jason Brower
It would take some work. But you can do it. You would actually install openoffice and use this... http://wiki.services.openoffice.org/wiki/Python It would be a great tool for indexing office documents, but a tough program to get it just right. BR, Jason Brower On 09/29/2010 08:26 PM, Napole

[web2py] Re: Searching and indexing a microsoft office documents

2010-09-29 Thread mdipierro
http://code.google.com/p/ogram/source/browse/ogram/converter/doc2txt.py may be useful. Field('original','upload') Field('content','text',compute=lambda r: doc2txt(r.original),writable=False,readable=False) and use content for searching. User postgresql full text search @@ feature. On Sep 29, 12

[web2py] Re: Searching and indexing a microsoft office documents

2010-09-29 Thread David Marko
On Windows I would use 'Windows Search' as indexing service and COM API to work with it. David On 29 zář, 20:23, mdipierro wrote: > http://code.google.com/p/ogram/source/browse/ogram/converter/doc2txt.py > > may be useful. > > Field('original','upload') > Field('content','text',compute=lambda r:

[web2py] Re: Searching and indexing a microsoft office documents

2010-09-29 Thread mdipierro
Do you have examples? On Sep 29, 1:29 pm, David Marko wrote: > On Windows I would use 'Windows Search' as indexing service and COM > API to work with it. > > David > > On 29 zář, 20:23, mdipierro wrote: > > >http://code.google.com/p/ogram/source/browse/ogram/converter/doc2txt.py > > > may be use

[web2py] jqgrid how can I get my field label?

2010-09-29 Thread Richard Vézina
Hello, I define my field label in my model, but the jqgrid available by plugin wiki not taking them into consideration. How can I get my label instead of field name? Richard

[web2py] Re: Searching and indexing a microsoft office documents

2010-09-29 Thread David Marko
Havent used it yet, but should be available. Or one can use Google Desktop Search and Python API e.g. http://www.iqsoftware.biz/news/python-library-for-gds-4/ David On 29 zář, 20:51, mdipierro wrote: > Do you have examples? > > On Sep 29, 1:29 pm, David Marko wrote: > > > > > > > > > On Window

[web2py] Re: jqgrid how can I get my field label?

2010-09-29 Thread mdipierro
good point. Need to be fixed. Look into /controllers/plugin_wiki.py funciton jqgrid() On Sep 29, 2:23 pm, Richard Vézina wrote: > Hello, > > I define my field label in my model, but the jqgrid available by plugin wiki > not taking them into consideration. > > How can I get my label instead of fie

[web2py] jqgrid sort pb with represent

2010-09-29 Thread Richard Vézina
Hello, I use db.table.field.reprensent=... In that particular case the jqgrid is not able to sort those column instead I use the ID number... Richard

[web2py] Re: Searching and indexing a microsoft office documents

2010-09-29 Thread slestak
Maybe look at the java Lucene libraries. I understand there are some ports to other languages. The Mindtouch wiki I use indexes all the documents that are attached to my wiki. Doc, xls, etc.

Re: [web2py] Re: jqgrid how can I get my field label?

2010-09-29 Thread Richard Vézina
Can't figure out how to get label instead of columns... If I could do : labels = (request.vars.labels or error()).split(',') instead of : columns = (request.vars.columns or error()).split(',') I could then do : fields = [table[f] for f in labels] Richard On Wed, Sep 29, 2010

Re: [web2py] Re: Searching and indexing a microsoft office documents

2010-09-29 Thread Napoleon Moreno
Good afternoon Thanks for your comments. It will work on a lamp server. The databae will be mysql. Is there some issue in this environment? On Wed, Sep 29, 2010 at 2:53 PM, slestak wrote: > Maybe look at the java Lucene libraries. I understand there are some > ports to other languages. The

[web2py] Re: superfish

2010-09-29 Thread Rick
Thanks for taking the time for my problem. I couldn't find any good example that shows how to make a nice menu. While trying different solutions I made a mess of the code. But at the end I made this solution: {{ submenu1=[ ['item1',False,URL(r=request,f='item1')], ['item2',False,URL(r=requ

[web2py] dal connection failed on legacy postgres db

2010-09-29 Thread Oleg Butovich
subj. with error: RuntimeError: unrecognized configuration parameter "standard_conforming_strings" (tried 5 times) I propose set standard_conforming_strings only if it defined.. :) See attached patch # HG changeset patch # User oleg # Date 1285795123 -7200 # Node ID 9de0c834114345fdac603f05d0a68

[web2py] no application URL in function with arguments

2010-09-29 Thread Francisco Costa
Hello! I have the following routes: routes_in = ( ('/$c/$f', '/welcome/$c/$f'), ) routes_out = ( ('/welcome/$c/$f', '/$c/$f'), ) but when I have a function that needs some arguments, the URL link with the 'welcome' application. What should I do?

[web2py] Re: no application URL in function with arguments

2010-09-29 Thread Francisco Costa
I've managed with routes_in = ( ('/(?P.*)', '/welcome/\g'), ) routes_out = ( ('/welcome/(?P.*)', '/\g'), ) but now i can't see some images like: http://domain.com/welcome/controller/download/some.image.png On Sep 29, 11:41 pm, Francisco Costa wrote: > Hello! > I have the following rout

[web2py] Re: no application URL in function with arguments

2010-09-29 Thread Francisco Costa
nevermind.. this last solution works On Sep 30, 12:03 am, Francisco Costa wrote: > I've managed with > > routes_in = ( >     ('/(?P.*)', '/welcome/\g'), > ) > routes_out = ( >     ('/welcome/(?P.*)', '/\g'), > ) > > but now i can't see some images > like:http://domain.com/welcome/controller/down

[web2py] Re: dal connection failed on legacy postgres db

2010-09-29 Thread mdipierro
Which postgresql version to you have? If you don't have this parameter you probably have 8.1 or older. That causes a major security vulnerability with web2py. On Sep 29, 4:44 pm, Oleg Butovich wrote: > subj. with error: > RuntimeError: unrecognized configuration parameter > "standard_conforming_

[web2py] Re: web2py minimalist version

2010-09-29 Thread Richard
thanks - didn't know about that free plan. Pity they haven't translated everything to English. On Sep 29, 8:13 am, Jose wrote: > On 25 ago, 00:15, Kevin wrote: > > > You can remove gluon/contrib/populate.py, which is almost 1 mb. > > > You can also run web2py with `python -OO web2py.py`, and af

[web2py] Re: problem about session

2010-09-29 Thread hywang
it works well. thank you. On 9月29日, 下午9时42分, mdipierro wrote: > If not request.function=='user': session.forget() > > will prevent saving sessions for all controller functions but the > 'user' one which handles login. > > On Sep 29, 1:56 am, hywang wrote: > > > when some one visits my site , a n

[web2py] Re: jqgrid how can I get my field label?

2010-09-29 Thread mdipierro
now plugin_wiki jqgrid has colnames. Please give it a try. You need to get it from cube2py on googlecode. Massimo On Sep 29, 3:41 pm, Richard Vézina wrote: > Can't figure out how to get label instead of columns... > > If I could do : > >     labels = (request.vars.labels or error()).split(',') >

[web2py] Re: Retrieve Password Issue ????

2010-09-29 Thread Yannick
Thanks for the note. I added 'registration_id' and [CRYPT()] but No luck still failing to send the password. The form validation fails in the method reset_password_deprecated() inside Tools.py This is weird... On Sep 29, 9:28 am, mdipierro wrote: > The only issues I see are [CRYPT()] instead of

[web2py] Re: Retrieve Password Issue ????

2010-09-29 Thread mdipierro
Do you have an error or traceback? Anyway, for security reasons you should call request_reset_password instead of retrieve_password which is deprecated because of security issues. Anyway, do you get email on registration? On Sep 29, 10:30 pm, Yannick wrote: > Thanks for the note. I added 're

[web2py] Re: Retrieve Password Issue ????

2010-09-29 Thread Yannick
Yes I also tried quickly and I just retry again request_reset_password. No success, No error message generated. What do you mean my getting email on registration ? Are you talking about getting email confirmation when user register ? If that's what you meant the answer is NO. So basically the re

[web2py] Re: Retrieve Password Issue ????

2010-09-29 Thread mdipierro
try this... python web2py.py -S yourapp -M >>> print mail.send(to='y...@youraddress.com',message='Hi there') do you get the email? what does it print True or False? I think mail is not setup properly. Massimo On Sep 29, 11:13 pm, Yannick wrote: > Yes I also tried quickly and I just retry a

[web2py] Re: web2py minimalist version

2010-09-29 Thread guruyaya
I'm curious, what is populate for, anyway? On Sep 30, 3:13 am, Richard wrote: > thanks - didn't know about that free plan. > Pity they haven't translated everything to English. > > On Sep 29, 8:13 am, Jose wrote: > > > On 25 ago, 00:15, Kevin wrote: > > > > You can remove gluon/contrib/populate