Export to CSV for Money attributes in Modern UX exports incorrect number of decimal places

book

Article ID: 194153

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Problem Statement: Export to CSV for Money attributes in Modern UX exports incorrect number of decimal places 

STEPS TO REPRODUCE:

  1. Create a money attribute on the project object
  2. Set the Which field to the Currency Code
  3. Enter a API Attribute ID value
  4. Click the Save and Return button
  5. Log into the Modern UX
  6. Click the Projects link
  7. Click the View Options and set the Money display to two decimal places.
  8. Add the new money attribute through the column panel
  9. Manually add values to some of the projects
  10. Select the Export to CSV
  11. Open the exported CSV file with text editor and examine the values for the money attribute


Expected results: Values of the money attribute are exported format 1234.56


Actual results: Values of the money attribute are exported in the format 1234.560

Cause

This was logged as defect DE56123 but it was determined as working as designed 

 

Environment

Release : All Clarity Supported Version 

 

Resolution

This is working as per design. This was discussed during the initial design discussion and decided to not to process any data as it will introduce performance issues like Classic UI export. So we export the data without considering the UI settings. Display of decimals for numbers need not to adhere the 'View Settings' of the UI in the generic grid component. The view settings are at UI layer and hence the export is done from the API layer, so the system cannot adhere the UI layer settings.