[web2py] Re: monetize web2py anybody?

2010-05-24 Thread Leandro - ProfessionalIT
Massimo, Despite being a product and not a tool, the business plan of OpenERP is very interesting. I think that Regional/Country Departments of the Association can provide more global visibility to Web2Py. IMHO, a business plan to this association can have a certification program with

[web2py] Re: Erro in conditional IS_IN_DB() validator

2010-05-06 Thread Leandro - ProfessionalIT
Friend, I don't know, but I think that this problem can be a bug, because run OK in SQLite but generate this errors in GAE. In my case, I'm using the crud.create() to generate the input FORM then I do not know why the orderby is being called. In db.py I have this field in the table

[web2py] Erro in conditional IS_IN_DB() validator

2010-05-05 Thread Leandro - ProfessionalIT
Friends, In my app running in GAE I'm receiving a error message when display/ create CRUD Create form. In db.py: db.define_table('conta_corrente', Field('conta_corrente_pai','reference conta_corrente', label=T('Conta Corrente Pai')), Field('descricao','string', length=255,

[web2py] Re: Erro in conditional IS_IN_DB() validator

2010-05-05 Thread Leandro - ProfessionalIT
Friends, I tried these two solutions: http://groups.google.com/group/web2py/browse_thread/thread/2f7465d678f24949/eaa0a076fcbded09?lnk=gstq=conditional+is_in_db#eaa0a076fcbded09

[web2py] Re: Erro in conditional IS_IN_DB() validator

2010-05-05 Thread Leandro - ProfessionalIT
Friends, Another informationlocally with SQLite works perfectly, but in the GAE these errors happening. Any Idea ?

[web2py] Error in validator in GAE

2010-05-04 Thread Leandro - ProfessionalIT
Hi Friends, I'm developing a 'calendar' (agenda in portuguese) app and this app is deployed in GAE. My db.py # the data_hora field have a brazilian format and I cannot have two records in the same data/time (only a event in a date/time) db.define_table('agenda',

[web2py] Re: Error in validator in GAE

2010-05-04 Thread Leandro - ProfessionalIT
Master Massimo, just a detail: This form still not saved a data because this error in submit and looking in GAE dataviewer I see that the kind/table agenda not was created / not exist. I think in disable the requires and insert a record and after re- enable this requires, because IMHO this

[web2py] Re: Error in validator in GAE

2010-05-04 Thread Leandro - ProfessionalIT
Now I know the problem and the solution Let's go: In db.py I put this: Field('data_hora','datetime', default=now, requires=[IS_DATETIME(format='%d-%m-%Y %H:%M'), IS_NOT_IN_DB(db, 'agenda.data_hora')], unique=True, label=T('Data/Hora')), and in web2py_ajax.html I customize the default

[web2py] Re: Does mail work in GoogleAppEngine

2010-05-01 Thread Leandro - ProfessionalIT
Hello Friends, Sorry to re-open the topic, but as my problem is relative Well, I have my app deployed in GAE and I'm using the Google Apps Standard to manage my domain. Follow my configurations: In db.py: mail=Mail() mail.settings.server='gae'

[web2py] Re: Does mail work in GoogleAppEngine

2010-05-01 Thread Leandro - ProfessionalIT
Master Massimo, Perfect !, you are right !. Follow the correct configuration to solve this(my) problem(sent mail) in this situation: app deployed in GAE and domain managed by Google Apps: in db.py mail=Mail() mail.settings.server='gae'

[web2py] Re: Web2py Utilities

2010-04-29 Thread Leandro - ProfessionalIT
Thadeus, Sorry by my dummie question...but how to use your librarie in my apps deployed in GAE ? Thanks, Leandro.

[web2py] Self Reference or Null

2010-04-15 Thread Leandro - ProfessionalIT
Friends, I have a situation where I can have a dog that I don't know your father and mother. How to resolve this ? for example, a dog that I buy in a shop. db.define_table('dog', Field('name'), Field('father_id','reference dog'), Field('mother_id','reference dog')) How to map

[web2py] Re: Self Reference or Null

2010-04-15 Thread Leandro - ProfessionalIT
Hi Alexey, sorry, map = define table in models.py. -- Leandro. -- To unsubscribe, reply using remove me as the subject.

[web2py] Using the Google Data APIs in my GAE web2py project

2010-04-05 Thread Leandro - ProfessionalIT
Hi Friends, In the documentation of gdata-python-client library I have this: Using the gdata-python-client library Google offers a Google Data Python client library that simplifies token management and requesting data from specific Google Data APIs. We recently released a version of this

[web2py] [Off-Topic] markdown is useful for me?

