Error importing item data

Hi ,

     I have imported around 20,000 items into the system. Now when I try to import more, it just shows uploading and sort of hangs over there. I waited maybe upto 20mins without any response. I was wondering what could be the issue. I run this on a 512 MB ram droplet on digital ocean . does it have anyhting to do with that ?




Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/52b49a92-ed59-4e66-9d63-cbd4bf4b8d4b%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.

On 02-Sep-2014, at 4:45 pm, Vivek <v2...@gmail.com> wrote:

Hi ,

     I have imported around 20,000 items into the system. Now when I try to import more, it just shows uploading and sort of hangs over there. I waited maybe upto 20mins without any response. I was wondering what could be the issue. I run this on a 512 MB ram droplet on digital ocean . does it have anyhting to do with that ?


Try importing fewer items in one sheet. Also check your JS console for any error trace.




Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/52b49a92-ed59-4e66-9d63-cbd4bf4b8d4b%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/D1CE101A-5370-4E78-A85C-45783DE6F209%40gmail.com.

    For more options, visit https://groups.google.com/d/optout.
Hi,

     As of now sets of 20 are working. Anything more shows a JSON.parse error on the console




On Tuesday, September 2, 2014 4:51:08 PM UTC+4, rushabh wrote:

On 02-Sep-2014, at 4:45 pm, Vivek <v2...@gmail.com> wrote:

Hi ,

     I have imported around 20,000 items into the system. Now when I try to import more, it just shows uploading and sort of hangs over there. I waited maybe upto 20mins without any response. I was wondering what could be the issue. I run this on a 512 MB ram droplet on digital ocean . does it have anyhting to do with that ?


Try importing fewer items in one sheet. Also check your JS console for any error trace.




Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/52b49a92-ed59-4e66-9d63-cbd4bf4b8d4b%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/65e8cde7-4740-42ef-bdc3-5d5ecaa6acce%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
Failed to load resource: the server responded with a status of 504 (Gateway Time-out) http://salehalsouqi.com/
  1. Uncaught SyntaxError: Unexpected token < frappe.min.js:300
    1. (anonymous function)frappe.min.js:300
    2. k.fireWithjquery.min.js:2
    3. (anonymous function)


Thats what comes up on the chrome console.




On Wednesday, September 3, 2014 3:51:44 PM UTC+4, Vivek wrote:
Hi,

     As of now sets of 20 are working. Anything more shows a JSON.parse error on the console




On Tuesday, September 2, 2014 4:51:08 PM UTC+4, rushabh wrote:

On 02-Sep-2014, at 4:45 pm, Vivek <v2...@gmail.com> wrote:

Hi ,

     I have imported around 20,000 items into the system. Now when I try to import more, it just shows uploading and sort of hangs over there. I waited maybe upto 20mins without any response. I was wondering what could be the issue. I run this on a 512 MB ram droplet on digital ocean . does it have anyhting to do with that ?


Try importing fewer items in one sheet. Also check your JS console for any error trace.




Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/52b49a92-ed59-4e66-9d63-cbd4bf4b8d4b%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/3d2fd5b7-9e98-461f-b57e-33a882566ce1%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
Failed to load resource: the server responded with a status of 504 (Gateway Time-out) http://salehalsouqi.com/
  1. Uncaught SyntaxError: Unexpected token < frappe.min.js:300
    1. (anonymous function)frappe.min.js:300
    2. k.fireWithjquery.min.js:2
    3. (anonymous function)






On Wednesday, September 3, 2014 3:51:44 PM UTC+4, Vivek wrote:
Hi,

     As of now sets of 20 are working. Anything more shows a JSON.parse error on the console




On Tuesday, September 2, 2014 4:51:08 PM UTC+4, rushabh wrote:

On 02-Sep-2014, at 4:45 pm, Vivek <v2...@gmail.com> wrote:

Hi ,

     I have imported around 20,000 items into the system. Now when I try to import more, it just shows uploading and sort of hangs over there. I waited maybe upto 20mins without any response. I was wondering what could be the issue. I run this on a 512 MB ram droplet on digital ocean . does it have anyhting to do with that ?


Try importing fewer items in one sheet. Also check your JS console for any error trace.




Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/52b49a92-ed59-4e66-9d63-cbd4bf4b8d4b%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/c321f756-dc3f-4b0a-90ff-b6d6092f7453%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
Check your server stats, when importing. 

