date:20110211

Thanks for your comments.

WHen you need urllib, and web2py.python makes outbound connections you
should not need a proxy server or any proxy configuration as far as I
can tell (and I am not sure about your setup). This looks more of a
firewall issue.

On Feb 11, 5:19 am, whowhywhat mads...@gmail.com wrote:
 web2py is the first framework i actually enjoy using. :) .. been
 advocating it to everyone i meet these days. I sincerely thank the
 entire web2py community for everything.

 I have been developing a small web2py application for intranet use at
 the place where i work. During development i used windows (i carry
 web2py on a thumb drive). At work we use a proxy for net access and in
 windows i have no problems with web2py accessing the net using the
 proxy.
 I can use urllib to fetch webpages etc.

 To deploy the app i am using Ubuntu. I have deployed web2py using both
 apache as well as Cherokee using WSGI. The application runs fine.
 however the web2py environment is not able to fetch anything from the
 internet. urllib does not fetch any webpages. I have explicitly set
 the http_proxy environment variable (in /etc/environment, in the
 Cherokee startup script). I need to fetch data from the web, mostly
 for openID authentication. I am not sure what's wrong.

 how can i make web2py/python use the proxy server (http_proxy)?

[web2py] Re: IS_IN_DB no dropdown list

you can have

requires=IS_IN_DB(,_and=IS_NOT_IN_DB(...))

and/or

requires=IS_IN_DB(db(condition),)

Mind that the example in the cookbook 3 years old.
It works but now you do not all those validators. They are set by
default:

import datetime
now=datetime.date.today()

db=DAL('mysql://cookbook:cookb...@127.0.0.1/cookbook')

db.define_table('category',
Field('name',length=32,notnull=True,unique=True)
format='%(name)s')

db.define_table('recipe',
Field('title',length=32,nutnull=True),
Field('description',length=256,notnull=True),
Field('category',db.category),
Field('pub_date','date',default=now),
Field('instructions','text'))

# Notice no validators needed!

Mind that I changed Field('date') into Field('pub_date') because
'date' is not a valid SQL field name. The cookbook would only work on
sqlite because of this.

On Feb 11, 7:33 am, contatogilson...@gmail.com
contatogilson...@gmail.com wrote:
 We have a small problem in the use of IS_IN_DB. Only you can use this, and
 if
 want to use a IS_NOT_EMPTY for example, does not display the dropdown list.
 _
 *Gilson Filho*
 *Web Developerhttp://gilsondev.com*

[web2py] Re: web2py layouts

2011-02-11 Thread stargate

Thanks for the information I will try it out

On Feb 10, 6:16 pm, Massimo Di Pierro massimo.dipie...@gmail.com
wrote:
 Now I understand. These are plugins, not apps. You need an existing
 app and apply them from the design page of the existing app as plugins
 (form is at the bottom).
 They do not contain any login (models/controllers).

 On Feb 10, 12:56 pm, stargate kyoukh...@gmail.com wrote:

  Its most of them I have downloaded and tired.  If you have step by
  step instructions i could be doing something wrong.  Thanks

  On Feb 10, 12:10 pm, Massimo Di Pierro massimo.dipie...@gmail.com
  wrote:

   Are you usinghttp://web2py.com/layouts?Doyouhave a problem with
   this one only?

   On Feb 10, 9:54 am, stargate kyoukh...@gmail.com wrote:

I tried installing the Simpletex layout but i try to view it and it
says invalid controller (default/index).  So i am not sure what are
the steps to installing these sample layouts.

[web2py] Integrating SOAP services

Hi,

