You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ICS | How To Write CSV File With Commas In Values

edited Jun 26, 2018 8:02PM in Integration 4 comments

Summary

When writing CSV files with commas in values I get the error - Translation to native failed. Element 'elementName' not expected..

Content

Hi,

I'm writing a csv file using the "Stage File" action. The values to be populated in the csv file come from a SOAP web service response. Some of the values returned in the response contain commas in them. When writing such values into the csv file I get the following exception:

 

<Jun 26, 2018 7:00:03 PM UTC> <Error> <oracle.soa.translator.nxsd> <BEA-000000> <translateToNative call failed with exception : Element '********' not expected.> 
<Jun 26, 2018 7:00:03 PM UTC> <Error> <oracle.soa.Logger> <BEA-000000> <Error occured in WriteAppendFile with error Translation Failure.
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!