Specially - mysql, run "show processlist" when your import seems stuck.

Difficult to guess why this happens. I don't think it has to do with the Item import.


On 03-Sep-2014, at 5:40 pm, Vivek <v2...@gmail.com> wrote:

Failed to load resource: the server responded with a status of 504 (Gateway Time-out) http://salehalsouqi.com/
  1. Uncaught SyntaxError: Unexpected token < frappe.min.js:300
    1. (anonymous function)frappe.min.js:300
    2. k.fireWithjquery.min.js:2
    3. (anonymous function)






On Wednesday, September 3, 2014 3:51:44 PM UTC+4, Vivek wrote:
Hi,

     As of now sets of 20 are working. Anything more shows a JSON.parse error on the console




On Tuesday, September 2, 2014 4:51:08 PM UTC+4, rushabh wrote:

On 02-Sep-2014, at 4:45 pm, Vivek <v2...@gmail.com> wrote:

Hi ,

     I have imported around 20,000 items into the system. Now when I try to import more, it just shows uploading and sort of hangs over there. I waited maybe upto 20mins without any response. I was wondering what could be the issue. I run this on a 512 MB ram droplet on digital ocean . does it have anyhting to do with that ? 


Try importing fewer items in one sheet. Also check your JS console for any error trace.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/52b49a92-ed59-4e66-9d63-cbd4bf4b8d4b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/c321f756-dc3f-4b0a-90ff-b6d6092f7453%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/FF3694E1-B189-4D3F-8E5F-0E46BD36D73B%40gmail.com.

    For more options, visit https://groups.google.com/d/optout.

   As I keep adding more items , the number of items I can import seems to be reducing. I had tried using a larger droplet with 2 CPUs and 2GB ram. Let me try again.






On Wednesday, September 3, 2014 5:02:12 PM UTC+4, rushabh wrote:
Check your server stats, when importing. 

Specially - mysql, run "show processlist" when your import seems stuck.

Difficult to guess why this happens. I don't think it has to do with the Item import.


On 03-Sep-2014, at 5:40 pm, Vivek <v2...@gmail.com> wrote:

Failed to load resource: the server responded with a status of 504 (Gateway Time-out) http://salehalsouqi.com/
  1. Uncaught SyntaxError: Unexpected token < frappe.min.js:300
    1. (anonymous function)frappe.min.js:300
    2. k.fireWithjquery.min.js:2
    3. (anonymous function)






On Wednesday, September 3, 2014 3:51:44 PM UTC+4, Vivek wrote:
Hi,

     As of now sets of 20 are working. Anything more shows a JSON.parse error on the console




On Tuesday, September 2, 2014 4:51:08 PM UTC+4, rushabh wrote:

On 02-Sep-2014, at 4:45 pm, Vivek <v2...@gmail.com> wrote:

Hi ,

     I have imported around 20,000 items into the system. Now when I try to import more, it just shows uploading and sort of hangs over there. I waited maybe upto 20mins without any response. I was wondering what could be the issue. I run this on a 512 MB ram droplet on digital ocean . does it have anyhting to do with that ? 


Try importing fewer items in one sheet. Also check your JS console for any error trace.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/52b49a92-ed59-4e66-9d63-cbd4bf4b8d4b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/c321f756-dc3f-4b0a-90ff-b6d6092f7453%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/dacbb16a-b918-4191-bab6-75de95861208%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
Vivek,

You should also check the output of the "Response" part of request via the network tab of developer console.

-Anand.


On Wed, Sep 3, 2014 at 6:49 PM, Vivek <v2…@gmail.com> wrote:


As I keep adding more items , the number of items I can import seems to be reducing. I had tried using a larger droplet with 2 CPUs and 2GB ram. Let me try again.







On Wednesday, September 3, 2014 5:02:12 PM UTC+4, rushabh wrote:

Check your server stats, when importing.


Specially - mysql, run “show processlist” when your import seems stuck.

Difficult to guess why this happens. I don’t think it has to do with the Item import.


On 03-Sep-2014, at 5:40 pm, Vivek <v2...@gmail.com> wrote:

Failed to load resource: the server responded with a status of 504 (Gateway Time-out) http://salehalsouqi.com/
  1. Uncaught SyntaxError: Unexpected token < frappe.min.js:300
    1. (anonymous function)frappe.min.js:300
    2. k.fireWithjquery.min.js:2
    3. (anonymous function)






On Wednesday, September 3, 2014 3:51:44 PM UTC+4, Vivek wrote:
Hi,

As of now sets of 20 are working. Anything more shows a JSON.parse error on the console




On Tuesday, September 2, 2014 4:51:08 PM UTC+4, rushabh wrote:

On 02-Sep-2014, at 4:45 pm, Vivek <v2...@gmail.com> wrote:

Hi ,

I have imported around 20,000 items into the system. Now when I try to import more, it just shows uploading and sort of hangs over there. I waited maybe upto 20mins without any response. I was wondering what could be the issue. I run this on a 512 MB ram droplet on digital ocean . does it have anyhting to do with that ?



Try importing fewer items in one sheet. Also check your JS console for any error trace.



Note:

If you are posting an issue,


1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.

  1. 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.
    3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

  2. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/52b49a92-ed59-4e66-9d63-cbd4bf4b8d4b%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.




--
Note:

If you are posting an issue,

1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  1. 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.
    3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

  2. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/c321f756-dc3f-4b0a-90ff-b6d6092f7453%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.




Note:



If you are posting an issue,


  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.

  2. 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.

  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email

  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/dacbb16a-b918-4191-bab6-75de95861208%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAAQzbF3p_hpT%2BaAhQHhYD%2BSn8_KVi%3Dbu2mLFYVq_C1pqoVLJFA%40mail.gmail.com.

    For more options, visit https://groups.google.com/d/optout.

On 03-Sep-2014, at 6:49 pm, Vivek <v2...@gmail.com> wrote:


   As I keep adding more items , the number of items I can import seems to be reducing. I had tried using a larger droplet with 2 CPUs and 2GB ram. Let me try again.


this does not seem to be a scale / size issue. There is something else hurting. Did you check your mysql process list?








On Wednesday, September 3, 2014 5:02:12 PM UTC+4, rushabh wrote:
Check your server stats, when importing. 

Specially - mysql, run "show processlist" when your import seems stuck.

Difficult to guess why this happens. I don't think it has to do with the Item import.


On 03-Sep-2014, at 5:40 pm, Vivek <v2...@gmail.com> wrote:

Failed to load resource: the server responded with a status of 504 (Gateway Time-out) http://salehalsouqi.com/
  1. Uncaught SyntaxError: Unexpected token < frappe.min.js:300
    1. (anonymous function)frappe.min.js:300
    2. jjquery.min.js:2
    3. k.fireWithjquery.min.js:2
    4. (anonymous function)






On Wednesday, September 3, 2014 3:51:44 PM UTC+4, Vivek wrote:
Hi,

     As of now sets of 20 are working. Anything more shows a JSON.parse error on the console




On Tuesday, September 2, 2014 4:51:08 PM UTC+4, rushabh wrote:

On 02-Sep-2014, at 4:45 pm, Vivek <v2...@gmail.com> wrote:

Hi ,

     I have imported around 20,000 items into the system. Now when I try to import more, it just shows uploading and sort of hangs over there. I waited maybe upto 20mins without any response. I was wondering what could be the issue. I run this on a 512 MB ram droplet on digital ocean . does it have anyhting to do with that ? 


Try importing fewer items in one sheet. Also check your JS console for any error trace.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/52b49a92-ed59-4e66-9d63-cbd4bf4b8d4b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/c321f756-dc3f-4b0a-90ff-b6d6092f7453%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.




Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/dacbb16a-b918-4191-bab6-75de95861208%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/441AEFC8-FB78-42BF-ACC8-B6B981F3A0E2%40gmail.com.

    For more options, visit https://groups.google.com/d/optout.

Hi ,

      The network tab of the browser console shows  a 504 gatway error of type text

I am uncertain how to access the mysql console at the terminal because when I hit mysql it takes my to MariaDB console, so havent checked the mysql processlist. How do I get to the mysql console?






On Wednesday, September 3, 2014 9:02:07 PM UTC+4, rushabh wrote:

