Export Color name instead of of Hex code

[dfex]

NetBox version

v4.2.5-Docker-3.2.0

Feature type

Change to existing functionality

Proposed functionality

Hello Netbox legends!

I'm exporting the Cables view to CSV for my field techs to go and patch interfaces.

One thing that confuses them (among many) is that Netbox exports the Colour column as Hex Values:

It would be great if this could export the Color name (that is displayed in the color picker drop-down) instead:

Thanks!

Ben

Use case

Would allow netbox admins to export Cable views as patching schedules for electrical/cabling contractors to execute.

Database changes

Possibly, yes - from what I can see of the API data, only the hex code is stored, not the color name

External dependencies

None

[jeremystretch]

Storing the actual RGB value in the database has some utility, so I think we want to keep it. However, we could add an optional field on the tables with color fields to include the name of the color as well.

We could potentially also support using the color names for bulk import as well, by introducing an optional color_name field. That should probably be a separate FR though.

[dfex]

I'm happy to own this one and get a PR raised

[1024834]

We could potentially also support using the color names for bulk import as well, by introducing an optional color_name field. That should probably be a separate FR though.

Requested in #18936

[bctiemann]

@dfex if you can handle #18936 as well, please comment in that FR and we can assign it to you. Thanks!