Hi, Im a newbie, have trouble importing my file from http://media.pcna.com/Integration/PCNA-Media.zip. I unzip it and reference the xml file. My goal is to export the xml to a csv file, but can't get it to read.
Can someone help?
Question
Reading XML file and exporting excel or csv
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.
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.
+6- Safer
Hello @estuffs
Here is a tutorial that will help get you started with the Reader configuration when reading in an XML file. https://knowledge.safe.com/articles/29322/xml-reader-configuration.html
In short, when you add the XML reader and point it towards your XML file(you do not need to download and unzip the file, you could just point at the zip url), if you toggle the parameters on the reader, you can choose the Elements to Match. This will open up a tree view of the XML file and will allow you to chose the features you wish to view. I was able to read your XML file with the matched element MediaContents/MediaContent.
I hope that helps