On 03-Sep-2014, at 6:49 pm, Vivek <v2...@gmail.com> wrote:


   As I keep adding more items , the number of items I can import seems to be reducing. I had tried using a larger droplet with 2 CPUs and 2GB ram. Let me try again.


this does not seem to be a scale / size issue. There is something else hurting. Did you check your mysql process list?








On Wednesday, September 3, 2014 5:02:12 PM UTC+4, rushabh wrote:
Check your server stats, when importing. 

Specially - mysql, run "show processlist" when your import seems stuck.

Difficult to guess why this happens. I don't think it has to do with the Item import.


On 03-Sep-2014, at 5:40 pm, Vivek <v2...@gmail.com> wrote:

Failed to load resource: the server responded with a status of 504 (Gateway Time-out) http://salehalsouqi.com/
  1. Uncaught SyntaxError: Unexpected token < frappe.min.js:300
    1. (anonymous function)frappe.min.js:300
    2. jjquery.min.js:2
    3. k.fireWithjquery.min.js:2
    4. (anonymous function)






On Wednesday, September 3, 2014 3:51:44 PM UTC+4, Vivek wrote:
Hi,

     As of now sets of 20 are working. Anything more shows a JSON.parse error on the console




On Tuesday, September 2, 2014 4:51:08 PM UTC+4, rushabh wrote:

On 02-Sep-2014, at 4:45 pm, Vivek <v2...@gmail.com> wrote:

Hi ,

     I have imported around 20,000 items into the system. Now when I try to import more, it just shows uploading and sort of hangs over there. I waited maybe upto 20mins without any response. I was wondering what could be the issue. I run this on a 512 MB ram droplet on digital ocean . does it have anyhting to do with that ? 


Try importing fewer items in one sheet. Also check your JS console for any error trace.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/52b49a92-ed59-4e66-9d63-cbd4bf4b8d4b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/c321f756-dc3f-4b0a-90ff-b6d6092f7453%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.




Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/dacbb16a-b918-4191-bab6-75de95861208%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/eef784f3-625d-4d4f-bfa7-edfb9aaedf2f%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.


On 04-Sep-2014, at 12:10 pm, Vivek <v2...@gmail.com> wrote:


Hi ,

      The network tab of the browser console shows  a 504 gatway error of type text

I am uncertain how to access the mysql console at the terminal because when I hit mysql it takes my to MariaDB console, so havent checked the mysql processlist. How do I get to the mysql console?

mariadb is a drop in replacement for mysql - so all commands are the same! just run

"show processlist" when this comes up.







On Wednesday, September 3, 2014 9:02:07 PM UTC+4, rushabh wrote:

On 03-Sep-2014, at 6:49 pm, Vivek <v2...@gmail.com> wrote:


   As I keep adding more items , the number of items I can import seems to be reducing. I had tried using a larger droplet with 2 CPUs and 2GB ram. Let me try again.


this does not seem to be a scale / size issue. There is something else hurting. Did you check your mysql process list?








On Wednesday, September 3, 2014 5:02:12 PM UTC+4, rushabh wrote:
Check your server stats, when importing. 

Specially - mysql, run "show processlist" when your import seems stuck.

Difficult to guess why this happens. I don't think it has to do with the Item import.


On 03-Sep-2014, at 5:40 pm, Vivek <v2...@gmail.com> wrote:

Failed to load resource: the server responded with a status of 504 (Gateway Time-out) http://salehalsouqi.com/
  1. Uncaught SyntaxError: Unexpected token < frappe.min.js:300
    1. (anonymous function)frappe.min.js:300
    2. jjquery.min.js:2
    3. k.fireWithjquery.min.js:2
    4. (anonymous function)






On Wednesday, September 3, 2014 3:51:44 PM UTC+4, Vivek wrote:
Hi,

     As of now sets of 20 are working. Anything more shows a JSON.parse error on the console




On Tuesday, September 2, 2014 4:51:08 PM UTC+4, rushabh wrote:

On 02-Sep-2014, at 4:45 pm, Vivek <v2...@gmail.com> wrote:

Hi ,

     I have imported around 20,000 items into the system. Now when I try to import more, it just shows uploading and sort of hangs over there. I waited maybe upto 20mins without any response. I was wondering what could be the issue. I run this on a 512 MB ram droplet on digital ocean . does it have anyhting to do with that ? 


