Re: [web2py] database question

2010-09-24 Thread Jason Brower
On 09/23/2010 09:49 PM, rick wrote: I have three tables: Could you show us the tables you have created? Don't need the data just how they are setup. I can then try to make your query. Br, Jason

[web2py] Re: database question

2010-09-24 Thread annet
I guess you're looking for something like this: In db_00.py: db.define_table('stores', Field('name'), migrate='stores.table') db.define_table('regions', Field('abbr',length=2), migrate='regions.table') db.define_table('store_region', Field('store_id',db.stores),

[web2py] export text to Office?

2010-09-24 Thread Timmie
Hello, I would like to generate template reports for Office with a predefined page header footer similar to was is now possible with PDF. A starting point could be: http://github.com/mikemaccana/python-docx#readme Have there been any attempts to create MS Word files with web2py? Regards,

[web2py] Looping through DAL Rows Object

2010-09-24 Thread b vivek
Ok this is simple I know , but I am sort of not getting it. I have a table named 'spam' and I need the latest three entries of it .. so i do the below:- def home: latestthreespams=db().select(db.spam.ALL,orderby=~db.spam.created_on,limitby=(0,3)) return dict(jingle=latestthreespams) now

[web2py] Consecutive id numbers in GAE

2010-09-24 Thread mdmcginn
Of course, web2py automatically assigns record IDs, but in GAE, they aren't consecutive. That means this code in my view won't work reliably in GAE: a href={{=URL(r=request,f='respond', args=poll.id+1)}}Next/a Here's a suggested solution. How would I implement it in web2py?

[web2py] Re: Deploying web2py on linux (Redhat or others) on cpanel or other ways

2010-09-24 Thread Rahul
All, Can we use Cherokee or Lighttpd instead on a shared host to deploy the application. If yes, how and which would be the easiest. I dont mind using it with Rocket either. All I want is to get it up there and running on CPanel - aka - Shared hosting..

[web2py] Store and retrieve blob

2010-09-24 Thread winti
Hello, i am working on a project where web2py will be used as a online/ offline frontent for mobile users ufor our ERP System. The communication from web2py to the backend system is implemented with the soap library suds. Now i am at the point to deal with exchanging files (pdf, pictures ).

[web2py] GAE appstats problem in app.yaml

2010-09-24 Thread mdmcginn
GAE appstats no longer works in app.yaml for 1.85.3 and some earlier versions (at least using dev_appserver.py) This URL gets response code 500: http://localhost:8080/_ah/login?continue=http://localhost:8080/_ah/stats/ It works if I remove login: admin (below) from app.yaml - url: /_ah/stats.*

[web2py] Re: Deploying web2py on linux (Redhat or others) on cpanel or other ways

2010-09-24 Thread mdmcginn
Have you tried Massimo's solution? http://groups.google.com/group/web2py/browse_thread/thread/bc29ddd40d441a6d# On Sep 24, 3:52 am, Rahul rahul.dhak...@gmail.com wrote: All,    Can we use Cherokee or Lighttpd instead on a shared host to deploy the application. If yes, how and which would be

[web2py] Deployment using Rocket Server only on shared hosting - cpanel

2010-09-24 Thread Rahul
Hi , I have a question. Cant we simply deploy web2py with Rocket only. Not using Apache or any other server to server any requests? Is this possible? Has anyone tried it before? If yes please please let us know how can we achieve it on shared env which we have shell access + virtualenv but no

[web2py] Re: how to use web2py planet?

2010-09-24 Thread Timmie
There is a cron job that fetches rss posts, and you could call If I understand the crontab correctly the server should fetch new posts every minute, correct? This does not happen. refresh() controller to force update. manually calling refresh updates the planet feeds page without problems. I

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

2010-09-24 Thread Christopher Steel
Yannick, Hi Yannick, As I mentioned before this sounds lot like a permissions issue. If you could include the output of the following command when run from the web2py directory on your server it could be very helpful. ls -al | grep applications Where you able to restart Apache and web2py?

[web2py] Re: export text to Office?

