ERPNext DATEV-kompatibel machen

rmeyer · February 14, 2019, 10:14am

Statement von @charterware zum Thema:

[Technisch]
Vorschlag, individuelle CSV-Dialekte, also das DATEV-Format, zu ermöglichen:

github.com/frappe/frappe

[Proposal] Custom CSV Dialect

opened 08:03PM - 13 Feb 19 UTC

closed 10:15PM - 09 Jul 19 UTC

barredterra

## Use-case * Data is exported to be imported into another application. * S…ome applications only support one specific CSV dialect. (For example, the German tax consultancy software DATEV) * We need to give developers and administrators the choice to provide the dialect. This will support the DRY principle, removing the need for case-specific implementations like this one: https://github.com/frappe/erpnext/blob/master/erpnext/regional/report/fichier_des_ecritures_comptables_[fec]/fichier_des_ecritures_comptables_[fec].js#L91-L97 ## Proposal 1. Add Doctype "CSV Dialect" to frappe core. 2. Extend UnicodeWriter to consider CSV Dialect ### 1. Add Doctype "CSV Dialect" **Proposed location:** `frappe.core.doctype.csv_dialect` **Screenshots:** ![Some useful dialects](https://user-images.githubusercontent.com/14891507/54562769-ee7d0100-49c7-11e9-80b0-3ea9a2d34ef0.png) ![Dialect for German accounting monopolist](https://user-images.githubusercontent.com/14891507/54562604-a2ca5780-49c7-11e9-8850-86bb20740a57.png) **Fields:** Name | Type | Default -----|------|--------- Quoting | Select | Minimal Quote Character | Data | " Delimiter| Data | , Doublequote | Checkbox | 1 Escape Character | Data | None Line Terminator | Data | \r\n Write Header | Checkbox | 1 Encoding | Data | utf-8 **DocType**: https://github.com/alyf-de/frappe/blob/csv_dialect/frappe/core/doctype/csv_dialect/csv_dialect.json ### 2. Extend UnicodeWriter Current: https://github.com/frappe/frappe/blob/bd2e410a02758733fd499273f497c13de25dced8/frappe/utils/csvutils.py#L96-L116 https://github.com/frappe/frappe/blob/d0e7690ae2f219c1688411a19f952179f885528d/frappe/public/js/frappe/misc/tools.js#L67-L77 Proposed: https://github.com/alyf-de/frappe/blob/csv_dialect/frappe/core/doctype/csv_dialect/csv_dialect.py ### 3. Give users the choice In `Report > Menu > Export > CSV`, provide a link field to choose the CSV Dialect. Provided CSV shall conform to the dialect. ## Result Before a call to `to_csv` is made, we can ask the user to select a dialect which suits the target application. Required templates should come preinstalled and be set as default. Thanks for reviewing. Maybe from @anandpdoshi who built the csv export?