Talking Call Center Leak
Format - .SQL
Size sql file - 1 Gb
INSERT INTO `cdr_static` (`yearstatic`, `monthstatic`, `daystatic`, `recid`, `linkedid`, `uniqueid`, `calldate`, `calltype`, `context`, `didnumber`, `brandname`, `queuenum`, `queuename`, `src`, `dst`, `crmuserid`, `old_crmuserid`, `crmusername`, `agentnum`, `agentname`, `callstatus`, `starttimeasdate`, `endtimeasdate`, `starttime`, `answertime`, `endtime`, `billableseconds`, `duration`, `holdseconds`, `coreversion`, `costunitprice`, `recfilename`, `hangupby`, `causecode`, `causecodedesc`, `dsttype`, `branchnum`, `queuerecfilename`, `transferto`, `transferfrom`, `forwardto`, `callsteps`, `callkey`, `callleg`, `call_key`, `queueuniqueid`, `callmethod`, `call_back`, `totalduration`, `misscallat`, `queuestarttime`, `queueendtime`, `ringseconds`, `queueringseconds`, `queueduration`, `agents`, `agentsavail`, `agentsbusy`, `checkqueueat`, `srcalias`, `dstalias`, `id_customer`, `customer_name`, `crm_call_status`, `network`, `initunitprice`, `cost`, `id_organization`, `id_store`, `dtmfdigit`, `dtmfdigit2`, `dtmfdigit3`, `dtmfdigit4`, `dtmfdigit5`, `phoneLocation`, `legStartKey`, `legEndKey`, `campaignUuid`, `accountCode`, `dstLocation`, `billBlocks`, `campaignName`, `call_back_quantity`) VALUES
sample:
(2022, 6, 27, 636783, '1656321072.116455', '1656321101.116458', '2022-06-27 16:11:41', 'IN', 'BVMAT', '1900555553', '', '79001', 'Q_CSKH_1900', '0945532979', '118499005', 30, NULL, '', '99005', 'Dang Thi Ngoc Han', 'ANSWERED', '2022-06-27 16:11:41', '2022-06-27 16:12:36', '2022-06-27 16:11:41', '2022-06-27 16:11:49', '2022-06-27 16:12:36', 47, 54, 0, '3.6.6', '0.00', 'http://bvmatccms.talking.vn:1101/webservice/callRecord?key=fd3a4e1018d4519dadc8c8559a80b500', 'CUSTOMER', 16, 'Normal clearing', 'EXTENSION', NULL, '', '', '', '', 'IB_1900555553:IVR_780001:Q_79001:EX_118499005', '7aac312f823cbf755384d2d80f78af93', NULL, NULL, '1656321072.116455', '', 'Customer called back at 2022-06-27 16:11:41 from 0945532979 to 118499005', 83, '', '2022-06-27 16:11:29', '2022-06-27 16:12:35', 7, 19, 66, 4, 1, 3, '2022-06-27 16:11:29', '', '', NULL, NULL, 'ANSWERED', 'vinaphone', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0),
(2022, 6, 27, 636784, '1656321143.116466', '1656321144.116468', '2022-06-27 16:12:25', 'IN', 'BV-LTR', '02839256155', '', '79006', 'Q_LTR', '0965941658', '121463002', 2, NULL, '', '', '', 'ANSWERED', '2022-06-27 16:12:25', '2022-06-27 16:13:19', '2022-06-27 16:12:25', '2022-06-27 16:12:36', '2022-06-27 16:13:19', 42, 53, 0, '3.6.6', '0.00', 'http://bvmatccms.talking.vn:1101/webservice/callRecord?key=9911962a16be54d6068196612f1ad2d9', 'AGENT', 16, 'Normal clearing', 'EXTENSION', NULL, '', '', '', '', 'IB_02839256155:Q_79006:EX_121463002', 'a674d0bbff37881911896fb6ff93ef86', NULL, NULL, '1656321143.116466', '', 'Customer called back at 2022-06-27 16:12:25 from 0965941658 to 121463002', 55, '', '2022-06-27 16:12:23', '2022-06-27 16:13:18', 11, 12, 54, 2, 2, 0, '2022-06-27 16:12:23', '', '', NULL, NULL, 'ANSWERED', 'viettel', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0),
(2022, 6, 27, 636785, '1656320917.116440', '1656320917.116440', '2022-06-27 16:08:38', 'OUT', 'BVMAT', '02838684599', '', '', '', '118499001', '0976309733', 6, NULL, '', '99003', 'Lam Ngoc Huy', 'ANSWERED', '2022-06-27 16:08:38', '2022-06-27 16:13:38', '2022-06-27 16:08:38', '2022-06-27 16:08:53', '2022-06-27 16:13:38', 285, 299, 0, '3.6.6', '0.00', 'http://bvmatccms.talking.vn:1101/webservice/callRecord?key=ee500e5e623b874d16e35e829b564dab', 'CUSTOMER', 16, 'Normal clearing', 'PHONE', NULL, '', '', '', '', 'EX_118499001:OB_02838684599:PHONE_0976309733', 'ee500e5e623b874d16e35e829b564dab', NULL, NULL, '', 'CLICK TO CALL', 'Agent called back at 2022-06-27 16:08:38 from 118499001 to 0976309733', 299, '', NULL, NULL, 14, 0, 0, 0, 0, 0, NULL, '', '', NULL, NULL, 'ANSWERED', 'viettel', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0),
(2022, 6, 27, 636786, '1656321082.116456', '1656321123.116464', '2022-06-27 16:12:04', 'IN', 'BVMAT', '1900555553', '', '79001', 'Q_CSKH_1900', '0931207194', '118499009', 3, NULL, '', '99009', 'Truong Thuy Duong', 'ANSWERED', '2022-06-27 16:12:04', '2022-06-27 16:15:11', '2022-06-27 16:12:04', '2022-06-27 16:12:13', '2022-06-27 16:15:11', 177, 187, 0, '3.6.6', '0.00', 'http://bvmatccms.talking.vn:1101/webservice/callRecord?key=51e83000523e4f49e3b334f1ce674aaf', 'CUSTOMER', 16, 'Normal clearing', 'EXTENSION', NULL, '', '', '', '', 'IB_1900555553:IVR_780001:Q_79001:EX_118499009', 'fd4bec90bd98eae3ba27bd6df5aa9a60', NULL, NULL, '1656321082.116456', '', 'Customer called back at 2022-06-27 16:12:04 from 0931207194 to 118499009', 229, '', '2022-06-27 16:11:51', '2022-06-27 16:15:10', 9, 21, 199, 4, 1, 3, '2022-06-27 16:11:51', '', '', NULL, NULL, 'ANSWERED', 'mobifone', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0),
(2022, 6, 27, 636787, '1656321314.116470', '1656321315.116472', '2022-06-27 16:15:15', 'IN', 'BV-CMT8', '02838629751', '', '79008', 'Q_CMT8', '0965941658', '121362002', 2, NULL, '', '', '', 'ANSWERED', '2022-06-27 16:15:15', '2022-06-27 16:16:10', '2022-06-27 16:15:15', '2022-06-27 16:15:25', '2022-06-27 16:16:10', 44, 54, 0, '3.6.6', '0.00', 'http://bvmatccms.talking.vn:1101/webservice/callRecord?key=243173f61a5b70563e3ca7faba919b37', 'CUSTOMER', 16, 'Normal clearing', 'EXTENSION', NULL, '', '', '', '', 'IB_02838629751:Q_79008:EX_121362002', 'f6d0bc40c284ddd2a42ffb037b78348a', NULL, NULL, '1656321314.116470', '', 'Customer called back at 2022-06-27 16:12:25 from 0965941658 to 121463002', 56, '', '2022-06-27 16:15:14', '2022-06-27 16:16:09', 10, 11, 55, 1, 1, 0, '2022-06-27 16:15:14', '', '', NULL, NULL, 'ANSWERED', 'viettel', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0),
(2022, 6, 27, 636788, '1656321368.116480', '1656321368.116480', '2022-06-27 16:16:09', 'OUT', 'BVMAT', '02838684599', '', '', '', '118499001', '0901069245', 6, NULL, '', '99003', 'Lam Ngoc Huy', 'CANCEL', '2022-06-27 16:16:09', '2022-06-27 16:16:29', '2022-06-27 16:16:09', NULL, '2022-06-27 16:16:29', 0, 20, 0, '3.6.6', '0.00', 'http://bvmatccms.talking.vn:1101/webservice/callRecord?key=76cf3a45c25a50f85a6f170f112460cd', 'AGENT', 16, 'Normal clearing', 'PHONE', NULL, '', '', '', '', 'EX_118499001:OB_02838684599:PHONE_0901069245', '76cf3a45c25a50f85a6f170f112460cd', NULL, NULL, '', 'CLICK TO CALL', NULL, 20, '', NULL, NULL, 20, 0, 0, 0, 0, 0, NULL, '', '', NULL, NULL, 'NOANSWER', 'mobifone', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
Format - .SQL
Size sql file - 1 Gb
INSERT INTO `cdr_static` (`yearstatic`, `monthstatic`, `daystatic`, `recid`, `linkedid`, `uniqueid`, `calldate`, `calltype`, `context`, `didnumber`, `brandname`, `queuenum`, `queuename`, `src`, `dst`, `crmuserid`, `old_crmuserid`, `crmusername`, `agentnum`, `agentname`, `callstatus`, `starttimeasdate`, `endtimeasdate`, `starttime`, `answertime`, `endtime`, `billableseconds`, `duration`, `holdseconds`, `coreversion`, `costunitprice`, `recfilename`, `hangupby`, `causecode`, `causecodedesc`, `dsttype`, `branchnum`, `queuerecfilename`, `transferto`, `transferfrom`, `forwardto`, `callsteps`, `callkey`, `callleg`, `call_key`, `queueuniqueid`, `callmethod`, `call_back`, `totalduration`, `misscallat`, `queuestarttime`, `queueendtime`, `ringseconds`, `queueringseconds`, `queueduration`, `agents`, `agentsavail`, `agentsbusy`, `checkqueueat`, `srcalias`, `dstalias`, `id_customer`, `customer_name`, `crm_call_status`, `network`, `initunitprice`, `cost`, `id_organization`, `id_store`, `dtmfdigit`, `dtmfdigit2`, `dtmfdigit3`, `dtmfdigit4`, `dtmfdigit5`, `phoneLocation`, `legStartKey`, `legEndKey`, `campaignUuid`, `accountCode`, `dstLocation`, `billBlocks`, `campaignName`, `call_back_quantity`) VALUES
sample:
(2022, 6, 27, 636783, '1656321072.116455', '1656321101.116458', '2022-06-27 16:11:41', 'IN', 'BVMAT', '1900555553', '', '79001', 'Q_CSKH_1900', '0945532979', '118499005', 30, NULL, '', '99005', 'Dang Thi Ngoc Han', 'ANSWERED', '2022-06-27 16:11:41', '2022-06-27 16:12:36', '2022-06-27 16:11:41', '2022-06-27 16:11:49', '2022-06-27 16:12:36', 47, 54, 0, '3.6.6', '0.00', 'http://bvmatccms.talking.vn:1101/webservice/callRecord?key=fd3a4e1018d4519dadc8c8559a80b500', 'CUSTOMER', 16, 'Normal clearing', 'EXTENSION', NULL, '', '', '', '', 'IB_1900555553:IVR_780001:Q_79001:EX_118499005', '7aac312f823cbf755384d2d80f78af93', NULL, NULL, '1656321072.116455', '', 'Customer called back at 2022-06-27 16:11:41 from 0945532979 to 118499005', 83, '', '2022-06-27 16:11:29', '2022-06-27 16:12:35', 7, 19, 66, 4, 1, 3, '2022-06-27 16:11:29', '', '', NULL, NULL, 'ANSWERED', 'vinaphone', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0),
(2022, 6, 27, 636784, '1656321143.116466', '1656321144.116468', '2022-06-27 16:12:25', 'IN', 'BV-LTR', '02839256155', '', '79006', 'Q_LTR', '0965941658', '121463002', 2, NULL, '', '', '', 'ANSWERED', '2022-06-27 16:12:25', '2022-06-27 16:13:19', '2022-06-27 16:12:25', '2022-06-27 16:12:36', '2022-06-27 16:13:19', 42, 53, 0, '3.6.6', '0.00', 'http://bvmatccms.talking.vn:1101/webservice/callRecord?key=9911962a16be54d6068196612f1ad2d9', 'AGENT', 16, 'Normal clearing', 'EXTENSION', NULL, '', '', '', '', 'IB_02839256155:Q_79006:EX_121463002', 'a674d0bbff37881911896fb6ff93ef86', NULL, NULL, '1656321143.116466', '', 'Customer called back at 2022-06-27 16:12:25 from 0965941658 to 121463002', 55, '', '2022-06-27 16:12:23', '2022-06-27 16:13:18', 11, 12, 54, 2, 2, 0, '2022-06-27 16:12:23', '', '', NULL, NULL, 'ANSWERED', 'viettel', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0),
(2022, 6, 27, 636785, '1656320917.116440', '1656320917.116440', '2022-06-27 16:08:38', 'OUT', 'BVMAT', '02838684599', '', '', '', '118499001', '0976309733', 6, NULL, '', '99003', 'Lam Ngoc Huy', 'ANSWERED', '2022-06-27 16:08:38', '2022-06-27 16:13:38', '2022-06-27 16:08:38', '2022-06-27 16:08:53', '2022-06-27 16:13:38', 285, 299, 0, '3.6.6', '0.00', 'http://bvmatccms.talking.vn:1101/webservice/callRecord?key=ee500e5e623b874d16e35e829b564dab', 'CUSTOMER', 16, 'Normal clearing', 'PHONE', NULL, '', '', '', '', 'EX_118499001:OB_02838684599:PHONE_0976309733', 'ee500e5e623b874d16e35e829b564dab', NULL, NULL, '', 'CLICK TO CALL', 'Agent called back at 2022-06-27 16:08:38 from 118499001 to 0976309733', 299, '', NULL, NULL, 14, 0, 0, 0, 0, 0, NULL, '', '', NULL, NULL, 'ANSWERED', 'viettel', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0),
(2022, 6, 27, 636786, '1656321082.116456', '1656321123.116464', '2022-06-27 16:12:04', 'IN', 'BVMAT', '1900555553', '', '79001', 'Q_CSKH_1900', '0931207194', '118499009', 3, NULL, '', '99009', 'Truong Thuy Duong', 'ANSWERED', '2022-06-27 16:12:04', '2022-06-27 16:15:11', '2022-06-27 16:12:04', '2022-06-27 16:12:13', '2022-06-27 16:15:11', 177, 187, 0, '3.6.6', '0.00', 'http://bvmatccms.talking.vn:1101/webservice/callRecord?key=51e83000523e4f49e3b334f1ce674aaf', 'CUSTOMER', 16, 'Normal clearing', 'EXTENSION', NULL, '', '', '', '', 'IB_1900555553:IVR_780001:Q_79001:EX_118499009', 'fd4bec90bd98eae3ba27bd6df5aa9a60', NULL, NULL, '1656321082.116456', '', 'Customer called back at 2022-06-27 16:12:04 from 0931207194 to 118499009', 229, '', '2022-06-27 16:11:51', '2022-06-27 16:15:10', 9, 21, 199, 4, 1, 3, '2022-06-27 16:11:51', '', '', NULL, NULL, 'ANSWERED', 'mobifone', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0),
(2022, 6, 27, 636787, '1656321314.116470', '1656321315.116472', '2022-06-27 16:15:15', 'IN', 'BV-CMT8', '02838629751', '', '79008', 'Q_CMT8', '0965941658', '121362002', 2, NULL, '', '', '', 'ANSWERED', '2022-06-27 16:15:15', '2022-06-27 16:16:10', '2022-06-27 16:15:15', '2022-06-27 16:15:25', '2022-06-27 16:16:10', 44, 54, 0, '3.6.6', '0.00', 'http://bvmatccms.talking.vn:1101/webservice/callRecord?key=243173f61a5b70563e3ca7faba919b37', 'CUSTOMER', 16, 'Normal clearing', 'EXTENSION', NULL, '', '', '', '', 'IB_02838629751:Q_79008:EX_121362002', 'f6d0bc40c284ddd2a42ffb037b78348a', NULL, NULL, '1656321314.116470', '', 'Customer called back at 2022-06-27 16:12:25 from 0965941658 to 121463002', 56, '', '2022-06-27 16:15:14', '2022-06-27 16:16:09', 10, 11, 55, 1, 1, 0, '2022-06-27 16:15:14', '', '', NULL, NULL, 'ANSWERED', 'viettel', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0),
(2022, 6, 27, 636788, '1656321368.116480', '1656321368.116480', '2022-06-27 16:16:09', 'OUT', 'BVMAT', '02838684599', '', '', '', '118499001', '0901069245', 6, NULL, '', '99003', 'Lam Ngoc Huy', 'CANCEL', '2022-06-27 16:16:09', '2022-06-27 16:16:29', '2022-06-27 16:16:09', NULL, '2022-06-27 16:16:29', 0, 20, 0, '3.6.6', '0.00', 'http://bvmatccms.talking.vn:1101/webservice/callRecord?key=76cf3a45c25a50f85a6f170f112460cd', 'AGENT', 16, 'Normal clearing', 'PHONE', NULL, '', '', '', '', 'EX_118499001:OB_02838684599:PHONE_0901069245', '76cf3a45c25a50f85a6f170f112460cd', NULL, NULL, '', 'CLICK TO CALL', NULL, 20, '', NULL, NULL, 20, 0, 0, 0, 0, 0, NULL, '', '', NULL, NULL, 'NOANSWER', 'mobifone', NULL, '0.00', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
