From plstiburek at gmail.com  Thu Oct 11 11:05:10 2012
From: plstiburek at gmail.com (pavel lstiburek)
Date: Thu, 11 Oct 2012 11:05:10 +0200
Subject: [Erp5-dev] ERP5 - start date error
Message-ID: <CAOeJZqs2FEauC2y71MbARCsf_hQEk6y863xRm8N2mUe8_zoKoQ@mail.gmail.com>

Hi,
i keep running into problems with start_date and stop_date.
Usualy it says me *Could not map those columns: set(['stop_date'])*
I coudnt search by it, but searching with creation_date is no problem.
Can someone tell how to fix this error, or where can i look for script that
defines start_date or stop_date?

-- 
Pavel Lstiburek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20121011/fd5ebbbc/attachment.htm>

From yusei at nexedi.com  Thu Oct 11 11:13:37 2012
From: yusei at nexedi.com (Yusei TAHARA)
Date: Thu, 11 Oct 2012 18:13:37 +0900
Subject: [Erp5-dev] ERP5 - start date error
In-Reply-To: <CAOeJZqs2FEauC2y71MbARCsf_hQEk6y863xRm8N2mUe8_zoKoQ@mail.gmail.com>
References: <CAOeJZqs2FEauC2y71MbARCsf_hQEk6y863xRm8N2mUe8_zoKoQ@mail.gmail.com>
Message-ID: <20121011181337.751dc946.yusei@nexedi.com>

Hi,

There are two sets of date time columns in catalog. One is
delivery.start_date and delivery.stop_date. The other one is
movement.start_date and movement.stop_date.

If you search movement type document like sale order line, sale
packing list line, you need to use "movement.start_date". And
if you search delivery type doucment like sale order, sale
packing list, then you need "delivery.start_date".

And then you also need to add listbox_delivery_start_date datetime
field to listbox to control datetime formating for example.

You can find many example implementations. One good example is
portal_skins/erp5_trade/SaleOrderModule_viewSaleOrderList in
erp5_trade business template.

Regards,
Yusei

On Thu, 11 Oct 2012 11:05:10 +0200
pavel lstiburek <plstiburek at gmail.com> wrote:

> Hi,
> i keep running into problems with start_date and stop_date.
> Usualy it says me *Could not map those columns: set(['stop_date'])*
> I coudnt search by it, but searching with creation_date is no problem.
> Can someone tell how to fix this error, or where can i look for script that
> defines start_date or stop_date?
> 
> -- 
> Pavel Lstiburek


-- 
Yusei TAHARA <yusei at nexedi.com>
Nexedi: Consulting and Development of Free / Open Source Software
http://www.nexedi.co.jp/
ERP5: Full Featured High End Open Source ERP
http://www.erp5.com/
ERP5 Wiki: Developer Zone for ERP5 Community
http://www.erp5.org/

From plstiburek at gmail.com  Thu Oct 11 11:33:04 2012
From: plstiburek at gmail.com (pavel lstiburek)
Date: Thu, 11 Oct 2012 11:33:04 +0200
Subject: [Erp5-dev] ERP5 - start date error
In-Reply-To: <20121011181337.751dc946.yusei@nexedi.com>
References: <CAOeJZqs2FEauC2y71MbARCsf_hQEk6y863xRm8N2mUe8_zoKoQ@mail.gmail.com>
	<20121011181337.751dc946.yusei@nexedi.com>
Message-ID: <CAOeJZqu7T5NE9n2rJYBz+k9UmWhL-kdQWehraP-4xLpR0jUACw@mail.gmail.com>

Thanks, this will do most of times.
But what if i for example need to find all person older than 20. If try to
find it by date i get error.
Person is not movement or delivery. How to deal with such case?

Pavel Lstiburek

2012/10/11 Yusei TAHARA <yusei at nexedi.com>

