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.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables