Question

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

  • 23 August 2023
  • 2 replies
  • 28 views
C
Rank
Badge +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.

 

2 replies

M
Rank
Userlevel 2
Badge +6

@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
Rank
Userlevel 4
Badge +12

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.

https://www.linkedin.com/in/saranga-amaraweera-62418388

Reply


Terms & ConditionsCookie settings