Excel to CI Error – Invalid XML Returned

Today one of our users called in stating that they were getting an error while trying to upload the data using the Excel to CI utility. The text of the error was: Error: Invalid XML Returned. The response text is not valid XML. Login Data cleared.

Excel to CI Error - Invalid XML Returned

Upon investigation, it was found that a wrong entry in the Connect Information sheet was the root cause of this error. The PeopleSoft Site Name entered was incorrect. After entering the correct site name, the tool started working perfectly.

Well, another reason for this error to occur would be that none of the Permission Lists that are associated with the user has access to WEBLIB_SOAPTOCI iScript. But in our case, this was ruled out as this user was able to use Excel to CI till the week before.

If you have ruled out the above possibilities, then there could be yet another reason that this may happen. It can be due to the presence of invalid characters in the actual data being uploaded, the most common such character being “&”.