Data Import Starts but does not Finish

Hi all,

We are having an issue where we have a stock entry ready to import using the data import tool, all fields have the “green light” icon. When we click Start Import, the button goes disabled as if it’s working, but then nothing happens and the import does not resolve. The Start Import button does go back to enabled state after a few seconds, but the document stays in “Not Started” status. Any ideas?

Did you import CSV or XLS? - I have had cases where there are “phantom” cells thousands of rows/columns along that make the system think there is more data which is tries to work with unsuccessfully. Best to use CSV as it is easier to manage

I’m using a CSV with only 21 rows of data, and it’s worked just fine up until this point. I also tried re-downloading the file from our database to upload in, to double check that it’s not an issue with the file, and it still isn’t going anywhere.

OK - not sure why that’s happening. The only thing I can think of is that something that’s referenced in the CSV data is missing on the main system eg. An item that goes into a non-existing category could possibly cause this “hanging”

That’s a good thought, @trentmu – I just double checked that all the items in the CSV exist in our system, so it seems it’s not that. I wish it would at least throw me an error; I get nothing in the UI or in the console while it’s “processing”.

Check the browser’s JS console and see if there is any error traceback on clicking Start Import.

Some times, just reloading the page works.

@kennethsequeira Sorry Kenneth, no relevant errors coming up in the ERPNext UI or in the console; you can see the Start Import button is disabled after I’ve clicked it, but it reverts to “enabled” state after about 3 seconds and nothing actually happens.

I’m having same problem! Did you ever resolve?

Is your scheduler running?

I think it needs to be running to get the import to start.

BKM

It happens for almost every import for me (v12), no matter how many records it has. But in fact, import is finished and after page reload displays success.

I sent a support ticket in and they told me I had some background processes running that were stopping it from being able to submit, then stopped the processes, and yes, I am now able to submit!

I did an update and seems to be working now. Is performing as martin42 above says. Nothing happens but then works…

Thanks.

Hello everyone,

I have the same problem with importing data in items from .xls file. When I click Start Import, the button goes disabled as if it’s working, but then nothing happens and the import does not resolve.
Welihayes could you let me know how to stop processes and which ones I have to stop.

ERPNext: v12.18.0 (version-12)
Frappe Framework: v12.15.0 (version-12)

Same issue here, nothing happened after pressing the bottom of the “start import” ! (Start import disappear and nothing happen)
use svc, refresh many times, logout, log in, restart server, nothing, the same problem.
The most important part of ERP must be import and export data very very smoothly and easy ! it looks like ERPNEXT is not smooth and strong enough ! so much hassle!

.xls files are not ideal. I have had instances where the file has a hidden cell with content which makes the system think there are millions of cells (eg. if you added colour or formatting to a whole column/row).
The SAFEST/easiest import is a .CSV file - which also doesn’t mess around with date formatting

I am having the same issue. Tried xls and csv. Even after downloading the csv template containing some manually created bank transactions, then deleting bank transaction and reimporting the transactions using the template file didn’t work. Indicating this is not a problem with my file.

Anyone has an idea? If this doesn’t work I will have to leave ERPNext and move to another system.
Can the following be the problem?

Blockquote
$ ps aux | grep bench
erpnext 3010 0.0 0.0 2608 540 ? Ss Dec12 0:00 /bin/sh -c bench worker --queue long 1>> logs/worker.log 2>> logs/worker.error.log
erpnext 3012 0.0 0.0 2608 476 ? Ss Dec12 0:00 /bin/sh -c bench worker --queue short 1>> logs/worker.log 2>> logs/worker.error.log
erpnext 3014 0.1 0.7 120308 29708 ? S Dec12 11:47 /opt/bench/erpnext/env/bin/python -m frappe.utils.bench_helper frappe worker --queue long
erpnext 3019 0.1 0.7 119904 29832 ? S Dec12 11:48 /opt/bench/erpnext/env/bin/python -m frappe.utils.bench_helper frappe worker --queue short
erpnext 3021 0.0 0.0 2608 540 ? Ss Dec12 0:00 /bin/sh -c bench worker --queue default 1>> logs/worker.log 2>> logs/worker.error.log
erpnext 3025 0.1 0.7 120288 30324 ? S Dec12 16:01 /opt/bench/erpnext/env/bin/python -m frappe.utils.bench_helper frappe worker --queue default
erpnext 57916 0.0 0.0 2608 544 ? Ss Dec19 0:00 /bin/sh -c bench serve --port 8000
erpnext 57926 0.0 1.2 96412 51404 ? S Dec19 0:01 /opt/bench/erpnext/env/bin/python -m frappe.utils.bench_helper frappe serve --port 8000
erpnext 57934 0.0 0.0 2608 608 ? Ss Dec19 0:00 /bin/sh -c bench worker --queue short 1>> logs/worker.log 2>> logs/worker.error.log
erpnext 57936 0.0 0.0 2608 612 ? Ss Dec19 0:00 /bin/sh -c bench worker --queue long 1>> logs/worker.log 2>> logs/worker.error.log
erpnext 57937 0.0 0.0 2608 604 ? Ss Dec19 0:00 /bin/sh -c bench schedule
erpnext 57938 0.1 0.8 119664 34640 ? Sl Dec19 0:38 /opt/bench/erpnext/env/bin/python -m frappe.utils.bench_helper frappe worker --queue short
erpnext 57941 0.1 0.8 119808 35176 ? Sl Dec19 0:39 /opt/bench/erpnext/env/bin/python -m frappe.utils.bench_helper frappe worker --queue long
erpnext 57943 0.0 0.0 2608 612 ? Ss Dec19 0:00 /bin/sh -c bench worker --queue default 1>> logs/worker.log 2>> logs/worker.error.log
erpnext 57944 1.0 1.4 82876 57760 ? S Dec19 5:24 /opt/bench/erpnext/env/bin/python -m frappe.utils.bench_helper frappe schedule
erpnext 57958 0.1 0.8 119816 35080 ? Sl Dec19 0:44 /opt/bench/erpnext/env/bin/python -m frappe.utils.bench_helper frappe worker --queue default
erpnext 57995 9.7 5.8 827984 233812 ? Sl Dec19 50:14 /opt/bench/erpnext/env/bin/python -m frappe.utils.bench_helper frappe serve --port 8000
erpnext 58015 11.8 9.4 1123820 379296 ? SNl Dec19 61:10 /opt/bench/erpnext/apps/frappe/node_modules/esbuild/bin/esbuild --service=0.11.21 --ping
69927 0.0 0.0 6432 672 pts/2 S+ 00:05 0:00 grep --color=auto bench