149 views

When exporting from a list view or export set using CSV, column lengths are restricted to 32,000 characters

 

Issue

If doing a CSV export from a list view or using an export set and a column contains more than 32,000 characters, the export will limit those columns to around 32,000 characters.

  

Cause
By default, CSV exports are limited to 32,000 characters per column.  The CSV export uses the display value when exporting columns with long string values.

 

Resolution

To allow CSV exports to have column exports in excess of 32,000 characters, modify the export type from display values to raw values by using one of the following methods:

  • Navigate to System Properties > Import Export and set the Use Raw Values system property to true.

  • Modify the sys_properties table with the following details:

    • Name = glide.export.csv.raw.value
    • Type = true|false
    • Value = true

     

    Note: Setting this property will apply this unlimited CSV export to all CSV exports system wide, so this might not be acceptable for all users.  This also exports RAW values for reference fields, not display values.

     

Article Information

Last Updated:2017-10-17 16:00:39
Published:2017-02-23