Table Export

Overview

The table export is used to allow quick table additions. You can export a table from one RIG and import to another RIG to reduce administration time.

This guide details the method to automate the creation of the BROKEREDCONNECTIONS table. This operation can be performed on almost any table and has many uses. The table provided in this guide is used only as an example.

Audience

This guide is intended for system administrators or engineers who are responsible for RIG installation and administration.

Supported Software Versions

• Nectar UCMP v8.7

Create Brokered Connections

There should be at least one entry present in the table to provide you a schema for the table. This section explains how to create brokered connections and includes:

• Export a .csv File
• Manipulate the .csv File
• Import a .csv File
• Example

Export a .csv File

Follow these steps to export the .csv file:

1. Open a Command Line.
2. Create a new directory called excel in the Apps\[BP directory]\etc directory.
3. Open a Maritime terminal session.
4. Issue the following command:

CONNECTIONBROKER DATA EXPORTCSV BROKEREDCONNECTIONS [filename].csv

This [filename].csv should be in the etc\excel directory.

1. Use File Manager to download this file to your PC.
2. Open file with Microsoft Excel.

Manipulate the .csv File

Follow these steps to manipulate the .csv file:

1. Open the file in Microsoft Excel.
2. Add additional connections or copy from another source. However, field order is critical.

Note

For bulk additions, do not put any entry in Tag field.

1. Use existing entries as examples for each type of connection.
2. Before sending table, it is important to remove all existing table entries or duplicates will be created.

Import a .csv File

Follow these steps to import a .csv file:

1. Open File Manager and navigate to the etc\excel directory
2. Drag the [filename].csv into the directory.

Note

You could rename to prevent overwriting the existing file.

1. Open a Maritime window.
2. Issue the following command:

CONNECTIONBROKER DATA IMPORTCSV BROKEREDCONNECTIONS [filename].csv

1. Check the Connection Broker and Connection Table should contain the new connections.

Example

Figure 2-1 mkdir excel

Figure 2-2 Write brokerconnections to connections.csv

Figure 2-3 connections.csv

Figure 2-4 File Example

Figure 2-5 Addition File

Figure 2-6 Addition File

Figure 2-7 Present Connection Broker Table (Excerpt)

An ssh connection exists for every Media Gateway that can be used for access. There is no need to manually add them.

Figure 2-8 New Connection Table (Excerpt)