AXL perfmon counter output

Version 1
    This document was generated from CDN thread

    Created by: Chester Rieman on 31-05-2012 08:58:06 AM
    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!
     
     

    Subject: Re: New Message from Chester Rieman in Administration XML (AXL) - Administr
    Replied by: Carlos Sanz on 31-05-2012 08:59:15 AM
    Hola, hasta el día 25-Junio estaré fuera de oficina y no tendré acceso
    al correo. Por asuntos urgentes por favor contactad con el
    comunicacionesunificadas@acuntia.es

    Hello, until day 25-Jun I will not  have access to the mail. For
    urgent issues please contact with comunicacionesunificadas@acuntia.es

    --
    Un Saludo,

    Carlos Sanz
    Dpto Proyectos y Consultoría.
    Área de Comunicaciones Unificadas & Colaboración.

    Dirección:       Valle de la Fuenfría 3,
                            28034 Madrid España
    Teléfono:        +34 91 456 00 08
    Móvil:              +34 618 18 55 02
    E-Mail:            carlos.sanz@acuntia.es <Lcarlos.sanz@acuntia.es>
    Web:               http://www.acuntia.es

    --


    P Antes de imprimir este mensaje, por favor, compruebe que es necesario. Proteger
    el medio ambiente está también en su mano *.*ü

    **** DISCLAIMER****
    Este e-mail contiene información confidencial, el contenido de la misma se
    encuentra protegido por Ley. Cualquier persona distinta a su destinataria
    tiene prohibida su reproducción, uso, divulgación o impresión total o
    parcial. Si ha recibido este mensaje por error, notifíquelo de inmediato al
    remitente borrando el mensaje original juntamente con sus ficheros anexos.
    Gracias

    This e-mail contains confidencial information protected by Law. It is
    prohibited to reproduce, use, disclose and totally or partially print the
    content of this e-mail to any person other than intended recipient. If you
    have received this message by mistake, please notify immediately the sender
    and delete the original message jointly with all attached files. Thank you.

    Subject: RE: AXL perfmon counter output
    Replied by: David Staudt on 04-09-2012 05:50:40 PM
    Can you provide a sample of the XML output from Perfmonport?  Do you have any idea which fields your module is having a problem with?