Link to home
Start Free TrialLog in
Avatar of SASnewbie
SASnewbie

asked on

Parse XML file to visually display tree and details

Hi,

In need of a tool to parse an XML file to be able to see the parent/child in tree diagram and all tool configuration details.

Thanks,
AlteryxDocument-yxmdVer.xml
Avatar of Rob
Rob
Flag of Australia image

I use XML notepad to easily visualise an XML file: https://www.microsoft.com/en-au/download/details.aspx?id=7973

You can also open it in most web browsers and it will display nicely as well.
In addition to XML Notepad, I also use XMLPad.
http://wmhelp.com/
Avatar of SASnewbie
SASnewbie

ASKER

Thank you for the suggestions. These can come in handy at some point. but what I am looking for is a tool that will graphically display the nodes, parent/children and details.

For example:
              <ChildNodes>
                <Node ToolID="4660">
                  <GuiSettings Plugin="AlteryxBasePluginsGui.Filter.Filter">
                    <Position x="1002" y="7134" />
                  </GuiSettings>
                  <Properties>
                    <Configuration>
                      <Expression><![CDATA[ ([Channel] IN ("Indirect")
AND
[Product Code] IN ("350", "354", "378", "380", "381", "383", "383", "384", "385", "386", "387", "388", "394", "395", "396", "397", "398", "885", "890", "403","405"))
AND
([Sales Channel] NOT IN ("Direct","DIRECT","US Customer Center","US Customer Centers","Northern Latin America","Southern Latin America","Latin America AS", "Latin America TFM")
AND
[Product Type Code]!="80")
AND
[Branch] NOT IN ("GOVERNMENT","ITS Internal Product Request", "Warranty & Goodwill Order Processing", "Direct Sales & Service","ZEKS")
AND [Product Family] not in ("Air", "Fluid")
AND FINDSTRING([CCN],"GENERAL MISC COMP")=-1
]]></Expression>
                      <Mode>Custom</Mode>
                    </Configuration>
                    <Annotation DisplayMode="0">
                      <Name />
                      <DefaultAnnotationText><![CDATA[ ([Channel] IN ("Indirect")
AND
[Product Code] IN ("350", "35...]]></DefaultAnnotationText>
                                   </Node>
I think what you're looking for is a tool with xquery support.  There are both downloadable and online tools that might work, but I have no experience with any of them.  Have you looked at any of these tools?
Attached is an example of what I need:
Capture.PNG
Hi aikimark,

Will search for xquery support. I didn't know what to look for, but will do so now.

Thanks!
SOLUTION
Avatar of aikimark
aikimark
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi Pravin,,

Will do!

Thanks!
Thanks,

Glad to be of some help