2010-02-10 Thread Leandro - ProfessionalIT
Friends, I'm developing my blog with the powerfull web2py. This blog is running in GAE and to create/edit my posts I use the CFKeditor. This give me rich content in my post, because for me, CKFeditor is a great tool. it also allows you to have a 'module manager' quite easy for the end user to

[web2py] Re: help to make a complex model

2010-02-01 Thread Leandro - ProfessionalIT
Massimo, db.define_table('product cost',         Field('quote_products_id', db.quote_products, requires=IS_IN_DB (db, 'quote_products.id', lambda row: row.product.description')), This field generate a error of string expected.         Field('quote_products_id', db.quote_products,

[web2py] Re: help to make a complex model

2010-02-01 Thread Leandro - ProfessionalIT
Massimo, After update my web2py with the last source version(tar.gz) I'm receiving this error message: OperationalError: parameter standard_conforming_strings cannot be changed Ps: My database is postgreSQL. -- You received this message because you are subscribed to the Google Groups

[web2py] help to make a complex model

2010-01-29 Thread Leandro - ProfessionalIT
Friends, I have this situation: My customers quote products and all products in the quote has a separated cost. The sum of all cost for all products of a quote is the price of product for this customer. To map this scenario, I have these tables: a) customer: db.define_table('customer',

[web2py] Re: New site in web2py

2010-01-29 Thread Leandro - ProfessionalIT
Hello Miguel, There's some problem with the noticia view since the html of the news body is rendering as text. Thanks, I forget of XML() function in this page. Congratulations on the site. Thank you. Some details I still have to review and another ideas to a second moment, as comment in the

[web2py] New site in web2py

2010-01-28 Thread Leandro - ProfessionalIT
Friends, The new site in web2py made by my company: ProfessionalIT. KZero Consultoria: http://www.kzeroconsultoria.com.br -- Leandro. -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to

[web2py] Fields in the SQLTable running in GAE

2010-01-27 Thread Leandro - ProfessionalIT
Hi, I have a table (pampa_produto) with many fields (and many records), but when I try show only two fields of this table in a page in GAE, ever show me ALL fields of the table. In my controller: myfields = [db.pampa_produto.id, db.pampa_produto.codigo,

[web2py] Re: Fields in the SQLTable running in GAE

2010-01-27 Thread Leandro - ProfessionalIT
Sorry master by my ignorance, but do you have a example to me ? -- Leandro. -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to

[web2py] Re: Fields in the SQLTable running in GAE

2010-01-27 Thread Leandro - ProfessionalIT
OK. Thanks -- Leandro. -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this

[web2py:38434] Feature read more in a default blog index page

2010-01-06 Thread Leandro - ProfessionalIT
Hi, Well, I am developing my blog and in my index page I have the latest 05 posts. This posts can be big and I think that a good idea is break the content and put a link read more to read the full content of the post. To solve this problem I thought of two solutions: 1) Break the post in

[web2py:38435] Re: Feature read more in a default blog index page

2010-01-06 Thread Leandro - ProfessionalIT
  To solve this problem I thought of two solutions:   1) Break the post in determined number of the words, but this has a problem:      - Break the formatation of my index page.      I implemented this to test but as the content field is a field that accepts html tags if I put a read more

[web2py:38440] Re: Feature read more in a default blog index page [ SOLVED]

2010-01-06 Thread Leandro - ProfessionalIT
Great Master Thadeus !, perfect ! solved my problem !. Thank you very much ! -- Leandro. -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to

[web2py:38478] Re: Feature read more in a default blog index page

2010-01-06 Thread Leandro - ProfessionalIT
1) XML(post.content) is vulenrable to XSS injections. Do XML (post.content,sanitize=True) instead. I'll do it 2) XML(post.content[0:500]) may (and will) truncate some tags. What if for example post content[0:500]='bla bla ... bla a href=http' it will mess up your page very badly.

[web2py:38292] Re: Blogitizor

2010-01-04 Thread Leandro - ProfessionalIT
Thadeus, You're right, this is the best way to have a category web2py to insert the planetplanet. -- Leandro. -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this

[web2py:38156] Re: Blogitizor

2010-01-01 Thread Leandro - ProfessionalIT
Hello David, On Dec 31 2009, 5:32 pm, villas villa...@gmail.com wrote: I vote in a planet, web2py-planet Could you specify the URL please. My google search returned Kpax, but that was described as a CMS from another planet so it can't be that one! I believe there is still this project ...

[web2py:38118] Re: Two Errors (Now one Error)

2009-12-31 Thread Leandro - ProfessionalIT
Master Massimo, On Dec 30, 5:59 pm, mdipierro mdipie...@cs.depaul.edu wrote: 1) GAE rules. Here is a quick fix. posts = db((db.posts.category == cat.id)).select(db.posts.ALL).sort (lambda r['created'],reverse=True) Perfect !, this code solved this problem. 2) Try one of these variations

