Skip to main content
Question

[FSM] addres_ID and contact_sequence field - import data with leading zeros


Forum|alt.badge.img+3

Hello,

we have a client who wants their ADDRESS_ID and CONTACT.CONTACT_SEQUENCE to always be 10 digits, for example, Address ID: 0012345678.

When we import the customer's current sample data, the leading zeros in Address ID (e.g., 00 in 0012345678) are not displayed. We only see 12345678.

In FSM, both of these fields are of the DECIMAL data type in the FSM Metadata, and it is not possible to override them with custom metadata.

Apart from using a user_def field with a column type of STRING, are there any other options?

Thank you in advance for your kind help.

 

Forum|alt.badge.img+9
  • Hero (Employee)
  • August 23, 2023

@ChingL ,

Hi, 

You are correct those fields can not be altered to allow leading zero’s. If leading zero’s are needed you need to go the route of user defs.

Regards,

Morris


SAMLK
Hero (Partner)
Forum|alt.badge.img+13
  • Hero (Partner)
  • August 28, 2023

Hi @ChingL ,

As both of you mentioned, we cannot format the decimal type values with the expected output as the leading zeros are automatically eliminated by the application itself. You will require to setup this on a string type variable.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings