Import GL Entry Data

Hi all,
  1. I have to import GL entry data through application. 
  2. For that i have given 'Allow Import' permission to GL Entry doctype
  3. In data Import tool, i have download template and added new records.
  4. I have saved file in csv format and upload it
  5. At the time of uploading i get following error 
        Traceback (innermost last): File "../lib/webnotes/handler.py", line 92, in uploadfile ret = webnotes.get_method(webnotes.form_dict.method)() File   "../lib/core/page/data_import_tool/data_import_tool.py", line 184, in upload doctype = get_header_row(data_keys.main_table)[1] IndexError: list index out of range

For your reference i have attached csv file here with. Please give me solution on it.

Thanks and regards
Rohit



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.
Rohit,

Try Voucher Import tool. it will create voucher in bulk and create GL entries for those vouchers.

https://prh.erpnext.com/voucher-import-tool

Hope this helps.


On Wed, Sep 11, 2013 at 6:42 PM, Rohit Waghchaure <ro...@indictranstech.com> wrote:
Hi all,
  1. I have to import GL entry data through application.
  2. For that i have given 'Allow Import' permission to GL Entry doctype
  3. In data Import tool, i have download template and added new records.
  4. I have saved file in csv format and upload it
  5. At the time of uploading i get following error
Traceback (innermost last): File "../lib/webnotes/handler.py", line 92, in uploadfile ret = webnotes.get_method(webnotes.form_dict.method)() File "../lib/core/page/data_import_tool/data_import_tool.py", line 184, in upload doctype = get_header_row(data_keys.main_table)[1] IndexError: list index out of range

For your reference i have attached csv file here with. Please give me solution on it.

Thanks and regards
Rohit



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.




--
Thanks and Regards,
Umair Sayyed
www.erpnext.com



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.