How to add another unique field like serial numbers for an individual item

1
HI ,

        I have 2 unique fields for each item under the same product name . 

1. Being serial number which erpnext handles well
2. Being sim numbers. 

Now when making a purchase receipt I have the option to add the serial numbers in bulk . How would I replicate the same with another field for the 2nd unique field in my case being sim  numbers . If you could point me to the code which handles loading the serial numbers , I should be able to read and write one to add my requirment

If I could upload stock via a CSV file is also fine.


Thanks 

–

Note:

 

If you are posting an issue,

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

    For more options, visit https://groups.google.com/groups/opt_out.
2
Hi Vivek

In your case, the simplest solution will be to:

1. Create a custom field SIM No. in the Serial No doctype and make it required.
2. Use data import tool to upload new serial no - sim no combinations without warehouse.
3. Any entry/movement of serial no already will have a sim no associated with it.

-Anand.


On Wed, Nov 27, 2013 at 7:26 PM, Vivek <v2...@gmail.com> wrote:
HI ,

I have 2 unique fields for each item under the same product name .

1. Being serial number which erpnext handles well
2. Being sim numbers.

Now when making a purchase receipt I have the option to add the serial numbers in bulk . How would I replicate the same with another field for the 2nd unique field in my case being sim numbers . If you could point me to the code which handles loading the serial numbers , I should be able to read and write one to add my requirment

If I could upload stock via a CSV file is also fine.


Thanks

–

Note:



If you are posting an issue,

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

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


–

Note:

 

If you are posting an issue,

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

    For more options, visit https://groups.google.com/groups/opt_out.
3
Hi ,

      So I will have to upload the Serial  - Sim No combo , using the data import tool for the Serial_no template. Correct ? I been trying for the same , but unable to import the file.The file gets uploaded without any response back. 









On Wednesday, November 27, 2013 9:26:41 PM UTC+4, Anand Doshi wrote:
Hi Vivek

In your case, the simplest solution will be to:

1. Create a custom field SIM No. in the Serial No doctype and make it required.
2. Use data import tool to upload new serial no - sim no combinations without warehouse.
3. Any entry/movement of serial no already will have a sim no associated with it.

-Anand.


On Wed, Nov 27, 2013 at 7:26 PM, Vivek <v2...@gmail.com> wrote:
HI ,

        I have 2 unique fields for each item under the same product name . 

1. Being serial number which erpnext handles well
2. Being sim numbers. 

Now when making a purchase receipt I have the option to add the serial numbers in bulk . How would I replicate the same with another field for the 2nd unique field in my case being sim  numbers . If you could point me to the code which handles loading the serial numbers , I should be able to read and write one to add my requirment

If I could upload stock via a CSV file is also fine.


Thanks 

–

Note:

 

If you are posting an issue,

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

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


–

Note:

 

If you are posting an issue,

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

    For more options, visit https://groups.google.com/groups/opt_out.
4
I think there is some error with the data import tool for the Serial_no Table. When I click on upload , the green bar on top loads to full and nothing else is shown. Any way I can track what just happened?




On Thursday, November 28, 2013 6:28:58 PM UTC+4, Vivek wrote:
Hi ,

      So I will have to upload the Serial  - Sim No combo , using the data import tool for the Serial_no template. Correct ? I been trying for the same , but unable to import the file.The file gets uploaded without any response back. 









On Wednesday, November 27, 2013 9:26:41 PM UTC+4, Anand Doshi wrote:
Hi Vivek

In your case, the simplest solution will be to:

1. Create a custom field SIM No. in the Serial No doctype and make it required.
2. Use data import tool to upload new serial no - sim no combinations without warehouse.
3. Any entry/movement of serial no already will have a sim no associated with it.

-Anand.


On Wed, Nov 27, 2013 at 7:26 PM, Vivek <v2...@gmail.com> wrote:
HI ,

        I have 2 unique fields for each item under the same product name . 

1. Being serial number which erpnext handles well
2. Being sim numbers. 

Now when making a purchase receipt I have the option to add the serial numbers in bulk . How would I replicate the same with another field for the 2nd unique field in my case being sim  numbers . If you could point me to the code which handles loading the serial numbers , I should be able to read and write one to add my requirment

If I could upload stock via a CSV file is also fine.


Thanks 

–

Note:

 

If you are posting an issue,

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

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


–

Note:

 

If you are posting an issue,

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

    For more options, visit https://groups.google.com/groups/opt_out.
5
Do you see anything in your Javascript Console?

