updating DCO Network Cable Types from ETL

[DCIM_Support]

I'm trying to update the DCO Network Cable Types from ETL but I cannot get it.

I'm using the cable_type table from ETL stagging database but the cables type are not created in DCO.

How can I get to do it?

Regards,

Enric Climent

(CID:102924936)

[DCIM_Support]

Hi Enric Climent, thank you for posting. Let's see who can be of assistance here. @community - any ideas?

(CID:102925004)

[DCIM_Support]

Hi Enric The functionality is there and should work. The easiest way to figure out what is happening is if I can take a look at the transformations you are using - is that possible? Are they built on top of the example transformation importing network connections and port configurations from an Excel sheet? Best, Niels

(CID:102925155)

[DCIM_Support]

Enric Climent See the comment above.

(CID:102925156)

[DCIM_Support]

Hi Niels,

How can I send you the tranformations and Excel files?

Regards,

Enric Climent

(CID:103583756)

[DCIM_Support]

Upload them here, or send them to Niels.Kjeldsen@Schneider-electric.com.

(CID:103583890)

[DCIM_Support]

Hi Niels,

Here are the transformation files.

Best regards,

Enric

ETLimport.zip

(CID:103583923)

[DCIM_Support]

Hi Enric

I have looked at the transformations and found out two things:

1. There was a small error in the port configuration transformation (one of the sorts missed a parameter). See the updated version of the file attached here.
2. I get the network cables in with type information and color. Both blue and red cables. Note that the experience is better if you create the cable types in Operations first, and then import network connections. The imported connections should then have the same cable type descriptions as the ones defined in Operations.

You can setup the cable types under Tools -> Configure Network Cable Types.

Please try the following:

1. Delete the staging database and set it up again (to reset the state of the database)
2. Upload the updated port configuration transformation file
3. Create the cable types you need in Operations
4. Setup the network import in Operations
5. Associate the devices from the external system to the matching equipment and save
6. Synchronize with the external system again to get the network connections. Now you should have cable types as well.

Best,

Niels

Updated port configuration transformation:PortConfiguration.ktr

(CID:103584233)

[DCIM_Support]

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