2010-09-24 Thread mdipierro
web2py includes pyRTF to generate Rich Text Format. Look into gluon/contrib/pyrtf/ On Sep 24, 2:30 am, Timmie timmichel...@gmx-topmail.de wrote: Hello, I would like to generate template reports for Office with a predefined page header footer similar to was is now possible with PDF. A

[web2py] Re: Looping through DAL Rows Object

2010-09-24 Thread mdipierro
you loop {{for elem in jingle:}} {{=elem.title}} {{pass}} or take a slice {{for elem in jingle[1:2]:}} {{=elem.title}} {{pass}} or pick one {{elem=jingle[1]}} {{=elem.title}} On Sep 24, 2:43 am, b vivek bvivek1...@gmail.com wrote: Ok this is simple I know , but I am sort of not getting it.

[web2py] Re: Issue with concurrency on languages file updating

2010-09-24 Thread Christopher Steel
Hi Fran, I checked out the Sahana Eden \Open Source Disaster Management Platform the other day. WoW! http://eden.sahanafoundation.org Awesome work! Christopher Steel On Sep 22, 5:52 pm, Fran francisb...@gmail.com wrote: Hi folks, I have an issue with concurrency the dynamic updating

[web2py] Re: Deploying web2py on linux (Redhat or others) on cpanel or other ways

2010-09-24 Thread Rahul
All, I did some basic things to run this from scratch with Rocket and it is working like a charm. More details on Monday. Please let me know your feed back on this site below. http://www.flockbird.com:9000/web2py/Flockbird/default/index There is a BugBuster - Bug Tracking application that

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

2010-09-24 Thread Yannick
Hello Chris, Thanks for the note and suggestions: Yes did reboot Apache and Web2py... Here is the result of the command I run in web2py dir: drwxr-xr-x 6 www-data www-data 4096 2010-09-22 04:15 applications From the command it seems that the owner do have permision to read and

Re: [web2py] Re: Looping through DAL Rows Object

2010-09-24 Thread b vivek
Thanks Massimo! On Fri, Sep 24, 2010 at 5:51 PM, mdipierro mdipie...@cs.depaul.edu wrote: you loop {{for elem in jingle:}} {{=elem.title}} {{pass}} or take a slice {{for elem in jingle[1:2]:}} {{=elem.title}} {{pass}} or pick one {{elem=jingle[1]}} {{=elem.title}} On Sep 24,

[web2py] Re: Store and retrieve blob

2010-09-24 Thread mdipierro
if you have db.define_table('a',Field('b','blob')) db.a.insert(b=converted) On Sep 24, 4:34 am, winti stefan.winterb...@gmail.com wrote: Hello, i am working on a project where web2py will be used as a online/ offline frontent for mobile users ufor our ERP System. The communication from

[web2py] Re: GAE appstats problem in app.yaml

2010-09-24 Thread mdipierro
This is not a web2py issue but a GAE issue. Has something changed there and we need to adapt out app.yaml? On Sep 24, 4:55 am, mdmcginn michael.d.mcgin...@gmail.com wrote: GAE appstats no longer works in app.yaml for 1.85.3 and some earlier versions (at least using dev_appserver.py) This URL

[web2py] Re: export text to Office?

2010-09-24 Thread Timmie
web2py includes pyRTF to generate Rich Text Format. Look into gluon/contrib/pyrtf/ I know. But can this also modify page headline and footer? Test the module I recommended. The example document looks very nice. I know that Sahana is also doings something along these lines but they have a

[web2py] Re: Store and retrieve blob

2010-09-24 Thread winti
Thank you massimo, this i tried allready and could store the data but not retrieve in a usefull format... How is it possible for downloading this stored file in field b providing the user a link within web2py ? I allways get rubish back or a huge url with the data stored within this field. Stefan

[web2py] contribute de-de (german) language file

