The summary which is displayed after importing identifies the number of records imported, skipped, or if any had errors or warnings. A record is a collection of information in your company file, like a customer, a sale transaction, an inventory item, etc.
Errors | Something is wrong with a record so it couldn't be imported. | Warnings | A record was imported but might need attention. For example, a supplier's bank account details were imported but the bank BSB wasn't recognised, so it was ignored. | Skipped | These records haven't been imported, usually because you selected to reject duplicate records during the import. |
UI Text Box |
---|
| Don't match the Record ID field: When importing, don't match the Record ID field unless you're importing data from the same company file.
|
Check your import log fileAn import log file is created after the import which provides details of any import issues. There are too many error and warning codes to list them all here, but the import log file has all the info you need. The import summary window shows where you'll find your import log file. Typically it's saved in the same location as your company file:
UI Text Box |
---|
| If you stop the import before it's finished, the import log file won't be created. You can use Windows Explorer to find your import log file. The easiest way to open Windows Explorer is to simultaneously press the Windows and E keys on your keyboard (the Windows key is between the Ctrl and Alt keys). On a Mac, use Finder. Double-click the import log file to open it in a text editor, such as Notepad or Microsoft Word. |
Understanding your import log fileHere's an example import log file created after importing inventory items, and a description of the contents.
Each import is different, so each import log file is different - so don't worry if yours doesn't look like ours! 1. | The number of errors, warnings and skipped records in your import. This info is also displayed after your import. Depending on your software version, this information might appear at the bottom of your import log file. | 2. | A summary of the errors and warnings. Each error and warning has a code and description. So in our example "Error -9: Duplicate Item Number" means the import file contained an item number that was already in your company file. "Warning 61: Asset Account not found, account ignored" means the item was imported but it was linked to an Asset Account that wasn't in your company file. So in this case the item was imported, but the unknown Asset Account number wasn't. Depending on your software version, this summary information might appear at the bottom of your import log file. | 3. | The records with errors or warnings. Each line is a single record, and the line will begin with the error or warning code (as listed in the summary above). So in our example, the first line starts with "-9" meaning this record contains a duplicate item number. |
There's too many error and warning codes to describe them all here, but everything you need is in the import log. Check your import log to determine what's caused an error or warning. Then you can fix it by either: - modifying the information in the import file then reimporting it, or
- modifying the information in the original source software, then exporting it again ready for importing into your company file.
If you're still stuck (or just plain confused!), post the details of your import issue on the Community Forum - there's hundreds of MYOB experts who'll be happy to assist. Not registered to post on the Forum? Not a problem - registering is free, quick and easy. |