search cancel

CSV Export with numeric ID fields, does not export the leading zeros

book

Article ID: 256654

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

When you export to CSV where the IDs are numeric and has leading zeros (ex: Auto-number with just numeric values), the CSV Export doesn't export the leading zeros.  Because of this issue, it impacts CSV Import because the IDs do not match hence it creates a new record on import vs. updating the existing record.

Steps to Reproduce: 

  1. Create a Custom Master Object (CMO) where the ID is auto-numbered, where the Type of Segment=Numeric Counter 
  2. Create some records for the CMO created in step #1 (Notice that the ID has leading zeros) 
  3. Export to CSV 

Expected Results: The autonumber field is a string field so if there are leading zeros they should appear. 

Actual Results: The leading zeros are stripped because the value is being interpreted as a number instead of a string field. 

Workaround: There are alternatives such as adding a text character or string as part of the autonumber scheme, but that won't change the existing ID values that look like numbers. For existing values, the user would have to manually update the data in the output file before using it to do the Import action to ensure the existing records get updated instead of new records being created. 

Autonumber definition:

Export to CSV output: 

 

Environment

Release 16.1.0 

Cause

DE67827  

Resolution

Targeted Fix for Release 16.1.1 

Additional Information

The Import from CSV {Beta} is a new capability for Custom Master Objects introduced in Release 16.1.0 

Attachments