2010-09-24 Thread dustin.b
i only wanna know if there is an interest for a german (admin) language file? for a little project i am doing with w2p (a mockup prototype) it is necessary to translate and change the admin interface. i am almost done and wonder if it is somehow useful ? (after clearing to be useful to a

Re: [web2py] Re: let user choose it membership

2010-09-24 Thread Richard Vézina
Here new version! - It check if user is allowed to change his role. - It protect in case the membership of the user is allowed to modify does not exist - It protect also in case the allowed group set is not define for a particular user (new table auth_group_allowed) What to do : Add this model

Re: [web2py] Re: export text to Office?

2010-09-24 Thread Bruno Rocha
You can try POD ( Python Open Document) http://appyframework.org/pod.html 2010/9/24 Timmie timmichel...@gmx-topmail.de web2py includes pyRTF to generate Rich Text Format. Look into gluon/contrib/pyrtf/ I know. But can this also modify page headline and footer? Test the module I

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

2010-09-24 Thread Martin.Mulone
1) it no longer uses ez.css for layout (id had the options for left and right sidebars for example) now fixed. see http://web2pytesting.appspot.com/sidebars/default/index The lines are commented in layout, to get working have to uncomment sidebar-right and sidebar-left !--div

[web2py] db.table.truncate() does not reset the id

2010-09-24 Thread Johann Spies
I read in the manual: You can truncate the table, i.e., delete all records and reset the counter of the id. My experience is that it deletes all the records but does not resent the counter of the id. I did the following: Export a table to a csv-file. Truncate the table. db.commit() Edit the

[web2py] Re: database question

2010-09-24 Thread ron_m
If a store can only be in one region then you don't need a many to many relation expressed by intermediate table store_region. Instead just put a region_id field in store referencing the region table forming a one to many relation from region to store. You may have a reason for a many to many

Re: [web2py] Re: how to use web2py planet?

2010-09-24 Thread Mariano Reingart
On Fri, Sep 24, 2010 at 8:37 AM, Timmie timmichel...@gmx-topmail.de wrote: There is a cron job that fetches rss posts, and you could call If I understand the crontab correctly the server should fetch new posts every minute, correct? This does not happen. Mmm, maybe a cron configuration

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

2010-09-24 Thread Anthony
Looking great. I'm not sure I'm crazy about the darker blue background of the menus -- I think the original gray looked good, or maybe the lighter blue of the active menu title. I also liked the horizontal lines in between the menu items. Also, at first I was confused by the gray menu items --

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

2010-09-24 Thread Jonathan Lundell
On Sep 24, 2010, at 8:12 AM, Martin.Mulone wrote: 3) I would still like the flash to be black because works ... fixed. this is the welcome: http://web2pytesting.appspot.com/welcome/ With all that white space in the header, could you move the flash somewhere (centered, perhaps?) where

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

2010-09-24 Thread Jonathan Lundell
On Sep 24, 2010, at 8:57 AM, Anthony wrote: Looking great. I'm not sure I'm crazy about the darker blue background of the menus -- I think the original gray looked good, or maybe the lighter blue of the active menu title. I also liked the horizontal lines in between the menu items. I'm

Re: [web2py] Re: let user choose it membership

2010-09-24 Thread Richard Vézina
Hello, There is still problem with the design... The function is not protecting from the definition of group set that could include an other group the in which the user is already involved. The user is allowed to change from only one group, so if we use other groups for other purpose (like

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

2010-09-24 Thread dustin.b
hi, i followed your topic and your work is pleasing to the eye :) thx for that! but i also agree with the others about that menu gray visited links thing.

[web2py] Re: how to use web2py planet?

2010-09-24 Thread Tim Michelsen
Mmm, maybe a cron configuration problem. I did have some issues with that too (using apache / external cron) A workaround is to add a wget .../refresh to the o.s. crontab to force updates. Would you consider this as a bug in cron?

Re: [web2py] Re: how to use web2py planet?

2010-09-24 Thread Mariano Reingart
On Fri, Sep 24, 2010 at 3:23 PM, Tim Michelsen timmichel...@gmx-topmail.de wrote: Mmm, maybe a cron configuration problem. I did have some issues with that too (using apache / external cron) A workaround is to add a wget .../refresh to the o.s. crontab to force updates. Would you consider

