Re: [web2py] Re: manage rooms places

2016-01-27 Thread Laurent Lc
Managing ressources (rooms,equipment and so on) Le 28 janv. 2016 12:09 AM, "Massimo Di Pierro" <massimo.dipie...@gmail.com> a écrit : > It is french. No idea what it does. :-( > > On Wednesday, 27 January 2016 02:23:56 UTC-6, Laurent Lc wrote: >> >> Hi, >

[web2py] manage rooms places

2016-01-27 Thread Laurent Lc
Hi, Do you know if there is an existing app similar as grr (http://grr.devome.com/fr/) for web2py ? thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues)

[web2py] Re: web2py.app.booking.w2p??? Booking system??

2016-01-27 Thread Laurent Lc
di you get it ? I am interested Le mercredi 26 octobre 2011 21:19:40 UTC+2, Ismael Serratos a écrit : > > Hi! Everybody!! I've been looking for a good booking system example, I > found the web2py.app.booking.w2p app, but the link is not working. > How could I get it?? Is there any good

[web2py] search date sqlform.grid

2015-12-30 Thread Laurent Lc
Hi, I have a table that has a date field. When you attempt to search by this date field in a SQLFORM.grid, the date picker no longer appears, just a test box !! How can i do ? thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Re: Upgrade to Web2py 2.10.4 breaks date field search in sqlform.grid

2015-12-30 Thread Laurent Lc
Did you find a solution ? Thanks Le vendredi 5 juin 2015 06:26:00 UTC+2, Mat Miles a écrit : > > I upgraded Web2py to version 2.10.4 on Pythonanywhere which has created a > problem with SQLFORM.grid. I have a table that has a date field. When you > attempt to search by this date field in a

[web2py] CUSTOM VALIDATOR

2015-12-14 Thread Laurent Lc
Hi i have created a custom validator in the the directory modules *customvalidators.py* class COUNT_TEXT(): def __call__(self, value): size = 25 error = None try: if len(value.split()) > size: error="too much words" except:

Re: [web2py] Re: CUSTOM a large form

2015-12-06 Thread Laurent Lc
g tabs... using a library helps > the process of making tabs pretty trivial... > > here's jquery ui's information > http://jqueryui.com/tabs/ > > bootstrap: > http://getbootstrap.com/components/#nav-tabs > > hope that helps > > On Friday, December 4, 2015 at 11:

[web2py] CREATE A VALIDATOR

2015-12-04 Thread Laurent Lc
Hello, i try to create my own validator : the goal is to count the number of words "app/module/customvalidators.py" class COUNT_TEXT(Validator): def __call__(self, value): size = 25 error = None try: if len(value.split()) > size: error="too

[web2py] Re: CREATE A VALIDATOR

2015-12-04 Thread Laurent Lc
ng (and is missing the split() > attribute), but the tb may show something different. > > /dps > > >> On Friday, December 4, 2015 at 4:30:28 PM UTC-5, Laurent Lc wrote: >>> >>> Hello, >>> >>> i try to create my own validator : the go

[web2py] Re: CREATE A VALIDATOR

2015-12-04 Thread Laurent Lc
the field : Field('Abstract', type = 'text' ), Le samedi 5 décembre 2015 05:02:13 UTC+1, Laurent Lc a écrit : > > Traceback (most recent call last): > File "C:\Users\chambon\Documents\web2py\gluon\restricted.py", line 227, in > restricted > exec ccode in envir

[web2py] CUSTOM a large form

2015-12-04 Thread Laurent Lc
Hi, I'd like to know the best way to present a big form with a lot of fields, using tabs for example and anchors ? thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

[web2py] Re: CREATE A VALIDATOR

2015-12-04 Thread Laurent Lc
I think that I can do differently creating a function register in default.py and use "onvalidation". What do you think about that ? But i would like to understand why it does not run thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

[web2py] Re: CREATE A VALIDATOR

2015-12-04 Thread Laurent Lc
sorry to have bothered for this little problem. I made so many changes as I do not see the essantiel Le samedi 5 décembre 2015 06:32:20 UTC+1, Anthony a écrit : > > On Friday, December 4, 2015 at 11:47:17 PM UTC-5, Laurent Lc wrote: >> >> the field : Field('Abstract', type =

Re: [web2py] Re: how to custom the view sqlform.grid

2015-11-25 Thread Laurent Lc
m > > On Wednesday, 25 November 2015 03:01:19 UTC+1, Laurent Lc wrote: >> >> >> How do i do if i want to see some fields (and not all) when i click on >> show >> thanks >> > -- > Resources: > - http://web2py.com > - http://web2py.com/book

Re: [web2py] Re: how to custom the view sqlform.grid

2015-11-25 Thread Laurent Lc
You are right but i do not want to display some fields in the view and not all Le 25 nov. 2015 10:58 AM, "Nico de Groot" a écrit : > You can also set the attribute 'readable' in the controller. > > Nico > > -- > Resources: > - http://web2py.com > - http://web2py.com/book

Re: [web2py] Re: how to custom the view sqlform.grid

2015-11-25 Thread Laurent Lc
le and writable attributes of a field anywhere. > > Anthony > > On Wednesday, November 25, 2015 at 3:08:01 AM UTC-5, Laurent Lc wrote: >> >> Thank you >> But i want to change in the view >> Le 25 nov. 2015 8:37 AM, "Alessio Varalta" < >> aless

[web2py] how to custom the view sqlform.grid

2015-11-24 Thread Laurent Lc
How do i do if i want to see some fields (and not all) when i click on show thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this

[web2py] custom view sqlform.grid

2015-11-24 Thread Laurent Lc
hi i return a grid how can i do if i want to see some fields (and not all) when i select show for a record thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report

[web2py] addMarker

2015-11-13 Thread Laurent Lc
I 'd like to see markers on a Map , i ve folowed a tuto but i do not understand why it does not run. I have only one point in fact. If i delete "new GMaps .." there is no map Could you helpe me thanks My View {{extend 'layout.html'}} https://maps.google.com/maps/api/js?sensor=true";>

[web2py] Re: Question regarding conf2py registration bug

2015-11-11 Thread Laurent Lc
idem Le lundi 11 novembre 2013 22:14:46 UTC+1, Jaeseong You a écrit : > > The conf2py seems to suffer from a crash when one is trying to register. > Is there any past resolution of this bug? Would it be possible for you to > help me clarify the problem? > -- Resources: - http://web2py.com -

[web2py] CONF2PY

2015-11-11 Thread Laurent Lc
Could you tell me why it is impossible to run this app. If i want to create an user it crash the app .. Th os where i ve installed this app is a debian Thank you The most recent version is 2010 ? -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

Re: [web2py] CONF2PY

2015-11-11 Thread Laurent Lc
gt; > On Wed, Nov 11, 2015 at 7:24 AM, Laurent Lc <lchambo...@gmail.com> wrote: > >> Could you tell me why it is impossible to run this app. >> If i want to create an user it crash the app .. >> Th os where i ve installed this app is a debian >> >> Thank you

[web2py] request.vars and request.args

2015-11-09 Thread Laurent Lc
Hello, I d like to know why .. menu.py URL('a', 'c', 'f', args=['x', 'y'], vars=dict(z='t')) c.py len(request.args) is always empty but len (request.vars.keys()) is not empty i don 't understand thank you 4 your explanation -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] sqlform.grid

2015-10-29 Thread Laurent Lc
Hi, i'd like a very simple example please (i begin) : could you tell me how to do for updating a field when i use sqlform.grid. Example: my db : db.define_table('message', Field('firstname',requires=IS_NOT_EMPTY()), Field('lastname',requires=IS_NOT_EMPTY()),

[web2py] web2py edit modify field sqlform.grid

2015-10-20 Thread Laurent Lc
Hi, i'd like a very simple example please (i begin) : could you tell me how to do for updating a field when i use sqlform.grid. Example: my db : db.define_table('message', Field('firstname',requires=IS_NOT_EMPTY()), Field('lastname',requires=IS_NOT_EMPTY()),

[web2py] Re: transform a row from a request to a line editable

2015-10-19 Thread Laurent Lc
Forget my question i think that a SQLFORM.GRID should be ok, i gonna test Le lundi 19 octobre 2015 20:49:56 UTC+2, Laurent Lc a écrit : > > Hi, > > Could you tell me how in can change this line in a a response editable > > form = db1(db1.user.id == request.args(0)).select() &g

[web2py] Re: transform a row from a request to a line editable

2015-10-19 Thread Laurent Lc
Solved Sorry sometimes you need to write stupid things for finding Le lundi 19 octobre 2015 21:42:42 UTC+2, Laurent Lc a écrit : > > Forget the menu sorry > > Le lundi 19 octobre 2015 21:11:31 UTC+2, Laurent Lc a écrit : >> >> In fact it does n

[web2py] Re: transform a row from a request to a line editable

2015-10-19 Thread Laurent Lc
Forget the menu sorry Le lundi 19 octobre 2015 21:11:31 UTC+2, Laurent Lc a écrit : > > In fact it does not work : > My function : > > @auth.requires_login() > def update(): > query = (db1.user.id == request.args(0)) > records = SQLFORM.grid(query=query,user_sign

[web2py] Re: transform a row from a request to a line editable

2015-10-19 Thread Laurent Lc
In fact it does not work : My function : @auth.requires_login() def update(): query = (db1.user.id == request.args(0)) records = SQLFORM.grid(query=query,user_signature=True) return dict(records=records) Le lundi 19 octobre 2015 21:00:13 UTC+2, Laurent Lc a écrit : > > For

[web2py] transform a row from a request to a line editable

2015-10-19 Thread Laurent Lc
Hi, Could you tell me how in can change this line in a a response editable form = db1(db1.user.id == request.args(0)).select() Thank you Nb: i 'd like to know why one field of my menu disapears when i browse my app -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -

Re: [web2py] Re: WEB2PY FOR MANAGING RESOURCES

2015-10-17 Thread Laurent Lc
October 16, 2015 at 2:12:06 AM UTC-7, Laurent Lc wrote: >> >> Hi, >> >> Does exist *an app already built ti manage* the shared usage of physical >> resources among a community of users. Resources may be *rooms*, >> vehicles, beamers as grr can do >> &g

[web2py] WEB2PY FOR MANAGING RESOURCES

2015-10-16 Thread Laurent Lc
Hi, Does exist *an app already built ti manage* the shared usage of physical resources among a community of users. Resources may be *rooms*, vehicles, beamers as grr can do Thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py

[web2py] Re: Mod_WSGI deployment problem

2015-10-14 Thread Laurent Lc
It works for me thank you :) Le mercredi 21 janvier 2009 11:35:13 UTC+1, voltron a écrit : > > Hi Massimo! > > thanks for your help. Sadly, that did not work either , another idea? > > Thanks > > On Jan 21, 11:31 am, mdipierro wrote: > > try edit wsgihandler.py and

[web2py] Re: upload and sqlform.grid

2015-10-07 Thread Laurent Lc
,db.personnel.groupe, db.personnel.picture],orderby=db.personnel.nom) return dict(grid=grid) Le lundi 5 octobre 2015 16:27:01 UTC+2, Laurent Lc a écrit : > > Hi, > > I'd like to show pics for each records when i return a grid. My function > is : > > def showonly(): >

[web2py] Re: Matplotlib

2015-10-05 Thread Laurent Lc
thank you Le vendredi 2 octobre 2015 10:59:39 UTC+2, pa...@cancamusa.net a écrit : > > You can also use this: > > http://mpld3.github.io/index.html > > If I understand correctly, once you provide some static libraries, you can > serve your plots as plain html, or even json, in your views. > --

[web2py] spip web2py

2015-10-05 Thread Laurent Lc
Hi, i have a web site built with spip. I'd like to create a form inside spip (ok i know how to do ;) , but the action would be http://localhost/app/contro/function. Now i need to capture the args from the form and embeded the results in spip. how to do that ? thanks Laurent -- Resources: -

[web2py] Re: links in sqlform.grid

2015-10-05 Thread Laurent Lc
Could tou give the good code because it does not run for me and i do not see what's going wrong cheers Le vendredi 20 septembre 2013 20:19:18 UTC+2, 黄祥 a écrit : > > hi, > > i have an table that contain an upload field for store image, i want to > show the image in sqlform grid. i tried to

[web2py] upload and sqlform.grid

2015-10-05 Thread Laurent Lc
Hi, I'd like to show pics for each records when i return a grid. My function is : def showonly(): query=(db1.test.present=='present') grid = SQLFORM.grid(query=query, user_signature=False, maxtextlength = 40,deletable=False, \ editable=False, create=False,

[web2py] Re: Matplotlib

2015-10-01 Thread Laurent Lc
I found something : In a controller (the import is done in a model) : def mychart(): return dict(a=IMG(_src=URL('draw'+'.png'))) def draw(): x = [datetime.date(2014, 1, 29), datetime.date(2014, 4, 15), datetime.date(2014, 3, 29)] y = [2, 4, 1] fig, ax = plt.subplots()

[web2py] Re: Matplotlib

2015-10-01 Thread Laurent Lc
Sorry i found just put the function draw in a model and add write in the controller: def mychart(): response.headers['Content-Type']='image/png' return draw() Le jeudi 1 octobre 2015 10:36:27 UTC+2, Laurent Lc a écrit : > > I found something : > > In a controller (the im

[web2py] Matplotlib

2015-09-30 Thread Laurent Lc
I 'd like to view in a view this part of code : import datetime import matplotlib.pyplot as plt x = [datetime.date(2014, 1, 29), datetime.date(2014, 4, 15), datetime.date(2014, 3, 29)] y = [2, 4, 1] fig, ax = plt.subplots() ax.plot_date(x, y, markerfacecolor='CornflowerBlue',

Re: [web2py] Dynamic Query SQLFOR.GRID

2015-09-29 Thread Laurent Lc
Thank you very much Le 29 sept. 2015 11:20 AM, "Massimiliano" <mbelle...@gmail.com> a écrit : > You can use belongs() > >db1.test.groupe.belongs(groupe) & ... > > > > On Mon, Sep 28, 2015 at 4:36 PM, Laurent Lc <lchambo...@gmail.com&g

[web2py] Dynamic Query SQLFOR.GRID

2015-09-28 Thread Laurent Lc
function in controller def showselectionfunding(): groupe = request.vars['groupe'] ask_date = request.vars['ask_date'] query=((db1.test.groupe == groupe)&(db1.test.datefincontrat > ask_date)) #query=((db1.test.groupe == groupe)&(db1.test.financement==

[web2py] Re: sqlform.factory

2015-09-25 Thread Laurent Lc
Sorry i found distinct=True Le vendredi 25 septembre 2015 16:25:42 UTC+2, Laurent Lc a écrit : > > Hi, > > i'd like to create a form from a database. > form = SQLFORM.factory( > Field('groupe',requires=IS_IN_DB(db1,db1.test.id > ,'%(groupe)s',multiple=Fal

[web2py] sqlform.factory

2015-09-25 Thread Laurent Lc
Hi, i'd like to create a form from a database. form = SQLFORM.factory( Field('groupe',requires=IS_IN_DB(db1,db1.test.id,'%(groupe)s',multiple=False)), Field('financement',requires=IS_IN_DB(db1,db1.test.id,'%(financement)s')),

[web2py] CMS

2015-09-23 Thread Laurent Lc
Hi, I'd like to know the best way to permit an user wiht no computer knowledge to create web pages, sections thank you Laurent -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -

Re: [web2py] How to get and use attributes from Active Directory

2015-09-16 Thread Laurent Lc
> > Richard > > On Mon, Sep 14, 2015 at 4:38 PM, Laurent Lc <lcham...@gmail.com > > wrote: > >> i am looking for a very simple example >> thanks >> >> -- >> Resources: >> - http://web2py.com >> - http://web2py.com/book (Documentation) >

[web2py] Re: sql query

2015-09-16 Thread Laurent Lc
() > or > dbRH(dbRH.test.login=="Laurent").select() > ? > > > > Dne středa 16. září 2015 12:34:09 UTC+2 Laurent Lc napsal(a): >> >> Hi >> could you explain me why it does not work : >> my file db.py (a part of file) >> >> loginses

[web2py] sql query

2015-09-16 Thread Laurent Lc
Hi could you explain me why it does not work : my file db.py (a part of file) loginsession = auth.user.username dbRH = DAL('mysql://xxx:xxx@localhost/RH', pool_size=0) dbRH.define_table('test', SQLField('login', type = 'string' , length = 20 ), SQLField('nom', type = 'string' , length =

[web2py] SQL select with a var

2015-09-16 Thread Laurent Lc
when the request is written like this : for row in dbRH(dbRH.test.login=="Laurent").select(): firstname = row.firstname It works . Now i want to replace "Laurent" by" myvar" and it doesn't work , how to do please help. It should be very simple but but .. it still doesn't work for me --

[web2py] Re: SQL select with a var

2015-09-16 Thread Laurent Lc
like this : myvar="toto" for row in dbRH(dbRH.test.login==myvar).select(): firstname = row.firstname the sql request doesn't work beacause myvar does not exist in sql but in python. so i don't know how to do Le mercredi 16 septembre 2015 16:20:11 UTC+2, Leonel Câmara a écrit : > > What do

[web2py] Re: SQL select with a var

2015-09-16 Thread Laurent Lc
yes copy/paste it works because in the view associated i can see the var "firstname" Le mercredi 16 septembre 2015 16:48:19 UTC+2, Anthony a écrit : > > On Wednesday, September 16, 2015 at 10:33:39 AM UTC-4, Laurent Lc wrote: >> >> like this : >> myvar="t

[web2py] Re: SQL select with a var

2015-09-16 Thread Laurent Lc
you were right, it was not exactly the same code. Now i put the code in db.py, and i use the request to set default values in a form. Is it a good way ? Le mercredi 16 septembre 2015 16:48:19 UTC+2, Anthony a écrit : > > On Wednesday, September 16, 2015 at 10:33:39 AM UTC-4, Laurent Lc

[web2py] Re: get username

2015-09-15 Thread Laurent Lc
do i have to use HTTP_AUTHORIZATION with WSGIPassAuthorization On ? Le mardi 15 septembre 2015 11:52:34 UTC+2, Laurent Lc a écrit : > > Hi, > > a part of my db.py is : > . > . > from gluon.tools import Auth, Service, PluginManager > > auth = Auth(db) >

[web2py] get username

2015-09-15 Thread Laurent Lc
Hi, a part of my db.py is : . . from gluon.tools import Auth, Service, PluginManager auth = Auth(db) service = Service() plugins = PluginManager() auth.define_tables(username=True) auth.settings.create_user_groups=False . . I would like to get the session's username and use it for reseaching

[web2py] CAS SERVER

2015-09-14 Thread Laurent Lc
Hi i use these lines of code and the goal is to retreive the login. Ive looked for Auth_user, cookies but nothing works, how can i do ? In fac the purpose is to replace PHP_AUTH_USER by ... i don't know. Could you help me ? thanks from gluon.tools import Auth, Service, PluginManager #auth

[web2py] Re: get user name and email on External cas login

2015-09-14 Thread Laurent Lc
Did you find a solution ? lchambo...@gmail.com Thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are

[web2py] How to get and use attributes from Active Directory

2015-09-14 Thread Laurent Lc
i am looking for a very simple example thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the

[web2py] Re: CAS SERVER

2015-09-14 Thread Laurent Lc
It works,i can login through my server cas, but i do not know how to get the login needed for aurhenticate -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues)

[web2py] $_SERVER['PHP_AUTH_USER']

2015-07-24 Thread Laurent Lc
Hi, i'd like to retrieve the login of people when they authentificate through a cas server. With PHP no problem with $_SERVER['PHP_AUTH_USER'] How do we do with web2py thank you -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source

[web2py] Server CAS

2015-07-21 Thread Laurent Lc
Hi, I have a central server https://cas.monuniversite.fr I would like to use it as i do with phpcas for example. Could you tell me how to do : eg: 1. modify the model db and add .. 2. crate a controller and add 3. modify apache .. I am a beginner so ... i ve read the doc but i do not

[web2py] convert csv file to sqlite

2015-06-23 Thread Laurent Lc
Hi Is it possible to convert a csv file to sqlite quiclly thanks -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you

[web2py] Re: why i cannot see database administration db.auth_group and so on

2015-06-21 Thread Laurent Lc
? On Thursday, 18 June 2015 06:25:04 UTC-5, Laurent Lc wrote: sorry i do not understand i follow the overview (the exemple blogs) and when i want to create the group manager i cannot see database administration db.auth_grou why ? thank you very much -- Resources: - http://web2py.com

[web2py] Re: why i cannot see database administration db.auth_group and so on

2015-06-21 Thread Laurent Lc
13:25:04 UTC+2, Laurent Lc a écrit : sorry i do not understand i follow the overview (the exemple blogs) and when i want to create the group manager i cannot see database administration db.auth_grou why ? thank you very much -- Resources: - http://web2py.com - http://web2py.com/book

[web2py] creation group manager

2015-06-18 Thread Laurent Lc
Sorry, I have followed the tuto and i cannot create the group manage (via appadmin). could you give me the way to do that I cannot see auth_users, auth_groups too Please give simple code for a viewer and a controler or a way to succeed. Thanks -- Resources: - http://web2py.com -

[web2py] why i cannot see database administration db.auth_group and so on

2015-06-18 Thread Laurent Lc
sorry i do not understand i follow the overview (the exemple blogs) and when i want to create the group manager i cannot see database administration db.auth_grou why ? thank you very much -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) -