> Hi,
>
> There are two sets of date time columns in catalog. One is
> delivery.start_date and delivery.stop_date. The other one is
> movement.start_date and movement.stop_date.
>
> If you search movement type document like sale order line, sale
> packing list line, you need to use "movement.start_date". And
> if you search delivery type doucment like sale order, sale
> packing list, then you need "delivery.start_date".
>
> And then you also need to add listbox_delivery_start_date datetime
> field to listbox to control datetime formating for example.
>
> You can find many example implementations. One good example is
> portal_skins/erp5_trade/SaleOrderModule_viewSaleOrderList in
> erp5_trade business template.
>
> Regards,
> Yusei
>
> On Thu, 11 Oct 2012 11:05:10 +0200
> pavel lstiburek <plstiburek at gmail.com> wrote:
>
> > Hi,
> > i keep running into problems with start_date and stop_date.
> > Usualy it says me *Could not map those columns: set(['stop_date'])*
> > I coudnt search by it, but searching with creation_date is no problem.
> > Can someone tell how to fix this error, or where can i look for script
> that
> > defines start_date or stop_date?
> >
> > --
> > Pavel Lstiburek
>
>
> --
> Yusei TAHARA <yusei at nexedi.com>
> Nexedi: Consulting and Development of Free / Open Source Software
> http://www.nexedi.co.jp/
> ERP5: Full Featured High End Open Source ERP
> http://www.erp5.com/
> ERP5 Wiki: Developer Zone for ERP5 Community
> http://www.erp5.org/
> _______________________________________________
> Erp5-dev mailing list
> Erp5-dev at erp5.org
> https://mail.tiolive.com/mailman/listinfo/erp5-dev
>



-- 
Pavel Lstiburek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20121011/833ecc86/attachment.htm>

From yusei at nexedi.com  Thu Oct 11 11:52:49 2012
From: yusei at nexedi.com (Yusei TAHARA)
Date: Thu, 11 Oct 2012 18:52:49 +0900
Subject: [Erp5-dev] ERP5 - start date error
In-Reply-To: <CAOeJZqu7T5NE9n2rJYBz+k9UmWhL-kdQWehraP-4xLpR0jUACw@mail.gmail.com>
References: <CAOeJZqs2FEauC2y71MbARCsf_hQEk6y863xRm8N2mUe8_zoKoQ@mail.gmail.com>
	<20121011181337.751dc946.yusei@nexedi.com>
	<CAOeJZqu7T5NE9n2rJYBz+k9UmWhL-kdQWehraP-4xLpR0jUACw@mail.gmail.com>
Message-ID: <20121011185249.7da46155.yusei@nexedi.com>

Hi,

In such case, you first need to add a custom mysql table and
corresponding zsqlmethods to portal_catalog. Because portal_catalog
does not cover all properties of document. Only some specific
properties are searchable.

About person document, it has start_date, but it is not a
delivery/movement. Thus person's start_date is not indexed and it is
not searchable by default.

erp5_ingestion_mysql_innodb_catalog is a good example to know how
to extend catalog.

Regards,
Yusei


On Thu, 11 Oct 2012 11:33:04 +0200
pavel lstiburek <plstiburek at gmail.com> wrote:

> Thanks, this will do most of times.
> But what if i for example need to find all person older than 20. If try to
> find it by date i get error.
> Person is not movement or delivery. How to deal with such case?
> 
> Pavel Lstiburek
> 
> 2012/10/11 Yusei TAHARA <yusei at nexedi.com>
> 
> > Hi,
> >
> > There are two sets of date time columns in catalog. One is
> > delivery.start_date and delivery.stop_date. The other one is
> > movement.start_date and movement.stop_date.
> >
> > If you search movement type document like sale order line, sale
> > packing list line, you need to use "movement.start_date". And
> > if you search delivery type doucment like sale order, sale
> > packing list, then you need "delivery.start_date".
> >
> > And then you also need to add listbox_delivery_start_date datetime
> > field to listbox to control datetime formating for example.
> >
> > You can find many example implementations. One good example is
> > portal_skins/erp5_trade/SaleOrderModule_viewSaleOrderList in
> > erp5_trade business template.
> >
> > Regards,
> > Yusei
> >
> > On Thu, 11 Oct 2012 11:05:10 +0200
> > pavel lstiburek <plstiburek at gmail.com> wrote:
> >
> > > Hi,
> > > i keep running into problems with start_date and stop_date.
> > > Usualy it says me *Could not map those columns: set(['stop_date'])*
> > > I coudnt search by it, but searching with creation_date is no problem.
> > > Can someone tell how to fix this error, or where can i look for script
> > that
> > > defines start_date or stop_date?
> > >
> > > --
> > > Pavel Lstiburek
> >
> >
> > --
> > Yusei TAHARA <yusei at nexedi.com>
> > Nexedi: Consulting and Development of Free / Open Source Software
> > http://www.nexedi.co.jp/
> > ERP5: Full Featured High End Open Source ERP
> > http://www.erp5.com/
> > ERP5 Wiki: Developer Zone for ERP5 Community
> > http://www.erp5.org/
> > _______________________________________________
> > Erp5-dev mailing list
> > Erp5-dev at erp5.org
> > https://mail.tiolive.com/mailman/listinfo/erp5-dev
> >
> 
> 
> 
> -- 
> Pavel Lstiburek


