RecordListToExcel: column name translation

By Carlos Henriques on 31 Jan

RecordListToExcel should be able to translate the column names of the Excel header.


We can translate the labels of a structure attribute but this does not have impact on the RecordListToExcel action output.

Carlos, what's your use case for translating the column names?

J.1 Feb

our use-case: export (without having to import them later on)


J., so you want to translate the column names on Export, to have them match the current locale? Or in practice you want to always customize the names?

The column names should get the mapping like other stuff in the system does, in my opinion.

J.Ja

Hi Paulo,


We have multi language applications (english, portuguese and spanish), and many of them have export to excel actions near a TableRecord.

Table headers are translated, but when the user exports to excel, the excel header is always in english, the default language used for the label attributes of entities and structures).


It's strange for the user to see all the application translated to his language, but when exporting data to excel getting some parts in another language. It's not coherent.


The weirdest thing is that we can translate structure attribute labels on Language Resources, but with no visible impact, since the RecordListToExcel does not use them.

Yeah, it's really strange this doesn't work. I'd consider it a bug even...

Justin James20 Jun 2014
It would be great if we could change what text is used as the header text on RecordListToExcel, our internal entity/attribute names often do not make sense for the people who use the exported data.

Thanks!

J.Ja


Merged from 'RecordListToExcel: Control header text' (idea created on 2014-06-20 18:18:42 by Justin James), on 2017-05-12 10:48:11 by André Vieira
José Antunes27 Jun 2014
Hi James,

Indeed, we had a similar problem. In some cases the entity Label attribute is enough, but in some user requirements we had to create structures with the desired attribute label for the header. This adds extra work and often ends up in a maintenance problem.

Cheers,
JA

Merged from 'RecordListToExcel: Control header text' (idea created on 2014-06-20 18:18:42 by Justin James), on 2017-05-12 10:48:11 by André Vieira
José Antunes27 Jun 2014
Hi,

By the way, it would be nice to be able to change the order of the columns as well...


Cheers,
JA

Merged from 'RecordListToExcel: Control header text' (idea created on 2014-06-20 18:18:42 by Justin James), on 2017-05-12 10:48:11 by André Vieira
André Ramos6 May 2011
We should be able to define the names of the fields we are exporting to excel.

Merged from 'RecordListToExcel field names' (idea created on 2011-05-06 16:00:27 by André Ramos), on 2017-05-12 10:49:19 by André Vieira
Fernando Sousa18 Apr 2012
It would work for me if we could choose if we want the header to be added automatically (true, by default as it is now).

When we want to customize headers, we could set this option to false, create a record with the intended custom filed names and then add the record to the top of the record list (ListInsert at position 0) we want to export.

Obviously, this would require all fileds of the structure in use to be Text.

Merged from 'RecordListToExcel field names' (idea created on 2011-05-06 16:00:27 by André Ramos), on 2017-05-12 10:49:19 by André Vieira

Please add this simple feature to change column header and order. 

Current workaround is creating a Structure, mapping fields to Structure and exporting it. This keeps the order and header name.

Andrew,

That would be a different Idea, this Idea is about translation only.