Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Problem with importing certain columns of a MS Project file into RTC

I have a Microsoft Project file that has a "WBS" column as well as a "Predecessors" column.  I have saved that file as an XML file and have successfully imported it into RTC.  However, it is not importing the WBS and Predecessors data.  I have even tried adding an attribute called "WBS" on the task work item and it is still not importing the WBS data into the RTC tasks.  Is there a way to get these 2 columns of data to import properly into the RTC task work items?

0 votes



2 answers

Permanent link
My suggestion would be to create a small export out of RTC to see which format the XML should have. I have, in the past, been able to get dependencies recreated in RTC.

0 votes


Permanent link

I've been able to get links (predecessor, parent, child, etc.) to import from an excel file by labeling the column with the correct link name and putting a "#" sign followed by the work item ID.  But these Predecessors are the line item from the Project file, so not the same as the ID for the RTC work item.

Still have the issue of not having the WBS field not showing up in the RTC task.  The interesting thing is that I saved a project file in XML.  Then imported it into RTC.  Then I went to that plan in RTC and exported the plan into an XML file.  Interestingly, it saves the MS Project information somewhere within RTC because it exported the WBS and other data into my new XML file.  Therefore, it is storing it someplace in RTC.  How do I get the WBS field to show up on an RTC task work item?

Here is an excerpt of one of the tasks as exported from RTC into XML (with an origin of being saved as a MS Project XML file and imported into RTC to create the task):

<Task>

<UID>6</UID>

<ID>6</ID>

<Name>Input expenditures for contractor personnel - November</Name>

<Type>0</Type>

<IsNull>0</IsNull>

<WBS>1.1.1.1.1.1</WBS>

<OutlineNumber>1.1.1.1.1.1</OutlineNumber>

<OutlineLevel>6</OutlineLevel>

<Start>2014-08-04 14:18:44</Start>

<Finish>2014-08-05 14:18:44</Finish>

<Work>PT8H0M0S</Work>

<Duration>PT8H0M0S</Duration>

<RemainingDuration>PT8H0M0S</RemainingDuration>

<ActualStart/>

<ActualFinish/>

<ActualDuration>PT0H0M0S</ActualDuration>

<ActualWork>PT0H0M0S</ActualWork>

<Milestone>0</Milestone>

<Summary>0</Summary>

<FixedCostAccrual>3</FixedCostAccrual>

<PercentComplete>0</PercentComplete>

<ConstraintType>4</ConstraintType>

<ConstraintDate>2014-11-15T08:00:00</ConstraintDate>

<HyperlinkAddress/>

<Notes/>

<Deadline/>

<ExtendedAttribute>

<FieldID>188743734</FieldID>

<Value>New</Value>

</ExtendedAttribute>

<ExtendedAttribute>

<FieldID>188743737</FieldID>

<Value/>

</ExtendedAttribute>

<ExtendedAttribute>

<FieldID>188743945</FieldID>

<Value/>

</ExtendedAttribute> -

<ExtendedAttribute>

<FieldID>188743767</FieldID>

<Value>3711</Value>

</ExtendedAttribute>

<ExtendedAttribute>

<FieldID>188743740</FieldID>

<Value/>

</ExtendedAttribute>

<PredecessorLink>

<PredecessorUID/>

<Type>1</Type>

<CrossProject>0</CrossProject>

<LinkLag>0</LinkLag>

<LagFormat>7</LagFormat>

</PredecessorLink>

</Task>

 

As you can see the WBS number is stored somewhere since it is showing up in the XML export from RTC.  How can I get that data into an attribute on my RTC task work item??

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Aug 01 '14, 3:36 p.m.

Question was seen: 4,799 times

Last updated: Aug 04 '14, 5:23 p.m.

Confirmation Cancel Confirm