[web2py:38120] Re: Two Errors [SOLVED]

2009-12-31 Thread Leandro - ProfessionalIT
Hi, Solved with this (remove the ' character) category_name = request.get_vars.category_name category_name = category_name[1:category_name.rfind(')] Thanks by all help . -- Leandro. -- You received this message because you are subscribed to the Google Groups web2py-users group. To post

[web2py:38140] Re: Blogitizor

2009-12-31 Thread Leandro - ProfessionalIT
Hi Thadeus, How do you do to show the posts in determined category where you have two or more words in the name of you category ? I'm looking in your blog now and see this in : http://web2py.thadeusb.com/weblog/category/Web Development Do you can show me the code of controller of categoy

[web2py:38142] Re: Blogitizor

2009-12-31 Thread Leandro - ProfessionalIT
I vote in a planet, web2py-planet -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options,

[web2py:37746] Re: Sitemap Plugin or Sitemap Generator

2009-12-23 Thread Leandro - ProfessionalIT
Friends, I implemented in the default controller a function called sitemap() that have all logic to generate the sitemap.xml file, but I don't know how to escape a string into a XML. My sitemap() function: def sitemap(): sitemap_xml = '' ''' Here the logic to generate the content

[web2py:37753] Re: Sitemap Plugin or Sitemap Generator

2009-12-23 Thread Leandro - ProfessionalIT
On Dec 23, 1:50 pm, mdipierro mdipie...@cs.depaul.edu wrote: I need to see the actual code. Master, follow my dummie code: def sitemap(): import os from gluon.myregex import regex_expose # Statics URLs ctldir = os.path.join(request.folder,controllers)

[web2py:37758] Re: Sitemap Plugin or Sitemap Generator

2009-12-23 Thread Leandro - ProfessionalIT
Perfect ! now I have a sitemap generated by the my Web2Py app. Thank's for all help. -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to

[web2py:37770] Re: Sitemap Plugin or Sitemap Generator

2009-12-23 Thread Leandro - ProfessionalIT
Massimo, Ok, I will follow your suggestion. -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For

[web2py:37665] Re: Sitemap Plugin or Sitemap Generator

2009-12-22 Thread Leandro - ProfessionalIT
Well, I'm trying implement this script(http://toncar.cz/opensource/ sitemap_gen.html) and integrate it how a plugin or use the cron to auto-generate the sitemap.xml file. -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send

[web2py:37011] Re: e-Store Appliance in GAE

2009-12-11 Thread Leandro - ProfessionalIT
Good, very good ! -- You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web...@googlegroups.com. To unsubscribe from this group, send email to web2py+unsubscr...@googlegroups.com. For more options, visit this group

[web2py:35821] Re: twitter in GAE

2009-11-23 Thread Leandro - ProfessionalIT
Hi wes, I copy and paste your suggestion em my controller/page, but I still receive the message: 'Unable to download'. I don't know, but I think that this feature don't run in GAE. Thanks by your help. -- Leandro. --~--~-~--~~~---~--~~ You received this

[web2py:35835] Re: twitter in GAE

2009-11-23 Thread Leandro - ProfessionalIT
._unlock(response)     import gluon.tools     import gluon.contrib.simplejson as sj     page = gluon.tools.fetch('http://twitter.com/web2py?format=json')     return sj.loads(page)['#timeline'] and see what error you get in the GAE log. On Nov 23, 5:24 am, Leandro - ProfessionalIT lsever

[web2py:35840] Re: twitter in GAE

2009-11-23 Thread Leandro - ProfessionalIT
Master Massimo, Sorry, I forget of this detail. That dummie !. The GAE log: In FILE: /base/data/home/apps/leandro-inf/1.337957566746262675/ applications/init/controllers/default.py Traceback (most recent call last): File /base/data/home/apps/leandro-inf/1.337957566746262675/gluon/

[web2py:35847] Re: twitter in GAE

2009-11-23 Thread Leandro - ProfessionalIT
On Nov 23, 3:06 pm, mdipierro mdipie...@cs.depaul.edu wrote: Sorry to do this to you Hey Master no problems ! I love Web2Py and I think our community is very caring. try: def my test():     import gluon.tools     page = gluon.tools.fetch('http://twitter.com/web2py?format=json')    

[web2py:35854] Re: twitter in GAE

