<div class="gmail_quote">On Mon, Dec 10, 2012 at 11:02 PM, Joseph <span dir="ltr"><<a href="mailto:syscon780@gmail.com" target="_blank">syscon780@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>On 12/10/12 20:45, Steve Edwards wrote:<br>
</div><div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
On Mon, 10 Dec 2012, Joseph wrote:<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
When a call comes in asterisk records the date correctly but when I cake a<br>
call out I get only something like:<br>
Date: 60<br>
here is an example:<br>
<br>
From: "<a href="tel:7807560785" value="+17807560785" target="_blank">7807560785</a>"<br>
To: "s"<br>
Date: "2012-12-11 00:46:04"<br>
Status: "ANSWERED"<br>
----------------<br>
<br>
From: "5"<br>
To: "4331235"<br>
Date: 60<br>
Status: 4<br>
</blockquote>
<br>
What version of Asterisk?<br>
<br>
Where are you seeing the data you display above?<br>
<br>
-- <br>
Thanks in advance,<br>
------------------------------<u></u>------------------------------<u></u>-------------<br>
Steve Edwards <a href="mailto:sedwards@sedwards.com" target="_blank">sedwards@sedwards.com</a> Voice: <a href="tel:%2B1-760-468-3867" value="+17604683867" target="_blank">+1-760-468-3867</a> PST<br>
Newline Fax: <a href="tel:%2B1-760-731-3000" value="+17607313000" target="_blank">+1-760-731-3000</a><br>
</blockquote>
<br></div>
I'm using this command to pull the records of the cvs:<br>
grep -P '\d{4}-\d{2}-\d{2}\s\d{2}:\d{<u></u>2}:\d{2}' /var/log/asterisk/cdr-csv/*.<u></u>csv | cut -d, -f2,3,10,15 | awk -F"," {'print "From:\t"$1"\nTo:\t"$2"\nDate:<u></u>\t"$3"\nStatus:\t"$4"\n-------<u></u>---------\n"'} |tail -60<br>
<br>
the actual last records in Master.csv is:<br>
"","5","218","internal","""<u></u>Cerra"" <5>","IAX2/192.168.141.1:4569-<u></u>4374","SIP/11-00000180","Dial"<u></u>,"SIP/11&SIP/321&SIP/218,25,m(<u></u>penguin)w","2012-12-11 02:58:53","2012-12-11 02:58:59","2012-12-11 03:00:00",67,61,"ANSWERED","<u></u>DOCUMENTATION","1355194733.<u></u>524",""<br>
<br>
but with the above command it display:<div><br>
From: "5"<br>
To: "218"<br>
Date: 25<br>
Status: 67<br>
<br>
-- <br></div><span><font color="#888888">
Joseph</font></span><div><div><br>
<br>
--<br>
______________________________<u></u>______________________________<u></u>_________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/<u></u>mailman/listinfo/asterisk-<u></u>users</a><br>
</div></div></blockquote></div><div><br></div>The problem is not exactly Asterisk, it is how the data being parsed from the CSV file. If you look at the data, each field is enclosed with double quotes. One field in particular may have commas embedded within the double quotes. For instance, in your data there is one field that looks like this: <div>
<br></div><div>"SIP/11&SIP/321&SIP/218,25,m(penguin)w"</div><div><br></div><div>Using the 'cut' utility does not take into account the quoiting, so cut happily chops that one field into three. This causes the date and status field numbers to be different (according to cut) and therefore your request for fields 10 and 15 return the wrong columns. To compound the issue, some records do not have the extra commas so you cannot simply change the field numbers.</div>
<div><br></div><div>I have not spent any real time looking at a way to deal with this using command line utilities because I read the data from a mysql database. Another option would be to read the data into a spreadsheet. You could also write a script around what you are doing and parts records differently based on the 'last appliation' such as Dial, Read, Voicemail.</div>
<div><br></div><div>I hope that helps.</div><div><br></div><div>Dale</div>