-
Suggestion
-
Resolution: Unresolved
-
None
Issue Summary
The CSV file that is exported from the Managed Accounts of Organizations, this file is clearly separated by commas "," - but when the Display Name of users or some other column has a comma when trying to use Excel, Google Sheets, or any other spreadsheet application when organizing the Data into columns, a lot of data is broken, making it difficult for our Customers and our support to analyze it when we need it.
Steps to Reproduce
- Export Managed Accounts for a huge Org When some users have the Display Name with a comma.
- Text To Columns on Excel, and it will break the lines.
Expected Results
Perhaps generating the CSV file by enclosing each value of each field with quotation marks <" ">, or separating the columns with another character such as pipe < | > or semicolon < ; >
Workaround
There is no easy Workaround for this, our Customers have to analyze line by line, and for huge organizations, this is not possible.
[ACCESS-1724] Improve Export from Managed Accounts
| Description |
Original:
h3. Issue Summary
The CSV file that is exported from the Managed Accounts of Organizations, this file is clearly separated by commas "," - but when the Display Name of users or some other column has a comma when trying to use Excel, Google Sheets, or any other spreadsheet application when organizing the Data into columns, a lot of data is broken, making it difficult for our Customers and our support to analyze it when we need it. h3. Steps to Reproduce # Export Managed Accounts for a huge Org When some users have the Display Name with a comma. # Text To Columns on Excel, and it will break the lines. h3. Expected Results Maybe change the generated file to another unused character such as pipe "|" or semicolon ";" for example h3. Workaround There is no easy Workaround for this, our Customers have to analyze line by line, and for huge organizations, this is not possible. |
New:
h3. Issue Summary
The CSV file that is exported from the Managed Accounts of Organizations, this file is clearly separated by commas "," - but when the Display Name of users or some other column has a comma when trying to use Excel, Google Sheets, or any other spreadsheet application when organizing the Data into columns, a lot of data is broken, making it difficult for our Customers and our support to analyze it when we need it. h3. Steps to Reproduce # Export Managed Accounts for a huge Org When some users have the Display Name with a comma. # Text To Columns on Excel, and it will break the lines. h3. Expected Results Perhaps generating the CSV file by enclosing each value of each field with quotation marks <" ">, or separating the columns with another character such as pipe < | > or semicolon < ; > h3. Workaround There is no easy Workaround for this, our Customers have to analyze line by line, and for huge organizations, this is not possible. |