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: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
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>
