ERPNext Foundation ERPNext Cloud User Manual Blog Discuss Frappé* Donate

Data missing after successful import

import
database

#1

Doing a fairly large customer import via the bench tool.

The initial size was around 8000 customers, but I also tried smaller files (<4000).

Most are imported properly, but a few of the items are missing even though they are listed as importing correctly. For example:

cust_import2.log:Inserted row for "Customer: DEMO COUNTY CLERK OF CIRCUIT COURT"Document successfully saved

But the customer is not actually in ERPNext after the import.


#2

Try looking for a pattern with regards to what might have been missed. Lets say you have 4000 records create 10 batches of 400 each and try to upload it. Doing this way you may have a theory on what could be causing data importation to fail. Most likely it might either have to do:

  1. Data formatting issues
  2. Missing mandatory fields

Give the above approach a go we might have more information to debug the issue

Here are few links to posts on related topics that might help

  1. Import Log. Import Failed. Please correct the format of the file and import again
  2. Data Import Error - Please correct the format of the file and import again

You might also want to look and share import logs, that should also help determine the issue


#3

Is it possible that the import was successful, but the/this user doesn’t have permissions to view them?


#4

Just as an update, I never got this to work, but I was able to do the import via the API instead and it worked.

Is this behavior something I should file a bug for?