support  |  log in
learning center  >  SYSTEM ADMIN  >  Data Sync Center  >  911 Interface

Learning Center

Data Sync Center

Topics Discussed Below

 911 Interface - Creating a 911 Interface Template

 Modifying the Field Mapping

 Column Mapping

 Creating Files

 Deleting an Interface

911 Interface

Creating a 911 Interface

From the 911 Interface, you create a template that gathers directory information from the cairs.net database to send to another 911 program. This is a two-step process, first you create the template, this defines file format, extension length, etc. If you are creating a NENA file, the second step requires you to map or associate the fields within the NENA file to field within cairs.net.

Creating a 911 Interface Template

1.    Click the System Admin menu.

2.    In the Navigation pane, click the plus sign (+) next to Data Sync Center to expand the menu items.

3.    Click 911 Interface.

4.    Within the Actions pane, click the Add New Interface 911 link.

5.    The General-911 Interface window opens. There are two panes of information; the top pane contains the general template information and the bottom pane displays the number plans included in the interface.

6.    Within the top pane, configure the following fields. Required fields are indicated by an asterisk:

·         Template Name* – type-in the template name.

·         Format 911* – click the drop-down arrow to access a format list. From the list, select one of the following file formats:

·         NENA 

·         UCID

·         CSV

! Depending on the format that you choose, the fields may be different.  For the purposes of this document, we will define all fields. 

·         Path* – double-click the field to access the Browse For Folder pop-up. Within the pop-up, browse to the location you. want to create the files.

·         File Name – you are creating a file to send to another system, this will be the name of the file.

·         Extension Length*– from the drop-down list select the extension length, 3 to 10 digits.

·         Last Date Time – populates with the date and time of the last 911 file created.

·         NENA Format – when you select the NENA format, this field auto-populates to the NENA 2 format. 

·         Initialize or Change – type-in I for initial, meaning you are creating a brand new file to send or type-in C for change meaning you only want to send the changes made within the database to the 911 system.

·         Email Address – if cairs has the capability to email notification, when a 911 interface creates the file this email address will receive a notification

·         Company Name – type-in the company name.

·         State – type-in your state code.

·         Extract Date – this field populates with the current date.

·         Country ID – type-in your country id.

·         Cycle Counter – type-in the cycle counter.

·         Modify Termination – check mark the field to indicate you want to modify the termination.

·         No Header Footer –check mark the field to indicate the created file will not have a header or footer.

·         Include All Number – checkmark the field to indicate that all numbers are included in the interface

·         Include Duplicate Number – checkmark the field to indicate that duplicate numbers are included in the interface

·         Run on Schedule – check mark the box to indicate you want the interface to run on the schedule you set within Service Manager. Leave the field blank to indicate you will run the interface manually.

7.   The lower pane displays a list of the Number Plans within your database.  This pane allows you to select which number plans to include in the interface file.  To include a number plan, click on the box in the Include column. 

! The numbers, if any, within the Interface 911 Prefix column append to each number transferred in the interface. For example, if you have an extension length of 7 and the prefix of 702, each number transferred starts with the 702 and then the 7-digit number. This allows you to send more digits through the interface than what you track within your cairs.net database. You add the 911 Prefix within the Number Plan. 

8.   Within the Actions ribbon group, click Save (to save and stay) to continue adding information for the interface, or click Save & Close (to save and exit) to return to the 911 Interface list.

Modifying the Field Mapping

1.      Click the System Admin menu.

2.      In the Navigation pane, click the plus sign (+) next to Data Sync Center to expand the menu items.

3.      Click 911 Interface. The list of existing template populates, within the list, click on the template to modify.

4.      Within the Show ribbon group, click on the Column Mapping button.

The screen changes to display the five columns listed above.

5.      In the list, find the field to modify, within the Column Mapping Table column click on the field to access a drop-down list. From the list select the appropriate table, for example, if you are mapping Building Name you would select Building.

6.      Next, you select the field to associate. Within the Column Mapping Field column, click on the field to access a drop-down list, from the list select the cairs.net field name.

7.      Continue mapping fields together. Once complete, within the Actions ribbon group, click Save (to save and stay) to continue adding information for the interface, or click Save & Close (to save and exit) to return to the 911 Interface list.

 Top of Page

NENA Column Mapping

Once you have created the basic information for the interface, you can connect the fields together. This means that you are associating the fields within NENA to the field within cairs. There are ten columns of information:

·         NENA Field – displays the field name within the NENA field

·         NENA Size – displays the maximum character limit for the NENA field

·         Default Mapping – displays the default cairs field that is associated with the NENA field

·         Custom Mapping Table and Custom Mapping Field – for fields that do not appear in the default mapping, you can use these two columns to pull fields from different tables within your database.  Once you select the table, the associated fields populate with the mapping field column allowing you to select any field that appears in that table.

·         Cisco Custom Mapping Table and Custom Mapping Field – these columns pull fields from the tables that are specific to a Cisco Call Manager

·         AS5300 Custom Mapping Table and Custom Mapping Field – these columns pull fields from the tables that are specific to a Avaya AS5300 switch

