Forum Discussion

AlanF's avatar
AlanF
Experienced User
5 years ago

Import - Receive Payments - Error 0: Unexpected import error - Sequence contains no matching element

Hi All,   I am having trouble importing a receive payments file.   I am getting:   Error 0: Unexpected import error - Sequence contains no matching element   I have attached the log file, and...
  • Komal_S's avatar
    Komal_S
    5 years ago

    Hi AlanF 

     

    I needed some time to find out the reason for why it was happening and it appers that you're getting this error because there needs to be a blank line between two lines of separate invoices for the import to work. I have attached a template so you can try importing it again on your end. Please note that the template I have attached is separated by tabs, instead of commas. 

     

    Please let me know if you still get the same error. 

AlanF's avatar
AlanF
Experienced User
5 years ago

{Bump}

 

:-)

  • Komal_S's avatar
    Komal_S
    MYOB Staff
    5 years ago

    Hi AlanF 

    When you import this file, could you please also attach the screenshot of Match fields window from the Import/Export Assistant so we can figure out how the import fields are matched against the fields in the software. Also, is the import failing for all the receive payment transactions or only some of them. 

    • AlanF's avatar
      AlanF
      Experienced User
      5 years ago

      Hi Komal_S,

       

      I have attached a screenshot of the 'match fields' screen - it all looks okay to me, but perhaps I am missing something?

       

      The import is failing for the single transaction that I posted above (see the attached import file, and associated log file) - I didn't see any point in trying to do a full batch until I can get one working at least.  This is the first time I have tried importing 'received payments'.

       

      Thanks for your assistance - very much appreciated!

       

      Alan.

       

       

       

      • Komal_S's avatar
        Komal_S
        MYOB Staff
        5 years ago

        Hi AlanF 


        Upon investigation, it has been found out that " " in the memo are causing the import to fail. If you remove these symbols, the import should work fine. However, please ensure that you choose Add the import data in the import export assistant and backup your file to avoid the risk of importing duplicates. This is because choosing Reject the import data would also give "Error 0: Unexpected import error - Sequence contains no matching element":

         

         

        I have attached sample import file for your reference. Please let me know how you go on. 

Looking for something else?

Search the Community Forum for answers or find your topic and get the conversation started!

Community home

Dig into MYOB Academy for free courses, learning paths and live events to help build your business with MYOB.