Clarity

In order to XOG out Task Dependencies, tasks must have a task id on it.

From Bookshelf

XML Open Gateway Developer Guide

CA Clarity™ PPM

Release 13.3.00

https://support.ca.com/cadocs/7/CA%20Clarity%20PPM%2013%203%2000%20%20On%20Premise%20-%20Restricted%20Content%20-ENU/Bookshelf_Files/HTML/xog/index.htm

PRTask Schema Tag

This tag is part of the inbound schema mapping for the Project XOG object. PRTeam is populated when you staff a resource to a project.

This tag uses the PRTask table, which can have 0 to many records and where PRTask.prProjectID = PRJ_PROJECTS.prID.

The Task (PRTask) schema tag has the following attributes:

taskID

    Optional. Defines the unique identifier for the task. Required, if referenced by Relation tag or as a sub-project.

    Table and Column: PRTask.prExternalID

    Type: String

Thanks for the tip Robert!

Thanks for this useful info, Robert

NJ

Hello Robert,

I was aware about that requirement however, there are more problems:

If you have a taskID(aka  PREXTERNALID) in all tasks:

• XOG out will include all dependencies in output file
• In order to ensure that all tasks have taskID
  • Before to xog out you should verify every task has taskID
  • From MSP it is possible to avoid TaskID requirement, and Clarity interface will upload these tasks
    • When a end user copy/paste tasks in MSP, they should select the complete row in order to ensure they are copying the hidden taskID field
• Impact (due duplicated taskIDs):
  • In Clarity you cannot copy/paste tasks as expected, even if you cannot paste multiple times a task from a template (an it is a documented Clarity best practice)
  • From MSP if a user copy/paste a task in same project when saving he will receive an error due duplicated taskIDs (see screenshot)

If you have NOT a taskID(aka  PREXTERNALID) in all tasks:

• in Clarity, you can copy/paste multiple times a tasks from same project or a template
• in MSP, you can copy/paste multiple times a tasks from same project
• Impact
  • When you XOG out, output file does not include tasks dependencies and what is worse there is not warnings and you could not realize about it

Since Openworkbench has not that such problem, because it automatically generates a taskID-x  to a duplicated task. I think Clarity and Clarity interface could use same approach than OWB.

Regarding XOG, it should use an internal ID or other solution but in my opinion at the moment it is a DEFECT in XOG

Sorry to say I don't quite get the tip and need more education please.

Reading the

XML Open Gateway Developer Guide

CA Clarity™ PPM

Release 13.3.00

it strikes me that  if you are to XOG out Task Dependencies

then  you are not working with

PRTask Schema Tag

This tag is part of the inbound schema mapping for the Project XOG object

but the outbound schema

Secondly while the task ID may not be a required field and thus there can be tasks that do not have ID.

However, if the external dependency is based on the task ID how do you create that if the task has no ID.

Thirdly my understanding was that you need to have the read filter in your input file.

<args name="include_dependencies" value="true"/>

Educate me plese.

Hello Urmas,

Until latest v13.3.0, document "CAClarityPPM_XOG_DeveloperGuide" never stated about this requirement for xog out a project with tasks and dependencies.

Now documentation covers it, so we could suppose it works as expected. However, changing documentation doesn't solve the problem, because people could not be aware of this detail, know that they have task in their projects with taskid missing,....

Time ago I executed a query to see how many tasks without taskid and having dependencies, we have and I was highly surprised seeing thousands of tasks.

Xml file used for read is "prj_projects_read.xml" and it has as argument

<args name="include_dependencies" value="true"/>

Furthermore this thread is related to an older thread

XOG task dependencies without task has not TaskID

h ttps://communities.ca.com/message/104517946#104517946