Solved

Is it possible to exclude columns when exporting data?

  • 28 May 2020
  • 5 replies
  • 124 views

Userlevel 4
Badge +11

 

Is it possible to exclude columns when exporting data? I already marked these columns as Hidden but you can still select them if you want. 
 

Example for excluding Hidden fields

 

The order seems to be taken from the order in Subjects > Components > Grid.

I know that you can modify the column sequence before executing the export when you choose for the option "Advanced option” and drag and drop the chosen field. But I want a default ordering of columns for export deviating from the order in the grid.
 

How to modify the "Standard order”

 

icon

Best answer by Jasper 4 June 2020, 14:43

View original

5 replies

Userlevel 7
Badge +11

Hi Dennis, 

If you set these columns hidden at column level instead of the grid or form, then they won’t be available for export. 

Userlevel 4
Badge +11

Hi Jasper,

The Software Factory (2019.2) doesn't seems to behave that way. Even if I make the column type "Hidden" on META-level it remains selectable with the advanced export functionality. 

Maby it's because these colums are a Primary key :thinking: ?

 

Hidden on META level

 

Hidden on Subjects > Columns level

 

Number* and Invoice* still available for export

Besides that I'm still wondering or you can set a default ordering of columns for export. 

Userlevel 7
Badge +11

You’re right, primary key columns are always available for export because you need those columns when importing data or updating data using an import file.

Unfortunately, there is no way to set the order of columns for export, apart from using the Grid ordering.

Userlevel 4
Badge +11

Okay clear, in that case I'll make a variant specifically for exporting the columns in the ordering we want, disable all the other options and only allow the export functionality.

Is it worth putting it up as an idea on the platform?

Userlevel 7
Badge +11

Sure, feel free to submit an idea!

Reply