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?
+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
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.