Re: [web2py] Re: Postgresql Schema in Web2py

2010-05-17 Thread Jean Guy
That way, the DAL or web2py (I don't know the exact wording to use) will be able to put data in my table that allready exist in the postgresql schema where they are? An other problem that I am facing is that I use numeric(length, nb decimal) type of postgresql that type not seems to be supported i

[web2py] what the best practice for the decimal field type

2010-05-17 Thread Jean Guy
Hi, I would like to know if decimal "built in" field type will be created soon? What the best practice untill that time? Jonhy

[web2py] freelancer

2010-05-17 Thread Jean Guy
Is there any freelance here that use web2py for building "data centric web form" application user interface for populating postgresql database? I would like to have primer app (model, view, controler) that will be able to adapt and spread it at large after... Jonhy

Re: [web2py] Re: what the best practice for the decimal field type

2010-05-18 Thread Jean Guy
msg/5290f650358692ee > lists those and many other features. > > > On May 17, 4:51 pm, Jean Guy wrote: > > Hi, > > > > I would like to know if decimal "built in" field type will be created > soon? > > > > What the best practice untill that time? > > > > Jonhy >

[web2py] legacy database id field and sequence

2010-05-18 Thread Jean Guy
Hi, I found this information about legacy database and the id field name : http://groups.google.com/group/web2py/browse_thread/thread/eed21229883b5a1a That seems to work quite well except for one thing... Web2py seems to want a different sequence name. By default PostgreSQL gives sequence name ba

[web2py] unique id (=postgresql serial) is uuid need?

2010-05-19 Thread Jean Guy
Hi, Not sure, I understand uuid the correct way... Do I have to use uuid to ensure that my id will be unique : postgresql serial Thanks Jonhy

Re: [web2py] Script to generate schema (models) from mysql

2010-05-21 Thread Jean Guy
Hi, Really nice! I haven't try it, but I have to do the importation of postgresql database into a web2py model. I was just wondering if you can pointed the place that should be adapt for postgresql, I will change it and return the running code for postgresql. Thanks. Jonhy 2010/5/20 Alexandre

Re: [web2py] Script to generate schema (models) from mysql

2010-05-21 Thread Jean Guy
Hi, Could it be port to all database this way : http://blog.gmane.org/gmane.comp.python.sqlobject/month=20100101 SQLObject ?? Jonhy 2010/5/20 Alexandre Andrade > Some time ago I talk about to do it. > > Finally I have to do it. > > It can be improved to a form in appadmin, use the model to

[web2py] Fwd: legacy database id field and sequence

2010-05-25 Thread Jean Guy
would let the sequences names generated by Postgres as they are because my PK are set to "serial" type field and if I backup my database and recreate it, the wrong names of PK sequence will be recreate and I will have to manually modify them again. Thanks Jonhy -- Forwarded

[web2py] where is : scripts/web2py-wsgi.conf

2010-05-27 Thread Jean Guy
Hi dear web2py crew, I was trying to deploy web2py in production with apache2 under ubuntu server. I follow those informations in the web2py book : http://web2py.com/book/default/section/11/2 I got : admin disabled because unable to access password file What do I have to do... scripts/web2py-ws

Re: [web2py] where is : scripts/web2py-wsgi.conf

2010-05-28 Thread Jean Guy
p***ubuntu.sh will work fine. > > > > 2010/5/27 Jean Guy > > Hi dear web2py crew, >> >> I was trying to deploy web2py in production with apache2 under ubuntu >> server. I follow those informations in the web2py book : >> http://web2py.com/book/default/sect

Re: [web2py] where is : scripts/web2py-wsgi.conf

2010-05-28 Thread Jean Guy
I start getting to the point... I mean, it seems that Deny from all Deny from all As to be to Allow from all Is that correct? But it's not working so far. Jonhy 2010/5/28 Jean Guy > Hi Alexandre, > > Ok! > > What I understand so far is... > &g

Re: [web2py] where is : scripts/web2py-wsgi.conf

2010-05-28 Thread Jean Guy
I got it! I miss the setup script!!! God. I am going to test it right now. Thanks. Jonhy 2010/5/27 Alexandre Andrade > using the script setup***ubuntu.sh will work fine. > > > > 2010/5/27 Jean Guy > > Hi dear web2py crew, >> >> I was trying to deploy

[web2py] combine field validator IS_IN_DB

2010-06-01 Thread Jean Guy
Hello, I would like to know if there is a way to do that : db.define_table('person', SQLField('fname'), SQLField('lname')) db.define_table('dog', SQLField('name')) db.define_table('ownership', SQLField('person', db.person), SQLField('dog', db.dog)) db.ownership.person.requi

Re: [web2py] Re: combine field validator IS_IN_DB

2010-06-01 Thread Jean Guy
wnership.dog.requires = IS_IN_DB(db, 'dog.id', 'dog.name') > > or simply > > db.define_table('person', >SQLField('fname'), > SQLField('lname'),format='%(fname)s %(lname)s') > > db.define_table('dog'

[web2py] current version source??

2010-06-03 Thread Jean Guy
Hi, I would like to know if the source of the current version are fixed or if they change over time? I compared the dal.py and sql.py and they were differents for the same version of current version? Thanks. Jonhy

[web2py] Dropbox with (IS_IN_DB) without requires constrains

2010-06-03 Thread Jean Guy
Hi, I would like to know if there is a way as simple of "requires = IS_IN_DB" to show a dropbox of what is already in my table, but without the need of requiring that field be entered in my other table. I have many fields that need dropbox but they are not all used at the same time (nulls fields :

Re: [web2py] Re: Dropbox with (IS_IN_DB) without requires constrains

2010-06-03 Thread Jean Guy
Wonderful! It works just fine. Thanks. Richard 2010/6/3 Yarko Tymciurak > > On Jun 3, 10:26 am, Jean Guy wrote: > > Hi, > > > > I would like to know if there is a way as simple of "requires = IS_IN_DB" > to > > show a dropbox of what is a

[web2py] unable to install app from a dev in a prod web2py installation

2010-06-03 Thread Jean Guy
Hello, I am unable unpack it in my prod web2py environnement... Is it a Linux permission issue? I pack it from my dev web2py I try to give my app.w2p www-data owner by sudo chown www-data.www-data myapp.w2p Before try to install it in my prod web2py installation. My prod web2py is full fonct

[web2py] get authenticate user id from session

2010-06-08 Thread Jean Guy
Hello web2py geek, How can I get the user id from session ? Thanks. Jonhy

[web2py] getting value of field selected

2010-06-08 Thread Jean Guy
Hello, This : {{=db(db.auth_user.id==auth.user_id).select(db.auth_user.initials)}} Return : auth_user.initials INITIALS I would have : INITIALS How can I do it? Jonhy

Re: [web2py] Re: getting value of field selected

2010-06-08 Thread Jean Guy
Thank you! I was trying with index but fall on tuple at last... Like this : {{=db(db.auth_user.id ==auth.user_id).select(db.auth_user.initials).reponse[0][0]}} But tuple can't be sliced... :) Jonhy 2010/6/8 mdipierro > > > On Jun 8, 4:02 pm, Jean Guy wrote: > >

[web2py] electronic signature

2010-06-08 Thread Jean Guy
Could it be a good practice to implement electronic signature of the database records like this : db.define_table('atable', SQLField('var1'), SQLField('var2',default=db(db.auth_user.id ==auth.user_id).select(db.auth_user.initials).first().initials)) It needs that the user be authentified

Re: [web2py] Re: electronic signature

2010-06-08 Thread Jean Guy
your help. Jonhy 2010/6/8 mr.freeze > I think it would be more useful to record the auth user id instead > since you wouldn't be able to find the corresponding user record from > the initials. > > On Jun 8, 5:29 pm, Jean Guy wrote: > > Could it be a good practice to im

[web2py] adding table to RBAC

2010-06-09 Thread Jean Guy
Hello, I implement the RBAC in my app and I try to figure it out how I can add more table in the dropbox of auth_permission table... There is only the auth_ table in the dropbox... I'm not experienced with RBAC and web2py then the information in web2py book are a bit short to me. Thanks. Jonhy

[web2py] how to do a data picker?

2010-06-09 Thread Jean Guy
Hello, I have different types of data that must be selected, but a dropbox is not adequate. A popup that could list in columns my different data type would be an interesting alternative. Is there exist a plugin that would do that? I search for the code of calendar date picker included in web2py ..

Re: [web2py] how to do a data picker?

2010-06-09 Thread Jean Guy
if your using a 'date' in your model you should have a date picker by > default. > Best Regards, > Jason Brower > > On Wed, 2010-06-09 at 11:10 -0400, Jean Guy wrote: > > Hello, > > > > I have different types of data that must be selected, but a dropbox

Re: [web2py] Re: get authenticate user id from session

2010-06-10 Thread Jean Guy
Thanks it solved the breaking app problem when not connect also. 2010/6/8 mdipierro > auth.user_id is the user id retrived from the session. > > > > On Jun 8, 1:39 pm, Jean Guy wrote: > > Hello web2py geek, > > > > How can I get the user id from session ? > > > > Thanks. > > > > Jonhy >

Re: [web2py] Controller wide auth

2010-06-10 Thread Jean Guy
You are a nice guy! Thank you. Jonhy 2010/6/10 Doug Warren > I've had an issue lately where pretty much every function in a > controller needed an auth decorator. Given how many functions were in > the controller this turned out to be an error prone forgetful process. > So I came up with a

Re: [web2py] Controller wide auth

2010-06-10 Thread Jean Guy
The redirect those not work out of the box... Jonhy 2010/6/10 Jean Guy > You are a nice guy! > > > Thank you. > > Jonhy > > 2010/6/10 Doug Warren > > I've had an issue lately where pretty much every function in a >> controller needed an auth decorator.

Re: [web2py] Controller wide auth

2010-06-10 Thread Jean Guy
%252525252525252525252525252525252525252FTABEL instead of : http://127.0.0.1:8000/dev/default/user/login?_next=/dev/default/TABLE Could it be import urllib that failed? Jonhy 2010/6/10 Jean Guy > The redirect those not work out of the box... > > Jonhy > > 2010/6/10 Jean Guy >

Re: [web2py] Controller wide auth

2010-06-10 Thread Jean Guy
Try to import in ipython it pass... urllib seems to be part of other package in ubuntu : http://stackoverflow.com/questions/2532321/python-importerror-no-module-named-urllib or python-m2crypto Don't know which one is best... Could it depends of python version? Jonhy 2010/6/10 Jea

Re: [web2py] Controller wide auth

2010-06-10 Thread Jean Guy
from > source (not from exe.) I haven't tried it yet in my production > environment. > Try it with the decorator > @auth.requires_login( ) > def index(): >return dict(message="Logged in") > > On Thu, Jun 10, 2010 at 9:11 AM, Jean Guy wrote: > > Try

Re: [web2py] Controller wide auth

2010-06-10 Thread Jean Guy
Don't work. 2010/6/10 Jean Guy > With decorator it works. > > I try with urllib2. > > > Jonhy > > 2010/6/10 Doug Warren > >> I'm not sure actually the code was mostly cut and pasted directly from >> tools.py perhaps it needs an import urllib2

Re: [web2py] Re: best list of jquery plugins I found so far

2010-06-10 Thread Jean Guy
Just remove the /plugins 2010/6/10 Yarko Tymciurak > that comes up as a bad link for me... > > www.jquery.com/plugins redirects to http://plugins.jquery.com -- is > this the one you meant? > > On Jun 10, 11:04 am, mdipierro wrote: > > http://www.jqueryplugins.com/plugins/ >

[web2py] multiple select jquery plugin

2010-06-10 Thread Jean Guy
I don't remember how I come with this link : http://abeautifulsite.net/2008/04/jquery-multiselect/ But it could serve my needs for sometime... I'm not experienced at all with jquery. I would like to use it with web2py mainly cause it seems to let the possibility to group differents query results

Re: [web2py] Re: multiple select jquery plugin

2010-06-10 Thread Jean Guy
n/slices/take_slice/70 > > On Jun 10, 2:02 pm, mdipierro wrote: > > http://web2py.com/plugins/default/multiselect > > > > On Jun 10, 1:57 pm, Jean Guy wrote: > > > > > I don't remember how I come with this link : > http://abeautifulsite.net/2008/04/jquery

Re: [web2py] Re: electronic signature

2010-06-10 Thread Jean Guy
into examples in the docstring > > or in the web based shell type > > > > help(auth.archive) > > > > On Jun 9, 11:53 pm, Christopher Steel wrote: > > > > > Hi Jean Guy, > > > > > Are you talking about record auditing??? > > > > > Y

[web2py] Y'a-t-il des Québécois sur cette liste?

2010-06-10 Thread Jean Guy
[?] Je demandais s'il y avait des québécois qui développe avec Web2py et qui son inscrit sur cette liste? Jean Guy <<330.gif>>

Re: [web2py] Script to generate schema (models) from mysql

2010-06-10 Thread Jean Guy
I'm sorry I didn't have time to look at the script... I try to look at it in the near future. Jonhy 2010/5/22 Alexandre Andrade > I can adapt it on demand to any database for just $100. > Obviously it will be returned to community too. > > I usualy use only mysql, postresql, sqlite and now mo

[web2py] my app instead of welcome app???

2010-06-14 Thread Jean-Guy
Hello, Can't figure it out how to let my app load at 127.0.0.1 on prod server apache under ubuntu... I remove the welcome app and web2py still search to load it. Thanks Jonhy

Re: [web2py] Re: multiple select jquery plugin

2010-06-14 Thread Jean-Guy
On 2010-06-10 15:05, mr.freeze wrote: Another option: http://www.web2pyslices.com/main/slices/take_slice/70 On Jun 10, 2:02 pm, mdipierro wrote: http://web2py.com/plugins/default/multiselect On Jun 10, 1:57 pm, Jean Guy wrote: I don't remember how I come with this link

[web2py] My table won't appear in auth_permission : table name

2010-06-14 Thread Jean-Guy
Hello web2py crowd, How can I make appear my tables in auth_permission "table name" dropbox? Does that I should be able to define permission on them? Thank you. Jonhy

Re: [web2py] error auth_user already exists

2010-06-14 Thread Jean-Guy
On 2010-06-14 11:34, annet wrote: ed something in the db.py file, the file contains the following custom auth_user table: If you are developping and testing using sqlite and your database not content important data... I think you can just erase everything in database folder... Jonhy

Re: [web2py] Re: error auth_user already exists

2010-06-14 Thread Jean-Guy
On 2010-06-14 13:18, annet wrote: is a solution which allows me to keep the tables in the PostgreSQL database. ,migrate=False : at the end of your model... Ex.: db.define_table('atable', SQLField('var1'), SQLField('var2'),migrate=False) modify your table in postgres and define t

[web2py] Re: My table won't appear in auth_permission : table name

2010-06-14 Thread Jean-Guy
On 2010-06-14 10:59, Jean-Guy wrote: Hello web2py crowd, How can I make appear my tables in auth_permission "table name" dropbox? Does that I should be able to define permission on them? Thank you. Jonhy Answering to myself... Here is the solution : http://www.mail-archive.

Re: [web2py] Re: my app instead of welcome app???

2010-06-15 Thread Jean-Guy
On 2010-06-15 02:45, mdipierro wrote: se you do not have too, you can use ruotes already for this purpose. I read somewhere that we should modify the route in apache conf... I know I am not very precise I will try to found back the post of doc files... What the best practice? Jonhy

Re: [web2py] Re: my app instead of welcome app???

2010-06-15 Thread Jean-Guy
On 2010-06-15 02:45, mdipierro wrote: se you do not have too, you can use ruotes already for this purpose. Here : http://www.web2py.com/AlterEgo/default/show/42

[web2py] where are the auth table model?

2010-06-15 Thread Jean-Guy
Hello, I would like to get the auth tables models to implement them in my app cause web2py complain that they already are define when I move change from dev to prod database within the same app... I had found those models, can't remember where they were... ;-) Jonhy

Re: [web2py] Re: where are the auth table model?

2010-06-15 Thread Jean-Guy
On 2010-06-15 11:36, Pai wrote: there's an option to customized it. see below http://web2py.com/book/default/section/8/1?search=Customizing+Auth hope this helps :) Pai On Jun 15, 10:17 am, Jean-Guy wrote: Hello, I would like to get the auth tables models to implement them in m

Re: [web2py] Re: my app instead of welcome app???

2010-06-15 Thread Jean-Guy
On 2010-06-15 11:47, Thadeus Burgess wrote: bah, whats the use. -- Thadeus On Tue, Jun 15, 2010 at 10:14 AM, Jean-Guy wrote: On 2010-06-15 02:45, mdipierro wrote: se you do not have too, you can use ruotes already for this purpose. Here : http://www.web2py.com/AlterEgo/default

Re: [web2py] Re: my app instead of welcome app???

2010-06-15 Thread Jean-Guy
probably won't ever change his mind, so we should just stop arguing the topic. -- Thadeus On Tue, Jun 15, 2010 at 12:05 PM, Jean-Guy wrote: On 2010-06-15 11:47, Thadeus Burgess wrote: bah, whats the use. -- Thadeus On Tue, Jun 15, 2010 at 10:14 AM, Jean-Guy

Re: [web2py] Does DAL supports creating DBs?

2010-06-15 Thread Jean-Guy
On 2010-06-15 15:03, Phyo Arkar wrote: ot sure how DAL of Web2py can create DBs. I think we have to use python-mysql to do the work? When you define a model web2py create the database for you!! You have to tell wich RDBMS you use... db=DAL ('

[web2py] How to change the /default

2010-06-15 Thread Jean-Guy
Hello, I would remove completly default folder in my app... I changed many files to not use default folder anymore, but logout function and initialization of the app still require to reach default/index.html I change my routes.py that way as Massimo wrote : routes_in = (('/', '/app/newfolder

Re: [web2py] Re: Does DAL supports creating DBs?

2010-06-15 Thread Jean-Guy
tdb and it creates. On Jun 15, 7:55 pm, Jean-Guy wrote: On 2010-06-15 15:03, Phyo Arkar wrote:> ot sure how DAL of Web2py can create DBs. I think we have to use python-mysql to do the work? When you define a model web2py create the database for you!! You have to tell wich

[web2py] cosmetic dropbox request

2010-06-16 Thread Jean-Guy
Hello, I use %()s in a IS_IN_DB validator like this : db.reg_registry.registry_id.requires = IS_IN_DB(db,'reg_registry.registry_id','%(num_part1)s-%(num_part2)s-%(num_part3)s') return num_part1 -num_part2 -num_part3 My problem is that %()s seems to add whitespace at the end of the string w

Re: [web2py] Re: cosmetic dropbox request

2010-06-17 Thread Jean-Guy
On 2010-06-16 22:22, mr.freeze wrote: ,lambda row: '%s-%s-%s' % (row.num_part1.rstrip(),row.num_part2.rstrip(), row.num_part3.rstrip()) Works just fine. Thanks! Jonhy

[web2py] requires, requiered or notnull=True

2010-06-17 Thread Jean-Guy
Hello dear web2py friends, What the difference between those validators : requires=IS_NOT_EMPTY() required=IS_NOT_EMPTY() not sure about this one if it is not only a typo error I made and notnull=True Jonhy

Re: [web2py] Re: my app instead of welcome app???

2010-06-18 Thread Jean-Guy
My comment between the text down there... On 2010-06-15 18:51, Yarko Tymciurak wrote: On Jun 15, 1:05 pm, Jean-Guy wrote: On 2010-06-15 13:16, Thadeus Burgess wrote: I ment... whats the use attempting to convince Massimo that this is a good idea although many community members

Re: [web2py] Re: my app instead of welcome app???

2010-06-18 Thread Jean-Guy
Sure but the conf of routes.py seems a bit tricky to me for now and the time I understand it completly I prefer the init symlink that you propose. Thanks Jonhy On 2010-06-18 11:18, mdipierro wrote: This is not a problem if you use routes.py On Jun 18, 9:48 am, Jean-Guy wrote: My

Re: [web2py] Re: my app instead of welcome app???

2010-06-21 Thread Jean-Guy
st On Jun 18, 5:44 pm, Jean-Guy wrote: Sure but the conf of routes.py seems a bit tricky to me for now and the time I understand it completly I prefer the init symlink that you propose. Thanks Jonhy On 2010-06-18 11:18, mdipierro wrote:

[web2py] crud.create hide field

2010-06-22 Thread Jean-Guy
Hello, I would like to use crud.create in my controler instead of SQLForm, but I need to select the fields to be show... form = SQLFORM(db.atable,\ fields=['field1',\ 'field2',\ 'field3',\

Re: [web2py] Re: crud.create hide field

2010-06-22 Thread Jean-Guy
Too easy : Like web2py! I should had think about it... Thank you. Regards. Jonhy On 2010-06-22 12:11, mdipierro wrote: db.atable.field8.writable=db.atable.field8.readable=False form=crud.create(db.atable) On Jun 22, 7:23 am, Jean-Guy wrote: Hello, I would like to use

[web2py] crud.create -> crud.read and crud.update if necessary

2010-06-28 Thread Jean-Guy
Hello, I am trying to figure it out how I may add a button on crud.read form that redirect if pressed on crud.update form. I would like my users to be able to modify their seizures mistakes if they made some... To not make update to the database if the data are correct I redirect them to c

[web2py] subset user list base on group of user

2010-06-28 Thread Jean-Guy
Hello, I would like to make a subset list of user base on auth_group the user are associate and use the subset list in a dropbox using multiselect plugin... I already make work properly multiselect plugin with my app... I search a way to verify the in which group are users and then show the

[web2py] models for auth system

2010-06-29 Thread Jean-Guy
Hello, Where can I find the models of auth tables? Are they stored somewhere in the web2py tree? Jonhy

[web2py] format of fk field

2010-06-29 Thread Jean-Guy
Hello, I know there is a way to show an other field value of the same row for a fk field. Is that correct? How to do it? This work in case of m2m table : If you check in appadmin in membership table the group_id are replaced by the role of the auth_group table... I there a way to do the sam

Re: [web2py] Re: models for auth system

2010-06-29 Thread Jean-Guy
On 2010-06-29 14:30, Chris S wrote: that's what you're looking for. Yes! Thank Chris.

[web2py] built in web2py datepicker bug with Google Chrome

2010-06-29 Thread Jean-Guy
Hello, Is there other user that are having datepicker coming blank when changing the year or mouth couples of time with Google Chrome? I test it with firefox no problem. I use web2py 1.7.8 Jonhy

[web2py] multiselect plugin from web2py slice

2010-06-29 Thread Jean-Guy
Hello, I install multiselect plugin it works just fine... http://web2pyslices.com/main/slices/take_slice/70 But I receive this error when I try to got on a record from the appadmin : Error traceback Traceback (most recent call last): File "/web2py/gluon/restricted.py", line 178, in restrict

[web2py] Re: multiselect plugin from web2py slice

2010-06-29 Thread Jean-Guy
Work around that work actually is to define the widget in the controller : move this from model to controller : db.atable.field1.widget=multiselect_widget Jonhy On 2010-06-29 18:29, Jean-Guy wrote: Hello, I install multiselect plugin it works just fine... http://web2pyslices.com/main/slices

[web2py] How may I do that

2010-06-30 Thread Jean-Guy
Hello, How may I pass the id of my entered record to an other function?? def atable_create(): if auth.has_membership(auth.id_group('group1')): form=crud.create(db.atable,next=URL(r=request,f='atable_read'),message=T('form accepted')) elif form.errors: response.flash = T('f

Re: [web2py] Re: How may I do that

2010-06-30 Thread Jean-Guy
hank you... Jonhy On 2010-06-30 16:58, mdipierro wrote: it is in form.vars.id. You can also use a shotcut: form=crud.create(db.atable,next='atable_read/[id]') On 30 Giu, 15:52, Jean-Guy wrote: Hello, How may I pass the id of my entered record to an other function?? def atable

[web2py] folder default

2010-07-01 Thread Jean-Guy
Hello, I am having difficulties to understand something about web2py... Can we make other folders (different of the default folder) for storing our models, controllers and views or should we most put everything in default folder? I mean if I create other folders and I put my stuff in in when

Re: [web2py] Re: folder default

2010-07-05 Thread Jean-Guy
Thank you... I Like your answers precises and consises... Jonhy On 2010-07-02 03:30, mdipierro wrote: RL(r=request, c='controller_name', f='index')

[web2py] command line interracting with web2py app

2010-07-05 Thread Jean-Guy
Hello, How may I use web2py with ipython shell? I use this command to start ipython with my app : python web2py.py -a '' --shell=APP_NAME -i 127.0.0.1 -p 8000 But db and controller functions are not availables. Jonhy

Re: [web2py] Re: JQGrid Plugin with multiple Databases

2010-07-06 Thread Jean-Guy
I am quite interrested to the incorporation of this plugin in the near future... I will read the thread carefully. Thanks to pay attention about this issue. Jonhy On 2010-07-06 12:59, AsmanCom wrote: Could you advise me a Workaround for that? THX Dieter Asman On 6 Jul., 18:16, mdipierro w

[web2py] web2py prod deployment

2010-07-06 Thread Jean-Guy
Hello, I already had deployed web2py 1.78.3 in prod with the ubuntu script... I would like to know what is the best way to deploy the web2py 1.79.2 over the already deployed web2py installation (1.78.3) : 1) update of web2py 1.78.3 from the admin interface 2) replace the web2py 1.78.3 folder

[web2py] Fwd: web2py prod deployment

2010-07-07 Thread Jean-Guy
It's happen sometime that my emails are blocked somewhere... I is the case for this one... My question down there. Jonhy Original Message Subject:web2py prod deployment Date: Tue, 06 Jul 2010 20:35:20 -0400 From: Jean-Guy To: web2py@googlegroups.com

Re: [web2py] Re: web2py prod deployment

2010-07-07 Thread Jean Guy
subfolders will do the job... Jonhy 2010/7/7 mdipierro > In the admin interface there is a button {upgrade now} and it will do > this for you. Did you try it? > > On 6 Lug, 19:35, Jean-Guy wrote: > > Hello, > > > > I already had deployed web2py 1.78.3 in prod with the ub

[web2py] permission on particular column

2010-07-07 Thread Jean-Guy
Hello, 0 at auth_permission.record_id meens all the table... How may I specify permission only on particular column ?? Thanks Jonhy

[web2py] label field comment

2010-07-09 Thread Jean-Guy
Hello, I would like to change the way the grid of SQLForm or crud is presented : |Field1 Label|Field1|Comment1| |Field2 Label|Field2|Comment2| I would prefer it be like this : |Field1 Label| | |Field1|Comment1| |Field2 Label| | |Field2|Comment2| How may I change it if it is possible? Thank

Re: [web2py] Re: label field comment

2010-07-09 Thread Jean-Guy
M(formstyle='divs') and align the divs yourself. On 9 Lug, 09:18, Jean-Guy wrote: Hello, I would like to change the way the grid of SQLForm or crud is presented : |Field1 Label|Field1|Comment1| |Field2 Label|Field2|Comment2| I would prefer it be like this : |Field1 Label| |

Re: [web2py] Re: label field comment

2010-07-09 Thread Jean-Guy
Great! Jonhy On 2010-07-09 14:39, mdipierro wrote: crud.settings.formstyle='table2cols' (requires trunk but will be in stable next week). On 9 Lug, 10:00, Jean-Guy wrote: formstyle= It's not working with crud?? The solution is ok with SQLFORM. Jonhy On 2010-07-09 1

[web2py] prohibit users to edit their profiles

2010-07-12 Thread Jean-Guy
Hello, It says here : http://web2py.com/book/default/section/8/1?search=profile That this line : http://.../[app]/default/user/profile Control if the user can or not edit their profile by exposing or not the function. I remove it but the users can still edit their profiles. Do I miss somet

[web2py] auth tables migrates false

2010-07-12 Thread Jean-Guy
Hello, I often have to switch between dev and prod db and web2py tells that tables already exist each time I change this line : db = DAL('dbengine://dbengineparameters') in db.py... Normally I can remove the auth tables and let web2py recreate them... I know that I can personalize the auth t

Re: [web2py] Re: prohibit users to edit their profiles

2010-07-12 Thread Jean-Guy
profile page. To block it you need to 1) remove the list (as you did) and 2) auth.settings.function_disabled.append('profile') On 12 Lug, 09:48, Jean-Guy wrote: Hello, It says here :http://web2py.com/book/default/section/8/1?search=profile That this line : http://.../[app]/default/

Re: [web2py] Re: prohibit users to edit their profiles

2010-07-12 Thread Jean-Guy
Little up! Jonhy On 2010-07-12 11:29, Jean-Guy wrote: I get this error : AttributeError:'NoneType'object has no attribute'append' I put this : auth.settings.function_disabled.append('profile') In the db.py and in the user function... Jonhy On 2010-07-12 11:0

[web2py] auth tables definition

2010-07-12 Thread Jean-Guy
Hello, Did I defined my auth tables correctly ? Here is my auth tables definitions : Not sure of the FK in red... auth_table = db.define_table( auth.settings.table_event_name, Field('time_stamp','datetime'), Field('client_ip','string',length=512), Field('user_id',db.auth_user),

Re: [web2py] Re: prohibit users to edit their profiles

2010-07-12 Thread Jean-Guy
entry in the layout?? Or both... Jonhy On 2010-07-12 15:31, mdipierro wrote: auth.settings.actions_disabled.append('profile') On 12 Lug, 10:29, Jean-Guy wrote: I get this error : AttributeError:'NoneType'object has no attribute'append' I put this : auth.settings.

Re: [web2py] Re: prohibit users to edit their profiles

2010-07-13 Thread Jean-Guy
tions_disabled.append('profile') The link to profile is not displayed. Please check it. On 12 Lug, 16:38, Jean-Guy wrote: It raises a 404 error when "modify profil" is cliked... I add those line to catch it up in the user controller: if request.args[0] == 'pr

Re: [web2py] Re: prohibit users to edit their profiles

2010-07-13 Thread Jean-Guy
tions_disabled.append('profile') The link to profile is not displayed. Please check it. On 12 Lug, 16:38, Jean-Guy wrote: It raises a 404 error when "modify profil" is cliked... I add those line to catch it up in the user controller: if request.args[0] == 'prof

Re: [web2py] Re: prohibit users to edit their profiles

2010-07-13 Thread Jean-Guy
y On 2010-07-12 18:22, mdipierro wrote: if in the view you use {{=auth.navbar('welcome',URL(r=request,c='default',c='user'))}} then I just added some code to trunk so that if auth.settings.actions_disabled.append('profile') The link to profile

[web2py] crud.update strange behavior

2010-07-13 Thread Jean-Guy
Hello, I would like to make sure if it is my function that is not correct or the crud.update behavior... Here are my create function and update fuction : @auth.requires_login() def create(): if auth.has_membership(auth.id_group('tech')): form = crud.create(db.atable) db.at

Re: [web2py] Re: prohibit users to edit their profiles

2010-07-13 Thread Jean-Guy
It had a the auth bar in the body of the views I put it into... The profile button is still in the navigatio bar and the bar is duplicate. It not replacing the original bar, not sure that was the goal... Jonhy On 2010-07-13 10:25, Jonathan Lundell wrote: On Jul 13, 2010, at 6:52 AM, Jean-Guy

[web2py] Fwd: crud.update strange behavior

2010-07-13 Thread Jean-Guy
: Jean-Guy To: web2py@googlegroups.com Hello, I would like to make sure if it is my function that is not correct or the crud.update behavior... Here are my create function and update fuction : @auth.requires_login() def create(): if auth.has_membership(auth.id_group('

Re: [web2py] Re: crud.update strange behavior

2010-07-13 Thread Jean-Guy
Ok I short my function for more clarity there is a else clause for the first if in the original function... And I found a solution see my foward. Jonhy On 2010-07-13 11:28, mdipierro wrote: if is false and the second it true?

Re: [web2py] openwysiwyg?

2010-07-13 Thread Jean-Guy
On 2010-07-13 12:50, mdipierro wrote: d making admin lighter. Anybody opposed? Do you mean the text editor built in web2py?? I use it! Jonhy

Re: [web2py] Re: openwysiwyg?

2010-07-13 Thread Jean-Guy
Never used it! Jonhy On 2010-07-13 13:02, mdipierro wrote: on a view [htmledit]. Do you use it?

Re: [web2py] Import csv

2010-07-14 Thread Jean-Guy
Export your actual table you will get the exact format you need csv to have for the import! Cheers Jonhy On 2010-07-14 14:31, Deepan wrote: d is auto increment.

  1   2   >