{"id":4511,"date":"2025-01-11T16:43:28","date_gmt":"2025-01-11T21:43:28","guid":{"rendered":"https:\/\/dialer.one\/?p=4511"},"modified":"2025-03-07T08:58:29","modified_gmt":"2025-03-07T13:58:29","slug":"custom-vicidial-reports-on-github","status":"publish","type":"post","link":"https:\/\/dialer.one\/index.php\/custom-vicidial-reports-on-github\/","title":{"rendered":"Custom VICIdial Reports on GitHub"},"content":{"rendered":"\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h1 class=\"wp-block-heading\">Custom VICIdial Reports on GitHub<\/h1>\n\n\n\n<h3 class=\"wp-block-heading\"><strong>Introducing My New GitHub Repository for Custom VICIdial Reports<\/strong><\/h3>\n\n\n\n<center><a href=\"https:\/\/www.jdoqocy.com\/click-101361114-14092462\" target=\"_blank\" rel=\"noopener\">\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.awltovhc.com\/image-101361114-14092462\" width=\"728\" height=\"90\" alt=\"\" border=\"0\" title=\"\"><\/a><\/center>\n\n\n\n<p>Hey there, fellow VICIdial enthusiasts!<\/p>\n\n\n\n<p>I am thrilled to announce the launch of my latest GitHub repository, dedicated to creating custom reports for VICIdial. As a long-time user and developer in the VICIdial community, I understand the importance of having detailed and actionable data at your fingertips. This repository aims to enhance your call center&#8217;s efficiency and decision-making process by providing insightful reports tailored to your specific needs.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>First Report: Area Code Call Breakdown<\/strong><\/h4>\n\n\n\n<p>The first report available in this repository is the &#8220;Area Code Call Breakdown.&#8221; This report is designed to give you a comprehensive analysis of the number of calls made to each area code within a specified date range. Whether you are looking to optimize your outbound campaigns or ensure compliance with call regulations, this report will provide valuable insights into your call distribution patterns.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Understanding the New Spam Math for 2025<\/strong><\/h4>\n\n\n\n<p>In light of recent changes to spam regulations, it is crucial to manage your Direct Inward Dial (DID) numbers effectively. According to the new guidelines for 2025, you should aim to keep the number of calls per DID below 50 calls per day. This report will help you achieve that by suggesting the optimal number of DIDs you should have for each area code based on the collected data and a six-day work week.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-dominant-color=\"f2f2f2\" data-has-transparency=\"false\" style=\"--dominant-color: #f2f2f2;\" loading=\"lazy\" decoding=\"async\" width=\"573\" height=\"940\" sizes=\"auto, (max-width: 573px) 100vw, 573px\" src=\"https:\/\/dialer.one\/wp-content\/uploads\/2025\/01\/image-png.webp\" alt=\"\" class=\"wp-image-4512 not-transparent\" title=\"\" srcset=\"https:\/\/dialer.one\/wp-content\/uploads\/2025\/01\/image-png.webp 573w, https:\/\/dialer.one\/wp-content\/uploads\/2025\/01\/image-183x300.webp 183w\" \/><\/figure>\n<\/div>\n\n\n<center><a href=\"https:\/\/www.dpbolvw.net\/click-101361114-15620149\" target=\"_blank\" rel=\"noopener\">\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.lduhtrp.net\/image-101361114-15620149\" width=\"728\" height=\"90\" alt=\"\" border=\"0\" title=\"\"><\/a><\/center>\n\n\n\n<p>Here\u2019s how the calculations work:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Total Calls to Area Code (per date range)<\/strong>: This is the total number of calls made to a particular area code within your specified date range.<\/li>\n\n\n\n<li><strong>Daily Call Volume<\/strong>: Divide the total calls by the number of days in the date range to get the average daily call volume.<\/li>\n\n\n\n<li><strong>Required DIDs<\/strong>: To ensure each DID handles fewer than 50 calls per day, divide the daily call volume by 50 and round up to the nearest whole number.<\/li>\n<\/ol>\n\n\n\n<p>For example, if you made 3,000 calls to area code 305 over a six-day period:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Daily Call Volume: 3,000 calls \/ 6 days = 500 calls per day<\/li>\n\n\n\n<li>Required DIDs: 500 calls per day \/ 50 calls per DID per day = 10 DIDs<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><strong>Exporting Data to CSV<\/strong><\/h4>\n\n\n\n<p>To make the data even more accessible, this report includes the option to export your findings to a CSV file. This feature allows you to easily share the data with your team, analyze it in spreadsheet software, or integrate it with other systems for further processing.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-dominant-color=\"ededee\" data-has-transparency=\"false\" style=\"--dominant-color: #ededee;\" loading=\"lazy\" decoding=\"async\" width=\"375\" height=\"732\" sizes=\"auto, (max-width: 375px) 100vw, 375px\" src=\"https:\/\/dialer.one\/wp-content\/uploads\/2025\/01\/image-1-png.webp\" alt=\"\" class=\"wp-image-4513 not-transparent\" title=\"\" srcset=\"https:\/\/dialer.one\/wp-content\/uploads\/2025\/01\/image-1-png.webp 375w, https:\/\/dialer.one\/wp-content\/uploads\/2025\/01\/image-1-154x300.webp 154w\" \/><\/figure>\n<\/div>\n\n\n<h4 class=\"wp-block-heading\"><strong>Get Started Today<\/strong><\/h4>\n\n\n\n<p>Ready to enhance your VICIdial reporting capabilities? Head over to my GitHub repository <a href=\"https:\/\/github.com\/carpenox\/Reports\/tree\/main\" target=\"_blank\" rel=\"noreferrer noopener\">here<\/a> to get started. You&#8217;ll find detailed instructions on how to set up and run the reports, as well as ongoing updates and new features.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Installation<\/h4>\n\n\n\n<p>Go to your &#8220;vicidial&#8221; directory on your web server. For ViciBox type &#8220;cd \/srv\/www\/htdocs\/vicidial&#8221; and for Redhat(Alma\/Rocky\/CentOS) type &#8220;cd \/var\/www\/html\/vicidial&#8221; and then clone the repo by typing:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>git clone https:\/\/github.com\/carpenox\/Reports.git<\/code><\/pre>\n\n\n\n<p>Then browse to your server &#8211; https:\/\/yourserver.com\/vicidial\/Reports\/did_report.php<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<p>I have added a bunch more that are all described on the github, but the latest one looks like this:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img data-dominant-color=\"f8f8f8\" data-has-transparency=\"false\" style=\"--dominant-color: #f8f8f8;\" loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"723\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" src=\"https:\/\/dialer.one\/wp-content\/uploads\/2025\/01\/image-11-1024x723.webp\" alt=\"Record Search\" class=\"wp-image-4762 not-transparent\" title=\"\" srcset=\"https:\/\/dialer.one\/wp-content\/uploads\/2025\/01\/image-11-1024x723.webp 1024w, https:\/\/dialer.one\/wp-content\/uploads\/2025\/01\/image-11-300x212.webp 300w, https:\/\/dialer.one\/wp-content\/uploads\/2025\/01\/image-11-768x542.webp 768w, https:\/\/dialer.one\/wp-content\/uploads\/2025\/01\/image-11-600x423.webp 600w, https:\/\/dialer.one\/wp-content\/uploads\/2025\/01\/image-11-png.webp 1322w\" \/><\/figure>\n<\/div>\n\n\n<p>Thats it, enjoy!<\/p>\n\n\n\n<p>Stay tuned for more custom reports and features coming soon. If you have any suggestions or feedback, feel free to open an issue on GitHub or reach out to me directly on Discord: <a href=\"https:\/\/discord.gg\/ymGZJvF6hK\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/discord.gg\/ymGZJvF6hK<\/a><\/p>\n\n\n\n<p>Happy dialing!<\/p>\n\n\n\n<p>Chris aka carpenox<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<center><a href=\"https:\/\/www.kqzyfj.com\/click-101361114-14511101\" target=\"_top\" rel=\"noopener\">\n<img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.awltovhc.com\/image-101361114-14511101\" width=\"728\" height=\"90\" alt=\"Contabo opens DC in Singapore\" border=\"0\" title=\"\"><\/a><\/center>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Custom VICIdial Reports on GitHub Introducing My New GitHub Repository for Custom VICIdial Reports Hey there, fellow VICIdial enthusiasts! I am thrilled to announce the launch of my latest GitHub repository, dedicated to creating custom reports for VICIdial. As a long-time user and developer in the VICIdial community, I understand the importance of having detailed [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4512,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"content-type":"","_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[529,96],"tags":[],"class_list":["post-4511","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-cyburdial","category-vicidial"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/dialer.one\/wp-content\/uploads\/2025\/01\/image-png.webp","jetpack-related-posts":[{"id":2371,"url":"https:\/\/dialer.one\/index.php\/how-to-fix-the-python-repo-for-vicidial-repository-opensuse-leap-15-2-devel-languages-python-is-invalid\/","url_meta":{"origin":4511,"position":0},"title":"How to &#8211; fix the Python repo for Vicidial &#8211; Repository &#8216;openSUSE-Leap-15.2-Devel-Languages-Python&#8217; is invalid.","author":"carpenox","date":"March 3, 2022","format":false,"excerpt":"How to fix the Python repo for Vicidial - Repository 'openSUSE-Leap-15.2-Devel-Languages-Python' is invalid. So I know a lot of you have asked about the python repo issue with leap 15.2 after upgrading so here is a quick fix in relation to that. Repository 'openSUSE-Leap-15.2-Devel-Languages-Python' is invalid Step 1 - Remove\u2026","rel":"","context":"In &quot;Vicidial&quot;","block_context":{"text":"Vicidial","link":"https:\/\/dialer.one\/index.php\/category\/vicidial\/"},"img":{"alt_text":"Repository 'openSUSE-Leap-15.2-Devel-Languages-Python' is invalid.","src":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/03\/image.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/03\/image.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/03\/image.png?resize=525%2C300&ssl=1 1.5x"},"classes":[]},{"id":2378,"url":"https:\/\/dialer.one\/index.php\/table-of-contents\/","url_meta":{"origin":4511,"position":1},"title":"Table of Contents &#8211; Knowledge Base","author":"carpenox","date":"March 7, 2022","format":false,"excerpt":"Welcome to my blog, some of you may know me from the ViciDial forums, I am carpenox and I am here to share my knowledge with everyone, for free!","rel":"","context":"In &quot;Vicidial&quot;","block_context":{"text":"Vicidial","link":"https:\/\/dialer.one\/index.php\/category\/vicidial\/"},"img":{"alt_text":"CyburDial","src":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/02\/image.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/02\/image.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/02\/image.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/02\/image.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/02\/image.png?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":1448,"url":"https:\/\/dialer.one\/index.php\/how-to-set-the-time-zone-for-php-and-db-in-the-reports-page-for-vicidial-or-cyburdial\/","url_meta":{"origin":4511,"position":2},"title":"How to &#8211; Set the time zone for PHP and DB in the reports page for Vicidial","author":"carpenox","date":"January 28, 2021","format":false,"excerpt":"How to - Set the time zone for PHP and DB in the reports page for Vicidial Syncing your time zone for ViciDial or CyburDial This is a pretty simple process, but if you are unfamiliar with linux, it can be quite overwhelming to figure out how to solve this\u2026","rel":"","context":"With 1 comment","block_context":{"text":"With 1 comment","link":"https:\/\/dialer.one\/index.php\/how-to-set-the-time-zone-for-php-and-db-in-the-reports-page-for-vicidial-or-cyburdial\/#comments"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2021\/01\/image-3.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2021\/01\/image-3.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2021\/01\/image-3.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2021\/01\/image-3.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":3793,"url":"https:\/\/dialer.one\/index.php\/how-to-create-a-simple-cdr-report-for-vicidial\/","url_meta":{"origin":4511,"position":3},"title":"How to &#8211; Create a simple CDR report for ViciDial","author":"carpenox","date":"October 25, 2023","format":false,"excerpt":"How to - Create a simple CDR report for ViciDial This article will go over how to create a simple CDR report for ViciDial using MySQL and PHP. I will provide the code I've used to accomplish this report which can be altered to fit your needs. First off, I\u2026","rel":"","context":"In &quot;Vicidial&quot;","block_context":{"text":"Vicidial","link":"https:\/\/dialer.one\/index.php\/category\/vicidial\/"},"img":{"alt_text":"ViciDial Custom Report","src":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2023\/10\/image-11.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2023\/10\/image-11.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2023\/10\/image-11.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2023\/10\/image-11.png?resize=700%2C400&ssl=1 2x"},"classes":[]},{"id":2411,"url":"https:\/\/dialer.one\/index.php\/how-to-fix-repository-opensuse-leap-15-2-php-applications-is-invalid\/","url_meta":{"origin":4511,"position":4},"title":"How to &#8211; Fix &#8220;Repository &#8216;openSUSE-Leap-15.2-PHP-Applications&#8217; is invalid.&#8221;","author":"carpenox","date":"March 14, 2022","format":false,"excerpt":"How to - Fix \"Repository 'openSUSE-Leap-15.2-PHP-Applications' is invalid.\" Repository 'openSUSE-Leap-15.2-PHP-Applications' is invalid. Just a short article to fix this issue for Leap 15.2. First you need to list your repo's and remove the one labeled PHP-Applications, for my installs its been number 8. The following commands will show you how\u2026","rel":"","context":"In &quot;Vicidial&quot;","block_context":{"text":"Vicidial","link":"https:\/\/dialer.one\/index.php\/category\/vicidial\/"},"img":{"alt_text":"Repository 'openSUSE-Leap-15.2-PHP-Applications' is invalid.","src":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/03\/image-15.png?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/03\/image-15.png?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/03\/image-15.png?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/03\/image-15.png?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/dialer.one\/wp-content\/uploads\/2022\/03\/image-15.png?resize=1050%2C600&ssl=1 3x"},"classes":[]},{"id":2899,"url":"https:\/\/dialer.one\/index.php\/how-to-integrate-queuemetrics-with-vicidial\/","url_meta":{"origin":4511,"position":5},"title":"How to &#8211; Integrate Queuemetrics with Vicidial","author":"carpenox","date":"May 8, 2023","format":false,"excerpt":"How to - Integrate Queuemetrics with Vicidial This article will go over how to integrate Queuemetrics with ViciDial ViciDial integration ViciDial is an enterprise class, open source call center suite in use by many large call centers around the world. VICIdial has a full featured predictive dialer. It can also\u2026","rel":"","context":"In &quot;Vicidial&quot;","block_context":{"text":"Vicidial","link":"https:\/\/dialer.one\/index.php\/category\/vicidial\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/posts\/4511","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/comments?post=4511"}],"version-history":[{"count":0,"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/posts\/4511\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/media\/4512"}],"wp:attachment":[{"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/media?parent=4511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/categories?post=4511"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dialer.one\/index.php\/wp-json\/wp\/v2\/tags?post=4511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}