Leading zeros are getting removed while doing a dataload using inputmpas/datasource.
Article ID: KB0070668
Updated On:
| Products | Versions |
|---|---|
| TIBCO MDM | 9.2.0,9.3.0,9.3.1,10.0.0,11.0.0 |
Description
The leading zeros are eliminated during dataload/import records using inputmaps. For example, 000012 is there in the csv, but the repository only shows 12.(Refer attached records_withoutLeadingZero.png under images.zip)
Environment
All
Resolution
To resolve follow the below steps:
1.Go to MDM studio click on datasources, create a new datasource, change ID type from Integer to String(Refer attached screenshot datasource_studio.png under images.zip)
2.Then create inputmap for same datasource.
3.Depoly inputmap and datasource On UI
4.Go to UI MasterData-->View Data Source-->Check Attributes-->PRODUCTID Value should be String(Refer screenshot datasource_UI.png under images.zip)
5.Import records into repository. Then leading zeros will get in front of number.(refer record_withLeadingZeros.png under images.zip)
1.Go to MDM studio click on datasources, create a new datasource, change ID type from Integer to String(Refer attached screenshot datasource_studio.png under images.zip)
2.Then create inputmap for same datasource.
3.Depoly inputmap and datasource On UI
4.Go to UI MasterData-->View Data Source-->Check Attributes-->PRODUCTID Value should be String(Refer screenshot datasource_UI.png under images.zip)
5.Import records into repository. Then leading zeros will get in front of number.(refer record_withLeadingZeros.png under images.zip)
Issue/Introduction
While doing the dataload/import records using inputmpas then leading zeros are getting removed.
Additional Information
Leading zeros, zeros, import, MDMUI
Feedback
Yes
No
Powered by
