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?
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?
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