I got a query to integrate BullHorn (Staffing solution) (http://bullhorn.com) 
and VerticalResponse (Email-Marketing)  (http://www.verticalresponse.com/) 
together into their existing application.
On investigating I found out that, both uses soap services. 
How do you recommend me to consume SOAP services in web2py.
I'm new to SOAP.

Thanks,
Arun

[web2py] Re: web2py layouts

2011-02-11 Thread stargate

It worked i created then applied the theme as a plugin.  In the
documentation where is a tutorial in creating your own theme. Thanks
for all the help

On Feb 10, 6:16 pm, Massimo Di Pierro massimo.dipie...@gmail.com
wrote:
 Now I understand. These are plugins, not apps. You need an existing
 app and apply them from the design page of the existing app as plugins
 (form is at the bottom).
 They do not contain any login (models/controllers).

 On Feb 10, 12:56 pm, stargate kyoukh...@gmail.com wrote:

  Its most of them I have downloaded and tired.  If you have step by
  step instructions i could be doing something wrong.  Thanks

  On Feb 10, 12:10 pm, Massimo Di Pierro massimo.dipie...@gmail.com
  wrote:

   Are you usinghttp://web2py.com/layouts?Doyouhave a problem with
   this one only?

   On Feb 10, 9:54 am, stargate kyoukh...@gmail.com wrote:

I tried installing the Simpletex layout but i try to view it and it
says invalid controller (default/index).  So i am not sure what are
the steps to installing these sample layouts.

Re: [web2py] Re: IS_IN_DB no dropdown list

2011-02-11 Thread Bruno Rocha

2011/2/11 Massimo Di Pierro massimo.dipie...@gmail.com

 you can have

 requires=IS_IN_DB(,_and=IS_NOT_IN_DB(...))


The above is a new syntax for me, is it on the book or somewhere?

Re: [web2py] Re: IS_IN_DB no dropdown list

On Friday, February 11, 2011 9:50:32 AM UTC-5, rochacbruno wrote: 

 2011/2/11 Massimo Di Pierro massimo@gmail.com

 you can have

 requires=IS_IN_DB(,_and=IS_NOT_IN_DB(...))


 The above is a new syntax for me, is it on the book or somewhere?

 
Yes, in the IS_IN_DB section here: 
http://web2py.com/book/default/chapter/07#Database-Validators

[web2py] Re: Integrating SOAP services



I tried following in ipython at the second statement ipython just hanged. So 
I'm a bit tensed..
Am I doing something wrong.

from gluon.contrib.pysimplesoap.client import SoapClient, SoapFault   
client = 
SoapClient(wsdl=https://api.bullhornstaffing.com/webservices-1.1/?wsdl;)

Re: [web2py] Re: IS_IN_DB no dropdown list

2011-02-11 Thread Bruno Rocha

2011/2/11 Anthony abasta...@gmail.com

 On Friday, February 11, 2011 9:50:32 AM UTC-5, rochacbruno wrote:

 2011/2/11 Massimo Di Pierro massimo@gmail.com

  you can have

 requires=IS_IN_DB(,_and=IS_NOT_IN_DB(...))


 The above is a new syntax for me, is it on the book or somewhere?


 Yes, in the IS_IN_DB section here:
 http://web2py.com/book/default/chapter/07#Database-Validators



I needed something like that some time ago, but I did not see the '_and'  in
book, then I ran in to a different solution (created my own validator)

Thank you

[web2py] function in query

2011-02-11 Thread Manuele Pesenti


Hi,

how can I select records of a table that got 2 date fields (one datetime 
and a simple date) wich difference is a fixed value?


I thought this solution:

import datetime
today=datetime.datetime.today()
yesterday = today.date() - datetime.timedelta(days=1)

db.define_table('mytab',
...
Field('date1','datetime',default=today),
Field('date2','date',default=yesterday)
)

db(db.mytab.date1-db.mytab.date1 == datetime.timedelta(days=2).select()
but thats wat I got:

Traceback (most recent call last):
  File console, line 1, in module
  File Path/web2py/gluon/dal.py, line 4507, in select
return self.db._adapter.select(self.query,fields,attributes)
  File Path/web2py/gluon/dal.py, line 996, in select
sql = self._select(query,fields,attributes)
  File Path/web2py/gluon/dal.py, line 929, in _select
sql_w = ' WHERE ' + self.expand(query)
  File Path/web2py/gluon/dal.py, line 799, in expand
return expression.op(expression.first, expression.second)
  File Path/web2py/gluon/dal.py, line 721, in AND
return '(%s AND %s)' % (self.expand(first),self.expand(second))
  File Path/web2py/gluon/dal.py, line 799, in expand
return expression.op(expression.first, expression.second)
  File Path/web2py/gluon/dal.py, line 751, in EQ
return '(%s = %s)' % 
(self.expand(first),self.expand(second,first.type))

  File Path/web2py/gluon/dal.py, line 805, in expand
return self.represent(expression,field_type)
  File Path/web2py/gluon/dal.py, line 1106, in represent
return repr(float(obj))
TypeError: float() argument must be a string or a number

Thank you very much for any help.

Manuele

[web2py] Re: Authorization for Webhooks

2011-02-11 Thread AsmanCom

BTW why does the callbacks with the cookie header not work with web2py
just like that? Is this some kind of Security Feature of web2py?

Thanks in advance.

Dieter Asman


On 11 Feb., 13:02, AsmanCom d.as...@web.de wrote:
 I´ve got an Application wich makes (url)callbacks to my web2py app and
 All these webhooks have a Cookie: header with a value identical to
 the browser that caused the request to be initiated.
 For for example it calls the web2py Controller with this Cookie:
 header:

 Cookie: session_id_myapp=127.0.0.1-2b77d424-4e72-4d3f-a0de-
 badbcdbe6a30

 In the called web2py controller I want to make the Authorization for
 this call, tried to like that:

 def connect():

     return response.json([auth.is_logged_in(), {name: Test}])

 When called with the Browser, it returns:
 [true, {name: test}]

 When called by the (url)callback, it returns:
 [false, {name: test}]

 In this Controller I can simply grab the session_id:

 def get_session_test():

     if request.cookies.has_key(response.session_id_name):
         value = request.cookies[response.session_id_name].value
         return dict(session_id=value)
     else:
         return False

 How can I authorize these (url)callbacks by session_id?

 I´ve to query two values by the given session_id,
 1. is_logged_in (boolean)
 2. username or user email (string)

 But, how to obtain them?

 Or is there a better way to make the authorization for the
 (url)callbacks?

 Thank you in advance.

 Dieter Asman

[web2py] Re: JSON in templates

2011-02-11 Thread smoggy

A json template system :
https://github.com/ruidlopes/minimal.js

Definite win 4 web2py.

[web2py] recommended ERP system?

2011-02-11 Thread Carlos

Hi,

A potential client requires a complete ERP system (with POS, Inventory, CRM, 
etc., preferably multi-lingual with Spanish as a must, and to be installed 
in Mexico), which I would love to implement with web2py, but unfortunately 
his need is immediate (and requires something already proven), and it has to 
be not that expensive.

Do you recommend an specific ERP system that I could later interface with 
web2py somehow?.

I've been reading about ERP5, OpenERP, Tryton, OpenBravo, MyERP, etc., but I 
am not that familiar with any of them (with any ERP system for that matter) 
... are all of them the same as SalesForce, Zoho and such?.

And I don't really know if a fully-web system, or fully-local, or a 
combination of both, is preferred.

I'd really appreciate any advice you can provide, and also any docs you can 
refer me to in order to learn much more about ERP systems (with pros, cons, 
steps, etc.).

Many thanks,

   Carlos

[web2py] New web2py logo? [just for fun]

My 4-year-old daughter has been practicing her writing recently. Yesterday, 
she handed this to me (she must have found the book on my desk and copied 
the title). Apparently web2py makes her think of hearts and flowers, as it 
does for most people. :)
 
Anthony
attachment: new_web2py_logo.png

[web2py] problem nesting menu generated from database

2011-02-11 Thread w2padawan

Hi,

I'm loosing a lot of time trying to generate a categories menu from
database, but my lack of experience in python seems to be yet too
much.

The respective error ticket says:

AttributeError: 'tuple' object has no attribute 'append'

How can I list.append((newitem,False,link)) inside a
list=[(name,False,link,[newitem,False,link])] to make the respective
submenu from the query, if you know what I mean?


CONTROLLER:
==
supercategorias =
db(db.t_categoria.supercategoria==None).select(db.t_categoria.id,db.t_categoria.nombre)
for supercat in supercategorias:
catree[-1].append((supercat.nombre,False,'link'))
cats = 
db(db.t_categoria.supercategoria==supercat.id).select(db.t_categoria.nombre,db.t_categoria.id)
for cat in cats:
catree.append([cat.nombre,False,'link'])




MODEL:
=
db.define_table(t_categoria,
Field('nombre','string'),
Field('supercategoria','string')
)

db.t_categoria.supercategoria.requires=IS_EMPTY_OR(IS_IN_DB(db,'t_categoria.id','%(nombre)s',zero=T('[Seleccione
sólo si corresponde]')))
-

VIEW:

{{=MENU(catree)}}
---

kind regards, and thank you for your time

Re: [web2py] New web2py logo? [just for fun]

2011-02-11 Thread Marin Pranjic

sweet :)

On Fri, Feb 11, 2011 at 6:36 PM, Anthony abasta...@gmail.com wrote:

 My 4-year-old daughter has been practicing her writing recently. Yesterday,
 she handed this to me (she must have found the book on my desk and copied
 the title). Apparently web2py makes her think of hearts and flowers, as it
 does for most people. :)

 Anthony

[web2py] Re: Authorization for Webhooks

Can you just read the cookie and match it to a session? Do these callbacks 
occur quickly enough that the session has not expired? I don't know exactly 
how sessions work but I could imagine there's be problems using sessions 
with callbacks since the callback is not technically logged in (it has 
stolen a cookie).

Re: [web2py] Re: web2py not using global http_proxy

2011-02-11 Thread Luis Díaz

Greetings,
web2py I mention that I use in my work.
and we have a proxy that we restrict the output
by user name and password

I have solved the problem properly configuring the proxy on the computer
where I have installed debian web2py

nano /etc/profile

adding the following lines:

export http_proxy = http://proxy.uc.edu.ve:5010/
export https_proxy = http://proxy.uc.edu.ve:5010/
export ftp_proxy = http://proxy.uc.edu.ve:5010/

2011/2/11 Massimo Di Pierro massimo.dipie...@gmail.com

Thanks for your comments.

WHen you need urllib, and web2py.python makes outbound connections you
should not need a proxy server or any proxy configuration as far as I
can tell (and I am not sure about your setup). This looks more of a
firewall issue.

On Feb 11, 5:19 am, whowhywhat mads...@gmail.com wrote:
web2py is the first framework i actually enjoy using. :) .. been
advocating it to everyone i meet these days. I sincerely thank the
entire web2py community for everything.

I have been developing a small web2py application for intranet use at
the place where i work. During development i used windows (i carry
web2py on a thumb drive). At work we use a proxy for net access and in
windows i have no problems with web2py accessing the net using the
proxy.
I can use urllib to fetch webpages etc.

To deploy the app i am using Ubuntu. I have deployed web2py using both
apache as well as Cherokee using WSGI. The application runs fine.
however the web2py environment is not able to fetch anything from the
internet. urllib does not fetch any webpages. I have explicitly set
the http_proxy environment variable (in /etc/environment, in the
Cherokee startup script). I need to fetch data from the web, mostly
for openID authentication. I am not sure what's wrong.

how can i make web2py/python use the proxy server (http_proxy)?

--
Díaz Luis
TSU Analisis de Sistemas
Universidad de Carabobo

Facultad de
Odontologíahttp://www.odontologia.uc.edu.ve/index.php?option=com_contentview=articleid=102Itemid=85

Re: [web2py] function in query

2011-02-11 Thread w2padawan

2011/2/11 Manuele Pesenti manuele.pese...@gmail.com:
 (...)
 TypeError: float() argument must be a string or a number

 Thank you very much for any help.

Manuele


where/why is the/a float argument?

[web2py] Re: problem nesting menu generated from database

replace (...) with [...] in

list=[(name,False,link,[newitem,False,link])] to make the respective
...
catree[-1].append((supercat.nombre,False,'link'))


list=[[name,False,link,[newitem,False,link]]] to make the respective
...
catree[-1].append([supercat.nombre,False,'link'])

On Feb 11, 11:39 am, w2padawan web2py.n...@gmail.com wrote:
 Hi,

 I'm loosing a lot of time trying to generate a categories menu from
 database, but my lack of experience in python seems to be yet too
 much.

 The respective error ticket says:

     AttributeError: 'tuple' object has no attribute 'append'

 How can I list.append((newitem,False,link)) inside a
 list=[(name,False,link,[newitem,False,link])] to make the respective
 submenu from the query, if you know what I mean?

 CONTROLLER:
 ==
 supercategorias =
 db(db.t_categoria.supercategoria==None).select(db.t_categoria.id,db.t_categ 
 oria.nombre)
 for supercat in supercategorias:
         catree[-1].append((supercat.nombre,False,'link'))
         cats = 
 db(db.t_categoria.supercategoria==supercat.id).select(db.t_categoria.nombre 
 ,db.t_categoria.id)
         for cat in cats:
             catree.append([cat.nombre,False,'link'])
 

 MODEL:
 =
 db.define_table(t_categoria,
     Field('nombre','string'),
     Field('supercategoria','string')
 )

 db.t_categoria.supercategoria.requires=IS_EMPTY_OR(IS_IN_DB(db,'t_categoria 
 .id','%(nombre)s',zero=T('[Seleccione
 sólo si corresponde]')))
 -

 VIEW:
 
 {{=MENU(catree)}}
 ---

 kind regards, and thank you for your time

[web2py] Re: New web2py logo? [just for fun]

Printing and hanging on wall!

On Feb 11, 11:36 am, Anthony abasta...@gmail.com wrote:
 My 4-year-old daughter has been practicing her writing recently. Yesterday,
 she handed this to me (she must have found the book on my desk and copied
 the title). Apparently web2py makes her think of hearts and flowers, as it
 does for most people. :)

 Anthony

  new_web2py_logo.png
 20KViewDownload

Re: [web2py] Re: web2py not using global http_proxy

2011-02-11 Thread Luis Díaz

I forgot.
if you need to specify username and password
then the structure would be something.

export http_proxy = http://username:password@proxy:port/
export https_proxy = http://username:password@proxy:port /
export ftp_proxy = http://username:password@proxy:port /

2011/2/11 Luis Díaz diazluis2...@gmail.com

Greetings,
web2py I mention that I use in my work.
and we have a proxy that we restrict the output
by user name and password

I have solved the problem properly configuring the proxy on the computer
where I have installed debian web2py

nano /etc/profile

adding the following lines:

export http_proxy = http://proxy.uc.edu.ve:5010/
export https_proxy = http://proxy.uc.edu.ve:5010/
export ftp_proxy = http://proxy.uc.edu.ve:5010/

2011/2/11 Massimo Di Pierro massimo.dipie...@gmail.com

Thanks for your comments.

how can i make web2py/python use the proxy server (http_proxy)?

--
Díaz Luis
TSU Analisis de Sistemas
Universidad de Carabobo

Facultad de
Odontologíahttp://www.odontologia.uc.edu.ve/index.php?option=com_contentview=articleid=102Itemid=85

--
Díaz Luis
TSU Analisis de Sistemas
Universidad de Carabobo

Facultad de
Odontologíahttp://www.odontologia.uc.edu.ve/index.php?option=com_contentview=articleid=102Itemid=85

[web2py] Re: function in query

db(db.mytab.date1-db.mytab.date1 ==
datetime.timedelta(days=2).select()

must be

db(db.mytab.date1 == db.mytab.date1 +
datetime.timedelta(days=2).select()

a query has the form field =  expression. You cannot have the
expression on the left-hand side.

I cannot exclude something else is also wrong. Please check and let us
know.

On Feb 11, 9:25 am, Manuele Pesenti manuele.pese...@gmail.com wrote:
 Hi,

 how can I select records of a table that got 2 date fields (one datetime
 and a simple date) wich difference is a fixed value?

 I thought this solution:

 import datetime
 today=datetime.datetime.today()
 yesterday = today.date() - datetime.timedelta(days=1)

 db.define_table('mytab',
      ...
      Field('date1','datetime',default=today),
 Field('date2','date',default=yesterday)
 )

 db(db.mytab.date1-db.mytab.date1 == datetime.timedelta(days=2).select()
 but thats wat I got:

 Traceback (most recent call last):
    File console, line 1, in module
    File Path/web2py/gluon/dal.py, line 4507, in select
      return self.db._adapter.select(self.query,fields,attributes)
    File Path/web2py/gluon/dal.py, line 996, in select
      sql = self._select(query,fields,attributes)
    File Path/web2py/gluon/dal.py, line 929, in _select
      sql_w = ' WHERE ' + self.expand(query)
    File Path/web2py/gluon/dal.py, line 799, in expand
      return expression.op(expression.first, expression.second)
    File Path/web2py/gluon/dal.py, line 721, in AND
      return '(%s AND %s)' % (self.expand(first),self.expand(second))
    File Path/web2py/gluon/dal.py, line 799, in expand
      return expression.op(expression.first, expression.second)
    File Path/web2py/gluon/dal.py, line 751, in EQ
      return '(%s = %s)' %
 (self.expand(first),self.expand(second,first.type))
    File Path/web2py/gluon/dal.py, line 805, in expand
      return self.represent(expression,field_type)
    File Path/web2py/gluon/dal.py, line 1106, in represent
      return repr(float(obj))
 TypeError: float() argument must be a string or a number

 Thank you very much for any help.

      Manuele

Re: [web2py] Re: Web2py and Sencha (Extjs)

2011-02-11 Thread mikech

Extjs and Sencha just seem more complete UI element wise.   Their table 
tools seem very powerful.  It is pricey, but for business applications this 
shouldn't be a problem.

Re: [web2py] Re: Integrating SOAP services

2011-02-11 Thread Mariano Reingart

This bullhornstaffing webservice is a very complex one, it import many
schemas so the library has to fetch many URL, and this can take quite
a while.

You can see what is happening using trace=True (and enabling wsdl
caching to prevent fetching them each time):

client = 
SoapClient(wsdl=https://api.bullhornstaffing.com/webservices-1.1/?wsdl,trace=True,
cache='.')

You get better performance not using the WSDL at all, in most cases
you need webservice location and action, and you can perform remote
calls directly (even in raw mode), that's the flexibility this library
provides, see the examples:

http://code.google.com/p/pysimplesoap/wiki/SoapClient

If you find any problem please fill an issue at the project site:
http://code.google.com/p/pysimplesoap/

Let me know if you need further assistance (if you can, send me what
function do you want to consume, with theirs parameters)

Best regards,

Mariano Reingart
http://www.sistemasagiles.com.ar
http://reingart.blogspot.com



On Fri, Feb 11, 2011 at 12:06 PM, Arun K.Rajeevan the1.a...@gmail.com wrote:
 I tried following in ipython at the second statement ipython just hanged. So
 I'm a bit tensed..
 Am I doing something wrong.

 from gluon.contrib.pysimplesoap.client import SoapClient, SoapFault
 client =
 SoapClient(wsdl=https://api.bullhornstaffing.com/webservices-1.1/?wsdl;)

Re: [web2py] URL anchor breaks routes

2011-02-11 Thread Jonathan Lundell

On Feb 10, 2011, at 5:16 PM, Plumo wrote:
 so let's say I have mapped /init/default/about to /about
 
 Then: URL(r=request, c='default', f='about', anchor='company')
 will produce: /init/default/about#company 
 instead of: /about#company

OK, I have some more information on this.

With the regex URL rewriter (which is the only one in the stable release), the 
anchor (and query string if there is one) is part of the URL being matched in 
routes_out. So you need to include it in your regex in order for it to work the 
way you want.

So for example instead of this:

routes_out = [
   ('/init/default/index', '/'), 
]

you need this:

routes_out = [
   (r'/init/default/index(?Panchor(#.*)?)', r'/\ganchor'), 
]

or more generally:

routes_out = [
   (r'/init/default/index(?Pquery(\?.*)?)(?Panchor(#.*)?)', 
r'/\gquery\ganchor'), 
]

or combined, if you never need to distinguish the query and anchor:

routes_out = [
   (r'/init/default/index(?Pqa([?#].*)?)', r'/\gqa'), 
]


FWIW, this doesn't arise with the new-style router in the trunk. The downside 
there is that you can't rewrite the query string or anchor.

Re: [web2py] Re: problem nesting menu generated from database

2011-02-11 Thread w2padawan

I changed it as you say but now gives me:

ValueError: need more than 1 value to unpack


CONTROLLER
==
def catree():
# query
supercategorias =
db(db.t_categoria.supercategoria==None).select(db.t_categoria.id,db.t_categoria.nombre)

# creating the menu
catree = [['testmenu',False,None,['testsubmenu',False,None]]]

# identifying and building submenus
for supercat in supercategorias:
catree.append([supercat.nombre,False,'link'])
cats = 
db(db.t_categoria.supercategoria==supercat.id).select(db.t_categoria.nombre,db.t_categoria.id)
for cat in cats:
catree.append([cat.nombre,False,'link'])

return dict(catree=catree)

what I'm still missing?

[web2py] Re: Web2py and Sencha (Extjs)

2011-02-11 Thread Luther Goh Lu Feng



On Feb 12, 1:53 am, mikech mp.ch...@gmail.com wrote:
 Extjs and Sencha just seem more complete UI element wise.   Their table
 tools seem very powerful.  It is pricey, but for business applications this
 shouldn't be a problem.

Another mobile framework is http://joapp.com/

[web2py] Re: New web2py logo? [just for fun]

2011-02-11 Thread cjrh

On Feb 11, 7:36 pm, Anthony abasta...@gmail.com wrote:
 My 4-year-old daughter has been practicing her writing recently.

lol!

[web2py] Re: pyamf 0.6 doesn't work with web2py

2011-02-11 Thread elffikk

What is the status, I would like to test it

On Jan 31, 4:19 pm, Massimo Di Pierro massimo.dipie...@gmail.com
wrote:
 g...

 I can port it to the new one. Can you help with testing?

 On Jan 31, 3:04 am, elffikk elff...@gmail.com wrote:







  hi Massimo,

  I think this is due to a list of backward 
  incompatibilitieshttp://www.pyamf.org/whatsnew/0.6.html

[web2py] Re: recommended ERP system?

2011-02-11 Thread b00m_chef

Based on your criteria listed in your original post, the answer is
easy - http://www.xtuple.com/

You can interface with the database that xTuple uses (postgresql) from
any language. So you can extend xTuple using any set of tools you
want.

Don't bite off more than you can chew though...ERPs are VERY
complex...and 80% of the complexity is nothing to do with programming,
but with business process analysis and accounting process analysis.

A main thing you may want is to make sure you choose a provider of the
software that has LOTS of experience in your EXACT line of
business...xTuple is experienced in manufacturing...just
FYI...specialization of provider will save you TONS of
headaches...don't shy away from bigger companies either though, as
they have benefits too...but stay away from MS Dynamics...it will
cause you endless sleepless nights and costs...

Good luck!



On Feb 11, 9:34 am, Carlos carlosgali...@gmail.com wrote:
 Hi,

 A potential client requires a complete ERP system (with POS, Inventory, CRM,
 etc., preferably multi-lingual with Spanish as a must, and to be installed
 in Mexico), which I would love to implement with web2py, but unfortunately
 his need is immediate (and requires something already proven), and it has to
 be not that expensive.

 Do you recommend an specific ERP system that I could later interface with
 web2py somehow?.

 I've been reading about ERP5, OpenERP, Tryton, OpenBravo, MyERP, etc., but I
 am not that familiar with any of them (with any ERP system for that matter)
 ... are all of them the same as SalesForce, Zoho and such?.

 And I don't really know if a fully-web system, or fully-local, or a
 combination of both, is preferred.

 I'd really appreciate any advice you can provide, and also any docs you can
 refer me to in order to learn much more about ERP systems (with pros, cons,
 steps, etc.).

 Many thanks,

    Carlos

Re: [web2py] Re: Integrating SOAP services

Hi, your solution worked.
Before I was clueless about what's happening and terminated the process in 
between.
It takes minutes upon minutes to finish.

I've a doubt, it's not that pressing, but curious.
I've no access to server side implementation, all I know is location of this 
wsdl file (I've access to api documentation in java)

To get all available services,
1) If I use SOAPpy
from SOAPpy import WSDL
_server = WSDL.Proxy(WSDFILE)
_server.methods.keys()

2) If I use pysimplesoup
from pysimplesoap.client import SoapClient, SoapFault  
client = SoapClient(WSDFILE, cache='.')
client.services['VRAPI']['ports']['VRAPIPort']['operations'].keys()

is there any better way to do this.
Not important, but...

Re: [web2py] Re: Integrating SOAP services

Oh, I forgot to Thank you,

Thank you very much for the tip. It saved my day. :)

[web2py] new support platform for web2py - make money

2011-02-11 Thread Francisco Costa

Hello!
During the past months I'm using a lot web2py.
I've been asking a few questions here in this group and I've received
help from people all around the world. Sometimes I really felt like I
should give back something to those kind souls..

So that's why in the past 2 days I've created http://askvalue.com/
(using web2py).
This is alpha version, and I would like your feedback.

AskValue aims to be a social platform of questions and answers where
you can make money by doing a valuable question/comment or by
providing quality answers.

How do you win money? You must have a Flattr.com account (optional)
and create a thing with your site profile: http://askvalue.com/user/username

If the user gives you credit I believe that you will be flattred (make
money)
If you register you can follow your friends, and receive their updates
(dashboard under construction).. or you can only follow questions of
your interest.
You can also vote on your favorite answers!

I'm also planning to implement during the next week email-
notifications.

I think that this kind of service can encourages users to help more!
I also believe that Google Groups is very limited and old-fashionable
for support, and with this you can have a much richer experience.

Please help me by providing me your honest feedback.
and please don't mock on my design skills.. I need more time for it :)

[web2py] Re: new support platform for web2py - make money

Cool site. Have you looked at http://beta.qa-stack.com/ -- it's also a 
web2py-based QA app (open source code)?

On Friday, February 11, 2011 2:45:52 PM UTC-5, Francisco Costa wrote:

 Hello! 
 During the past months I'm using a lot web2py. 
 I've been asking a few questions here in this group and I've received 
 help from people all around the world. Sometimes I really felt like I 
 should give back something to those kind souls.. 

 So that's why in the past 2 days I've created http://askvalue.com/ 
 (using web2py). 
 This is alpha version, and I would like your feedback. 

 AskValue aims to be a social platform of questions and answers where 
 you can make money by doing a valuable question/comment or by 
 providing quality answers. 

 How do you win money? You must have a Flattr.com account (optional) 
 and create a thing with your site profile: 
 http://askvalue.com/user/username 

 If the user gives you credit I believe that you will be flattred (make 
 money) 
 If you register you can follow your friends, and receive their updates 
 (dashboard under construction).. or you can only follow questions of 
 your interest. 
 You can also vote on your favorite answers! 

 I'm also planning to implement during the next week email- 
 notifications. 

 I think that this kind of service can encourages users to help more! 
 I also believe that Google Groups is very limited and old-fashionable 
 for support, and with this you can have a much richer experience. 

 Please help me by providing me your honest feedback. 
 and please don't mock on my design skills.. I need more time for it :)

[web2py] Re: new support platform for web2py - make money

Where can qa-stack be downloaded?

[web2py] What user is logged in (or, restricting access based on user)

2011-02-11 Thread Ed Greenberg

I am adding authentication and limitations to an app. Consider two
tables:


db_define_table('detail',
, Field('detail_item', type='string',label=T('Item'))
, FIeld('owner_id', db.auth_user, readable=False, writable=False)
)

I have a controller that includes a method to list all records in the
detail tale, and now I need to limit it to records owned by the logged
in user.

I've reviewed all of chapter 8, and also the source code for the Auth
class. I still don't see how to implement this.  If I could know who
is logged in, I could handle it in my select.

There's probably a web2py best practice for this, as well.

Can somebody please explain.

Thanks,
Ed Greenberg

[web2py] Re: Say hello to pyStack.com

I'm interested in having a look at the code. Thanks.

[web2py] plugin_wiki

2011-02-11 Thread stargate

I am trying to apply the plugin_wiki to a test application i created
in the wizard but when i go to preview the site it doesn't look like
the limey green look why is that.

[web2py] Re: problem nesting menu generated from database

please post the complete traceback.

On Feb 11, 12:08 pm, w2padawan web2py.n...@gmail.com wrote:
 I changed it as you say but now gives me:

     ValueError: need more than 1 value to unpack

 
 CONTROLLER
 ==
 def catree():
     # query
     supercategorias =
 db(db.t_categoria.supercategoria==None).select(db.t_categoria.id,db.t_categ 
 oria.nombre)

     # creating the menu
     catree = [['testmenu',False,None,['testsubmenu',False,None]]]

     # identifying and building submenus
     for supercat in supercategorias:
         catree.append([supercat.nombre,False,'link'])
         cats = 
 db(db.t_categoria.supercategoria==supercat.id).select(db.t_categoria.nombre 
 ,db.t_categoria.id)
         for cat in cats:
             catree.append([cat.nombre,False,'link'])

     return dict(catree=catree)

 what I'm still missing?

Re: [web2py] plugin_wiki

2011-02-11 Thread Albert Abril

I'm not sure what you would mean whit 'the limey green', but if you want to
access the plugin_wiki once installed, you should go to
http://URL/YourApp/plugin_wiki .

On Fri, Feb 11, 2011 at 10:27 PM, stargate kyoukh...@gmail.com wrote:

 I am trying to apply the plugin_wiki to a test application i created
 in the wizard but when i go to preview the site it doesn't look like
 the limey green look why is that.

[web2py] Re: auth.signature

2011-02-11 Thread villas

Yes, it does seem strange to have 'modified_on','updated_by'. They
should be the same.
In the plugin_wiki it is modified_on, modified_by -- at least that's
consistent.


On Feb 11, 12:29 am, Vinicius Assef vinicius...@gmail.com wrote:
 If you have 'created_on' and 'created_by', what about 'updated_on' and
 'updated_by'?
 Vinicius Assef.

 On Tue, Feb 8, 2011 at 6:39 PM, villas villa...@gmail.com wrote:
  For those intrigued and cannot update to trunk right now, it creates
  some extra fields...

  ['id', 'whatever', 'created_on', 'created_by', 'modified_on',
  'updated_by']

  Nice shortcut, but I never guessed from the name 'auth.signature' what
  it would do.
  Maybe a different name would be clearer?  e.g. 'auth.rectimestamp'

Re: [web2py] Re: new support platform for web2py - make money

2011-02-11 Thread Marin Pranjic

Cannot. Still in beta.

On 11 Feb 2011 21:53, pbreit pbreitenb...@gmail.com wrote:

Where can qa-stack be downloaded?

[web2py] Re: What user is logged in (or, restricting access based on user)

2011-02-11 Thread villas

Something quick for you to try...
1. Make sure your owner_id field has a user_id saved in there. Take a
look through the admin.

2. You may wish to add this to the field definition so it will save
your logged in user: default=auth.user_id

 Field('owner_id', db.auth_user,default=auth.user_id, readable=False,
writable=False)


3. Make a function like this in your default.py controller file:

@auth.requires_login()
def test():
rows = db(db.detail.owner_id==auth.user_id).select()
return dict(rows=rows, message='Hello to %s (Id: %s)'%
(auth.user.first_name,auth.user_id))

The decorator @auth.requires_login() forces you to log in.
The message=... part is just a bit of fun, it shows who is currently
logged in.

4. Try it in your browser:  e.g. http://yourserver/yourapp/default/test

Good luck  :)

On Feb 11, 8:54 pm, Ed Greenberg greenberg...@gmail.com wrote:
 I am adding authentication and limitations to an app. Consider two
 tables:

 db_define_table('detail',
     , Field('detail_item', type='string',label=T('Item'))
     , FIeld('owner_id', db.auth_user, readable=False, writable=False)
 )

 I have a controller that includes a method to list all records in the
 detail tale, and now I need to limit it to records owned by the logged
 in user.

 I've reviewed all of chapter 8, and also the source code for the Auth
 class. I still don't see how to implement this.  If I could know who
 is logged in, I could handle it in my select.

 There's probably a web2py best practice for this, as well.

 Can somebody please explain.

 Thanks,
 Ed Greenberg

[web2py] Re: What user is logged in (or, restricting access based on user)

I'm having trouble as well figuring out the best way to do this. It is core 
to ever app I contemplate building but doesn't seem to be spelled out in the 
docs. Pretty much every web site I know of personalizes web pages based on 
who is logged in.

I noticed that for each user, a db.auth_group is created. Would we use that 
for this type of permissioning?

[web2py] Re: What user is logged in (or, restricting access based on user)

2011-02-11 Thread villas

The individual auth_group can be used for giving permissions to that
individual user.

The main idea is to save yourself some work.  Instead of giving every
individual person their own permissions,  divide your users into
groups.  Once you have all your users in groups,  it becomes more
manageable to allocate permissions to them.

For example,  if you have 50 users,  you may find that they divide
into 4 groups.

Clients:  They just get permission to see their own profiles read-
only.
General Staff: Can view and edit everyone's profiles.
Senior Staff: Can also see all the accounts.
Superusers: Can access everything.

You can then plan your functions so that these four groups get accesss
to what they are authorised to do.  It is a lot easier to allocate
permissions to 4 groups than 50 individuals.

You need to get a pen and paper and write down what everyone should be
able to do.  There are no short cuts to thinking through the logic.

Best wishes
David

On Feb 11, 11:00 pm, pbreit pbreitenb...@gmail.com wrote:
 I'm having trouble as well figuring out the best way to do this. It is core
 to ever app I contemplate building but doesn't seem to be spelled out in the
 docs. Pretty much every web site I know of personalizes web pages based on
 who is logged in.

 I noticed that for each user, a db.auth_group is created. Would we use that
 for this type of permissioning?

[web2py] Re: Howto populate table with data

2011-02-11 Thread Christopher Steel

The Instant-press application is a great application to take a look at
for a number of reasons. In addition you will find an example of
populating a table with default values.

http://code.google.com/p/instant-press/


Chris



On Feb 10, 4:57 pm, Sascha Peilicke sasc...@gmx.de wrote:
 Hi guys,

 I'd like to know how to best populate a table with a given set of default
 values. I could add them manually via the shell, but I'd like it to be done
 when the table is created. Let's consider the following table:

 db.define_table('tag',
     Field('name'),
     format='%(name)s')

 And assume I got some tags:

 TAGS = ['nice','great','awesome']

 So, how's the most appropriate way in getting those tags into the table?
 --
 Mit freundlichen Grüßen,
 Sascha Peilickehttp://saschpe.wordpress.com

  signature.asc
  1KViewDownload

[web2py] testing ldap communication?

2011-02-11 Thread Panupat

I'm really stuck here, would greatly appreciate any help.

Is there a way to check or test if the DAL is communicating with the
ldap ad host? It seems like no matter what settings I used to the
server and base_dn, even ones that are obviously wrong, I am only
getting the same invalid login error.

I read in some older discussion that I should use

auth.settings.login_methods = [ldap_auth(mode='ad', .

instead of

auth.settings.login_methods.append(ldap_auth(mode='ad', .

Does this still apply to the current version? I'm trying them both
without luck so far.

[web2py] Re: plugin_wiki

2011-02-11 Thread John-Kim Murphy

The green theme is from a previous version of web2py (pre 1.89?) If
you really want it, Chris Steel uploaded a plugin (http://
groups.google.com/group/web2py/msg/954dfcfd1adeb440) that will restore
it.

The plugin_wiki just adds functionality to your app without visually
altering it. It adds a new item to the menu bar, but you have to
create an account and log in before it is visible.


On Feb 12, 6:46 am, Albert Abril albert.ab...@gmail.com wrote:
 I'm not sure what you would mean whit 'the limey green', but if you want to
 access the plugin_wiki once installed, you should go 
 tohttp://URL/YourApp/plugin_wiki.



 On Fri, Feb 11, 2011 at 10:27 PM, stargate kyoukh...@gmail.com wrote:
  I am trying to apply the plugin_wiki to a test application i created
  in the wizard but when i go to preview the site it doesn't look like
  the limey green look why is that.

[web2py] Re: testing ldap communication?

No difference

On Feb 11, 7:30 pm, Panupat panup...@gmail.com wrote:
 I'm really stuck here, would greatly appreciate any help.

 Is there a way to check or test if the DAL is communicating with the
 ldap ad host? It seems like no matter what settings I used to the
 server and base_dn, even ones that are obviously wrong, I am only
 getting the same invalid login error.

 I read in some older discussion that I should use

 auth.settings.login_methods = [ldap_auth(mode='ad', .

 instead of

 auth.settings.login_methods.append(ldap_auth(mode='ad', .

 Does this still apply to the current version? I'm trying them both
 without luck so far.

[web2py] Re: What user is logged in (or, restricting access based on user)

I get the concept of groups which is why I was confused that web2py auth 
creates a auth_group.role for each individual user (user_1, user_2 and so 
on).

In all of my apps I have just one class of users. Sometimes, only the 
created_by can view an item. And usually, only the create_by can edit an 
item. And on pretty much every page I have personalizations based on the 
logged in user. Almost every web site I can think of works like this.

[web2py] Re: WSGI + shared host

2011-02-11 Thread Christopher Steel

Are you running behind apache?



On Feb 10, 4:43 pm, Nico nikola.cvrtn...@gmail.com wrote:
 Hey peeps !

 I have simple question Since web2py doesnt need any installation
 and i want to run it on my shared host... how can i set it up...

 I contacted my host, they moved my acc on another server where they
 support wsgi and they asked me for the path... i told them, the path
 to the script is...

 /home/nico/public_html/dev/web2py/wsgihandler.py

 or

 mydomain.xxx/dev/web2py/wsgihandler

 So... They set it up, so in dev directory wsgi scripts should work
 but it doesnt...

 See what it says here:

 http://cvrtnjak.com/dev/
 orhttp://cvrtnjak.com/dev/web2py

 

 Did they do something wrong or ?
 Any suggestions :) ?

[web2py] [+-off topic] Rails vulnerability issue (are we protected?)

2011-02-11 Thread rochacbruno

I just read about Rails vulnerability, just  thinking if we are protected 
against the same kind of thing?

http://lists.webappsec.org/pipermail/websecurity_lists.webappsec.org/2011-February/007533.html

[web2py] Help me with the coding for making a table

2011-02-11 Thread Rupesh Pradhan


I want using the data below, generate a table:

header=['roll', 'name', 'absent']

data=[['1', ''], ['2', ''], ['3', ''], ['4', '']]


table width=200 border=1
tr
th scope=colRoll/th
th scope=colName/th
th scope=colpAbsent/p
p
label(
input type=checkbox name=absentall id=absentall /
/label
All)/p/th
/tr
form id=form1 name=form1 method=post action=
tr
td1/td
td/td
td
input type=checkbox name=1 id=absent /
/td
/tr
tr
td2/td
td/td
tdinput type=checkbox name=2 id=absent //td
/tr
tr
td3/td
td/td
tdinput type=checkbox name=3 id=absent //td
/tr
tr
td4/td
td/td
tdinput type=checkbox name=4 id=absent //td
/tr

/table
input type=submit name=submit id=submit value=Submit /
/form

[web2py] Re: web2py not using global http_proxy

2011-02-11 Thread whowhywhat

Thanks for the quick replies.
As Luis mentions i have used export http_proxy (but in /etc/
environment and in the startup script of cherokee). I will try
defining in /etc/profile
i did some further testing by launching web2py with its own web
server.
by running python web2py.py -c server.crt -k server.key -a password -
i IPADDRESS -p 
This way web2py uses the proxy seamlessly (It works fine!)

but when i deploy using wsgi either in apache or cherokee web2py does
not see the proxy. what could be wrong? where is this problem
occurring?

Luis .. which is the web server and cgi setup you are using?

i am really impressed with the speed of cherokee + wsgi + web2py, the
memory foot print is small and the whole thing runs like greased
lightning :D .. i just hope to solve this proxy issue.

On Feb 11, 10:50 pm, Luis Díaz diazluis2...@gmail.com wrote:
 I forgot.
 if you need to specify username and password
 then the structure would be something.

 export http_proxy =http://username:password@proxy:port/
 export https_proxy =http://username:password@proxy:port/
 export ftp_proxy =http://username:password@proxy:port/

 2011/2/11 Luis Díaz diazluis2...@gmail.com









  Greetings,
  web2py I mention that I use in my work.
  and we have a proxy that we restrict the output
  by user name and password

  I have solved the problem properly configuring the proxy on the computer
  where I have installed debian web2py

  nano /etc/profile

  adding the following lines:

  export http_proxy =http://proxy.uc.edu.ve:5010/
  export https_proxy =http://proxy.uc.edu.ve:5010/
  export ftp_proxy =http://proxy.uc.edu.ve:5010/

  2011/2/11 Massimo Di Pierro massimo.dipie...@gmail.com

  Thanks for your comments.

  WHen you need urllib, and web2py.python makes outbound connections you
  should not need a proxy server or any proxy configuration as far as I
  can tell (and I am not sure about your setup). This looks more of a
  firewall issue.

  On Feb 11, 5:19 am, whowhywhat mads...@gmail.com wrote:
   web2py is the first framework i actually enjoy using. :) .. been
   advocating it to everyone i meet these days. I sincerely thank the
   entire web2py community for everything.

   I have been developing a small web2py application for intranet use at
   the place where i work. During development i used windows (i carry
   web2py on a thumb drive). At work we use a proxy for net access and in
   windows i have no problems with web2py accessing the net using the
   proxy.
   I can use urllib to fetch webpages etc.

   To deploy the app i am using Ubuntu. I have deployed web2py using both
   apache as well as Cherokee using WSGI. The application runs fine.
   however the web2py environment is not able to fetch anything from the
   internet. urllib does not fetch any webpages. I have explicitly set
   the http_proxy environment variable (in /etc/environment, in the
   Cherokee startup script). I need to fetch data from the web, mostly
   for openID authentication. I am not sure what's wrong.

   how can i make web2py/python use the proxy server (http_proxy)?

  --
  Díaz Luis
  TSU Analisis de Sistemas
  Universidad de Carabobo

  Facultad de 
  Odontologíahttp://www.odontologia.uc.edu.ve/index.php?option=com_contentview=ar...

 --
 Díaz Luis
 TSU Analisis de Sistemas
 Universidad de Carabobo

 Facultad de 
 Odontologíahttp://www.odontologia.uc.edu.ve/index.php?option=com_contentview=ar...

Re: [web2py] Re: Apache, Wsgi problem

2011-02-11 Thread Jonathan Lundell

On Feb 10, 2011, at 6:19 AM, Massimo Di Pierro wrote:
 
 I offer $300 to whoever can identify within 3 weeks and without
 ambiguity the cause of this problem. The bounty applies even if the
 problem turns out to be not in web2py but in one of the Python
 modules, in Apache or in the mod_wsgi implementation. It does not
 apply if the problem is due to known bug that has already been fixed
 by the responsible party (for example if you are using an old un-
 patched python version like 2.5.0 or an old mod_wsgi version).

psycopg2 2.0.7 is the version in use in this case. 2.0.8 had this in the change 
log:

 * psycopg/pqpath.c (_pq_fetch_tuples): Don't call Python APIs
 without holding the GIL.


Suggestive, no? There's some evidence on the web that this may have led to 
Segmentation fault - premature end of script headers errors.

2.3.2 is current.

Re: [web2py] Re: Apache, Wsgi problem