Try importing fewer items in one sheet. Also check your JS console for any error trace.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/52b49a92-ed59-4e66-9d63-cbd4bf4b8d4b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/c321f756-dc3f-4b0a-90ff-b6d6092f7453%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.




Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/dacbb16a-b918-4191-bab6-75de95861208%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.




Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/eef784f3-625d-4d4f-bfa7-edfb9aaedf2f%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/C98A5B37-8605-4989-9132-568880500F99%40gmail.com.

    For more options, visit https://groups.google.com/d/optout.

It returns an empty list , accept for the the query SHOW PROCESSLIST, it returns empty.

Before I started import there was one more line in the table , with the user for the DB and state Sleep

Ones I started import it goes off and just returns SHOW PROCESSLIST as the only query running



On Thursday, September 4, 2014 11:01:09 AM UTC+4, rushabh wrote:


On 04-Sep-2014, at 12:10 pm, Vivek <v2...@gmail.com> wrote:


Hi ,

      The network tab of the browser console shows  a 504 gatway error of type text

I am uncertain how to access the mysql console at the terminal because when I hit mysql it takes my to MariaDB console, so havent checked the mysql processlist. How do I get to the mysql console?

mariadb is a drop in replacement for mysql - so all commands are the same! just run

"show processlist" when this comes up.







On Wednesday, September 3, 2014 9:02:07 PM UTC+4, rushabh wrote:

On 03-Sep-2014, at 6:49 pm, Vivek <v2...@gmail.com> wrote:


   As I keep adding more items , the number of items I can import seems to be reducing. I had tried using a larger droplet with 2 CPUs and 2GB ram. Let me try again.


this does not seem to be a scale / size issue. There is something else hurting. Did you check your mysql process list?








On Wednesday, September 3, 2014 5:02:12 PM UTC+4, rushabh wrote:
Check your server stats, when importing. 

Specially - mysql, run "show processlist" when your import seems stuck.

Difficult to guess why this happens. I don't think it has to do with the Item import.


On 03-Sep-2014, at 5:40 pm, Vivek <v2...@gmail.com> wrote:

Failed to load resource: the server responded with a status of 504 (Gateway Time-out) http://salehalsouqi.com/
  1. Uncaught SyntaxError: Unexpected token < frappe.min.js:300
    1. (anonymous function)frappe.min.js:300
    2. jjquery.min.js:2
    3. k.fireWithjquery.min.js:2
    4. (anonymous function)






On Wednesday, September 3, 2014 3:51:44 PM UTC+4, Vivek wrote:
Hi,

     As of now sets of 20 are working. Anything more shows a JSON.parse error on the console




On Tuesday, September 2, 2014 4:51:08 PM UTC+4, rushabh wrote:

On 02-Sep-2014, at 4:45 pm, Vivek <v2...@gmail.com> wrote:

Hi ,

     I have imported around 20,000 items into the system. Now when I try to import more, it just shows uploading and sort of hangs over there. I waited maybe upto 20mins without any response. I was wondering what could be the issue. I run this on a 512 MB ram droplet on digital ocean . does it have anyhting to do with that ? 


Try importing fewer items in one sheet. Also check your JS console for any error trace.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/52b49a92-ed59-4e66-9d63-cbd4bf4b8d4b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/c321f756-dc3f-4b0a-90ff-b6d6092f7453%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.




Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/dacbb16a-b918-4191-bab6-75de95861208%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.




Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/eef784f3-625d-4d4f-bfa7-edfb9aaedf2f%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/5a8166ae-a4e8-4eda-83a7-42adbb21b8ba%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.

  I have attached a screenshot




On Thursday, September 4, 2014 11:12:52 AM UTC+4, Vivek wrote:

It returns an empty list , accept for the the query SHOW PROCESSLIST, it returns empty.

Before I started import there was one more line in the table , with the user for the DB and state Sleep

Ones I started import it goes off and just returns SHOW PROCESSLIST as the only query running



On Thursday, September 4, 2014 11:01:09 AM UTC+4, rushabh wrote:


On 04-Sep-2014, at 12:10 pm, Vivek <v2...@gmail.com> wrote:


Hi ,

      The network tab of the browser console shows  a 504 gatway error of type text

