Home › Forums › Import Export PowerTool › Customer import

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • Ted JohnstonTed Johnston
      June 6, 2023 at 2:57 pm
      Post count: 5
      #9589

      I’m trying to import customers exported from NAV.

      The field validation is helpful as a few field names have changed. I updated my file.

      Now, when I try to import to table 18 with all the options set to yes, I receive the following error (copied details from BC).

       

      If requesting support, please provide the following details to help troubleshooting:

      An item with the same key has already been added.

      Internal session ID:
      15ab0f90-ab57-4e9d-bc72-915095eaae37

      Application Insights session ID:
      e6c4a523-5054-4e70-9a0d-1a051b6eb42b

      Client activity id:
      6d14c4cb-9363-45b0-8348-01c78b1ea18d

      Time stamp on error:
      2023-06-06T21:54:45.0213753Z

      AL call stack:
      “IWX IEPT Imp. Exp. XMLPort”(XmlPort 23067855).getFieldNames line 62 – Import Export PowerTool by Insight Works
      “IWX IEPT Imp. Exp. XMLPort”(XmlPort 23067855).doAfterImportRecord line 8 – Import Export PowerTool by Insight Works
      “IWX IEPT Imp. Exp. XMLPort”(XmlPort 23067855).”Integer – OnBeforeInsertRecord”(Trigger) line 10 – Import Export PowerTool by Insight Works
      “IWX IEPT Universal Imp. Exp.”(Page 23067856).doImport line 17 – Import Export PowerTool by Insight Works
      “IWX IEPT Universal Imp. Exp.”(Page 23067856).”acImport – OnAction”(Trigger) line 2 – Import Export PowerTool by Insight Works

      Ted JohnstonTed Johnston
        June 7, 2023 at 11:46 am
        Post count: 5
        #9598

        More info- Company is in a sandbox in current SaaS BC.

        Cut the import down to just two records, same error so I know there is not a duplicate in the data.

        Turned off Do Two step, same error.

        Turned off the RunOnModify trigger, same error.

         

         

        Insight Works
          June 7, 2023 at 4:15 pm
          Post count: 6
          #9602

          It may be a sub-table with duplicate data. If the validation triggers are enabled (field and record), it’s possible BC is trying to create new, conflicting data. You can try disabling that to see if it helps. If not, if you can provide a sample of the data, either here or to our support department we can have a look at the possible cause.

          Ted JohnstonTed Johnston
            June 8, 2023 at 7:41 am
            Post count: 5
            #9606

            Thanks.

            This is a new sandbox with a new company so the likelihood of a duplicate is small.

            Who do I send a data sample to? I would rather not post it here.

          • Author
            Posts
          Viewing 4 posts - 1 through 4 (of 4 total)
          • You must be logged in to reply to this topic.