2009-11-23 Thread Leandro - ProfessionalIT
Massimo, from google.appengine.api.urlfetch import fetch def my test():     page = fetch('http://twitter.com/ web2py',payload='format=json').content     return page do you get JSON? Massimo This function run OK (http://www.leandro.inf.br/init/default/my_test), then I try change my

[web2py:35868] Re: twitter in GAE

2009-11-23 Thread Leandro - ProfessionalIT
Massimo, def twitter():         session.forget()         session._unlock(response)         import gluon.tools         import gluon.contrib.simplejson as sj         from google.appengine.api.urlfetch import fetch         #page = gluon.tools.fetch('http://twitter.com/web2py? format=json')  

[web2py:35708] twitter in GAE

2009-11-20 Thread Leandro - ProfessionalIT
Hi, I'm trying to implement the feature that show the 'tweets' of my twitter account in the index page of my blog(hosted in GAE) based in the code of admin controller, but it don't run !. In my tests it can't connect with twitter. It's a bug/bad implementation of my controller or the GAE don't

[web2py:33976] GAE don't create table ?

2009-10-28 Thread Leandro - ProfessionalIT
Hi, I'm testing a new app in GAE but after upload the app, it don't create the tables. Any idea ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to

[web2py:33986] Re: GAE don't create table ?

2009-10-28 Thread Leandro - ProfessionalIT
Massimo, You are right !, I need insert a data to create the tables. What I did was create an application called init and upload to the GAE, then I went to see in the Data View and the tables were not shown. I register a user and all tables show in Data View. Sorry by my dummie question.

[web2py:32588] stupid question: How to format a table.id in a form ?

2009-10-09 Thread Leandro - ProfessionalIT
Hi, I have a custom form and I need show the table.id in this format: 0 in the page. How to do this ? Ex: labelspan{{=form.custom.label.id}}/span {{=form.custom.widget.id}}/label This show me: 1 But I need that show me in this way: 1 Any idea ?

[web2py:31916] Multiple fields in a constraint

2009-09-30 Thread Leandro - ProfessionalIT
Hi, I have a table with this fields: id categoria_cliente_id produto_id preco Well, I need to implement a constraint where the fields categoria_cliente_id + produto_id are unique. for example: id - categoria_cliente_id - produto_id - preco 01 01

[web2py:31704] Increment the value of a field + 1 or how to auto-increment a field value ?

2009-09-26 Thread Leandro - ProfessionalIT
Hi, I need create a field in my table that receive the last value + 1 when I create a new record. For example to a questions table. In this table I have a ID and a number of question field. --~--~-~--~~~---~--~~ You received this message because you are

[web2py:31481] Web2Py with Aptana IDE

2009-09-22 Thread Leandro - ProfessionalIT
Hi, I'm trying use Aptana IDE with web2py but when I run web2py.py in IDE I receive a message that the port is in use, but I don't have another application running in this port. Any idea ? --~--~-~--~~~---~--~~ You received this message because you are

[web2py:31269] help with routes.py

2009-09-18 Thread Leandro - ProfessionalIT
Hi, I have two apps in my Web2Py: init - default website. blog - my personal blog. I need of this mapping: www.mysite.com ( the default index page ) point to init/default/index www.mysite.com/company ( a company page )

[web2py:31110] How to set the labels fields to a crud.updade or crud.create ?

2009-09-16 Thread Leandro - ProfessionalIT
For example, in model I do this: db.define_table('unidades', SQLField('sigla','string', length=3, default=''), SQLField('descricao','string', length=150, default=''), migrate=False) db.unidades.sigla.requires=IS_NOT_EMPTY() db.unidades.descricao.requires=IS_NOT_EMPTY()

[web2py:30888] How to Implement a field search to search in all content of my website ?

2009-09-13 Thread Leandro - ProfessionalIT
How to Implement a field search to search in all content of my website ?, any idea ? --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups web2py-users group. To post to this group, send email to web2py@googlegroups.com

[web2py:30919] How to implements a self join in a table definition ?

2009-09-13 Thread Leandro - ProfessionalIT
I have this fields for the NI table: ni part_number customer_id of_id picture_id description is_kit ni_01 ni_02 ni_03 ni_04

[web2py:27606] Auto generate select field in view ?

2009-07-30 Thread Leandro - ProfessionalIT
Hi friends, I have this case: # Model SQLField('aceita','string', default='Sim')) db.pampa_classificacaocliente.aceita.requires=[IS_NOT_EMPTY(), IS_IN_SET(['Sim', 'Não'])] # Controller

[web2py:27285] import SQL Schemma Database into model.py

2009-07-23 Thread Leandro - ProfessionalIT
Hi, It's possible import a SQL Schemma Database into a model.py ? I have a big legacy database(with many tables) and I want generate the model class from database( If this possbile !). Any idea ? --~--~-~--~~~---~--~~ You received this message because you

[web2py:27169] Where/How I can personalize the CRUD behavior and Layout ?

2009-07-22 Thread Leandro - ProfessionalIT
Hi, I'm sorry by my stupid questions and by terrible english , but... I want to personalize the behavior and the Layout of CRUD funcionality, about this, I have Three questions: 1) In the action default/data/select/table_name the generated output is a HTML table with all records and