Welcome to the new Schneider Electric Community

It's your place to connect with experts and peers, get continuous support, and share knowledge.

  • Explore the new navigation for even easier access to your community.
  • Bookmark and use our new, easy-to-remember address (community.se.com).
  • Get ready for more content and an improved experience.

Contact SchneiderCommunity.Support@se.com if you have any questions.

Close
Invite a Co-worker
Send a co-worker an invite to the Exchange portal.Just enter their email address and we’ll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
84865members
354354posts

View .XML data from ION Setup?

Metering & Power Quality

Collaborate with multiple experts and discuss various topics about Power Meters and Power Quality. From design & implementation to troubleshooting and more, get support from experts and share your experiences by subscribing to the Schneider Electric Exchange forum today.

engineer_langfo
Lieutenant JG
Lieutenant JG

View .XML data from ION Setup?

this question was partially answered in another thread :"Scripting ION Setup for downloading..."

 

However, is there any way to view or extract the .XML file data that is generated by ION Setup? 
I am specifically referring to the tab under Reports / "Data Collection" .  While the other reports can be saved as .CSV, this one is strictly .XML. 

The question has been made to me:  Why not .CSV? 

and more importantly:  

How can the data be viewed or extracted from the .XML into a spreadsheet?

Tags (2)
1 Reply 1
Robert_Lee
Captain Captain
Captain

Re: View .XML data from ION Setup?

The Data Collection option is generated as an easy means to collect data from a remote device for the sole purpose of importing that information into PME (i.e. no permanent communication connection is available between the PME server and remote ION device so this was developed to allow someone to go out to the device and remotely extract that information to be imported into PME for processing).

While CSV is available as a file format for storage, we didn't want to promote ION Setup to be used some type of free data collection tool where a more sophisticated one like PME is far superior.  You would NOT use the XML format for anything but for PME (so if you do want to pull data into Excel, upload information and save it as CSV, not XML).