You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Jacques Le Roux <ja...@les7arts.com> on 2007/12/27 23:17:48 UTC
Re: svn commit: r607090 - in /ofbiz/trunk/applications: ecommerce/data/DemoConfigurator.xml ecommerce/data/DemoProductImages.xml manufacturing/data/ManufacturingExampleData.xml
I'm not sure why, I was able to import in Postgres but not in Derby (using Webtools/import text). I will see later..
Jacques
----- Original Message -----
From: <jl...@apache.org>
To: <co...@ofbiz.apache.org>
Sent: Thursday, December 27, 2007 6:04 PM
Subject: svn commit: r607090 - in /ofbiz/trunk/applications: ecommerce/data/DemoConfigurator.xml
ecommerce/data/DemoProductImages.xml manufacturing/data/ManufacturingExampleData.xml
> Author: jleroux
> Date: Thu Dec 27 09:04:51 2007
> New Revision: 607090
>
> URL: http://svn.apache.org/viewvc?rev=607090&view=rev
> Log:
> New very simple aggregated product of type Food using Chris Lombardi's example in
> https://issues.apache.org/jira/browse/OFBIZ-1495#action_12554443
> I did real quick so maybe there are some changes to do...
> I noticed one, we should find a generalised label for "verify configuration"
>
> Modified:
> ofbiz/trunk/applications/ecommerce/data/DemoConfigurator.xml
> ofbiz/trunk/applications/ecommerce/data/DemoProductImages.xml
> ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml
>
> Modified: ofbiz/trunk/applications/ecommerce/data/DemoConfigurator.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/applications/ecommerce/data/DemoConfigurator.xml?rev=607090&r1=607089&r2=607090&view=diff
> ==============================================================================
> --- ofbiz/trunk/applications/ecommerce/data/DemoConfigurator.xml (original)
> +++ ofbiz/trunk/applications/ecommerce/data/DemoConfigurator.xml Thu Dec 27 09:04:51 2007
> @@ -20,17 +20,17 @@
>
> <entity-engine-xml>
> <Product productId="PC001" productTypeId="AGGREGATED" productName="Configurable PC" internalName="Configurable PC"
> description="Configurable PC" isVirtual="N" isVariant="N" billOfMaterialLevel="0" createdDate="2004-08-20 12:49:13.418"
> createdByUserLogin="admin"/>
> - <Product productId="RAM256_BRAND" productTypeId="FINISHED_GOOD" productName="RAM256" internalName="RAM 256 no parity"
> description="1GB Dual Channel DDR2 SDRAM at 667MHz" isVirtual="N" isVariant="N" billOfMaterialLevel="0" createdDate="2004-08-20
> 12:50:54.794" createdByUserLogin="admin"/>
> - <Product productId="HD2GB_BRAND" productTypeId="FINISHED_GOOD" productName="HD2GB" internalName="HD 2 GB" description="250GB
> Serial ATA Hard Drive (7200RPM)" isVirtual="N" isVariant="N" billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
> createdByUserLogin="admin"/>
> - <Product productId="HD4GB_BRAND" productTypeId="FINISHED_GOOD" productName="HD4GB" internalName="HD 4 GB" description="500GB
> Serial ATA Hard Drive (7200RPM)" isVirtual="N" isVariant="N" billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
> createdByUserLogin="admin"/>
> + <Product productId="RAM1GB_BRAND" productTypeId="FINISHED_GOOD" productName="RAM1GB" internalName="RAM 1 GB DDR2"
> description="1 GB Dual Channel DDR2 SDRAM" isVirtual="N" isVariant="N" billOfMaterialLevel="0" createdDate="2004-08-20
> 12:50:54.794" createdByUserLogin="admin"/>
> + <Product productId="HD250GB_BRAND" productTypeId="FINISHED_GOOD" productName="HD250GB" internalName="HD 250 GB"
> description="250 GB Hard Drive" isVirtual="N" isVariant="N" billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
> createdByUserLogin="admin"/>
> + <Product productId="HD500GB_BRAND" productTypeId="FINISHED_GOOD" productName="HD500GB" internalName="HD 450 GB"
> description="500 GB Hard Drive" isVirtual="N" isVariant="N" billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
> createdByUserLogin="admin"/>
> <Product productId="ETH_BRAND" productTypeId="FINISHED_GOOD" productName="Ethernet100" internalName="Ethernet Card 10/100"
> description="Ethernet Card 10/100" isVirtual="N" isVariant="N" billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
> createdByUserLogin="admin"/>
> <Product productId="MOD_BRAND" productTypeId="FINISHED_GOOD" productName="Modem56k" internalName="Modem Card 56k"
> description="Modem Card 56k" isVirtual="N" isVariant="N" billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
> createdByUserLogin="admin"/>
> -
> +
> <ProductPrice productId="PC001" productPricePurposeId="PURCHASE" productPriceTypeId="DEFAULT_PRICE" currencyUomId="USD"
> productStoreGroupId="_NA_" fromDate="2004-08-20 12:55:53.223" price="50" createdDate="2004-08-20 12:55:53.223"
> createdByUserLogin="admin"/>
> - <ProductPrice productId="RAM256_BRAND" productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20 12:55:53.223" price="115" createdDate="2004-08-20
> 12:55:53.223" createdByUserLogin="admin"/>
> - <ProductPrice productId="RAM256_BRAND" productPricePurposeId="PURCHASE" productPriceTypeId="DEFAULT_PRICE"
> currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20 12:55:36.479" price="120" createdDate="2004-08-20
> 12:55:36.479" createdByUserLogin="admin"/>
> - <ProductPrice productId="HD2GB_BRAND" productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20 12:55:53.223" price="220" createdDate="2004-08-20
> 12:55:53.223" createdByUserLogin="admin"/>
> - <ProductPrice productId="HD4GB_BRAND" productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20 12:55:36.479" price="420" createdDate="2004-08-20
> 12:55:36.479" createdByUserLogin="admin"/>
> + <ProductPrice productId="RAM1GB_BRAND" productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20 12:55:53.223" price="115" createdDate="2004-08-20
> 12:55:53.223" createdByUserLogin="admin"/>
> + <ProductPrice productId="RAM1GB_BRAND" productPricePurposeId="PURCHASE" productPriceTypeId="DEFAULT_PRICE"
> currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20 12:55:36.479" price="120" createdDate="2004-08-20
> 12:55:36.479" createdByUserLogin="admin"/>
> + <ProductPrice productId="HD250GB_BRAND" productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20 12:55:53.223" price="220" createdDate="2004-08-20
> 12:55:53.223" createdByUserLogin="admin"/>
> + <ProductPrice productId="HD500GB_BRAND" productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20 12:55:36.479" price="420" createdDate="2004-08-20
> 12:55:36.479" createdByUserLogin="admin"/>
> <ProductPrice productId="ETH_BRAND" productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20 12:55:36.479" price="18" createdDate="2004-08-20 12:55:36.479"
> createdByUserLogin="admin"/>
> <ProductPrice productId="MOD_BRAND" productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20 12:55:36.479" price="15" createdDate="2004-08-20 12:55:36.479"
> createdByUserLogin="admin"/>
>
> @@ -45,10 +45,10 @@
> <ProductConfigOption configItemId="IT0002" configOptionId="OP004" configOptionName="OPT001" description="Ethernet Card"
> sequenceNum="10"/>
> <ProductConfigOption configItemId="IT0002" configOptionId="OP005" configOptionName="OPT002" description="Modem 56k"
> sequenceNum="20"/>
>
> - <ProductConfigProduct configItemId="IT0000" configOptionId="OP000" productId="RAM256_BRAND" quantity="1"/>
> - <ProductConfigProduct configItemId="IT0000" configOptionId="OP001" productId="RAM256_BRAND" quantity="2"/>
> - <ProductConfigProduct configItemId="IT0001" configOptionId="OP002" productId="HD2GB_BRAND" quantity="1"/>
> - <ProductConfigProduct configItemId="IT0001" configOptionId="OP003" productId="HD4GB_BRAND" quantity="1"/>
> + <ProductConfigProduct configItemId="IT0000" configOptionId="OP000" productId="RAM1GB_BRAND" quantity="1"/>
> + <ProductConfigProduct configItemId="IT0000" configOptionId="OP001" productId="RAM1GB_BRAND" quantity="2"/>
> + <ProductConfigProduct configItemId="IT0001" configOptionId="OP002" productId="HD250GB_BRAND" quantity="1"/>
> + <ProductConfigProduct configItemId="IT0001" configOptionId="OP003" productId="HD500GB_BRAND" quantity="1"/>
> <ProductConfigProduct configItemId="IT0002" configOptionId="OP004" productId="ETH_BRAND" quantity="1"/>
> <ProductConfigProduct configItemId="IT0002" configOptionId="OP005" productId="MOD_BRAND" quantity="1"/>
>
> @@ -71,4 +71,43 @@
> <ProductCategoryMember productCategoryId="PROMOTIONS" productId="PC001" fromDate="2001-05-13 12:00:00.0"/>
> <ProductCategoryMember productCategoryId="PC-100" productId="PC001" fromDate="2001-05-13 12:00:00.0"/>
> <ProductCategoryMember productCategoryId="CATALOG1_SEARCH" productId="PC001" fromDate="2001-05-13 12:00:00.0"/>
> +
> + <Product productId="ENCHILADAS" productTypeId="AGGREGATED" productName="Enchiladas" internalName="Enchiladas"
> description="Cheese enchiladas" isVirtual="N" isVariant="N" billOfMaterialLevel="0" createdDate="2007-12-27 12:00:00.0"
> createdByUserLogin="admin"/>
> + <Product productId="FAJITA_BEEF" productTypeId="FINISHED_GOOD" productName="Fajita beef" internalName="Fajita beef"
> description="Fajita beef" isVirtual="N" isVariant="N" billOfMaterialLevel="0" createdDate="2007-12-27 12:00:00.0"
> createdByUserLogin="admin"/>
> + <Product productId="JALAPENOS" productTypeId="FINISHED_GOOD" productName="Jalapenos" internalName="Jalapenos"
> description="Jalapenos" isVirtual="N" isVariant="N" billOfMaterialLevel="0" createdDate="2007-12-27 12:00:00.0"
> createdByUserLogin="admin"/>
> +
> + <ProductPrice productId="ENCHILADAS" productPricePurposeId="PURCHASE" productPriceTypeId="DEFAULT_PRICE" currencyUomId="USD"
> productStoreGroupId="_NA_" fromDate="2007-12-27 12:00:00.0" price="6" createdDate="2007-12-27 12:00:00.0"
> createdByUserLogin="admin"/>
> + <ProductPrice productId="FAJITA_BEEF" productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2007-12-27 12:00:00.0" price="2" createdDate="2007-12-27 12:00:00.0"
> createdByUserLogin="admin"/>
> + <ProductPrice productId="FAJITA_BEEF" productPricePurposeId="PURCHASE" productPriceTypeId="DEFAULT_PRICE" currencyUomId="USD"
> productStoreGroupId="_NA_" fromDate="2007-12-27 12:00:00.0" price="8" createdDate="2007-12-27 12:00:00.0"
> createdByUserLogin="admin"/>
> + <ProductPrice productId="JALAPENOS" productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2007-12-27 12:00:00.0" price="0.75" createdDate="2007-12-27 12:00:00.0"
> createdByUserLogin="admin"/>
> +
> + <ProductConfigItem configItemId="TEXMEX0000" configItemTypeId="SINGLE" configItemName="Enchiladas type" description="Select
> cheese or beef (default to cheese):"/>
> + <ProductConfigItem configItemId="TEXMEX0001" configItemTypeId="MULTIPLE" configItemName="Peppers" description="Add jalapenos
> :"/>
> +
> + <ProductConfigProduct configItemId="TEXMEX0000" configOptionId="OP010" productId="ENCHILADAS" quantity="1"/>
> + <ProductConfigProduct configItemId="TEXMEX0000" configOptionId="OP011" productId="FAJITA_BEEF" quantity="1"/>
> + <ProductConfigProduct configItemId="TEXMEX0001" configOptionId="OP012" productId="JALAPENOS" quantity="1"/>
> +
> + <ProductConfigOption configItemId="TEXMEX0000" configOptionId="OP010" configOptionName="OPT001" description="Cheese
> enchiladas" sequenceNum="10"/>
> + <ProductConfigOption configItemId="TEXMEX0000" configOptionId="OP011" configOptionName="OPT002" description="Fajita beef"
> sequenceNum="20"/>
> + <ProductConfigOption configItemId="TEXMEX0001" configOptionId="OP012" configOptionName="OPT001" description="Jalapenos"
> sequenceNum="10"/>
> +
> + <ProductConfig productId="ENCHILADAS" configItemId="TEXMEX0000" sequenceNum="10" fromDate="2004-08-20 12:59:26.209"
> description="Enchiladas type" defaultConfigOptionId="OP010" configTypeId="QUESTION" isMandatory="Y"/>
> + <ProductConfig productId="ENCHILADAS" configItemId="TEXMEX0001" sequenceNum="20" fromDate="2004-08-20 12:59:26.209"
> description="Peppers" configTypeId="QUESTION" isMandatory="N"/>
> +
> + <WorkEffort workEffortId="TASK11" workEffortTypeId="ROU_TASK" workEffortPurposeTypeId="ROU_ASSEMBLING"
> currentStatusId="ROU_ACTIVE" workEffortName="Stock out" description="Components" revisionNumber="1" fixedAssetId="DEMO_FOOD_GROUP"
> estimatedMilliSeconds="600000" estimatedSetupMillis="0"/>
> + <WorkEffort workEffortId="TASK12" workEffortTypeId="ROU_TASK" workEffortPurposeTypeId="ROU_ASSEMBLING"
> currentStatusId="ROU_ACTIVE" workEffortName="Assembly" description="Assembly" revisionNumber="1" fixedAssetId="DEMO_FOOD_GROUP"
> estimatedMilliSeconds="900000" estimatedSetupMillis="0"/>
> + <WorkEffort workEffortId="TASK13" workEffortTypeId="ROU_TASK" workEffortPurposeTypeId="ROU_ASSEMBLING"
> currentStatusId="ROU_ACTIVE" workEffortName="Test" description="Test" revisionNumber="1" fixedAssetId="DEMO_FOOD_GROUP"
> estimatedMilliSeconds="450000" estimatedSetupMillis="20000"/>
> + <WorkEffort workEffortId="ROUT11" workEffortTypeId="ROUTING" currentStatusId="ROU_ACTIVE" workEffortName="Food delivery"
> description="Food delivery" revisionNumber="1" quantityToProduce="0"/>
> + <WorkEffortGoodStandard workEffortId="ROUT11" productId="ENCHILADAS" workEffortGoodStdTypeId="ROU_PROD_TEMPLATE"
> statusId="WEGS_CREATED" fromDate="2007-12-27 12:00:00.0"/>
> + <WorkEffortAssoc workEffortIdFrom="ROUT11" workEffortIdTo="TASK11" workEffortAssocTypeId="ROUTING_COMPONENT" sequenceNum="10"
> fromDate="2007-12-27 12:00:00.0"/>
> + <WorkEffortAssoc workEffortIdFrom="ROUT11" workEffortIdTo="TASK12" workEffortAssocTypeId="ROUTING_COMPONENT" sequenceNum="20"
> fromDate="2007-12-27 12:00:00.0"/>
> + <WorkEffortAssoc workEffortIdFrom="ROUT11" workEffortIdTo="TASK13" workEffortAssocTypeId="ROUTING_COMPONENT" sequenceNum="30"
> fromDate="2007-12-27 12:00:00.0"/>
> +
> + <ProductCategory productCategoryId="FOOD-001" productCategoryTypeId="CATALOG_CATEGORY"/>
> + <ProductCategoryRollup fromDate="2007-12-27 12:00:00.0" parentProductCategoryId="CATALOG1" productCategoryId="FOOD-001"/>
> + <ProductCategoryMember productCategoryId="PROMOTIONS" productId="ENCHILADAS" fromDate="2007-12-27 12:00:00.0"/>
> + <ProductCategoryMember productCategoryId="FOOD-001" productId="ENCHILADAS" fromDate="2007-12-27 12:00:00.0"/>
> + <ProductCategoryMember productCategoryId="CATALOG1_SEARCH" productId="ENCHILADAS" fromDate="2007-12-27 12:00:00.0"/>
> +
> </entity-engine-xml>
>
> Modified: ofbiz/trunk/applications/ecommerce/data/DemoProductImages.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/applications/ecommerce/data/DemoProductImages.xml?rev=607090&r1=607089&r2=607090&view=diff
> ==============================================================================
> --- ofbiz/trunk/applications/ecommerce/data/DemoProductImages.xml (original)
> +++ ofbiz/trunk/applications/ecommerce/data/DemoProductImages.xml Thu Dec 27 09:04:51 2007
> @@ -36,4 +36,5 @@
> <Product productId="PC001" smallImageUrl="/images/products/small/gis_computer_glen_rolla.png"
> largeImageUrl="/images/products/large/gis_computer_glen_rolla.png"/>
> <Product productId="GC-001" smallImageUrl="/images/products/small/certificate.png"
> largeImageUrl="/images/products/large/certificate.png"/>
> <Product productId="GC-002" smallImageUrl="/images/products/small/certificate.png"
> largeImageUrl="/images/products/large/certificate.png"/>
> + <Product productId="ENCHILADAS" smallImageUrl="/images/products/small/borsa_estiva_architetto.png"
> largeImageUrl="/images/products/large/borsa_estiva_architetto.png"/>
> </entity-engine-xml>
>
> Modified: ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml?rev=607090&r1=607089&r2=607090&view=diff
> ==============================================================================
> --- ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml (original)
> +++ ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml Thu Dec 27 09:04:51 2007
> @@ -29,7 +29,10 @@
> <TechDataCalendarWeek calendarWeekId="DEMO_WEEK" description="Demo calendar week of 8hours/days 5days/week starting at 8h30
> from monday to friday" mondayStartTime="08:30:00" mondayCapacity="2.88E7" tuesdayStartTime="08:30:00" tuesdayCapacity="2.88E7"
> wednesdayStartTime="08:30:00" wednesdayCapacity="2.88E7" thursdayStartTime="08:30:00" thursdayCapacity="2.88E7"
> fridayStartTime="08:30:00" fridayCapacity="2.88E7"/>
> <TechDataCalendar calendarId="DEMO_CALENDAR" description="Demo Workcenter Calendar" calendarWeekId="DEMO_WEEK"/>
> <TechDataCalendarExcDay calendarId="DEMO_CALENDAR" exceptionDateStartTime="2004-12-24 00:01:00.0" exceptionCapacity="0"
> description="Christmas Day"/>
> -
> +
> <FixedAsset fixedAssetId="DEMO_MACHINE_GROUP" fixedAssetTypeId="GROUP_EQUIPMENT" fixedAssetName="Demo Machine Group"/>
> <FixedAsset fixedAssetId="DEMO_MACHINE" fixedAssetName="Demo Machine" fixedAssetTypeId="PRODUCTION_EQUIPMENT"
> parentFixedAssetId="DEMO_MACHINE_GROUP" calendarId="DEMO_CALENDAR"/>
> +
> + <FixedAsset fixedAssetId="DEMO_FOOD_GROUP" fixedAssetTypeId="GROUP_EQUIPMENT" fixedAssetName="Demo Food Group"/>
> + <FixedAsset fixedAssetId="DEMO_FOOD" fixedAssetName="Demo Food" fixedAssetTypeId="PRODUCTION_EQUIPMENT"
> parentFixedAssetId="DEMO_FOOD_GROUP" calendarId="DEMO_CALENDAR"/>
> </entity-engine-xml>
>
>
>
Re: svn commit: r607090 - in /ofbiz/trunk/applications: ecommerce/data/DemoConfigurator.xml ecommerce/data/DemoProductImages.xml manufacturing/data/ManufacturingExampleData.xml
Posted by Jacques Le Roux <ja...@les7arts.com>.
Thanks Pankaj,
Jacques
From: "pankaj savita" <pa...@gmail.com>
>I think we must load the data for "ProductConfigOption" Entity before
> "ProductConfigProduct" Entity inorder to avoid the foreign key constraint.
>
> modifications required to make the Build Success in file
> DemoConfigurator.xml are as follows :
>
> <ProductConfigOption configItemId="TEXMEX0000" configOptionId="OP010"
> configOptionName="OPT001" description="Cheese enchiladas" sequenceNum="10"/>
> <ProductConfigOption configItemId="TEXMEX0000" configOptionId="OP011"
> configOptionName="OPT002" description="Fajita beef" sequenceNum="20"/>
> <ProductConfigOption configItemId="TEXMEX0001" configOptionId="OP012"
> configOptionName="OPT001" description="Jalapenos" sequenceNum="10"/>
>
> <ProductConfigProduct configItemId="TEXMEX0000" configOptionId="OP010"
> productId="ENCHILADAS" quantity="1"/>
> <ProductConfigProduct configItemId="TEXMEX0000" configOptionId="OP011"
> productId="FAJITA_BEEF" quantity="1"/>
> <ProductConfigProduct configItemId="TEXMEX0001" configOptionId="OP012"
> productId="JALAPENOS" quantity="1"/>
>
> --
> Cheers,
> Pankaj Savita
> HotWax Media Inc.
> Mailto: pankaj.savita@hotwaxmedia.com
> Website: http://www.hotwaxmedia.com
>
> On Dec 28, 2007 3:47 AM, Jacques Le Roux <ja...@les7arts.com>
> wrote:
>
>> I'm not sure why, I was able to import in Postgres but not in Derby (using
>> Webtools/import text). I will see later..
>>
>> Jacques
>>
>> ----- Original Message -----
>> From: <jl...@apache.org>
>> To: <co...@ofbiz.apache.org>
>> Sent: Thursday, December 27, 2007 6:04 PM
>> Subject: svn commit: r607090 - in /ofbiz/trunk/applications:
>> ecommerce/data/DemoConfigurator.xml
>> ecommerce/data/DemoProductImages.xml
>> manufacturing/data/ManufacturingExampleData.xml
>>
>>
>> > Author: jleroux
>> > Date: Thu Dec 27 09:04:51 2007
>> > New Revision: 607090
>> >
>> > URL: http://svn.apache.org/viewvc?rev=607090&view=rev
>> > Log:
>> > New very simple aggregated product of type Food using Chris Lombardi's
>> example in
>> > https://issues.apache.org/jira/browse/OFBIZ-1495#action_12554443
>> > I did real quick so maybe there are some changes to do...
>> > I noticed one, we should find a generalised label for "verify
>> configuration"
>> >
>> > Modified:
>> > ofbiz/trunk/applications/ecommerce/data/DemoConfigurator.xml
>> > ofbiz/trunk/applications/ecommerce/data/DemoProductImages.xml
>> >
>> ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml
>> >
>> > Modified: ofbiz/trunk/applications/ecommerce/data/DemoConfigurator.xml
>> > URL:
>> >
>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/ecommerce/data/DemoConfigurator.xml?rev=607090&r1=607089&r2=607090&view=diff
>> >
>> ==============================================================================
>> > --- ofbiz/trunk/applications/ecommerce/data/DemoConfigurator.xml
>> (original)
>> > +++ ofbiz/trunk/applications/ecommerce/data/DemoConfigurator.xml Thu Dec
>> 27 09:04:51 2007
>> > @@ -20,17 +20,17 @@
>> >
>> > <entity-engine-xml>
>> > <Product productId="PC001" productTypeId="AGGREGATED"
>> productName="Configurable PC" internalName="Configurable PC"
>> > description="Configurable PC" isVirtual="N" isVariant="N"
>> billOfMaterialLevel="0" createdDate="2004-08-20 12:49:13.418"
>> > createdByUserLogin="admin"/>
>> > - <Product productId="RAM256_BRAND" productTypeId="FINISHED_GOOD"
>> productName="RAM256" internalName="RAM 256 no parity"
>> > description="1GB Dual Channel DDR2 SDRAM at 667MHz" isVirtual="N"
>> isVariant="N" billOfMaterialLevel="0" createdDate="2004-08-20
>> > 12:50:54.794" createdByUserLogin="admin"/>
>> > - <Product productId="HD2GB_BRAND" productTypeId="FINISHED_GOOD"
>> productName="HD2GB" internalName="HD 2 GB" description="250GB
>> > Serial ATA Hard Drive (7200RPM)" isVirtual="N" isVariant="N"
>> billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
>> > createdByUserLogin="admin"/>
>> > - <Product productId="HD4GB_BRAND" productTypeId="FINISHED_GOOD"
>> productName="HD4GB" internalName="HD 4 GB" description="500GB
>> > Serial ATA Hard Drive (7200RPM)" isVirtual="N" isVariant="N"
>> billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
>> > createdByUserLogin="admin"/>
>> > + <Product productId="RAM1GB_BRAND" productTypeId="FINISHED_GOOD"
>> productName="RAM1GB" internalName="RAM 1 GB DDR2"
>> > description="1 GB Dual Channel DDR2 SDRAM" isVirtual="N" isVariant="N"
>> billOfMaterialLevel="0" createdDate="2004-08-20
>> > 12:50:54.794" createdByUserLogin="admin"/>
>> > + <Product productId="HD250GB_BRAND" productTypeId="FINISHED_GOOD"
>> productName="HD250GB" internalName="HD 250 GB"
>> > description="250 GB Hard Drive" isVirtual="N" isVariant="N"
>> billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
>> > createdByUserLogin="admin"/>
>> > + <Product productId="HD500GB_BRAND" productTypeId="FINISHED_GOOD"
>> productName="HD500GB" internalName="HD 450 GB"
>> > description="500 GB Hard Drive" isVirtual="N" isVariant="N"
>> billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
>> > createdByUserLogin="admin"/>
>> > <Product productId="ETH_BRAND" productTypeId="FINISHED_GOOD"
>> productName="Ethernet100" internalName="Ethernet Card 10/100"
>> > description="Ethernet Card 10/100" isVirtual="N" isVariant="N"
>> billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
>> > createdByUserLogin="admin"/>
>> > <Product productId="MOD_BRAND" productTypeId="FINISHED_GOOD"
>> productName="Modem56k" internalName="Modem Card 56k"
>> > description="Modem Card 56k" isVirtual="N" isVariant="N"
>> billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
>> > createdByUserLogin="admin"/>
>> > -
>> > +
>> > <ProductPrice productId="PC001" productPricePurposeId="PURCHASE"
>> productPriceTypeId="DEFAULT_PRICE" currencyUomId="USD"
>> > productStoreGroupId="_NA_" fromDate="2004-08-20 12:55:53.223" price="50"
>> createdDate="2004-08-20 12:55:53.223"
>> > createdByUserLogin="admin"/>
>> > - <ProductPrice productId="RAM256_BRAND"
>> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
>> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
>> 12:55:53.223" price="115" createdDate="2004-08-20
>> > 12:55:53.223" createdByUserLogin="admin"/>
>> > - <ProductPrice productId="RAM256_BRAND"
>> productPricePurposeId="PURCHASE" productPriceTypeId="DEFAULT_PRICE"
>> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
>> 12:55:36.479" price="120" createdDate="2004-08-20
>> > 12:55:36.479" createdByUserLogin="admin"/>
>> > - <ProductPrice productId="HD2GB_BRAND"
>> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
>> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
>> 12:55:53.223" price="220" createdDate="2004-08-20
>> > 12:55:53.223" createdByUserLogin="admin"/>
>> > - <ProductPrice productId="HD4GB_BRAND"
>> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
>> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
>> 12:55:36.479" price="420" createdDate="2004-08-20
>> > 12:55:36.479" createdByUserLogin="admin"/>
>> > + <ProductPrice productId="RAM1GB_BRAND"
>> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
>> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
>> 12:55:53.223" price="115" createdDate="2004-08-20
>> > 12:55:53.223" createdByUserLogin="admin"/>
>> > + <ProductPrice productId="RAM1GB_BRAND"
>> productPricePurposeId="PURCHASE" productPriceTypeId="DEFAULT_PRICE"
>> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
>> 12:55:36.479" price="120" createdDate="2004-08-20
>> > 12:55:36.479" createdByUserLogin="admin"/>
>> > + <ProductPrice productId="HD250GB_BRAND"
>> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
>> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
>> 12:55:53.223" price="220" createdDate="2004-08-20
>> > 12:55:53.223" createdByUserLogin="admin"/>
>> > + <ProductPrice productId="HD500GB_BRAND"
>> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
>> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
>> 12:55:36.479" price="420" createdDate="2004-08-20
>> > 12:55:36.479" createdByUserLogin="admin"/>
>> > <ProductPrice productId="ETH_BRAND"
>> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
>> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
>> 12:55:36.479" price="18" createdDate="2004-08-20 12:55:36.479"
>> > createdByUserLogin="admin"/>
>> > <ProductPrice productId="MOD_BRAND"
>> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
>> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
>> 12:55:36.479" price="15" createdDate="2004-08-20 12:55:36.479"
>> > createdByUserLogin="admin"/>
>> >
>> > @@ -45,10 +45,10 @@
>> > <ProductConfigOption configItemId="IT0002" configOptionId="OP004"
>> configOptionName="OPT001" description="Ethernet Card"
>> > sequenceNum="10"/>
>> > <ProductConfigOption configItemId="IT0002" configOptionId="OP005"
>> configOptionName="OPT002" description="Modem 56k"
>> > sequenceNum="20"/>
>> >
>> > - <ProductConfigProduct configItemId="IT0000" configOptionId="OP000"
>> productId="RAM256_BRAND" quantity="1"/>
>> > - <ProductConfigProduct configItemId="IT0000" configOptionId="OP001"
>> productId="RAM256_BRAND" quantity="2"/>
>> > - <ProductConfigProduct configItemId="IT0001" configOptionId="OP002"
>> productId="HD2GB_BRAND" quantity="1"/>
>> > - <ProductConfigProduct configItemId="IT0001" configOptionId="OP003"
>> productId="HD4GB_BRAND" quantity="1"/>
>> > + <ProductConfigProduct configItemId="IT0000" configOptionId="OP000"
>> productId="RAM1GB_BRAND" quantity="1"/>
>> > + <ProductConfigProduct configItemId="IT0000" configOptionId="OP001"
>> productId="RAM1GB_BRAND" quantity="2"/>
>> > + <ProductConfigProduct configItemId="IT0001" configOptionId="OP002"
>> productId="HD250GB_BRAND" quantity="1"/>
>> > + <ProductConfigProduct configItemId="IT0001" configOptionId="OP003"
>> productId="HD500GB_BRAND" quantity="1"/>
>> > <ProductConfigProduct configItemId="IT0002" configOptionId="OP004"
>> productId="ETH_BRAND" quantity="1"/>
>> > <ProductConfigProduct configItemId="IT0002" configOptionId="OP005"
>> productId="MOD_BRAND" quantity="1"/>
>> >
>> > @@ -71,4 +71,43 @@
>> > <ProductCategoryMember productCategoryId="PROMOTIONS"
>> productId="PC001" fromDate="2001-05-13 12:00:00.0"/>
>> > <ProductCategoryMember productCategoryId="PC-100" productId="PC001"
>> fromDate="2001-05-13 12:00:00.0"/>
>> > <ProductCategoryMember productCategoryId="CATALOG1_SEARCH"
>> productId="PC001" fromDate="2001-05-13 12:00:00.0"/>
>> > +
>> > + <Product productId="ENCHILADAS" productTypeId="AGGREGATED"
>> productName="Enchiladas" internalName="Enchiladas"
>> > description="Cheese enchiladas" isVirtual="N" isVariant="N"
>> billOfMaterialLevel="0" createdDate="2007-12-27 12:00:00.0"
>> > createdByUserLogin="admin"/>
>> > + <Product productId="FAJITA_BEEF" productTypeId="FINISHED_GOOD"
>> productName="Fajita beef" internalName="Fajita beef"
>> > description="Fajita beef" isVirtual="N" isVariant="N"
>> billOfMaterialLevel="0" createdDate="2007-12-27 12:00:00.0"
>> > createdByUserLogin="admin"/>
>> > + <Product productId="JALAPENOS" productTypeId="FINISHED_GOOD"
>> productName="Jalapenos" internalName="Jalapenos"
>> > description="Jalapenos" isVirtual="N" isVariant="N"
>> billOfMaterialLevel="0" createdDate="2007-12-27 12:00:00.0"
>> > createdByUserLogin="admin"/>
>> > +
>> > + <ProductPrice productId="ENCHILADAS"
>> productPricePurposeId="PURCHASE" productPriceTypeId="DEFAULT_PRICE"
>> currencyUomId="USD"
>> > productStoreGroupId="_NA_" fromDate="2007-12-27 12:00:00.0" price="6"
>> createdDate="2007-12-27 12:00:00.0"
>> > createdByUserLogin="admin"/>
>> > + <ProductPrice productId="FAJITA_BEEF"
>> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
>> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2007-12-27
>> 12:00:00.0" price="2" createdDate="2007-12-27 12:00:00.0"
>> > createdByUserLogin="admin"/>
>> > + <ProductPrice productId="FAJITA_BEEF"
>> productPricePurposeId="PURCHASE" productPriceTypeId="DEFAULT_PRICE"
>> currencyUomId="USD"
>> > productStoreGroupId="_NA_" fromDate="2007-12-27 12:00:00.0" price="8"
>> createdDate="2007-12-27 12:00:00.0"
>> > createdByUserLogin="admin"/>
>> > + <ProductPrice productId="JALAPENOS"
>> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
>> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2007-12-27
>> 12:00:00.0" price="0.75" createdDate="2007-12-27 12:00:00.0"
>> > createdByUserLogin="admin"/>
>> > +
>> > + <ProductConfigItem configItemId="TEXMEX0000"
>> configItemTypeId="SINGLE" configItemName="Enchiladas type"
>> description="Select
>> > cheese or beef (default to cheese):"/>
>> > + <ProductConfigItem configItemId="TEXMEX0001"
>> configItemTypeId="MULTIPLE" configItemName="Peppers" description="Add
>> jalapenos
>> > :"/>
>> > +
>> > + <ProductConfigProduct configItemId="TEXMEX0000"
>> configOptionId="OP010" productId="ENCHILADAS" quantity="1"/>
>> > + <ProductConfigProduct configItemId="TEXMEX0000"
>> configOptionId="OP011" productId="FAJITA_BEEF" quantity="1"/>
>> > + <ProductConfigProduct configItemId="TEXMEX0001"
>> configOptionId="OP012" productId="JALAPENOS" quantity="1"/>
>> > +
>> > + <ProductConfigOption configItemId="TEXMEX0000"
>> configOptionId="OP010" configOptionName="OPT001" description="Cheese
>> > enchiladas" sequenceNum="10"/>
>> > + <ProductConfigOption configItemId="TEXMEX0000"
>> configOptionId="OP011" configOptionName="OPT002" description="Fajita beef"
>> > sequenceNum="20"/>
>> > + <ProductConfigOption configItemId="TEXMEX0001"
>> configOptionId="OP012" configOptionName="OPT001" description="Jalapenos"
>> > sequenceNum="10"/>
>> > +
>> > + <ProductConfig productId="ENCHILADAS" configItemId="TEXMEX0000"
>> sequenceNum="10" fromDate="2004-08-20 12:59:26.209"
>> > description="Enchiladas type" defaultConfigOptionId="OP010"
>> configTypeId="QUESTION" isMandatory="Y"/>
>> > + <ProductConfig productId="ENCHILADAS" configItemId="TEXMEX0001"
>> sequenceNum="20" fromDate="2004-08-20 12:59:26.209"
>> > description="Peppers" configTypeId="QUESTION" isMandatory="N"/>
>> > +
>> > + <WorkEffort workEffortId="TASK11" workEffortTypeId="ROU_TASK"
>> workEffortPurposeTypeId="ROU_ASSEMBLING"
>> > currentStatusId="ROU_ACTIVE" workEffortName="Stock out"
>> description="Components" revisionNumber="1" fixedAssetId="DEMO_FOOD_GROUP"
>> > estimatedMilliSeconds="600000" estimatedSetupMillis="0"/>
>> > + <WorkEffort workEffortId="TASK12" workEffortTypeId="ROU_TASK"
>> workEffortPurposeTypeId="ROU_ASSEMBLING"
>> > currentStatusId="ROU_ACTIVE" workEffortName="Assembly"
>> description="Assembly" revisionNumber="1" fixedAssetId="DEMO_FOOD_GROUP"
>> > estimatedMilliSeconds="900000" estimatedSetupMillis="0"/>
>> > + <WorkEffort workEffortId="TASK13" workEffortTypeId="ROU_TASK"
>> workEffortPurposeTypeId="ROU_ASSEMBLING"
>> > currentStatusId="ROU_ACTIVE" workEffortName="Test" description="Test"
>> revisionNumber="1" fixedAssetId="DEMO_FOOD_GROUP"
>> > estimatedMilliSeconds="450000" estimatedSetupMillis="20000"/>
>> > + <WorkEffort workEffortId="ROUT11" workEffortTypeId="ROUTING"
>> currentStatusId="ROU_ACTIVE" workEffortName="Food delivery"
>> > description="Food delivery" revisionNumber="1" quantityToProduce="0"/>
>> > + <WorkEffortGoodStandard workEffortId="ROUT11"
>> productId="ENCHILADAS" workEffortGoodStdTypeId="ROU_PROD_TEMPLATE"
>> > statusId="WEGS_CREATED" fromDate="2007-12-27 12:00:00.0"/>
>> > + <WorkEffortAssoc workEffortIdFrom="ROUT11" workEffortIdTo="TASK11"
>> workEffortAssocTypeId="ROUTING_COMPONENT" sequenceNum="10"
>> > fromDate="2007-12-27 12:00:00.0"/>
>> > + <WorkEffortAssoc workEffortIdFrom="ROUT11" workEffortIdTo="TASK12"
>> workEffortAssocTypeId="ROUTING_COMPONENT" sequenceNum="20"
>> > fromDate="2007-12-27 12:00:00.0"/>
>> > + <WorkEffortAssoc workEffortIdFrom="ROUT11" workEffortIdTo="TASK13"
>> workEffortAssocTypeId="ROUTING_COMPONENT" sequenceNum="30"
>> > fromDate="2007-12-27 12:00:00.0"/>
>> > +
>> > + <ProductCategory productCategoryId="FOOD-001"
>> productCategoryTypeId="CATALOG_CATEGORY"/>
>> > + <ProductCategoryRollup fromDate="2007-12-27 12:00:00.0"
>> parentProductCategoryId="CATALOG1" productCategoryId="FOOD-001"/>
>> > + <ProductCategoryMember productCategoryId="PROMOTIONS"
>> productId="ENCHILADAS" fromDate="2007-12-27 12:00:00.0"/>
>> > + <ProductCategoryMember productCategoryId="FOOD-001"
>> productId="ENCHILADAS" fromDate="2007-12-27 12:00:00.0"/>
>> > + <ProductCategoryMember productCategoryId="CATALOG1_SEARCH"
>> productId="ENCHILADAS" fromDate="2007-12-27 12:00:00.0"/>
>> > +
>> > </entity-engine-xml>
>> >
>> > Modified: ofbiz/trunk/applications/ecommerce/data/DemoProductImages.xml
>> > URL:
>> >
>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/ecommerce/data/DemoProductImages.xml?rev=607090&r1=607089&r2=607090&view=diff
>> >
>> ==============================================================================
>> > --- ofbiz/trunk/applications/ecommerce/data/DemoProductImages.xml
>> (original)
>> > +++ ofbiz/trunk/applications/ecommerce/data/DemoProductImages.xml Thu
>> Dec 27 09:04:51 2007
>> > @@ -36,4 +36,5 @@
>> > <Product productId="PC001"
>> smallImageUrl="/images/products/small/gis_computer_glen_rolla.png"
>> > largeImageUrl="/images/products/large/gis_computer_glen_rolla.png"/>
>> > <Product productId="GC-001"
>> smallImageUrl="/images/products/small/certificate.png"
>> > largeImageUrl="/images/products/large/certificate.png"/>
>> > <Product productId="GC-002"
>> smallImageUrl="/images/products/small/certificate.png"
>> > largeImageUrl="/images/products/large/certificate.png"/>
>> > + <Product productId="ENCHILADAS"
>> smallImageUrl="/images/products/small/borsa_estiva_architetto.png"
>> > largeImageUrl="/images/products/large/borsa_estiva_architetto.png"/>
>> > </entity-engine-xml>
>> >
>> > Modified:
>> ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml
>> > URL:
>> >
>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml?rev=607090&r1=607089&r2=607090&view=diff
>> >
>> ==============================================================================
>> > ---
>> ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml
>> (original)
>> > +++
>> ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml Thu
>> Dec 27 09:04:51 2007
>> > @@ -29,7 +29,10 @@
>> > <TechDataCalendarWeek calendarWeekId="DEMO_WEEK" description="Demo
>> calendar week of 8hours/days 5days/week starting at 8h30
>> > from monday to friday" mondayStartTime="08:30:00" mondayCapacity="2.88E7"
>> tuesdayStartTime="08:30:00" tuesdayCapacity="2.88E7"
>> > wednesdayStartTime="08:30:00" wednesdayCapacity="2.88E7"
>> thursdayStartTime="08:30:00" thursdayCapacity="2.88E7"
>> > fridayStartTime="08:30:00" fridayCapacity="2.88E7"/>
>> > <TechDataCalendar calendarId="DEMO_CALENDAR" description="Demo
>> Workcenter Calendar" calendarWeekId="DEMO_WEEK"/>
>> > <TechDataCalendarExcDay calendarId="DEMO_CALENDAR"
>> exceptionDateStartTime="2004-12-24 00:01:00.0" exceptionCapacity="0"
>> > description="Christmas Day"/>
>> > -
>> > +
>> > <FixedAsset fixedAssetId="DEMO_MACHINE_GROUP"
>> fixedAssetTypeId="GROUP_EQUIPMENT" fixedAssetName="Demo Machine Group"/>
>> > <FixedAsset fixedAssetId="DEMO_MACHINE" fixedAssetName="Demo
>> Machine" fixedAssetTypeId="PRODUCTION_EQUIPMENT"
>> > parentFixedAssetId="DEMO_MACHINE_GROUP" calendarId="DEMO_CALENDAR"/>
>> > +
>> > + <FixedAsset fixedAssetId="DEMO_FOOD_GROUP"
>> fixedAssetTypeId="GROUP_EQUIPMENT" fixedAssetName="Demo Food Group"/>
>> > + <FixedAsset fixedAssetId="DEMO_FOOD" fixedAssetName="Demo Food"
>> fixedAssetTypeId="PRODUCTION_EQUIPMENT"
>> > parentFixedAssetId="DEMO_FOOD_GROUP" calendarId="DEMO_CALENDAR"/>
>> > </entity-engine-xml>
>> >
>> >
>> >
>>
>>
>
Re: svn commit: r607090 - in /ofbiz/trunk/applications: ecommerce/data/DemoConfigurator.xml ecommerce/data/DemoProductImages.xml manufacturing/data/ManufacturingExampleData.xml
Posted by pankaj savita <pa...@gmail.com>.
I think we must load the data for "ProductConfigOption" Entity before
"ProductConfigProduct" Entity inorder to avoid the foreign key constraint.
modifications required to make the Build Success in file
DemoConfigurator.xml are as follows :
<ProductConfigOption configItemId="TEXMEX0000" configOptionId="OP010"
configOptionName="OPT001" description="Cheese enchiladas" sequenceNum="10"/>
<ProductConfigOption configItemId="TEXMEX0000" configOptionId="OP011"
configOptionName="OPT002" description="Fajita beef" sequenceNum="20"/>
<ProductConfigOption configItemId="TEXMEX0001" configOptionId="OP012"
configOptionName="OPT001" description="Jalapenos" sequenceNum="10"/>
<ProductConfigProduct configItemId="TEXMEX0000" configOptionId="OP010"
productId="ENCHILADAS" quantity="1"/>
<ProductConfigProduct configItemId="TEXMEX0000" configOptionId="OP011"
productId="FAJITA_BEEF" quantity="1"/>
<ProductConfigProduct configItemId="TEXMEX0001" configOptionId="OP012"
productId="JALAPENOS" quantity="1"/>
--
Cheers,
Pankaj Savita
HotWax Media Inc.
Mailto: pankaj.savita@hotwaxmedia.com
Website: http://www.hotwaxmedia.com
On Dec 28, 2007 3:47 AM, Jacques Le Roux <ja...@les7arts.com>
wrote:
> I'm not sure why, I was able to import in Postgres but not in Derby (using
> Webtools/import text). I will see later..
>
> Jacques
>
> ----- Original Message -----
> From: <jl...@apache.org>
> To: <co...@ofbiz.apache.org>
> Sent: Thursday, December 27, 2007 6:04 PM
> Subject: svn commit: r607090 - in /ofbiz/trunk/applications:
> ecommerce/data/DemoConfigurator.xml
> ecommerce/data/DemoProductImages.xml
> manufacturing/data/ManufacturingExampleData.xml
>
>
> > Author: jleroux
> > Date: Thu Dec 27 09:04:51 2007
> > New Revision: 607090
> >
> > URL: http://svn.apache.org/viewvc?rev=607090&view=rev
> > Log:
> > New very simple aggregated product of type Food using Chris Lombardi's
> example in
> > https://issues.apache.org/jira/browse/OFBIZ-1495#action_12554443
> > I did real quick so maybe there are some changes to do...
> > I noticed one, we should find a generalised label for "verify
> configuration"
> >
> > Modified:
> > ofbiz/trunk/applications/ecommerce/data/DemoConfigurator.xml
> > ofbiz/trunk/applications/ecommerce/data/DemoProductImages.xml
> >
> ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml
> >
> > Modified: ofbiz/trunk/applications/ecommerce/data/DemoConfigurator.xml
> > URL:
> >
> http://svn.apache.org/viewvc/ofbiz/trunk/applications/ecommerce/data/DemoConfigurator.xml?rev=607090&r1=607089&r2=607090&view=diff
> >
> ==============================================================================
> > --- ofbiz/trunk/applications/ecommerce/data/DemoConfigurator.xml
> (original)
> > +++ ofbiz/trunk/applications/ecommerce/data/DemoConfigurator.xml Thu Dec
> 27 09:04:51 2007
> > @@ -20,17 +20,17 @@
> >
> > <entity-engine-xml>
> > <Product productId="PC001" productTypeId="AGGREGATED"
> productName="Configurable PC" internalName="Configurable PC"
> > description="Configurable PC" isVirtual="N" isVariant="N"
> billOfMaterialLevel="0" createdDate="2004-08-20 12:49:13.418"
> > createdByUserLogin="admin"/>
> > - <Product productId="RAM256_BRAND" productTypeId="FINISHED_GOOD"
> productName="RAM256" internalName="RAM 256 no parity"
> > description="1GB Dual Channel DDR2 SDRAM at 667MHz" isVirtual="N"
> isVariant="N" billOfMaterialLevel="0" createdDate="2004-08-20
> > 12:50:54.794" createdByUserLogin="admin"/>
> > - <Product productId="HD2GB_BRAND" productTypeId="FINISHED_GOOD"
> productName="HD2GB" internalName="HD 2 GB" description="250GB
> > Serial ATA Hard Drive (7200RPM)" isVirtual="N" isVariant="N"
> billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
> > createdByUserLogin="admin"/>
> > - <Product productId="HD4GB_BRAND" productTypeId="FINISHED_GOOD"
> productName="HD4GB" internalName="HD 4 GB" description="500GB
> > Serial ATA Hard Drive (7200RPM)" isVirtual="N" isVariant="N"
> billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
> > createdByUserLogin="admin"/>
> > + <Product productId="RAM1GB_BRAND" productTypeId="FINISHED_GOOD"
> productName="RAM1GB" internalName="RAM 1 GB DDR2"
> > description="1 GB Dual Channel DDR2 SDRAM" isVirtual="N" isVariant="N"
> billOfMaterialLevel="0" createdDate="2004-08-20
> > 12:50:54.794" createdByUserLogin="admin"/>
> > + <Product productId="HD250GB_BRAND" productTypeId="FINISHED_GOOD"
> productName="HD250GB" internalName="HD 250 GB"
> > description="250 GB Hard Drive" isVirtual="N" isVariant="N"
> billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
> > createdByUserLogin="admin"/>
> > + <Product productId="HD500GB_BRAND" productTypeId="FINISHED_GOOD"
> productName="HD500GB" internalName="HD 450 GB"
> > description="500 GB Hard Drive" isVirtual="N" isVariant="N"
> billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
> > createdByUserLogin="admin"/>
> > <Product productId="ETH_BRAND" productTypeId="FINISHED_GOOD"
> productName="Ethernet100" internalName="Ethernet Card 10/100"
> > description="Ethernet Card 10/100" isVirtual="N" isVariant="N"
> billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
> > createdByUserLogin="admin"/>
> > <Product productId="MOD_BRAND" productTypeId="FINISHED_GOOD"
> productName="Modem56k" internalName="Modem Card 56k"
> > description="Modem Card 56k" isVirtual="N" isVariant="N"
> billOfMaterialLevel="0" createdDate="2004-08-20 12:50:54.794"
> > createdByUserLogin="admin"/>
> > -
> > +
> > <ProductPrice productId="PC001" productPricePurposeId="PURCHASE"
> productPriceTypeId="DEFAULT_PRICE" currencyUomId="USD"
> > productStoreGroupId="_NA_" fromDate="2004-08-20 12:55:53.223" price="50"
> createdDate="2004-08-20 12:55:53.223"
> > createdByUserLogin="admin"/>
> > - <ProductPrice productId="RAM256_BRAND"
> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
> 12:55:53.223" price="115" createdDate="2004-08-20
> > 12:55:53.223" createdByUserLogin="admin"/>
> > - <ProductPrice productId="RAM256_BRAND"
> productPricePurposeId="PURCHASE" productPriceTypeId="DEFAULT_PRICE"
> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
> 12:55:36.479" price="120" createdDate="2004-08-20
> > 12:55:36.479" createdByUserLogin="admin"/>
> > - <ProductPrice productId="HD2GB_BRAND"
> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
> 12:55:53.223" price="220" createdDate="2004-08-20
> > 12:55:53.223" createdByUserLogin="admin"/>
> > - <ProductPrice productId="HD4GB_BRAND"
> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
> 12:55:36.479" price="420" createdDate="2004-08-20
> > 12:55:36.479" createdByUserLogin="admin"/>
> > + <ProductPrice productId="RAM1GB_BRAND"
> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
> 12:55:53.223" price="115" createdDate="2004-08-20
> > 12:55:53.223" createdByUserLogin="admin"/>
> > + <ProductPrice productId="RAM1GB_BRAND"
> productPricePurposeId="PURCHASE" productPriceTypeId="DEFAULT_PRICE"
> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
> 12:55:36.479" price="120" createdDate="2004-08-20
> > 12:55:36.479" createdByUserLogin="admin"/>
> > + <ProductPrice productId="HD250GB_BRAND"
> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
> 12:55:53.223" price="220" createdDate="2004-08-20
> > 12:55:53.223" createdByUserLogin="admin"/>
> > + <ProductPrice productId="HD500GB_BRAND"
> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
> 12:55:36.479" price="420" createdDate="2004-08-20
> > 12:55:36.479" createdByUserLogin="admin"/>
> > <ProductPrice productId="ETH_BRAND"
> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
> 12:55:36.479" price="18" createdDate="2004-08-20 12:55:36.479"
> > createdByUserLogin="admin"/>
> > <ProductPrice productId="MOD_BRAND"
> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2004-08-20
> 12:55:36.479" price="15" createdDate="2004-08-20 12:55:36.479"
> > createdByUserLogin="admin"/>
> >
> > @@ -45,10 +45,10 @@
> > <ProductConfigOption configItemId="IT0002" configOptionId="OP004"
> configOptionName="OPT001" description="Ethernet Card"
> > sequenceNum="10"/>
> > <ProductConfigOption configItemId="IT0002" configOptionId="OP005"
> configOptionName="OPT002" description="Modem 56k"
> > sequenceNum="20"/>
> >
> > - <ProductConfigProduct configItemId="IT0000" configOptionId="OP000"
> productId="RAM256_BRAND" quantity="1"/>
> > - <ProductConfigProduct configItemId="IT0000" configOptionId="OP001"
> productId="RAM256_BRAND" quantity="2"/>
> > - <ProductConfigProduct configItemId="IT0001" configOptionId="OP002"
> productId="HD2GB_BRAND" quantity="1"/>
> > - <ProductConfigProduct configItemId="IT0001" configOptionId="OP003"
> productId="HD4GB_BRAND" quantity="1"/>
> > + <ProductConfigProduct configItemId="IT0000" configOptionId="OP000"
> productId="RAM1GB_BRAND" quantity="1"/>
> > + <ProductConfigProduct configItemId="IT0000" configOptionId="OP001"
> productId="RAM1GB_BRAND" quantity="2"/>
> > + <ProductConfigProduct configItemId="IT0001" configOptionId="OP002"
> productId="HD250GB_BRAND" quantity="1"/>
> > + <ProductConfigProduct configItemId="IT0001" configOptionId="OP003"
> productId="HD500GB_BRAND" quantity="1"/>
> > <ProductConfigProduct configItemId="IT0002" configOptionId="OP004"
> productId="ETH_BRAND" quantity="1"/>
> > <ProductConfigProduct configItemId="IT0002" configOptionId="OP005"
> productId="MOD_BRAND" quantity="1"/>
> >
> > @@ -71,4 +71,43 @@
> > <ProductCategoryMember productCategoryId="PROMOTIONS"
> productId="PC001" fromDate="2001-05-13 12:00:00.0"/>
> > <ProductCategoryMember productCategoryId="PC-100" productId="PC001"
> fromDate="2001-05-13 12:00:00.0"/>
> > <ProductCategoryMember productCategoryId="CATALOG1_SEARCH"
> productId="PC001" fromDate="2001-05-13 12:00:00.0"/>
> > +
> > + <Product productId="ENCHILADAS" productTypeId="AGGREGATED"
> productName="Enchiladas" internalName="Enchiladas"
> > description="Cheese enchiladas" isVirtual="N" isVariant="N"
> billOfMaterialLevel="0" createdDate="2007-12-27 12:00:00.0"
> > createdByUserLogin="admin"/>
> > + <Product productId="FAJITA_BEEF" productTypeId="FINISHED_GOOD"
> productName="Fajita beef" internalName="Fajita beef"
> > description="Fajita beef" isVirtual="N" isVariant="N"
> billOfMaterialLevel="0" createdDate="2007-12-27 12:00:00.0"
> > createdByUserLogin="admin"/>
> > + <Product productId="JALAPENOS" productTypeId="FINISHED_GOOD"
> productName="Jalapenos" internalName="Jalapenos"
> > description="Jalapenos" isVirtual="N" isVariant="N"
> billOfMaterialLevel="0" createdDate="2007-12-27 12:00:00.0"
> > createdByUserLogin="admin"/>
> > +
> > + <ProductPrice productId="ENCHILADAS"
> productPricePurposeId="PURCHASE" productPriceTypeId="DEFAULT_PRICE"
> currencyUomId="USD"
> > productStoreGroupId="_NA_" fromDate="2007-12-27 12:00:00.0" price="6"
> createdDate="2007-12-27 12:00:00.0"
> > createdByUserLogin="admin"/>
> > + <ProductPrice productId="FAJITA_BEEF"
> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2007-12-27
> 12:00:00.0" price="2" createdDate="2007-12-27 12:00:00.0"
> > createdByUserLogin="admin"/>
> > + <ProductPrice productId="FAJITA_BEEF"
> productPricePurposeId="PURCHASE" productPriceTypeId="DEFAULT_PRICE"
> currencyUomId="USD"
> > productStoreGroupId="_NA_" fromDate="2007-12-27 12:00:00.0" price="8"
> createdDate="2007-12-27 12:00:00.0"
> > createdByUserLogin="admin"/>
> > + <ProductPrice productId="JALAPENOS"
> productPricePurposeId="COMPONENT_PRICE" productPriceTypeId="DEFAULT_PRICE"
> > currencyUomId="USD" productStoreGroupId="_NA_" fromDate="2007-12-27
> 12:00:00.0" price="0.75" createdDate="2007-12-27 12:00:00.0"
> > createdByUserLogin="admin"/>
> > +
> > + <ProductConfigItem configItemId="TEXMEX0000"
> configItemTypeId="SINGLE" configItemName="Enchiladas type"
> description="Select
> > cheese or beef (default to cheese):"/>
> > + <ProductConfigItem configItemId="TEXMEX0001"
> configItemTypeId="MULTIPLE" configItemName="Peppers" description="Add
> jalapenos
> > :"/>
> > +
> > + <ProductConfigProduct configItemId="TEXMEX0000"
> configOptionId="OP010" productId="ENCHILADAS" quantity="1"/>
> > + <ProductConfigProduct configItemId="TEXMEX0000"
> configOptionId="OP011" productId="FAJITA_BEEF" quantity="1"/>
> > + <ProductConfigProduct configItemId="TEXMEX0001"
> configOptionId="OP012" productId="JALAPENOS" quantity="1"/>
> > +
> > + <ProductConfigOption configItemId="TEXMEX0000"
> configOptionId="OP010" configOptionName="OPT001" description="Cheese
> > enchiladas" sequenceNum="10"/>
> > + <ProductConfigOption configItemId="TEXMEX0000"
> configOptionId="OP011" configOptionName="OPT002" description="Fajita beef"
> > sequenceNum="20"/>
> > + <ProductConfigOption configItemId="TEXMEX0001"
> configOptionId="OP012" configOptionName="OPT001" description="Jalapenos"
> > sequenceNum="10"/>
> > +
> > + <ProductConfig productId="ENCHILADAS" configItemId="TEXMEX0000"
> sequenceNum="10" fromDate="2004-08-20 12:59:26.209"
> > description="Enchiladas type" defaultConfigOptionId="OP010"
> configTypeId="QUESTION" isMandatory="Y"/>
> > + <ProductConfig productId="ENCHILADAS" configItemId="TEXMEX0001"
> sequenceNum="20" fromDate="2004-08-20 12:59:26.209"
> > description="Peppers" configTypeId="QUESTION" isMandatory="N"/>
> > +
> > + <WorkEffort workEffortId="TASK11" workEffortTypeId="ROU_TASK"
> workEffortPurposeTypeId="ROU_ASSEMBLING"
> > currentStatusId="ROU_ACTIVE" workEffortName="Stock out"
> description="Components" revisionNumber="1" fixedAssetId="DEMO_FOOD_GROUP"
> > estimatedMilliSeconds="600000" estimatedSetupMillis="0"/>
> > + <WorkEffort workEffortId="TASK12" workEffortTypeId="ROU_TASK"
> workEffortPurposeTypeId="ROU_ASSEMBLING"
> > currentStatusId="ROU_ACTIVE" workEffortName="Assembly"
> description="Assembly" revisionNumber="1" fixedAssetId="DEMO_FOOD_GROUP"
> > estimatedMilliSeconds="900000" estimatedSetupMillis="0"/>
> > + <WorkEffort workEffortId="TASK13" workEffortTypeId="ROU_TASK"
> workEffortPurposeTypeId="ROU_ASSEMBLING"
> > currentStatusId="ROU_ACTIVE" workEffortName="Test" description="Test"
> revisionNumber="1" fixedAssetId="DEMO_FOOD_GROUP"
> > estimatedMilliSeconds="450000" estimatedSetupMillis="20000"/>
> > + <WorkEffort workEffortId="ROUT11" workEffortTypeId="ROUTING"
> currentStatusId="ROU_ACTIVE" workEffortName="Food delivery"
> > description="Food delivery" revisionNumber="1" quantityToProduce="0"/>
> > + <WorkEffortGoodStandard workEffortId="ROUT11"
> productId="ENCHILADAS" workEffortGoodStdTypeId="ROU_PROD_TEMPLATE"
> > statusId="WEGS_CREATED" fromDate="2007-12-27 12:00:00.0"/>
> > + <WorkEffortAssoc workEffortIdFrom="ROUT11" workEffortIdTo="TASK11"
> workEffortAssocTypeId="ROUTING_COMPONENT" sequenceNum="10"
> > fromDate="2007-12-27 12:00:00.0"/>
> > + <WorkEffortAssoc workEffortIdFrom="ROUT11" workEffortIdTo="TASK12"
> workEffortAssocTypeId="ROUTING_COMPONENT" sequenceNum="20"
> > fromDate="2007-12-27 12:00:00.0"/>
> > + <WorkEffortAssoc workEffortIdFrom="ROUT11" workEffortIdTo="TASK13"
> workEffortAssocTypeId="ROUTING_COMPONENT" sequenceNum="30"
> > fromDate="2007-12-27 12:00:00.0"/>
> > +
> > + <ProductCategory productCategoryId="FOOD-001"
> productCategoryTypeId="CATALOG_CATEGORY"/>
> > + <ProductCategoryRollup fromDate="2007-12-27 12:00:00.0"
> parentProductCategoryId="CATALOG1" productCategoryId="FOOD-001"/>
> > + <ProductCategoryMember productCategoryId="PROMOTIONS"
> productId="ENCHILADAS" fromDate="2007-12-27 12:00:00.0"/>
> > + <ProductCategoryMember productCategoryId="FOOD-001"
> productId="ENCHILADAS" fromDate="2007-12-27 12:00:00.0"/>
> > + <ProductCategoryMember productCategoryId="CATALOG1_SEARCH"
> productId="ENCHILADAS" fromDate="2007-12-27 12:00:00.0"/>
> > +
> > </entity-engine-xml>
> >
> > Modified: ofbiz/trunk/applications/ecommerce/data/DemoProductImages.xml
> > URL:
> >
> http://svn.apache.org/viewvc/ofbiz/trunk/applications/ecommerce/data/DemoProductImages.xml?rev=607090&r1=607089&r2=607090&view=diff
> >
> ==============================================================================
> > --- ofbiz/trunk/applications/ecommerce/data/DemoProductImages.xml
> (original)
> > +++ ofbiz/trunk/applications/ecommerce/data/DemoProductImages.xml Thu
> Dec 27 09:04:51 2007
> > @@ -36,4 +36,5 @@
> > <Product productId="PC001"
> smallImageUrl="/images/products/small/gis_computer_glen_rolla.png"
> > largeImageUrl="/images/products/large/gis_computer_glen_rolla.png"/>
> > <Product productId="GC-001"
> smallImageUrl="/images/products/small/certificate.png"
> > largeImageUrl="/images/products/large/certificate.png"/>
> > <Product productId="GC-002"
> smallImageUrl="/images/products/small/certificate.png"
> > largeImageUrl="/images/products/large/certificate.png"/>
> > + <Product productId="ENCHILADAS"
> smallImageUrl="/images/products/small/borsa_estiva_architetto.png"
> > largeImageUrl="/images/products/large/borsa_estiva_architetto.png"/>
> > </entity-engine-xml>
> >
> > Modified:
> ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml
> > URL:
> >
> http://svn.apache.org/viewvc/ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml?rev=607090&r1=607089&r2=607090&view=diff
> >
> ==============================================================================
> > ---
> ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml
> (original)
> > +++
> ofbiz/trunk/applications/manufacturing/data/ManufacturingExampleData.xml Thu
> Dec 27 09:04:51 2007
> > @@ -29,7 +29,10 @@
> > <TechDataCalendarWeek calendarWeekId="DEMO_WEEK" description="Demo
> calendar week of 8hours/days 5days/week starting at 8h30
> > from monday to friday" mondayStartTime="08:30:00" mondayCapacity="2.88E7"
> tuesdayStartTime="08:30:00" tuesdayCapacity="2.88E7"
> > wednesdayStartTime="08:30:00" wednesdayCapacity="2.88E7"
> thursdayStartTime="08:30:00" thursdayCapacity="2.88E7"
> > fridayStartTime="08:30:00" fridayCapacity="2.88E7"/>
> > <TechDataCalendar calendarId="DEMO_CALENDAR" description="Demo
> Workcenter Calendar" calendarWeekId="DEMO_WEEK"/>
> > <TechDataCalendarExcDay calendarId="DEMO_CALENDAR"
> exceptionDateStartTime="2004-12-24 00:01:00.0" exceptionCapacity="0"
> > description="Christmas Day"/>
> > -
> > +
> > <FixedAsset fixedAssetId="DEMO_MACHINE_GROUP"
> fixedAssetTypeId="GROUP_EQUIPMENT" fixedAssetName="Demo Machine Group"/>
> > <FixedAsset fixedAssetId="DEMO_MACHINE" fixedAssetName="Demo
> Machine" fixedAssetTypeId="PRODUCTION_EQUIPMENT"
> > parentFixedAssetId="DEMO_MACHINE_GROUP" calendarId="DEMO_CALENDAR"/>
> > +
> > + <FixedAsset fixedAssetId="DEMO_FOOD_GROUP"
> fixedAssetTypeId="GROUP_EQUIPMENT" fixedAssetName="Demo Food Group"/>
> > + <FixedAsset fixedAssetId="DEMO_FOOD" fixedAssetName="Demo Food"
> fixedAssetTypeId="PRODUCTION_EQUIPMENT"
> > parentFixedAssetId="DEMO_FOOD_GROUP" calendarId="DEMO_CALENDAR"/>
> > </entity-engine-xml>
> >
> >
> >
>
>