·         Custom Value – displays the static field value, for example, you may want to pre-define your state id for all numbers included in the file.  Within this field, you would type-in your state abbreviation. 

! You cannot have a value in both the custom mapping field and the custom value. If you try to enter information into the custom value field, it will delete your selection in the custom mapping table and field columns and vice versa.  

Modifying the Field Mapping

1.    Click the System Admin menu.

2.    In the Navigation pane, click the plus sign (+) next to Data Sync Center to expand the menu items.

3.    Click 911 Interface. The list of existing template populates to the right, within the list, click on the template to modify.

4.    Within the Show ribbon group, click on the Column Mapping button.

5.    The screen changes to display the five columns listed above. You will notice that we have pre-determined some fields for you.  However, you can change those values at any time. 

6.    In the list, find the field to modify, within the Column Mapping Table column click on the field to access a dropdown list. From the list select the appropriate table, for example, if you were mapping Building Name you would select Building. There are several different tables to choose from, each having its own set of custom fields, you may have to try a few selections before you find the appropriate table/field combination.

7.    Next, you select the field to associate. Within the Column Mapping Field column, click on the field to access a dropdown list, from the list select the cairs.net field name.

8.    Continue mapping fields together. Once complete, within the Actions ribbon group, click Save (to save and stay) to continue adding information for the interface, or click Save & Close (to save and exit) to return to the 911 Interface list.

  Top of Page

CSV Column Mapping

Once you have created the basic information for the interface, you can connect the fields together. This means that you are associating the fields within your CSV file to the field within cairs. There are nine columns of information:

·         CSV Field – displays the field name within the NENA field

·         CSV Size – displays the maximum character limit, most fields are defaulted to 60 characters

·         Custom Mapping Table and Custom Mapping Field – you can use these two columns to pull fields from different tables within your database.  Once you select the table, the associated fields populate with the mapping field column allowing you to select any field that appears in that table.

·         Cisco Custom Mapping Table and Custom Mapping Field – these columns pull fields from the tables that are specific to a Cisco Call Manager

·         AS5300 Custom Mapping Table and Custom Mapping Field – these columns pull fields from the tables that are specific to a Avaya AS5300 switch

·         Custom Value – displays the static field value, for example, you may want to pre-define your state id for all numbers included in the file.  Within this field, you would type-in your state abbreviation. 

! You cannot have a value in both the custom mapping field and the custom value. If you try to enter information into the custom value field, it will delete your selection in the custom mapping table and field columns and vice versa.  

Modifying the Field Mapping

1.     Click the System Admin menu.

2.     In the Navigation pane, click the plus sign (+) next to Data Sync Center to expand the menu items.

3.     Click 911 Interface. The list of existing template populates to the right, within the list, click on the template to modify.

4.     Within the Show ribbon group, click on the Column Mapping button.

5.     The screen changes to display the nine columns listed above. 

6.     There are 21 miscellaneous fields that you will need to map for information to appear within the interface files.  For each field select the Custom Mapping Table first.  This will populate the fields within the dropdown for the Custom Mapping Field column. 

7.     Within the Custom Mapping Field column, select the field that you want to appear in the interface file.  There are several different tables to choose from, each having its own set of custom fields, you may have to try a few selections before you find the appropriate table/field combination.

8.     Please note that if you do not put anything in each field, a column will still appear in the interface file.  If you do not want the field to appear select ‘NONE’ in both columns. 

9.     Once complete, within the Actions ribbon group, click Save (to save and stay) to continue adding information for the interface, or click Save & Close (to save and exit) to return to the 911 Interface list.

Creating Files

1.      Click the System Admin menu.

2.      In the Navigation pane, click the plus sign (+) next to Data Sync Center to expand the menu items.

3.      Click 911 Interface.

4.      In the 911 Interface list, double-click the interface to modify. The General-911 Interface window opens.

5.      Within the Interface ribbon group, click the Create Files button.

6.      A Status Notification box appears in the lower right hand corner of your screen displaying the status of generating the files.

7.      A textbox displays indicating the interface is complete. Click the Ok button.

8.      Cairs.net creates a file with the date as the file name and a file extension of .asc.

 Top of Page

Deleting an Interface

1.      Click the System Admin menu.

2.      In the Navigation pane, click the plus sign (+) next to Data Sync Center to expand the menu items.

3.      Click 911 Interface.

4.      In the 911 Interface list, click the interface you want to delete.

5.      There are two ways to delete a interface:

·        Within the list, highlight the interface name. In the Actions pane click the Delete Interface911 link.

·        Double-click the interface name within the list. The 911 Interface window opens. Within the Actions ribbon group, click the Delete button.

6.      Once you click Delete, a message box displays verifying that you really want to delete the interface. Click Yes to continue or No to cancel the operation.

 Top of Page

 

Other Unique Sites

 

Unique.net 

 

Cairs Blog 

 

FTP Site

 

 

                          

 

 

Unique.net Pages

 

Our Products

 

About Us

 

Support

 

Cairs Blog

 

Contact Us

 

Learning Center Pages

 

Learning Center

 

Role-Based Training

 

Training-Courses

Support

 

Contact Us

 

Report a Trouble

 

Request a Feature

 

 

 

© Unique Communication Solutions 2012