Uploaded image for project: 'CFA MX '
  1. CFA MX
  2. CFAMX-11800

All - INTL - Support special characters in Imports/Exports

    Details

    • INF Reference Number:
      INF-12261

      Description

      As InFORM expands into new markets, with new languages, ensure that Imports and Exports support special characters as needed.

      MX Jira tickets that were for Special characters in Exports

      Notes from Will Englefield

      I did some testing of this processing in the testing environment.

      • Importing a UOM file resulted in the special characters being replaced by ?
      • I then manually added Units, and a UOM in thru the UI
      • Importing the Inventory Item file, with the name of the UOM (as entered thru the UI), the file processed, but the UOM's were not populated
      • Importing the Vendor Item file, with the name of the UOM (as entered thru the UI), the file processed, and the UOM was not populated

      Notes/data

      SQL for Testing

      --CFA Testing

      select PurchaseUnit, StocktakeUnit1, StocktakeUnit2, InventoryUnit, StocktakeUnit4, * from tbItem with(nolock)
      where itemid = 4128

      select StocktakeUnit1ID,ReportingUnitID,StocktakeUnit2ID,StocktakeUnit4ID, * from tbEntityItem with(nolock)
      where itemid = 4128
      and EntityID = 62

      select PurchaseUnitID, InnerUnitID, * from tbVendorItem with(nolock)
      where VendorItemID = 56847

      Results of Import/SQL

        Attachments

        1. screenshot-1.png
          screenshot-1.png
          115 kB
        2. screenshot-2.png
          screenshot-2.png
          156 kB
        3. screenshot-3.png
          screenshot-3.png
          168 kB
        4. InventoryItems_20210125_01.csv
          0.9 kB
        5. InventoryItems-Trace_01-25-2021_130113.Log
          0.9 kB
        6. VENDORITEM_20210125_01.csv
          0.6 kB
        7. VENDORITEM-Trace_20210125_130706.log
          0.8 kB
        8. screenshot-4.png
          screenshot-4.png
          69 kB

          Issue Links

            Activity

              People

              • Assignee:
                will.englefield Will Englefield (Inactive)
                Reporter:
                will.englefield Will Englefield (Inactive)
              • Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  PagerDuty

                  Error rendering 'com.pagerduty.jira-server-plugin:PagerDuty'. Please contact your Jira administrators.