# Network Topology Map Export to Visio

This guide explains how you can export your network topology map from Domotz to Microsoft Visio.

**Please Note:** The ability to use the required Excel Data Visualizer templates is only available with Visio Plan 2. If you're not sure what version of Visio you're using, select **File** > **Account** > **About Visio**. Visit Microsoft's page for [Visio Plan 2](https://go.microsoft.com/fwlink/?linkid=838594) to learn more about the subscription version of Visio.

Ultimately, by completing these steps you will be able to edit your Network Topology Map in Microsoft Visio. Furthermore, the end results will be a nicely designed asset you can share with your customers and stakeholders.

## Requirements

To import your Domotz Network Topology to Microsoft Visio, you will need a laptop or workstation with both Microsoft Visio and Microsoft Excel installed.

This guide was created using Microsoft Visio Plan 2 MSA (Version 2204 Build 16.0.x) and Microsoft Excel for Microsoft 365 MSO (Version 2204 Build 16.0.x).

## Domotz Network Topology Visio Template

Firstly, to export to Visio, the first step is to download and install the Domotz Network Topology Visio Template which contains the logic and the icons to build a cross-functional network topology graph in Visio.

[Download the Domotz Visio Template](https://github.com/domotz/domotz2visio/raw/main/templates/Domotz-Network-Topology-Template.vtpx)from Github.

Once you've downloaded the template, double click on it and it should get automatically imported into Microsoft Visio.
If the installation is successful this window will appear:

Installation Confirmation for Visio Template Package

1. A dialog box indicates that the Visio template package installation is complete.
2. You can find the Visio template on the Personal tab in the Backstage.
3. The Excel template is located in Documents under Custom Office Templates.
4. Click the "OK" button to close the dialog box.

## From Domotz - Export Network Topology in Excel format

To export the Domotz Network Topology in Excel format, please go to your Agent's Network Topology Section and select the "Export as Excel File" download arrow:

Network topology overview with export option.

1. View the network topology map, which shows connections from the internet to devices, indicating download and upload speeds.
2. Use the "Filter Devices" section on the left to manage display options, such as showing outdated links and highlighting important devices.
3. Refer to the legend to understand link types: direct, outdated, manual, and WiFi.
4. To export the network map, scroll down to the "Download Map" section and select "Export as Excel file."
5. Click the link for instructions on importing the file into Visio.

## In Visio - Importing the Network Topology

Firstly, open Microsoft Visio and go to "Home", select "Domotz Network Topology", and click "Create":

Creating a Domotz Network Topology Diagram

1. In the application interface, select the "Home" tab from the left-side menu.
2. Under the "New" section, click on the "Domotz Network Topology (cross-functional)" template.
3. In the dialog box that appears, click the "Create" button to generate the diagram using the selected template.

Secondly, browse for the excel file you downloaded from Domotz and open it:

Creating a Diagram from an Excel Workbook in Microsoft Visio

1. In Visio, click the "Browse" button next to "Select an Excel workbook."
2. In the file explorer window that opens, navigate to the "Downloads" folder.
3. Select the Excel file named "network-topology" from the list and proceed to use it for creating your diagram.

Next, click on "Finish":

Creating a Diagram from Excel Data

1. Choose the diagram type from the dropdown menu; select "Cross Functional Flowchart (horizontal)".
2. Specify the Excel workbook by using the field labeled for workbook selection, such as "network-topology.x" which shows the file path. Use the "Browse..." button if necessary to locate the workbook.
3. Choose a table or custom range within the workbook using the provided dropdown, such as "network_topology".
4. Click "Next" to proceed through the setup. A note suggests using an Excel table for better data update management.
5. Complete the setup by clicking "Finish".

After that, your Network Topology will be imported.
On the right side you will also be able to add additional fields to your devices if required.

Network topology diagram with device IP addresses.

1. The diagram shows a network with various devices connected through switches. Devices include ESXI-2, ESXI-DR, and iRMC ESXI-DR servers.
2. IP addresses are displayed for each device: ESXI-2 (192.168.99.2), iRMC ESXI-DR (192.168.99.241), ESXI-DR (192.168.99.3), wireless router (192.168.99.200), and another wireless router (192.168.99.194). A core switch with IP 192.168.99.240 and Switch-01 with IP 192.168.99.13 are also shown.
3. Cables connect the devices through the switches, indicating the network's structure.
4. On the right, a menu allows selection of data graphics, with "IP" checked and "MAC" unchecked. Other options like Device ID, Device Name, and Device Type are available for customizing the display.

Furthermore, after selecting the additional fields, you will be able to see them attached to the displayed devices.

Network topology diagram with device details and field selection.

1. The diagram shows a network with devices such as switches and servers. Each device includes information boxes displaying details like IP, MAC address, device type, model, and vendor.

2. The top-center device is labeled "Switch-Core," connecting to multiple devices. Each connected device has specific details:
   - Device 1: IP 192.168.99.2, MAC 3A:68:DD:12:B0:4F, Device Type Server, Model ThinkSystem SR650, Vendor Lenovo.
   - Device 2: IP 192.168.99.241, MAC E8:BA:70:21:13:41, Device Type Switch, Model C2960S, Vendor Cisco Systems, Inc.
   - Device 3: IP 192.168.99.13, MAC 4C:52:62:04:8E:96, Device Type Server, Model ServerView iRMC S4 Web Server, Vendor Fujitsu Technology Solutions GmbH.

3. On the right side, a panel titled "Choose column fields to apply data graphics" allows selection of information to display. Items such as Device Type, Vendor, IP, and MAC are selected.

This setup helps visualize the network structure and filter displayed information based on user preferences.

Please note that in order to the map to be created by Visio, the excel file should not exceed the size of 50 Kbytes.

To conclude, learn more about Domotz [network topology mapping features](https://help.domotz.com/user-guide/network-topology/).

## Troubleshoot Visio import

If you encounter issues while importing the Domotz Network Topology Map into Visio, please follow the steps below to create a custom template for importing the network topology diagram. 
 
**_Kindly keep in mind that the screenshots have been made with the Plan 2 version, so with your Visio version they might differ, and you might search online if something is missing._** 

Creating a Flowchart Using Software Templates

1. In the left-side menu, select "New" to start a new document.
2. Go to the "Templates" tab to browse available templates.
3. Scroll to the "Flowchart" option in the green section and select it to begin designing a flowchart.

 

Selecting a Cross-Functional Flowchart Template with Excel

1. Locate the section displaying various flowchart templates.
2. Identify the "Cross-Functional Flowchart" that includes an Excel icon in the top-left corner of its preview.
3. Click on this template for a flowchart with Excel integration features.

Select the Metric for data values and click create:

Creating a Cross-Functional Flowchart in Data Visualizer

1. Choose the unit of measurement by selecting either "Metric Units" or "US Units".
2. Click the "Create" button to generate the flowchart.

Load the network topology Excel file that you have downloaded from Domotz portal to the chart:

_[Image]_

Creating a Diagram from Excel Data

1. In the "Create Diagram from Data" window, choose the diagram type you want from the "What diagram do you want to create from data?" dropdown menu. Select "Cross Functional Flowchart (horizontal)".
2. In the "Select an Excel workbook" section, either use the provided Excel template or click "Browse" to locate your file. Ensure the file is chosen correctly.
3. In the "Select a table or a custom range in the workbook" dropdown menu, ensure "network_topology" is selected. This is crucial for updating source data.
4. Click the "Next" button to proceed with the setup.

_[Image]_

_[Image]_

Here you have to map the icons for all the devices. In order to find the "networking ones" you will have to click on "More Shapes."

And then to assign them to each device type, you will have to drag and drop them in the "Shapes" column:

_[Image]_

_[Image]_

After clicking "Finish" you should get your final network topology diagram. 

If you would like to obtain the "**curved**" connections, you will have to navigate to the Design tab and select the Re-Layout page: 

Accessing More Layout Options for Diagram Customization

1. Click on "Re-Layout Page" in the toolbar to open a dropdown menu with different layout options such as Flowchart, Hierarchy, Compact Tree, Radial, and Circular.
2. Select "More Layout Options…" at the bottom of the dropdown to access additional customization settings for diagram layouts.

Configuring Layout in a Diagram Tool

1. In the "Configure Layout" window, select "Radial" from the "Style" dropdown under "Placement".
2. Set the "Spacing" to 7.5 mm.
3. Under "Connectors", choose "Flowchart" for "Style" and "Curved" for "Appearance".
4. Ensure the "Apply routing style to connectors" box is checked.
5. The layout will apply to the "Current page".
6. Click "OK" to confirm and apply the settings.