-- 
Yusei TAHARA <yusei at nexedi.com>
Nexedi: Consulting and Development of Free / Open Source Software
http://www.nexedi.co.jp/
ERP5: Full Featured High End Open Source ERP
http://www.erp5.com/
ERP5 Wiki: Developer Zone for ERP5 Community
http://www.erp5.org/

From plstiburek at gmail.com  Thu Oct 11 11:57:29 2012
From: plstiburek at gmail.com (pavel lstiburek)
Date: Thu, 11 Oct 2012 11:57:29 +0200
Subject: [Erp5-dev] ERP5 - start date error
In-Reply-To: <20121011185249.7da46155.yusei@nexedi.com>
References: <CAOeJZqs2FEauC2y71MbARCsf_hQEk6y863xRm8N2mUe8_zoKoQ@mail.gmail.com>
	<20121011181337.751dc946.yusei@nexedi.com>
	<CAOeJZqu7T5NE9n2rJYBz+k9UmWhL-kdQWehraP-4xLpR0jUACw@mail.gmail.com>
	<20121011185249.7da46155.yusei@nexedi.com>
Message-ID: <CAOeJZqsbeKFKU5=32pzR3XDbKXyViNMHj=ZeFQZZBHqsOiRH7A@mail.gmail.com>

Thanks again for help.

2012/10/11 Yusei TAHARA <yusei at nexedi.com>

> Hi,
>
> In such case, you first need to add a custom mysql table and
> corresponding zsqlmethods to portal_catalog. Because portal_catalog
> does not cover all properties of document. Only some specific
> properties are searchable.
>
> About person document, it has start_date, but it is not a
> delivery/movement. Thus person's start_date is not indexed and it is
> not searchable by default.
>
> erp5_ingestion_mysql_innodb_catalog is a good example to know how
> to extend catalog.
>
> Regards,
> Yusei
>
>
> On Thu, 11 Oct 2012 11:33:04 +0200
> pavel lstiburek <plstiburek at gmail.com> wrote:
>
> > Thanks, this will do most of times.
> > But what if i for example need to find all person older than 20. If try
> to
> > find it by date i get error.
> > Person is not movement or delivery. How to deal with such case?
> >
> > Pavel Lstiburek
> >
> > 2012/10/11 Yusei TAHARA <yusei at nexedi.com>
> >
> > > Hi,
> > >
> > > There are two sets of date time columns in catalog. One is
> > > delivery.start_date and delivery.stop_date. The other one is
> > > movement.start_date and movement.stop_date.
> > >
> > > If you search movement type document like sale order line, sale
> > > packing list line, you need to use "movement.start_date". And
> > > if you search delivery type doucment like sale order, sale
> > > packing list, then you need "delivery.start_date".
> > >
> > > And then you also need to add listbox_delivery_start_date datetime
> > > field to listbox to control datetime formating for example.
> > >
> > > You can find many example implementations. One good example is
> > > portal_skins/erp5_trade/SaleOrderModule_viewSaleOrderList in
> > > erp5_trade business template.
> > >
> > > Regards,
> > > Yusei
> > >
> > > On Thu, 11 Oct 2012 11:05:10 +0200
> > > pavel lstiburek <plstiburek at gmail.com> wrote:
> > >
> > > > Hi,
> > > > i keep running into problems with start_date and stop_date.
> > > > Usualy it says me *Could not map those columns: set(['stop_date'])*
> > > > I coudnt search by it, but searching with creation_date is no
> problem.
> > > > Can someone tell how to fix this error, or where can i look for
> script
> > > that
> > > > defines start_date or stop_date?
> > > >
> > > > --
> > > > Pavel Lstiburek
> > >
> > >
> > > --
> > > Yusei TAHARA <yusei at nexedi.com>
> > > Nexedi: Consulting and Development of Free / Open Source Software
> > > http://www.nexedi.co.jp/
> > > ERP5: Full Featured High End Open Source ERP
> > > http://www.erp5.com/
> > > ERP5 Wiki: Developer Zone for ERP5 Community
> > > http://www.erp5.org/
> > > _______________________________________________
> > > Erp5-dev mailing list
> > > Erp5-dev at erp5.org
> > > https://mail.tiolive.com/mailman/listinfo/erp5-dev
> > >
> >
> >
> >
> > --
> > Pavel Lstiburek
>
>
> --
> Yusei TAHARA <yusei at nexedi.com>
> Nexedi: Consulting and Development of Free / Open Source Software
> http://www.nexedi.co.jp/
> ERP5: Full Featured High End Open Source ERP
> http://www.erp5.com/
> ERP5 Wiki: Developer Zone for ERP5 Community
> http://www.erp5.org/
> _______________________________________________
> Erp5-dev mailing list
> Erp5-dev at erp5.org
> https://mail.tiolive.com/mailman/listinfo/erp5-dev
>



