Skip to content

Studio export to csv/Excel truncates String values longer than 30 characters #721

Description

@vic0824

ArcadeDB Version: v22.11.1

JDK Version: openjdk 11.0.12 2021-07-20 LTS

OpenJDK Runtime Environment Corretto-11.0.12.7.1 (build 11.0.12+7-LTS)
OpenJDK 64-Bit Server VM Corretto-11.0.12.7.1 (build 11.0.12+7-LTS, mixed mode)

OS: CentOS release 6.9 (Final)

Expected behavior

The export to csv/Excel generates a file which include the same values stored in the database

Actual behavior

the csv/Excel export includes ellipsis for values longer than 30 characters.
This does not seem to be linked to the browser and screen settings, because if I open a side window (e.g. developer tools), all the table columns shrink but the amount of text displayed stays the same, it just wraps around.
The attached screenshot "Studio table view" shows that the Studio table view shows the value "CS_OPER_AUX_WNDCHE_00000000T00..." for the "name" property
The attached screenshot "json table view" shows that the actual value of the name property for that record is "CS_OPER_AUX_WNDCHE_00000000T000000_99999999T999999_0001.DBL"

Steps to reproduce

  1. Create a type
  2. create a property "name" of type String
  3. insert a value longer than 30 characters for the "name" property, e.g. 'property_name_longer_than_30_ch', which is 31 characters long.
  4. issue a select query for the type
  5. verify that the table view shows ellipsis "..." at the end of the value, e.g. 'property_name_longer_than_30_c...'
  6. click the json view and verify that the name property has value = property_name_longer_than_30_ch
  7. export to csv or Excel
  8. open the file and verify that the value is truncated and it contains ellipsis and the end, e.g. "property_name_longer_than_30_c..."

Studio Table view
Studio json view

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Type

No type

Fields

No fields configured for issues without a type.

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions