Data Import Tool issue

ERPNext
1

Hi,

I’ve downloaded Item Attribute (with data containing default attributes - color,size) and tried to upload the same file without changing anything. I got the below error.

{u’item_attribute_values’: [{u’attribute_value’: u’Green’, u’parenttype’: u’Item Attribute’, u’parentfield’: u’item_attribute_values’, u’abbr’: u’GRE’, u’doctype’: u’Item Attribute Value’}]}
desk.min.js?ver=1512993594.0:1701 Traceback (most recent call last):
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 324, in upload
validate_naming(doc)
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 179, in validate_naming
autoname = frappe.get_meta(doc[‘doctype’]).autoname
KeyError: u’doctype’

desk.min.js?ver=1512993594.0:1701 {u’item_attribute_values’: [{u’attribute_value’: u’Blue’, u’parenttype’: u’Item Attribute’, u’parentfield’: u’item_attribute_values’, u’abbr’: u’BLU’, u’doctype’: u’Item Attribute Value’}]}
desk.min.js?ver=1512993594.0:1701 Traceback (most recent call last):
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 324, in upload
validate_naming(doc)
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 179, in validate_naming
autoname = frappe.get_meta(doc[‘doctype’]).autoname
KeyError: u’doctype’

desk.min.js?ver=1512993594.0:1701 {u’item_attribute_values’: [{u’attribute_value’: u’Black’, u’parenttype’: u’Item Attribute’, u’parentfield’: u’item_attribute_values’, u’abbr’: u’BLA’, u’doctype’: u’Item Attribute Value’}]}
desk.min.js?ver=1512993594.0:1701 Traceback (most recent call last):
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 324, in upload
validate_naming(doc)
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 179, in validate_naming
autoname = frappe.get_meta(doc[‘doctype’]).autoname
KeyError: u’doctype’

desk.min.js?ver=1512993594.0:1701 {u’item_attribute_values’: [{u’attribute_value’: u’White’, u’parenttype’: u’Item Attribute’, u’parentfield’: u’item_attribute_values’, u’abbr’: u’WHI’, u’doctype’: u’Item Attribute Value’}]}
desk.min.js?ver=1512993594.0:1701 Traceback (most recent call last):
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 324, in upload
validate_naming(doc)
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 179, in validate_naming
autoname = frappe.get_meta(doc[‘doctype’]).autoname
KeyError: u’doctype’

desk.min.js?ver=1512993594.0:1701 {u’item_attribute_values’: [{u’attribute_value’: u’Small’, u’parenttype’: u’Item Attribute’, u’parentfield’: u’item_attribute_values’, u’abbr’: u’S’, u’doctype’: u’Item Attribute Value’}]}
desk.min.js?ver=1512993594.0:1701 Traceback (most recent call last):
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 324, in upload
validate_naming(doc)
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 179, in validate_naming
autoname = frappe.get_meta(doc[‘doctype’]).autoname
KeyError: u’doctype’

desk.min.js?ver=1512993594.0:1701 {u’item_attribute_values’: [{u’attribute_value’: u’Medium’, u’parenttype’: u’Item Attribute’, u’parentfield’: u’item_attribute_values’, u’abbr’: u’M’, u’doctype’: u’Item Attribute Value’}]}
desk.min.js?ver=1512993594.0:1701 Traceback (most recent call last):
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 324, in upload
validate_naming(doc)
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 179, in validate_naming
autoname = frappe.get_meta(doc[‘doctype’]).autoname
KeyError: u’doctype’

desk.min.js?ver=1512993594.0:1701 {u’item_attribute_values’: [{u’attribute_value’: u’Large’, u’parenttype’: u’Item Attribute’, u’parentfield’: u’item_attribute_values’, u’abbr’: u’L’, u’doctype’: u’Item Attribute Value’}]}
desk.min.js?ver=1512993594.0:1701 Traceback (most recent call last):
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 324, in upload
validate_naming(doc)
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 179, in validate_naming
autoname = frappe.get_meta(doc[‘doctype’]).autoname
KeyError: u’doctype’

desk.min.js?ver=1512993594.0:1701 {u’item_attribute_values’: [{u’attribute_value’: u’Extra Large’, u’parenttype’: u’Item Attribute’, u’parentfield’: u’item_attribute_values’, u’abbr’: u’XL’, u’doctype’: u’Item Attribute Value’}]}
desk.min.js?ver=1512993594.0:1701 Traceback (most recent call last):
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 324, in upload
validate_naming(doc)
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 179, in validate_naming
autoname = frappe.get_meta(doc[‘doctype’]).autoname
KeyError: u’doctype’

I faced the similar problem with other doctypes that are having child tables. So I feel, there is some issue with doctypes having child tables.

Can someone please help me on this.

2

The error log is for several items. To narrow it down, find the error log for one single record below…

{u’item_attribute_values’: [{u’attribute_value’: u’Green’, u’parenttype’: u’Item Attribute’, u’parentfield’: u’item_attribute_values’, u’abbr’: u’GREEN’, u’doctype’: u’Item Attribute Value’}]}
desk.min.js?ver=1512993594.0:1701 Traceback (most recent call last):
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 324, in upload
validate_naming(doc)
File “/home/vamc/frappe-bench/apps/frappe/frappe/core/page/data_import_tool/importer.py”, line 179, in validate_naming
autoname = frappe.get_meta(doc[‘doctype’]).autoname
KeyError: u’doctype’

3

What version are you on?

4

Hi @tundebabzy,

Version details:

frappe 9.2.22
erpnext 9.2.21

6

Hi @tundebabzy,

Thinking that this is an issue, I’ve raised it on GitHub (Issue#11954), but it was closed due to some misunderstanding thinking that we are discussing regarding the functionality on GitHub.

Is this not an issue? Can you replicate it on your system? Or am I doing mistake anywhere?

It is occurring when I have multiple values in the child table. Like, when creating an Item Attribute Color with multiple values like Green, Blue, Red values through Data Import Tool, it is throwing me an error.

Kindly help us on this.

7

Hi Team,

Any update on this. We also are facing same issue where we are not able to upload items that are vairants. It gives the same error

8

Hi @Vishesh_Handa

This is a bug. We will soon update the fix.

9

Hi ,

Thanks for update. We look forward to the same.

10

Hey @ManasSolanki, Similar error I’m getting i.e.

Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/data_import/importer.py", line 358, in upload
    validate_naming(doc)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/data_import/importer.py", line 211, in validate_naming
    if autoname and not doc[autoname]:
KeyError: u'naming_series'

I’m importing customers to the new instance, an older instance is v9 and newer is v10. Can you also look into this?

1 Like
11

I will push a fix for the same.

2 Likes
12

Same issue here on 10.0.0