Skip to content

MYOB Business - Importing and exporting data - Import error log

An import log is created at the end of the import process. It's a text file that details any issues with the import, and there's a link to it from the conclusion step of the Import and Export Assistant.

Example import conclusion window

If you stop the import before it's finished the import log won't be created. The results of the import will be summarised in the Conclusion step of the Import and Export Assistant window.

Error means a record isn't imported because there is something wrong with it. For example the format of the Account Number must be numeric.

Warning means a record is imported but might need attention. For example the Card ID record was not unique and it was substituted.

Skipped means a record isn't imported, usually because you selected to reject the record if it was a duplicate.

If you closed this window you can find the Importlog.txt file at C:\Users\<Username>\Documents\MYOB\AccountRight\Current>. The path changes based on who performed the import.

You can then open the Import log to investigate what went wrong.

What does the import log tell you?

The import log has all the information you need and helps you troubleshoot the cause of the errors or warnings. As data contained in each import is different, so to will each import log. Here's an example.

The import log

The import log has the following details and each record that is being referred to is a collection of information in your company file. For example all the fields that are part of the Account Number record.

1

The number of errors, warnings and skipped records in your import.

2

Additional information regarding each error and warning.

3

Each record beginning with the error or warning code listed in the above section, to help you identify the problem with it.

By reviewing the error and warning code in the Import log it will help you narrow down the record that needs to be corrected. Most errors will always occur because of the formatting or structure of the fields, but there could be multiple factors which are causing it. The description provided may be generic as opposed to specific, so keep this in mind when you're troubleshooting the file:

For example Error "-3 - Account Number must be numeric" tells you there's a problem with the Account Number column, so you can narrow it down to this piece of information. But if the account number in your file is numeric then you should also check these factors about that field.

Format

If the account number is entered as 'xx-xxx' where the program only accepts 'x-xxxx' then it's the wrong format. You can also try removing the hyphen and import using the 'xxxxx' format.

Length

The program only accepts a five digit number, yet the field contains more.

Invalid Characters

There are quotations around the figure which are considered to be invalid characters.

Well that's a start to troubleshooting. If you need more help then try the MYOB Community Forum.

Learn more about the structure and format of export/import files, by exporting the same type of information from Clearwater, the sample company file. You can then use that export file as your template. For more information see Importing and exporting tips.

Once you work out the issues, modify the information, in either the export file itself, or the original source software then export it again and reimport it.

Import log FAQs