It's all about the answers!

Ask a question

Does Rational support state modifications from .csv?

Christopher McKay (2687) | asked Oct 26 '10, 4:06 a.m.
If I export a RTC query to a .csv file, I can modify the states in the .csv file and re-import the file back into RTC. An advantage to this approach is the ability to modify a large number of RTC work items and then re-import the file back in.

Does Rational support this capability or should I avoid this idea?

Thank you for your help.

3 answers

permanent link
Benjamin Chodroff (8985231) | answered Jan 16 '11, 9:04 p.m.
We do not support this and I'd avoid this. In RTC 3 we have more capabilities to modify a field across multiple work items.

permanent link
Sean G Wilbur (87222421) | answered Jan 18 '11, 9:44 a.m.

If you have batch updates that you need to do regularly and cannot do them from the clients, I would recommend submitting enhancement requests describing the scenarios that you are looking for that are not currently covered and to help you in the short term investing some time to develop helper scripts/code using the API to meet your needs.


permanent link
Christian Morgan (317714) | answered Jan 19 '11, 9:05 a.m.
We do not support this and I'd avoid this. In RTC 3 we have more capabilities to modify a field across multiple work items.

Why exactly is this not supported and why would you avoid it?

We certainly can do multiple WI state changes using the UI, but you have to have a path from the current to target states. If one doesn't exist then prior to doing the mass update you would have to modify the workflow account for the action then cleanup afterwards by removing the action. This also doesn't address a scenario where you have multiple WIs in different states and would have to setup many legal transitions from various states to the target.

I have done this a few times w/ 3.0 and have had no issue. I have seen that you have to be absolutely certain that the states in the import file are an exact match to the ones in the WI type workflow, otherwise they wind up in an uninitialized state and will have to be corrected, through a batch update (.csv). For example if the legitimate state is "In Progress" and in the csv it is listed as "in Progress" the WIs would be updated but end up uninitialized.

If there are any other issues that result from importing and updating states in this method I'd be very interested to know. We have imported a large volume of records from another CRM system and have to do occasional tweaks to the previously imported records which sometimes includes modifying states in batch.

Your answer

Register or 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.