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?
I solved the problem by running Talend Open Studio for Data Integration as an administrator
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema