Skip to main content
Solved

Excel to XML causing bad encoding (UTF-8)

  • January 17, 2019
  • 2 replies
  • 200 views
F

I'm trying to create a workspace to create a XML file from an excel-report (Sample) and an excelfile containg some other information (Blad1). However I'm running in to issues with the encoding of the created file. It seems like textwriter is not able to output UTF-8 encoded characters (input contains Swedish characters like åäö).

 

Trying to understand where in the process this gets wierdly formatted but loggers seem to show the right characters.

 

When I exchange these characters manually in the output XML file the validationservice I'm using is working.

 

Anyone who can point out how to fix this? Kind regards.

 

Best answer by lenaatsafe

Hi @flyell

could you please check what the encoding of the values leaving XMLTemplater is and whether the values look right? Also: is Text File Writer Character Encoding parameter set to UTF-8?

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

L
Forum|alt.badge.img
  • lenaatsafe
  • Best Answer
  • January 17, 2019

Hi @flyell

could you please check what the encoding of the values leaving XMLTemplater is and whether the values look right? Also: is Text File Writer Character Encoding parameter set to UTF-8?

F
  • flyell
  • Author
  • January 18, 2019

Hi @flyell

could you please check what the encoding of the values leaving XMLTemplater is and whether the values look right? Also: is Text File Writer Character Encoding parameter set to UTF-8?

It was the Text File Writer Character Encoding that needed to be changed. Thanks for the answer!

Community Stats

32,207
Posts
122,303
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.