PSA had problem

[Former Member]

Hi experts,

I have CSV file to load example data as below. I changed QTY to QUAN with UNIT Q_UNIT type and S_PRICE to CURR with unit S_UNIT.

I activated it and go to next tab to read Preview Data as below. I don't know why S_PRICE loaded as below.  It has "," instead of "." for S_PRICE("1.21"  load to "1,21"). You can see the difference from the Screen shot above and below. Can anyone explain why? Much appriciate if you can give a answer.

[former_member188080]

Hi,

If say you are receiving the file from one particular country or say your development is done is carried out in one particlar country there is a possibility that this issue will occur due to incorrect regional and language setting..

so in control panel ------ regional and language setting ... change the format as per country and you will see the change..

else you have to delete and recreate the datasource newly..

Thanks and regards

Kiran

[Former Member]

Hi Kiran,

I create a new CSV flat file but the result is still the same. I can get the correct result if I change the S_PRICE type "CUKY" instead of "CURR".  I don't know why? The problem is CUKY should be for currency unit like USD. CURR is for currency amount like 4.99. Am I correct?

[Former Member]

Hi Eric,

You can change this settings at Data Source level. We will have Setting for Thousand and Decimal Separator.

I think at present it will be like thousand separator -- . and decimal separator -- ,.

you change this to thousand separator -- , and decimal separator -- .

Hope it helps

Regards,

Venkatesh

[Former Member]

Hi Venkatesh,

Do you know where I can change the setting in Datasource level? I click all the tab for datasouce and can't find the place to change the setting.

Thank you very much for your reply.

Eric

[Former Member]

Hi Eric,

This can be done from T/A-SPRO

Better way is open SPRO and search with key FLAT. You will be guided to that. There settings can be changed accordingly.

Regards

Chandu

[Former Member]

Hi Chandu,

I got the place but the default setting for Dec. point separator is OK (".") and not ",".  I still don't understand it happen like that.

[Former Member]

Check the settings in Control Panel

Control Panel -> Regional and language settings -> Customize this format

Change the settings accordingly

[Former Member]

Hi Chandra,

This is default setting in my Control panel setting. The Decimal setting is ".". What should I change?

The