Clearing formatting on multiple artifacts on RM
We noticed that when exporting some JRS reports to excel, there were some artifacts that had some formatting tags on the spreadsheet (something like "<span style="-webkit-text-stroke-width:0px; color:#000000; display:inline !important; etc etc etc"). This seems to be due to some rich text formatting that snuck into some artifacts, probably during previous edit work done by the team. Is there a good way to clear this formatting besides a roundtrip export/import using CSV?
2 answers
Hi Lita,
I had some success doing a ReqIf export, unzipping, editing the file to remove the unwanted styling in a text editor (Notepad++) zipping back up again and then reimporting.
But I found that sometimes on import attribute values got corrupted. IBM insist this can't happen even after I demonstrated it to them via a remote desktop session. But since they can't reproduce it they basically say that they can't do anything about the bug.
If you try this method, do it in a Change Set and make sure that you have no unexpected changes