4
 Followers
77
 Likes

RecordListToExcel field names

Backend
On our radar
We should be able to define the names of the fields we are exporting to excel.
Created on 6 May 2011
Comments (25)
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 this idea with 'Rename Columns in RecordListToExcel widget' (created on 21 May 2010 16:56:41 by André Vieira)
It would be very helpful not only to select what columns from the recordlist are exported but also what are the names used for the headers with multilanguage support.


This comment was:
- originally posted on idea 'Rename Columns in RecordListToExcel widget' (created on 21 May 2010 by André Vieira)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:13:17 by Vasco Pessanha

When the source record list is an entity, Labels are used instead of Names, but when it is a structure, it is always Names that are used.

Also, when the source record list contains more than one entity, Labels are always prefixed with the entity's name, even when you are only exporting data of just one entity.


This comment was:
- originally posted on idea 'Rename Columns in RecordListToExcel widget' (created on 21 May 2010 by André Vieira)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:13:17 by Vasco Pessanha
This would be perfect! And lots of time the user asks for special header name.. And even for entities (that normally show the label),if it's a JOIN, the labels come with the alias...


This comment was:
- originally posted on idea 'Rename Columns in RecordListToExcel widget' (created on 21 May 2010 by André Vieira)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:13:17 by Vasco Pessanha
Thumbs up!

I've needed this more than once.

This comment was:
- originally posted on idea 'Rename Columns in RecordListToExcel widget' (created on 21 May 2010 by André Vieira)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:13:17 by Vasco Pessanha

Perhaps allow us to specify the name of the column when exported, i.e. add a text field on each column that we can input an 'alias' for the column that when it gets exported.



This comment was:
- originally posted on idea 'Rename Columns in RecordListToExcel widget' (created on 21 May 2010 by André Vieira)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:13:17 by Vasco Pessanha

 As per the requirement we can change the header name ..

Create a structure having all the attribute with text type, and change the name of label as per your requirement, if you will export a record list using this structure it will export the label name not the name in excel.



Thanks 

Rajendra Singh



This comment was:
- originally posted on idea 'Rename Columns in RecordListToExcel widget' (created on 21 May 2010 by André Vieira)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:13:17 by Vasco Pessanha

 As per the requirement we can change the header name ..

Create a structure having all the attribute with text type, and change the name of label as per your requirement, if you will export a record list using this structure it will export the label name not the name in excel.



Thanks 

Rajendra Singh



This comment was:
- originally posted on idea 'Rename Columns in RecordListToExcel widget' (created on 21 May 2010 by André Vieira)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:13:17 by Vasco Pessanha
Merged this idea with 'RecordListToExcel: column name translation' (created on 31 Jan 2017 14:24:02 by Carlos Henriques)

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.



This comment was:
- originally posted on idea 'RecordListToExcel: column name translation' (created on 31 Jan 2017 by Carlos Henriques)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:55:05 by Vasco Pessanha

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



This comment was:
- originally posted on idea 'RecordListToExcel: column name translation' (created on 31 Jan 2017 by Carlos Henriques)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:55:05 by Vasco Pessanha

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




This comment was:
- originally posted on idea 'RecordListToExcel: column name translation' (created on 31 Jan 2017 by Carlos Henriques)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:55:05 by Vasco Pessanha

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?



This comment was:
- originally posted on idea 'RecordListToExcel: column name translation' (created on 31 Jan 2017 by Carlos Henriques)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:55:05 by Vasco Pessanha

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

J.Ja



This comment was:
- originally posted on idea 'RecordListToExcel: column name translation' (created on 31 Jan 2017 by Carlos Henriques)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:55:05 by Vasco Pessanha

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.



This comment was:
- originally posted on idea 'RecordListToExcel: column name translation' (created on 31 Jan 2017 by Carlos Henriques)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:55:05 by Vasco Pessanha

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



This comment was:
- originally posted on idea 'RecordListToExcel: column name translation' (created on 31 Jan 2017 by Carlos Henriques)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:55:05 by Vasco Pessanha
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

This comment was:
- originally posted on idea 'RecordListToExcel: column name translation' (created on 31 Jan 2017 by Carlos Henriques)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:55:05 by Vasco Pessanha
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

This comment was:
- originally posted on idea 'RecordListToExcel: column name translation' (created on 31 Jan 2017 by Carlos Henriques)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:55:05 by Vasco Pessanha
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

This comment was:
- originally posted on idea 'RecordListToExcel: column name translation' (created on 31 Jan 2017 by Carlos Henriques)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:55:05 by Vasco Pessanha
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

This comment was:
- originally posted on idea 'RecordListToExcel: column name translation' (created on 31 Jan 2017 by Carlos Henriques)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:55:05 by Vasco Pessanha
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

This comment was:
- originally posted on idea 'RecordListToExcel: column name translation' (created on 31 Jan 2017 by Carlos Henriques)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:55:05 by Vasco Pessanha

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.



This comment was:
- originally posted on idea 'RecordListToExcel: column name translation' (created on 31 Jan 2017 by Carlos Henriques)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:55:05 by Vasco Pessanha

Andrew,

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



This comment was:
- originally posted on idea 'RecordListToExcel: column name translation' (created on 31 Jan 2017 by Carlos Henriques)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:55:05 by Vasco Pessanha
Merged this idea with 'RecordListToExcel field names' (created on 2011-05-06 16:00:27 by André Ramos)

This comment was:
- originally posted on idea 'RecordListToExcel: column name translation' (created on 31 Jan 2017 by Carlos Henriques)
- merged to idea 'RecordListToExcel field names' on 07 Sep 2018 14:55:05 by Vasco Pessanha
views
768
Followers
4