So should we remove the description field from these ProductCategory
in the demo data? I think so, or how would one be able to see the alternate locale description? Begin forwarded message: > From: [hidden email] > Date: November 9, 2006 1:05:49 PM PST > To: [hidden email] > Subject: svn commit: r473073 - /incubator/ofbiz/trunk/applications/ > ecommerce/data/DemoProductCategoriesI18nData.xml > Reply-To: [hidden email] > > Author: jleroux > Date: Thu Nov 9 13:05:48 2006 > New Revision: 473073 > > URL: http://svn.apache.org/viewvc?view=rev&rev=473073 > Log: > Primary categories content locale now default to english (was french) > > Modified: > incubator/ofbiz/trunk/applications/ecommerce/data/ > DemoProductCategoriesI18nData.xml > > Modified: incubator/ofbiz/trunk/applications/ecommerce/data/ > DemoProductCategoriesI18nData.xml > URL: http://svn.apache.org/viewvc/incubator/ofbiz/trunk/ > applications/ecommerce/data/DemoProductCategoriesI18nData.xml? > view=diff&rev=473073&r1=473072&r2=473073 > ====================================================================== > ======== > --- incubator/ofbiz/trunk/applications/ecommerce/data/ > DemoProductCategoriesI18nData.xml (original) > +++ incubator/ofbiz/trunk/applications/ecommerce/data/ > DemoProductCategoriesI18nData.xml Thu Nov 9 13:05:48 2006 > @@ -24,14 +24,14 @@ > <ElectronicText dataResourceId="DR100DESCIT" textData="Gizmos > it"/> > <ElectronicText dataResourceId="DR100DESCEN" textData="Gizmos > en"/> > > - <Content contentId="C100DESC" contentTypeId="DOCUMENT" > dataResourceId="DR100DESCFR" description="DESCRIPTION FR Gizmos" > localeString="fr" /> > + <Content contentId="C100DESCFR" contentTypeId="DOCUMENT" > dataResourceId="DR100DESCFR" description="DESCRIPTION FR Gizmos" > localeString="fr" /> > <Content contentId="C100DESCIT" contentTypeId="DOCUMENT" > dataResourceId="DR100DESCIT" description="DESCRIPTION IT Gizmos" > localeString="it" /> > <Content contentId="C100DESCEN" contentTypeId="DOCUMENT" > dataResourceId="DR100DESCEN" description="DESCRIPTION EN Gizmos" > localeString="en"/> > > - <ProductCategoryContent productCategoryId="100" > contentId="C100DESC" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > + <ProductCategoryContent productCategoryId="100" > contentId="C100DESCEN" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="C100DESC" contentIdTo="C100DESCIT" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > - <ContentAssoc contentId="C100DESC" contentIdTo="C100DESCEN" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > + <ContentAssoc contentId="C100DESCEN" contentIdTo="C100DESCIT" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > + <ContentAssoc contentId="C100DESCEN" contentIdTo="C100DESCFR" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > > <!-- Small Gizmos category --> > <DataResource dataResourceId="DR101DESCFR" > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > @@ -42,14 +42,14 @@ > <ElectronicText dataResourceId="DR101DESCIT" textData="Piccolo > Gizmos"/> > <ElectronicText dataResourceId="DR101DESCEN" textData="Small > Gizmos"/> > > - <Content contentId="C101DESC" contentTypeId="DOCUMENT" > dataResourceId="DR101DESCFR" description="DESCRIPTION FR Petits > Gizmos" localeString="fr" /> > + <Content contentId="C101DESCFR" contentTypeId="DOCUMENT" > dataResourceId="DR101DESCFR" description="DESCRIPTION FR Petits > Gizmos" localeString="fr" /> > <Content contentId="C101DESCIT" contentTypeId="DOCUMENT" > dataResourceId="DR101DESCIT" description="DESCRIPTION IT Piccolo > Gizmos" localeString="it" /> > <Content contentId="C101DESCEN" contentTypeId="DOCUMENT" > dataResourceId="DR101DESCEN" description="DESCRIPTION EN Small > Gizmos" localeString="en"/> > > - <ProductCategoryContent productCategoryId="101" > contentId="C101DESC" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > + <ProductCategoryContent productCategoryId="101" > contentId="C101DESCEN" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="C101DESC" contentIdTo="C101DESCEN" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > - <ContentAssoc contentId="C101DESC" contentIdTo="C101DESCIT" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > + <ContentAssoc contentId="C101DESCEN" contentIdTo="C101DESCFR" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > + <ContentAssoc contentId="C101DESCEN" contentIdTo="C101DESCIT" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > > <!-- Large Gizmos category --> > <DataResource dataResourceId="DR102DESCFR" > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > @@ -60,14 +60,14 @@ > <ElectronicText dataResourceId="DR102DESCIT" textData="Grande > Gizmos"/> > <ElectronicText dataResourceId="DR102DESCEN" textData="Large > Gizmos"/> > > - <Content contentId="C102DESC" contentTypeId="DOCUMENT" > dataResourceId="DR102DESCFR" description="DESCRIPTION FR Grands > Gizmos" localeString="fr" /> > + <Content contentId="C102DESCFR" contentTypeId="DOCUMENT" > dataResourceId="DR102DESCFR" description="DESCRIPTION FR Grands > Gizmos" localeString="fr" /> > <Content contentId="C102DESCIT" contentTypeId="DOCUMENT" > dataResourceId="DR102DESCIT" description="DESCRIPTION IT Grande > Gizmos" localeString="it" /> > <Content contentId="C102DESCEN" contentTypeId="DOCUMENT" > dataResourceId="DR102DESCEN" description="DESCRIPTION IT Large > Gizmos" localeString="en"/> > > - <ProductCategoryContent productCategoryId="102" > contentId="C102DESC" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > + <ProductCategoryContent productCategoryId="102" > contentId="C102DESCEN" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="C102DESC" contentIdTo="C102DESCIT" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > - <ContentAssoc contentId="C102DESC" contentIdTo="C102DESCEN" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > + <ContentAssoc contentId="C102DESCEN" contentIdTo="C102DESCIT" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > + <ContentAssoc contentId="C102DESCEN" contentIdTo="C102DESCFR" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > > <!-- Widgets category --> > <DataResource dataResourceId="DR200DESCFR" > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > @@ -78,14 +78,14 @@ > <ElectronicText dataResourceId="DR200DESCIT" textData="Widgets > it"/> > <ElectronicText dataResourceId="DR200DESCEN" textData="Widgets > en"/> > > - <Content contentId="C200DESC" contentTypeId="DOCUMENT" > dataResourceId="DR200DESCFR" description="DESCRIPTION FR Gizmos" > localeString="fr" /> > + <Content contentId="C200DESCFR" contentTypeId="DOCUMENT" > dataResourceId="DR200DESCFR" description="DESCRIPTION FR Gizmos" > localeString="fr" /> > <Content contentId="C200DESCIT" contentTypeId="DOCUMENT" > dataResourceId="DR200DESCIT" description="DESCRIPTION IT Gizmos" > localeString="it" /> > <Content contentId="C200DESCEN" contentTypeId="DOCUMENT" > dataResourceId="DR200DESCEN" description="DESCRIPTION EN Gizmos" > localeString="en"/> > > - <ProductCategoryContent productCategoryId="200" > contentId="C200DESC" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > + <ProductCategoryContent productCategoryId="200" > contentId="C200DESCEN" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="C200DESC" contentIdTo="C200DESCIT" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > - <ContentAssoc contentId="C200DESC" contentIdTo="C200DESCEN" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > + <ContentAssoc contentId="C200DESCEN" contentIdTo="C200DESCIT" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > + <ContentAssoc contentId="C200DESCEN" contentIdTo="C200DESCFR" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > > <!-- Small Widgets category --> > <DataResource dataResourceId="DR201DESCFR" > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > @@ -96,14 +96,14 @@ > <ElectronicText dataResourceId="DR201DESCIT" textData="Piccolo > Widgets"/> > <ElectronicText dataResourceId="DR201DESCEN" textData="Small > Widgets"/> > > - <Content contentId="C201DESC" contentTypeId="DOCUMENT" > dataResourceId="DR201DESCFR" description="DESCRIPTION FR Petits > Widgets" localeString="fr" /> > + <Content contentId="C201DESCFR" contentTypeId="DOCUMENT" > dataResourceId="DR201DESCFR" description="DESCRIPTION FR Petits > Widgets" localeString="fr" /> > <Content contentId="C201DESCIT" contentTypeId="DOCUMENT" > dataResourceId="DR201DESCIT" description="DESCRIPTION IT Piccolo > Widgets" localeString="it" /> > <Content contentId="C201DESCEN" contentTypeId="DOCUMENT" > dataResourceId="DR201DESCEN" description="DESCRIPTION EN Small > Widgets" localeString="en"/> > > - <ProductCategoryContent productCategoryId="201" > contentId="C201DESC" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > + <ProductCategoryContent productCategoryId="201" > contentId="C201DESCEN" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="C201DESC" contentIdTo="C201DESCEN" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > - <ContentAssoc contentId="C201DESC" contentIdTo="C201DESCIT" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > + <ContentAssoc contentId="C201DESCEN" contentIdTo="C201DESCFR" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > + <ContentAssoc contentId="C201DESCEN" contentIdTo="C201DESCIT" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > > <!-- Other Mini Widgets category --> > <DataResource dataResourceId="DR2012DESCFR" > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > @@ -114,14 +114,14 @@ > <ElectronicText dataResourceId="DR2012DESCIT" textData="Altro > Mini Widgets"/> > <ElectronicText dataResourceId="DR2012DESCEN" textData="Other > Mini Widgets"/> > > - <Content contentId="C2012DESC" contentTypeId="DOCUMENT" > dataResourceId="DR2012DESCFR" description="DESCRIPTION FR Autre > Mini Widgets" localeString="fr" /> > + <Content contentId="C2012DESCFR" contentTypeId="DOCUMENT" > dataResourceId="DR2012DESCFR" description="DESCRIPTION FR Autre > Mini Widgets" localeString="fr" /> > <Content contentId="C2012DESCIT" contentTypeId="DOCUMENT" > dataResourceId="DR2012DESCIT" description="DESCRIPTION IT Altro > Piccolo Widgets" localeString="it" /> > <Content contentId="C2012DESCEN" contentTypeId="DOCUMENT" > dataResourceId="DR2012DESCEN" description="DESCRIPTION EN Other > Mini Widgets" localeString="en"/> > > - <ProductCategoryContent productCategoryId="2012" > contentId="C2012DESC" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > + <ProductCategoryContent productCategoryId="2012" > contentId="C2012DESCEN" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="C2012DESC" contentIdTo="C2012DESCEN" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > - <ContentAssoc contentId="C2012DESC" contentIdTo="C2012DESCIT" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > + <ContentAssoc contentId="C2012DESCEN" > contentIdTo="C2012DESCFR" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > + <ContentAssoc contentId="C2012DESCEN" > contentIdTo="C2012DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > > <!-- Mini Widgets category --> > <DataResource dataResourceId="DR2011DESCFR" > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > @@ -132,14 +132,14 @@ > <ElectronicText dataResourceId="DR2011DESCIT" textData="Mini > Widgets it"/> > <ElectronicText dataResourceId="DR2011DESCEN" textData="Mini > Widgets en"/> > > - <Content contentId="C2011DESC" contentTypeId="DOCUMENT" > dataResourceId="DR2011DESCFR" description="DESCRIPTION FR Mini > Widgets" localeString="fr" /> > + <Content contentId="C2011DESCFR" contentTypeId="DOCUMENT" > dataResourceId="DR2011DESCFR" description="DESCRIPTION FR Mini > Widgets" localeString="fr" /> > <Content contentId="C2011DESCIT" contentTypeId="DOCUMENT" > dataResourceId="DR2011DESCIT" description="DESCRIPTION IT Mini > Widgets" localeString="it" /> > <Content contentId="C2011DESCEN" contentTypeId="DOCUMENT" > dataResourceId="DR2011DESCEN" description="DESCRIPTION EN Mini > Widgets" localeString="en"/> > > - <ProductCategoryContent productCategoryId="2011" > contentId="C2011DESC" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > + <ProductCategoryContent productCategoryId="2011" > contentId="C2011DESCEN" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="C2011DESC" contentIdTo="C2011DESCEN" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > - <ContentAssoc contentId="C2011DESC" contentIdTo="C2011DESCIT" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > + <ContentAssoc contentId="C2011DESCEN" > contentIdTo="C2011DESCFR" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > + <ContentAssoc contentId="C2011DESCEN" > contentIdTo="C2011DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > > <!-- Micro Widgets category --> > <DataResource dataResourceId="DR20111DESCFR" > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > @@ -150,14 +150,14 @@ > <ElectronicText dataResourceId="DR20111DESCIT" textData="Micro > Widgets it"/> > <ElectronicText dataResourceId="DR20111DESCEN" textData="Micro > Widgets en"/> > > - <Content contentId="C20111DESC" contentTypeId="DOCUMENT" > dataResourceId="DR20111DESCFR" description="DESCRIPTION FR Micro > Widgets" localeString="fr" /> > + <Content contentId="C20111DESCFR" contentTypeId="DOCUMENT" > dataResourceId="DR20111DESCFR" description="DESCRIPTION FR Micro > Widgets" localeString="fr" /> > <Content contentId="C20111DESCIT" contentTypeId="DOCUMENT" > dataResourceId="DR20111DESCIT" description="DESCRIPTION IT Micro > Widgets" localeString="it" /> > <Content contentId="C20111DESCEN" contentTypeId="DOCUMENT" > dataResourceId="DR20111DESCEN" description="DESCRIPTION EN Micro > Widgets" localeString="en"/> > > - <ProductCategoryContent productCategoryId="20111" > contentId="C20111DESC" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > + <ProductCategoryContent productCategoryId="20111" > contentId="C20111DESCEN" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="C20111DESC" > contentIdTo="C20111DESCEN" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > - <ContentAssoc contentId="C20111DESC" > contentIdTo="C20111DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > + <ContentAssoc contentId="C20111DESCEN" > contentIdTo="C20111DESCFR" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > + <ContentAssoc contentId="C20111DESCEN" > contentIdTo="C20111DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > > <!-- Large Widgets category --> > <DataResource dataResourceId="DR202DESCFR" > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > @@ -168,14 +168,14 @@ > <ElectronicText dataResourceId="DR202DESCIT" textData="Grande > Widgets"/> > <ElectronicText dataResourceId="DR202DESCEN" textData="Large > Widgets"/> > > - <Content contentId="C202DESC" contentTypeId="DOCUMENT" > dataResourceId="DR202DESCFR" description="DESCRIPTION FR Grands > Widgets" localeString="fr" /> > + <Content contentId="C202DESCFR" contentTypeId="DOCUMENT" > dataResourceId="DR202DESCFR" description="DESCRIPTION FR Grands > Widgets" localeString="fr" /> > <Content contentId="C202DESCIT" contentTypeId="DOCUMENT" > dataResourceId="DR202DESCIT" description="DESCRIPTION IT Grande > Widgets" localeString="it" /> > <Content contentId="C202DESCEN" contentTypeId="DOCUMENT" > dataResourceId="DR202DESCEN" description="DESCRIPTION IT Large > Widgets" localeString="en"/> > > - <ProductCategoryContent productCategoryId="202" > contentId="C202DESC" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > + <ProductCategoryContent productCategoryId="202" > contentId="C202DESCEN" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="C202DESC" contentIdTo="C202DESCIT" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > - <ContentAssoc contentId="C202DESC" contentIdTo="C202DESCEN" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > + <ContentAssoc contentId="C202DESCEN" contentIdTo="C202DESCIT" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > + <ContentAssoc contentId="C202DESCEN" contentIdTo="C202DESCFR" > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > 00:00:00.0"/> > > <!-- Gift Cards category --> > <DataResource dataResourceId="DRGC-100DESCFR" > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > @@ -186,14 +186,14 @@ > <ElectronicText dataResourceId="DRGC-100DESCIT" > textData="Carte regalo"/> > <ElectronicText dataResourceId="DRGC-100DESCEN" textData="Gift > Cards"/> > > - <Content contentId="CGC-100DESC" contentTypeId="DOCUMENT" > dataResourceId="DRGC-100DESCFR" description="DESCRIPTION FR Cartes > cadeau" localeString="fr" /> > + <Content contentId="CGC-100DESCFR" contentTypeId="DOCUMENT" > dataResourceId="DRGC-100DESCFR" description="DESCRIPTION FR Cartes > cadeau" localeString="fr" /> > <Content contentId="CGC-100DESCIT" contentTypeId="DOCUMENT" > dataResourceId="DRGC-100DESCIT" description="DESCRIPTION IT Carte > regalo" localeString="it" /> > <Content contentId="CGC-100DESCEN" contentTypeId="DOCUMENT" > dataResourceId="DRGC-100DESCEN" description="DESCRIPTION EN Gift > Cards" localeString="en"/> > > - <ProductCategoryContent productCategoryId="GC-100" > contentId="CGC-100DESC" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > + <ProductCategoryContent productCategoryId="GC-100" > contentId="CGC-100DESCEN" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="CGC-100DESC" > contentIdTo="CGC-100DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > - <ContentAssoc contentId="CGC-100DESC" > contentIdTo="CGC-100DESCEN" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > + <ContentAssoc contentId="CGC-100DESCEN" > contentIdTo="CGC-100DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > + <ContentAssoc contentId="CGC-100DESCEN" > contentIdTo="CGC-100DESCFR" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > > <!-- Gift Cards Purchase category --> > <DataResource dataResourceId="DRGC-101DESCFR" > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > @@ -204,14 +204,14 @@ > <ElectronicText dataResourceId="DRGC-101DESCIT" > textData="Acquisto di carta regalo"/> > <ElectronicText dataResourceId="DRGC-101DESCEN" textData="Gift > Cards Purchase"/> > > - <Content contentId="CGC-101DESC" contentTypeId="DOCUMENT" > dataResourceId="DRGC-101DESCFR" description="DESCRIPTION FR Achat > de carte cadeau" localeString="fr" /> > + <Content contentId="CGC-101DESCFR" contentTypeId="DOCUMENT" > dataResourceId="DRGC-101DESCFR" description="DESCRIPTION FR Achat > de carte cadeau" localeString="fr" /> > <Content contentId="CGC-101DESCIT" contentTypeId="DOCUMENT" > dataResourceId="DRGC-101DESCIT" description="DESCRIPTION IT > Acquisto di carta regalo" localeString="it" /> > <Content contentId="CGC-101DESCEN" contentTypeId="DOCUMENT" > dataResourceId="DRGC-101DESCEN" description="DESCRIPTION IT Gift > Cards Purchase" localeString="en"/> > > - <ProductCategoryContent productCategoryId="GC-101" > contentId="CGC-101DESC" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > + <ProductCategoryContent productCategoryId="GC-101" > contentId="CGC-101DESCEN" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="CGC-101DESC" > contentIdTo="CGC-101DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > - <ContentAssoc contentId="CGC-101DESC" > contentIdTo="CGC-101DESCEN" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > + <ContentAssoc contentId="CGC-101DESCEN" > contentIdTo="CGC-101DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > + <ContentAssoc contentId="CGC-101DESCEN" > contentIdTo="CGC-101DESCFR" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > > <!-- Gift Cards Reload category --> > <DataResource dataResourceId="DRGC-102DESCFR" > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > @@ -222,14 +222,14 @@ > <ElectronicText dataResourceId="DRGC-102DESCIT" > textData="Ricaricano di carte regalo"/> > <ElectronicText dataResourceId="DRGC-102DESCEN" textData="Gift > Cards Reload"/> > > - <Content contentId="CGC-102DESC" contentTypeId="DOCUMENT" > dataResourceId="DRGC-102DESCFR" description="DESCRIPTION FR > Rechargement de cartes cadeau" localeString="fr" /> > + <Content contentId="CGC-102DESCFR" contentTypeId="DOCUMENT" > dataResourceId="DRGC-102DESCFR" description="DESCRIPTION FR > Rechargement de cartes cadeau" localeString="fr" /> > <Content contentId="CGC-102DESCIT" contentTypeId="DOCUMENT" > dataResourceId="DRGC-102DESCIT" description="DESCRIPTION IT > Ricaricano di carte regalo" localeString="it" /> > <Content contentId="CGC-102DESCEN" contentTypeId="DOCUMENT" > dataResourceId="DRGC-102DESCEN" description="DESCRIPTION EN Gift > Cards Reload" localeString="en"/> > > - <ProductCategoryContent productCategoryId="GC-102" > contentId="CGC-102DESC" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > + <ProductCategoryContent productCategoryId="GC-102" > contentId="CGC-102DESCEN" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="CGC-102DESC" > contentIdTo="CGC-102DESCEN" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > - <ContentAssoc contentId="CGC-102DESC" > contentIdTo="CGC-102DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > + <ContentAssoc contentId="CGC-102DESCEN" > contentIdTo="CGC-102DESCFR" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > + <ContentAssoc contentId="CGC-102DESCEN" > contentIdTo="CGC-102DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > > <!-- Configurables PCs category --> > <DataResource dataResourceId="DRPC-100DESCFR" > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > @@ -240,13 +240,13 @@ > <ElectronicText dataResourceId="DRPC-100DESCIT" > textData="Computer configurabili"/> > <ElectronicText dataResourceId="DRPC-100DESCEN" > textData="Configurables PCs"/> > > - <Content contentId="CPC-100DESC" contentTypeId="DOCUMENT" > dataResourceId="DRPC-100DESCFR" description="DESCRIPTION FR PC > configurables" localeString="fr" /> > + <Content contentId="CPC-100DESCFR" contentTypeId="DOCUMENT" > dataResourceId="DRPC-100DESCFR" description="DESCRIPTION FR PC > configurables" localeString="fr" /> > <Content contentId="CPC-100DESCIT" contentTypeId="DOCUMENT" > dataResourceId="DRPC-100DESCIT" description="DESCRIPTION IT > Computer configurabili" localeString="it" /> > <Content contentId="CPC-100DESCEN" contentTypeId="DOCUMENT" > dataResourceId="DRPC-100DESCEN" description="DESCRIPTION EN > Configurables PCs" localeString="en"/> > > - <ProductCategoryContent productCategoryId="PC-100" > contentId="CPC-100DESC" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > + <ProductCategoryContent productCategoryId="PC-100" > contentId="CPC-100DESCEN" prodCatContentTypeId="DESCRIPTION" > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="CPC-100DESC" > contentIdTo="CPC-100DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > - <ContentAssoc contentId="CPC-100DESC" > contentIdTo="CPC-100DESCEN" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > + <ContentAssoc contentId="CPC-100DESCEN" > contentIdTo="CPC-100DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > + <ContentAssoc contentId="CPC-100DESCEN" > contentIdTo="CPC-100DESCFR" contentAssocTypeId="ALTERNATE_LOCALE" > fromDate="2006-09-22 00:00:00.0"/> > > </entity-engine-xml> > Best Regards, Si [hidden email] |
Administrator
|
I'm not sure because as David already explained there are 2 ways for this.
Quick one : std description field Longuer one : std description field overidden by data source content (this implies a default locale that seems ok now) And IIRW David seemed to keep std description field because it's quicker. Actually, if we do according to your proposition is the DB description field always needed ? And if we go in this direction maybe some DB refactoring have to be thought about ? Jacques From: "Si Chen" <[hidden email]> > So should we remove the description field from these ProductCategory > in the demo data? I think so, or how would one be able to see the > alternate locale description? > > Begin forwarded message: > > > From: [hidden email] > > Date: November 9, 2006 1:05:49 PM PST > > To: [hidden email] > > Subject: svn commit: r473073 - /incubator/ofbiz/trunk/applications/ > > ecommerce/data/DemoProductCategoriesI18nData.xml > > Reply-To: [hidden email] > > > > Author: jleroux > > Date: Thu Nov 9 13:05:48 2006 > > New Revision: 473073 > > > > URL: http://svn.apache.org/viewvc?view=rev&rev=473073 > > Log: > > Primary categories content locale now default to english (was french) > > > > Modified: > > incubator/ofbiz/trunk/applications/ecommerce/data/ > > DemoProductCategoriesI18nData.xml > > > > Modified: incubator/ofbiz/trunk/applications/ecommerce/data/ > > DemoProductCategoriesI18nData.xml > > URL: http://svn.apache.org/viewvc/incubator/ofbiz/trunk/ > > applications/ecommerce/data/DemoProductCategoriesI18nData.xml? > > view=diff&rev=473073&r1=473072&r2=473073 > > ====================================================================== > > ======== > > --- incubator/ofbiz/trunk/applications/ecommerce/data/ > > DemoProductCategoriesI18nData.xml (original) > > +++ incubator/ofbiz/trunk/applications/ecommerce/data/ > > DemoProductCategoriesI18nData.xml Thu Nov 9 13:05:48 2006 > > @@ -24,14 +24,14 @@ > > <ElectronicText dataResourceId="DR100DESCIT" textData="Gizmos > > it"/> > > <ElectronicText dataResourceId="DR100DESCEN" textData="Gizmos > > en"/> > > > > - <Content contentId="C100DESC" contentTypeId="DOCUMENT" > > dataResourceId="DR100DESCFR" description="DESCRIPTION FR Gizmos" > > localeString="fr" /> > > + <Content contentId="C100DESCFR" contentTypeId="DOCUMENT" > > dataResourceId="DR100DESCFR" description="DESCRIPTION FR Gizmos" > > localeString="fr" /> > > <Content contentId="C100DESCIT" contentTypeId="DOCUMENT" > > dataResourceId="DR100DESCIT" description="DESCRIPTION IT Gizmos" > > localeString="it" /> > > <Content contentId="C100DESCEN" contentTypeId="DOCUMENT" > > dataResourceId="DR100DESCEN" description="DESCRIPTION EN Gizmos" > > localeString="en"/> > > > > - <ProductCategoryContent productCategoryId="100" > > contentId="C100DESC" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ProductCategoryContent productCategoryId="100" > > contentId="C100DESCEN" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > > > - <ContentAssoc contentId="C100DESC" contentIdTo="C100DESCIT" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > - <ContentAssoc contentId="C100DESC" contentIdTo="C100DESCEN" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > + <ContentAssoc contentId="C100DESCEN" contentIdTo="C100DESCIT" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > + <ContentAssoc contentId="C100DESCEN" contentIdTo="C100DESCFR" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > > > <!-- Small Gizmos category --> > > <DataResource dataResourceId="DR101DESCFR" > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > > @@ -42,14 +42,14 @@ > > <ElectronicText dataResourceId="DR101DESCIT" textData="Piccolo > > Gizmos"/> > > <ElectronicText dataResourceId="DR101DESCEN" textData="Small > > Gizmos"/> > > > > - <Content contentId="C101DESC" contentTypeId="DOCUMENT" > > dataResourceId="DR101DESCFR" description="DESCRIPTION FR Petits > > Gizmos" localeString="fr" /> > > + <Content contentId="C101DESCFR" contentTypeId="DOCUMENT" > > dataResourceId="DR101DESCFR" description="DESCRIPTION FR Petits > > Gizmos" localeString="fr" /> > > <Content contentId="C101DESCIT" contentTypeId="DOCUMENT" > > dataResourceId="DR101DESCIT" description="DESCRIPTION IT Piccolo > > Gizmos" localeString="it" /> > > <Content contentId="C101DESCEN" contentTypeId="DOCUMENT" > > dataResourceId="DR101DESCEN" description="DESCRIPTION EN Small > > Gizmos" localeString="en"/> > > > > - <ProductCategoryContent productCategoryId="101" > > contentId="C101DESC" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ProductCategoryContent productCategoryId="101" > > contentId="C101DESCEN" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > > > - <ContentAssoc contentId="C101DESC" contentIdTo="C101DESCEN" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > - <ContentAssoc contentId="C101DESC" contentIdTo="C101DESCIT" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > + <ContentAssoc contentId="C101DESCEN" contentIdTo="C101DESCFR" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > + <ContentAssoc contentId="C101DESCEN" contentIdTo="C101DESCIT" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > > > <!-- Large Gizmos category --> > > <DataResource dataResourceId="DR102DESCFR" > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > > @@ -60,14 +60,14 @@ > > <ElectronicText dataResourceId="DR102DESCIT" textData="Grande > > Gizmos"/> > > <ElectronicText dataResourceId="DR102DESCEN" textData="Large > > Gizmos"/> > > > > - <Content contentId="C102DESC" contentTypeId="DOCUMENT" > > dataResourceId="DR102DESCFR" description="DESCRIPTION FR Grands > > Gizmos" localeString="fr" /> > > + <Content contentId="C102DESCFR" contentTypeId="DOCUMENT" > > dataResourceId="DR102DESCFR" description="DESCRIPTION FR Grands > > Gizmos" localeString="fr" /> > > <Content contentId="C102DESCIT" contentTypeId="DOCUMENT" > > dataResourceId="DR102DESCIT" description="DESCRIPTION IT Grande > > Gizmos" localeString="it" /> > > <Content contentId="C102DESCEN" contentTypeId="DOCUMENT" > > dataResourceId="DR102DESCEN" description="DESCRIPTION IT Large > > Gizmos" localeString="en"/> > > > > - <ProductCategoryContent productCategoryId="102" > > contentId="C102DESC" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ProductCategoryContent productCategoryId="102" > > contentId="C102DESCEN" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > > > - <ContentAssoc contentId="C102DESC" contentIdTo="C102DESCIT" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > - <ContentAssoc contentId="C102DESC" contentIdTo="C102DESCEN" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > + <ContentAssoc contentId="C102DESCEN" contentIdTo="C102DESCIT" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > + <ContentAssoc contentId="C102DESCEN" contentIdTo="C102DESCFR" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > > > <!-- Widgets category --> > > <DataResource dataResourceId="DR200DESCFR" > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > > @@ -78,14 +78,14 @@ > > <ElectronicText dataResourceId="DR200DESCIT" textData="Widgets > > it"/> > > <ElectronicText dataResourceId="DR200DESCEN" textData="Widgets > > en"/> > > > > - <Content contentId="C200DESC" contentTypeId="DOCUMENT" > > dataResourceId="DR200DESCFR" description="DESCRIPTION FR Gizmos" > > localeString="fr" /> > > + <Content contentId="C200DESCFR" contentTypeId="DOCUMENT" > > dataResourceId="DR200DESCFR" description="DESCRIPTION FR Gizmos" > > localeString="fr" /> > > <Content contentId="C200DESCIT" contentTypeId="DOCUMENT" > > dataResourceId="DR200DESCIT" description="DESCRIPTION IT Gizmos" > > localeString="it" /> > > <Content contentId="C200DESCEN" contentTypeId="DOCUMENT" > > dataResourceId="DR200DESCEN" description="DESCRIPTION EN Gizmos" > > localeString="en"/> > > > > - <ProductCategoryContent productCategoryId="200" > > contentId="C200DESC" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ProductCategoryContent productCategoryId="200" > > contentId="C200DESCEN" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > > > - <ContentAssoc contentId="C200DESC" contentIdTo="C200DESCIT" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > - <ContentAssoc contentId="C200DESC" contentIdTo="C200DESCEN" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > + <ContentAssoc contentId="C200DESCEN" contentIdTo="C200DESCIT" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > + <ContentAssoc contentId="C200DESCEN" contentIdTo="C200DESCFR" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > > > <!-- Small Widgets category --> > > <DataResource dataResourceId="DR201DESCFR" > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > > @@ -96,14 +96,14 @@ > > <ElectronicText dataResourceId="DR201DESCIT" textData="Piccolo > > Widgets"/> > > <ElectronicText dataResourceId="DR201DESCEN" textData="Small > > Widgets"/> > > > > - <Content contentId="C201DESC" contentTypeId="DOCUMENT" > > dataResourceId="DR201DESCFR" description="DESCRIPTION FR Petits > > Widgets" localeString="fr" /> > > + <Content contentId="C201DESCFR" contentTypeId="DOCUMENT" > > dataResourceId="DR201DESCFR" description="DESCRIPTION FR Petits > > Widgets" localeString="fr" /> > > <Content contentId="C201DESCIT" contentTypeId="DOCUMENT" > > dataResourceId="DR201DESCIT" description="DESCRIPTION IT Piccolo > > Widgets" localeString="it" /> > > <Content contentId="C201DESCEN" contentTypeId="DOCUMENT" > > dataResourceId="DR201DESCEN" description="DESCRIPTION EN Small > > Widgets" localeString="en"/> > > > > - <ProductCategoryContent productCategoryId="201" > > contentId="C201DESC" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ProductCategoryContent productCategoryId="201" > > contentId="C201DESCEN" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > > > - <ContentAssoc contentId="C201DESC" contentIdTo="C201DESCEN" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > - <ContentAssoc contentId="C201DESC" contentIdTo="C201DESCIT" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > + <ContentAssoc contentId="C201DESCEN" contentIdTo="C201DESCFR" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > + <ContentAssoc contentId="C201DESCEN" contentIdTo="C201DESCIT" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > > > <!-- Other Mini Widgets category --> > > <DataResource dataResourceId="DR2012DESCFR" > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > > @@ -114,14 +114,14 @@ > > <ElectronicText dataResourceId="DR2012DESCIT" textData="Altro > > Mini Widgets"/> > > <ElectronicText dataResourceId="DR2012DESCEN" textData="Other > > Mini Widgets"/> > > > > - <Content contentId="C2012DESC" contentTypeId="DOCUMENT" > > dataResourceId="DR2012DESCFR" description="DESCRIPTION FR Autre > > Mini Widgets" localeString="fr" /> > > + <Content contentId="C2012DESCFR" contentTypeId="DOCUMENT" > > dataResourceId="DR2012DESCFR" description="DESCRIPTION FR Autre > > Mini Widgets" localeString="fr" /> > > <Content contentId="C2012DESCIT" contentTypeId="DOCUMENT" > > dataResourceId="DR2012DESCIT" description="DESCRIPTION IT Altro > > Piccolo Widgets" localeString="it" /> > > <Content contentId="C2012DESCEN" contentTypeId="DOCUMENT" > > dataResourceId="DR2012DESCEN" description="DESCRIPTION EN Other > > Mini Widgets" localeString="en"/> > > > > - <ProductCategoryContent productCategoryId="2012" > > contentId="C2012DESC" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ProductCategoryContent productCategoryId="2012" > > contentId="C2012DESCEN" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > > > - <ContentAssoc contentId="C2012DESC" contentIdTo="C2012DESCEN" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > - <ContentAssoc contentId="C2012DESC" contentIdTo="C2012DESCIT" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > + <ContentAssoc contentId="C2012DESCEN" > > contentIdTo="C2012DESCFR" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ContentAssoc contentId="C2012DESCEN" > > contentIdTo="C2012DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > > > <!-- Mini Widgets category --> > > <DataResource dataResourceId="DR2011DESCFR" > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > > @@ -132,14 +132,14 @@ > > <ElectronicText dataResourceId="DR2011DESCIT" textData="Mini > > Widgets it"/> > > <ElectronicText dataResourceId="DR2011DESCEN" textData="Mini > > Widgets en"/> > > > > - <Content contentId="C2011DESC" contentTypeId="DOCUMENT" > > dataResourceId="DR2011DESCFR" description="DESCRIPTION FR Mini > > Widgets" localeString="fr" /> > > + <Content contentId="C2011DESCFR" contentTypeId="DOCUMENT" > > dataResourceId="DR2011DESCFR" description="DESCRIPTION FR Mini > > Widgets" localeString="fr" /> > > <Content contentId="C2011DESCIT" contentTypeId="DOCUMENT" > > dataResourceId="DR2011DESCIT" description="DESCRIPTION IT Mini > > Widgets" localeString="it" /> > > <Content contentId="C2011DESCEN" contentTypeId="DOCUMENT" > > dataResourceId="DR2011DESCEN" description="DESCRIPTION EN Mini > > Widgets" localeString="en"/> > > > > - <ProductCategoryContent productCategoryId="2011" > > contentId="C2011DESC" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ProductCategoryContent productCategoryId="2011" > > contentId="C2011DESCEN" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > > > - <ContentAssoc contentId="C2011DESC" contentIdTo="C2011DESCEN" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > - <ContentAssoc contentId="C2011DESC" contentIdTo="C2011DESCIT" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > + <ContentAssoc contentId="C2011DESCEN" > > contentIdTo="C2011DESCFR" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ContentAssoc contentId="C2011DESCEN" > > contentIdTo="C2011DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > > > <!-- Micro Widgets category --> > > <DataResource dataResourceId="DR20111DESCFR" > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > > @@ -150,14 +150,14 @@ > > <ElectronicText dataResourceId="DR20111DESCIT" textData="Micro > > Widgets it"/> > > <ElectronicText dataResourceId="DR20111DESCEN" textData="Micro > > Widgets en"/> > > > > - <Content contentId="C20111DESC" contentTypeId="DOCUMENT" > > dataResourceId="DR20111DESCFR" description="DESCRIPTION FR Micro > > Widgets" localeString="fr" /> > > + <Content contentId="C20111DESCFR" contentTypeId="DOCUMENT" > > dataResourceId="DR20111DESCFR" description="DESCRIPTION FR Micro > > Widgets" localeString="fr" /> > > <Content contentId="C20111DESCIT" contentTypeId="DOCUMENT" > > dataResourceId="DR20111DESCIT" description="DESCRIPTION IT Micro > > Widgets" localeString="it" /> > > <Content contentId="C20111DESCEN" contentTypeId="DOCUMENT" > > dataResourceId="DR20111DESCEN" description="DESCRIPTION EN Micro > > Widgets" localeString="en"/> > > > > - <ProductCategoryContent productCategoryId="20111" > > contentId="C20111DESC" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ProductCategoryContent productCategoryId="20111" > > contentId="C20111DESCEN" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > > > - <ContentAssoc contentId="C20111DESC" > > contentIdTo="C20111DESCEN" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="C20111DESC" > > contentIdTo="C20111DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ContentAssoc contentId="C20111DESCEN" > > contentIdTo="C20111DESCFR" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ContentAssoc contentId="C20111DESCEN" > > contentIdTo="C20111DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > > > <!-- Large Widgets category --> > > <DataResource dataResourceId="DR202DESCFR" > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > > @@ -168,14 +168,14 @@ > > <ElectronicText dataResourceId="DR202DESCIT" textData="Grande > > Widgets"/> > > <ElectronicText dataResourceId="DR202DESCEN" textData="Large > > Widgets"/> > > > > - <Content contentId="C202DESC" contentTypeId="DOCUMENT" > > dataResourceId="DR202DESCFR" description="DESCRIPTION FR Grands > > Widgets" localeString="fr" /> > > + <Content contentId="C202DESCFR" contentTypeId="DOCUMENT" > > dataResourceId="DR202DESCFR" description="DESCRIPTION FR Grands > > Widgets" localeString="fr" /> > > <Content contentId="C202DESCIT" contentTypeId="DOCUMENT" > > dataResourceId="DR202DESCIT" description="DESCRIPTION IT Grande > > Widgets" localeString="it" /> > > <Content contentId="C202DESCEN" contentTypeId="DOCUMENT" > > dataResourceId="DR202DESCEN" description="DESCRIPTION IT Large > > Widgets" localeString="en"/> > > > > - <ProductCategoryContent productCategoryId="202" > > contentId="C202DESC" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ProductCategoryContent productCategoryId="202" > > contentId="C202DESCEN" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > > > - <ContentAssoc contentId="C202DESC" contentIdTo="C202DESCIT" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > - <ContentAssoc contentId="C202DESC" contentIdTo="C202DESCEN" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > + <ContentAssoc contentId="C202DESCEN" contentIdTo="C202DESCIT" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > + <ContentAssoc contentId="C202DESCEN" contentIdTo="C202DESCFR" > > contentAssocTypeId="ALTERNATE_LOCALE" fromDate="2006-09-22 > > 00:00:00.0"/> > > > > <!-- Gift Cards category --> > > <DataResource dataResourceId="DRGC-100DESCFR" > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > > @@ -186,14 +186,14 @@ > > <ElectronicText dataResourceId="DRGC-100DESCIT" > > textData="Carte regalo"/> > > <ElectronicText dataResourceId="DRGC-100DESCEN" textData="Gift > > Cards"/> > > > > - <Content contentId="CGC-100DESC" contentTypeId="DOCUMENT" > > dataResourceId="DRGC-100DESCFR" description="DESCRIPTION FR Cartes > > cadeau" localeString="fr" /> > > + <Content contentId="CGC-100DESCFR" contentTypeId="DOCUMENT" > > dataResourceId="DRGC-100DESCFR" description="DESCRIPTION FR Cartes > > cadeau" localeString="fr" /> > > <Content contentId="CGC-100DESCIT" contentTypeId="DOCUMENT" > > dataResourceId="DRGC-100DESCIT" description="DESCRIPTION IT Carte > > regalo" localeString="it" /> > > <Content contentId="CGC-100DESCEN" contentTypeId="DOCUMENT" > > dataResourceId="DRGC-100DESCEN" description="DESCRIPTION EN Gift > > Cards" localeString="en"/> > > > > - <ProductCategoryContent productCategoryId="GC-100" > > contentId="CGC-100DESC" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ProductCategoryContent productCategoryId="GC-100" > > contentId="CGC-100DESCEN" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > > > - <ContentAssoc contentId="CGC-100DESC" > > contentIdTo="CGC-100DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="CGC-100DESC" > > contentIdTo="CGC-100DESCEN" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ContentAssoc contentId="CGC-100DESCEN" > > contentIdTo="CGC-100DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ContentAssoc contentId="CGC-100DESCEN" > > contentIdTo="CGC-100DESCFR" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > > > <!-- Gift Cards Purchase category --> > > <DataResource dataResourceId="DRGC-101DESCFR" > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > > @@ -204,14 +204,14 @@ > > <ElectronicText dataResourceId="DRGC-101DESCIT" > > textData="Acquisto di carta regalo"/> > > <ElectronicText dataResourceId="DRGC-101DESCEN" textData="Gift > > Cards Purchase"/> > > > > - <Content contentId="CGC-101DESC" contentTypeId="DOCUMENT" > > dataResourceId="DRGC-101DESCFR" description="DESCRIPTION FR Achat > > de carte cadeau" localeString="fr" /> > > + <Content contentId="CGC-101DESCFR" contentTypeId="DOCUMENT" > > dataResourceId="DRGC-101DESCFR" description="DESCRIPTION FR Achat > > de carte cadeau" localeString="fr" /> > > <Content contentId="CGC-101DESCIT" contentTypeId="DOCUMENT" > > dataResourceId="DRGC-101DESCIT" description="DESCRIPTION IT > > Acquisto di carta regalo" localeString="it" /> > > <Content contentId="CGC-101DESCEN" contentTypeId="DOCUMENT" > > dataResourceId="DRGC-101DESCEN" description="DESCRIPTION IT Gift > > Cards Purchase" localeString="en"/> > > > > - <ProductCategoryContent productCategoryId="GC-101" > > contentId="CGC-101DESC" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ProductCategoryContent productCategoryId="GC-101" > > contentId="CGC-101DESCEN" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > > > - <ContentAssoc contentId="CGC-101DESC" > > contentIdTo="CGC-101DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="CGC-101DESC" > > contentIdTo="CGC-101DESCEN" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ContentAssoc contentId="CGC-101DESCEN" > > contentIdTo="CGC-101DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ContentAssoc contentId="CGC-101DESCEN" > > contentIdTo="CGC-101DESCFR" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > > > <!-- Gift Cards Reload category --> > > <DataResource dataResourceId="DRGC-102DESCFR" > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > > @@ -222,14 +222,14 @@ > > <ElectronicText dataResourceId="DRGC-102DESCIT" > > textData="Ricaricano di carte regalo"/> > > <ElectronicText dataResourceId="DRGC-102DESCEN" textData="Gift > > Cards Reload"/> > > > > - <Content contentId="CGC-102DESC" contentTypeId="DOCUMENT" > > dataResourceId="DRGC-102DESCFR" description="DESCRIPTION FR > > Rechargement de cartes cadeau" localeString="fr" /> > > + <Content contentId="CGC-102DESCFR" contentTypeId="DOCUMENT" > > dataResourceId="DRGC-102DESCFR" description="DESCRIPTION FR > > Rechargement de cartes cadeau" localeString="fr" /> > > <Content contentId="CGC-102DESCIT" contentTypeId="DOCUMENT" > > dataResourceId="DRGC-102DESCIT" description="DESCRIPTION IT > > Ricaricano di carte regalo" localeString="it" /> > > <Content contentId="CGC-102DESCEN" contentTypeId="DOCUMENT" > > dataResourceId="DRGC-102DESCEN" description="DESCRIPTION EN Gift > > Cards Reload" localeString="en"/> > > > > - <ProductCategoryContent productCategoryId="GC-102" > > contentId="CGC-102DESC" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ProductCategoryContent productCategoryId="GC-102" > > contentId="CGC-102DESCEN" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > > > - <ContentAssoc contentId="CGC-102DESC" > > contentIdTo="CGC-102DESCEN" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="CGC-102DESC" > > contentIdTo="CGC-102DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ContentAssoc contentId="CGC-102DESCEN" > > contentIdTo="CGC-102DESCFR" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ContentAssoc contentId="CGC-102DESCEN" > > contentIdTo="CGC-102DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > > > <!-- Configurables PCs category --> > > <DataResource dataResourceId="DRPC-100DESCFR" > > dataResourceTypeId="ELECTRONIC_TEXT" localeString="fr"/> > > @@ -240,13 +240,13 @@ > > <ElectronicText dataResourceId="DRPC-100DESCIT" > > textData="Computer configurabili"/> > > <ElectronicText dataResourceId="DRPC-100DESCEN" > > textData="Configurables PCs"/> > > > > - <Content contentId="CPC-100DESC" contentTypeId="DOCUMENT" > > dataResourceId="DRPC-100DESCFR" description="DESCRIPTION FR PC > > configurables" localeString="fr" /> > > + <Content contentId="CPC-100DESCFR" contentTypeId="DOCUMENT" > > dataResourceId="DRPC-100DESCFR" description="DESCRIPTION FR PC > > configurables" localeString="fr" /> > > <Content contentId="CPC-100DESCIT" contentTypeId="DOCUMENT" > > dataResourceId="DRPC-100DESCIT" description="DESCRIPTION IT > > Computer configurabili" localeString="it" /> > > <Content contentId="CPC-100DESCEN" contentTypeId="DOCUMENT" > > dataResourceId="DRPC-100DESCEN" description="DESCRIPTION EN > > Configurables PCs" localeString="en"/> > > > > - <ProductCategoryContent productCategoryId="PC-100" > > contentId="CPC-100DESC" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ProductCategoryContent productCategoryId="PC-100" > > contentId="CPC-100DESCEN" prodCatContentTypeId="DESCRIPTION" > > fromDate="2006-09-22 00:00:00.0"/> > > > > - <ContentAssoc contentId="CPC-100DESC" > > contentIdTo="CPC-100DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > - <ContentAssoc contentId="CPC-100DESC" > > contentIdTo="CPC-100DESCEN" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ContentAssoc contentId="CPC-100DESCEN" > > contentIdTo="CPC-100DESCIT" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > + <ContentAssoc contentId="CPC-100DESCEN" > > contentIdTo="CPC-100DESCFR" contentAssocTypeId="ALTERNATE_LOCALE" > > fromDate="2006-09-22 00:00:00.0"/> > > > > </entity-engine-xml> > > > > Best Regards, > > Si > [hidden email] > > > > |
For "demo" data, the performance doesn't matter as much. Better to demonstrate and test, at least with one of the fields. -David On Nov 10, 2006, at 1:12 PM, Jacques Le Roux wrote: > I'm not sure because as David already explained there are 2 ways > for this. > Quick one : std description field > Longuer one : std description field overidden by data source > content (this implies a default locale that seems ok now) > > And IIRW David seemed to keep std description field because it's > quicker. > Actually, if we do according to your proposition is the DB > description field always needed ? > And if we go in this direction maybe some DB refactoring have to be > thought about ? > > Jacques > > From: "Si Chen" <[hidden email]> >> So should we remove the description field from these ProductCategory >> in the demo data? I think so, or how would one be able to see the >> alternate locale description? |
Administrator
|
David,
OK, and what about the DB description field always needed and some DB refactoring that this (and more eventually) may imply ? Jacques From: "David E Jones" <[hidden email]> > > For "demo" data, the performance doesn't matter as much. Better to > demonstrate and test, at least with one of the fields. > > -David > > > On Nov 10, 2006, at 1:12 PM, Jacques Le Roux wrote: > > > I'm not sure because as David already explained there are 2 ways > > for this. > > Quick one : std description field > > Longuer one : std description field overidden by data source > > content (this implies a default locale that seems ok now) > > > > And IIRW David seemed to keep std description field because it's > > quicker. > > Actually, if we do according to your proposition is the DB > > description field always needed ? > > And if we go in this direction maybe some DB refactoring have to be > > thought about ? > > > > Jacques > > > > From: "Si Chen" <[hidden email]> > >> So should we remove the description field from these ProductCategory > >> in the demo data? I think so, or how would one be able to see the > >> alternate locale description? |
Jacques, Sorry, you lost me. What is the "DB description" field, and what refactoring and such would this imply? -David On Nov 10, 2006, at 1:53 PM, Jacques Le Roux wrote: > David, > > OK, and what about the DB description field always needed and some > DB refactoring that this (and more eventually) may imply ? > > Jacques > > > From: "David E Jones" <[hidden email]> >> >> For "demo" data, the performance doesn't matter as much. Better to >> demonstrate and test, at least with one of the fields. >> >> -David >> >> >> On Nov 10, 2006, at 1:12 PM, Jacques Le Roux wrote: >> >>> I'm not sure because as David already explained there are 2 ways >>> for this. >>> Quick one : std description field >>> Longuer one : std description field overidden by data source >>> content (this implies a default locale that seems ok now) >>> >>> And IIRW David seemed to keep std description field because it's >>> quicker. >>> Actually, if we do according to your proposition is the DB >>> description field always needed ? >>> And if we go in this direction maybe some DB refactoring have to be >>> thought about ? >>> >>> Jacques >>> >>> From: "Si Chen" <[hidden email]> >>>> So should we remove the description field from these >>>> ProductCategory >>>> in the demo data? I think so, or how would one be able to see the >>>> alternate locale description? |
Administrator
|
David,
Forget it, I was thinking that we may not use anymore the category description field, but I guess it's needed if we want to keep things fast. So Si, it seems that if you want to remove the description field from demo ProductCategory data it's ok, isn'it ? Jacques > > Jacques, > > Sorry, you lost me. What is the "DB description" field, and what > refactoring and such would this imply? > > -David > > > On Nov 10, 2006, at 1:53 PM, Jacques Le Roux wrote: > > > David, > > > > OK, and what about the DB description field always needed and some > > DB refactoring that this (and more eventually) may imply ? > > > > Jacques > > > > > > From: "David E Jones" <[hidden email]> > >> > >> For "demo" data, the performance doesn't matter as much. Better to > >> demonstrate and test, at least with one of the fields. > >> > >> -David > >> > >> > >> On Nov 10, 2006, at 1:12 PM, Jacques Le Roux wrote: > >> > >>> I'm not sure because as David already explained there are 2 ways > >>> for this. > >>> Quick one : std description field > >>> Longuer one : std description field overidden by data source > >>> content (this implies a default locale that seems ok now) > >>> > >>> And IIRW David seemed to keep std description field because it's > >>> quicker. > >>> Actually, if we do according to your proposition is the DB > >>> description field always needed ? > >>> And if we go in this direction maybe some DB refactoring have to be > >>> thought about ? > >>> > >>> Jacques > >>> > >>> From: "Si Chen" <[hidden email]> > >>>> So should we remove the description field from these > >>>> ProductCategory > >>>> in the demo data? I think so, or how would one be able to see the > >>>> alternate locale description? |
Yes, let's do that so the demo data would allow people to see the
i18n of product categories. On Nov 10, 2006, at 2:28 PM, Jacques Le Roux wrote: > David, > > Forget it, I was thinking that we may not use anymore the category > description field, but I guess it's needed if we want to keep > things fast. > > So Si, it seems that if you want to remove the description field > from demo ProductCategory data it's ok, isn'it ? > > Jacques > >> >> Jacques, >> >> Sorry, you lost me. What is the "DB description" field, and what >> refactoring and such would this imply? >> >> -David >> >> >> On Nov 10, 2006, at 1:53 PM, Jacques Le Roux wrote: >> >>> David, >>> >>> OK, and what about the DB description field always needed and some >>> DB refactoring that this (and more eventually) may imply ? >>> >>> Jacques >>> >>> >>> From: "David E Jones" <[hidden email]> >>>> >>>> For "demo" data, the performance doesn't matter as much. Better to >>>> demonstrate and test, at least with one of the fields. >>>> >>>> -David >>>> >>>> >>>> On Nov 10, 2006, at 1:12 PM, Jacques Le Roux wrote: >>>> >>>>> I'm not sure because as David already explained there are 2 ways >>>>> for this. >>>>> Quick one : std description field >>>>> Longuer one : std description field overidden by data source >>>>> content (this implies a default locale that seems ok now) >>>>> >>>>> And IIRW David seemed to keep std description field because it's >>>>> quicker. >>>>> Actually, if we do according to your proposition is the DB >>>>> description field always needed ? >>>>> And if we go in this direction maybe some DB refactoring have >>>>> to be >>>>> thought about ? >>>>> >>>>> Jacques >>>>> >>>>> From: "Si Chen" <[hidden email]> >>>>>> So should we remove the description field from these >>>>>> ProductCategory >>>>>> in the demo data? I think so, or how would one be able to see >>>>>> the >>>>>> alternate locale description? Best Regards, Si [hidden email] |
Administrator
|
Only in french and italian right now, easy to improve though...
Next I will work on catalog, do you see any others places needing this ? I let you do the job Si ? Jacques From: "Si Chen" <[hidden email]> > Yes, let's do that so the demo data would allow people to see the > i18n of product categories. > > On Nov 10, 2006, at 2:28 PM, Jacques Le Roux wrote: > > > David, > > > > Forget it, I was thinking that we may not use anymore the category > > description field, but I guess it's needed if we want to keep > > things fast. > > > > So Si, it seems that if you want to remove the description field > > from demo ProductCategory data it's ok, isn'it ? > > > > Jacques > > > >> > >> Jacques, > >> > >> Sorry, you lost me. What is the "DB description" field, and what > >> refactoring and such would this imply? > >> > >> -David > >> > >> > >> On Nov 10, 2006, at 1:53 PM, Jacques Le Roux wrote: > >> > >>> David, > >>> > >>> OK, and what about the DB description field always needed and some > >>> DB refactoring that this (and more eventually) may imply ? > >>> > >>> Jacques > >>> > >>> > >>> From: "David E Jones" <[hidden email]> > >>>> > >>>> For "demo" data, the performance doesn't matter as much. Better to > >>>> demonstrate and test, at least with one of the fields. > >>>> > >>>> -David > >>>> > >>>> > >>>> On Nov 10, 2006, at 1:12 PM, Jacques Le Roux wrote: > >>>> > >>>>> I'm not sure because as David already explained there are 2 ways > >>>>> for this. > >>>>> Quick one : std description field > >>>>> Longuer one : std description field overidden by data source > >>>>> content (this implies a default locale that seems ok now) > >>>>> > >>>>> And IIRW David seemed to keep std description field because it's > >>>>> quicker. > >>>>> Actually, if we do according to your proposition is the DB > >>>>> description field always needed ? > >>>>> And if we go in this direction maybe some DB refactoring have > >>>>> to be > >>>>> thought about ? > >>>>> > >>>>> Jacques > >>>>> > >>>>> From: "Si Chen" <[hidden email]> > >>>>>> So should we remove the description field from these > >>>>>> ProductCategory > >>>>>> in the demo data? I think so, or how would one be able to see > >>>>>> the > >>>>>> alternate locale description? > > Best Regards, > > Si > [hidden email] > > > > |
In reply to this post by Jacques Le Roux
I'm curious as to how much of a performance hit it
would be to create a view entity between product and each langauge (ie ProductViewEN, ProductViewES, ProductViewFR, ProductViewIT) using a complex alias for this. This would have the benefit of being able to i18n more than just the description and also perhaps jump start the normalization of the Product entity that was discussed a few months back so that you don't have the overflow of fields that don't make sense to the product type (ie the rental fields for sale products, the product dimension fields for electronic products, etc) --- Jacques Le Roux <[hidden email]> wrote: > David, > > Forget it, I was thinking that we may not use > anymore the category description field, but I guess > it's needed if we want to keep > things fast. > > So Si, it seems that if you want to remove the > description field from demo ProductCategory data > it's ok, isn'it ? > > Jacques > > > > > Jacques, > > > > Sorry, you lost me. What is the "DB description" > field, and what > > refactoring and such would this imply? > > > > -David > > > > > > On Nov 10, 2006, at 1:53 PM, Jacques Le Roux > wrote: > > > > > David, > > > > > > OK, and what about the DB description field > always needed and some > > > DB refactoring that this (and more eventually) > may imply ? > > > > > > Jacques > > > > > > > > > From: "David E Jones" > <[hidden email]> > > >> > > >> For "demo" data, the performance doesn't matter > as much. Better to > > >> demonstrate and test, at least with one of the > fields. > > >> > > >> -David > > >> > > >> > > >> On Nov 10, 2006, at 1:12 PM, Jacques Le Roux > wrote: > > >> > > >>> I'm not sure because as David already > explained there are 2 ways > > >>> for this. > > >>> Quick one : std description field > > >>> Longuer one : std description field overidden > by data source > > >>> content (this implies a default locale that > seems ok now) > > >>> > > >>> And IIRW David seemed to keep std description > field because it's > > >>> quicker. > > >>> Actually, if we do according to your > proposition is the DB > > >>> description field always needed ? > > >>> And if we go in this direction maybe some DB > refactoring have to be > > >>> thought about ? > > >>> > > >>> Jacques > > >>> > > >>> From: "Si Chen" > <[hidden email]> > > >>>> So should we remove the description field > from these > > >>>> ProductCategory > > >>>> in the demo data? I think so, or how would > one be able to see the > > >>>> alternate locale description? > > |
In reply to this post by Jacques Le Roux
actually if you could do it it'd be great--i'm sorry i might not get
to it for a while On Nov 10, 2006, at 3:19 PM, Jacques Le Roux wrote: > Only in french and italian right now, easy to improve though... > > Next I will work on catalog, do you see any others places needing > this ? > > I let you do the job Si ? > > Jacques > > From: "Si Chen" <[hidden email]> >> Yes, let's do that so the demo data would allow people to see the >> i18n of product categories. >> >> On Nov 10, 2006, at 2:28 PM, Jacques Le Roux wrote: >> >>> David, >>> >>> Forget it, I was thinking that we may not use anymore the category >>> description field, but I guess it's needed if we want to keep >>> things fast. >>> >>> So Si, it seems that if you want to remove the description field >>> from demo ProductCategory data it's ok, isn'it ? >>> >>> Jacques >>> >>>> >>>> Jacques, >>>> >>>> Sorry, you lost me. What is the "DB description" field, and what >>>> refactoring and such would this imply? >>>> >>>> -David >>>> >>>> >>>> On Nov 10, 2006, at 1:53 PM, Jacques Le Roux wrote: >>>> >>>>> David, >>>>> >>>>> OK, and what about the DB description field always needed and >>>>> some >>>>> DB refactoring that this (and more eventually) may imply ? >>>>> >>>>> Jacques >>>>> >>>>> >>>>> From: "David E Jones" <[hidden email]> >>>>>> >>>>>> For "demo" data, the performance doesn't matter as much. >>>>>> Better to >>>>>> demonstrate and test, at least with one of the fields. >>>>>> >>>>>> -David >>>>>> >>>>>> >>>>>> On Nov 10, 2006, at 1:12 PM, Jacques Le Roux wrote: >>>>>> >>>>>>> I'm not sure because as David already explained there are 2 ways >>>>>>> for this. >>>>>>> Quick one : std description field >>>>>>> Longuer one : std description field overidden by data source >>>>>>> content (this implies a default locale that seems ok now) >>>>>>> >>>>>>> And IIRW David seemed to keep std description field because it's >>>>>>> quicker. >>>>>>> Actually, if we do according to your proposition is the DB >>>>>>> description field always needed ? >>>>>>> And if we go in this direction maybe some DB refactoring have >>>>>>> to be >>>>>>> thought about ? >>>>>>> >>>>>>> Jacques >>>>>>> >>>>>>> From: "Si Chen" <[hidden email]> >>>>>>>> So should we remove the description field from these >>>>>>>> ProductCategory >>>>>>>> in the demo data? I think so, or how would one be able to see >>>>>>>> the >>>>>>>> alternate locale description? >> >> Best Regards, >> >> Si >> [hidden email] >> >> >> >> Best Regards, Si [hidden email] |
In reply to this post by cjhowe
Actually, this may have undesired side effects that actually slow it down and/or make caching less efficient... -David On Nov 10, 2006, at 4:42 PM, Chris Howe wrote: > I'm curious as to how much of a performance hit it > would be to create a view entity between product and > each langauge (ie ProductViewEN, ProductViewES, > ProductViewFR, ProductViewIT) using a complex alias > for this. > This would have the benefit of being able to i18n more > than just the description and also perhaps jump start > the normalization of the Product entity that was > discussed a few months back so that you don't have the > overflow of fields that don't make sense to the > product type (ie the rental fields for sale products, > the product dimension fields for electronic products, > etc) > > --- Jacques Le Roux <[hidden email]> > wrote: > >> David, >> >> Forget it, I was thinking that we may not use >> anymore the category description field, but I guess >> it's needed if we want to keep >> things fast. >> >> So Si, it seems that if you want to remove the >> description field from demo ProductCategory data >> it's ok, isn'it ? >> >> Jacques >> >>> >>> Jacques, >>> >>> Sorry, you lost me. What is the "DB description" >> field, and what >>> refactoring and such would this imply? >>> >>> -David >>> >>> >>> On Nov 10, 2006, at 1:53 PM, Jacques Le Roux >> wrote: >>> >>>> David, >>>> >>>> OK, and what about the DB description field >> always needed and some >>>> DB refactoring that this (and more eventually) >> may imply ? >>>> >>>> Jacques >>>> >>>> >>>> From: "David E Jones" >> <[hidden email]> >>>>> >>>>> For "demo" data, the performance doesn't matter >> as much. Better to >>>>> demonstrate and test, at least with one of the >> fields. >>>>> >>>>> -David >>>>> >>>>> >>>>> On Nov 10, 2006, at 1:12 PM, Jacques Le Roux >> wrote: >>>>> >>>>>> I'm not sure because as David already >> explained there are 2 ways >>>>>> for this. >>>>>> Quick one : std description field >>>>>> Longuer one : std description field overidden >> by data source >>>>>> content (this implies a default locale that >> seems ok now) >>>>>> >>>>>> And IIRW David seemed to keep std description >> field because it's >>>>>> quicker. >>>>>> Actually, if we do according to your >> proposition is the DB >>>>>> description field always needed ? >>>>>> And if we go in this direction maybe some DB >> refactoring have to be >>>>>> thought about ? >>>>>> >>>>>> Jacques >>>>>> >>>>>> From: "Si Chen" >> <[hidden email]> >>>>>>> So should we remove the description field >> from these >>>>>>> ProductCategory >>>>>>> in the demo data? I think so, or how would >> one be able to see the >>>>>>> alternate locale description? >> >> > |
How would one best go about testing how expensive a
complex alias is? Additionally, alongside the discussion on the data warehousing strategies how feasible do you think it would be in a real setup to create a "temporary" Product entity that gets truncated and rebuilt by a service of normalized entities since most of the live ecommerce use of the Product entities are retrieval queries and not create update or delete? This being rebuilt once a day, once a week, once a product line change, etc. --- David E Jones <[hidden email]> wrote: > > Actually, this may have undesired side effects that > actually slow it > down and/or make caching less efficient... > > -David > > > On Nov 10, 2006, at 4:42 PM, Chris Howe wrote: > > > I'm curious as to how much of a performance hit it > > would be to create a view entity between product > and > > each langauge (ie ProductViewEN, ProductViewES, > > ProductViewFR, ProductViewIT) using a complex > alias > > for this. > > This would have the benefit of being able to i18n > more > > than just the description and also perhaps jump > start > > the normalization of the Product entity that was > > discussed a few months back so that you don't have > the > > overflow of fields that don't make sense to the > > product type (ie the rental fields for sale > products, > > the product dimension fields for electronic > products, > > etc) > > > > --- Jacques Le Roux <[hidden email]> > > wrote: > > > >> David, > >> > >> Forget it, I was thinking that we may not use > >> anymore the category description field, but I > guess > >> it's needed if we want to keep > >> things fast. > >> > >> So Si, it seems that if you want to remove the > >> description field from demo ProductCategory data > >> it's ok, isn'it ? > >> > >> Jacques > >> > >>> > >>> Jacques, > >>> > >>> Sorry, you lost me. What is the "DB description" > >> field, and what > >>> refactoring and such would this imply? > >>> > >>> -David > >>> > >>> > >>> On Nov 10, 2006, at 1:53 PM, Jacques Le Roux > >> wrote: > >>> > >>>> David, > >>>> > >>>> OK, and what about the DB description field > >> always needed and some > >>>> DB refactoring that this (and more eventually) > >> may imply ? > >>>> > >>>> Jacques > >>>> > >>>> > >>>> From: "David E Jones" > >> <[hidden email]> > >>>>> > >>>>> For "demo" data, the performance doesn't > matter > >> as much. Better to > >>>>> demonstrate and test, at least with one of the > >> fields. > >>>>> > >>>>> -David > >>>>> > >>>>> > >>>>> On Nov 10, 2006, at 1:12 PM, Jacques Le Roux > >> wrote: > >>>>> > >>>>>> I'm not sure because as David already > >> explained there are 2 ways > >>>>>> for this. > >>>>>> Quick one : std description field > >>>>>> Longuer one : std description field overidden > >> by data source > >>>>>> content (this implies a default locale that > >> seems ok now) > >>>>>> > >>>>>> And IIRW David seemed to keep std description > >> field because it's > >>>>>> quicker. > >>>>>> Actually, if we do according to your > >> proposition is the DB > >>>>>> description field always needed ? > >>>>>> And if we go in this direction maybe some DB > >> refactoring have to be > >>>>>> thought about ? > >>>>>> > >>>>>> Jacques > >>>>>> > >>>>>> From: "Si Chen" > >> <[hidden email]> > >>>>>>> So should we remove the description field > >> from these > >>>>>>> ProductCategory > >>>>>>> in the demo data? I think so, or how would > >> one be able to see the > >>>>>>> alternate locale description? > >> > >> > > > > |
On Nov 10, 2006, at 9:26 PM, Chris Howe wrote: > How would one best go about testing how expensive a > complex alias is? The main trick is caching. You can always measure the time it takes to do a query, but in general doing a cache look up is generally two orders of magnitude faster than a db query, and as you mentioned below the product information doesn't change as often so caching works well. > Additionally, alongside the discussion on the data > warehousing strategies how feasible do you think it > would be in a real setup to create a "temporary" > Product entity that gets truncated and rebuilt by a > service of normalized entities since most of the live > ecommerce use of the Product entities are retrieval > queries and not create update or delete? This being > rebuilt once a day, once a week, once a product line > change, etc. What would the goal be for this? In general this sort of thing is difficult and costly and makes things like real-time effective dated relationships and other such things difficult. -David > --- David E Jones <[hidden email]> > wrote: > >> >> Actually, this may have undesired side effects that >> actually slow it >> down and/or make caching less efficient... >> >> -David >> >> >> On Nov 10, 2006, at 4:42 PM, Chris Howe wrote: >> >>> I'm curious as to how much of a performance hit it >>> would be to create a view entity between product >> and >>> each langauge (ie ProductViewEN, ProductViewES, >>> ProductViewFR, ProductViewIT) using a complex >> alias >>> for this. >>> This would have the benefit of being able to i18n >> more >>> than just the description and also perhaps jump >> start >>> the normalization of the Product entity that was >>> discussed a few months back so that you don't have >> the >>> overflow of fields that don't make sense to the >>> product type (ie the rental fields for sale >> products, >>> the product dimension fields for electronic >> products, >>> etc) >>> >>> --- Jacques Le Roux <[hidden email]> >>> wrote: >>> >>>> David, >>>> >>>> Forget it, I was thinking that we may not use >>>> anymore the category description field, but I >> guess >>>> it's needed if we want to keep >>>> things fast. >>>> >>>> So Si, it seems that if you want to remove the >>>> description field from demo ProductCategory data >>>> it's ok, isn'it ? >>>> >>>> Jacques >>>> >>>>> >>>>> Jacques, >>>>> >>>>> Sorry, you lost me. What is the "DB description" >>>> field, and what >>>>> refactoring and such would this imply? >>>>> >>>>> -David >>>>> >>>>> >>>>> On Nov 10, 2006, at 1:53 PM, Jacques Le Roux >>>> wrote: >>>>> >>>>>> David, >>>>>> >>>>>> OK, and what about the DB description field >>>> always needed and some >>>>>> DB refactoring that this (and more eventually) >>>> may imply ? >>>>>> >>>>>> Jacques >>>>>> >>>>>> >>>>>> From: "David E Jones" >>>> <[hidden email]> >>>>>>> >>>>>>> For "demo" data, the performance doesn't >> matter >>>> as much. Better to >>>>>>> demonstrate and test, at least with one of the >>>> fields. >>>>>>> >>>>>>> -David >>>>>>> >>>>>>> >>>>>>> On Nov 10, 2006, at 1:12 PM, Jacques Le Roux >>>> wrote: >>>>>>> >>>>>>>> I'm not sure because as David already >>>> explained there are 2 ways >>>>>>>> for this. >>>>>>>> Quick one : std description field >>>>>>>> Longuer one : std description field overidden >>>> by data source >>>>>>>> content (this implies a default locale that >>>> seems ok now) >>>>>>>> >>>>>>>> And IIRW David seemed to keep std description >>>> field because it's >>>>>>>> quicker. >>>>>>>> Actually, if we do according to your >>>> proposition is the DB >>>>>>>> description field always needed ? >>>>>>>> And if we go in this direction maybe some DB >>>> refactoring have to be >>>>>>>> thought about ? >>>>>>>> >>>>>>>> Jacques >>>>>>>> >>>>>>>> From: "Si Chen" >>>> <[hidden email]> >>>>>>>>> So should we remove the description field >>>> from these >>>>>>>>> ProductCategory >>>>>>>>> in the demo data? I think so, or how would >>>> one be able to see the >>>>>>>>> alternate locale description? >>>> >>>> >>> >> >> > |
--- David E Jones <[hidden email]> wrote: > The main trick is caching. You can always measure > the time it takes > to do a query, but in general doing a cache look up > is generally two > orders of magnitude faster than a db query, and as > you mentioned > below the product information doesn't change as > often so caching > works well. > So, aside from a view-entity not actually being handled by the database by declaring an explicit SQL "CREATE VIEW...", is it possible to cache the results of a complex-alias view entity? If it's cached, is there then a difference whether it's being handled by an entity or a view entity on subsequent requests? > > What would the goal be for this? > Just brainstorming, three goals 1) Creating data warehousing techniques where the proof of concept end result is more applicable to a wider user base than simply the report generation that's generally more implementation specific. 2) Decrease the learning curve by separating the Product entity by the meaning of the data, without having to scrap much of the work that is in the demo installation. 3) Normalization. Decrease the potential of breaking one feature when introducing another (or creating roadblocks from new features being created). > In general this sort of thing is difficult and > costly I don't think it would be difficult as you'd be using a normalized data set to create the denormalized temporary table. Costly, perhaps. And that's where my question is really aimed at. If you had 100,000 products, would it take five, ten, fifteen minutes to run a service to recreate a new temporary table? And even if it did take that long couldn't you avoid the effect on a live system with the following strategy. Product - denormalized product related entity ProductSub1 - normalized portion of Product Entity ProductSub2 - normalized portion of Product Entity ... - more normalied portions of Product Entity ProductSubN - normalized portion of Product Entity Run service that denormalizes portions of ProductSub1, ProductSub2, ... ProductSubN to create ProductNext - denormalized product related entity not in use yet Drop Product, rename ProductNext to Product > and makes > things like real-time effective dated relationships > and other such > things difficult. > Wouldn't the dating of the relations in the normalized entities still be correct even though the denormalized entity is being dropped and recreated? > -David > |
Free forum by Nabble | Edit this page |