dear all i have installed mod_nibblebill and works perfectly, can nibble_bill produce cdr with info for calling and called number? regards budi
Nibble bill does not produce a separate CDR. However, the variables and their values will be recorded if you are using XML CDR. Regards HASSAN On 2010-11-01, budi wibowo <bwibowo@gmail.com> wrote:
dear all i have installed mod_nibblebill and works perfectly, can nibble_bill produce cdr with info for calling and called number?
regards
budi
-- Sent from my mobile device
i use csv cdr (sql insert ) and use cron import to postgresql every 10 minutes. Dome C. 2010/11/1 Nyamul Hassan <mnhassan@usa.net>:
Nibble bill does not produce a separate CDR. However, the variables and their values will be recorded if you are using XML CDR.
Regards HASSAN
On 2010-11-01, budi wibowo <bwibowo@gmail.com> wrote:
dear all i have installed mod_nibblebill and works perfectly, can nibble_bill produce cdr with info for calling and called number?
regards
budi
-- Sent from my mobile device
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
yes i use the perl script, but it doesnt explain which call with how many amount is deducted from the account thx budi On Tue, Nov 2, 2010 at 5:08 PM, Dome Charoenyost <dome@tel.co.th> wrote:
i use csv cdr (sql insert ) and use cron import to postgresql every 10 minutes.
Dome C.
2010/11/1 Nyamul Hassan <mnhassan@usa.net>:
Nibble bill does not produce a separate CDR. However, the variables and their values will be recorded if you are using XML CDR.
Regards HASSAN
On 2010-11-01, budi wibowo <bwibowo@gmail.com> wrote:
dear all i have installed mod_nibblebill and works perfectly, can nibble_bill produce cdr with info for calling and called number?
regards
budi
-- Sent from my mobile device
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
You can customize the variables stored by mod cdr_csv to include those set by nibblebill if you rather not have mess with mod_cdr_xml http://wiki.freeswitch.org/wiki/Mod_cdr_csv#Variables_in_a_template Just define a new template that includes the nibblebill variables and use that instead of the default. -- W PS: I would include an example but don't have it handy.
2010/11/3 William Suffill <william.suffill@gmail.com>:
You can customize the variables stored by mod cdr_csv to include those set by nibblebill if you rather not have mess with mod_cdr_xml
http://wiki.freeswitch.org/wiki/Mod_cdr_csv#Variables_in_a_template
I agree :) for my solution i modify nibble bill support many feature initial block , regular block, grace period (30/6 , 1/1 , 60/60), multiple rate (first 2 minute 0.5 usd and next 0.2 usd) .. etc and define channel variable for csv cdr (about 30 columns) Dome C.
Just define a new template that includes the nibblebill variables and use that instead of the default.
-- W
PS: I would include an example but don't have it handy.
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
the perl script can parse all cdr and insert to database, but no info about the cost defined in nibblebill. On Wed, Nov 3, 2010 at 1:52 PM, Dome Charoenyost <dome@tel.co.th> wrote:
2010/11/3 William Suffill <william.suffill@gmail.com>:
You can customize the variables stored by mod cdr_csv to include those set by nibblebill if you rather not have mess with mod_cdr_xml
http://wiki.freeswitch.org/wiki/Mod_cdr_csv#Variables_in_a_template
I agree :) for my solution i modify nibble bill support many feature initial block , regular block, grace period (30/6 , 1/1 , 60/60), multiple rate (first 2 minute 0.5 usd and next 0.2 usd) .. etc and define channel variable for csv cdr (about 30 columns)
Dome C.
Just define a new template that includes the nibblebill variables and use that instead of the default.
-- W
PS: I would include an example but don't have it handy.
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
The standard cdr does not include the values that were set by nibble bill. To get them, you need to add custom columns to the cdr, as mentioned earlier, them modify the perl script to correctly parse the column. Regards HASSAN On 2010-11-04, budi wibowo <bwibowo@gmail.com> wrote:
the perl script can parse all cdr and insert to database, but no info about the cost defined in nibblebill.
On Wed, Nov 3, 2010 at 1:52 PM, Dome Charoenyost <dome@tel.co.th> wrote:
2010/11/3 William Suffill <william.suffill@gmail.com>:
You can customize the variables stored by mod cdr_csv to include those set by nibblebill if you rather not have mess with mod_cdr_xml
http://wiki.freeswitch.org/wiki/Mod_cdr_csv#Variables_in_a_template
I agree :) for my solution i modify nibble bill support many feature initial block , regular block, grace period (30/6 , 1/1 , 60/60), multiple rate (first 2 minute 0.5 usd and next 0.2 usd) .. etc and define channel variable for csv cdr (about 30 columns)
Dome C.
Just define a new template that includes the nibblebill variables and use that instead of the default.
-- W
PS: I would include an example but don't have it handy.
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
-- Sent from my mobile device
This is my cdr_csv.conf.xml <configuration name="cdr_csv.conf" description="CDR CSV Format"> <settings> <!-- 'cdr-csv' will always be appended to log-base --> <!--<param name="log-base" value="/var/log"/>--> <param name="default-template" value="sql"/> <!-- This is like the info app but after the call is hung up --> <!--<param name="debug" value="true"/>--> <param name="rotate-on-hup" value="true"/> <!-- may be a b or ab --> <param name="legs" value="ab"/> <!-- Only log in Master.csv --> <param name="master-file-only" value="true"/> </settings> <templates> <template name="sql">INSERT INTO voipcall (prate,pcost,provider,provider_id,pprefix,bleg,price,duration,initialincrement,regularincrement,graceperiod,tariffdesc,prefix,service_charge,cost,username,callingstationid,calledstationid,duration_raw,acctstoptime,acctstarttime,acctsessionid,hangup_cause) values (${prate},(${billsec}+1)/60.00*${prate},'${provider_name}',${provider_id},${pprefix},'${bleg_uuid}',${tux_rate},${t_duration},${in_block},${re_block},${gr_block},'${dest}','${iprefix}',${ser_charge},${tux_total_billed}/100,'${tux_account}','${caller_id_number}', '${dnumber}',(${billsec}+1), '${end_stamp}','${start_stamp}' ,'${uuid}','${hangup_cause}');</template> 2010/11/4 budi wibowo <bwibowo@gmail.com>:
the perl script can parse all cdr and insert to database, but no info about the cost defined in nibblebill.
On Wed, Nov 3, 2010 at 1:52 PM, Dome Charoenyost <dome@tel.co.th> wrote:
2010/11/3 William Suffill <william.suffill@gmail.com>:
You can customize the variables stored by mod cdr_csv to include those set by nibblebill if you rather not have mess with mod_cdr_xml
http://wiki.freeswitch.org/wiki/Mod_cdr_csv#Variables_in_a_template
I agree :) for my solution i modify nibble bill support many feature initial block , regular block, grace period (30/6 , 1/1 , 60/60), multiple rate (first 2 minute 0.5 usd and next 0.2 usd) .. etc and define channel variable for csv cdr (about 30 columns)
Dome C.
Just define a new template that includes the nibblebill variables and use that instead of the default.
-- W
PS: I would include an example but don't have it handy.
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
thx, i will try that. other opinion, i found 2010-11-11 04:03:18.503474 [DEBUG] mod_dingaling.c:1350 CHANNEL LOOPBACK 2010-11-11 04:03:18.505460 [DEBUG] mod_nibblebill.c:572 Received request via SESSION_HEARTBEAT! 2010-11-11 04:03:18.505460 [DEBUG] mod_nibblebill.c:433 Attempting to bill at $0.03 per minute to account 1000 2010-11-11 04:03:18.505460 [INFO] mod_nibblebill.c:485 Beginning new billing on *93dc8ab7-6f8d-4918-ab32-b4a4ad115eaf* 2010-11-11 04:03:18.505460 [DEBUG] mod_nibblebill.c:491 0 seconds passed since last bill time of 2010-11-11 04:03:18 on debug mode. 93dc8ab7-6f8d-4918-ab32-b4a4ad115eaf can be found on cdr , how to insert this info and call cost to new table? regards budi On Thu, Nov 4, 2010 at 10:37 AM, Dome Charoenyost <dome@tel.co.th> wrote:
This is my cdr_csv.conf.xml
<configuration name="cdr_csv.conf" description="CDR CSV Format"> <settings> <!-- 'cdr-csv' will always be appended to log-base --> <!--<param name="log-base" value="/var/log"/>--> <param name="default-template" value="sql"/> <!-- This is like the info app but after the call is hung up --> <!--<param name="debug" value="true"/>--> <param name="rotate-on-hup" value="true"/> <!-- may be a b or ab --> <param name="legs" value="ab"/> <!-- Only log in Master.csv --> <param name="master-file-only" value="true"/> </settings> <templates> <template name="sql">INSERT INTO voipcall
(prate,pcost,provider,provider_id,pprefix,bleg,price,duration,initialincrement,regularincrement,graceperiod,tariffdesc,prefix,service_charge,cost,username,callingstationid,calledstationid,duration_raw,acctstoptime,acctstarttime,acctsessionid,hangup_cause) values (${prate},(${billsec}+1)/60.00*${prate},'${provider_name}',${provider_id},${pprefix},'${bleg_uuid}',${tux_rate},${t_duration},${in_block},${re_block},${gr_block},'${dest}','${iprefix}',${ser_charge},${tux_total_billed}/100,'${tux_account}','${caller_id_number}', '${dnumber}',(${billsec}+1), '${end_stamp}','${start_stamp}' ,'${uuid}','${hangup_cause}');</template>
2010/11/4 budi wibowo <bwibowo@gmail.com>:
the perl script can parse all cdr and insert to database, but no info about the cost defined in nibblebill.
On Wed, Nov 3, 2010 at 1:52 PM, Dome Charoenyost <dome@tel.co.th> wrote:
2010/11/3 William Suffill <william.suffill@gmail.com>:
You can customize the variables stored by mod cdr_csv to include those set by nibblebill if you rather not have mess with mod_cdr_xml
http://wiki.freeswitch.org/wiki/Mod_cdr_csv#Variables_in_a_template
I agree :) for my solution i modify nibble bill support many feature initial block , regular block, grace period (30/6 , 1/1 , 60/60), multiple rate (first 2 minute 0.5 usd and next 0.2 usd) .. etc and define channel variable for csv cdr (about 30 columns)
Dome C.
Just define a new template that includes the nibblebill variables and use that instead of the default.
-- W
PS: I would include an example but don't have it handy.
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:
http://lists.freeswitch.org/mailman/options/freeswitch-users
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE: http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
_______________________________________________ FreeSWITCH-users mailing list FreeSWITCH-users@lists.freeswitch.org http://lists.freeswitch.org/mailman/listinfo/freeswitch-users UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users http://www.freeswitch.org
participants (5)
-
budi wibowo
-
Dome Charoenyost
-
Nyamul Hassan
-
Nyamul Hassan
-
William Suffill