Community
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Subscribe

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.

0 Likes

Know the answer?

Help others by sharing your knowledge.

Answer

Need more details?

Request clarification before answering.

Show replies
Show replies
View Entire Topic
former_member188080
Active Contributor
‎2012 Jul 02 11:27 AM
0 Likes

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

Show replies
Show replies
Former Member
‎2012 Jul 02 2:45 PM
0 Likes

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?

Ask a Question