Voucher Import Tool Error

Hi All,

I was trying to import vouchers from voucher import tool while uploading the "Voucher-Import-Two_Accounts.csv" file getting this error:

[row #12] failed: 'NoneType' object has no attribute 'startswith'

All transactions rolled back

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

Thanks and regards

Sayali



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.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/1eb06562-72c2-457c-93df-fc7113eeb4fd%40googlegroups.com.

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

In our latest version, vouchers are imported from Data Import Tool. Please check following links for help on migrating to our latest version.

https://github.com/webnotes/erpnext/wiki/Migrating-your-erpnext-instance-to-wsgi

https://github.com/webnotes/erpnext/wiki/WSGI-Production-Deployment

Following help link is for importing transactions from Data Import Tool.

http://erpnext.org/data-import-tool

Hope this helps.


On Thu, Feb 13, 2014 at 11:41 PM, Sayali Yewale <sa...@gmail.com> wrote:
Hi All,

I was trying to import vouchers from voucher import tool while uploading the "Voucher-Import-Two_Accounts.csv" file getting this error:

[row #12] failed: 'NoneType' object has no attribute 'startswith'

All transactions rolled back

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

Thanks and regards

Sayali



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.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/1eb06562-72c2-457c-93df-fc7113eeb4fd%40googlegroups.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.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CAJ33fAtgkrW%3D7Cvgejf9DyhScJr-6fGSFdmUejzMZBc9701YPQ%40mail.gmail.com.

    For more options, visit https://groups.google.com/groups/opt_out.
Thanks Umair, for an update.
I ran the latest update. But when i am trying to create voucher type such as bank voucher and cash voucher, getting this error:

[14:58:32.684] Traceback (innermost last):
File "lib/webnotes/handler.py", line 78, in handle
execute_cmd(cmd)
File "lib/webnotes/handler.py", line 118, in execute_cmd
ret = call(method, webnotes.form_dict)
File "lib/webnotes/handler.py", line 140, in call
return fn(**newargs)
File "lib/webnotes/widgets/form/save.py", line 18, in savedocs
getattr(wrapper, action.lower())()
File "lib/webnotes/model/bean.py", line 299, in save
self.run_method('validate')
File "lib/webnotes/model/bean.py", line 239, in run_method
getattr(self.controller, method)(*args, **kwargs)
File "app/accounts/doctype/journal_voucher/journal_voucher.py", line 37, in validate
self.create_remarks()
File "app/accounts/doctype/journal_voucher/journal_voucher.py", line 123, in create_remarks
(self.doc.cheque_no, formatdate(self.doc.cheque_date)))
File "lib/webnotes/utils/__init__.py", line 274, in formatdate
return out.replace("dd", string_date.strftime("%d"))\
AttributeError: 'NoneType' object has no attribute 'replace'

Thanks and regards

Sayali




On Fri, Feb 14, 2014 at 12:10 PM, Umair Sayyed <um...@iwebnotes.com> wrote:
Hello Sayali,

In our latest version, vouchers are imported from Data Import Tool. Please check following links for help on migrating to our latest version.

https://github.com/webnotes/erpnext/wiki/Migrating-your-erpnext-instance-to-wsgi

https://github.com/webnotes/erpnext/wiki/WSGI-Production-Deployment

Following help link is for importing transactions from Data Import Tool.


http://erpnext.org/data-import-tool

Hope this helps.



On Thu, Feb 13, 2014 at 11:41 PM, Sayali Yewale <sa…@gmail.com> wrote:

Hi All,

I was trying to import vouchers from voucher import tool while uploading the "Voucher-Import-Two_Accounts.csv" file getting this error:


[row #12] failed: 'NoneType' object has no attribute 'startswith'

All transactions rolled back

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

Thanks and regards

Sayali



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.



--
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 a topic in the Google Groups "ERPNext Developer Forum" group.

    To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-developer-forum/BJPlHN-QXbg/unsubscribe.

To unsubscribe from this group and all its topics, 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/CAJ33fAtgkrW%3D7Cvgejf9DyhScJr-6fGSFdmUejzMZBc9701YPQ%40mail.gmail.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.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CACMa%2BPfv-oTPtgMNrWc6uniBpYjHti%3Ds5RN5_oG2i2_V86EJiA%40mail.gmail.com.

    For more options, visit https://groups.google.com/groups/opt_out.
Set "Date Format" from Setup -> Global Defaults, clear cache and refresh and try again.

On 14-Feb-2014, at 4:13 PM, Sayali Yewale wrote:

Thanks Umair, for an update.
I ran the latest update. But when i am trying to create voucher type such as bank voucher and cash voucher, getting this error:

[14:58:32.684] Traceback (innermost last):
  File "lib/webnotes/handler.py", line 78, in handle
    execute_cmd(cmd)
  File "lib/webnotes/handler.py", line 118, in execute_cmd
    ret = call(method, webnotes.form_dict)
  File "lib/webnotes/handler.py", line 140, in call
    return fn(**newargs)
  File "lib/webnotes/widgets/form/save.py", line 18, in savedocs
    getattr(wrapper, action.lower())()
  File "lib/webnotes/model/bean.py", line 299, in save
    self.run_method('validate')
  File "lib/webnotes/model/bean.py", line 239, in run_method
    getattr(self.controller, method)(*args, **kwargs)
  File "app/accounts/doctype/journal_voucher/journal_voucher.py", line 37, in validate
    self.create_remarks()
  File "app/accounts/doctype/journal_voucher/journal_voucher.py", line 123, in create_remarks
    (self.doc.cheque_no, formatdate(self.doc.cheque_date)))
  File "lib/webnotes/utils/__init__.py", line 274, in formatdate
    return out.replace("dd", string_date.strftime("%d"))\
 AttributeError: 'NoneType' object has no attribute 'replace'

Thanks and regards

Sayali




On Fri, Feb 14, 2014 at 12:10 PM, Umair Sayyed <um...@iwebnotes.com> wrote:
Hello Sayali,

In our latest version, vouchers are imported from Data Import Tool. Please check following links for help on migrating to our latest version.

https://github.com/webnotes/erpnext/wiki/Migrating-your-erpnext-instance-to-wsgi

https://github.com/webnotes/erpnext/wiki/WSGI-Production-Deployment

Following help link is for importing transactions from Data Import Tool.


http://erpnext.org/data-import-tool

Hope this helps.



On Thu, Feb 13, 2014 at 11:41 PM, Sayali Yewale <sa…@gmail.com> wrote:

Hi All,

I was trying to import vouchers from voucher import tool while uploading the "Voucher-Import-Two_Accounts.csv" file getting this error:


[row #12] failed: ‘NoneType’ object has no attribute ‘startswith’

All transactions rolled back

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

Thanks and regards

Sayali




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.



--
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 a topic in the Google Groups “ERPNext Developer Forum” group.

    To unsubscribe from this topic, visit https://groups.google.com/d/topic/erpnext-developer-forum/BJPlHN-QXbg/unsubscribe.

To unsubscribe from this group and all its topics, 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/CAJ33fAtgkrW%3D7Cvgejf9DyhScJr-6fGSFdmUejzMZBc9701YPQ%40mail.gmail.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.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/CACMa%2BPfv-oTPtgMNrWc6uniBpYjHti%3Ds5RN5_oG2i2_V86EJiA%40mail.gmail.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.

    To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-developer-forum/826629A3-7558-4009-A48F-A845013665BE%40gmail.com.

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