ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

First column on CSV Export missing "". Converted data wrong if first cell data contains a comma

book

Article ID: 240603

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

When exporting to CSV the first column of the CSV file doesn’t contain " ".
This means that if I export data that contains a comma (,) the data is split into two columns. 

For example when I export and convert data of the Project Staff Grid view with Resource (last name, first name) as the first column.

STEPS TO REPRODUCE:

1. Login to Modern UX and edit any project

2. Add at least one member of Staff

3. Export to CSV

Notice the first column does not have " "

4. Convert the CSV file into an Excel spreadsheet

Expected Results: CSV file first column to contain "" and converted data to fits to columns

Actual results: The first column of the CSV file does not have "" and when the data contains a comma, the content spreads to the next column

Cause

This is caused by DE64951

Resolution

This is an issue related to Excel and not Clarity. There must be some setting that interferes here.

List to csv, items in first column don't have surrounding double quotes - Bugs and Other Issues - MIT App Inventor Community

If the csv file is opened with Notepad++, you can see the double quotes on the first column too.

Opening the file in Google Sheets is fine too

Workaround if using Excel: Reorder the grid columns before doing the CSV Export to ensure the data does not contain commas like the Resource Name column does when separating last name, first name

Attachments