[web2py] JQuery plugin

2010-09-24 Thread Rick
Hi, I'd like to make a button that generates a sound when clicking on it. This JQuery plugin was the best way I could found: http://plugins.jquery.com/project/sound and I wrote this code: views/default/index.html: {{extend 'layout.html'}} div

Re: [web2py] JQuery plugin

2010-09-24 Thread Bruno Rocha
You should append JS files before the {{include 'web2py_ajax.html'}} views/layout.html: head {{response.files.append(URL(r=request,c='static',f='jquery.sound.js'))}} {{include 'web2py_ajax.html'}} /head and in your div the OnClick event is used in the wrong way, it is not

[web2py] Re: JQuery plugin

2010-09-24 Thread Rick
Thanks! I think there are better plugins for this purpose than this sound- plugin. But now I know how to install it into my application. On Sep 24, 8:26 pm, Bruno Rocha rochacbr...@gmail.com wrote: You should append JS files before the {{include 'web2py_ajax.html'}} views/layout.html:        

Re: [web2py] Re: JQuery plugin

2010-09-24 Thread Bruno Rocha
You can use the new audio tag from HTML5, but this should not work on every browser audio src={{=URL('static',args='horse.ogg')}} controls=controls Your browser does not support the audio element. /audio 2010/9/24 Rick sababa.sab...@gmail.com Thanks! I think there are better plugins for

[web2py] Re: JQuery plugin

2010-09-24 Thread mdmcginn
Or you could use unobtrusive Javascript http:// www.smashingmagazine.com/2008/09/16/jquery-examples-and-best-practices/, where onClick isn't necessary in the HTML because it's inserted by jQuery. On Sep 24, 4:42 pm, Bruno Rocha rochacbr...@gmail.com wrote: You can use the new audio tag from

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

2010-09-24 Thread Martin.Mulone
I already fix this issue, and put the notification more centre. You can see the changes in: Html5 test font and edit content http://web2pytesting.appspot.com/html5 And the notification example http://web2pytesting.appspot.com/notification/ On Sep 24, 2:34 pm, dustin.b

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

2010-09-24 Thread Jonathan Lundell
On Sep 24, 2010, at 3:05 PM, Martin.Mulone wrote: I already fix this issue, and put the notification more centre. Nice. The web2py flash is a slightly difficult design problem, in that its size is rather unpredictable. I like Gmail's approach of reserving a bit of space for their flash to

[web2py] Re: JQuery plugin

2010-09-24 Thread Magnitus
Assuming that you know how to create sound effects in regular Javascript, making your own pluggin for it doesn't seem that difficult. Lets assume that you want a pluggin that affect only div elements in a wrapped set and you want to be able to specify the sound... It'd look something like this

[web2py] Question about CRUD forms and compute values

2010-09-24 Thread Bernardo
Dear all, The question is that I have a compute value defined on my model this way: Field('n_lote', compute = lambda r: str(r['fecha']).replace(-, ) + str(r['cliente_id']), required = True) When I try to make a form from my controller to read the record on the database table, like this: form

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

2010-09-24 Thread Luis Díaz
Greetings, there is an option select multiple problems. should have at least 5 lines minimum to select various options to see -- Díaz Luis TSU Analisis de Sistemas Universidad de Carabobo

[web2py] Re: Store and retrieve blob

2010-09-24 Thread mdipierro
How are you retrieving it? Are you setting a content type and content disposition in the header? On Sep 24, 8:41 am, winti stefan.winterb...@gmail.com wrote: Thank you massimo, this i tried allready and could store the data but not retrieve in a usefull format... How is it possible for

[web2py] Re: db.table.truncate() does not reset the id

2010-09-24 Thread mdipierro
It incorrect in the manual. On Sep 24, 10:27 am, Johann Spies johann.sp...@gmail.com wrote: I read in the manual: You can truncate the table, i.e., delete all records and reset the counter of the id. My experience is that it deletes all the records but does not resent the counter of the