where do I find cable_type_id ....

[DCIM_Support]

when loading DCO 7.5 network connections via ETL Import network_connection table?

I checked ETL Export DB and some of the Web Service APIs but nothing 

I'd like to set the cable type and hopefully colour on the "Physical" tab of cable connection

I've configured network cable type via Tools - Configure Network Cable Type and FWIW have a "Network Cables" genomes entry 

Or do I have to set them via ETL import cable_type table but how do I populate this table and sync/associate with the cable types in DCO

Thanks

(CID:103584659)

[DCIM_Support · Accepted solution]

Pls disregard.  I worked out how to use the cable_type table 

(CID:103584664)

[DCIM_Support]

Hi Ed,

Please copy your answer here so people can access it 😉 In regard of the cable colours, you need to specify the RGB colour code.

-Guillaume

(CID:103584672)

[DCIM_Support]

The use of the ETL Import table "cable_type" is independent of the cable info set via the DCO GUI.  Set your cables types before loading your connections, e.g. 

INSERT INTO cable_type

(id, description, red, green, blue)

VALUES
(‘ct0001’,’red’,255,0,0),

(‘ct0002’,’yellow’,255,255,0),

(‘ct0003’,’orange’,255,128,0),

(‘ct0004’,’blue’,0,128,255);

Then when you load your connection, you can specific which cable type you want using the "id" column as key.

INSERT INTO network_connection

(id, name, barcode, serial_number, description, length, manufacturer, model_name,part_number,cable_type_id,

from_id, from_connector_type, from_module_name, from_port_number, is_from_patch_panel_rear,

to_id,   to_connector_type,   to_module_name,   to_port_number,   is_to_patch_panel_rear,

state_flag, state_last_updated)

VALUES

(‘CN000001’,’CableName’,’CableBarcode00001’,’cableSerialNum’,’The cable description server direct to switch’,12,’Clipsal’,’Clipsal Super RJ45 patch lead’,’EdsPartNum’,’ct0001’,

’000001’,’RJ45_REGULAR’,’ServerRearModuleA’,1,0,

’000002’,’RJ45_REGULAR’,’SwitchNetModuleA’,1,0,

’new’, 1444196853);

Footnote: it would be great if this type of "how to use" info was present as a matter of course, e.g. at http://dcimsupport.apc.com/display/public/DCIMDEVELOPER/ETL+Import+Database

(CID:103584686)

[DCIM_Support]

Thank you very much for sharing your example, Ed:-) Now it is available to everyone looking for instructions about setting the cable type. Updating the developer documentation is on our backlog.

(CID:103584695)

[DCIM_Support]

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