Reordering Input Data columns in a Service Template CSV export

Solved107 viewsExport Configuration export csv service template service templates
2
2 Comments

Hi dojo,

I have a Service Template that is mainly based on several Input Data fields, which are used to define child elements, parameter indices, ports, service names, and other service configuration details.

During the template creation, some additional Input Data fields had to be added later. Because of that, when exporting the Service Template configuration to CSV, the columns are not in the most logical order for the service flow. They seem to follow the order in which the Input Data fields were created.

Is there any way to reorder the Input Data fields in an existing Service Template, so that the exported CSV columns appear in a more intuitive order, without having to recreate the template from scratch?

Thanks in advance.

Daniel Silva [DevOps Advocate] Selected answer as best
Miguel Obregon [SLC] [DevOps Catalyst] commented

Hi Daniel,
Since the exported CSV file contains a header with the column names, you can open the file in a spreadsheet and move the columns accordingly. Is this an option for your use case?
Daniel Silva [DevOps Advocate] commented

Hi Miguel,

Thanks for the suggestion.

I had already tested that, but manually reordering the columns in the CSV and importing it again does not change the Service Template configuration. When exporting it again, the CSV still comes with the original column order.

For this use case, the idea is to have the CSV exported already in a logical order, without requiring the columns to be rearranged manually every time.

So I was wondering if there is a way to persistently reorder the Input Data fields in the Service Template itself, or if recreating the template is the only option.

1 Answer

0
6.85K 1 Comment

Hi Daniel,

The order in which the data:xxx columns appear in the "Export configuration..." CSV output is the order in which the "Input Data" fields appear in the add/edit service template user interface and in the XML files that back the service template configuration.

There's currently no possibility to re-order entries in that UI.

One option could be to recreate the input data fields there in the correct order while not touching the rest of the service template definition.

Daniel Silva [DevOps Advocate] Selected answer as best
Daniel Silva [DevOps Advocate] commented

Hi Wouter,

Thanks for the clarification.

That makes sense and confirms what I was seeing in the UI. Having an option to reorder the Input Data fields directly would be useful for making the CSV export easier to manage in this kind of use case.

Thanks again for the explanation.