Exporting to CSV file shifts column content if there is a comma in the results

book

Article ID: 192761

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

The customer is generating reports from Manage > Computers.
He is adding a filter for active computers and primary user, asset status, etc. for example.


 
The report looks normal and acceptable in the console.

However, when he exports to a CSV file, the formatting is getting messed up, shifting values to the right.

Cause

Known issue. What seems to be causing the issue is the results from vAC_PrimaryUser: there is a comma between [last name][first name].


 
When he adds this column into the report, it is causing issues with the other columns.

Most of the time, vAC_PrimaryUser is formatted [last name][first name]. However, the CSV file puts the last name on one cell and first name on the next column, shifting everything to the right.
 
Also, when a "user" is missing in vAC_Primary, it shifts the other columns to the right and doesn't put a blank in the primary user cell.

Environment

ITMS 8.5 RU3 

Resolution

This issue has been reported to our Broadcom Development team.
 
A possible workaround is if you save the filter results "As a report" instead of "Export".
Then for the saved report, you can "Save As >Spreedsheet", the CSV formatting should stay fine.

Attachments