On Thursday, November 28, 2013 8:21:48 PM UTC+5:30, Vivek wrote:
I think there is some error with the data import tool for the Serial_no Table. When I click on upload , the green bar on top loads to full and nothing else is shown. Any way I can track what just happened?




On Thursday, November 28, 2013 6:28:58 PM UTC+4, Vivek wrote:
Hi ,

      So I will have to upload the Serial  - Sim No combo , using the data import tool for the Serial_no template. Correct ? I been trying for the same , but unable to import the file.The file gets uploaded without any response back. 









On Wednesday, November 27, 2013 9:26:41 PM UTC+4, Anand Doshi wrote:
Hi Vivek

In your case, the simplest solution will be to:

1. Create a custom field SIM No. in the Serial No doctype and make it required.
2. Use data import tool to upload new serial no - sim no combinations without warehouse.
3. Any entry/movement of serial no already will have a sim no associated with it.

-Anand.


On Wed, Nov 27, 2013 at 7:26 PM, Vivek <v2...@gmail.com> wrote:
HI ,

        I have 2 unique fields for each item under the same product name . 

1. Being serial number which erpnext handles well
2. Being sim numbers. 

Now when making a purchase receipt I have the option to add the serial numbers in bulk . How would I replicate the same with another field for the 2nd unique field in my case being sim  numbers . If you could point me to the code which handles loading the serial numbers , I should be able to read and write one to add my requirment

If I could upload stock via a CSV file is also fine.


Thanks 

–

Note:

 

If you are posting an issue,

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

–

Note:

 

If you are posting an issue,

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

    For more options, visit https://groups.google.com/groups/opt_out.
6
Hi Vivek,

Can you update? I think there was an issue in data import tool which was fixed yesterday.

-Anand.


On Fri, Nov 29, 2013 at 3:16 PM, rushabh <rm…@gmail.com> wrote:

Do you see anything in your Javascript Console?


On Thursday, November 28, 2013 8:21:48 PM UTC+5:30, Vivek wrote:
I think there is some error with the data import tool for the Serial_no Table. When I click on upload , the green bar on top loads to full and nothing else is shown. Any way I can track what just happened?




On Thursday, November 28, 2013 6:28:58 PM UTC+4, Vivek wrote:
Hi ,

So I will have to upload the Serial - Sim No combo , using the data import tool for the Serial_no template. Correct ? I been trying for the same , but unable to import the file.The file gets uploaded without any response back.









On Wednesday, November 27, 2013 9:26:41 PM UTC+4, Anand Doshi wrote:
Hi Vivek

In your case, the simplest solution will be to:

1. Create a custom field SIM No. in the Serial No doctype and make it required.
2. Use data import tool to upload new serial no - sim no combinations without warehouse.
3. Any entry/movement of serial no already will have a sim no associated with it.

-Anand.


On Wed, Nov 27, 2013 at 7:26 PM, Vivek <v2...@gmail.com> wrote:
HI ,

I have 2 unique fields for each item under the same product name .

1. Being serial number which erpnext handles well
2. Being sim numbers.

Now when making a purchase receipt I have the option to add the serial numbers in bulk . How would I replicate the same with another field for the 2nd unique field in my case being sim numbers . If you could point me to the code which handles loading the serial numbers , I should be able to read and write one to add my requirment

If I could upload stock via a CSV file is also fine.


Thanks

–

Note:



If you are posting an issue,

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

–

Note:



If you are posting an issue,

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

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


–

Note:

 

If you are posting an issue,

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

    For more options, visit https://groups.google.com/groups/opt_out.
7
Hi , 

      I reinstalled from source , but am still having trouble with the data import tool. Gets stuck on "Performing hardcore import process..."



On Friday, November 29, 2013 1:51:44 PM UTC+4, Anand Doshi wrote:
Hi Vivek,

Can you update? I think there was an issue in data import tool which was fixed yesterday.

-Anand.


On Fri, Nov 29, 2013 at 3:16 PM, rushabh <rm…@gmail.com> wrote:

Do you see anything in your Javascript Console?


On Thursday, November 28, 2013 8:21:48 PM UTC+5:30, Vivek wrote:
I think there is some error with the data import tool for the Serial_no Table. When I click on upload , the green bar on top loads to full and nothing else is shown. Any way I can track what just happened?




On Thursday, November 28, 2013 6:28:58 PM UTC+4, Vivek wrote:
Hi ,

      So I will have to upload the Serial  - Sim No combo , using the data import tool for the Serial_no template. Correct ? I been trying for the same , but unable to import the file.The file gets uploaded without any response back. 









