Importing/Exporting a Map to CSV

This feature allows you to export certain parts of the system map to a Comma Separated Values (CSV) format. This exported .csv file can be edited and imported back into the matrix for updates to take effect (.csv files are commonly opened in Excel). The following files can be exported:

Entities (can be edited and re-imported)
Members
Trunks
SIP (with EHX 14, SIP accounts and servers can be exported but not imported)
- SIP Accounts
- SIP Servers
Beltpacks (can be exported and imported but not edited)

The Entities file can be edited and re-imported. This feature can be used, for example, to support system user shift changes.

Changes can be optionally imported to the following fields:

Label
Alt label
Username
Password

How to Export/Import Map to CSV

Navigate to File > Import/Export to CSV and select it.
The Export Configuration Wizard opens. Select Export and click Next.
Select the required system.
Select the elements of the configuration you wish to export and click Next.
Browse... to Save the file to a suitable location.
To re-import your files, navigate to File > Import/Export to CSV. In the Import/Export Wizard, select Import and then Next.
Browse to the edited .csv file and select it. Click to enable the fields you wish to import.
Click Next. The Import/Export wizard will show you a list of changes. To accept these changes select Finish.
To complete the import process, Apply Map to Matrix.

Note:

In any .csv file, do not change the Dial Code or IP Address entries as the system uses these to match data fields.

Note:

The file type must be .csv.

Note:

Any commas in text fields will be stripped out. Quotations marks in text fields can cause unpredicatable results when re-imported.

Saved Export Files

According to the options you have selected, the following files are saved:

File name	Options	Headers
Entities	Ports, Roles, TCVRs, IFBs, Groups, Partylines, Controls, Speed Dials	Dial Code, Id Number, Label, Alt Label, Username, Password, Type, Sub Type, Panel Type, Secondary Action
Members	Groups, Partylines, IFBs	Parent Type, Parent Dial Code, Parent Port, Member Dial Code, Membership label, Membership Type
Trunks	Trunks	Port Number, Port Label, Alt Text, Port Sub Type, Remote System (if known), Remote Port (if known)
sipServers	SIP	Frame, Matrix Primary IP, Matrix Secondary IP, Export Version, Export Type, Index, Name, Description, Registrar IP, Domain IP, Port
sipAccounts	SIP	Frame, Matrix Primary IP, Matrix Secondary IP, Export Version, Export Type, Index, Name, Description, Registrar IP, Domain IP, Port
Beltpacks	Beltpacks	RF ID, Station ID, Preferred Role Team, Preferred Role, Role Selection, Beltpack Type