Error within XML-metadata creation process - HELP

One Star

Error within XML-metadata creation process - HELP

Hello community,

I want to map a XML-File to a CSV-File with Talend Open Studio for Data Integration but I've got a problem within the XML-metadata creation process. I use a simple XML-File with UTF-8 encoding.
To create the metadata file I follow these steps (These steps out of the book "Getting Started with Talend Open Studio for Data Integration by Jonathan Bown"):

Repository -> Meta-Data -> XML-File -> create XML-File -> Input XML -> Select File -> Encoding UTF-8 -> Select the XPath Loop Expression and the fields

Then when I click on "Refresh Preview" I receive an error message:
"Preview error. Some settings must be changed. Note: Preview errors are generelly due to wrong encoding setting."
What's the problem?

Thanks
Marc

Highlighted
One Star

Re: Error within XML-metadata creation process - HELP

Hi Marc

It might be the type of encoding. In e.g. Notepad++ files are distinguished in UTF-8 with or without BOM. As I recall, Talend prefers without :-)

See the attached screenshot from Notepad++:
One Star

Re: Error within XML-metadata creation process - HELP

Hello Lise,

thank you very much for your message.
I solved the problem by running Talend Open Studio for Data Integration as an administrator.

Marc
Seventeen Stars

Re: Error within XML-metadata creation process - HELP

hi,


I solved the problem by running Talend Open Studio for Data Integration as an administrator


It's not a good thing to run as admin.
Create a Talend workspace like c:/Talend where you don't need to be admin to create/modify files.

regards

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 2

Part 2 of a series on Context Variables

Blog

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog