Automated Spectrum Management

ASMS-AIM is a software module that enables the interface of the ASMS with third party accounting systems. The ASMS-AIM permits safe integration with SAGE 300 ERP 2018 or higher (ACCPAC), Sage X3 Version 11 and SAP Business One 9.2. In order to maintain security and data integrity the APIs or web services provided by the ERP/ Financial software are used. ASMS-AIM never talks directly to the database.

ASMS-AIM Prerequisites

• ASMS-AIM shares the same ODBC connection used by ASMS. If ASMS is not installed in the workstation where ASMS-AIM is installed a new ODBC DSN needs to be created.
• ASMS-AIM requires that an ACCPAC client should be installed in the workstation that will be used to run AIM. This is only required if interfacing with ACCPAC.
• ASMS-AIM connects to the ASMS database to retrieve the data to be exported, so the ASMS server should be visible from the workstation used to run the interface.
• ASMS-AIM needs to know the credentials used to connect to the financial package.

ASMS-AIM Features

• ASMS-AIM allows the following data transfer:
  • Invoices from ASMS to SAGE 300 ERP 2018 (ACCPAC), Sage X3 Version 11 and SAP Business One 9.2
  • Receipts from ASMS to SAGE 300 ERP 2018 (ACCPAC), Sage X3 Version 11 and SAP Business One 9.2
  • Customers from ASMS to SAGE 300 ERP 2018 (ACCPAC), Sage X3 Version 11 and SAP Business One 9.2
• Option to schedule a task at regular intervals to automatically export the information to the ERP/ Financial Software
• ASMS-AIM provides different modes:
  • Preview: This mode allows generating as list of records that are candidate to be exported according to the date range specified.
  • Trial: When this option is executed, the batch will do a “trial” export to the financial package and will report an error if any record cannot be exported. All the errors are recorded in ASMS error log. However, please be aware that this option is only available while exporting to ACCPAC.
  • Final: ASMS-AIM final mode performs the actual update of the destination database. If required the final mode will only be allowed to export data if no errors are found in the export.
• ASMS-AIM supports creation of multiple configurations that can be selected at run-time. This allows users to connect to test environments without modifying information in their production system.

The WebCP (Web Customer Portal) option of ASMS enables your customers to complete and submit their license application over the Internet. In a standard browser window, WebCP displays the same data-entry forms with the same dynamic behavior as found in the ASMS. Since the applicant enters all required information on these dynamic forms, applications are complete and accurate upon submission. The WebCP administrator just needs to add the official information to an application in order to transfer it directly into the ASMS, ready for the official approvals process. This dramatically reduces data-entry costs and frees resources for planning and analysis tasks.

Minimize the workload and expense of handling license applications.

• WebCP consists of a web server, website software and an e-mail agent
• It supports three levels of user access:
  • Super user (grants access to administrators)
  • Administrator (grants access to applicants via a registration page on the website)
  • Applicant

Minimum Requirements

• TCI ASMS
• Two external fixed IP addresses
• One SMTP email account
• Broadband Internet connection

Key Features

• Enables your customer to perform all application data entry
• Sends customizable e-mails automatically to all parties at key points in the process
• Page-level validation (“to do” lists)
• Help windows provided for every screen
• Current license holders can log in to apply for license modification and license renewal
• Supports OAuth Authentication for mail servers

ASMS Analytics is a software module that allows the user to view and analyze the data from the ASMS database. The easy-to-use graphical user interface is divided into selectable dashboards that group similar data for easy viewing and analysis. Convenient drill-down menus enable the user to narrow or expand the data set and select a wide variety of additional details to be presented. A powerful search feature lets the user search by client name, type, license number, and more.

ASMS Analytics runs on the Microsoft® PowerBI® platform and data can be exported for presentations, further analysis, and other uses.

Dashboards Provided in ASMS Analytics

License Technical Info

This dashboard provides license details for all customers, including license type, license status, assigned frequency, equipment type, and organization chart.

Accrued Revenue per License Type

This dashboard gives the user access to revenue information that includes total revenue per customer, fee code, description, category, and license type.

Invoices and Receivables

This dashboard offers options to view total invoiced amount per customer, payments received, and balance due amounts.

Licenses Due for Renewal

This dashboard is able to show a list of customer license renewals, next renewal period, and upcoming renewals.

Spectrum Type Approval

This dashboard displays categories such as customer status, frequency range, model, make, equipment type, and type approvals by year.

Non-Spectrum License Applications

This dashboard shows different non-spectrum license types, license status, and their Count.

Spectrum License Application Status

This dashboard displays spectrum license account information such as customer name, license type, application number, and status.

Note that the Microsoft® PowerBI® application is required to use ASMS Analytics. There are three kinds of Power BI per-user licenses: Free, Pro, and Premium Per User. Which type of license a user needs is determined by where content is stored, how they’ll interact with that content, and if that content uses Premium features.

MapPlus is an add-on module for the TCI ASMS, which allows map information generated by the ASMS to be viewed in the Google Earth™ mapping service. With the MapPlus option, every ASMS map screen contains an “Export to Google Earth” button. Clicking this button generates a file in KMZ format containing the current data (for example, stations, links, or calculated field strength).

ASMS then launches Google Earth, which displays the KMZ data over its terrain map. The operator can zoom, pan, and “fly” over the data set in Google Earth’s three-dimensional space. This makes it easy to:

• Verify station coordinates against surface landmarks
• Visualize broadcast field strengths in relation to population centers
• Verify line-of-sight visibility between stations on the latest satellite maps

Add context to spectrum data with Google Earth terrain.

Minimum Requirements

• TCI ASMS
• Esri™ ArcGIS™ Engine and Spatial Analyst (included with MapPlus)
• Google Earth™ mapping service installed on the client workstation
• Broadband Internet connection on the client workstation

Key Features

• KMZ exported files can be saved for subsequent analysis and comparison
• High-resolution satellite images available for many areas
• Labels for surface features (city names, roads, etc.) are dynamically generated by Google Earth as zoom is varied. Labels can be turned off/on as needed
• Custom overlays (e.g., economic regions, zones and districts) can be developed and added to map displays
• Compatible with Google Earth and Google Earth Pro™