[web2py:23768] Question on database definition

2009-06-09 Thread Francois (Jersey)
I am creating a simple model to represent a chart of accounts: For example, we have 0. top account 1. Account 1 1.1 account 1.1 1.11 1.12 1.13 1.2 (...) 2. 2.1 2.2 2.21 2.22 The model is as below : db.define_table('accountfrom

[web2py:24146] Nested list : good example for the documentation

2009-06-14 Thread Francois (Jersey)
Hello I am trying to make a page showing a nested list: period 1 subperiod 1 subperiod 2 subperiod 3 period 2 subperiod 1 subperiod 2 period 3 subperiod 1 period 4 subperiod 1 subperiod 2 subperiod 3 My model is: db.define_table('period', SQLField('descrip

[web2py:24261] Re: Nested list : good example for the documentation

2009-06-15 Thread Francois (Jersey)
I tried the following view: {{extend 'layout.html'}} This is the test/show_periods.html template {{for period in periods:}} {{period}} {{ subperiods = db(db.subperiod.period=period.id).select()}} {{for subperiod in subperiods:}} {{subperiod}} {{pass}} {{pass}}

[web2py:24301] Re: Nested list : good example for the documentation

2009-06-16 Thread Francois (Jersey)
Tried what you suggested (see below), but I still have an error message: def show_periods(): periods=db().select(db.period.ALL) return dict(periods=periods) {{extend 'layout.html'}} This is the test/show_periods.html template {{for period in periods:}} {{=period}} {{subperiods =

[web2py:24302] Re: Nested list : good example for the documentation

2009-06-16 Thread Francois (Jersey)
Where line 42 is subperiods = db (db.subperiod.period=period.id).select() --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com

[web2py:24332] Re: new slides

2009-06-16 Thread Francois (Jersey)
can not access as well, and have an Invalid function. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this

[web2py:24659] Newbie question: showing details for a foreign key instead of the foreign key number

2009-06-21 Thread Francois (Jersey)
I am trying to show the detail for a foreign key, but I really do not know how to do it. My model is: db.define_table('currency', SQLField('code',length=3), SQLField('name',length=100)) db.currency.code.requires=[IS_NOT_EMPTY(),IS_NOT_IN_DB (db,'currency.code')] db

[web2py:25286] Re: Web2py is not too designer friendly?

2009-06-29 Thread Francois (Jersey)
Would it be possible to add an example of more complex form on the web2py website, as it may be a way of answering lots of queries? On my side, I was asking myself the same question and was trying to do a complex form using a bit of javascript (Jscript?). Like lots of new user of Web2py, I find

[web2py:25310] Re: Web2py is not too designer friendly?

2009-06-29 Thread Francois (Jersey)
An example of "return response.render('custom.html',data=data) " would be useful on the web2py website. Fabulous framework. --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to th

[web2py:25531] Re: need an ajax spreadsheet? Here is one

2009-07-02 Thread Francois (Jersey)
tried to install the spreadsheet application, but I have the following error message: unable to install application spreadsheet. It is possible to download the file, but I believe file is corrupt --~--~-~--~~~---~--~~ You received this message because you are subs

[web2py:25754] Re: need an ajax spreadsheet

2009-07-05 Thread Francois (Jersey)
Try to install from the following link http://www.web2py.com/appliances/default/download/app.source.abebe92ece83f899.73686565742e773270.w2p, and I still have an error message, Unable to install application "spreadsheet". Am I the only one in this case? Francois --~--~-~--~~--

[web2py:25756] Re: want to help web2py?

2009-07-05 Thread Francois (Jersey)
I am currently building an accounting system for companies. This could be used as a foundation to develop more financial applications. Likely delivery end of the year. Your release of spreadsheet is proving very useful, eventhough I am encountering similar difficulties to some people on the mailin

[web2py:26244] Re: new chapters for the book CRUD and AUTH

2009-07-11 Thread Francois (Jersey)
Reviewed chapter 7 Forms and validators. The chapter deals with multiple forms per page, however a more complex example would be useful. Let me explain the limitation of the current presentation. The example presented page 178 has a validation button for each form, but it is not possible to vali

[web2py:26243] Re: new chapters for the book CRUD and AUTH

2009-07-11 Thread Francois (Jersey)
Reviewed chapter 7 Forms and validators. The chapter deals with multiple forms per page, however a more complex example would be useful. Let me explain the limitation of the current presentation. The example presented page 178 has a validation button for each form, but it is not possible to vali

[web2py:26290] Re: new chapters for the book CRUD and AUTH

2009-07-11 Thread Francois (Jersey)
Agree with Massimo, that it is the best solution. Still struggling with it though :;) --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegr

[web2py:26325] Re: task forces

2009-07-11 Thread Francois (Jersey)
Back with an old query, in order to deal with an e-store, we would need to deal with numeric, as we need to deal with prices which are monetary amounts in multiple currencies. I can not remember where we are with numeric implementation? For example in SQLalchemy, numeric is defined as class sql

[web2py:26326] Re: task forces

2009-07-11 Thread Francois (Jersey)
For example in Postgresql and MySQL , we Monetary Types: http://www.postgresql.org/docs/8.4/static/datatype-money.html http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html I really believe that we should store monetary amount using the monetary amount available in the database if available,

[web2py:26367] complex redirect: help needed

2009-07-12 Thread Francois (Jersey)
I am trying to make a complex redirection: Each transaction can have multiple transactions lines. For each transaction, the user can create a new transaction line or edit an existing one. When the user has posted a new transaction line or edited an existing one, the page should redirect to the p

[web2py:28496] Accounting package: help needed for Jquery against a fee

2009-08-13 Thread Francois (Jersey)
I am writing a small accounting software using WEB2PY and Jquery validate. I have started writing a dynamic javascript page, but I am new to it. Would anyone be willing to work on it for a fee. I am using an enhancement of the example dynamic total from the Jquery validate package, and this i

[web2py:28908] Re: Create a group on Ning?

2009-08-18 Thread Francois (Jersey)
So there are no members in Linkedin, as Massimo needs to authorise users who request to join the group :) or alternatively should allow everyone to join. On Aug 18, 3:09 pm, mdipierro wrote: > I do not know what Ning is. There are groups on linked-in and facebook > but no action there. All the a

[web2py:29613] Re: web2py course

2009-08-28 Thread Francois (Jersey)
how many hours of work are expected for this 5 weeks course? --~--~-~--~~~---~--~~ 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 To unsubscribe from this

[web2py:37436] Re: Virtualfields to make a running total

2009-12-16 Thread Francois (Jersey)
Is anyone wanting to join forces to create a MIT/GPL accounting software? I spent a year writing specification for a multi currencies accounting software and would love to share with other people. We have a nice interface for entering transactions: http://olivvv.aptanacloud.com/compta/index.html

[web2py:37478] Re: Virtualfields to make a running total

2009-12-17 Thread Francois (Jersey)
unts. > However,  if you give me some idea of your project perhaps some > elements would overlap,  especially for data entry. > > I see a role for Massimo's spreadsheet for reporting or modelling > budgets etc. > > Regards, > -David > > On Dec 17, 7:31 am, "Fra

[web2py:37479] Re: Virtualfields to make a running total

2009-12-17 Thread Francois (Jersey)
Forgot to say, I have found a fabulous expert on jquey, who will help build the nice forms. Massimo, any chance of paying some students to help on project to advance on the accounting software project? -- You received this message because you are subscribed to the Google Groups "web2py-users" g

[web2py:37508] Re: Virtualfields to make a running total

2009-12-17 Thread Francois (Jersey)
have spent one year working on the blueprint of the software, and I feel it would a very interesting/revolutionnary software for the free software, as accounting is really what is missing. On Dec 18, 3:38 am, mdipierro wrote: > Who pays? I can find the students. > > On Dec 17, 3:48 pm,

[web2py:37685] Re: Virtualfields to make a running total

2009-12-22 Thread Francois (Jersey)
thers, you might get some > people to chip in with the costs etc.  Something simple which also > works on GoogleApps could be quite revolutionary! > > Regards, > - David > > On Dec 17, 9:40 pm, "Francois (Jersey)" > > > > wrote: > > Hi David, > >

[web2py:22512] DECIMAL or NUMERIC type for database fields

2009-05-23 Thread Francois (Jersey)
Dear all, Having a numeric/decimal support for web2py is key to produce applications including accounting or financial aspects, and there had been discussions about it back in March. I understand that the reason for not including decimal or numerical is that it is not supported by all the databa

[web2py:22544] Re: DECIMAL or NUMERIC type for database fields

2009-05-24 Thread Francois (Jersey)
I thought that Python, since version 2.4 could deal with decimal. Please have a look at the link http://docs.python.org/library/decimal.html Am I missing something? If Python can deal with decimal and the database can as well, would it make sense to have decimal implemented in Web2py? Apologies,

[web2py:22545] Re: DECIMAL or NUMERIC type for database fields

2009-05-24 Thread Francois (Jersey)
Floats can not be used, as float may give a different result from decimal, and this is not acceptable for financial applications: An explanation of the difference can be found at http://docs.python.org/library/decimal.html --~--~-~--~~~---~--~~ You received this me

[web2py:22648] Re: DECIMAL or NUMERIC type for database fields

2009-05-25 Thread Francois (Jersey)
Agree with Joe, on the need to store decimal in the database. I may be biaised because I have used Sqlalchemy before. I suppose we should be able to find inspiration from Sqlalchemy code for decimal... Please let me know how I can help. --~--~-~--~~~---~--~~ You r

[web2py:22652] Re: experimental: decimal and pickable and custom columns

2009-05-26 Thread Francois (Jersey)
The link to the Sqlalchemy page should be useful: http://www.sqlalchemy.org/docs/05/reference/sqlalchemy/types.html --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group,