Hello, To continue with what Jacques and Sharan stated, OFBiz does not support QIF, OFX or QFX out of the box. With that being said, you only need to understand a few entities (tables) to map your source data to. The main entities coming to mind are AcctgTrans, AcctgTransEntry and GlAccount.
Anyway, don't start from scratch as someone almost always did it for you. From research I found this Java library for importing / exporting QIF -> https://code.google.com/p/jqif/. Are you by the way bringing this data from GnuCash? Cheers, Taher Alkhateeb ----- Original Message ----- From: "Sharan-F" <[email protected]> To: [email protected] Sent: Friday, 3 July, 2015 2:17:52 PM Subject: Re: Import of bank transaction/statement data, QIF ? Thanks for the recommendation Jacques. The book doesn't cover importing bank statements.(although there is a small appendix about importing data via the webtools menu) I think that if you want to look at importing a bank statement then an xml import is the way to go (so if you can convert it to xml you can import it). Effectively all you are doing is importing transactions. The challenge you may have is going to be the format and linking with the GL and other areas. I'd suggest you look at importing it as a financial account bank account to start with. That way you can have a play around with the different statuses and reconciliations available and posting the transactions to the GL account you want. It's been a while since I looked at it but I remember some functionality around reconcilation that matches the closing balance of one reconciliation against the following one, which would help as an ongoing balance check for ongoing imports. It's a bit hard to say much more without more information. Anyway, hope this helps. Thanks Sharan -- View this message in context: http://ofbiz.135035.n4.nabble.com/Import-of-bank-transaction-statement-data-QIF-tp4670715p4670740.html Sent from the OFBiz - User mailing list archive at Nabble.com.
