![]() ![]() I made sure there were no transactions for the same date already in GnuCash in case it was not showing them because it thought they were already in GnuCash.īTW the only de-personalising editing I did to the transactions I originally supplied, was to change the transaction values. I tried importing a test file which I edited to have only 2 transactions with unique FITID's (903889 + 903890) but the GnuCash 'List of downloaded transactions' window is still empty. So I should be able to use a script to make them unique, say by using the transaction date, bank FITID, and transaction value. I see from the OFX spec for my version OFX file (102) that FITIDS can be up to 255 chars and it is recommended to keep them <= 32 chars for performance reasons, Yes, it looks like all the interest transactions for the same date have duplicate FITID's. Seem to find incompetence to be embarrassing these days. Perhaps you can embarrass them into fixing their code. If those FITIDs are the bankâs numbers, then they are violating the ofx spec. ![]() Requires manual action on your part during the import. Some help identifying potential duplicates, but confirming the duplicates If qif works for you, Iâd recommend staying with that. Values yourself is likely to negate the primary advantage of ofx vs qif â nearĬertainty of identifying transactions you have already downloaded once The biggest issue you face is that anything you do to fix the FITID FITIDs donât need toīe anything special, they just need to be guaranteed unique forever perĪccount. Import them without modifying the files prior to import. Numbers are the ones provided by the bank, then no, you wonât be able to In your example transactions, the values are identical. ofx file that does import so I can figure out what is different about my file? ![]() Highlight multiple transactions and assign the non-bank account to them inĪlternatively, can some-one please provide a de-personalised example It did take me about 10 transactions before I realised you can I was pretty impressed with the qif import process. Thankfully, this bank allows you to download transactions in csv, ofx I cannot find anything on the bank's website about direct So it seems there is something wrong with the data.ĭoes any know if GnuCash can or cannot import ofx transactions fromĭirectly. ofx file from Australian ING Direct bank and itĪccepts the file but there are no transactions listed in the window, OTOH, banks don’t seem to find incompetence to be embarrassing these days.ĭave mailing remember to CC this list on all your replies. If those FITIDs are the bank’s numbers, then they are violating the ofx spec. Gnucash does provide some help identifying potential duplicates, but confirming the duplicates requires manual action on your part during the import. If qif works for you, I’d recommend staying with that. The biggest issue you face is that anything you do to fix the FITID values yourself is likely to negate the primary advantage of ofx vs qif - near certainty of identifying transactions you have already downloaded once (duplicate transaction rejection). FITIDs don’t need to be anything special, they just need to be guaranteed unique forever per account. If those numbers are the ones provided by the bank, then no, you won’t be able to import them without modifying the files prior to import. Here is a de-personalised extract from my file: ofxįile that does import so I can figure out what is different about my file? Multiple transactions and assign the non-bank account to them in 1 go.Īlternatively, can some-one please provide a de-personalised example. It did take me about 10 transactions before I realised you can highlight Transactions matching unique IDs you have already imported. Then the duplicate recognition is automatic and you never see You the most recent 30 days of data regardless of what you request, You import transactions every week, and your bank insists on sending ![]() OFX transactions contain a unique transaction ID, so that if Thankfully, this bank allows you to download transactions in csv, ofx or qif I cannot find anything on the bank's website about direct connect I'd also like to know if I can use aqbanking to download transactionsĭirectly. The file but there are no transactions listed in the window, so it seemsĭoes any know if GnuCash can or cannot import ofx transactions from this ofx file from Australian ING Direct bank and it accepts ![]()
0 Comments
Leave a Reply. |