--- title: "Table Export" slug: "table-export-1" updated: 2022-06-06T21:01:57Z published: 2022-06-06T21:01:57Z canonical: "support.nectarcorp.com/table-export-1" --- > ## Documentation Index > Fetch the complete documentation index at: https://support.nectarcorp.com/llms.txt > Use this file to discover all available pages before exploring further. # 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***](/docs/table-export-1#_bookmark8) - [***Manipulate the .csv File***](/docs/table-export-1#_bookmark9) - [***Import a .csv File***](/docs/table-export-1#_bookmark10) - [***Example***](/docs/table-export-1#_bookmark11) ### 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 ![](https://cdn.document360.io/f8330b7a-360f-4ca0-b0ac-2664b7c04c49/Images/Documentation/table-export-image-rc6fxtqi.png?sv=2026-02-06&spr=https&st=2026-11-08T18%3A10%3A37Z&se=2026-11-08T19%3A10%3A37Z&sr=c&sp=r&sig=fmQzeVUuYaqWE5mE84%2B%2BiyivwFOPOqmjRDpH9sdM3LM%3D) *Figure 2-1 mkdir excel* ![](https://cdn.document360.io/f8330b7a-360f-4ca0-b0ac-2664b7c04c49/Images/Documentation/table-export-image-ep1hqzxk.png?sv=2026-02-06&spr=https&st=2026-11-08T18%3A10%3A37Z&se=2026-11-08T19%3A10%3A37Z&sr=c&sp=r&sig=fmQzeVUuYaqWE5mE84%2B%2BiyivwFOPOqmjRDpH9sdM3LM%3D) *Figure 2-2 Write brokerconnections to connections.csv* ![](https://cdn.document360.io/f8330b7a-360f-4ca0-b0ac-2664b7c04c49/Images/Documentation/table-export-image-d1bsfdt6.jpe?sv=2026-02-06&spr=https&st=2026-11-08T18%3A10%3A37Z&se=2026-11-08T19%3A10%3A37Z&sr=c&sp=r&sig=fmQzeVUuYaqWE5mE84%2B%2BiyivwFOPOqmjRDpH9sdM3LM%3D) *Figure 2-3 connections.csv* ![](https://cdn.document360.io/f8330b7a-360f-4ca0-b0ac-2664b7c04c49/Images/Documentation/table-export-image-3ds5seto.jpe?sv=2026-02-06&spr=https&st=2026-11-08T18%3A10%3A37Z&se=2026-11-08T19%3A10%3A37Z&sr=c&sp=r&sig=fmQzeVUuYaqWE5mE84%2B%2BiyivwFOPOqmjRDpH9sdM3LM%3D) *Figure 2-4 File Example* ![](https://cdn.document360.io/f8330b7a-360f-4ca0-b0ac-2664b7c04c49/Images/Documentation/table-export-image-wxdtq5ks.jpe?sv=2026-02-06&spr=https&st=2026-11-08T18%3A10%3A37Z&se=2026-11-08T19%3A10%3A37Z&sr=c&sp=r&sig=fmQzeVUuYaqWE5mE84%2B%2BiyivwFOPOqmjRDpH9sdM3LM%3D) *Figure 2-5 Addition File* ![](https://cdn.document360.io/f8330b7a-360f-4ca0-b0ac-2664b7c04c49/Images/Documentation/table-export-image-vqsiy5tu.jpe?sv=2026-02-06&spr=https&st=2026-11-08T18%3A10%3A37Z&se=2026-11-08T19%3A10%3A37Z&sr=c&sp=r&sig=fmQzeVUuYaqWE5mE84%2B%2BiyivwFOPOqmjRDpH9sdM3LM%3D)*Figure 2-6 Addition File* ![](https://cdn.document360.io/f8330b7a-360f-4ca0-b0ac-2664b7c04c49/Images/Documentation/table-export-image-62vf3ii2.png?sv=2026-02-06&spr=https&st=2026-11-08T18%3A10%3A37Z&se=2026-11-08T19%3A10%3A37Z&sr=c&sp=r&sig=fmQzeVUuYaqWE5mE84%2B%2BiyivwFOPOqmjRDpH9sdM3LM%3D) *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. ![](https://cdn.document360.io/f8330b7a-360f-4ca0-b0ac-2664b7c04c49/Images/Documentation/table-export-image-sotu3am5.png?sv=2026-02-06&spr=https&st=2026-11-08T18%3A10%3A37Z&se=2026-11-08T19%3A10%3A37Z&sr=c&sp=r&sig=fmQzeVUuYaqWE5mE84%2B%2BiyivwFOPOqmjRDpH9sdM3LM%3D) *Figure 2-8 New Connection Table (Excerpt)*