[jira] Created: (OFBIZ-2444) webtools import errors when a currency specific value includes a thousands delimiter USD

[Nicolas Malin (Jira)]

webtools import errors when a currency specific value includes a thousands delimiter USD
----------------------------------------------------------------------------------------

                 Key: OFBIZ-2444
                 URL: https://issues.apache.org/jira/browse/OFBIZ-2444
             Project: OFBiz
          Issue Type: Bug
          Components: framework
    Affects Versions: Release Branch 9.04, SVN trunk
            Reporter: BJ Freeman
             Fix For: Release Branch 9.04, SVN trunk


and entity field defined as
        <field name="retailprice" type="currency-precise"></field>
when imported with a comma for thousands


        <retailprice>1,199.95</retailprice>

gives this error


The Following Errors Occurred:

ERROR: Error parsing entity xml file: java.lang.NumberFormatException


--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-2444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12707633#action_12707633 ]

BJ Freeman commented on OFBIZ-2444:
-----------------------------------

So the question is for a solution.
do require all input to be deviod of delimiters, other than the decimal place so no change to code.
or
do we add functionality to replace the comma  before sending the string to the numberformatter.

I would prefer a solution more like the second one. also remove currency symbols. as part of the string operations.

> webtools import errors when a currency specific value includes a thousands delimiter USD
> ----------------------------------------------------------------------------------------
>
>                 Key: OFBIZ-2444
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-2444
>             Project: OFBiz
>          Issue Type: Bug
>          Components: framework
>    Affects Versions: Release Branch 9.04, SVN trunk
>            Reporter: BJ Freeman
>             Fix For: Release Branch 9.04, SVN trunk
>
>
> and entity field defined as
>         <field name="retailprice" type="currency-precise"></field>
> when imported with a comma for thousands
>         <retailprice>1,199.95</retailprice>
> gives this error
> The Following Errors Occurred:
> ERROR: Error parsing entity xml file: java.lang.NumberFormatException

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.