Author: jonesde
Date: Fri Sep 21 00:21:44 2007 New Revision: 578004 URL: http://svn.apache.org/viewvc?rev=578004&view=rev Log: Data cleanup, mostly killing data that the entity engine maintains Modified: ofbiz/trunk/applications/ecommerce/data/DemoRentalProduct.xml ofbiz/trunk/applications/ecommerce/data/DemoSurvey.xml Modified: ofbiz/trunk/applications/ecommerce/data/DemoRentalProduct.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/ecommerce/data/DemoRentalProduct.xml?rev=578004&r1=578003&r2=578004&view=diff ============================================================================== --- ofbiz/trunk/applications/ecommerce/data/DemoRentalProduct.xml (original) +++ ofbiz/trunk/applications/ecommerce/data/DemoRentalProduct.xml Fri Sep 21 00:21:44 2007 @@ -97,13 +97,13 @@ <ProductCategory description="Speed Boats" longDescription="long description of Speed Boats" primaryParentCategoryId="BoatRental" productCategoryId="SpeedBoats" productCategoryTypeId="CATALOG_CATEGORY"/> - <ProductCategoryRollup productCategoryId="ConfRooms" parentProductCategoryId="HotelFac" fromDate="2004-10-18 15:21:07.613" lastUpdatedStamp="2004-10-18 15:21:13.066" lastUpdatedTxStamp="2004-10-18 15:21:13.066" createdStamp="2004-10-18 15:21:13.066" createdTxStamp="2004-10-18 15:21:13.066"/> - <ProductCategoryRollup productCategoryId="Rooms" parentProductCategoryId="HotelFac" fromDate="2004-10-18 15:22:29.139" lastUpdatedStamp="2004-10-18 15:22:34.937" lastUpdatedTxStamp="2004-10-18 15:22:34.937" createdStamp="2004-10-18 15:22:34.937" createdTxStamp="2004-10-18 15:22:34.937"/> - <ProductCategoryRollup productCategoryId="Suites" parentProductCategoryId="HotelFac" fromDate="2004-10-18 15:23:05.706" lastUpdatedStamp="2004-10-18 15:23:10.615" lastUpdatedTxStamp="2004-10-18 15:23:10.615" createdStamp="2004-10-18 15:23:10.615" createdTxStamp="2004-10-18 15:23:10.615"/> - <ProductCategoryRollup productCategoryId="SpeedBoats" parentProductCategoryId="BoatRental" fromDate="2004-10-18 15:23:54.452" lastUpdatedStamp="2004-10-18 15:23:59.363" lastUpdatedTxStamp="2004-10-18 15:23:59.363" createdStamp="2004-10-18 15:23:59.363" createdTxStamp="2004-10-18 15:23:59.363"/> - <ProductCategoryRollup productCategoryId="MotorBoats" parentProductCategoryId="BoatRental" fromDate="2004-10-18 15:30:56.77" lastUpdatedStamp="2004-10-18 15:31:07.867" lastUpdatedTxStamp="2004-10-18 15:31:07.867" createdStamp="2004-10-18 15:31:07.867" createdTxStamp="2004-10-18 15:31:07.867"/> - <ProductCategoryRollup productCategoryId="RowBoats" parentProductCategoryId="BoatRental" fromDate="2004-10-18 15:32:27.359" lastUpdatedStamp="2004-10-18 15:32:32.796" lastUpdatedTxStamp="2004-10-18 15:32:32.796" createdStamp="2004-10-18 15:32:32.796" createdTxStamp="2004-10-18 15:32:32.796"/> - <ProductCategoryRollup productCategoryId="SailBoats" parentProductCategoryId="BoatRental" fromDate="2004-10-18 15:32:48.86" lastUpdatedStamp="2004-10-18 15:32:52.325" lastUpdatedTxStamp="2004-10-18 15:32:52.325" createdStamp="2004-10-18 15:32:52.325" createdTxStamp="2004-10-18 15:32:52.325"/> + <ProductCategoryRollup productCategoryId="ConfRooms" parentProductCategoryId="HotelFac" fromDate="2004-10-18 15:21:07.613"/> + <ProductCategoryRollup productCategoryId="Rooms" parentProductCategoryId="HotelFac" fromDate="2004-10-18 15:22:29.139"/> + <ProductCategoryRollup productCategoryId="Suites" parentProductCategoryId="HotelFac" fromDate="2004-10-18 15:23:05.706"/> + <ProductCategoryRollup productCategoryId="SpeedBoats" parentProductCategoryId="BoatRental" fromDate="2004-10-18 15:23:54.452"/> + <ProductCategoryRollup productCategoryId="MotorBoats" parentProductCategoryId="BoatRental" fromDate="2004-10-18 15:30:56.77"/> + <ProductCategoryRollup productCategoryId="RowBoats" parentProductCategoryId="BoatRental" fromDate="2004-10-18 15:32:27.359"/> + <ProductCategoryRollup productCategoryId="SailBoats" parentProductCategoryId="BoatRental" fromDate="2004-10-18 15:32:48.86"/> <!-- categories for e-commerce --> <ProdCatalogCategory prodCatalogId="RentalCatalog" productCategoryId="RentBrowseRoot" fromDate="2001-05-13 12:00:00.0" @@ -142,7 +142,7 @@ <ProductPrice productId="Cap" productPricePurposeId="PURCHASE" productPriceTypeId="DEFAULT_PRICE" currencyUomId="EUR" productStoreGroupId="_NA_" fromDate="2003-03-04 18:50:45.25" price="5.99" createdDate="2001-05-13 12:00:00.0" createdByUserLogin="admin" lastModifiedDate="2001-05-13 12:00:00.0" lastModifiedByUserLogin="admin"/> <!-- allocate products to categories --> - <ProductCategoryMember productCategoryId="RentalPromo" productId="RoomLux" fromDate="2004-10-18 20:39:58.563" lastUpdatedStamp="2004-10-18 20:40:12.411" lastUpdatedTxStamp="2004-10-18 20:40:12.411" createdStamp="2004-10-18 20:40:12.411" createdTxStamp="2004-10-18 20:40:12.411"/> - <ProductCategoryMember productCategoryId="RentalPromo" productId="RoomStd" fromDate="2004-10-18 20:40:12.749" lastUpdatedStamp="2004-10-18 20:40:30.044" lastUpdatedTxStamp="2004-10-18 20:40:30.044" createdStamp="2004-10-18 20:40:30.044" createdTxStamp="2004-10-18 20:40:30.044"/> - <ProductCategoryMember productCategoryId="RentalPromo" productId="Cap" fromDate="2004-10-18 20:40:12.749" lastUpdatedStamp="2004-10-18 20:40:30.044" lastUpdatedTxStamp="2004-10-18 20:40:30.044" createdStamp="2004-10-18 20:40:30.044" createdTxStamp="2004-10-18 20:40:30.044"/> + <ProductCategoryMember productCategoryId="RentalPromo" productId="RoomLux" fromDate="2004-10-18 20:39:58.563"/> + <ProductCategoryMember productCategoryId="RentalPromo" productId="RoomStd" fromDate="2004-10-18 20:40:12.749"/> + <ProductCategoryMember productCategoryId="RentalPromo" productId="Cap" fromDate="2004-10-18 20:40:12.749"/> </entity-engine-xml> Modified: ofbiz/trunk/applications/ecommerce/data/DemoSurvey.xml URL: http://svn.apache.org/viewvc/ofbiz/trunk/applications/ecommerce/data/DemoSurvey.xml?rev=578004&r1=578003&r2=578004&view=diff ============================================================================== --- ofbiz/trunk/applications/ecommerce/data/DemoSurvey.xml (original) +++ ofbiz/trunk/applications/ecommerce/data/DemoSurvey.xml Fri Sep 21 00:21:44 2007 @@ -19,11 +19,11 @@ --> <entity-engine-xml> - <Survey surveyId="1000" description="Gift Card Purchase Information" isAnonymous="Y" allowMultiple="Y" allowUpdate="N" lastUpdatedStamp="2003-12-05 16:49:33.835" lastUpdatedTxStamp="2003-12-05 16:49:33.835"/> - <Survey surveyId="1001" description="Gift Card Reload Information" isAnonymous="Y" allowMultiple="Y" allowUpdate="N" lastUpdatedStamp="2003-12-05 16:49:41.943" lastUpdatedTxStamp="2003-12-05 16:49:41.943"/> - <Survey surveyId="1002" surveyName="Shopping Survey" description="Tell us about your on-line shopping patterns" submitCaption="Complete Survey" comments="Your answers will help us serve you better" isAnonymous="N" allowMultiple="Y" allowUpdate="Y" lastUpdatedStamp="2003-12-05 19:11:04.883" lastUpdatedTxStamp="2003-12-05 19:11:04.883"/> - <Survey surveyId="1003" surveyName="Mini-Poll Poll" description="Tell us where the mini-poll should go" submitCaption="Vote!" isAnonymous="N" allowMultiple="N" allowUpdate="N" lastUpdatedStamp="2003-12-05 19:11:04.883" lastUpdatedTxStamp="2003-12-05 19:11:04.883"/> - <Survey surveyId="1004" surveyName="Mouse Hand Poll" description="Your mouse hand is" isAnonymous="N" allowMultiple="N" allowUpdate="N" lastUpdatedStamp="2003-12-05 19:11:04.883" lastUpdatedTxStamp="2003-12-05 19:11:04.883"/> + <Survey surveyId="1000" description="Gift Card Purchase Information" isAnonymous="Y" allowMultiple="Y" allowUpdate="N"/> + <Survey surveyId="1001" description="Gift Card Reload Information" isAnonymous="Y" allowMultiple="Y" allowUpdate="N"/> + <Survey surveyId="1002" surveyName="Shopping Survey" description="Tell us about your on-line shopping patterns" submitCaption="Complete Survey" comments="Your answers will help us serve you better" isAnonymous="N" allowMultiple="Y" allowUpdate="Y"/> + <Survey surveyId="1003" surveyName="Mini-Poll Poll" description="Tell us where the mini-poll should go" submitCaption="Vote!" isAnonymous="N" allowMultiple="N" allowUpdate="N"/> + <Survey surveyId="1004" surveyName="Mouse Hand Poll" description="Your mouse hand is" isAnonymous="N" allowMultiple="N" allowUpdate="N"/> <SurveyPage surveyId="1002" surveyPageSeqId="01" pageName="Shopping Survey Page 1" sequenceNum="1"/> <SurveyPage surveyId="1002" surveyPageSeqId="02" pageName="Shopping Survey Page 2" sequenceNum="2"/> @@ -33,80 +33,80 @@ <SurveyMultiRespColumn surveyId="1002" surveyMultiRespId="01" surveyMultiRespColId="02" columnTitle="Last Six Months" sequenceNum="2"/> <SurveyMultiRespColumn surveyId="1002" surveyMultiRespId="01" surveyMultiRespColId="03" columnTitle="Last Year" sequenceNum="3"/> - <SurveyQuestionCategory surveyQuestionCategoryId="1000" description="Gift Card Purchase Questions" lastUpdatedStamp="2003-12-04 21:40:23.207" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> - <SurveyQuestionCategory surveyQuestionCategoryId="1001" description="Shopping Questions" lastUpdatedStamp="2003-12-05 19:11:18.736" lastUpdatedTxStamp="2003-12-05 19:11:18.736"/> - <SurveyQuestionCategory surveyQuestionCategoryId="1002" description="Poll Questions" lastUpdatedStamp="2003-12-05 19:11:18.736" lastUpdatedTxStamp="2003-12-05 19:11:18.736"/> - - <SurveyQuestion surveyQuestionId="1000" surveyQuestionCategoryId="1000" surveyQuestionTypeId="TEXT_LONG" description="senderName" question="Sender's Name:" lastUpdatedStamp="2003-12-04 21:40:23.216" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> - <SurveyQuestion surveyQuestionId="1001" surveyQuestionCategoryId="1000" surveyQuestionTypeId="TEXT_LONG" description="recipientName" question="Recipient's Name:" lastUpdatedStamp="2003-12-04 21:40:23.222" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> - <SurveyQuestion surveyQuestionId="1002" surveyQuestionCategoryId="1000" surveyQuestionTypeId="EMAIL" description="recipientEmail" question="Recipient's Email:" lastUpdatedStamp="2003-12-04 21:40:23.225" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> - <SurveyQuestion surveyQuestionId="1003" surveyQuestionCategoryId="1000" surveyQuestionTypeId="TEXTAREA" description="giftMessage" question="Gift Message:" lastUpdatedStamp="2003-12-04 21:40:23.228" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> - <SurveyQuestion surveyQuestionId="1010" surveyQuestionCategoryId="1000" surveyQuestionTypeId="GIFT_CARD" description="giftCardNumber" question="Gift Card Number:" lastUpdatedStamp="2003-12-04 21:40:23.251" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> - <SurveyQuestion surveyQuestionId="1011" surveyQuestionCategoryId="1000" surveyQuestionTypeId="TEXT_SHORT" description="giftCardPin" question="PIN Number:" lastUpdatedStamp="2003-12-04 21:40:23.255" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> - - <SurveyQuestion surveyQuestionId="1030" surveyQuestionCategoryId="1001" surveyQuestionTypeId="OPTION" question="How often to you shop on-line?" lastUpdatedStamp="2003-12-05 19:12:29.893" lastUpdatedTxStamp="2003-12-05 19:12:29.893"/> - <SurveyQuestion surveyQuestionId="1031" surveyQuestionCategoryId="1001" surveyQuestionTypeId="BOOLEAN" question="Have you shopped here?" lastUpdatedStamp="2003-12-05 19:13:51.109" lastUpdatedTxStamp="2003-12-05 19:13:51.109"/> - <SurveyQuestion surveyQuestionId="1031B" surveyQuestionCategoryId="1001" surveyQuestionTypeId="BOOLEAN" question="Have you shopped here in the last six months?" lastUpdatedStamp="2003-12-05 19:13:51.109" lastUpdatedTxStamp="2003-12-05 19:13:51.109"/> - <SurveyQuestion surveyQuestionId="1031C" surveyQuestionCategoryId="1001" surveyQuestionTypeId="BOOLEAN" question="Have you shopped here in the last year?" lastUpdatedStamp="2003-12-05 19:13:51.109" lastUpdatedTxStamp="2003-12-05 19:13:51.109"/> - <SurveyQuestion surveyQuestionId="1032" surveyQuestionCategoryId="1001" surveyQuestionTypeId="SEPERATOR_LINE" lastUpdatedStamp="2003-12-05 19:14:08.69" lastUpdatedTxStamp="2003-12-05 19:14:08.69"/> - <SurveyQuestion surveyQuestionId="1033" surveyQuestionCategoryId="1001" surveyQuestionTypeId="OPTION" question="How would you rate this store for products?" lastUpdatedStamp="2003-12-05 19:14:46.222" lastUpdatedTxStamp="2003-12-05 19:14:46.222"/> - <SurveyQuestion surveyQuestionId="1034" surveyQuestionCategoryId="1001" surveyQuestionTypeId="OPTION" question="How would you rate this store for on-line functionality?" lastUpdatedStamp="2003-12-05 19:18:06.783" lastUpdatedTxStamp="2003-12-05 19:18:06.783"/> - <SurveyQuestion surveyQuestionId="1035" surveyQuestionCategoryId="1001" surveyQuestionTypeId="URL" question="What is your favorite on-line store? (Enter Valid URL)" lastUpdatedStamp="2003-12-05 19:19:04.538" lastUpdatedTxStamp="2003-12-05 19:19:04.538"/> - <SurveyQuestion surveyQuestionId="1036" surveyQuestionCategoryId="1001" surveyQuestionTypeId="TEXTAREA" question="Comments:" lastUpdatedStamp="2003-12-05 19:19:22.968" lastUpdatedTxStamp="2003-12-05 19:19:22.968"/> - <SurveyQuestion surveyQuestionId="1037" surveyQuestionCategoryId="1001" surveyQuestionTypeId="SEPERATOR_TEXT" question="<img src="http://localhost:8080/images/ofbiz_logo.jpg">" lastUpdatedStamp="2003-12-05 19:20:09.053" lastUpdatedTxStamp="2003-12-05 19:20:09.052"/> - <SurveyQuestion surveyQuestionId="1038" surveyQuestionCategoryId="1001" surveyQuestionTypeId="SEPERATOR_LINE" lastUpdatedStamp="2003-12-05 19:21:53.36" lastUpdatedTxStamp="2003-12-05 19:21:53.36"/> - <SurveyQuestion surveyQuestionId="1042" surveyQuestionCategoryId="1001" surveyQuestionTypeId="CONTENT" question="Do you have a picture you would like to attach?" lastUpdatedStamp="2004-09-14 17:59:27.115" lastUpdatedTxStamp="2004-09-14 17:59:27.115"/> + <SurveyQuestionCategory surveyQuestionCategoryId="1000" description="Gift Card Purchase Questions"/> + <SurveyQuestionCategory surveyQuestionCategoryId="1001" description="Shopping Questions"/> + <SurveyQuestionCategory surveyQuestionCategoryId="1002" description="Poll Questions"/> + + <SurveyQuestion surveyQuestionId="1000" surveyQuestionCategoryId="1000" surveyQuestionTypeId="TEXT_LONG" description="senderName" question="Sender's Name:"/> + <SurveyQuestion surveyQuestionId="1001" surveyQuestionCategoryId="1000" surveyQuestionTypeId="TEXT_LONG" description="recipientName" question="Recipient's Name:"/> + <SurveyQuestion surveyQuestionId="1002" surveyQuestionCategoryId="1000" surveyQuestionTypeId="EMAIL" description="recipientEmail" question="Recipient's Email:"/> + <SurveyQuestion surveyQuestionId="1003" surveyQuestionCategoryId="1000" surveyQuestionTypeId="TEXTAREA" description="giftMessage" question="Gift Message:"/> + <SurveyQuestion surveyQuestionId="1010" surveyQuestionCategoryId="1000" surveyQuestionTypeId="GIFT_CARD" description="giftCardNumber" question="Gift Card Number:"/> + <SurveyQuestion surveyQuestionId="1011" surveyQuestionCategoryId="1000" surveyQuestionTypeId="TEXT_SHORT" description="giftCardPin" question="PIN Number:"/> + + <SurveyQuestion surveyQuestionId="1030" surveyQuestionCategoryId="1001" surveyQuestionTypeId="OPTION" question="How often to you shop on-line?"/> + <SurveyQuestion surveyQuestionId="1031" surveyQuestionCategoryId="1001" surveyQuestionTypeId="BOOLEAN" question="Have you shopped here?"/> + <SurveyQuestion surveyQuestionId="1031B" surveyQuestionCategoryId="1001" surveyQuestionTypeId="BOOLEAN" question="Have you shopped here in the last six months?"/> + <SurveyQuestion surveyQuestionId="1031C" surveyQuestionCategoryId="1001" surveyQuestionTypeId="BOOLEAN" question="Have you shopped here in the last year?"/> + <SurveyQuestion surveyQuestionId="1032" surveyQuestionCategoryId="1001" surveyQuestionTypeId="SEPERATOR_LINE"/> + <SurveyQuestion surveyQuestionId="1033" surveyQuestionCategoryId="1001" surveyQuestionTypeId="OPTION" question="How would you rate this store for products?"/> + <SurveyQuestion surveyQuestionId="1034" surveyQuestionCategoryId="1001" surveyQuestionTypeId="OPTION" question="How would you rate this store for on-line functionality?"/> + <SurveyQuestion surveyQuestionId="1035" surveyQuestionCategoryId="1001" surveyQuestionTypeId="URL" question="What is your favorite on-line store? (Enter Valid URL)"/> + <SurveyQuestion surveyQuestionId="1036" surveyQuestionCategoryId="1001" surveyQuestionTypeId="TEXTAREA" question="Comments:"/> + <SurveyQuestion surveyQuestionId="1037" surveyQuestionCategoryId="1001" surveyQuestionTypeId="SEPERATOR_TEXT" question="<img src="http://localhost:8080/images/ofbiz_logo.jpg">"/> + <SurveyQuestion surveyQuestionId="1038" surveyQuestionCategoryId="1001" surveyQuestionTypeId="SEPERATOR_LINE"/> + <SurveyQuestion surveyQuestionId="1042" surveyQuestionCategoryId="1001" surveyQuestionTypeId="CONTENT" question="Do you have a picture you would like to attach?"/> - <SurveyQuestion surveyQuestionId="1040" surveyQuestionCategoryId="1002" surveyQuestionTypeId="OPTION" question="Which side should the mini-poll box show?" lastUpdatedStamp="2003-12-05 19:12:29.893" lastUpdatedTxStamp="2003-12-05 19:12:29.893"/> - <SurveyQuestion surveyQuestionId="1041" surveyQuestionCategoryId="1002" surveyQuestionTypeId="OPTION" question="Which hand do you use your mouse with?" lastUpdatedStamp="2003-12-05 19:12:29.893" lastUpdatedTxStamp="2003-12-05 19:12:29.893"/> + <SurveyQuestion surveyQuestionId="1040" surveyQuestionCategoryId="1002" surveyQuestionTypeId="OPTION" question="Which side should the mini-poll box show?"/> + <SurveyQuestion surveyQuestionId="1041" surveyQuestionCategoryId="1002" surveyQuestionTypeId="OPTION" question="Which hand do you use your mouse with?"/> - <SurveyQuestionAppl surveyId="1000" surveyQuestionId="1000" fromDate="2001-01-01 00:00:00.0" requiredField="Y" sequenceNum="1" lastUpdatedStamp="2003-12-04 21:40:23.233" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> - <SurveyQuestionAppl surveyId="1000" surveyQuestionId="1001" fromDate="2001-01-01 00:00:00.0" requiredField="Y" sequenceNum="2" lastUpdatedStamp="2003-12-04 21:40:23.239" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> - <SurveyQuestionAppl surveyId="1000" surveyQuestionId="1002" fromDate="2001-01-01 00:00:00.0" requiredField="Y" sequenceNum="3" lastUpdatedStamp="2003-12-04 21:40:23.242" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> - <SurveyQuestionAppl surveyId="1000" surveyQuestionId="1003" fromDate="2001-01-01 00:00:00.0" requiredField="N" sequenceNum="4" lastUpdatedStamp="2003-12-04 21:40:23.245" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> - <SurveyQuestionAppl surveyId="1001" surveyQuestionId="1010" fromDate="2001-01-01 00:00:00.0" requiredField="Y" sequenceNum="1" lastUpdatedStamp="2003-12-04 21:40:23.259" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> - <SurveyQuestionAppl surveyId="1001" surveyQuestionId="1011" fromDate="2001-01-01 00:00:00.0" requiredField="Y" sequenceNum="2" lastUpdatedStamp="2003-12-04 21:40:23.262" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> + <SurveyQuestionAppl surveyId="1000" surveyQuestionId="1000" fromDate="2001-01-01 00:00:00.0" requiredField="Y" sequenceNum="1"/> + <SurveyQuestionAppl surveyId="1000" surveyQuestionId="1001" fromDate="2001-01-01 00:00:00.0" requiredField="Y" sequenceNum="2"/> + <SurveyQuestionAppl surveyId="1000" surveyQuestionId="1002" fromDate="2001-01-01 00:00:00.0" requiredField="Y" sequenceNum="3"/> + <SurveyQuestionAppl surveyId="1000" surveyQuestionId="1003" fromDate="2001-01-01 00:00:00.0" requiredField="N" sequenceNum="4"/> + <SurveyQuestionAppl surveyId="1001" surveyQuestionId="1010" fromDate="2001-01-01 00:00:00.0" requiredField="Y" sequenceNum="1"/> + <SurveyQuestionAppl surveyId="1001" surveyQuestionId="1011" fromDate="2001-01-01 00:00:00.0" requiredField="Y" sequenceNum="2"/> - <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1037" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="01" sequenceNum="1" requiredField="N" lastUpdatedStamp="2003-12-05 19:20:12.398" lastUpdatedTxStamp="2003-12-05 19:20:12.398"/> - <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1030" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="01" sequenceNum="2" requiredField="Y" lastUpdatedStamp="2003-12-05 19:20:18.967" lastUpdatedTxStamp="2003-12-05 19:20:18.967"/> + <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1037" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="01" sequenceNum="1" requiredField="N"/> + <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1030" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="01" sequenceNum="2" requiredField="Y"/> <!-- NOTE: these questions are associated with different columns to demonstrate the ability to have one question per cell MultiResp; for this to work these must be sequenced properly by sequenceNum,surveyMultiRespColId; the first one for a row (set of questions) will be used for the row title --> - <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1031" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="01" sequenceNum="3" surveyMultiRespId="01" surveyMultiRespColId="01" requiredField="Y" lastUpdatedStamp="2003-12-05 19:20:42.651" lastUpdatedTxStamp="2003-12-05 19:20:42.651"/> - <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1031B" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="01" sequenceNum="3" surveyMultiRespId="01" surveyMultiRespColId="02" requiredField="Y" lastUpdatedStamp="2003-12-05 19:20:42.651" lastUpdatedTxStamp="2003-12-05 19:20:42.651"/> - <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1031C" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="01" sequenceNum="3" surveyMultiRespId="01" surveyMultiRespColId="03" requiredField="Y" lastUpdatedStamp="2003-12-05 19:20:42.651" lastUpdatedTxStamp="2003-12-05 19:20:42.651"/> - <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1032" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="01" sequenceNum="4" requiredField="N" lastUpdatedStamp="2003-12-05 19:20:48.254" lastUpdatedTxStamp="2003-12-05 19:20:48.254"/> - - <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1033" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="02" sequenceNum="5" surveyMultiRespId="01" requiredField="N" lastUpdatedStamp="2003-12-05 19:21:18.896" lastUpdatedTxStamp="2003-12-05 19:21:18.896"/> - <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1034" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="02" sequenceNum="6" surveyMultiRespId="01" requiredField="Y" lastUpdatedStamp="2003-12-05 19:21:23.89" lastUpdatedTxStamp="2003-12-05 19:21:23.89"/> - <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1038" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="02" sequenceNum="7" requiredField="N" lastUpdatedStamp="2003-12-05 19:21:59.761" lastUpdatedTxStamp="2003-12-05 19:21:59.761"/> - <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1042" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="02" sequenceNum="8" requiredField="N" lastUpdatedStamp="2004-09-14 17:59:47.669" lastUpdatedTxStamp="2004-09-14 17:59:47.669"/> - <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1035" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="02" sequenceNum="9" requiredField="N" lastUpdatedStamp="2003-12-05 19:22:07.669" lastUpdatedTxStamp="2003-12-05 19:22:07.669"/> + <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1031" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="01" sequenceNum="3" surveyMultiRespId="01" surveyMultiRespColId="01" requiredField="Y"/> + <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1031B" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="01" sequenceNum="3" surveyMultiRespId="01" surveyMultiRespColId="02" requiredField="Y"/> + <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1031C" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="01" sequenceNum="3" surveyMultiRespId="01" surveyMultiRespColId="03" requiredField="Y"/> + <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1032" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="01" sequenceNum="4" requiredField="N"/> + + <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1033" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="02" sequenceNum="5" surveyMultiRespId="01" requiredField="N"/> + <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1034" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="02" sequenceNum="6" surveyMultiRespId="01" requiredField="Y"/> + <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1038" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="02" sequenceNum="7" requiredField="N"/> + <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1042" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="02" sequenceNum="8" requiredField="N"/> + <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1035" fromDate="2001-01-01 00:00:00.0" surveyPageSeqId="02" sequenceNum="9" requiredField="N"/> <!-- this one doesn't have a surveyPageSeqId on purpose so that the default will be used --> - <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1036" fromDate="2001-01-01 00:00:00.0" sequenceNum="10" requiredField="N" lastUpdatedStamp="2003-12-05 19:22:03.015" lastUpdatedTxStamp="2003-12-05 19:22:03.015"/> + <SurveyQuestionAppl surveyId="1002" surveyQuestionId="1036" fromDate="2001-01-01 00:00:00.0" sequenceNum="10" requiredField="N"/> - <SurveyQuestionAppl surveyId="1003" surveyQuestionId="1040" fromDate="2001-01-01 00:00:00.0" requiredField="Y" sequenceNum="1" lastUpdatedStamp="2003-12-04 21:40:23.233" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> + <SurveyQuestionAppl surveyId="1003" surveyQuestionId="1040" fromDate="2001-01-01 00:00:00.0" requiredField="Y" sequenceNum="1"/> - <SurveyQuestionAppl surveyId="1004" surveyQuestionId="1041" fromDate="2001-01-01 00:00:00.0" requiredField="Y" sequenceNum="1" lastUpdatedStamp="2003-12-04 21:40:23.233" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> + <SurveyQuestionAppl surveyId="1004" surveyQuestionId="1041" fromDate="2001-01-01 00:00:00.0" requiredField="Y" sequenceNum="1"/> - <SurveyQuestionOption surveyQuestionId="1030" surveyOptionSeqId="00001" description="1-2 times per year" sequenceNum="1" lastUpdatedStamp="2003-12-05 19:12:57.186" lastUpdatedTxStamp="2003-12-05 19:12:57.186"/> - <SurveyQuestionOption surveyQuestionId="1030" surveyOptionSeqId="00002" description="2-5 times per year" sequenceNum="2" lastUpdatedStamp="2003-12-05 19:13:08.549" lastUpdatedTxStamp="2003-12-05 19:13:08.549"/> - <SurveyQuestionOption surveyQuestionId="1030" surveyOptionSeqId="00003" description="6-10 time per year" sequenceNum="3" lastUpdatedStamp="2003-12-05 19:13:22.074" lastUpdatedTxStamp="2003-12-05 19:13:22.074"/> - <SurveyQuestionOption surveyQuestionId="1030" surveyOptionSeqId="00004" description="more then 10 times per year" sequenceNum="4" lastUpdatedStamp="2003-12-05 19:13:31.363" lastUpdatedTxStamp="2003-12-05 19:13:31.363"/> - <SurveyQuestionOption surveyQuestionId="1033" surveyOptionSeqId="00001" description="The Best!" sequenceNum="1" lastUpdatedStamp="2003-12-05 19:15:08.414" lastUpdatedTxStamp="2003-12-05 19:15:08.414"/> - <SurveyQuestionOption surveyQuestionId="1033" surveyOptionSeqId="00002" description="Above Average" sequenceNum="2" lastUpdatedStamp="2003-12-05 19:15:17.016" lastUpdatedTxStamp="2003-12-05 19:15:17.016"/> - <SurveyQuestionOption surveyQuestionId="1033" surveyOptionSeqId="00003" description="Average" sequenceNum="3" lastUpdatedStamp="2003-12-05 19:15:25.974" lastUpdatedTxStamp="2003-12-05 19:15:25.974"/> - <SurveyQuestionOption surveyQuestionId="1033" surveyOptionSeqId="00004" description="Below Average" sequenceNum="4" lastUpdatedStamp="2003-12-05 19:15:35.418" lastUpdatedTxStamp="2003-12-05 19:15:35.418"/> - <SurveyQuestionOption surveyQuestionId="1033" surveyOptionSeqId="00005" description="Poor" sequenceNum="5" lastUpdatedStamp="2003-12-05 19:15:42.754" lastUpdatedTxStamp="2003-12-05 19:15:42.754"/> - <SurveyQuestionOption surveyQuestionId="1034" surveyOptionSeqId="00001" description="Excellent Functionality" sequenceNum="1" lastUpdatedStamp="2003-12-05 19:17:00.167" lastUpdatedTxStamp="2003-12-05 19:17:00.167"/> - <SurveyQuestionOption surveyQuestionId="1034" surveyOptionSeqId="00002" description="Good Functionality" sequenceNum="2" lastUpdatedStamp="2003-12-05 19:17:27.067" lastUpdatedTxStamp="2003-12-05 19:17:27.067"/> - <SurveyQuestionOption surveyQuestionId="1034" surveyOptionSeqId="00003" description="Poor Functionality" sequenceNum="3" lastUpdatedStamp="2003-12-05 19:17:37.407" lastUpdatedTxStamp="2003-12-05 19:17:37.407"/> - <SurveyQuestionOption surveyQuestionId="1040" surveyOptionSeqId="00001" description="Right Side" sequenceNum="1" lastUpdatedStamp="2003-12-05 19:17:37.407" lastUpdatedTxStamp="2003-12-05 19:17:37.407"/> - <SurveyQuestionOption surveyQuestionId="1040" surveyOptionSeqId="00002" description="Left Side" sequenceNum="2" lastUpdatedStamp="2003-12-05 19:17:37.407" lastUpdatedTxStamp="2003-12-05 19:17:37.407"/> - <SurveyQuestionOption surveyQuestionId="1041" surveyOptionSeqId="00001" description="Right Hand" sequenceNum="1" lastUpdatedStamp="2003-12-05 19:17:37.407" lastUpdatedTxStamp="2003-12-05 19:17:37.407"/> - <SurveyQuestionOption surveyQuestionId="1041" surveyOptionSeqId="00002" description="Left Hand" sequenceNum="2" lastUpdatedStamp="2003-12-05 19:17:37.407" lastUpdatedTxStamp="2003-12-05 19:17:37.407"/> - - <ProductStoreSurveyAppl productStoreSurveyId="1000" productStoreId="9000" surveyApplTypeId="CART_ADD" surveyId="1000" productCategoryId="GC-101" fromDate="2003-11-24 16:00:02.467" surveyTemplate="/applications/content/template/survey/genericsurvey.ftl" lastUpdatedStamp="2003-12-04 21:40:23.27" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> - <ProductStoreSurveyAppl productStoreSurveyId="1001" productStoreId="9000" surveyApplTypeId="CART_ADD" surveyId="1001" productCategoryId="GC-102" fromDate="2003-11-24 16:00:51.693" surveyTemplate="/applications/content/template/survey/genericsurvey.ftl" lastUpdatedStamp="2003-12-04 21:40:23.276" lastUpdatedTxStamp="2003-12-04 21:40:20.607"/> - <ProductStoreSurveyAppl productStoreSurveyId="1002" productStoreId="9000" surveyApplTypeId="CUSTOMER_PROFILE" surveyId="1002" fromDate="2003-12-05 19:22:40.925" surveyTemplate="/applications/content/template/survey/genericsurvey.ftl" resultTemplate="/applications/ecommerce/templates/survey/genericresult.ftl" sequenceNum="1" lastUpdatedStamp="2003-12-05 19:22:40.925" lastUpdatedTxStamp="2003-12-05 19:22:40.925"/> - <ProductStoreSurveyAppl productStoreSurveyId="1003" productStoreId="9000" surveyApplTypeId="RANDOM_POLL" groupName="testSurveyGroup" surveyId="1003" fromDate="2003-12-05 19:22:40.925" surveyTemplate="/applications/ecommerce/templates/survey/minisurvey.ftl" resultTemplate="/applications/ecommerce/templates/survey/miniresult.ftl" sequenceNum="1" lastUpdatedStamp="2003-12-05 19:22:40.925" lastUpdatedTxStamp="2003-12-05 19:22:40.925"/> - <ProductStoreSurveyAppl productStoreSurveyId="1004" productStoreId="9000" surveyApplTypeId="RANDOM_POLL" groupName="testSurveyGroup" surveyId="1004" fromDate="2003-12-05 19:22:40.925" surveyTemplate="/applications/ecommerce/templates/survey/minisurvey.ftl" resultTemplate="/applications/ecommerce/templates/survey/miniresult.ftl" sequenceNum="1" lastUpdatedStamp="2003-12-05 19:22:40.925" lastUpdatedTxStamp="2003-12-05 19:22:40.925"/> + <SurveyQuestionOption surveyQuestionId="1030" surveyOptionSeqId="00001" description="1-2 times per year" sequenceNum="1"/> + <SurveyQuestionOption surveyQuestionId="1030" surveyOptionSeqId="00002" description="2-5 times per year" sequenceNum="2"/> + <SurveyQuestionOption surveyQuestionId="1030" surveyOptionSeqId="00003" description="6-10 time per year" sequenceNum="3"/> + <SurveyQuestionOption surveyQuestionId="1030" surveyOptionSeqId="00004" description="more then 10 times per year" sequenceNum="4"/> + <SurveyQuestionOption surveyQuestionId="1033" surveyOptionSeqId="00001" description="The Best!" sequenceNum="1"/> + <SurveyQuestionOption surveyQuestionId="1033" surveyOptionSeqId="00002" description="Above Average" sequenceNum="2"/> + <SurveyQuestionOption surveyQuestionId="1033" surveyOptionSeqId="00003" description="Average" sequenceNum="3"/> + <SurveyQuestionOption surveyQuestionId="1033" surveyOptionSeqId="00004" description="Below Average" sequenceNum="4"/> + <SurveyQuestionOption surveyQuestionId="1033" surveyOptionSeqId="00005" description="Poor" sequenceNum="5"/> + <SurveyQuestionOption surveyQuestionId="1034" surveyOptionSeqId="00001" description="Excellent Functionality" sequenceNum="1"/> + <SurveyQuestionOption surveyQuestionId="1034" surveyOptionSeqId="00002" description="Good Functionality" sequenceNum="2"/> + <SurveyQuestionOption surveyQuestionId="1034" surveyOptionSeqId="00003" description="Poor Functionality" sequenceNum="3"/> + <SurveyQuestionOption surveyQuestionId="1040" surveyOptionSeqId="00001" description="Right Side" sequenceNum="1"/> + <SurveyQuestionOption surveyQuestionId="1040" surveyOptionSeqId="00002" description="Left Side" sequenceNum="2"/> + <SurveyQuestionOption surveyQuestionId="1041" surveyOptionSeqId="00001" description="Right Hand" sequenceNum="1"/> + <SurveyQuestionOption surveyQuestionId="1041" surveyOptionSeqId="00002" description="Left Hand" sequenceNum="2"/> + + <ProductStoreSurveyAppl productStoreSurveyId="1000" productStoreId="9000" surveyApplTypeId="CART_ADD" surveyId="1000" productCategoryId="GC-101" fromDate="2003-11-24 16:00:02.467" surveyTemplate="/applications/content/template/survey/genericsurvey.ftl"/> + <ProductStoreSurveyAppl productStoreSurveyId="1001" productStoreId="9000" surveyApplTypeId="CART_ADD" surveyId="1001" productCategoryId="GC-102" fromDate="2003-11-24 16:00:51.693" surveyTemplate="/applications/content/template/survey/genericsurvey.ftl"/> + <ProductStoreSurveyAppl productStoreSurveyId="1002" productStoreId="9000" surveyApplTypeId="CUSTOMER_PROFILE" surveyId="1002" fromDate="2003-12-05 19:22:40.925" surveyTemplate="/applications/content/template/survey/genericsurvey.ftl" resultTemplate="/applications/ecommerce/templates/survey/genericresult.ftl" sequenceNum="1"/> + <ProductStoreSurveyAppl productStoreSurveyId="1003" productStoreId="9000" surveyApplTypeId="RANDOM_POLL" groupName="testSurveyGroup" surveyId="1003" fromDate="2003-12-05 19:22:40.925" surveyTemplate="/applications/ecommerce/templates/survey/minisurvey.ftl" resultTemplate="/applications/ecommerce/templates/survey/miniresult.ftl" sequenceNum="1"/> + <ProductStoreSurveyAppl productStoreSurveyId="1004" productStoreId="9000" surveyApplTypeId="RANDOM_POLL" groupName="testSurveyGroup" surveyId="1004" fromDate="2003-12-05 19:22:40.925" surveyTemplate="/applications/ecommerce/templates/survey/minisurvey.ftl" resultTemplate="/applications/ecommerce/templates/survey/miniresult.ftl" sequenceNum="1"/> </entity-engine-xml> |
Free forum by Nabble | Edit this page |