On Wednesday, November 27, 2013 9:26:41 PM UTC+4, Anand Doshi wrote:
Hi Vivek

In your case, the simplest solution will be to:

1. Create a custom field SIM No. in the Serial No doctype and make it required.
2. Use data import tool to upload new serial no - sim no combinations without warehouse.
3. Any entry/movement of serial no already will have a sim no associated with it.

-Anand.


On Wed, Nov 27, 2013 at 7:26 PM, Vivek <v2...@gmail.com> wrote:
HI ,

        I have 2 unique fields for each item under the same product name . 

1. Being serial number which erpnext handles well
2. Being sim numbers. 

Now when making a purchase receipt I have the option to add the serial numbers in bulk . How would I replicate the same with another field for the 2nd unique field in my case being sim  numbers . If you could point me to the code which handles loading the serial numbers , I should be able to read and write one to add my requirment

If I could upload stock via a CSV file is also fine.


Thanks 

–

Note:

 

If you are posting an issue,

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

–

Note:

 

If you are posting an issue,

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

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


–

Note:

 

If you are posting an issue,

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

    For more options, visit https://groups.google.com/groups/opt_out.
8
Java Console reads as follows


Cleared App Cache. all-app.min.js:161
Cleared localstorage all-app.min.js:162
event.returnValue is deprecated. Please use the standard event.preventDefault() instead.
Cleared Cache - New Metadata all-app.min.js:363
Starting up... all-app.min.js:2418
Traceback (innermost last): File "lib/webnotes/handler.py", line 61, in uploadfile ret = webnotes.get_method(webnotes.form_dict.method)() File "lib/core/page/data_import_tool/data_import_tool.py", line 343, in upload doctype = get_header_row(data_keys.main_table)[1] IndexError: list index out of range all-app.min.js:331
Uncaught TypeError: Cannot read property 'messages' of undefined

–

Note:

 

If you are posting an issue,

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

    For more options, visit https://groups.google.com/groups/opt_out.
9
Hi Vivek,

The data import template you used seems to be incorrect!

Best,
Anand.


On Mon, Dec 2, 2013 at 6:33 PM, Vivek <v2...@gmail.com> wrote:
Java Console reads as follows


Cleared App Cache. all-app.min.js:161

Cleared localstorage all-app.min.js:162

event.returnValue is deprecated. Please use the standard event.preventDefault() instead.

Cleared Cache - New Metadata all-app.min.js:363

Starting up… all-app.min.js:2418

Traceback (innermost last):
File "lib/webnotes/handler.py", line 61, in uploadfile
ret = webnotes.get_method(webnotes.form_dict.method)()
File "lib/core/page/data_import_tool/data_import_tool.py", line 343, in upload
doctype = get_header_row(data_keys.main_table)[1]
IndexError: list index out of range
 all-app.min.js:331

Uncaught TypeError: Cannot read property 'messages' of undefined

–

Note:



If you are posting an issue,

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

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


–

Note:

 

If you are posting an issue,

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

    For more options, visit https://groups.google.com/groups/opt_out.
10
Hi ,

      Yes my template was being saved wrong , OpenOffice seemed to corrupt the template ones opened and saved. I had to use excel and then use notepad to save .

Thanks



On Tuesday, December 3, 2013 7:34:13 AM UTC+4, Anand Doshi wrote:
Hi Vivek,

The data import template you used seems to be incorrect!

Best,
Anand.


On Mon, Dec 2, 2013 at 6:33 PM, Vivek <v2...@gmail.com> wrote:
Java Console reads as follows


Cleared App Cache. all-app.min.js:161

Cleared localstorage all-app.min.js:162

event.returnValue is deprecated. Please use the standard event.preventDefault() instead.

Cleared Cache - New Metadata all-app.min.js:363

Starting up… all-app.min.js:2418

Traceback (innermost last):
File “lib/webnotes/handler.py”, line 61, in uploadfile
ret = webnotes.get_method(webnotes.form_dict.method)()
File “lib/core/page/data_import_tool/data_import_tool.py”, line 343, in upload
doctype = get_header_row(data_keys.main_table)[1]
IndexError: list index out of range
 all-app.min.js:331

Uncaught TypeError: Cannot read property ‘messages’ of undefined

–

Note:

 

If you are posting an issue,

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

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


–

Note:

 

If you are posting an issue,

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

    For more options, visit https://groups.google.com/groups/opt_out.
11

Is it possible to have the additional Field i,e. SIM here, just for a given ITEM or Item group?