Our Products & Services
Getting Started
First Time Setup
Getting Started With Jobs
Getting Started with Ticketing
Setting Sonar up for Billing
Getting Started with Accounts
Getting Started with Inventory
Baseline Configuration
User Specific Resources
How To: Using Sonar's Customer Portal
Accounts
Account Types: Overview & Example Use Cases
Account Statuses: Overview & Example Use Cases
Account Management View: Overview
Scheduled Events: Overview & Use Cases
Notes & Tasks: Best Practices & Use Cases
Child Accounts: Best Practices & How Tos
Disconnecting an Account
Understanding the Affordable Connectivity Program
FCC Broadband Data Collection (BDC) Filings: How Sonar Can Help
Account List View: Overview
Specify Account ID upon Creation
Lead Intake Form Processing
Account Groups: Overview & Example Use Cases
Using Sonar's FCC Broadband Label Generation Tool
CPUC Fixed Broadband Deployment by Address
Anchor & Linked Serviceable Addresses: Overview and Best Practices
Serviceable Addresses: Overview and Usage
FCC Data Exports: General Overview and Usage
Creating a New Account
Billing
Setting up Bank Account & Credit Card Processors
Billing Settings
Billing Defaults
Taxes Setup
General Ledger Codes: Overview
Services: Overview
Building a Data Service
Building Packages
Delinquency Billing Best Practices
Accounts in Vacation Mode
Batch Payments & Deposit Slips: Overview
Creating Discounts for Services and Packages
Setting Up Payment Methods and Taking Payments
Canadian ACH tool
Printed Invoice Batches: Overview
Delinquency Exclusions: Overview and Use Cases
Multi-Month Billing & Multi-Month Services
How to Take Bank Account Payments
Email Invoice Batch: Overview
Manual Transactions
ACH Batching: Overview
Billing Calculator
General Transactions: Best Practices
How Sonar Prorates Billing
Usage Based Billing Policies: Overview and Usage
How to: Adding a Service to an Account
Usage Based Billing Policy Free Periods: Overview and Usage
Using Tax Exemptions - How To
Avalara: Overview & Setup
Print to Mail
Communication
Setting up an Outbound Email Domain
Triggered Messages: Setup
Call Logs: General Best Practices
Using the Mass Message Tool
Saved Messages: Overview
Message Categories: Overview & Use Cases
Phone Number Types: Overview and Use Cases
Using Outbound SMS
Email Variables & Conditions
Communication Tools: Overview
Trigger Explanations
Companies
How to: Setting Up a Company in Sonar
Managing Multiple Companies in Sonar: Best Practices
Rebranding your Sonar Instance
Financial
Contract Templates
Invoice Attachment Use Cases & PDF Examples
Invoice Messages: Overview & Use Cases
Invoices in Sonar: Examples, Creation & Contents
Integrations
Calix SMx Integration: Overview
GPS Tracking Providers: Overview
Webhooks in Sonar: Basic PHP Example
How to Connect Cambium to your Sonar Instance
iCalendar Integration
RemoteWinBox - Integration with Sonar
External Marketing Providers
The Sonar Field Tech App
How to Connect Preseem to your Sonar System
Tower Coverage Integration: Overview
GoCardless Integration: Overview & Setup
Vetro FiberMap Integration: Overview
How to: Using Webhooks in Sonar
CrowdFiber Integration
Inventory
Setup of Inventory: Manufacturers, Categories, and Assignees
Inventory List View: Overview
Inventory Model Management: General Overview
Tracking and Using Consumable Inventory
Jobs
Job Types: Best Practices
Setting Up Schedules General Overview
Applying Task Templates to Jobs
Scheduling Week View: Overview
Example Jobs & Templates
Scheduling How-to: Creating and Booking a Job
Geofences: Overview
Edit Job Options
Jobs and Scheduling: Overview
Mapping
Misc.
Monitoring
Building a Monitoring Template
Pollers: General Overview, Deployment Strategy, Build Out & Setup
Building Alerting Rotations
Poller Troubleshooting
Networking
IP Assignments & Sonar
MikroTik: Setting Up a Sonar Controlled DHCP Server
IPAM: Basic Setup
MikroTik as an Inline Device: Integration With Sonar
MikroTik: Controlling Speeds
MikroTik: Controlling Access
PacketLogic: Integration With Sonar
Setting Up CoA Proxy
RADIUS: Building Reply Attributes
Data Usage Available Methods
Pulse, Polling, and PHP
Using Multiple Network Devices in Sonar
IPAM: Overview
Cable Modem Provisioning
LTE Integration
Assigning RADIUS Addresses
Controlling Customer Speeds with Sonar: General Overview
Sonar Flow
RADIUS: Build-Out & Integration with Sonar
Network Dashboard: Overview
Being Cloud Native
Netflow Integration: Overview
Building a Device Mapper
Sonar IP Addressing
Automating IP Assignments, Data Rates, and Network Access in Sonar
DHCP Delivery
Assigning an IP Address Using Sonar's IPAM: How to
Network Sites: Management View Overview
Building RADIUS Groups
Building Address Lists
Finding your OIDs
Purchase Orders
Release Notes
Reporting
Understanding Sonar Reports
How To Enhance Your Reporting With Custom Field Data
Report Licenses
Enhanced Business Intelligence - Tips & Tricks for Advanced Users
Sonar's Business Intelligence: Overview
Security
User Role Creation & Best Practices
Removing a Terminated Employee In Sonar
Password Policy In Depth
Application Firewall: General Overview and Best Practices
Auth0: Overview
Users: Overview
Role Creation using GraphiQL
Sonar Billing
sonarPay
sonarPay Disbursements: Overview
sonarPay Overview
sonarPay: Token Migration Process
sonarPay Chargebacks & Disputes: Overview
System
How to Best Use Global Search
How Your Data is Backed Up
How To Use GraphiQL to Understand the Sonar API
Frequently Used Terms
Sonar's Rich Text Editor
Mutations in the Sonar API
Notification Preferences
API Calls Using Third Party Applications: Personal Access Tokens
Date/Time Picker: Overview
The New Sonar API
Introducing the New Sidebar
Upgrading your Ubuntu OS - Customer Portal Upgrades
A Deeper Dive into the New Sonar API
Consuming the Sonar API
Filtering: Simple vs Advanced
Browser Compatibility and Minimum Hardware Requirements for Sonar
REST API Wrappers for V1 Compatibility
User Profile: Your Personal User Settings
SMS Notifications
Dynamic Time Zones in Sonar
System Settings: Overview
Troubleshooting the Customer Portal
Controlling Your Landing Page: Personal Preferences
Interacting with Files via the API
Getting Your Data into Sonar
Customizing Your Customer Portal
Ticketing
Ticketing: Overview
Canned Replies Examples & Templates
Canned Reply Categories
Inbound Mailboxes Example Build
Ticket Categories Best Practices & Example Build
Exploring Ticket Groups
Using Parent Tickets
How to Integrate Inbound Mailboxes with Slack
Advanced Ticketing Features
Voice
API Changes for Voice Billing
Best Practices to Remain CPNI Compliant
Billing Voice Services in Sonar
Deploying Voice Services in Sonar
Working With the Sonar Team & Additional Resources
Sonar's Security Practices & Certifications
Sonar and General Data Protection Regulation (GDPR)
Technical Security Overview
CyberSecure Canada Certification
Sonar's Security Strategies
Best Practices for Fast Tracking a Support Request
How Sonar Bills Your Instance
The Sonar Status Page
The Sonar Community Forum
Feedback Portal / Suggest a Feature
Sonar Casts Table of Contents
How to Request Termination of your Sonar Instance
Submitting Bugs vs. Feature Requests
Third Party Customer Support Referrals
New Client Training Overview
Learning with Sonar: Tools and Resources
Table of Contents
- All Categories
- Integrations
- Using Reports to Sync Sonar with Calix Service Cloud
Using Reports to Sync Sonar with Calix Service Cloud
Updated by Mitchell Paul-Soumis
Read Time: 5 mins
Prerequisites
This report, being entirely custom, has a few prerequisites.
- Adequate role permissions are required to access the reporting module.If your Role is as a Super-Admin, no permission changes are required.
- An Editor Report License must be assigned to your user profile.
Creating the Report
This section will walk you through the basic process of using Sonar's Business Intelligence to create a Custom Report. If you've ever created a report, you can skip to the “Required Fields” section of this article.
- Open the "Reports" module, select "Create Report", give your report a name (e.g., “Calix”), and select the category. For this use case, the category must be Accounts. Once filled in, click "Create"
- Click on "Edit Dashboard" in the middle of the page
- Click on "Add", then from the dropdown that appears, select the first option, "Visualization"
- In this example, we need data stored on the "Accounts" explore. So, it needs to be selected on this page.
- Next, select the data that needs to be extracted. For the Service Cloud report, the first column has to be
Accounts > AccountService > Account Service | Account ID
- Once selected, the field must be renamed in the Look. Select “Run” to generate the data in the visualization, then expand the “Edit” panel, switch to the “Series” tab, scroll down to “Customizations”, expand the
Accounts > AccountService > Account Service | Service ID field
, and set the name touniqueid
.
Required Fields
Once your initial fields have been created, you'll have to add and rename the remaining fields. The following list will provide the full list of fields, and what they should be renamed to in the Visualization:
Accounts > AccountService > Account Service | Account ID [unqiueid]
Accounts > Account | ID [account]
Accounts > Account | Name [name]
Accounts > AccountTypes > Account Type | Type [customertype]
Accounts > Contacts > Contact | Email Address [email]
Accounts > AccountService > Services > Service | ID [usoc]
Accounts > AccountService > Services > Service | Type [servicetype]
Accounts > AccountService > Services > Service | Name [servicedesc]
Accounts > AccountService > Services > DataServiceDetails > Data Service Detail | Technology Code [techtype]
Accounts > AccountService > Services > DataServiceDetails > Data Service Detail | Upload Speed in Mbps [upspeed]
Accounts > AccountService > Services > DataServiceDetails > Data Service Detail | Download Speed in Mbps [downspeed]
Accounts > Addresses > InventoryItems > InventoryModelFieldData1 > Model Field Data | Value [deviceid]
Accounts > Addresses > InventoryItems > InventoryModelFieldData > Model Field Data | MAC List [macaddress]
Accounts > Addresses > InventoryItems > InventoryModels > Model | Display Name [devicename]
Accounts > CustomFieldData1 > Custom Field Data | Value [field1]
Accounts > CustomFieldData2 > Custom Field Data | Value [field2]
Accounts > CustomFieldData3 > Custom Field Data | Value [field3]
Accounts > CustomFieldData4 > Custom Field Data | Value [field4]
Accounts > CustomFieldData5 > Custom Field Data | Value [field5]
Accounts > ServiceableAddresses > Address | Line 1 [address]
Accounts > ServiceableAddresses > Address | City [city]
Accounts > ServiceableAddresses > Address | Subdivision [state]
Accounts > ServiceableAddresses > Address | ZIP [postcode/zip]
Accounts > ServiceableAddresses > Address | Country [country]
Accounts > ServiceableAddresses > Address | Latitude [lat]
Accounts > ServiceableAddresses > Address | Longitude [long]
Accounts > MailingAddresses > Address | Line 1 [bill_address]
Accounts > MailingAddresses > Address | City [bill_city]
Accounts > MailingAddresses > Address | Subdivision [bill_state]
Accounts > MailingAddresses > Address | ZIP [bill_postcode/zip]
Accounts > MailingAddresses > Address | Country [bill_country]
Accounts > Addresses > InventoryItems > Inventory Item | ID (not shown in visalization)
Accounts > Countacts > PhoneNumbers > Phone Number | Number [phone]
Accounts > PrimaryContacts > PhoneNumbers > Phone Number | Number [key]
deviceid
column maps to this field. Additional columns are provided for device custom fields, if such fields are implemented in your instance.A completed Look should look something like this:
Using the report
Once you've filled in all report data and saved it to the dashboard, it needs to be scheduled and sent to Calix for integration with your Service Cloud. Follow these steps to get the process started. Select the 3 dot menu in the top-right, and then “Schedule delivery” from the dropdown:
In the modal that appears, fill in the information needed to send this report to Calix:
- Schedule Name: This sets the name of the schedule, and will be included in the title of the scheduled delivery format. It's recommended to name it something simple, like
Calix
orCalix_Service
- Recurrence and Time: Setting these fields determines how often, and at what time of day, these reports will generate. Calix must receive this file daily by 6:00 PM Pacific Time.This 6:00 PM Pacific deadline is the case for all billing files sent to Calix.
- Destination: The destination determines how the scheduled report will be delivered. In the case of a Calix Service Cloud integration, this destination will be SFTP.
- Address: The Address field appears once you select a destination that requires one. In this case, the Address will be an SFTP URL provided by Calix. Ensure that the completed address URL ends with a forward slash "
/
" when scheduling; otherwise, the report will be undeliverable (e.g.,sftp://example@upload-us.calix.com:2350/uploads/
). - Username and Password: These fields authenticate you with the SFTP URL you provided previously. These will also be confirmed by Calix.
- Preferred Key Exchange Algorithm: This establishes how Sonar and the destination will secure the exchange of information. Generally,
Default
will work, but any changes would be mentioned by Calix. - Format: This determines which format the data will be sent in. For this case, a CSV zip file should be sent.