Hi,
I need a way to import my bank transactions from my OFX bank statements (OFX - Open Financial Exchange - Wikipedia).
Today, ERPNext import bank transactions from CSV bank statements files.
How can I support this development?
Hi,
I need a way to import my bank transactions from my OFX bank statements (OFX - Open Financial Exchange - Wikipedia).
Today, ERPNext import bank transactions from CSV bank statements files.
How can I support this development?
@rmehta I already did and got a few answers and then silence for more than 10 days. Could you help me with that?
ERPNext is really missing this featureā¦
āERPNext is really missing this featureā¦ā
What might explain why the lack of initiative?
āThe OFX Protocol is the standard for two-way exchange of financial data.ā
@clarkej right, letās try to investigate the reasons why OFX isnāt being developed.
Lack of Documentation for Community
Our team tried to understand how to start to develop for ERPNext and the lack of clear instructions about how we could contribute to ERPNext + Frappe is a real problem.
Should OFX import be implemented into the Frappe project first or go directly to ERPNext project? What are the code patterns and architecture specifications we should care about?
There is no clear communication or documentation or definition coming from ERPNext+Frappe.
ERPNext Team focus
ERPNext team may be focusing on things they care about and, for small businesses, financial control usually is not a priority - even though it should beā¦
Can you be specific what is amiss here - a forum search on ācontribution guidelinesā also a Google search on āsite: github erpnext guidelinesā turns up advice
āThere is no clear communication or documentation or definition coming from ERPNext+Frappe.ā
In light of the code, the docs and this forum, what more do you require?
I think that this specifies what you are asking:
In that case probably erpnext -
frappe@ubuntu1804lts:~/frappe-bench$ find . -name ābank_*.pyā
./apps/erpnext/erpnext/accounts/doctype/bank_reconciliation_detail/bank_reconciliation_detail.py
./apps/erpnext/erpnext/accounts/doctype/bank_transaction_mapping/bank_transaction_mapping.py
./apps/erpnext/erpnext/accounts/doctype/bank_transaction/bank_transaction.py
./apps/erpnext/erpnext/accounts/doctype/bank_transaction/bank_transaction_upload.py
./apps/erpnext/erpnext/accounts/doctype/bank_statement_transaction_settings_item/bank_statement_transaction_settings_item.py
./apps/erpnext/erpnext/accounts/doctype/bank_statement_transaction_settings/bank_statement_transaction_settings.py
./apps/erpnext/erpnext/accounts/doctype/bank_statement_settings/bank_statement_settings.py
./apps/erpnext/erpnext/accounts/doctype/bank_statement_transaction_entry/bank_statement_transaction_entry.py
./apps/erpnext/erpnext/accounts/doctype/bank_guarantee/bank_guarantee.py
./apps/erpnext/erpnext/accounts/doctype/bank_statement_transaction_invoice_item/bank_statement_transaction_invoice_item.py
./apps/erpnext/erpnext/accounts/doctype/bank_account/bank_account_dashboard.py
./apps/erpnext/erpnext/accounts/doctype/bank_account/bank_account.py
./apps/erpnext/erpnext/accounts/doctype/bank_statement_transaction_payment_item/bank_statement_transaction_payment_item.py
./apps/erpnext/erpnext/accounts/doctype/bank_statement_settings_item/bank_statement_settings_item.py
./apps/erpnext/erpnext/accounts/doctype/bank/bank_dashboard.py
./apps/erpnext/erpnext/accounts/doctype/bank_transaction_payments/bank_transaction_payments.py
./apps/erpnext/erpnext/accounts/doctype/bank_reconciliation/bank_reconciliation.py
./apps/erpnext/erpnext/accounts/report/bank_clearance_summary/bank_clearance_summary.py
./apps/erpnext/erpnext/accounts/report/bank_reconciliation_statement/bank_reconciliation_statement.py
./apps/erpnext/erpnext/accounts/page/bank_reconciliation/bank_reconciliation.py
./apps/erpnext/erpnext/hr/report/bank_remittance/bank_remittance.py
./env/lib/python3.6/site-packages/stripe/api_resources/bank_account.py
./env/lib/python3.6/site-packages/gocardless_pro/resources/bank_details_lookup.py
./env/lib/python3.6/site-packages/gocardless_pro/services/bank_details_lookups_service.py
Hereās the file where Bank Statements are uploaded:
As you can see, lines 23 and 27, read_csv_content and read_xlsx_file_from_attached_file functions come from āfrappe.utilsā. So⦠in order to create a function āread_ofx_contentā or something like that I must know where to place it respecting source code patterns, readability and architecture.
Yes in that case you may want to add or modify a method here in frappe
frappe/handler.py at develop Ā· frappe/frappe Ā· GitHub
frappe/file_manager.py at develop Ā· frappe/frappe Ā· GitHub
Your case for user transparency concern can be resolved in due course no?
Frappe and the community can advise you here.
Refactoring can fix problems that ariseā¦