configuration changes in Console

[Former Member]

Hi,

I have a field having values separated with a ","for every 1000.

I do not want to have this. For example:

Length - 1000,00.00 WRONG

I want it to be like Length - 100000.00

We are getting the data from the client system for Length as 100000.00.

Can anyone in the forum suggest and help me to fix this issue.

I think we need to do this configurational change in the console.

I have already done the configurational change in data manager.

BR

SK

[Former Member · Accepted solution]

When you want to syndicate to a target system which does not accept the thousand separator, you can go to the tab "map properties" and set the delimiter to "none". All numbers sent will then have this format. If you do have a "mixed" requirement, format the field in the target schema as string and set the normalization on the required field in tab "destination items". I would leave in the data manager the default format - it's not relevant for the target/source system.

[Former Member · Accepted solution]

Hi Missale,

As you said i have already changed theNumeric 1000 separator to None. But in the preview i am still finding the same problem Having the "," for the values like length - 1,235.00 .But the requirement is to have Length - 1235.00 .

BR

SK

[Former Member · Accepted solution]

Hi Missale,

Now it is solved.

BR

SK

[former_member182007]

Hi,

I have a field having values separated with a ","for every 1000.

I do not want to have this. For example:

Length - 1000,00.00 WRONG

I want it to be like Length - 100000.00

We are getting the data from the client system for Length as 100000.00.

Can anyone in the forum suggest and help me to fix this issue.

I think we need to do this configurational change in the console.

Go in DM

Configuration OptionFormats- Deals in separator and save it.

Hope it help.

BR

Deepak

Edited by: Deepak Gupta on Jul 25, 2008 12:56 PM

[Former Member]

Hi Deepak,

As i had told before that i had done the configuration change in the data manager.But then also in the syndicator i was finding the fields with values having the separator. But again we need to change the setting in the Map properties to None. Then also i shall allocate points to all for the prompt reply :-).

BR

SK

[Former Member]

Hi Deepak,

I have changed the configuration in the data manager. But when i am syndicating the records then i am not able to find the change.

BR

SK

[Former Member]

Hi,

U have to only remove the thousand separator option in data manager configuration tab-->options.

There is not any option in MDM Console for this.

Rgds

ankit

[Former Member]

Hi Susil,

Your requirement is like u want to remove the seperator ,.

So u want the lenght 1000,00.00 to be like 100000.00

For this you do not need to do any settings in console.

In Data Manager go to the configuration options.

Click on formats.

Select none for currency 000s seperator.

Another option can be in Import Manager just replace the field value seperator , with a blank space.

Hope it helps.

Regards,

Minaz