Log in to AnswerLog in to Follow
UserImage.jpg
Carlos Xavier
22Views
4Comments
[CSVUtil] LoadCSV2RecordList problem with decimals.
Question
Forge
Traditional Web
csvutil
Service icon
CSVUtil
Forge component by Wei Zhu
Application Type
Traditional Web

Hi,

when i use the action LoadCSV2RecordList I have a problem with decimal numbers. but this problem only happens in QA server in DEV server works correctly.

For example: 

if in csv I have a number "1,5" when it is exported the comma  is ignored and export "15".

will it be some configuration at the server level?


thanks

0
0
26 Oct 2021

Hello @Carlos Xavier 

My 2 cents as a user of this component - I am not aware of any server level configurations that could cause such an outcome over different environments. If it is the same version of the code in both environments that is quite strange.

Have you compared the properties for your LoadCSV2RecordList action in both the environments just to eliminate that as a root cause?

Regards,

AJ

0
0
27 Oct 2021

Hi @AJ. 

the properties are exactly the same, that is, the code is the same in both environments. It's very strange.

Regards

0
0
27 Oct 2021

Replying to Carlos Xavier's comment on 27 Oct 2021 21:22:49

You stated that a number "1,5" in the CSV gets exported as "15". Where is the value being exported to? Is that in the database entity?

2. Is there any information you could attach here, for e.g. screenshots of the exported values, logic, or screenshots comparing the dev and test exported values? Basically that may help recreate the issue.

Thanks,

AJ

0
0
28 Oct 2021

Replying to AJ.'s comment on 28 Oct 2021 01:52:00

Hi @AJ. 

file I import with decimals:

the output sends the values without a comma to the structure


and the structure field is decimal


thanks,


0
0
28 Oct 2021
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.