Erpnext: Data Import Tool would Fail if we Use LibreOffice XLSX format

[adityaduggal]

Hi,

This is with reference to WN-SUP30878, wherein DATA IMPORT fails with below error:

Traceback (most recent call last):
  File "/home/frappe/frappe-bench/apps/frappe/frappe/core/doctype/data_import/importer.py", line 385, in upload
    doc = frappe.get_doc(doc)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/__init__.py", line 638, in get_doc
    return frappe.model.document.get_doc(*args, **kwargs)
  File "/home/frappe/frappe-bench/apps/frappe/frappe/model/document.py", line 68, in get_doc
    return controller(*args, **kwargs)
TypeError: __init__() keywords must be strings

This issue can be reproduced by following the below steps:

1. Use a computer which has LIBREOFFICE Version: 5.1.6.2 (tested with this version), but I guess it should be an issue with open office as well.
2. Now goto data import tool
3. Download the XLSX template file for the desired doctype.
4. Populate it with data you want to import and upload the sheet.

Kindly note that if you download the Template with MS Office and do the steps then there is no issue.
I am enclosing a XLSX file which is giving this error, please note that this xlsx file is made with Libreoffice.

Journal_Entry.xlsx

[adityaduggal]

@rohitwaghchaure This issue was moved from a support ticket to github issues but I guess it has not got any attention, I know it might not be a priority for the team for this issue but I guess since erpnext is open source it should support open source softwares and it has been 2 months I closed this support ticket.

[garyritchie]

I've been using LibreOffice Calc and the xlsx format was working fine. What I did learn was to include the "accounts" column: https://github.com/frappe/frappe/issues/4282#issuecomment-440045449
Maybe that will help your situation?