Import Error Dictionary
When you import files into PaymentNet, two general types of errors can occur:
File failures are serious errors that cause the entire import file to fail and are indicated by an import status of "Failed." File failures are generally caused by not having the correct header items in Row 1 of an import file or by having blank rows within or at the end of the file.
Line item failures can be caused by numerous things but are most common with bad data in the row that failed. If a line item error occurs after an import, the import status is “Successful with errors.” You can view the line item errors on the Import Error List screen.
After fixing the errors, you can import the same file into PaymentNet again as long as you understand the results.
If you are adding lines, the lines that were imported successfully the first time will return an error when you re-import the file because these items already exist. Only fixed items, and any new items that have subsequently been added to the file, will be successfully imported.
If you are deleting lines, the lines that were successfully deleted the first time will return an error because these items no longer exist. Only rows that were fixed will be deleted.
If you are performing an update, new errors should not occur when you re-import the file in its entirety. All rows will be updated, even if the information has not changed.
Note:If you do not want to receive the additional line item errors, you can create a new file that contains only the items you fixed and import that file. This may make it easier for you to find any new errors that occur.
Understanding the import process in general and the requirements of each import file type is the best way to avoid import file errors. To review the general guidelines for a successful import, see General Import File Tips. Requirements for each import file type can be found in the topics in the Import File Layouts section.
To help you troubleshoot and resolve errors that occur during an import, you can use the Import Error Dictionary. The Import Error Dictionary is an Excel spreadsheet that provides a list of import errors by import file type, including possible causes and resolutions, along with detailed explanations of the possible errors and suggestions for how you might fix them.
For further help resolving import errors, contact your J.P. Morgan implementation or relationship management team.