Special Character coming at Runtime.

[former_member751869]

Hello Experts,

I have CSV to XML converter. E2E flow is SFTP to ODATA.

After file getting converted to xml in Xml special character is coming.

How to solve this. so my mapping is running in simulation. but when i run E2E scenario, its failing.

Can any one of you please help.

Thanks.

Chaitanya

[yatanveersingh · Accepted solution]

Hi Chaitanya,

I believe the data in the file is having special char, due to this after conversion its getting converted to �H.

Do you know which char in the file is getting converted to this special char, can you manually remove some data and try to dot down to the char. Once you are able to find out the charater or word, manually type it and rerun the file.

Usually if the data is copied from pdf files some time we end up having this issue.

This is encoding issue.

Regards,

Yatan

[former_member221486 · Accepted solution]

yes. I have asked source system. And it worked!
I have one more doubt, how to do validations for incoming CSV file, if file header is missing or incorrect format then email should send so they will resend file with correct details.
Can you help with any groovy code please.

[yatanveersingh · Accepted solution]

If the issue is resolved, you can close this thread, and start a seperate thread for the error handling for file read.

[Sriprasadsbhat]

Hello Chaitanaya,

Could you please share some payload which shows special character appearing after conversion( Sample input and output ).Also please check your input CSV data for any such characters.

Regards,

Sriprasad Shivaram Bhat

[former_member751869]

Hi Sriprasad,

Input payload -
H,test,20210513,184536,test Apr 2021,3,,,,,

1,1,I22S,20210430,0L,test,NI22S003550.4,,,, 2,1269240001,,100.23,Test,NI22S005501.1,120,I22828,I22829,DEUS05,100053 2,6419197001,100.23,,Test,NI22S005501.1,500,I22828,I22829,DEUS05,100053 1,2,I22S,20210430,0L,Test,NI22S003550.4,,,, 2,1269240001,,200000,Test,NI22S005501.1,120,I22828,I22829,DEUS05,100053 2,6419197001,200000,,Test,NI22S005501.1,500,I22828,I22829,DEUS05,100053

F,20210513,184536,3,,,,,,,

O/P -

<RECORD_IDENTIFIER>�H</RECORD_IDENTIFIER>

and forward by payload.