Re: Import of bank transaction/statement data, QIF ? - GnuCash

[of...@nym.hush.com]

Taher,

using GnuCash as a proxy or scavenging it as appropriate is a nice 
idea.  I will take that into consideration.

THX



On Fri, 03 Jul 2015 14:05:21 +0200 "Taher Alkhateeb" 
<sl...@gmail.com> wrote:
>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" <sh...@gmail.com> 
>To: user@ofbiz.apache.org 
>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.