Clarity PPM: How to Remove Special Characters from .xml files used with XOG

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

At several occasions while using Clarity XML Open Gateway (XOG) action between environments, you may face an issue of XOG returning an error because of special characters inside the read or write XML file being used. How do we find all the special characters that will cause this problem?

Environment

Release: Any

Resolution

Use the following steps to modify the xml file with the issue:

1. Make a copy of your XML file in case you need to start over
2. Open the xml file in any Text editor supporting Regular Expression Find/Replace feature
3. Open the Find/Replace edit window
4. Select the Regular Expression option
5. Find : [^&;:()a-zA-Z0-9" =./><_-~-]
6. Replace with non special characters
7. Save the file and perform the XOG action again