topic How do i generate XML using Excel attendee & Meeting files ? in Cloud Collaboration

How do i generate XML using Excel attendee & Meeting files ?

moses.yesunathan — Tue, 09 Aug 2016 09:15:36 GMT

Hi all,

I have an application which only reads XML files sample resonse file format is given below, but now am unable to generate the XML file as the WebEx site is inactive and terminated, but i have the attendee and meeting reports generated in CSV which has all the information needed

to generate the below XMLs.

The two API calls used below are

Attendees: history:lstmeetingattendeeHistoryResponse

Meetings : history:lstmeetingusageHistoryResponse

how do i generate an XML from the excel files in the below format ? help please

ns3:message xmlns:history="http://www.webex.com/schemas/2002/06/service/history" xmlns="http://www.webex.com/schemas/2002/06/common"xmlns:ns3="http://www.webex.com/schemas/2002/06/service" xmlns:user="http://www.webex.com/schemas/2002/06/service/user">

<ns3:header>

<ns3:response>

<ns3:result>SUCCESS</ns3:result>

<ns3:gsbStatus>PRIMARY</ns3:gsbStatus>

</ns3:response>

</ns3:header>

<ns3:body>

<ns3:bodyContent xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="history:lstmeetingattendeeHistoryResponse">

<history:meetingAttendeeHistory>

<history:meetingKey>593091386</history:meetingKey>

<history:confName>MRO Integrator Program- Management review</history:confName>

<history:ipAddress>206.48.240.167</history:ipAddress>

<history:clientAgent>WINDOWS,IE</history:clientAgent>

<history:name>Chan</history:name>

<history:email>chan.@.com</history:email>

<history:joinTime>07/02/2012 19:58:46</history:joinTime>

<history:leaveTime>07/02/2012 20:02:46</history:leaveTime>

<history:duration>4</history:duration>

<history:participantType>ATTENDEE</history:participantType>

<history:voipDuration>0</history:voipDuration>

<history:confID>100967****</history:confID>

</history:meetingAttendeeHistory>

<history:meetingAttendeeHistory>

and the next file is 

<ns3:message xmlns:history="http://www.webex.com/schemas/2002/06/service/history" xmlns="http://www.webex.com/schemas/2002/06/common"xmlns:ns3="http://www.webex.com/schemas/2002/06/service" xmlns:user="http://www.webex.com/schemas/2002/06/service/user">
<ns3:header>
<ns3:response>
<ns3:result>SUCCESS</ns3:result>
<ns3:gsbStatus>PRIMARY</ns3:gsbStatus>
</ns3:response>
</ns3:header>
<ns3:body>
<ns3:bodyContent xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:type="history:lstmeetingusageHistoryResponse">
<history:meetingUsageHistory>
<history:sessionKey>5958266**</history:sessionKey>
<history:confName>- RAPID CHANGE</history:confName>
<history:meetingStartTime>07/02/2012 05:51:18</history:meetingStartTime>
<history:meetingEndTime>07/02/2012 06:23:37</history:meetingEndTime>
<history:duration>33</history:duration>
<history:timezone>GMT+10:00, Australia Eastern (Brisbane)</history:timezone>
<history:trackingCode>
<trackingCode1>Rio Alcan</trackingCode1>
<trackingCode2>76127**</trackingCode2>
<trackingCode3>320 57**</trackingCode3>
<trackingCode4>7081**</trackingCode4>
</history:trackingCode>

Re: How do i generate XML using Excel attendee & Meeting files ?

mifierro — Tue, 09 Aug 2016 16:38:09 GMT

Greetings, Moses! If I understand your question correctly, you are trying to take the output from the WebEx API requests and parse out the responses into an XML document you can then import into another application? Or convert to a .csv file?

If this is the case, then you would need to do this in whatever programming language you are using - i.e. this isn't something you can do directly from the API. You would basically be creating a filter that would take a returned record and parse out the values, dumping them into variables. In psuedocode, this would be:

Get first return record from the WebEx API response
Search for <history:confName>
Put value into local variable strConfName
Loop back to get the next record

You would then use your programming language to write that data out in whatever format you need. Most programming languages have libraries available to help write in XML or CSV formats.

I am not certain what you mean by "the WebEx site is inactive and terminated". If my answer above did not provide the information you need, then let me know what you meant with that statement.

Michael Fierro ● .:|:.:|:.

Customer Support Engineer

Cisco - API Developer Services

Re: How do i generate XML using Excel attendee & Meeting files ?

moses.yesunathan — Tue, 09 Aug 2016 17:30:11 GMT

Hi Michael,

Thanks for your response, I have two Excel reports from a site that was terminated/contract ended site,

The two excel files contain Meeting info and the Attendee , i need them in the XML format to load into my application,

my application is built to read XML files in the format for meeting :"history:lstmeetingusageHistoryResponse" and for

Attendees: history:lstmeetingattendeeHistoryResponse

My concern is here is there a way i can put these 2 excel files ie Meeting and Attendee and get the XML files in the format of API Response : lstmeetingusageHistoryResponse & lstmeetingattendeeHistoryResponse

Re: How do i generate XML using Excel attendee & Meeting files ?

mifierro — Tue, 09 Aug 2016 19:18:33 GMT

In this case, you would basically do the same thing that I mentioned above, but in reverse. The algorithm would be:

Create a string constant that you can use as a template. It might look something like:
"<history:meetingKey>$intMeetingKey</history:meetingKey>\n<history:confName>$strConfName</history:confName>"
Read a line in from your csv/input file
Break the fields up into appropriate variables ($intMeetingKey, $strConfName, etc)
Construct a string with the variables added in the correct locations in your template string
Write this string out to an XML library or directly to a file

As long as you are certain to add in the fields that your other application requires, this should be feasible.