Excel Import fails before Parsing the decimal value

0
Hi Experts,   When I am trying to import the decimal value with $123,000.00 .it is failing before  parsing the decimal value. without the dollar symbol($)it is parsing and successfully importing.    Previously it is working fine with the "$" values.   Is the mendix ExcelImporter.StartImportByTemplate itself preventing the decimal value with $?   How to fix this issue ?   Thanks in advance 
asked
2 answers
0

Hi,

 

Depending if your Excel is only showing the $ and is a decimal field (Check in Excel) or it looks like a Decimal, but is a Text =string. 

 

image.png

 

image.png

 

If you can't calculate in Excel, it is a string

image.png

 

When it is a string, use a parsing Microflow. https://docs.mendix.com/appstore/modules/excel-importer/#parse-with

 

With the String Functions https://docs.mendix.com/refguide/string-function-calls/, you can clean up the string and parse it using https://docs.mendix.com/refguide/parse-and-format-decimal-function-calls/#parseDecimal

 

Go Make IT

answered
0

HI Bright Amalraj,

 You have to change your attribute value decimal to string in your domain model,

Then it will work fine.

answered