OFBiz
  1. OFBiz
  2. OFBIZ-2444

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

    Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: Release Branch 09.04, SVN trunk
    • Component/s: framework
    • Labels:
      None

      Description

      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

        Activity

        Hide
        Jacques Le Roux added a comment -

        BJ, if you provide a patch why not, but beware with locale settings. I'd rather close and forget it (ie use decimal separator only). If you think so please close

        Show
        Jacques Le Roux added a comment - BJ, if you provide a patch why not, but beware with locale settings. I'd rather close and forget it (ie use decimal separator only). If you think so please close
        Gavin made changes -
        Field Original Value New Value
        Workflow jira [ 12462967 ] OFbiz Workflow [ 12506844 ]
        Hide
        BJ Freeman added a comment -

        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.

        Show
        BJ Freeman added a comment - 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.
        BJ Freeman created issue -

          People

          • Assignee:
            Unassigned
            Reporter:
            BJ Freeman
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:

              Development