search cancel

Leading Zeros In Modern Custom Object > Export To CSV and Import from CSV

book

Article ID: 256556

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Steps To Reproduce:

1.Set up autonumbering on custom object with leading zeros.

2. Set up a view with fields to export to CSV

3. Click Actions > Export To CSV and make sure to save it as a CSV file.

4. Review the CSV file with Notepad. Upon opening, the file needs be a CSV in content.


Expected: The leading zeroes should appear.

Actual: The leading zeroes do not appear.


If it does not appear, when importing back in, it will create new records and instead of treating it as an updated record, it will create a new row, as it treats the ID as a new unique record. 00120 vs 120

Curently, how can the list be updated or have records added?

Environment

Release : 16.1.0

Resolution

The Import From CSV will allow records to be updated and added/created.

Use the following example text file showing the CSV (comma-separated) with minimum fields:

"ID","Name","Created Date"
"code","name","createdDate"
"00001","A",2022-12-17
"00002","B",2022-12-18
"00003","C",2022-12-19
"00004","D",2022-12-20
"00005","E",2022-12-21
"00006","F",2022-12-22
"00007","G",2022-12-23
"00008","H",2022-12-24
"00009","I",2022-12-25
"00010","J",2022-12-26
"00011","K",2022-12-17
"00012","L",2022-12-18
"00013","M",2022-12-19
"00014","N",2022-12-20
"00015","O",2022-12-21
"00016","P",2022-12-22
"00017","Q",2022-12-23
"00018","R",2022-12-24
"00019","S",2022-12-25
"00020","T",2022-12-26
"00021","U",2022-12-27
"00022","V",2022-12-28
"00023","W",2022-12-29
"00024","X",2022-12-30
"00025","Y",2022-12-31
"00026","Z",2023-01-01

A. To update records, use the following sample:

"ID","Name","Created Date"
"code","name","createdDate"
"00001","Aa",2022-12-17
"00002","Bb",2022-12-18
"00003","Cc",2022-12-19
"00004","Dd",2022-12-20
"00005","Ee",2022-12-21
"00006","Ff",2022-12-22
"00007","Gg",2022-12-23
"00008","Hh",2022-12-24
"00009","Ii",2022-12-25
"00010","Jj",2022-12-26
"00011","Kk",2022-12-17
"00012","Ll",2022-12-18
"00013","Mm",2022-12-19
"00014","Nm",2022-12-20
"00015","Oo",2022-12-21
"00016","Pp",2022-12-22
"00017","Qq",2022-12-23
"00018","Rr",2022-12-24
"00019","Ss",2022-12-25
"00020","Tt",2022-12-26
"00021","Uu",2022-12-27
"00022","Vv",2022-12-28
"00023","Ww",2022-12-29
"00024","Xx",2022-12-30
"00025","Yy",2022-12-31
"00026","Zz",2023-01-01

B. To add records, use one ore more lines in the following sample:
,"Hello",2023-01-02
"","Hi",2023-01-03

Additional Information

Currently, leading zeroes are required, else a new record will be created.

The following sample will insert new records.

"ID","Name","Created Date"
"code","name","createdDate"
"1","Aa",2022-12-17
"2","Bb",2022-12-18
"3","Cc",2022-12-19

 

The following sample will update the records:
ID,Name,Created Date
code,name,createdDate
"00001","Aaa",2022-12-17
"00002","Bbb",2022-12-18
"00003","Ccc",2022-12-19

Although it can be used as a workaround, it does require time.


This is reported as DE67878/DE67827 and is resolved in 16.1.1.