I am uncertain how to access the mysql console at the terminal because when I hit mysql it takes my to MariaDB console, so havent checked the mysql processlist. How do I get to the mysql console?

mariadb is a drop in replacement for mysql - so all commands are the same! just run

"show processlist" when this comes up.







On Wednesday, September 3, 2014 9:02:07 PM UTC+4, rushabh wrote:

On 03-Sep-2014, at 6:49 pm, Vivek <v2...@gmail.com> wrote:


   As I keep adding more items , the number of items I can import seems to be reducing. I had tried using a larger droplet with 2 CPUs and 2GB ram. Let me try again.


this does not seem to be a scale / size issue. There is something else hurting. Did you check your mysql process list?








On Wednesday, September 3, 2014 5:02:12 PM UTC+4, rushabh wrote:
Check your server stats, when importing. 

Specially - mysql, run "show processlist" when your import seems stuck.

Difficult to guess why this happens. I don't think it has to do with the Item import.


On 03-Sep-2014, at 5:40 pm, Vivek <v2...@gmail.com> wrote:

Failed to load resource: the server responded with a status of 504 (Gateway Time-out) http://salehalsouqi.com/
  1. Uncaught SyntaxError: Unexpected token < frappe.min.js:300
    1. (anonymous function)frappe.min.js:300
    2. jjquery.min.js:2
    3. k.fireWithjquery.min.js:2
    4. (anonymous function)






On Wednesday, September 3, 2014 3:51:44 PM UTC+4, Vivek wrote:
Hi,

     As of now sets of 20 are working. Anything more shows a JSON.parse error on the console




On Tuesday, September 2, 2014 4:51:08 PM UTC+4, rushabh wrote:

On 02-Sep-2014, at 4:45 pm, Vivek <v2...@gmail.com> wrote:

Hi ,

     I have imported around 20,000 items into the system. Now when I try to import more, it just shows uploading and sort of hangs over there. I waited maybe upto 20mins without any response. I was wondering what could be the issue. I run this on a 512 MB ram droplet on digital ocean . does it have anyhting to do with that ? 


Try importing fewer items in one sheet. Also check your JS console for any error trace.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/52b49a92-ed59-4e66-9d63-cbd4bf4b8d4b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/c321f756-dc3f-4b0a-90ff-b6d6092f7453%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.




Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/dacbb16a-b918-4191-bab6-75de95861208%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.




Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/eef784f3-625d-4d4f-bfa7-edfb9aaedf2f%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/e1b79412-13c0-4e43-aece-d45f2e4e27e9%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.
Difficult to guess what is going wrong - if your mysql isn't clogged up, there is something else.

Are you sure your internet connection works. Also try and restart your machine and see if it works.

Can't guess why this might be happening.


On 04-Sep-2014, at 1:02 pm, Vivek <v2...@gmail.com> wrote:


  I have attached a screenshot




On Thursday, September 4, 2014 11:12:52 AM UTC+4, Vivek wrote:

It returns an empty list , accept for the the query SHOW PROCESSLIST, it returns empty. 

Before I started import there was one more line in the table , with the user for the DB and state Sleep 

Ones I started import it goes off and just returns SHOW PROCESSLIST as the only query running



On Thursday, September 4, 2014 11:01:09 AM UTC+4, rushabh wrote:


On 04-Sep-2014, at 12:10 pm, Vivek <v2...@gmail.com> wrote:


Hi ,

      The network tab of the browser console shows  a 504 gatway error of type text

I am uncertain how to access the mysql console at the terminal because when I hit mysql it takes my to MariaDB console, so havent checked the mysql processlist. How do I get to the mysql console?

mariadb is a drop in replacement for mysql - so all commands are the same! just run

"show processlist" when this comes up.







On Wednesday, September 3, 2014 9:02:07 PM UTC+4, rushabh wrote:

On 03-Sep-2014, at 6:49 pm, Vivek <v2...@gmail.com> wrote:


   As I keep adding more items , the number of items I can import seems to be reducing. I had tried using a larger droplet with 2 CPUs and 2GB ram. Let me try again.


this does not seem to be a scale / size issue. There is something else hurting. Did you check your mysql process list?








