Forum Discussion

JessArmstrong's avatar
JessArmstrong
Contributing User
4 years ago
Solved

Importing sales item data error -90

Hi there, I have followed your instructions to export data (Sales - Items) to a .txt template and have then edited the date only, saved as .txt and attempted to import and get the following error mes...
  • Mike_James's avatar
    Mike_James
    4 years ago

    Hi JessArmstrong , welcome to the forum. Are you able to attach the file you are importing (provided the content is not sensitive), and the log file?

     

    Does the text file being imported have {} on line 1, no blank line between the header line and the first invoice, and no blank lines at the end?

Mike_James's avatar
Mike_James
Ultimate Partner

Hi JessArmstrong , the Braces should be on line 1, above the column headings.

JessArmstrong's avatar
JessArmstrong
Contributing User
4 years ago

I tried that after re-reading your response.  MYOB then doesn't recognising the column headings to match, refer enclosed.  Note, I have altered the customer name for privacy purposes.  I think the {} have to come between the header and first line of data - is that correct?

 

 

 

  • Mike_James's avatar
    Mike_James
    Ultimate Partner
    4 years ago

    Hi JessArmstrong , looks like an import into v19. Please remove the braces (delete the line), and try again.

     

    Braces tell MYOB the import file is formatted for Accountright Live. 

    • JessArmstrong's avatar
      JessArmstrong
      Contributing User
      4 years ago

      Success, thank you!  Had to also remove invoice number as this duplicated.