You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by Ratnesh Upadhyay <ra...@gmail.com> on 2008/07/02 10:46:08 UTC
Re: svn commit: r673262 - in /ofbiz/trunk/applications/workeffort: data/WorkEffortTypeData.xml entitydef/entitymodel.xml
Getting following error while uploading data :
[java] 2008-07-02 13:56:09,272 (main) [
GenericDelegator.java:1240:ERROR]
[java] ---- exception report
----------------------------------------------------------
[java] Failure in store operation for entity [StatusType]:
org.ofbiz.entity.GenericEntityException: Error while updating:
[GenericEntity:StatusType][description,Project(java.lang.String)][lastUpdatedStamp,2008-07-02
13:56:09.249(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-02
13:56:09.146(java.sql.Timestamp)][parentTypeId,PROJECT_STATUS(java.lang.String)][statusTypeId,WORK_EFF_ASSET_STTS(java.lang.String)]
(SQL Exception while executing the following:UPDATE public.STATUS_TYPE SET
PARENT_TYPE_ID=?, DESCRIPTION=?, LAST_UPDATED_TX_STAMP=?,
LAST_UPDATED_STAMP=? WHERE STATUS_TYPE_ID=? (ERROR: insert or update on
table "status_type" violates foreign key constraint "status_type_parent"
[java] Detail: Key (parent_type_id)=(PROJECT_STATUS) is not present
in table "status_type".)). Rolling back transaction.
[java
Thank You,
Ratnesh
On Wed, Jul 2, 2008 at 8:03 AM, <jo...@apache.org> wrote:
> Author: jonesde
> Date: Tue Jul 1 19:33:00 2008
> New Revision: 673262
>
> URL: http://svn.apache.org/viewvc?rev=673262&view=rev
> Log:
> Added delegateReasonEnumId to WorkEffortPartyAssignment to keep track of
> why a task was assigned to another person or group
>
> Modified:
> ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
> ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>
> Modified: ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml?rev=673262&r1=673261&r2=673262&view=diff
>
> ==============================================================================
> --- ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
> (original)
> +++ ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml Tue Jul
> 1 19:33:00 2008
> @@ -28,13 +28,18 @@
> <EnumerationType description="Parent Type for all Work Effort enum
> types" enumTypeId="WORK_EFFORT" hasTable="N" parentTypeId=""/>
> <EnumerationType description="Parent Type for all Workflow enum types"
> enumTypeId="WORKFLOW" hasTable="N" parentTypeId=""/>
>
> - <EnumerationType description="Work Effort Expectations"
> enumTypeId="WORK_EFF_EXPECT" hasTable="N" parentTypeId="WORK_EFFORT"/>
> + <EnumerationType description="Work Effort Expectation"
> enumTypeId="WORK_EFF_EXPECT" hasTable="N" parentTypeId="WORK_EFFORT"/>
> <Enumeration description="For Your Information" enumCode="FYI"
> enumId="WEE_FYI" sequenceId="01" enumTypeId="WORK_EFF_EXPECT"/>
> <Enumeration description="Involvement Required" enumCode="REQUIRE"
> enumId="WEE_REQUIRE" sequenceId="02" enumTypeId="WORK_EFF_EXPECT"/>
> <Enumeration description="Involvement Requested" enumCode="REQUEST"
> enumId="WEE_REQUEST" sequenceId="03" enumTypeId="WORK_EFF_EXPECT"/>
> <Enumeration description="Immediate Response Requested"
> enumCode="IMMEDIATE" enumId="WEE_IMMEDIATE" sequenceId="04"
> enumTypeId="WORK_EFF_EXPECT"/>
>
> - <EnumerationType description="Work Effort Scope Classifications"
> enumTypeId="WORK_EFF_SCOPE" hasTable="N" parentTypeId="WORK_EFFORT"/>
> + <EnumerationType description="Work Effort Delegate Reason"
> enumTypeId="WORK_EFF_DEL_REAS" hasTable="N" parentTypeId="WORK_EFFORT"/>
> + <Enumeration description="Need Support or Help" enumCode="NEED_HELP"
> enumId="WEDR_NEED_HELP" sequenceId="01" enumTypeId="WORK_EFF_DEL_REAS"/>
> + <Enumeration description="My Part Finished" enumCode="PART_FINISHED"
> enumId="WEDR_PART_FINISHED" sequenceId="02" enumTypeId="WORK_EFF_DEL_REAS"/>
> + <Enumeration description="Completely Finished"
> enumCode="WHOLE_FINISHED" enumId="WEDR_WHOLE_FINISHED" sequenceId="03"
> enumTypeId="WORK_EFF_DEL_REAS"/>
> +
> + <EnumerationType description="Work Effort Scope Classification"
> enumTypeId="WORK_EFF_SCOPE" hasTable="N" parentTypeId="WORK_EFFORT"/>
> <Enumeration description="General, public access" enumCode="PUBLIC"
> enumId="WES_PUBLIC" sequenceId="01" enumTypeId="WORK_EFF_SCOPE"/>
> <Enumeration description="Restricted, private access"
> enumCode="PRIVATE" enumId="WES_PRIVATE" sequenceId="02"
> enumTypeId="WORK_EFF_SCOPE"/>
> <Enumeration description="Very restricted, confidential access"
> enumCode="CONFIDENTIAL" enumId="WES_CONFIDENTIAL" sequenceId="03"
> enumTypeId="WORK_EFF_SCOPE"/>
> @@ -80,13 +85,26 @@
> <StatusValidChange condition="" statusId="CAL_TENTATIVE"
> statusIdTo="CAL_CANCELLED" transitionName="Cancel"/>
> <StatusValidChange condition="" statusId="CAL_TENTATIVE"
> statusIdTo="CAL_CONFIRMED" transitionName="Confirm"/>
> <StatusValidChange condition="" statusId="CAL_CONFIRMED"
> statusIdTo="CAL_COMPLETED" transitionName="Complete"/>
> -
> +
> + <!-- Project Statuses -->
> + <StatusType description="Project" hasTable="N"
> parentTypeId="PROJECT_STATUS" statusTypeId="WORK_EFF_ASSET_STTS"/>
> + <StatusItem description="Planning" sequenceId="01"
> statusCode="PLANNING" statusId="WEPR_PLANNING" statusTypeId="EVENT_STATUS"/>
> + <StatusItem description="In Progress" sequenceId="02"
> statusCode="IN_PROGRESS" statusId="WEPR_IN_PROGRESS"
> statusTypeId="EVENT_STATUS"/>
> + <StatusItem description="Complete" sequenceId="05"
> statusCode="COMPLETE" statusId="WEPR_COMPLETE" statusTypeId="EVENT_STATUS"/>
> + <StatusItem description="On Hold" sequenceId="98" statusCode="ON_HOLD"
> statusId="WEPR_ON_HOLD" statusTypeId="EVENT_STATUS"/>
> + <StatusItem description="Cancelled" sequenceId="99"
> statusCode="CANCELLED" statusId="WEPR_CANCELLED"
> statusTypeId="EVENT_STATUS"/>
> + <StatusValidChange condition="" statusId="WEPR_PLANNING"
> statusIdTo="WEPR_IN_PROGRESS" transitionName="Begin Project"/>
> + <StatusValidChange condition="" statusId="WEPR_IN_PROGRESS"
> statusIdTo="WEPR_ON_HOLD" transitionName="Begin Project"/>
> + <StatusValidChange condition="" statusId="WEPR_ON_HOLD"
> statusIdTo="WEPR_IN_PROGRESS" transitionName="Resume Project"/>
> + <StatusValidChange condition="" statusId="WEPR_IN_PROGRESS"
> statusIdTo="WEPR_CANCELLED" transitionName="Cancel"/>
> + <StatusValidChange condition="" statusId="WEPR_ON_HOLD"
> statusIdTo="WEPR_CANCELLED" transitionName="Cancel"/>
> +
> <!-- Status items for WorkEffortPartyAssignment.availabilityStatusId
> -->
> <StatusType description="Work Effort Party Availability" hasTable="N"
> parentTypeId="" statusTypeId="WEPA_AVAILABILITY"/>
> <StatusItem description="Available" sequenceId="01"
> statusCode="AVAILABLE" statusId="WEPA_AV_AVAILABLE"
> statusTypeId="WEPA_AVAILABILITY"/>
> <StatusItem description="Busy" sequenceId="02" statusCode="BUSY"
> statusId="WEPA_AV_BUSY" statusTypeId="WEPA_AVAILABILITY"/>
> <StatusItem description="Away" sequenceId="03" statusCode="AWAY"
> statusId="WEPA_AV_AWAY" statusTypeId="WEPA_AVAILABILITY"/>
> -
> +
> <WorkEffortAssocType description="Breakdown/Detail" hasTable="N"
> parentTypeId="" workEffortAssocTypeId="WORK_EFF_BREAKDOWN"/>
> <WorkEffortAssocType description="Dependency" hasTable="N"
> parentTypeId="" workEffortAssocTypeId="WORK_EFF_DEPENDENCY"/>
> <WorkEffortAssocType description="Concurrency" hasTable="N"
> parentTypeId="WORK_EFF_DEPENDENCY"
> workEffortAssocTypeId="WORK_EFF_CONCURRENCY"/>
>
> Modified: ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
> URL:
> http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml?rev=673262&r1=673261&r2=673262&view=diff
>
> ==============================================================================
> --- ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
> (original)
> +++ ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml Tue Jul
> 1 19:33:00 2008
> @@ -668,9 +668,7 @@
> <key-map field-name="noteId"/>
> </relation>
> </entity>
> - <entity entity-name="WorkEffortPartyAssignment"
> - package-name="org.ofbiz.workeffort.workeffort"
> - title="Work Effort Party Assignment Entity">
> + <entity entity-name="WorkEffortPartyAssignment"
> package-name="org.ofbiz.workeffort.workeffort" title="Work Effort Party
> Assignment Entity">
> <field name="workEffortId" type="id-ne"></field>
> <field name="partyId" type="id-ne"></field>
> <field name="roleTypeId" type="id-ne"></field>
> @@ -678,7 +676,8 @@
> <field name="thruDate" type="date-time"></field>
> <field name="statusId" type="id"></field>
> <field name="statusDateTime" type="date-time"></field>
> - <field name="expectationEnumId" type="id"></field>
> + <field name="expectationEnumId" type="id"><description>Point to
> Enumeration value with enumTypeId="WORK_EFF_EXPECT"</description></field>
> + <field name="delegateReasonEnumId" type="id"><description>Point to
> Enumeration value with enumTypeId="WORK_EFF_DEL_REAS"</description></field>
> <field name="facilityId" type="id"></field>
> <field name="comments" type="comment"></field>
> <field name="mustRsvp" type="indicator"></field>
> @@ -712,14 +711,15 @@
> <relation type="one" fk-name="WKEFF_PA_EXP_ENUM" title="Expectation"
> rel-entity-name="Enumeration">
> <key-map field-name="expectationEnumId" rel-field-name="enumId"/>
> </relation>
> + <relation type="one" fk-name="WKEFF_PA_DELR_ENM"
> title="DelegateReason" rel-entity-name="Enumeration">
> + <key-map field-name="delegateReasonEnumId"
> rel-field-name="enumId"/>
> + </relation>
> <relation type="one" fk-name="WKEFF_PA_AVSTTS" title="Availability"
> rel-entity-name="StatusItem">
> <key-map field-name="availabilityStatusId"
> rel-field-name="statusId"/>
> </relation>
> </entity>
> - <entity entity-name="WorkEffortPurposeType"
> - package-name="org.ofbiz.workeffort.workeffort"
> - title="Work Effort Purpose Type Entity"
> - default-resource-name="WorkEffortEntityLabels">
> + <entity entity-name="WorkEffortPurposeType"
> package-name="org.ofbiz.workeffort.workeffort" title="Work Effort Purpose
> Type Entity"
> + default-resource-name="WorkEffortEntityLabels">
> <field name="workEffortPurposeTypeId" type="id-ne"></field>
> <field name="description" type="description"></field>
> <prim-key field="workEffortPurposeTypeId"/>
>
>
>
Re: svn commit: r673262 - in /ofbiz/trunk/applications/workeffort: data/WorkEffortTypeData.xml entitydef/entitymodel.xml
Posted by Ratnesh Upadhyay <ra...@gmail.com>.
Thank you so much David.
- Ratnesh
On Wed, Jul 2, 2008 at 2:32 PM, David E Jones <jo...@hotwaxmedia.com>
wrote:
>
> Thanks for letting me know. I hadn't finished the statusTypeIds when I
> committed that. They're finished now and in with a few other changes in SVN
> rev 673324.
>
> I also did a fresh db load test with the latest and got no errors.
>
> -David
>
>
>
> On Jul 2, 2008, at 2:46 AM, Ratnesh Upadhyay wrote:
>
> Getting following error while uploading data :
>>
>> [java] 2008-07-02 13:56:09,272 (main) [
>> GenericDelegator.java:1240:ERROR]
>> [java] ---- exception report
>> ----------------------------------------------------------
>> [java] Failure in store operation for entity [StatusType]:
>> org.ofbiz.entity.GenericEntityException: Error while updating:
>>
>> [GenericEntity:StatusType][description,Project(java.lang.String)][lastUpdatedStamp,2008-07-02
>> 13:56:09.249(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-02
>>
>> 13:56:09.146(java.sql.Timestamp)][parentTypeId,PROJECT_STATUS(java.lang.String)][statusTypeId,WORK_EFF_ASSET_STTS(java.lang.String)]
>> (SQL Exception while executing the following:UPDATE public.STATUS_TYPE SET
>> PARENT_TYPE_ID=?, DESCRIPTION=?, LAST_UPDATED_TX_STAMP=?,
>> LAST_UPDATED_STAMP=? WHERE STATUS_TYPE_ID=? (ERROR: insert or update on
>> table "status_type" violates foreign key constraint "status_type_parent"
>> [java] Detail: Key (parent_type_id)=(PROJECT_STATUS) is not present
>> in table "status_type".)). Rolling back transaction.
>> [java
>>
>>
>> Thank You,
>> Ratnesh
>>
>> On Wed, Jul 2, 2008 at 8:03 AM, <jo...@apache.org> wrote:
>>
>> Author: jonesde
>>> Date: Tue Jul 1 19:33:00 2008
>>> New Revision: 673262
>>>
>>> URL: http://svn.apache.org/viewvc?rev=673262&view=rev
>>> Log:
>>> Added delegateReasonEnumId to WorkEffortPartyAssignment to keep track of
>>> why a task was assigned to another person or group
>>>
>>> Modified:
>>> ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
>>> ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>>>
>>> Modified: ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
>>> URL:
>>>
>>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml?rev=673262&r1=673261&r2=673262&view=diff
>>>
>>>
>>> ==============================================================================
>>> --- ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
>>> (original)
>>> +++ ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml Tue
>>> Jul
>>> 1 19:33:00 2008
>>> @@ -28,13 +28,18 @@
>>> <EnumerationType description="Parent Type for all Work Effort enum
>>> types" enumTypeId="WORK_EFFORT" hasTable="N" parentTypeId=""/>
>>> <EnumerationType description="Parent Type for all Workflow enum types"
>>> enumTypeId="WORKFLOW" hasTable="N" parentTypeId=""/>
>>>
>>> - <EnumerationType description="Work Effort Expectations"
>>> enumTypeId="WORK_EFF_EXPECT" hasTable="N" parentTypeId="WORK_EFFORT"/>
>>> + <EnumerationType description="Work Effort Expectation"
>>> enumTypeId="WORK_EFF_EXPECT" hasTable="N" parentTypeId="WORK_EFFORT"/>
>>> <Enumeration description="For Your Information" enumCode="FYI"
>>> enumId="WEE_FYI" sequenceId="01" enumTypeId="WORK_EFF_EXPECT"/>
>>> <Enumeration description="Involvement Required" enumCode="REQUIRE"
>>> enumId="WEE_REQUIRE" sequenceId="02" enumTypeId="WORK_EFF_EXPECT"/>
>>> <Enumeration description="Involvement Requested" enumCode="REQUEST"
>>> enumId="WEE_REQUEST" sequenceId="03" enumTypeId="WORK_EFF_EXPECT"/>
>>> <Enumeration description="Immediate Response Requested"
>>> enumCode="IMMEDIATE" enumId="WEE_IMMEDIATE" sequenceId="04"
>>> enumTypeId="WORK_EFF_EXPECT"/>
>>>
>>> - <EnumerationType description="Work Effort Scope Classifications"
>>> enumTypeId="WORK_EFF_SCOPE" hasTable="N" parentTypeId="WORK_EFFORT"/>
>>> + <EnumerationType description="Work Effort Delegate Reason"
>>> enumTypeId="WORK_EFF_DEL_REAS" hasTable="N" parentTypeId="WORK_EFFORT"/>
>>> + <Enumeration description="Need Support or Help" enumCode="NEED_HELP"
>>> enumId="WEDR_NEED_HELP" sequenceId="01" enumTypeId="WORK_EFF_DEL_REAS"/>
>>> + <Enumeration description="My Part Finished" enumCode="PART_FINISHED"
>>> enumId="WEDR_PART_FINISHED" sequenceId="02"
>>> enumTypeId="WORK_EFF_DEL_REAS"/>
>>> + <Enumeration description="Completely Finished"
>>> enumCode="WHOLE_FINISHED" enumId="WEDR_WHOLE_FINISHED" sequenceId="03"
>>> enumTypeId="WORK_EFF_DEL_REAS"/>
>>> +
>>> + <EnumerationType description="Work Effort Scope Classification"
>>> enumTypeId="WORK_EFF_SCOPE" hasTable="N" parentTypeId="WORK_EFFORT"/>
>>> <Enumeration description="General, public access" enumCode="PUBLIC"
>>> enumId="WES_PUBLIC" sequenceId="01" enumTypeId="WORK_EFF_SCOPE"/>
>>> <Enumeration description="Restricted, private access"
>>> enumCode="PRIVATE" enumId="WES_PRIVATE" sequenceId="02"
>>> enumTypeId="WORK_EFF_SCOPE"/>
>>> <Enumeration description="Very restricted, confidential access"
>>> enumCode="CONFIDENTIAL" enumId="WES_CONFIDENTIAL" sequenceId="03"
>>> enumTypeId="WORK_EFF_SCOPE"/>
>>> @@ -80,13 +85,26 @@
>>> <StatusValidChange condition="" statusId="CAL_TENTATIVE"
>>> statusIdTo="CAL_CANCELLED" transitionName="Cancel"/>
>>> <StatusValidChange condition="" statusId="CAL_TENTATIVE"
>>> statusIdTo="CAL_CONFIRMED" transitionName="Confirm"/>
>>> <StatusValidChange condition="" statusId="CAL_CONFIRMED"
>>> statusIdTo="CAL_COMPLETED" transitionName="Complete"/>
>>> -
>>> +
>>> + <!-- Project Statuses -->
>>> + <StatusType description="Project" hasTable="N"
>>> parentTypeId="PROJECT_STATUS" statusTypeId="WORK_EFF_ASSET_STTS"/>
>>> + <StatusItem description="Planning" sequenceId="01"
>>> statusCode="PLANNING" statusId="WEPR_PLANNING"
>>> statusTypeId="EVENT_STATUS"/>
>>> + <StatusItem description="In Progress" sequenceId="02"
>>> statusCode="IN_PROGRESS" statusId="WEPR_IN_PROGRESS"
>>> statusTypeId="EVENT_STATUS"/>
>>> + <StatusItem description="Complete" sequenceId="05"
>>> statusCode="COMPLETE" statusId="WEPR_COMPLETE"
>>> statusTypeId="EVENT_STATUS"/>
>>> + <StatusItem description="On Hold" sequenceId="98"
>>> statusCode="ON_HOLD"
>>> statusId="WEPR_ON_HOLD" statusTypeId="EVENT_STATUS"/>
>>> + <StatusItem description="Cancelled" sequenceId="99"
>>> statusCode="CANCELLED" statusId="WEPR_CANCELLED"
>>> statusTypeId="EVENT_STATUS"/>
>>> + <StatusValidChange condition="" statusId="WEPR_PLANNING"
>>> statusIdTo="WEPR_IN_PROGRESS" transitionName="Begin Project"/>
>>> + <StatusValidChange condition="" statusId="WEPR_IN_PROGRESS"
>>> statusIdTo="WEPR_ON_HOLD" transitionName="Begin Project"/>
>>> + <StatusValidChange condition="" statusId="WEPR_ON_HOLD"
>>> statusIdTo="WEPR_IN_PROGRESS" transitionName="Resume Project"/>
>>> + <StatusValidChange condition="" statusId="WEPR_IN_PROGRESS"
>>> statusIdTo="WEPR_CANCELLED" transitionName="Cancel"/>
>>> + <StatusValidChange condition="" statusId="WEPR_ON_HOLD"
>>> statusIdTo="WEPR_CANCELLED" transitionName="Cancel"/>
>>> +
>>> <!-- Status items for WorkEffortPartyAssignment.availabilityStatusId
>>> -->
>>> <StatusType description="Work Effort Party Availability" hasTable="N"
>>> parentTypeId="" statusTypeId="WEPA_AVAILABILITY"/>
>>> <StatusItem description="Available" sequenceId="01"
>>> statusCode="AVAILABLE" statusId="WEPA_AV_AVAILABLE"
>>> statusTypeId="WEPA_AVAILABILITY"/>
>>> <StatusItem description="Busy" sequenceId="02" statusCode="BUSY"
>>> statusId="WEPA_AV_BUSY" statusTypeId="WEPA_AVAILABILITY"/>
>>> <StatusItem description="Away" sequenceId="03" statusCode="AWAY"
>>> statusId="WEPA_AV_AWAY" statusTypeId="WEPA_AVAILABILITY"/>
>>> -
>>> +
>>> <WorkEffortAssocType description="Breakdown/Detail" hasTable="N"
>>> parentTypeId="" workEffortAssocTypeId="WORK_EFF_BREAKDOWN"/>
>>> <WorkEffortAssocType description="Dependency" hasTable="N"
>>> parentTypeId="" workEffortAssocTypeId="WORK_EFF_DEPENDENCY"/>
>>> <WorkEffortAssocType description="Concurrency" hasTable="N"
>>> parentTypeId="WORK_EFF_DEPENDENCY"
>>> workEffortAssocTypeId="WORK_EFF_CONCURRENCY"/>
>>>
>>> Modified: ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>>> URL:
>>>
>>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml?rev=673262&r1=673261&r2=673262&view=diff
>>>
>>>
>>> ==============================================================================
>>> --- ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>>> (original)
>>> +++ ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml Tue Jul
>>> 1 19:33:00 2008
>>> @@ -668,9 +668,7 @@
>>> <key-map field-name="noteId"/>
>>> </relation>
>>> </entity>
>>> - <entity entity-name="WorkEffortPartyAssignment"
>>> - package-name="org.ofbiz.workeffort.workeffort"
>>> - title="Work Effort Party Assignment Entity">
>>> + <entity entity-name="WorkEffortPartyAssignment"
>>> package-name="org.ofbiz.workeffort.workeffort" title="Work Effort Party
>>> Assignment Entity">
>>> <field name="workEffortId" type="id-ne"></field>
>>> <field name="partyId" type="id-ne"></field>
>>> <field name="roleTypeId" type="id-ne"></field>
>>> @@ -678,7 +676,8 @@
>>> <field name="thruDate" type="date-time"></field>
>>> <field name="statusId" type="id"></field>
>>> <field name="statusDateTime" type="date-time"></field>
>>> - <field name="expectationEnumId" type="id"></field>
>>> + <field name="expectationEnumId" type="id"><description>Point to
>>> Enumeration value with enumTypeId="WORK_EFF_EXPECT"</description></field>
>>> + <field name="delegateReasonEnumId" type="id"><description>Point to
>>> Enumeration value with
>>> enumTypeId="WORK_EFF_DEL_REAS"</description></field>
>>> <field name="facilityId" type="id"></field>
>>> <field name="comments" type="comment"></field>
>>> <field name="mustRsvp" type="indicator"></field>
>>> @@ -712,14 +711,15 @@
>>> <relation type="one" fk-name="WKEFF_PA_EXP_ENUM" title="Expectation"
>>> rel-entity-name="Enumeration">
>>> <key-map field-name="expectationEnumId" rel-field-name="enumId"/>
>>> </relation>
>>> + <relation type="one" fk-name="WKEFF_PA_DELR_ENM"
>>> title="DelegateReason" rel-entity-name="Enumeration">
>>> + <key-map field-name="delegateReasonEnumId"
>>> rel-field-name="enumId"/>
>>> + </relation>
>>> <relation type="one" fk-name="WKEFF_PA_AVSTTS" title="Availability"
>>> rel-entity-name="StatusItem">
>>> <key-map field-name="availabilityStatusId"
>>> rel-field-name="statusId"/>
>>> </relation>
>>> </entity>
>>> - <entity entity-name="WorkEffortPurposeType"
>>> - package-name="org.ofbiz.workeffort.workeffort"
>>> - title="Work Effort Purpose Type Entity"
>>> - default-resource-name="WorkEffortEntityLabels">
>>> + <entity entity-name="WorkEffortPurposeType"
>>> package-name="org.ofbiz.workeffort.workeffort" title="Work Effort Purpose
>>> Type Entity"
>>> + default-resource-name="WorkEffortEntityLabels">
>>> <field name="workEffortPurposeTypeId" type="id-ne"></field>
>>> <field name="description" type="description"></field>
>>> <prim-key field="workEffortPurposeTypeId"/>
>>>
>>>
>>>
>>>
>
Re: svn commit: r673262 - in /ofbiz/trunk/applications/workeffort: data/WorkEffortTypeData.xml entitydef/entitymodel.xml
Posted by David E Jones <jo...@hotwaxmedia.com>.
Thanks for letting me know. I hadn't finished the statusTypeIds when I
committed that. They're finished now and in with a few other changes
in SVN rev 673324.
I also did a fresh db load test with the latest and got no errors.
-David
On Jul 2, 2008, at 2:46 AM, Ratnesh Upadhyay wrote:
> Getting following error while uploading data :
>
> [java] 2008-07-02 13:56:09,272 (main) [
> GenericDelegator.java:1240:ERROR]
> [java] ---- exception report
> ----------------------------------------------------------
> [java] Failure in store operation for entity [StatusType]:
> org.ofbiz.entity.GenericEntityException: Error while updating:
> [GenericEntity:StatusType][description,Project(java.lang.String)]
> [lastUpdatedStamp,2008-07-02
> 13:56:09.249(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-02
> 13:56:09.146(java.sql.Timestamp)]
> [parentTypeId,PROJECT_STATUS(java.lang.String)]
> [statusTypeId,WORK_EFF_ASSET_STTS(java.lang.String)]
> (SQL Exception while executing the following:UPDATE
> public.STATUS_TYPE SET
> PARENT_TYPE_ID=?, DESCRIPTION=?, LAST_UPDATED_TX_STAMP=?,
> LAST_UPDATED_STAMP=? WHERE STATUS_TYPE_ID=? (ERROR: insert or update
> on
> table "status_type" violates foreign key constraint
> "status_type_parent"
> [java] Detail: Key (parent_type_id)=(PROJECT_STATUS) is not
> present
> in table "status_type".)). Rolling back transaction.
> [java
>
>
> Thank You,
> Ratnesh
>
> On Wed, Jul 2, 2008 at 8:03 AM, <jo...@apache.org> wrote:
>
>> Author: jonesde
>> Date: Tue Jul 1 19:33:00 2008
>> New Revision: 673262
>>
>> URL: http://svn.apache.org/viewvc?rev=673262&view=rev
>> Log:
>> Added delegateReasonEnumId to WorkEffortPartyAssignment to keep
>> track of
>> why a task was assigned to another person or group
>>
>> Modified:
>> ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
>> ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>>
>> Modified: ofbiz/trunk/applications/workeffort/data/
>> WorkEffortTypeData.xml
>> URL:
>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml?rev=673262&r1=673261&r2=673262&view=diff
>>
>> =
>> =
>> =
>> =
>> =
>> =
>> =
>> =
>> =
>> =====================================================================
>> --- ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
>> (original)
>> +++ ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
>> Tue Jul
>> 1 19:33:00 2008
>> @@ -28,13 +28,18 @@
>> <EnumerationType description="Parent Type for all Work Effort enum
>> types" enumTypeId="WORK_EFFORT" hasTable="N" parentTypeId=""/>
>> <EnumerationType description="Parent Type for all Workflow enum
>> types"
>> enumTypeId="WORKFLOW" hasTable="N" parentTypeId=""/>
>>
>> - <EnumerationType description="Work Effort Expectations"
>> enumTypeId="WORK_EFF_EXPECT" hasTable="N"
>> parentTypeId="WORK_EFFORT"/>
>> + <EnumerationType description="Work Effort Expectation"
>> enumTypeId="WORK_EFF_EXPECT" hasTable="N"
>> parentTypeId="WORK_EFFORT"/>
>> <Enumeration description="For Your Information" enumCode="FYI"
>> enumId="WEE_FYI" sequenceId="01" enumTypeId="WORK_EFF_EXPECT"/>
>> <Enumeration description="Involvement Required" enumCode="REQUIRE"
>> enumId="WEE_REQUIRE" sequenceId="02" enumTypeId="WORK_EFF_EXPECT"/>
>> <Enumeration description="Involvement Requested"
>> enumCode="REQUEST"
>> enumId="WEE_REQUEST" sequenceId="03" enumTypeId="WORK_EFF_EXPECT"/>
>> <Enumeration description="Immediate Response Requested"
>> enumCode="IMMEDIATE" enumId="WEE_IMMEDIATE" sequenceId="04"
>> enumTypeId="WORK_EFF_EXPECT"/>
>>
>> - <EnumerationType description="Work Effort Scope Classifications"
>> enumTypeId="WORK_EFF_SCOPE" hasTable="N" parentTypeId="WORK_EFFORT"/>
>> + <EnumerationType description="Work Effort Delegate Reason"
>> enumTypeId="WORK_EFF_DEL_REAS" hasTable="N"
>> parentTypeId="WORK_EFFORT"/>
>> + <Enumeration description="Need Support or Help"
>> enumCode="NEED_HELP"
>> enumId="WEDR_NEED_HELP" sequenceId="01"
>> enumTypeId="WORK_EFF_DEL_REAS"/>
>> + <Enumeration description="My Part Finished"
>> enumCode="PART_FINISHED"
>> enumId="WEDR_PART_FINISHED" sequenceId="02"
>> enumTypeId="WORK_EFF_DEL_REAS"/>
>> + <Enumeration description="Completely Finished"
>> enumCode="WHOLE_FINISHED" enumId="WEDR_WHOLE_FINISHED"
>> sequenceId="03"
>> enumTypeId="WORK_EFF_DEL_REAS"/>
>> +
>> + <EnumerationType description="Work Effort Scope Classification"
>> enumTypeId="WORK_EFF_SCOPE" hasTable="N" parentTypeId="WORK_EFFORT"/>
>> <Enumeration description="General, public access"
>> enumCode="PUBLIC"
>> enumId="WES_PUBLIC" sequenceId="01" enumTypeId="WORK_EFF_SCOPE"/>
>> <Enumeration description="Restricted, private access"
>> enumCode="PRIVATE" enumId="WES_PRIVATE" sequenceId="02"
>> enumTypeId="WORK_EFF_SCOPE"/>
>> <Enumeration description="Very restricted, confidential access"
>> enumCode="CONFIDENTIAL" enumId="WES_CONFIDENTIAL" sequenceId="03"
>> enumTypeId="WORK_EFF_SCOPE"/>
>> @@ -80,13 +85,26 @@
>> <StatusValidChange condition="" statusId="CAL_TENTATIVE"
>> statusIdTo="CAL_CANCELLED" transitionName="Cancel"/>
>> <StatusValidChange condition="" statusId="CAL_TENTATIVE"
>> statusIdTo="CAL_CONFIRMED" transitionName="Confirm"/>
>> <StatusValidChange condition="" statusId="CAL_CONFIRMED"
>> statusIdTo="CAL_COMPLETED" transitionName="Complete"/>
>> -
>> +
>> + <!-- Project Statuses -->
>> + <StatusType description="Project" hasTable="N"
>> parentTypeId="PROJECT_STATUS" statusTypeId="WORK_EFF_ASSET_STTS"/>
>> + <StatusItem description="Planning" sequenceId="01"
>> statusCode="PLANNING" statusId="WEPR_PLANNING"
>> statusTypeId="EVENT_STATUS"/>
>> + <StatusItem description="In Progress" sequenceId="02"
>> statusCode="IN_PROGRESS" statusId="WEPR_IN_PROGRESS"
>> statusTypeId="EVENT_STATUS"/>
>> + <StatusItem description="Complete" sequenceId="05"
>> statusCode="COMPLETE" statusId="WEPR_COMPLETE"
>> statusTypeId="EVENT_STATUS"/>
>> + <StatusItem description="On Hold" sequenceId="98"
>> statusCode="ON_HOLD"
>> statusId="WEPR_ON_HOLD" statusTypeId="EVENT_STATUS"/>
>> + <StatusItem description="Cancelled" sequenceId="99"
>> statusCode="CANCELLED" statusId="WEPR_CANCELLED"
>> statusTypeId="EVENT_STATUS"/>
>> + <StatusValidChange condition="" statusId="WEPR_PLANNING"
>> statusIdTo="WEPR_IN_PROGRESS" transitionName="Begin Project"/>
>> + <StatusValidChange condition="" statusId="WEPR_IN_PROGRESS"
>> statusIdTo="WEPR_ON_HOLD" transitionName="Begin Project"/>
>> + <StatusValidChange condition="" statusId="WEPR_ON_HOLD"
>> statusIdTo="WEPR_IN_PROGRESS" transitionName="Resume Project"/>
>> + <StatusValidChange condition="" statusId="WEPR_IN_PROGRESS"
>> statusIdTo="WEPR_CANCELLED" transitionName="Cancel"/>
>> + <StatusValidChange condition="" statusId="WEPR_ON_HOLD"
>> statusIdTo="WEPR_CANCELLED" transitionName="Cancel"/>
>> +
>> <!-- Status items for
>> WorkEffortPartyAssignment.availabilityStatusId
>> -->
>> <StatusType description="Work Effort Party Availability"
>> hasTable="N"
>> parentTypeId="" statusTypeId="WEPA_AVAILABILITY"/>
>> <StatusItem description="Available" sequenceId="01"
>> statusCode="AVAILABLE" statusId="WEPA_AV_AVAILABLE"
>> statusTypeId="WEPA_AVAILABILITY"/>
>> <StatusItem description="Busy" sequenceId="02" statusCode="BUSY"
>> statusId="WEPA_AV_BUSY" statusTypeId="WEPA_AVAILABILITY"/>
>> <StatusItem description="Away" sequenceId="03" statusCode="AWAY"
>> statusId="WEPA_AV_AWAY" statusTypeId="WEPA_AVAILABILITY"/>
>> -
>> +
>> <WorkEffortAssocType description="Breakdown/Detail" hasTable="N"
>> parentTypeId="" workEffortAssocTypeId="WORK_EFF_BREAKDOWN"/>
>> <WorkEffortAssocType description="Dependency" hasTable="N"
>> parentTypeId="" workEffortAssocTypeId="WORK_EFF_DEPENDENCY"/>
>> <WorkEffortAssocType description="Concurrency" hasTable="N"
>> parentTypeId="WORK_EFF_DEPENDENCY"
>> workEffortAssocTypeId="WORK_EFF_CONCURRENCY"/>
>>
>> Modified: ofbiz/trunk/applications/workeffort/entitydef/
>> entitymodel.xml
>> URL:
>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml?rev=673262&r1=673261&r2=673262&view=diff
>>
>> =
>> =
>> =
>> =
>> =
>> =
>> =
>> =
>> =
>> =====================================================================
>> --- ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>> (original)
>> +++ ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>> Tue Jul
>> 1 19:33:00 2008
>> @@ -668,9 +668,7 @@
>> <key-map field-name="noteId"/>
>> </relation>
>> </entity>
>> - <entity entity-name="WorkEffortPartyAssignment"
>> - package-name="org.ofbiz.workeffort.workeffort"
>> - title="Work Effort Party Assignment Entity">
>> + <entity entity-name="WorkEffortPartyAssignment"
>> package-name="org.ofbiz.workeffort.workeffort" title="Work Effort
>> Party
>> Assignment Entity">
>> <field name="workEffortId" type="id-ne"></field>
>> <field name="partyId" type="id-ne"></field>
>> <field name="roleTypeId" type="id-ne"></field>
>> @@ -678,7 +676,8 @@
>> <field name="thruDate" type="date-time"></field>
>> <field name="statusId" type="id"></field>
>> <field name="statusDateTime" type="date-time"></field>
>> - <field name="expectationEnumId" type="id"></field>
>> + <field name="expectationEnumId" type="id"><description>Point
>> to
>> Enumeration value with enumTypeId="WORK_EFF_EXPECT"</description></
>> field>
>> + <field name="delegateReasonEnumId"
>> type="id"><description>Point to
>> Enumeration value with enumTypeId="WORK_EFF_DEL_REAS"</
>> description></field>
>> <field name="facilityId" type="id"></field>
>> <field name="comments" type="comment"></field>
>> <field name="mustRsvp" type="indicator"></field>
>> @@ -712,14 +711,15 @@
>> <relation type="one" fk-name="WKEFF_PA_EXP_ENUM"
>> title="Expectation"
>> rel-entity-name="Enumeration">
>> <key-map field-name="expectationEnumId" rel-field-
>> name="enumId"/>
>> </relation>
>> + <relation type="one" fk-name="WKEFF_PA_DELR_ENM"
>> title="DelegateReason" rel-entity-name="Enumeration">
>> + <key-map field-name="delegateReasonEnumId"
>> rel-field-name="enumId"/>
>> + </relation>
>> <relation type="one" fk-name="WKEFF_PA_AVSTTS"
>> title="Availability"
>> rel-entity-name="StatusItem">
>> <key-map field-name="availabilityStatusId"
>> rel-field-name="statusId"/>
>> </relation>
>> </entity>
>> - <entity entity-name="WorkEffortPurposeType"
>> - package-name="org.ofbiz.workeffort.workeffort"
>> - title="Work Effort Purpose Type Entity"
>> - default-resource-name="WorkEffortEntityLabels">
>> + <entity entity-name="WorkEffortPurposeType"
>> package-name="org.ofbiz.workeffort.workeffort" title="Work Effort
>> Purpose
>> Type Entity"
>> + default-resource-name="WorkEffortEntityLabels">
>> <field name="workEffortPurposeTypeId" type="id-ne"></field>
>> <field name="description" type="description"></field>
>> <prim-key field="workEffortPurposeTypeId"/>
>>
>>
>>
Re: svn commit: r673262 - in /ofbiz/trunk/applications/workeffort: data/WorkEffortTypeData.xml entitydef/entitymodel.xml
Posted by Jacques Le Roux <ja...@les7arts.com>.
David, Ratnesh,
Yes sorry, I was too fast on this one, kind of Pavlov's reflex. At large, my aim si to cut ASAP messages not well directed
Jacques
From: "David E Jones" <jo...@hotwaxmedia.com>
>
> Wait a minute... why would the user mailing list be used for this? It's definitely discussion around development of OFBiz
> itself....
>
> -David
>
>
> On Jul 2, 2008, at 3:48 AM, Jacques Le Roux wrote:
>
>> Any problems with revision (last) 673329 here
>>
>> Please use rather user ML for such questions :
>> http://docs.ofbiz.org/display/OFBADMIN/Mailing+Lists#MailingLists-DeveloperList :dev@ofbiz.apache.org
>>
>> Thanks
>>
>> Jacques
>>
>> From: "Ratnesh Upadhyay" <ra...@gmail.com>
>>> Getting following error while uploading data :
>>>
>>> [java] 2008-07-02 13:56:09,272 (main) [
>>> GenericDelegator.java:1240:ERROR]
>>> [java] ---- exception report
>>> ----------------------------------------------------------
>>> [java] Failure in store operation for entity [StatusType]:
>>> org.ofbiz.entity.GenericEntityException: Error while updating:
>>> [GenericEntity:StatusType][description,Project(java.lang.String)] [lastUpdatedStamp,2008-07-02
>>> 13:56:09.249(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-02
>>> 13:56:09.146(java.sql.Timestamp)] [parentTypeId,PROJECT_STATUS(java.lang.String)]
>>> [statusTypeId,WORK_EFF_ASSET_STTS(java.lang.String)]
>>> (SQL Exception while executing the following:UPDATE public.STATUS_TYPE SET
>>> PARENT_TYPE_ID=?, DESCRIPTION=?, LAST_UPDATED_TX_STAMP=?,
>>> LAST_UPDATED_STAMP=? WHERE STATUS_TYPE_ID=? (ERROR: insert or update on
>>> table "status_type" violates foreign key constraint "status_type_parent"
>>> [java] Detail: Key (parent_type_id)=(PROJECT_STATUS) is not present
>>> in table "status_type".)). Rolling back transaction.
>>> [java
>>>
>>>
>>> Thank You,
>>> Ratnesh
>>>
>>> On Wed, Jul 2, 2008 at 8:03 AM, <jo...@apache.org> wrote:
>>>
>>>> Author: jonesde
>>>> Date: Tue Jul 1 19:33:00 2008
>>>> New Revision: 673262
>>>>
>>>> URL: http://svn.apache.org/viewvc?rev=673262&view=rev
>>>> Log:
>>>> Added delegateReasonEnumId to WorkEffortPartyAssignment to keep track of
>>>> why a task was assigned to another person or group
>>>>
>>>> Modified:
>>>> ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
>>>> ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>>>>
>>>> Modified: ofbiz/trunk/applications/workeffort/data/ WorkEffortTypeData.xml
>>>> URL:
>>>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml?rev=673262&r1=673261&r2=673262&view=diff
>>>>
>>>> = = = = = = = = = = ====================================================================
>>>> --- ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
>>>> (original)
>>>> +++ ofbiz/trunk/applications/workeffort/data/ WorkEffortTypeData.xml Tue Jul
>>>> 1 19:33:00 2008
>>>> @@ -28,13 +28,18 @@
>>>> <EnumerationType description="Parent Type for all Work Effort enum
>>>> types" enumTypeId="WORK_EFFORT" hasTable="N" parentTypeId=""/>
>>>> <EnumerationType description="Parent Type for all Workflow enum types"
>>>> enumTypeId="WORKFLOW" hasTable="N" parentTypeId=""/>
>>>>
>>>> - <EnumerationType description="Work Effort Expectations"
>>>> enumTypeId="WORK_EFF_EXPECT" hasTable="N" parentTypeId="WORK_EFFORT"/>
>>>> + <EnumerationType description="Work Effort Expectation"
>>>> enumTypeId="WORK_EFF_EXPECT" hasTable="N" parentTypeId="WORK_EFFORT"/>
>>>> <Enumeration description="For Your Information" enumCode="FYI"
>>>> enumId="WEE_FYI" sequenceId="01" enumTypeId="WORK_EFF_EXPECT"/>
>>>> <Enumeration description="Involvement Required" enumCode="REQUIRE"
>>>> enumId="WEE_REQUIRE" sequenceId="02" enumTypeId="WORK_EFF_EXPECT"/>
>>>> <Enumeration description="Involvement Requested" enumCode="REQUEST"
>>>> enumId="WEE_REQUEST" sequenceId="03" enumTypeId="WORK_EFF_EXPECT"/>
>>>> <Enumeration description="Immediate Response Requested"
>>>> enumCode="IMMEDIATE" enumId="WEE_IMMEDIATE" sequenceId="04"
>>>> enumTypeId="WORK_EFF_EXPECT"/>
>>>>
>>>> - <EnumerationType description="Work Effort Scope Classifications"
>>>> enumTypeId="WORK_EFF_SCOPE" hasTable="N" parentTypeId="WORK_EFFORT"/>
>>>> + <EnumerationType description="Work Effort Delegate Reason"
>>>> enumTypeId="WORK_EFF_DEL_REAS" hasTable="N" parentTypeId="WORK_EFFORT"/>
>>>> + <Enumeration description="Need Support or Help" enumCode="NEED_HELP"
>>>> enumId="WEDR_NEED_HELP" sequenceId="01" enumTypeId="WORK_EFF_DEL_REAS"/>
>>>> + <Enumeration description="My Part Finished" enumCode="PART_FINISHED"
>>>> enumId="WEDR_PART_FINISHED" sequenceId="02" enumTypeId="WORK_EFF_DEL_REAS"/>
>>>> + <Enumeration description="Completely Finished"
>>>> enumCode="WHOLE_FINISHED" enumId="WEDR_WHOLE_FINISHED" sequenceId="03"
>>>> enumTypeId="WORK_EFF_DEL_REAS"/>
>>>> +
>>>> + <EnumerationType description="Work Effort Scope Classification"
>>>> enumTypeId="WORK_EFF_SCOPE" hasTable="N" parentTypeId="WORK_EFFORT"/>
>>>> <Enumeration description="General, public access" enumCode="PUBLIC"
>>>> enumId="WES_PUBLIC" sequenceId="01" enumTypeId="WORK_EFF_SCOPE"/>
>>>> <Enumeration description="Restricted, private access"
>>>> enumCode="PRIVATE" enumId="WES_PRIVATE" sequenceId="02"
>>>> enumTypeId="WORK_EFF_SCOPE"/>
>>>> <Enumeration description="Very restricted, confidential access"
>>>> enumCode="CONFIDENTIAL" enumId="WES_CONFIDENTIAL" sequenceId="03"
>>>> enumTypeId="WORK_EFF_SCOPE"/>
>>>> @@ -80,13 +85,26 @@
>>>> <StatusValidChange condition="" statusId="CAL_TENTATIVE"
>>>> statusIdTo="CAL_CANCELLED" transitionName="Cancel"/>
>>>> <StatusValidChange condition="" statusId="CAL_TENTATIVE"
>>>> statusIdTo="CAL_CONFIRMED" transitionName="Confirm"/>
>>>> <StatusValidChange condition="" statusId="CAL_CONFIRMED"
>>>> statusIdTo="CAL_COMPLETED" transitionName="Complete"/>
>>>> -
>>>> +
>>>> + <!-- Project Statuses -->
>>>> + <StatusType description="Project" hasTable="N"
>>>> parentTypeId="PROJECT_STATUS" statusTypeId="WORK_EFF_ASSET_STTS"/>
>>>> + <StatusItem description="Planning" sequenceId="01"
>>>> statusCode="PLANNING" statusId="WEPR_PLANNING" statusTypeId="EVENT_STATUS"/>
>>>> + <StatusItem description="In Progress" sequenceId="02"
>>>> statusCode="IN_PROGRESS" statusId="WEPR_IN_PROGRESS"
>>>> statusTypeId="EVENT_STATUS"/>
>>>> + <StatusItem description="Complete" sequenceId="05"
>>>> statusCode="COMPLETE" statusId="WEPR_COMPLETE" statusTypeId="EVENT_STATUS"/>
>>>> + <StatusItem description="On Hold" sequenceId="98" statusCode="ON_HOLD"
>>>> statusId="WEPR_ON_HOLD" statusTypeId="EVENT_STATUS"/>
>>>> + <StatusItem description="Cancelled" sequenceId="99"
>>>> statusCode="CANCELLED" statusId="WEPR_CANCELLED"
>>>> statusTypeId="EVENT_STATUS"/>
>>>> + <StatusValidChange condition="" statusId="WEPR_PLANNING"
>>>> statusIdTo="WEPR_IN_PROGRESS" transitionName="Begin Project"/>
>>>> + <StatusValidChange condition="" statusId="WEPR_IN_PROGRESS"
>>>> statusIdTo="WEPR_ON_HOLD" transitionName="Begin Project"/>
>>>> + <StatusValidChange condition="" statusId="WEPR_ON_HOLD"
>>>> statusIdTo="WEPR_IN_PROGRESS" transitionName="Resume Project"/>
>>>> + <StatusValidChange condition="" statusId="WEPR_IN_PROGRESS"
>>>> statusIdTo="WEPR_CANCELLED" transitionName="Cancel"/>
>>>> + <StatusValidChange condition="" statusId="WEPR_ON_HOLD"
>>>> statusIdTo="WEPR_CANCELLED" transitionName="Cancel"/>
>>>> +
>>>> <!-- Status items for WorkEffortPartyAssignment.availabilityStatusId
>>>> -->
>>>> <StatusType description="Work Effort Party Availability" hasTable="N"
>>>> parentTypeId="" statusTypeId="WEPA_AVAILABILITY"/>
>>>> <StatusItem description="Available" sequenceId="01"
>>>> statusCode="AVAILABLE" statusId="WEPA_AV_AVAILABLE"
>>>> statusTypeId="WEPA_AVAILABILITY"/>
>>>> <StatusItem description="Busy" sequenceId="02" statusCode="BUSY"
>>>> statusId="WEPA_AV_BUSY" statusTypeId="WEPA_AVAILABILITY"/>
>>>> <StatusItem description="Away" sequenceId="03" statusCode="AWAY"
>>>> statusId="WEPA_AV_AWAY" statusTypeId="WEPA_AVAILABILITY"/>
>>>> -
>>>> +
>>>> <WorkEffortAssocType description="Breakdown/Detail" hasTable="N"
>>>> parentTypeId="" workEffortAssocTypeId="WORK_EFF_BREAKDOWN"/>
>>>> <WorkEffortAssocType description="Dependency" hasTable="N"
>>>> parentTypeId="" workEffortAssocTypeId="WORK_EFF_DEPENDENCY"/>
>>>> <WorkEffortAssocType description="Concurrency" hasTable="N"
>>>> parentTypeId="WORK_EFF_DEPENDENCY"
>>>> workEffortAssocTypeId="WORK_EFF_CONCURRENCY"/>
>>>>
>>>> Modified: ofbiz/trunk/applications/workeffort/entitydef/ entitymodel.xml
>>>> URL:
>>>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml?rev=673262&r1=673261&r2=673262&view=diff
>>>>
>>>> = = = = = = = = = = ====================================================================
>>>> --- ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>>>> (original)
>>>> +++ ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml Tue Jul
>>>> 1 19:33:00 2008
>>>> @@ -668,9 +668,7 @@
>>>> <key-map field-name="noteId"/>
>>>> </relation>
>>>> </entity>
>>>> - <entity entity-name="WorkEffortPartyAssignment"
>>>> - package-name="org.ofbiz.workeffort.workeffort"
>>>> - title="Work Effort Party Assignment Entity">
>>>> + <entity entity-name="WorkEffortPartyAssignment"
>>>> package-name="org.ofbiz.workeffort.workeffort" title="Work Effort Party
>>>> Assignment Entity">
>>>> <field name="workEffortId" type="id-ne"></field>
>>>> <field name="partyId" type="id-ne"></field>
>>>> <field name="roleTypeId" type="id-ne"></field>
>>>> @@ -678,7 +676,8 @@
>>>> <field name="thruDate" type="date-time"></field>
>>>> <field name="statusId" type="id"></field>
>>>> <field name="statusDateTime" type="date-time"></field>
>>>> - <field name="expectationEnumId" type="id"></field>
>>>> + <field name="expectationEnumId" type="id"><description>Point to
>>>> Enumeration value with enumTypeId="WORK_EFF_EXPECT"</description></ field>
>>>> + <field name="delegateReasonEnumId" type="id"><description>Point to
>>>> Enumeration value with enumTypeId="WORK_EFF_DEL_REAS"</ description></field>
>>>> <field name="facilityId" type="id"></field>
>>>> <field name="comments" type="comment"></field>
>>>> <field name="mustRsvp" type="indicator"></field>
>>>> @@ -712,14 +711,15 @@
>>>> <relation type="one" fk-name="WKEFF_PA_EXP_ENUM" title="Expectation"
>>>> rel-entity-name="Enumeration">
>>>> <key-map field-name="expectationEnumId" rel-field- name="enumId"/>
>>>> </relation>
>>>> + <relation type="one" fk-name="WKEFF_PA_DELR_ENM"
>>>> title="DelegateReason" rel-entity-name="Enumeration">
>>>> + <key-map field-name="delegateReasonEnumId"
>>>> rel-field-name="enumId"/>
>>>> + </relation>
>>>> <relation type="one" fk-name="WKEFF_PA_AVSTTS" title="Availability"
>>>> rel-entity-name="StatusItem">
>>>> <key-map field-name="availabilityStatusId"
>>>> rel-field-name="statusId"/>
>>>> </relation>
>>>> </entity>
>>>> - <entity entity-name="WorkEffortPurposeType"
>>>> - package-name="org.ofbiz.workeffort.workeffort"
>>>> - title="Work Effort Purpose Type Entity"
>>>> - default-resource-name="WorkEffortEntityLabels">
>>>> + <entity entity-name="WorkEffortPurposeType"
>>>> package-name="org.ofbiz.workeffort.workeffort" title="Work Effort Purpose
>>>> Type Entity"
>>>> + default-resource-name="WorkEffortEntityLabels">
>>>> <field name="workEffortPurposeTypeId" type="id-ne"></field>
>>>> <field name="description" type="description"></field>
>>>> <prim-key field="workEffortPurposeTypeId"/>
>>>>
>>>>
>>>>
>>
>
Re: svn commit: r673262 - in /ofbiz/trunk/applications/workeffort: data/WorkEffortTypeData.xml entitydef/entitymodel.xml
Posted by David E Jones <jo...@hotwaxmedia.com>.
Wait a minute... why would the user mailing list be used for this?
It's definitely discussion around development of OFBiz itself....
-David
On Jul 2, 2008, at 3:48 AM, Jacques Le Roux wrote:
> Any problems with revision (last) 673329 here
>
> Please use rather user ML for such questions :
> http://docs.ofbiz.org/display/OFBADMIN/Mailing+Lists#MailingLists-DeveloperList
> :dev@ofbiz.apache.org
>
> Thanks
>
> Jacques
>
> From: "Ratnesh Upadhyay" <ra...@gmail.com>
>> Getting following error while uploading data :
>>
>> [java] 2008-07-02 13:56:09,272 (main) [
>> GenericDelegator.java:1240:ERROR]
>> [java] ---- exception report
>> ----------------------------------------------------------
>> [java] Failure in store operation for entity [StatusType]:
>> org.ofbiz.entity.GenericEntityException: Error while updating:
>> [GenericEntity:StatusType][description,Project(java.lang.String)]
>> [lastUpdatedStamp,2008-07-02
>> 13:56:09.249(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-02
>> 13:56:09.146(java.sql.Timestamp)]
>> [parentTypeId,PROJECT_STATUS(java.lang.String)]
>> [statusTypeId,WORK_EFF_ASSET_STTS(java.lang.String)]
>> (SQL Exception while executing the following:UPDATE
>> public.STATUS_TYPE SET
>> PARENT_TYPE_ID=?, DESCRIPTION=?, LAST_UPDATED_TX_STAMP=?,
>> LAST_UPDATED_STAMP=? WHERE STATUS_TYPE_ID=? (ERROR: insert or
>> update on
>> table "status_type" violates foreign key constraint
>> "status_type_parent"
>> [java] Detail: Key (parent_type_id)=(PROJECT_STATUS) is not
>> present
>> in table "status_type".)). Rolling back transaction.
>> [java
>>
>>
>> Thank You,
>> Ratnesh
>>
>> On Wed, Jul 2, 2008 at 8:03 AM, <jo...@apache.org> wrote:
>>
>>> Author: jonesde
>>> Date: Tue Jul 1 19:33:00 2008
>>> New Revision: 673262
>>>
>>> URL: http://svn.apache.org/viewvc?rev=673262&view=rev
>>> Log:
>>> Added delegateReasonEnumId to WorkEffortPartyAssignment to keep
>>> track of
>>> why a task was assigned to another person or group
>>>
>>> Modified:
>>> ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
>>> ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>>>
>>> Modified: ofbiz/trunk/applications/workeffort/data/
>>> WorkEffortTypeData.xml
>>> URL:
>>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml?rev=673262&r1=673261&r2=673262&view=diff
>>>
>>> =
>>> =
>>> =
>>> =
>>> =
>>> =
>>> =
>>> =
>>> =
>>> =
>>> ====================================================================
>>> --- ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
>>> (original)
>>> +++ ofbiz/trunk/applications/workeffort/data/
>>> WorkEffortTypeData.xml Tue Jul
>>> 1 19:33:00 2008
>>> @@ -28,13 +28,18 @@
>>> <EnumerationType description="Parent Type for all Work Effort
>>> enum
>>> types" enumTypeId="WORK_EFFORT" hasTable="N" parentTypeId=""/>
>>> <EnumerationType description="Parent Type for all Workflow enum
>>> types"
>>> enumTypeId="WORKFLOW" hasTable="N" parentTypeId=""/>
>>>
>>> - <EnumerationType description="Work Effort Expectations"
>>> enumTypeId="WORK_EFF_EXPECT" hasTable="N"
>>> parentTypeId="WORK_EFFORT"/>
>>> + <EnumerationType description="Work Effort Expectation"
>>> enumTypeId="WORK_EFF_EXPECT" hasTable="N"
>>> parentTypeId="WORK_EFFORT"/>
>>> <Enumeration description="For Your Information" enumCode="FYI"
>>> enumId="WEE_FYI" sequenceId="01" enumTypeId="WORK_EFF_EXPECT"/>
>>> <Enumeration description="Involvement Required"
>>> enumCode="REQUIRE"
>>> enumId="WEE_REQUIRE" sequenceId="02" enumTypeId="WORK_EFF_EXPECT"/>
>>> <Enumeration description="Involvement Requested"
>>> enumCode="REQUEST"
>>> enumId="WEE_REQUEST" sequenceId="03" enumTypeId="WORK_EFF_EXPECT"/>
>>> <Enumeration description="Immediate Response Requested"
>>> enumCode="IMMEDIATE" enumId="WEE_IMMEDIATE" sequenceId="04"
>>> enumTypeId="WORK_EFF_EXPECT"/>
>>>
>>> - <EnumerationType description="Work Effort Scope
>>> Classifications"
>>> enumTypeId="WORK_EFF_SCOPE" hasTable="N"
>>> parentTypeId="WORK_EFFORT"/>
>>> + <EnumerationType description="Work Effort Delegate Reason"
>>> enumTypeId="WORK_EFF_DEL_REAS" hasTable="N"
>>> parentTypeId="WORK_EFFORT"/>
>>> + <Enumeration description="Need Support or Help"
>>> enumCode="NEED_HELP"
>>> enumId="WEDR_NEED_HELP" sequenceId="01"
>>> enumTypeId="WORK_EFF_DEL_REAS"/>
>>> + <Enumeration description="My Part Finished"
>>> enumCode="PART_FINISHED"
>>> enumId="WEDR_PART_FINISHED" sequenceId="02"
>>> enumTypeId="WORK_EFF_DEL_REAS"/>
>>> + <Enumeration description="Completely Finished"
>>> enumCode="WHOLE_FINISHED" enumId="WEDR_WHOLE_FINISHED"
>>> sequenceId="03"
>>> enumTypeId="WORK_EFF_DEL_REAS"/>
>>> +
>>> + <EnumerationType description="Work Effort Scope Classification"
>>> enumTypeId="WORK_EFF_SCOPE" hasTable="N"
>>> parentTypeId="WORK_EFFORT"/>
>>> <Enumeration description="General, public access"
>>> enumCode="PUBLIC"
>>> enumId="WES_PUBLIC" sequenceId="01" enumTypeId="WORK_EFF_SCOPE"/>
>>> <Enumeration description="Restricted, private access"
>>> enumCode="PRIVATE" enumId="WES_PRIVATE" sequenceId="02"
>>> enumTypeId="WORK_EFF_SCOPE"/>
>>> <Enumeration description="Very restricted, confidential access"
>>> enumCode="CONFIDENTIAL" enumId="WES_CONFIDENTIAL" sequenceId="03"
>>> enumTypeId="WORK_EFF_SCOPE"/>
>>> @@ -80,13 +85,26 @@
>>> <StatusValidChange condition="" statusId="CAL_TENTATIVE"
>>> statusIdTo="CAL_CANCELLED" transitionName="Cancel"/>
>>> <StatusValidChange condition="" statusId="CAL_TENTATIVE"
>>> statusIdTo="CAL_CONFIRMED" transitionName="Confirm"/>
>>> <StatusValidChange condition="" statusId="CAL_CONFIRMED"
>>> statusIdTo="CAL_COMPLETED" transitionName="Complete"/>
>>> -
>>> +
>>> + <!-- Project Statuses -->
>>> + <StatusType description="Project" hasTable="N"
>>> parentTypeId="PROJECT_STATUS" statusTypeId="WORK_EFF_ASSET_STTS"/>
>>> + <StatusItem description="Planning" sequenceId="01"
>>> statusCode="PLANNING" statusId="WEPR_PLANNING"
>>> statusTypeId="EVENT_STATUS"/>
>>> + <StatusItem description="In Progress" sequenceId="02"
>>> statusCode="IN_PROGRESS" statusId="WEPR_IN_PROGRESS"
>>> statusTypeId="EVENT_STATUS"/>
>>> + <StatusItem description="Complete" sequenceId="05"
>>> statusCode="COMPLETE" statusId="WEPR_COMPLETE"
>>> statusTypeId="EVENT_STATUS"/>
>>> + <StatusItem description="On Hold" sequenceId="98"
>>> statusCode="ON_HOLD"
>>> statusId="WEPR_ON_HOLD" statusTypeId="EVENT_STATUS"/>
>>> + <StatusItem description="Cancelled" sequenceId="99"
>>> statusCode="CANCELLED" statusId="WEPR_CANCELLED"
>>> statusTypeId="EVENT_STATUS"/>
>>> + <StatusValidChange condition="" statusId="WEPR_PLANNING"
>>> statusIdTo="WEPR_IN_PROGRESS" transitionName="Begin Project"/>
>>> + <StatusValidChange condition="" statusId="WEPR_IN_PROGRESS"
>>> statusIdTo="WEPR_ON_HOLD" transitionName="Begin Project"/>
>>> + <StatusValidChange condition="" statusId="WEPR_ON_HOLD"
>>> statusIdTo="WEPR_IN_PROGRESS" transitionName="Resume Project"/>
>>> + <StatusValidChange condition="" statusId="WEPR_IN_PROGRESS"
>>> statusIdTo="WEPR_CANCELLED" transitionName="Cancel"/>
>>> + <StatusValidChange condition="" statusId="WEPR_ON_HOLD"
>>> statusIdTo="WEPR_CANCELLED" transitionName="Cancel"/>
>>> +
>>> <!-- Status items for
>>> WorkEffortPartyAssignment.availabilityStatusId
>>> -->
>>> <StatusType description="Work Effort Party Availability"
>>> hasTable="N"
>>> parentTypeId="" statusTypeId="WEPA_AVAILABILITY"/>
>>> <StatusItem description="Available" sequenceId="01"
>>> statusCode="AVAILABLE" statusId="WEPA_AV_AVAILABLE"
>>> statusTypeId="WEPA_AVAILABILITY"/>
>>> <StatusItem description="Busy" sequenceId="02" statusCode="BUSY"
>>> statusId="WEPA_AV_BUSY" statusTypeId="WEPA_AVAILABILITY"/>
>>> <StatusItem description="Away" sequenceId="03" statusCode="AWAY"
>>> statusId="WEPA_AV_AWAY" statusTypeId="WEPA_AVAILABILITY"/>
>>> -
>>> +
>>> <WorkEffortAssocType description="Breakdown/Detail" hasTable="N"
>>> parentTypeId="" workEffortAssocTypeId="WORK_EFF_BREAKDOWN"/>
>>> <WorkEffortAssocType description="Dependency" hasTable="N"
>>> parentTypeId="" workEffortAssocTypeId="WORK_EFF_DEPENDENCY"/>
>>> <WorkEffortAssocType description="Concurrency" hasTable="N"
>>> parentTypeId="WORK_EFF_DEPENDENCY"
>>> workEffortAssocTypeId="WORK_EFF_CONCURRENCY"/>
>>>
>>> Modified: ofbiz/trunk/applications/workeffort/entitydef/
>>> entitymodel.xml
>>> URL:
>>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml?rev=673262&r1=673261&r2=673262&view=diff
>>>
>>> =
>>> =
>>> =
>>> =
>>> =
>>> =
>>> =
>>> =
>>> =
>>> =
>>> ====================================================================
>>> --- ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>>> (original)
>>> +++ ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>>> Tue Jul
>>> 1 19:33:00 2008
>>> @@ -668,9 +668,7 @@
>>> <key-map field-name="noteId"/>
>>> </relation>
>>> </entity>
>>> - <entity entity-name="WorkEffortPartyAssignment"
>>> - package-name="org.ofbiz.workeffort.workeffort"
>>> - title="Work Effort Party Assignment Entity">
>>> + <entity entity-name="WorkEffortPartyAssignment"
>>> package-name="org.ofbiz.workeffort.workeffort" title="Work Effort
>>> Party
>>> Assignment Entity">
>>> <field name="workEffortId" type="id-ne"></field>
>>> <field name="partyId" type="id-ne"></field>
>>> <field name="roleTypeId" type="id-ne"></field>
>>> @@ -678,7 +676,8 @@
>>> <field name="thruDate" type="date-time"></field>
>>> <field name="statusId" type="id"></field>
>>> <field name="statusDateTime" type="date-time"></field>
>>> - <field name="expectationEnumId" type="id"></field>
>>> + <field name="expectationEnumId"
>>> type="id"><description>Point to
>>> Enumeration value with enumTypeId="WORK_EFF_EXPECT"</description></
>>> field>
>>> + <field name="delegateReasonEnumId"
>>> type="id"><description>Point to
>>> Enumeration value with enumTypeId="WORK_EFF_DEL_REAS"</
>>> description></field>
>>> <field name="facilityId" type="id"></field>
>>> <field name="comments" type="comment"></field>
>>> <field name="mustRsvp" type="indicator"></field>
>>> @@ -712,14 +711,15 @@
>>> <relation type="one" fk-name="WKEFF_PA_EXP_ENUM"
>>> title="Expectation"
>>> rel-entity-name="Enumeration">
>>> <key-map field-name="expectationEnumId" rel-field-
>>> name="enumId"/>
>>> </relation>
>>> + <relation type="one" fk-name="WKEFF_PA_DELR_ENM"
>>> title="DelegateReason" rel-entity-name="Enumeration">
>>> + <key-map field-name="delegateReasonEnumId"
>>> rel-field-name="enumId"/>
>>> + </relation>
>>> <relation type="one" fk-name="WKEFF_PA_AVSTTS"
>>> title="Availability"
>>> rel-entity-name="StatusItem">
>>> <key-map field-name="availabilityStatusId"
>>> rel-field-name="statusId"/>
>>> </relation>
>>> </entity>
>>> - <entity entity-name="WorkEffortPurposeType"
>>> - package-name="org.ofbiz.workeffort.workeffort"
>>> - title="Work Effort Purpose Type Entity"
>>> - default-resource-name="WorkEffortEntityLabels">
>>> + <entity entity-name="WorkEffortPurposeType"
>>> package-name="org.ofbiz.workeffort.workeffort" title="Work Effort
>>> Purpose
>>> Type Entity"
>>> + default-resource-name="WorkEffortEntityLabels">
>>> <field name="workEffortPurposeTypeId" type="id-ne"></field>
>>> <field name="description" type="description"></field>
>>> <prim-key field="workEffortPurposeTypeId"/>
>>>
>>>
>>>
>
Re: svn commit: r673262 - in /ofbiz/trunk/applications/workeffort: data/WorkEffortTypeData.xml entitydef/entitymodel.xml
Posted by Ratnesh Upadhyay <ra...@gmail.com>.
Jacques ,
I just found out a problem with this particular commit, so I reported here.
BTW i know about the user mailing list ;)
Thanks !
-Ratnesh
On Wed, Jul 2, 2008 at 3:18 PM, Jacques Le Roux <
jacques.le.roux@les7arts.com> wrote:
> Any problems with revision (last) 673329 here
>
> Please use rather user ML for such questions :
>
> http://docs.ofbiz.org/display/OFBADMIN/Mailing+Lists#MailingLists-DeveloperList:dev@ofbiz.apache.org
>
> Thanks
>
> Jacques
>
> From: "Ratnesh Upadhyay" <ra...@gmail.com>
>
> Getting following error while uploading data :
>>
>> [java] 2008-07-02 13:56:09,272 (main) [
>> GenericDelegator.java:1240:ERROR]
>> [java] ---- exception report
>> ----------------------------------------------------------
>> [java] Failure in store operation for entity [StatusType]:
>> org.ofbiz.entity.GenericEntityException: Error while updating:
>>
>> [GenericEntity:StatusType][description,Project(java.lang.String)][lastUpdatedStamp,2008-07-02
>> 13:56:09.249(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-02
>>
>> 13:56:09.146(java.sql.Timestamp)][parentTypeId,PROJECT_STATUS(java.lang.String)][statusTypeId,WORK_EFF_ASSET_STTS(java.lang.String)]
>> (SQL Exception while executing the following:UPDATE public.STATUS_TYPE SET
>> PARENT_TYPE_ID=?, DESCRIPTION=?, LAST_UPDATED_TX_STAMP=?,
>> LAST_UPDATED_STAMP=? WHERE STATUS_TYPE_ID=? (ERROR: insert or update on
>> table "status_type" violates foreign key constraint "status_type_parent"
>> [java] Detail: Key (parent_type_id)=(PROJECT_STATUS) is not present
>> in table "status_type".)). Rolling back transaction.
>> [java
>>
>>
>> Thank You,
>> Ratnesh
>>
>> On Wed, Jul 2, 2008 at 8:03 AM, <jo...@apache.org> wrote:
>>
>> Author: jonesde
>>> Date: Tue Jul 1 19:33:00 2008
>>> New Revision: 673262
>>>
>>> URL: http://svn.apache.org/viewvc?rev=673262&view=rev
>>> Log:
>>> Added delegateReasonEnumId to WorkEffortPartyAssignment to keep track of
>>> why a task was assigned to another person or group
>>>
>>> Modified:
>>> ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
>>> ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>>>
>>> Modified: ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
>>> URL:
>>>
>>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml?rev=673262&r1=673261&r2=673262&view=diff
>>>
>>>
>>> ==============================================================================
>>> --- ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
>>> (original)
>>> +++ ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml Tue
>>> Jul
>>> 1 19:33:00 2008
>>> @@ -28,13 +28,18 @@
>>> <EnumerationType description="Parent Type for all Work Effort enum
>>> types" enumTypeId="WORK_EFFORT" hasTable="N" parentTypeId=""/>
>>> <EnumerationType description="Parent Type for all Workflow enum types"
>>> enumTypeId="WORKFLOW" hasTable="N" parentTypeId=""/>
>>>
>>> - <EnumerationType description="Work Effort Expectations"
>>> enumTypeId="WORK_EFF_EXPECT" hasTable="N" parentTypeId="WORK_EFFORT"/>
>>> + <EnumerationType description="Work Effort Expectation"
>>> enumTypeId="WORK_EFF_EXPECT" hasTable="N" parentTypeId="WORK_EFFORT"/>
>>> <Enumeration description="For Your Information" enumCode="FYI"
>>> enumId="WEE_FYI" sequenceId="01" enumTypeId="WORK_EFF_EXPECT"/>
>>> <Enumeration description="Involvement Required" enumCode="REQUIRE"
>>> enumId="WEE_REQUIRE" sequenceId="02" enumTypeId="WORK_EFF_EXPECT"/>
>>> <Enumeration description="Involvement Requested" enumCode="REQUEST"
>>> enumId="WEE_REQUEST" sequenceId="03" enumTypeId="WORK_EFF_EXPECT"/>
>>> <Enumeration description="Immediate Response Requested"
>>> enumCode="IMMEDIATE" enumId="WEE_IMMEDIATE" sequenceId="04"
>>> enumTypeId="WORK_EFF_EXPECT"/>
>>>
>>> - <EnumerationType description="Work Effort Scope Classifications"
>>> enumTypeId="WORK_EFF_SCOPE" hasTable="N" parentTypeId="WORK_EFFORT"/>
>>> + <EnumerationType description="Work Effort Delegate Reason"
>>> enumTypeId="WORK_EFF_DEL_REAS" hasTable="N" parentTypeId="WORK_EFFORT"/>
>>> + <Enumeration description="Need Support or Help" enumCode="NEED_HELP"
>>> enumId="WEDR_NEED_HELP" sequenceId="01" enumTypeId="WORK_EFF_DEL_REAS"/>
>>> + <Enumeration description="My Part Finished" enumCode="PART_FINISHED"
>>> enumId="WEDR_PART_FINISHED" sequenceId="02"
>>> enumTypeId="WORK_EFF_DEL_REAS"/>
>>> + <Enumeration description="Completely Finished"
>>> enumCode="WHOLE_FINISHED" enumId="WEDR_WHOLE_FINISHED" sequenceId="03"
>>> enumTypeId="WORK_EFF_DEL_REAS"/>
>>> +
>>> + <EnumerationType description="Work Effort Scope Classification"
>>> enumTypeId="WORK_EFF_SCOPE" hasTable="N" parentTypeId="WORK_EFFORT"/>
>>> <Enumeration description="General, public access" enumCode="PUBLIC"
>>> enumId="WES_PUBLIC" sequenceId="01" enumTypeId="WORK_EFF_SCOPE"/>
>>> <Enumeration description="Restricted, private access"
>>> enumCode="PRIVATE" enumId="WES_PRIVATE" sequenceId="02"
>>> enumTypeId="WORK_EFF_SCOPE"/>
>>> <Enumeration description="Very restricted, confidential access"
>>> enumCode="CONFIDENTIAL" enumId="WES_CONFIDENTIAL" sequenceId="03"
>>> enumTypeId="WORK_EFF_SCOPE"/>
>>> @@ -80,13 +85,26 @@
>>> <StatusValidChange condition="" statusId="CAL_TENTATIVE"
>>> statusIdTo="CAL_CANCELLED" transitionName="Cancel"/>
>>> <StatusValidChange condition="" statusId="CAL_TENTATIVE"
>>> statusIdTo="CAL_CONFIRMED" transitionName="Confirm"/>
>>> <StatusValidChange condition="" statusId="CAL_CONFIRMED"
>>> statusIdTo="CAL_COMPLETED" transitionName="Complete"/>
>>> -
>>> +
>>> + <!-- Project Statuses -->
>>> + <StatusType description="Project" hasTable="N"
>>> parentTypeId="PROJECT_STATUS" statusTypeId="WORK_EFF_ASSET_STTS"/>
>>> + <StatusItem description="Planning" sequenceId="01"
>>> statusCode="PLANNING" statusId="WEPR_PLANNING"
>>> statusTypeId="EVENT_STATUS"/>
>>> + <StatusItem description="In Progress" sequenceId="02"
>>> statusCode="IN_PROGRESS" statusId="WEPR_IN_PROGRESS"
>>> statusTypeId="EVENT_STATUS"/>
>>> + <StatusItem description="Complete" sequenceId="05"
>>> statusCode="COMPLETE" statusId="WEPR_COMPLETE"
>>> statusTypeId="EVENT_STATUS"/>
>>> + <StatusItem description="On Hold" sequenceId="98"
>>> statusCode="ON_HOLD"
>>> statusId="WEPR_ON_HOLD" statusTypeId="EVENT_STATUS"/>
>>> + <StatusItem description="Cancelled" sequenceId="99"
>>> statusCode="CANCELLED" statusId="WEPR_CANCELLED"
>>> statusTypeId="EVENT_STATUS"/>
>>> + <StatusValidChange condition="" statusId="WEPR_PLANNING"
>>> statusIdTo="WEPR_IN_PROGRESS" transitionName="Begin Project"/>
>>> + <StatusValidChange condition="" statusId="WEPR_IN_PROGRESS"
>>> statusIdTo="WEPR_ON_HOLD" transitionName="Begin Project"/>
>>> + <StatusValidChange condition="" statusId="WEPR_ON_HOLD"
>>> statusIdTo="WEPR_IN_PROGRESS" transitionName="Resume Project"/>
>>> + <StatusValidChange condition="" statusId="WEPR_IN_PROGRESS"
>>> statusIdTo="WEPR_CANCELLED" transitionName="Cancel"/>
>>> + <StatusValidChange condition="" statusId="WEPR_ON_HOLD"
>>> statusIdTo="WEPR_CANCELLED" transitionName="Cancel"/>
>>> +
>>> <!-- Status items for WorkEffortPartyAssignment.availabilityStatusId
>>> -->
>>> <StatusType description="Work Effort Party Availability" hasTable="N"
>>> parentTypeId="" statusTypeId="WEPA_AVAILABILITY"/>
>>> <StatusItem description="Available" sequenceId="01"
>>> statusCode="AVAILABLE" statusId="WEPA_AV_AVAILABLE"
>>> statusTypeId="WEPA_AVAILABILITY"/>
>>> <StatusItem description="Busy" sequenceId="02" statusCode="BUSY"
>>> statusId="WEPA_AV_BUSY" statusTypeId="WEPA_AVAILABILITY"/>
>>> <StatusItem description="Away" sequenceId="03" statusCode="AWAY"
>>> statusId="WEPA_AV_AWAY" statusTypeId="WEPA_AVAILABILITY"/>
>>> -
>>> +
>>> <WorkEffortAssocType description="Breakdown/Detail" hasTable="N"
>>> parentTypeId="" workEffortAssocTypeId="WORK_EFF_BREAKDOWN"/>
>>> <WorkEffortAssocType description="Dependency" hasTable="N"
>>> parentTypeId="" workEffortAssocTypeId="WORK_EFF_DEPENDENCY"/>
>>> <WorkEffortAssocType description="Concurrency" hasTable="N"
>>> parentTypeId="WORK_EFF_DEPENDENCY"
>>> workEffortAssocTypeId="WORK_EFF_CONCURRENCY"/>
>>>
>>> Modified: ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>>> URL:
>>>
>>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml?rev=673262&r1=673261&r2=673262&view=diff
>>>
>>>
>>> ==============================================================================
>>> --- ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>>> (original)
>>> +++ ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml Tue Jul
>>> 1 19:33:00 2008
>>> @@ -668,9 +668,7 @@
>>> <key-map field-name="noteId"/>
>>> </relation>
>>> </entity>
>>> - <entity entity-name="WorkEffortPartyAssignment"
>>> - package-name="org.ofbiz.workeffort.workeffort"
>>> - title="Work Effort Party Assignment Entity">
>>> + <entity entity-name="WorkEffortPartyAssignment"
>>> package-name="org.ofbiz.workeffort.workeffort" title="Work Effort Party
>>> Assignment Entity">
>>> <field name="workEffortId" type="id-ne"></field>
>>> <field name="partyId" type="id-ne"></field>
>>> <field name="roleTypeId" type="id-ne"></field>
>>> @@ -678,7 +676,8 @@
>>> <field name="thruDate" type="date-time"></field>
>>> <field name="statusId" type="id"></field>
>>> <field name="statusDateTime" type="date-time"></field>
>>> - <field name="expectationEnumId" type="id"></field>
>>> + <field name="expectationEnumId" type="id"><description>Point to
>>> Enumeration value with enumTypeId="WORK_EFF_EXPECT"</description></field>
>>> + <field name="delegateReasonEnumId" type="id"><description>Point to
>>> Enumeration value with
>>> enumTypeId="WORK_EFF_DEL_REAS"</description></field>
>>> <field name="facilityId" type="id"></field>
>>> <field name="comments" type="comment"></field>
>>> <field name="mustRsvp" type="indicator"></field>
>>> @@ -712,14 +711,15 @@
>>> <relation type="one" fk-name="WKEFF_PA_EXP_ENUM" title="Expectation"
>>> rel-entity-name="Enumeration">
>>> <key-map field-name="expectationEnumId" rel-field-name="enumId"/>
>>> </relation>
>>> + <relation type="one" fk-name="WKEFF_PA_DELR_ENM"
>>> title="DelegateReason" rel-entity-name="Enumeration">
>>> + <key-map field-name="delegateReasonEnumId"
>>> rel-field-name="enumId"/>
>>> + </relation>
>>> <relation type="one" fk-name="WKEFF_PA_AVSTTS" title="Availability"
>>> rel-entity-name="StatusItem">
>>> <key-map field-name="availabilityStatusId"
>>> rel-field-name="statusId"/>
>>> </relation>
>>> </entity>
>>> - <entity entity-name="WorkEffortPurposeType"
>>> - package-name="org.ofbiz.workeffort.workeffort"
>>> - title="Work Effort Purpose Type Entity"
>>> - default-resource-name="WorkEffortEntityLabels">
>>> + <entity entity-name="WorkEffortPurposeType"
>>> package-name="org.ofbiz.workeffort.workeffort" title="Work Effort Purpose
>>> Type Entity"
>>> + default-resource-name="WorkEffortEntityLabels">
>>> <field name="workEffortPurposeTypeId" type="id-ne"></field>
>>> <field name="description" type="description"></field>
>>> <prim-key field="workEffortPurposeTypeId"/>
>>>
>>>
>>>
>>>
>>
>
Re: svn commit: r673262 - in /ofbiz/trunk/applications/workeffort: data/WorkEffortTypeData.xml entitydef/entitymodel.xml
Posted by Jacques Le Roux <ja...@les7arts.com>.
Any problems with revision (last) 673329 here
Please use rather user ML for such questions :
http://docs.ofbiz.org/display/OFBADMIN/Mailing+Lists#MailingLists-DeveloperList:dev@ofbiz.apache.org
Thanks
Jacques
From: "Ratnesh Upadhyay" <ra...@gmail.com>
> Getting following error while uploading data :
>
> [java] 2008-07-02 13:56:09,272 (main) [
> GenericDelegator.java:1240:ERROR]
> [java] ---- exception report
> ----------------------------------------------------------
> [java] Failure in store operation for entity [StatusType]:
> org.ofbiz.entity.GenericEntityException: Error while updating:
> [GenericEntity:StatusType][description,Project(java.lang.String)][lastUpdatedStamp,2008-07-02
> 13:56:09.249(java.sql.Timestamp)][lastUpdatedTxStamp,2008-07-02
> 13:56:09.146(java.sql.Timestamp)][parentTypeId,PROJECT_STATUS(java.lang.String)][statusTypeId,WORK_EFF_ASSET_STTS(java.lang.String)]
> (SQL Exception while executing the following:UPDATE public.STATUS_TYPE SET
> PARENT_TYPE_ID=?, DESCRIPTION=?, LAST_UPDATED_TX_STAMP=?,
> LAST_UPDATED_STAMP=? WHERE STATUS_TYPE_ID=? (ERROR: insert or update on
> table "status_type" violates foreign key constraint "status_type_parent"
> [java] Detail: Key (parent_type_id)=(PROJECT_STATUS) is not present
> in table "status_type".)). Rolling back transaction.
> [java
>
>
> Thank You,
> Ratnesh
>
> On Wed, Jul 2, 2008 at 8:03 AM, <jo...@apache.org> wrote:
>
>> Author: jonesde
>> Date: Tue Jul 1 19:33:00 2008
>> New Revision: 673262
>>
>> URL: http://svn.apache.org/viewvc?rev=673262&view=rev
>> Log:
>> Added delegateReasonEnumId to WorkEffortPartyAssignment to keep track of
>> why a task was assigned to another person or group
>>
>> Modified:
>> ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
>> ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>>
>> Modified: ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
>> URL:
>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml?rev=673262&r1=673261&r2=673262&view=diff
>>
>> ==============================================================================
>> --- ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml
>> (original)
>> +++ ofbiz/trunk/applications/workeffort/data/WorkEffortTypeData.xml Tue Jul
>> 1 19:33:00 2008
>> @@ -28,13 +28,18 @@
>> <EnumerationType description="Parent Type for all Work Effort enum
>> types" enumTypeId="WORK_EFFORT" hasTable="N" parentTypeId=""/>
>> <EnumerationType description="Parent Type for all Workflow enum types"
>> enumTypeId="WORKFLOW" hasTable="N" parentTypeId=""/>
>>
>> - <EnumerationType description="Work Effort Expectations"
>> enumTypeId="WORK_EFF_EXPECT" hasTable="N" parentTypeId="WORK_EFFORT"/>
>> + <EnumerationType description="Work Effort Expectation"
>> enumTypeId="WORK_EFF_EXPECT" hasTable="N" parentTypeId="WORK_EFFORT"/>
>> <Enumeration description="For Your Information" enumCode="FYI"
>> enumId="WEE_FYI" sequenceId="01" enumTypeId="WORK_EFF_EXPECT"/>
>> <Enumeration description="Involvement Required" enumCode="REQUIRE"
>> enumId="WEE_REQUIRE" sequenceId="02" enumTypeId="WORK_EFF_EXPECT"/>
>> <Enumeration description="Involvement Requested" enumCode="REQUEST"
>> enumId="WEE_REQUEST" sequenceId="03" enumTypeId="WORK_EFF_EXPECT"/>
>> <Enumeration description="Immediate Response Requested"
>> enumCode="IMMEDIATE" enumId="WEE_IMMEDIATE" sequenceId="04"
>> enumTypeId="WORK_EFF_EXPECT"/>
>>
>> - <EnumerationType description="Work Effort Scope Classifications"
>> enumTypeId="WORK_EFF_SCOPE" hasTable="N" parentTypeId="WORK_EFFORT"/>
>> + <EnumerationType description="Work Effort Delegate Reason"
>> enumTypeId="WORK_EFF_DEL_REAS" hasTable="N" parentTypeId="WORK_EFFORT"/>
>> + <Enumeration description="Need Support or Help" enumCode="NEED_HELP"
>> enumId="WEDR_NEED_HELP" sequenceId="01" enumTypeId="WORK_EFF_DEL_REAS"/>
>> + <Enumeration description="My Part Finished" enumCode="PART_FINISHED"
>> enumId="WEDR_PART_FINISHED" sequenceId="02" enumTypeId="WORK_EFF_DEL_REAS"/>
>> + <Enumeration description="Completely Finished"
>> enumCode="WHOLE_FINISHED" enumId="WEDR_WHOLE_FINISHED" sequenceId="03"
>> enumTypeId="WORK_EFF_DEL_REAS"/>
>> +
>> + <EnumerationType description="Work Effort Scope Classification"
>> enumTypeId="WORK_EFF_SCOPE" hasTable="N" parentTypeId="WORK_EFFORT"/>
>> <Enumeration description="General, public access" enumCode="PUBLIC"
>> enumId="WES_PUBLIC" sequenceId="01" enumTypeId="WORK_EFF_SCOPE"/>
>> <Enumeration description="Restricted, private access"
>> enumCode="PRIVATE" enumId="WES_PRIVATE" sequenceId="02"
>> enumTypeId="WORK_EFF_SCOPE"/>
>> <Enumeration description="Very restricted, confidential access"
>> enumCode="CONFIDENTIAL" enumId="WES_CONFIDENTIAL" sequenceId="03"
>> enumTypeId="WORK_EFF_SCOPE"/>
>> @@ -80,13 +85,26 @@
>> <StatusValidChange condition="" statusId="CAL_TENTATIVE"
>> statusIdTo="CAL_CANCELLED" transitionName="Cancel"/>
>> <StatusValidChange condition="" statusId="CAL_TENTATIVE"
>> statusIdTo="CAL_CONFIRMED" transitionName="Confirm"/>
>> <StatusValidChange condition="" statusId="CAL_CONFIRMED"
>> statusIdTo="CAL_COMPLETED" transitionName="Complete"/>
>> -
>> +
>> + <!-- Project Statuses -->
>> + <StatusType description="Project" hasTable="N"
>> parentTypeId="PROJECT_STATUS" statusTypeId="WORK_EFF_ASSET_STTS"/>
>> + <StatusItem description="Planning" sequenceId="01"
>> statusCode="PLANNING" statusId="WEPR_PLANNING" statusTypeId="EVENT_STATUS"/>
>> + <StatusItem description="In Progress" sequenceId="02"
>> statusCode="IN_PROGRESS" statusId="WEPR_IN_PROGRESS"
>> statusTypeId="EVENT_STATUS"/>
>> + <StatusItem description="Complete" sequenceId="05"
>> statusCode="COMPLETE" statusId="WEPR_COMPLETE" statusTypeId="EVENT_STATUS"/>
>> + <StatusItem description="On Hold" sequenceId="98" statusCode="ON_HOLD"
>> statusId="WEPR_ON_HOLD" statusTypeId="EVENT_STATUS"/>
>> + <StatusItem description="Cancelled" sequenceId="99"
>> statusCode="CANCELLED" statusId="WEPR_CANCELLED"
>> statusTypeId="EVENT_STATUS"/>
>> + <StatusValidChange condition="" statusId="WEPR_PLANNING"
>> statusIdTo="WEPR_IN_PROGRESS" transitionName="Begin Project"/>
>> + <StatusValidChange condition="" statusId="WEPR_IN_PROGRESS"
>> statusIdTo="WEPR_ON_HOLD" transitionName="Begin Project"/>
>> + <StatusValidChange condition="" statusId="WEPR_ON_HOLD"
>> statusIdTo="WEPR_IN_PROGRESS" transitionName="Resume Project"/>
>> + <StatusValidChange condition="" statusId="WEPR_IN_PROGRESS"
>> statusIdTo="WEPR_CANCELLED" transitionName="Cancel"/>
>> + <StatusValidChange condition="" statusId="WEPR_ON_HOLD"
>> statusIdTo="WEPR_CANCELLED" transitionName="Cancel"/>
>> +
>> <!-- Status items for WorkEffortPartyAssignment.availabilityStatusId
>> -->
>> <StatusType description="Work Effort Party Availability" hasTable="N"
>> parentTypeId="" statusTypeId="WEPA_AVAILABILITY"/>
>> <StatusItem description="Available" sequenceId="01"
>> statusCode="AVAILABLE" statusId="WEPA_AV_AVAILABLE"
>> statusTypeId="WEPA_AVAILABILITY"/>
>> <StatusItem description="Busy" sequenceId="02" statusCode="BUSY"
>> statusId="WEPA_AV_BUSY" statusTypeId="WEPA_AVAILABILITY"/>
>> <StatusItem description="Away" sequenceId="03" statusCode="AWAY"
>> statusId="WEPA_AV_AWAY" statusTypeId="WEPA_AVAILABILITY"/>
>> -
>> +
>> <WorkEffortAssocType description="Breakdown/Detail" hasTable="N"
>> parentTypeId="" workEffortAssocTypeId="WORK_EFF_BREAKDOWN"/>
>> <WorkEffortAssocType description="Dependency" hasTable="N"
>> parentTypeId="" workEffortAssocTypeId="WORK_EFF_DEPENDENCY"/>
>> <WorkEffortAssocType description="Concurrency" hasTable="N"
>> parentTypeId="WORK_EFF_DEPENDENCY"
>> workEffortAssocTypeId="WORK_EFF_CONCURRENCY"/>
>>
>> Modified: ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>> URL:
>> http://svn.apache.org/viewvc/ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml?rev=673262&r1=673261&r2=673262&view=diff
>>
>> ==============================================================================
>> --- ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml
>> (original)
>> +++ ofbiz/trunk/applications/workeffort/entitydef/entitymodel.xml Tue Jul
>> 1 19:33:00 2008
>> @@ -668,9 +668,7 @@
>> <key-map field-name="noteId"/>
>> </relation>
>> </entity>
>> - <entity entity-name="WorkEffortPartyAssignment"
>> - package-name="org.ofbiz.workeffort.workeffort"
>> - title="Work Effort Party Assignment Entity">
>> + <entity entity-name="WorkEffortPartyAssignment"
>> package-name="org.ofbiz.workeffort.workeffort" title="Work Effort Party
>> Assignment Entity">
>> <field name="workEffortId" type="id-ne"></field>
>> <field name="partyId" type="id-ne"></field>
>> <field name="roleTypeId" type="id-ne"></field>
>> @@ -678,7 +676,8 @@
>> <field name="thruDate" type="date-time"></field>
>> <field name="statusId" type="id"></field>
>> <field name="statusDateTime" type="date-time"></field>
>> - <field name="expectationEnumId" type="id"></field>
>> + <field name="expectationEnumId" type="id"><description>Point to
>> Enumeration value with enumTypeId="WORK_EFF_EXPECT"</description></field>
>> + <field name="delegateReasonEnumId" type="id"><description>Point to
>> Enumeration value with enumTypeId="WORK_EFF_DEL_REAS"</description></field>
>> <field name="facilityId" type="id"></field>
>> <field name="comments" type="comment"></field>
>> <field name="mustRsvp" type="indicator"></field>
>> @@ -712,14 +711,15 @@
>> <relation type="one" fk-name="WKEFF_PA_EXP_ENUM" title="Expectation"
>> rel-entity-name="Enumeration">
>> <key-map field-name="expectationEnumId" rel-field-name="enumId"/>
>> </relation>
>> + <relation type="one" fk-name="WKEFF_PA_DELR_ENM"
>> title="DelegateReason" rel-entity-name="Enumeration">
>> + <key-map field-name="delegateReasonEnumId"
>> rel-field-name="enumId"/>
>> + </relation>
>> <relation type="one" fk-name="WKEFF_PA_AVSTTS" title="Availability"
>> rel-entity-name="StatusItem">
>> <key-map field-name="availabilityStatusId"
>> rel-field-name="statusId"/>
>> </relation>
>> </entity>
>> - <entity entity-name="WorkEffortPurposeType"
>> - package-name="org.ofbiz.workeffort.workeffort"
>> - title="Work Effort Purpose Type Entity"
>> - default-resource-name="WorkEffortEntityLabels">
>> + <entity entity-name="WorkEffortPurposeType"
>> package-name="org.ofbiz.workeffort.workeffort" title="Work Effort Purpose
>> Type Entity"
>> + default-resource-name="WorkEffortEntityLabels">
>> <field name="workEffortPurposeTypeId" type="id-ne"></field>
>> <field name="description" type="description"></field>
>> <prim-key field="workEffortPurposeTypeId"/>
>>
>>
>>
>