I Had posted this in administration XML forum as well, but this seems more appropriate:
CUCM 8.5.1
Using Curl to grab perfmon counters from servers in a cluster - I get the xml file back and ahve done some parsing to get what I wanted but now trying to
use Spreadsheet::WriteExcel::FromXML (
http://search.cpan.org/dist/Spreadsheet-WriteExcel-FromXML/lib/Spreadsheet/WriteExcel/FromXML.pm) perl module
to import the output of some of these directly to excel. In particular, trying to get the SipStack perfmon data returned (
http://www.cisco.com/en/US/docs/voice_ip_comm/cucm/service/8_5_1/rtmt/rtpmcm.html#wp1071553).
This module seems to work well for other well-formed xml files, but I'm getting some unrecognized type errors when trying to import the output.
Has anyone here successfully used WriteExcel::FromXML to import cucm xml outputs directly into exce?
Is there a better method to be able to pull the perfmon counter data into an excel sheet?
Thanks!