On Wednesday, September 3, 2014 5:02:12 PM UTC+4, rushabh wrote:
Check your server stats, when importing. 

Specially - mysql, run "show processlist" when your import seems stuck.

Difficult to guess why this happens. I don't think it has to do with the Item import.


On 03-Sep-2014, at 5:40 pm, Vivek <v2...@gmail.com> wrote:

Failed to load resource: the server responded with a status of 504 (Gateway Time-out) http://salehalsouqi.com/
  1. Uncaught SyntaxError: Unexpected token < frappe.min.js:300
    1. (anonymous function)frappe.min.js:300
    2. jjquery.min.js:2
    3. k.fireWithjquery.min.js:2
    4. (anonymous function)






On Wednesday, September 3, 2014 3:51:44 PM UTC+4, Vivek wrote:
Hi,

     As of now sets of 20 are working. Anything more shows a JSON.parse error on the console




On Tuesday, September 2, 2014 4:51:08 PM UTC+4, rushabh wrote:

On 02-Sep-2014, at 4:45 pm, Vivek <v2...@gmail.com> wrote:

Hi ,

     I have imported around 20,000 items into the system. Now when I try to import more, it just shows uploading and sort of hangs over there. I waited maybe upto 20mins without any response. I was wondering what could be the issue. I run this on a 512 MB ram droplet on digital ocean . does it have anyhting to do with that ? 


Try importing fewer items in one sheet. Also check your JS console for any error trace.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/52b49a92-ed59-4e66-9d63-cbd4bf4b8d4b%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/c321f756-dc3f-4b0a-90ff-b6d6092f7453%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email toerpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/dacbb16a-b918-4191-bab6-75de95861208%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/eef784f3-625d-4d4f-bfa7-edfb9aaedf2f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.


-- 
Note:
 
If you are posting an issue,
 
1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
2. 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.
3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
4. 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.
To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/e1b79412-13c0-4e43-aece-d45f2e4e27e9%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
<Screenshot from 2014-09-04 11:30:50.png>



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/23125DB5-BBAD-48EB-9FB5-DEE81B91FD09%40gmail.com.

    For more options, visit https://groups.google.com/d/optout.

On Thu, Sep 4, 2014 at 12:42 PM, Vivek v2...@gmail.com wrote:

It returns an empty list , accept for the the query SHOW PROCESSLIST, it
returns empty.

Before I started import there was one more line in the table , with the user
for the DB and state Sleep

Ones I started import it goes off and just returns SHOW PROCESSLIST as the
only query running

Hi Vivek,

Looks like the http request is timing out.

Try the following,

bench update --bench
bench config http_timeout 600
bench setup nginx
bench setup supervisor
sudo supervisorctl reload
sudo service nginx restart

Thanks,

Pratik
ERPNext


Hi,

     This seemed to have helped a bit. Now I think I am pretty convinced its got something to do with the network. I am going to try this on another droplet in a different region. Doubt it could be something to do with my internal home / office network



On Thursday, September 4, 2014 2:13:24 PM UTC+4, Pratik Vyas wrote:
On Thu, Sep 4, 2014 at 12:42 PM, Vivek <v2...@gmail.com> wrote:
>
> It returns an empty list , accept for the the query SHOW PROCESSLIST, it
> returns empty.
>
> Before I started import there was one more line in the table , with the user
> for the DB and state Sleep
>
> Ones I started import it goes off and just returns SHOW PROCESSLIST as the
> only query running
>
>

Hi Vivek,

Looks like the http request is timing out.

Try the following,
```
bench update --bench
bench config http_timeout 600
bench setup nginx
bench setup supervisor
sudo supervisorctl reload
sudo service nginx restart
```

Thanks,
--
Pratik
ERPNext



Note:

 

If you are posting an issue,

 

  1. ERPNext is a free and open source software and support is given on this forum by a team (https://frappe.io/webnotes). So please consider donating if you find this forum useful (https://frappe.io/buy). Even a small amount would be helpful.
  2. 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.
  3. Paste your code at http://pastebin.com or http://gist.github.com and send only the URL via email
  4. 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.

    To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-developer-forum+un…@googlegroups.com.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/c76c491c-9229-4e55-a6f0-c67890b53c03%40googlegroups.com.

    For more options, visit https://groups.google.com/d/optout.