Creating a cable-export template for v3.4.3

[oneone84]

Hi,

I would like some help converting a template I used for exporting cables in v2.x.y to something that works in v3.4.3.
The base of the problem is that I can not simply export cables with csv and then import them.

In the earlier version the below worked ok, but with the changes I can not determine which fileds I need:

label,type,color,length,length_unit,side_a_device,side_a_name,side_a_type,side_b_device,side_b_name,side_b_type
{% for cables in queryset -%}
{{ cables.label }},{{ cables.type }},{{ cables.color }},{{ cables.length }},{{ cables.length_unit }},{{ cables.termination_a.device.name }},{{ cables.termination_a }},{{ cables.termination_a_type.app_labeled_name|replace(" | ",".")|replace(" ","") }},{{ cables.termination_b.device.name }},{{ cables.termination_b }},{{ cables.termination_b_type.app_labeled_name|replace(" | ",".")|replace(" ","") }}
{% endfor %}

[oneone84]

I was closer than I thought, this almost works, just need to find the correct call for side_a/b_name to replace
{{ cables.a_terminations[0].cable_terminations.content_type.model }}

label,type,color,length,length_unit,side_a_device,side_a_type,side_a_name,side_b_device,side_b_type,side_b_name
{% for cables in queryset -%}
{{ cables.label }},{{ cables.type }},{{ cables.color }},{{ cables.length }},{{ cables.length_unit }},{{ cables.a_terminations[0].device.name }}, {{cables.a_terminations[0].cable_terminations.content_type.app_label}}.{{cables.a_terminations[0].cable_terminations.content_type.model}},{{ cables.b_terminations[0].device.name }},{{cables.b_terminations[0].cable_terminations.content_type.app_label}}.{{cables.b_terminations[0].cable_terminations.content_type.model}}
{% endfor %}

content type: DCIM > Cables

Preferably I would like to see this or similar offered by Netbox and supported for future versions.

[oneone84]

Sorry, it is actually this one that is not working
cables.b_terminations[0].cable_terminations.content_type.app_label
result I get is "dcim", while I am trying to get name of the port/interface.

[oneone84]

I finally solved this with the help of #11762

At first I didn't understand why one would assign to the variables, but it does make it simpler. I had another order for the fields, maybe this is helpful to someone:

label,status,type,color,length,length_unit,side_a_device,side_a_type,side_a_name,side_b_device,side_b_type,side_b_name {%- for c in queryset %} {%- set act = c.a_terminations[0].cable_terminations.content_type %} {%- set bct = c.b_terminations[0].cable_terminations.content_type %} {%- if act.app_label != 'circuits' and bct.app_label != 'circuits' %} "{{ c.label }}",{{ c.status }},{{ c.type }},{{ c.color }},{{ c.length|default("", True) }},{{ c.length_unit }},{{ c.a_terminations[0].device.name }},{{ act.app_label }}.{{ act.model }},{{ c.a_terminations[0].name }},{{ c.b_terminations[0].device.name }},{{ bct.app_label }}.{{ bct.model }},{{ c.b_terminations[0].name }} {%- endif %} {%- endfor %}

content type: DCIM > Cables

Example output:
label,type,color,length,length_unit,side_a_device,side_a_type,side_a_name,side_b_device,side_b_type,side_b_name
"75275",connected,cat5e,9e9e9e,1.00,m,switch1,dcim.interface,PORT1,patch-panel1,dcim.frontport,1