We have make a functionality in which, when we upload a csv of customer records from data import tool it create customer and sales order respectively. Now our requirement is to upload a csv which has 1000000 (Around Ten Lakh) customer records. It is not possible through data import tool, is there any other way so i can create both customer and sales order respctively for 1000000 records.
Regards
Rohit
–
Note:
If you are posting an issue,
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
The limitation of 5000 records was put into place so that a lot of uncommitted changes do not pile up in mysql and cause it to crash.
To overcome this, you should break the million records into batches of 5000 and try to insert them batch wise. In ver 4, you could use celery to create queued tasks.
We have make a functionality in which, when we upload a csv of customer records from data import tool it create customer and sales order respectively. Now our requirement is to upload a csv which has 1000000 (Around Ten Lakh) customer records. It is not possible through data import tool, is there any other way so i can create both customer and sales order respctively for 1000000 records.
Regards
Rohit
–
Note:
If you are posting an issue,
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.
We should be able to replicate it at our end. So please give us as much information as you can. Please see it from the point of view of the person receiving the communication.
For sending images, use http://imgur.com or other similar services. Do not send images as attachments. Links are good. Same goes for any file you are going to send.
End of Note
—
You received this message because you are subscribed to the Google Groups "ERPNext Developer Forum" group.