You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Amine Benkirane <be...@hotmail.com> on 2008/07/17 14:28:28 UTC
Categories/products and parties
Hi,
I'm customizing, acutally, an OFBiz ecommerce site. For my specific needs, I want to associates Categories and products with parties. Basically, I add a party like customerA (partyId = 10000) and I want that this customer can only visualize (and buy) the categories and products which are associated to him.
I saw that in the Catalog Manager Application when I browsed my categories and click on one, there is a parties menu. I thought that can do my need but when I want to associate party to category (I select customer for the type), I had this error :
The Following Errors Occurred:
ERROR:
Could not complete the Add Party to Category
[file:/C:/Projets_Eclipse/ofbiz-mars/applications/product/script/org/ofbiz/product/category/CategoryServices.xml#addPartyToCategory]
process [problem creating the newEntity value: Error while inserting:
[GenericEntity:ProductCategoryRole][createdStamp,2008-07-17
14:25:46.005(java.sql.Timestamp)][createdTxStamp,2008-07-17
14:25:44.453(java.sql.Timestamp)][fromDate,2008-07-17
14:25:46.005(java.sql.Timestamp)][lastUpdatedStamp,2008-07-17
14:25:46.005(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-17
14:25:44.453(java.sql.Timestamp)][partyId,10000(java.lang.String)][productCategoryId,snackfood_fr(java.lang.String)][roleTypeId,CUSTOMER(java.lang.String)]
(SQL Exception while executing the following:INSERT INTO
OFBIZ.PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID,
ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP,
LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_CATEGORY_ROLE' caused
a violation of foreign key constraint 'PROD_CRLE_PTYRLE' for key
(10000,CUSTOMER). The statement has been rolled back.))]
Did I forgot something to do this association betwwen my categories and parties ?
Regards,
Amine
_________________________________________________________________
Votre correspondant a choisi Hotmail, un e-mail ultra sécurisé. Créez le votre gratuitement !
http://www.windowslive.fr/hotmail/default.asp
RE: Categories/products and parties
Posted by Amine Benkirane <be...@hotmail.com>.
Ok it works !! Thank you Jacopo !!!!
I only have a question : when a party logged in the ecommerce site, is this association generate the ecommerce browse categories with only the categories associated with the party ?
Regards,
Amine
> From: jacopo.cappellato@gmail.com
> To: user@ofbiz.apache.org
> Subject: Re: Categories/products and parties
> Date: Thu, 17 Jul 2008 14:32:32 +0200
>
> You should add to the party 10000 the role of CUSTOMER to avoid that
> error.
>
> Jacopo
>
> On Jul 17, 2008, at 2:28 PM, Amine Benkirane wrote:
>
> >
> > Hi,
> >
> > I'm customizing, acutally, an OFBiz ecommerce site. For my specific
> > needs, I want to associates Categories and products with parties.
> > Basically, I add a party like customerA (partyId = 10000) and I want
> > that this customer can only visualize (and buy) the categories and
> > products which are associated to him.
> >
> > I saw that in the Catalog Manager Application when I browsed my
> > categories and click on one, there is a parties menu. I thought that
> > can do my need but when I want to associate party to category (I
> > select customer for the type), I had this error :
> >
> >
> > The Following Errors Occurred:
> > ERROR:
> > Could not complete the Add Party to Category
> > [file:/C:/Projets_Eclipse/ofbiz-mars/applications/product/script/org/
> > ofbiz/product/category/CategoryServices.xml#addPartyToCategory]
> > process [problem creating the newEntity value: Error while inserting:
> > [GenericEntity:ProductCategoryRole][createdStamp,2008-07-17
> > 14:25:46.005(java.sql.Timestamp)][createdTxStamp,2008-07-17
> > 14:25:44.453(java.sql.Timestamp)][fromDate,2008-07-17
> > 14:25:46.005(java.sql.Timestamp)][lastUpdatedStamp,2008-07-17
> > 14:25:46.005(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-17
> > 14:25:44.453(java.sql.Timestamp)][partyId,10000(java.lang.String)]
> > [productCategoryId,snackfood_fr(java.lang.String)]
> > [roleTypeId,CUSTOMER(java.lang.String)]
> > (SQL Exception while executing the following:INSERT INTO
> > OFBIZ.PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID,
> > ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP,
> > LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
> > ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_CATEGORY_ROLE'
> > caused
> > a violation of foreign key constraint 'PROD_CRLE_PTYRLE' for key
> > (10000,CUSTOMER). The statement has been rolled back.))]
> >
> > Did I forgot something to do this association betwwen my categories
> > and parties ?
> >
> > Regards,
> >
> > Amine
> >
> >
> >
> >
> > _________________________________________________________________
> > Votre correspondant a choisi Hotmail, un e-mail ultra sécurisé.
> > Créez le votre gratuitement !
> > http://www.windowslive.fr/hotmail/default.asp
>
_________________________________________________________________
Contrôlez les personnes autorisées à parler à vos enfants sur MSN / Windows Live Messenger !
http://www.windowslive.fr/controleparental/default.asp
Re: Categories/products and parties
Posted by Ashish Vijaywargiya <vi...@gmail.com>.
Jacopo,
I like your idea.
Will put my efforts soon on this.
On Fri, Jul 18, 2008 at 3:08 PM, Jacopo Cappellato <
jacopo.cappellato@gmail.com> wrote:
> Hi Ashish,
>
> I don't like too much the idea of adding behind the lines the role to the
> party: in fact, if the user selects a wrong partyId (for example a supplier)
> and the system will make it a customer...
> The best solution would be, IMO, to enhance the UI (maybe with some Ajax
> magic) so that, when the user selects a role, then only the parties with
> that role are shown.
>
> Jacopo
>
>
> On Jul 18, 2008, at 9:59 AM, Ashish Vijaywargiya wrote:
>
> Jacopo,
>>
>> I remembered that somewhere in Ofbiz a functionality exists to first check
>> the associated role based record, if it doesn't exists then first it
>> creates
>> that record and then
>> create the Record in the calling entity that check for foreign key
>> constraint.
>> I think we should avoid this kind of error as far as User Point of View is
>> concerned.
>>
>> Does this scenario applies to here as well ?
>> If yes please let me know I will work on it as soon as I will get a
>> chance.
>>
>> Please let me know your thoughts on this.
>>
>> On Thu, Jul 17, 2008 at 6:02 PM, Jacopo Cappellato <
>> jacopo.cappellato@gmail.com> wrote:
>>
>> You should add to the party 10000 the role of CUSTOMER to avoid that
>>> error.
>>>
>>> Jacopo
>>>
>>>
>>> On Jul 17, 2008, at 2:28 PM, Amine Benkirane wrote:
>>>
>>>
>>> Hi,
>>>>
>>>> I'm customizing, acutally, an OFBiz ecommerce site. For my specific
>>>> needs,
>>>> I want to associates Categories and products with parties. Basically, I
>>>> add
>>>> a party like customerA (partyId = 10000) and I want that this customer
>>>> can
>>>> only visualize (and buy) the categories and products which are
>>>> associated to
>>>> him.
>>>>
>>>> I saw that in the Catalog Manager Application when I browsed my
>>>> categories
>>>> and click on one, there is a parties menu. I thought that can do my need
>>>> but
>>>> when I want to associate party to category (I select customer for the
>>>> type),
>>>> I had this error :
>>>>
>>>>
>>>> The Following Errors Occurred:
>>>> ERROR:
>>>> Could not complete the Add Party to Category
>>>>
>>>>
>>>> [file:/C:/Projets_Eclipse/ofbiz-mars/applications/product/script/org/ofbiz/product/category/CategoryServices.xml#addPartyToCategory]
>>>> process [problem creating the newEntity value: Error while inserting:
>>>> [GenericEntity:ProductCategoryRole][createdStamp,2008-07-17
>>>> 14:25:46.005(java.sql.Timestamp)][createdTxStamp,2008-07-17
>>>> 14:25:44.453(java.sql.Timestamp)][fromDate,2008-07-17
>>>> 14:25:46.005(java.sql.Timestamp)][lastUpdatedStamp,2008-07-17
>>>> 14:25:46.005(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-17
>>>>
>>>>
>>>> 14:25:44.453(java.sql.Timestamp)][partyId,10000(java.lang.String)][productCategoryId,snackfood_fr(java.lang.String)][roleTypeId,CUSTOMER(java.lang.String)]
>>>> (SQL Exception while executing the following:INSERT INTO
>>>> OFBIZ.PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID,
>>>> ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP,
>>>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
>>>> ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_CATEGORY_ROLE' caused
>>>> a violation of foreign key constraint 'PROD_CRLE_PTYRLE' for key
>>>> (10000,CUSTOMER). The statement has been rolled back.))]
>>>>
>>>> Did I forgot something to do this association betwwen my categories and
>>>> parties ?
>>>>
>>>> Regards,
>>>>
>>>> Amine
>>>>
>>>>
>>>>
>>>>
>>>> _________________________________________________________________
>>>> Votre correspondant a choisi Hotmail, un e-mail ultra sécurisé. Créez le
>>>> votre gratuitement !
>>>> http://www.windowslive.fr/hotmail/default.asp
>>>>
>>>>
>>>
>>>
>>
>> --
>> Ashish Vijaywargiya
>> Indore, India
>> http://en.wikipedia.org/wiki/Indore
>>
>
>
--
Ashish Vijaywargiya
Indore, India
http://en.wikipedia.org/wiki/Indore
Re: Categories/products and parties
Posted by Jacopo Cappellato <ja...@gmail.com>.
Hi Ashish,
I don't like too much the idea of adding behind the lines the role to
the party: in fact, if the user selects a wrong partyId (for example a
supplier) and the system will make it a customer...
The best solution would be, IMO, to enhance the UI (maybe with some
Ajax magic) so that, when the user selects a role, then only the
parties with that role are shown.
Jacopo
On Jul 18, 2008, at 9:59 AM, Ashish Vijaywargiya wrote:
> Jacopo,
>
> I remembered that somewhere in Ofbiz a functionality exists to first
> check
> the associated role based record, if it doesn't exists then first it
> creates
> that record and then
> create the Record in the calling entity that check for foreign key
> constraint.
> I think we should avoid this kind of error as far as User Point of
> View is
> concerned.
>
> Does this scenario applies to here as well ?
> If yes please let me know I will work on it as soon as I will get a
> chance.
>
> Please let me know your thoughts on this.
>
> On Thu, Jul 17, 2008 at 6:02 PM, Jacopo Cappellato <
> jacopo.cappellato@gmail.com> wrote:
>
>> You should add to the party 10000 the role of CUSTOMER to avoid
>> that error.
>>
>> Jacopo
>>
>>
>> On Jul 17, 2008, at 2:28 PM, Amine Benkirane wrote:
>>
>>
>>> Hi,
>>>
>>> I'm customizing, acutally, an OFBiz ecommerce site. For my
>>> specific needs,
>>> I want to associates Categories and products with parties.
>>> Basically, I add
>>> a party like customerA (partyId = 10000) and I want that this
>>> customer can
>>> only visualize (and buy) the categories and products which are
>>> associated to
>>> him.
>>>
>>> I saw that in the Catalog Manager Application when I browsed my
>>> categories
>>> and click on one, there is a parties menu. I thought that can do
>>> my need but
>>> when I want to associate party to category (I select customer for
>>> the type),
>>> I had this error :
>>>
>>>
>>> The Following Errors Occurred:
>>> ERROR:
>>> Could not complete the Add Party to Category
>>>
>>> [file:/C:/Projets_Eclipse/ofbiz-mars/applications/product/script/
>>> org/ofbiz/product/category/CategoryServices.xml#addPartyToCategory]
>>> process [problem creating the newEntity value: Error while
>>> inserting:
>>> [GenericEntity:ProductCategoryRole][createdStamp,2008-07-17
>>> 14:25:46.005(java.sql.Timestamp)][createdTxStamp,2008-07-17
>>> 14:25:44.453(java.sql.Timestamp)][fromDate,2008-07-17
>>> 14:25:46.005(java.sql.Timestamp)][lastUpdatedStamp,2008-07-17
>>> 14:25:46.005(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-17
>>>
>>> 14:25:44.453(java.sql.Timestamp)][partyId,10000(java.lang.String)]
>>> [productCategoryId,snackfood_fr(java.lang.String)]
>>> [roleTypeId,CUSTOMER(java.lang.String)]
>>> (SQL Exception while executing the following:INSERT INTO
>>> OFBIZ.PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID,
>>> ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP,
>>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES
>>> (?, ?,
>>> ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_CATEGORY_ROLE'
>>> caused
>>> a violation of foreign key constraint 'PROD_CRLE_PTYRLE' for key
>>> (10000,CUSTOMER). The statement has been rolled back.))]
>>>
>>> Did I forgot something to do this association betwwen my
>>> categories and
>>> parties ?
>>>
>>> Regards,
>>>
>>> Amine
>>>
>>>
>>>
>>>
>>> _________________________________________________________________
>>> Votre correspondant a choisi Hotmail, un e-mail ultra sécurisé.
>>> Créez le
>>> votre gratuitement !
>>> http://www.windowslive.fr/hotmail/default.asp
>>>
>>
>>
>
>
> --
> Ashish Vijaywargiya
> Indore, India
> http://en.wikipedia.org/wiki/Indore
Re: Categories/products and parties
Posted by Ashish Vijaywargiya <vi...@gmail.com>.
Jacopo,
I remembered that somewhere in Ofbiz a functionality exists to first check
the associated role based record, if it doesn't exists then first it creates
that record and then
create the Record in the calling entity that check for foreign key
constraint.
I think we should avoid this kind of error as far as User Point of View is
concerned.
Does this scenario applies to here as well ?
If yes please let me know I will work on it as soon as I will get a chance.
Please let me know your thoughts on this.
On Thu, Jul 17, 2008 at 6:02 PM, Jacopo Cappellato <
jacopo.cappellato@gmail.com> wrote:
> You should add to the party 10000 the role of CUSTOMER to avoid that error.
>
> Jacopo
>
>
> On Jul 17, 2008, at 2:28 PM, Amine Benkirane wrote:
>
>
>> Hi,
>>
>> I'm customizing, acutally, an OFBiz ecommerce site. For my specific needs,
>> I want to associates Categories and products with parties. Basically, I add
>> a party like customerA (partyId = 10000) and I want that this customer can
>> only visualize (and buy) the categories and products which are associated to
>> him.
>>
>> I saw that in the Catalog Manager Application when I browsed my categories
>> and click on one, there is a parties menu. I thought that can do my need but
>> when I want to associate party to category (I select customer for the type),
>> I had this error :
>>
>>
>> The Following Errors Occurred:
>> ERROR:
>> Could not complete the Add Party to Category
>>
>> [file:/C:/Projets_Eclipse/ofbiz-mars/applications/product/script/org/ofbiz/product/category/CategoryServices.xml#addPartyToCategory]
>> process [problem creating the newEntity value: Error while inserting:
>> [GenericEntity:ProductCategoryRole][createdStamp,2008-07-17
>> 14:25:46.005(java.sql.Timestamp)][createdTxStamp,2008-07-17
>> 14:25:44.453(java.sql.Timestamp)][fromDate,2008-07-17
>> 14:25:46.005(java.sql.Timestamp)][lastUpdatedStamp,2008-07-17
>> 14:25:46.005(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-17
>>
>> 14:25:44.453(java.sql.Timestamp)][partyId,10000(java.lang.String)][productCategoryId,snackfood_fr(java.lang.String)][roleTypeId,CUSTOMER(java.lang.String)]
>> (SQL Exception while executing the following:INSERT INTO
>> OFBIZ.PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID,
>> ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP,
>> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
>> ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_CATEGORY_ROLE' caused
>> a violation of foreign key constraint 'PROD_CRLE_PTYRLE' for key
>> (10000,CUSTOMER). The statement has been rolled back.))]
>>
>> Did I forgot something to do this association betwwen my categories and
>> parties ?
>>
>> Regards,
>>
>> Amine
>>
>>
>>
>>
>> _________________________________________________________________
>> Votre correspondant a choisi Hotmail, un e-mail ultra sécurisé. Créez le
>> votre gratuitement !
>> http://www.windowslive.fr/hotmail/default.asp
>>
>
>
--
Ashish Vijaywargiya
Indore, India
http://en.wikipedia.org/wiki/Indore
Re: Categories/products and parties
Posted by Jacopo Cappellato <ja...@gmail.com>.
You should add to the party 10000 the role of CUSTOMER to avoid that
error.
Jacopo
On Jul 17, 2008, at 2:28 PM, Amine Benkirane wrote:
>
> Hi,
>
> I'm customizing, acutally, an OFBiz ecommerce site. For my specific
> needs, I want to associates Categories and products with parties.
> Basically, I add a party like customerA (partyId = 10000) and I want
> that this customer can only visualize (and buy) the categories and
> products which are associated to him.
>
> I saw that in the Catalog Manager Application when I browsed my
> categories and click on one, there is a parties menu. I thought that
> can do my need but when I want to associate party to category (I
> select customer for the type), I had this error :
>
>
> The Following Errors Occurred:
> ERROR:
> Could not complete the Add Party to Category
> [file:/C:/Projets_Eclipse/ofbiz-mars/applications/product/script/org/
> ofbiz/product/category/CategoryServices.xml#addPartyToCategory]
> process [problem creating the newEntity value: Error while inserting:
> [GenericEntity:ProductCategoryRole][createdStamp,2008-07-17
> 14:25:46.005(java.sql.Timestamp)][createdTxStamp,2008-07-17
> 14:25:44.453(java.sql.Timestamp)][fromDate,2008-07-17
> 14:25:46.005(java.sql.Timestamp)][lastUpdatedStamp,2008-07-17
> 14:25:46.005(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-17
> 14:25:44.453(java.sql.Timestamp)][partyId,10000(java.lang.String)]
> [productCategoryId,snackfood_fr(java.lang.String)]
> [roleTypeId,CUSTOMER(java.lang.String)]
> (SQL Exception while executing the following:INSERT INTO
> OFBIZ.PRODUCT_CATEGORY_ROLE (PRODUCT_CATEGORY_ID, PARTY_ID,
> ROLE_TYPE_ID, FROM_DATE, THRU_DATE, COMMENTS, LAST_UPDATED_STAMP,
> LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?,
> ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PRODUCT_CATEGORY_ROLE'
> caused
> a violation of foreign key constraint 'PROD_CRLE_PTYRLE' for key
> (10000,CUSTOMER). The statement has been rolled back.))]
>
> Did I forgot something to do this association betwwen my categories
> and parties ?
>
> Regards,
>
> Amine
>
>
>
>
> _________________________________________________________________
> Votre correspondant a choisi Hotmail, un e-mail ultra sécurisé.
> Créez le votre gratuitement !
> http://www.windowslive.fr/hotmail/default.asp