Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[CSV export] numeric fields being exported as strings #64170

Closed
blookot opened this issue Apr 22, 2020 · 4 comments
Closed

[CSV export] numeric fields being exported as strings #64170

blookot opened this issue Apr 22, 2020 · 4 comments
Assignees
Labels
bug Fixes for quality problems that affect the customer experience Feature:Reporting:CSV Reporting issues pertaining to CSV file export feedback_needed needs-team Issues missing a team label SharedUX/fix-it-week Bugs that have been groomed and queued up for the team's next fix it week

Comments

@blookot
Copy link

blookot commented Apr 22, 2020

Kibana version: 7.6.2

Elasticsearch version: 7.6.2

Server OS version: Elastic Cloud

Browser version: Chrome latest version

Browser OS version: Windows 10

Describe the bug:

When using CSV export on a saved search you get numeric fields as strings in the csv file.

Steps to reproduce:

  1. use ES monitoring index for instance
  2. create a saved search with node_stats_jvm_mem_heap_max_in_bytes field for instance
  3. export in CSV, you'll see this field is a string with commas...
@elasticmachine
Copy link
Contributor

Pinging @elastic/kibana-app-services (Team:AppServices)

@elasticmachine
Copy link
Contributor

Pinging @elastic/kibana-reporting-services (Team:Reporting Services)

@tsullivan tsullivan added the bug Fixes for quality problems that affect the customer experience label Feb 25, 2021
@tsullivan
Copy link
Member

Hi, can you check to see if the Advanced Settings has csv:quoteValues enabled?

@dokmic dokmic self-assigned this Mar 2, 2021
@dokmic dokmic added the SharedUX/fix-it-week Bugs that have been groomed and queued up for the team's next fix it week label Mar 3, 2021
@dokmic
Copy link
Contributor

dokmic commented Mar 5, 2021

The issue was fixed as part of #67027, and the fix is available starting from 7.9. Previously, we were returning formatted values in the CSV export, which were containing commas in numeric values. Currently, we apply that formating only if it is explicitly set in the index patter field settings.

@dokmic dokmic closed this as completed Mar 5, 2021
@sophiec20 sophiec20 added Feature:Reporting:CSV Reporting issues pertaining to CSV file export and removed (Deprecated) Feature:Reporting Use Reporting:Screenshot, Reporting:CSV, or Reporting:Framework instead (Deprecated) Team:Reporting Services labels Aug 21, 2024
@botelastic botelastic bot added the needs-team Issues missing a team label label Aug 21, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Fixes for quality problems that affect the customer experience Feature:Reporting:CSV Reporting issues pertaining to CSV file export feedback_needed needs-team Issues missing a team label SharedUX/fix-it-week Bugs that have been groomed and queued up for the team's next fix it week
Projects
None yet
Development

No branches or pull requests

5 participants