Data export Functionality

sailaja sivaraju

May 9, 2018 at 2:53 am #5128

Hi ,

I have a functionality to export the data where I need to keep some columns names and respective data hidden.With spark version(4.5.2),I achieved that.But when I have upgraded the version to 4.5.3,I am getting empty columns (without headers)with null values which is not expected…Is there any difference in functionality of data export button between these 2 versions.

Thanks in advance..

 

 

SPARK Support

May 9, 2018 at 3:09 pm #5132

Hi Sailaja,

There was a fix implemented to allow null values to create a cell if the column was being exported.  This way, a record that was missing a property would not cause the cells to be misaligned.

However, I have tested a scenario with a Data Export control bound to a Table using SPARK UI version 4.5.4, and I am seeing only the columns included in the Table as the exported data.

Can you post a screen show of your design layout and the Data Export control configuration?

Regards,

Stephen P.

sailaja sivaraju

May 10, 2018 at 1:28 am #5133

Hi,

To be more clear I  am using data export control with bound data in 4.5.2..if value is not set in the bound data, it was not exported..whereas in 4.5.3 it is getting exported..

sailaja sivaraju

May 10, 2018 at 1:38 am #5134

Thanks Stephen for the reply..Please find the attached for more information for the bindings and the excel sheet.The columns which are in yellow color needs to be hidden..but they are getting displayed with empty values..

 

 

SPARK Support

May 10, 2018 at 10:28 am #5138

Hi Sailaja,

Yes, this is due to the fix that was implemented to prevent null values from skewing the columns.  You can work around this by creating a Business Object that does not contain the properties that you do not wish to export, and copying the values from the primary list.

Regards,

Stephen P.