Hi Perl lovers, I am a newbee to perl studiying perl manuals since 20 days and started little programing on additions and regexps and so, on...
Here i need a suggestion from you guys regarding the mysql database and writing a script on RAW CDRs so that i can make billing on that , i will explain my problem some more clearly :-( for every call my Freeradius server is writing records in mysql server, lets say more than one record for ever call may be 2 or may be 10 , but for every record of a call there is unique acctsession id so here i want to take that acctsession id as a key and manipulate the database and write on different table or on different file . the sample record for a call is as follows : RadAcctId | AcctSessionId | callingstationid | calledstation | acctstarttime | acctstoptime 101 | 0051e13de766a328NmY2MmFhZWNmNWE0 | 32331001 | 12345 | 2006-08-10 13:30:04 | 0000-00-00 00:00:00 102 | 0051e13de766a328NmY2MmFhZWNmNWE0 | 32331001 | 12345 | 0000-00-00 00:00:00| 2006-08-10 13:32:06 so this is my problem : in some cases for a call i am getting more than 5 records so Gurus, please give me an out line scenario how to solve this and so that i can write a new table or a new file with manipulating these type of records and get a one record . I hope i will get some suggestions, Thank you. regards, Ravi.