-- 
Pavel Lstiburek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20121011/d24f660e/attachment.htm>

From plstiburek at gmail.com  Thu Oct 11 14:35:07 2012
From: plstiburek at gmail.com (pavel lstiburek)
Date: Thu, 11 Oct 2012 14:35:07 +0200
Subject: [Erp5-dev] ERP5 - translate name
Message-ID: <CAOeJZqsTsYTN3pyd3iSyr20utm+aHO6fo4CcZqcVcE56FnTxXQ@mail.gmail.com>

Hi,
i found that erp5 put Person title in Localizer erp5_content.
Is it my bug or was it purpose? Anyway how can i stop erp5 from doing that?

-- 
Pavel Lstiburek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20121011/57fa9200/attachment.htm>

From jp at nexedi.com  Thu Oct 11 14:40:57 2012
From: jp at nexedi.com (Jean-Paul Smets)
Date: Thu, 11 Oct 2012 14:40:57 +0200
Subject: [Erp5-dev] ERP5 - translate name
In-Reply-To: <CAOeJZqsTsYTN3pyd3iSyr20utm+aHO6fo4CcZqcVcE56FnTxXQ@mail.gmail.com>
References: <CAOeJZqsTsYTN3pyd3iSyr20utm+aHO6fo4CcZqcVcE56FnTxXQ@mail.gmail.com>
Message-ID: <5076BE59.4080007@nexedi.com>

Hi,

It is a default setting which is likely wrong (it it right for other 
portal types such as Product).

You can set this on the portal type settings by selecting "no message 
translation" for translatable properties.

Regards,

JPS.


Le 11/10/2012 14:35, pavel lstiburek a ?crit :
> Hi,
> i found that erp5 put Person title in Localizer erp5_content.
> Is it my bug or was it purpose? Anyway how can i stop erp5 from doing 
> that?
>
> -- 
> Pavel Lstiburek
>
>
> _______________________________________________
> Erp5-dev mailing list
> Erp5-dev at erp5.org
> https://mail.tiolive.com/mailman/listinfo/erp5-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20121011/55d4a8f5/attachment.htm>

From plstiburek at gmail.com  Thu Oct 11 14:56:45 2012
From: plstiburek at gmail.com (pavel lstiburek)
Date: Thu, 11 Oct 2012 14:56:45 +0200
Subject: [Erp5-dev] ERP5 - translate name
In-Reply-To: <5076BE59.4080007@nexedi.com>
References: <CAOeJZqsTsYTN3pyd3iSyr20utm+aHO6fo4CcZqcVcE56FnTxXQ@mail.gmail.com>
	<5076BE59.4080007@nexedi.com>
Message-ID: <CAOeJZqujJNr=fQii-N-gX9ysijrpoqM06o3X8Uq1em8GADCXQw@mail.gmail.com>

Thnaks a lot,
a completely forgot about this setting.

2012/10/11 Jean-Paul Smets <jp at nexedi.com>

>  Hi,
>
> It is a default setting which is likely wrong (it it right for other
> portal types such as Product).
>
> You can set this on the portal type settings by selecting "no message
> translation" for translatable properties.
>
> Regards,
>
> JPS.
>
>
> Le 11/10/2012 14:35, pavel lstiburek a ?crit :
>
> Hi,
> i found that erp5 put Person title in Localizer erp5_content.
> Is it my bug or was it purpose? Anyway how can i stop erp5 from doing that?
>
>  --
> Pavel Lstiburek
>
>
> _______________________________________________
> Erp5-dev mailing listErp5-dev at erp5.orghttps://mail.tiolive.com/mailman/listinfo/erp5-dev
>
>
>
> _______________________________________________
> Erp5-dev mailing list
> Erp5-dev at erp5.org
> https://mail.tiolive.com/mailman/listinfo/erp5-dev
>
>


-- 
Pavel Lstiburek
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.tiolive.com/pipermail/erp5-dev/attachments/20121011/2075508b/attachment.htm>

