Tutorial - CVP VXML Array - How to parse log with notepad++

J_Cormier · ‎02-27-2023

I just wanted to share the way I've find how to parse the CVP VXML log to be ready to be imported in Excel

Then you can mesure the length of the array with =len() in Excel

1. Add this Macro to your application: You can paste this code to your %APPDATA%\Notepad++\shortcut.xml

       <Macro name="ParseCVP_VXMLLogs" Ctrl="no" Alt="no" Shift="no" Key="0">
            <Action type="3" message="1700" wParam="0" lParam="0" sParam="" />
            <Action type="3" message="1601" wParam="0" lParam="0" sParam="USER_MICROAPP_TOEXTVXML" />
            <Action type="3" message="1625" wParam="0" lParam="1" sParam="" />
            <Action type="3" message="1602" wParam="0" lParam="0" sParam="\nUSER_MICROAPP_TOEXTVXML " />
            <Action type="3" message="1702" wParam="0" lParam="256" sParam="" />
            <Action type="3" message="1701" wParam="0" lParam="1609" sParam="" />
            <Action type="3" message="1700" wParam="0" lParam="0" sParam="" />
            <Action type="3" message="1601" wParam="0" lParam="0" sParam="USER_MICROAPP_fromEXTVXML" />
            <Action type="3" message="1625" wParam="0" lParam="1" sParam="" />
            <Action type="3" message="1602" wParam="0" lParam="0" sParam="\nUSER_MICROAPP_fromEXTVXML" />
            <Action type="3" message="1702" wParam="0" lParam="256" sParam="" />
            <Action type="3" message="1701" wParam="0" lParam="1609" sParam="" />
            <Action type="3" message="1700" wParam="0" lParam="0" sParam="" />
            <Action type="3" message="1601" wParam="0" lParam="0" sParam="Peripheral Variables=" />
            <Action type="3" message="1625" wParam="0" lParam="1" sParam="" />
            <Action type="3" message="1602" wParam="0" lParam="0" sParam="\nPeripheral Variables=" />
            <Action type="3" message="1702" wParam="0" lParam="256" sParam="" />
            <Action type="3" message="1701" wParam="0" lParam="1609" sParam="" />
            <Action type="3" message="1700" wParam="0" lParam="0" sParam="" />
            <Action type="3" message="1601" wParam="0" lParam="0" sParam="^&#x0009;[Ligne].*" />
            <Action type="3" message="1625" wParam="0" lParam="2" sParam="" />
            <Action type="3" message="1602" wParam="0" lParam="0" sParam="" />
            <Action type="3" message="1702" wParam="0" lParam="768" sParam="" />
            <Action type="3" message="1701" wParam="0" lParam="1609" sParam="" />
            <Action type="3" message="1700" wParam="0" lParam="0" sParam="" />
            <Action type="3" message="1601" wParam="0" lParam="0" sParam="^  [c:].*" />
            <Action type="3" message="1625" wParam="0" lParam="2" sParam="" />
            <Action type="3" message="1602" wParam="0" lParam="0" sParam="" />
            <Action type="3" message="1702" wParam="0" lParam="768" sParam="" />
            <Action type="3" message="1701" wParam="0" lParam="1609" sParam="" />
            <Action type="2" message="0" wParam="42055" lParam="0" sParam="" />
        </Macro>

3. Copy a bunch of file from C:\Cisco\CVP\logs\VXML

4. With notepad++, use the search in files ECC ECC arrays=

5. Copy the result of this search and copy it in a new file in notepad++

6. Run the macro

7.Copy the content in excel in 1 column

8.Add =LEN([@Array])-27 (-27 number of caracters USER_MICROAPP_FROMEXTVXML[3]:)

Let me know if it work for you, I can ajust the tutorial if needed.