you can change the delimiter<br><br>Like the example:<br><br>"show calls as csv :::"<br> <br>The data will be sep by ::: instead of comma<br><br>if you would like to make a patch to add "" it would be applied.<br>
<br><br><br><div class="gmail_quote">On Mon, Mar 1, 2010 at 9:29 PM, Wellie Chao <span dir="ltr"><<a href="mailto:wchao@yahoo.com">wchao@yahoo.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
Terrific. "show calls as xml" works great and just what I needed.<br>
<br>
P.S. "show calls as csv" still has the comma bug. Not a big deal since I<br>
can get it as XML. CSV needs quotes around field values that contain a<br>
comma. Pretty easy to fix. Few lines of C (strchr for "," and if found,<br>
put quotes around field value).<br>
<br>
<br>
Date: Mon, 1 Mar 2010 17:24:16 -0600<br>
From: Anthony Minessale <<a href="mailto:anthony.minessale@gmail.com">anthony.minessale@gmail.com</a>><br>
Reply-To: <a href="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</a><br>
To: <a href="mailto:freeswitch-users@lists.freeswitch.org">freeswitch-users@lists.freeswitch.org</a><br>
Subject: Re: [Freeswitch-users] Bug in mod_commands.c with show calls command<br>
<div><div></div><div class="h5"><br>
Perhaps you may be reading up on something quickly and not worrying about<br>
the absolute correctness of something that is not critical to our time to explain.<br>
<br>
The proper syntax for the command is "show calls as xml" and you are not really using XMLRPC you are hitting it via direct url.<br>
so you will then need.<br>
<br>
<a href="http://192.168.1.1:8080/txtapi/show?calls%20as%20xml" target="_blank">http://192.168.1.1:8080/txtapi/show?calls%20as%20xml</a><br>
<br>
<br>
anything in the show command can be replied to with "as xml"<br>
<br>
also, for fun, try<br>
<br>
show calls as csv :::<br>
<br>
<br>
<br>
<br>
On Mon, Mar 1, 2010 at 3:31 PM, Wellie Chao <<a href="mailto:wchao@yahoo.com">wchao@yahoo.com</a>> wrote:<br>
I am using the xml_rpc interface like so:<br>
<br>
<a href="http://192.168.1.1:8080/webapi/show?calls" target="_blank">http://192.168.1.1:8080/webapi/show?calls</a><br>
<br>
I get a response in a table, which is a little bit undesirable because I<br>
want to parse the result in a program and don't want to parse a bunch of<br>
HTML (just seems inelegant and wasteful), so I instead tried the following<br>
request:<br>
<br>
<a href="http://192.168.1.1:8080/txtapi/show?calls" target="_blank">http://192.168.1.1:8080/txtapi/show?calls</a><br>
<br>
That works better, but then another wrinkle appears. Caller ID (and Callee<br>
ID) names sometimes have commas, which messes up the CSV.<br>
<br>
This appears to be a bug in mod_commands.c (or I suppose you could call it<br>
an artifact of somebody coding up something quickly and not worrying about<br>
the absolute correctness of something that is not critical to the core).<br>
There is also another bug with show calls via webapi in that the generated<br>
HTML has spurious <td> tags. I think the spurious <td> tag bug arises due<br>
to lines 3145-6 in mod/applications/mod_commands/mod_commands.c. Finally,<br>
another bug (or maybe just unimplemented feature) is that xmlapl isn't<br>
really different from webapi.<br>
<br>
These problems occur in the latest source tree (20100301).<br>
<br>
I am wondering if (a) one of the developers can fix these or (b) if I fix<br>
the bugs, how can I submit patches [and if I submit patches, will they be<br>
accepted into the main tree]?<br>
<br>
The fixes are pretty trivial and I'd be happy to code them up if somebody<br>
will tell me how I can submit the patches (haven't done it before).<br>
<br>
_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
<br>
<br>
<br>
<br>
--<br>
Anthony Minessale II<br>
<br>
FreeSWITCH <a href="http://www.freeswitch.org/" target="_blank">http://www.freeswitch.org/</a><br>
ClueCon <a href="http://www.cluecon.com/" target="_blank">http://www.cluecon.com/</a><br>
Twitter: <a href="http://twitter.com/FreeSWITCH_wire" target="_blank">http://twitter.com/FreeSWITCH_wire</a><br>
<br>
AIM: anthm<br>
<a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>
GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net" target="_blank">irc.freenode.net</a> #freeswitch<br>
<br>
FreeSWITCH Developer Conference<br>
<a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br>
<a href="http://iax:guest@conference.freeswitch.org/888" target="_blank">iax:guest@conference.freeswitch.org/888</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>
pstn:+19193869900<br>
<br>
<br>
_______________________________________________<br>
FreeSWITCH-users mailing list<br>
<a href="mailto:FreeSWITCH-users@lists.freeswitch.org">FreeSWITCH-users@lists.freeswitch.org</a><br>
<a href="http://lists.freeswitch.org/mailman/listinfo/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/listinfo/freeswitch-users</a><br>
UNSUBSCRIBE:<a href="http://lists.freeswitch.org/mailman/options/freeswitch-users" target="_blank">http://lists.freeswitch.org/mailman/options/freeswitch-users</a><br>
<a href="http://www.freeswitch.org" target="_blank">http://www.freeswitch.org</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br>Anthony Minessale II<br><br>FreeSWITCH <a href="http://www.freeswitch.org/">http://www.freeswitch.org/</a><br>ClueCon <a href="http://www.cluecon.com/">http://www.cluecon.com/</a><br>
Twitter: <a href="http://twitter.com/FreeSWITCH_wire">http://twitter.com/FreeSWITCH_wire</a><br><br>AIM: anthm<br><a href="mailto:MSN%3Aanthony_minessale@hotmail.com">MSN:anthony_minessale@hotmail.com</a><br>GTALK/JABBER/<a href="mailto:PAYPAL%3Aanthony.minessale@gmail.com">PAYPAL:anthony.minessale@gmail.com</a><br>
IRC: <a href="http://irc.freenode.net">irc.freenode.net</a> #freeswitch<br><br>FreeSWITCH Developer Conference<br><a href="mailto:sip%3A888@conference.freeswitch.org">sip:888@conference.freeswitch.org</a><br><a href="http://iax:guest@conference.freeswitch.org/888">iax:guest@conference.freeswitch.org/888</a><br>
<a href="mailto:googletalk%3Aconf%2B888@conference.freeswitch.org">googletalk:conf+888@conference.freeswitch.org</a><br>pstn:+19193869900<br>