From yusei at nexedi.com  Thu Oct 11 15:49:05 2012
From: yusei at nexedi.com (Yusei TAHARA)
Date: Thu, 11 Oct 2012 22:49:05 +0900
Subject: [Erp5-dev] ERP5 - translate name
In-Reply-To: <5076BE59.4080007@nexedi.com>
References: <CAOeJZqsTsYTN3pyd3iSyr20utm+aHO6fo4CcZqcVcE56FnTxXQ@mail.gmail.com>
	<5076BE59.4080007@nexedi.com>
Message-ID: <20121011224905.dc4d1d16.yusei@nexedi.com>

Hi,

On Thu, 11 Oct 2012 14:40:57 +0200
Jean-Paul Smets <jp at nexedi.com> wrote:

> Hi,
> 
> It is a default setting which is likely wrong (it it right for other 
> portal types such as Product).

Yes. Many portal type like Sale Order Line has this setting and it
is not appropriate in most cases. Because this setting easily
causes a conflict error inside Localizer. Localizer uses persistent
mapping to store messages and it is weak to many writing.

Regards,
Yusei

> 
> You can set this on the portal type settings by selecting "no message 
> translation" for translatable properties.
> 
> Regards,
> 
> JPS.
> 
> 
> Le 11/10/2012 14:35, pavel lstiburek a ?crit :
> > Hi,
> > i found that erp5 put Person title in Localizer erp5_content.
> > Is it my bug or was it purpose? Anyway how can i stop erp5 from doing 
> > that?
> >
> > -- 
> > Pavel Lstiburek
> >
> >
> > _______________________________________________
> > Erp5-dev mailing list
> > Erp5-dev at erp5.org
> > https://mail.tiolive.com/mailman/listinfo/erp5-dev
> 


-- 
Yusei TAHARA <yusei at nexedi.com>
Nexedi: Consulting and Development of Free / Open Source Software
http://www.nexedi.co.jp/
ERP5: Full Featured High End Open Source ERP
http://www.erp5.com/
ERP5 Wiki: Developer Zone for ERP5 Community
http://www.erp5.org/

From jp at nexedi.com  Thu Oct 11 18:23:55 2012
From: jp at nexedi.com (jp at nexedi.com)
Date: Thu, 11 Oct 2012 18:23:55 +0200
Subject: [Erp5-dev] =?utf-8?q?ERP5_-_translate_name?=
In-Reply-To: <20121011224905.dc4d1d16.yusei@nexedi.com>
Message-ID: <20121011162355.BB2A3BF02C4@mail2.tiolive.com>

Hi,

In my opinion, this setting should be changed carefully on portal types and commited.

For example: Products, Web Page, Web Site, etc. all need translation
But: Person, Sale Order, Sale Order Line etc. do not necessarily need and it is safe not to translate

Sale Order Line is a good example of case in which some people might want translation, but probably not Localizer based.

Regards,

JPS.


> Hi,
> 
> On Thu, 11 Oct 2012 14:40:57 +0200
> Jean-Paul Smets <jp at nexedi.com> wrote:
> 
> > Hi,
> > 
> > It is a default setting which is likely wrong (it it right for other 
> > portal types such as Product).
> 
> Yes. Many portal type like Sale Order Line has this setting and it
> is not appropriate in most cases. Because this setting easily
> causes a conflict error inside Localizer. Localizer uses persistent
> mapping to store messages and it is weak to many writing.
> 
> Regards,
> Yusei
> 
> > 
> > You can set this on the portal type settings by selecting "no message 
> > translation" for translatable properties.
> > 
> > Regards,
> > 
> > JPS.
> > 
> > 
> > Le 11/10/2012 14:35, pavel lstiburek a ?crit :
> > > Hi,
> > > i found that erp5 put Person title in Localizer erp5_content.
> > > Is it my bug or was it purpose? Anyway how can i stop erp5 from doing 
> > > that?
> > >
> > > -- 
> > > Pavel Lstiburek
> > >
> > >
> > > _______________________________________________
> > > Erp5-dev mailing list
> > > Erp5-dev at erp5.org
> > > https://mail.tiolive.com/mailman/listinfo/erp5-dev
> > 
> 
> 
> -- 
> Yusei TAHARA <yusei at nexedi.com>
> Nexedi: Consulting and Development of Free / Open Source Software
> http://www.nexedi.co.jp/
> ERP5: Full Featured High End Open Source ERP
> http://www.erp5.com/
> ERP5 Wiki: Developer Zone for ERP5 Community
> http://www.erp5.org/
> _______________________________________________
> Erp5-dev mailing list
> Erp5-dev at erp5.org
> https://mail.tiolive.com/mailman/listinfo/erp5-dev
>