Excel import Network connections issues

DCIM_Support · ‎2020-07-04

This question was originally posted on DCIM Support by amit shmaryahu on 2018-01-17

Hi, I am planning a DC using DCO 8.1. I am trying to import the network layer using excel. I am having problem to connect two PP. I succeeded to connect the first port only. The other ports are ignored. Any idea?

DCIM_Support · ‎2020-07-04

This answer was originally posted on DCIM Support by Jef Faridi on 2018-01-17

Hi Amit,

As far as I know, excel import does not support patch panel to patch panel connections. I would also like to mention that the excel import has limited functionalities and may overwrite the exciting data!

Kind regards

DCIM_Support · ‎2020-07-04

This comment was originally posted on DCIM Support by amit shmaryahu on 2018-01-17

Thanks,

DCIM_Support · ‎2020-07-04

This comment was originally posted on DCIM Support by amit shmaryahu on 2018-01-17

Jef thanks for your quick answer,

I am aware that this functionality is limited.

I am designing a new DC with a large number of new racks.

I need to prepare the network infrastructure before adding any IT devices.

I should create a full rout from the IT Rack PP to the COR switch.

A manual routing would consume great deal of time.

Is there a way to import network using DCO?

DCIM_Support · ‎2020-07-04

This comment was originally posted on DCIM Support by Jef Faridi on 2018-01-17

You are most welcome, Amit

In DCO we usually do manual configurations, but as you've mentioned process can be very time consuming. However, for large setups integration through ETL could be considered. Here is a short description about ETL: External system integration through ETL

ETL configuration/integration might be complex and may require programming skills. However, customized ETL integration can also be offered as service - for details you might want to contact Lasse Simonsen. I know, Lasse & the service team having a great experience with customized integration tasks (including network configuration though ETL).

Kind regards

DCIM_Support · ‎2020-07-04

This comment was originally posted on DCIM Support by Ed Tarento on 2018-01-18

Hi Amit

This has been done for a large Australian corporation. As Jef has advised, Lasse and his team can assist and/or you can get more info from Lukasz Staciwo or myself.

Cheers

DCIM_Support · ‎2020-07-04

This comment was originally posted on DCIM Support by amit shmaryahu on 2018-01-23

Hi,

I have tried using the ETL network example, downloading the excel file, the kjr, ktr, files as well to the pentaho/import directory on the DCO server.

I created the staging db.
I created the servers, patch panels and switch in the DCO client in a test room with the same names as the PortConfiguration indicates at the 'name' column.
Than, I ran the external system connection.

Unfortunately I didn't get any result, at all.

Where's my mistake?

Is there any indication of success or failure?
Is there a way to set the location for the assets, servers, pp, switch, etc? Or does it locate it automatically?
Should the assets names be unique, for example server1 or should I add another attribute to point to the specific asset I want to connect?
Is there a way to create a route between two assets cross some pp?

If there is another example of network management and connection I would appreciate if you can share it with me.

Regards,

DCIM_Support · ‎2020-07-04

This comment was originally posted on DCIM Support by Ed Tarento on 2018-01-23

Hi Amit

The system that we developed included loading rear connections, patch panel to patch panel. but we populate the ETL import DB directly from our program. This was a custom developed an dis the property of the client.

I share this so you know it's possible. As Jef has mentioned, the Excel import is designed for specific use cases.

Let me know if you need more assistance

Cheers

Ed

DCIM_Support · ‎2020-07-04

This question is closed for comments. You're welcome to start a new topic if you have further comments on this issue.