Weird OFX file import problem

msalists at gmx.net msalists at gmx.net
Wed Oct 1 20:19:25 EDT 2014


Hi John,

no, it's definitely different transactions for different months in there .

Looking at the OFX file in a text editor, which tag / element are the 
OFX transaction IDs you mentioned that need to be different?
There is a <TRNUID>, which is different in both files (basically the 
file download/generation date), but that is in the outer envelope of the 
download, not inside each individual transaction.

Thank you,

Mark


On 2014-10-01 17:00, John Ralls wrote:
> On Oct 1, 2014, at 11:02 AM, msalists at gmx.net wrote:
>
>>    Hello,
>>    I have a problem with importing OFX files.
>>    The very first import into a newly created account works, but trying to
>>    import additional OFX files for the same account comes up with no
>>    transactions to be imported.
>>    Using an entirely new GnuCash file (sqlite storage), I narrowed it down
>>    to the following:
>>    I have two OFX files from the same bank (Targobank Germany, ex
>>    Citibank).
>>    File A.ofx is from June, file B.ofx is from October.
>>    I have only the basic account structure setup, no bank account set up
>>    yet.
>>    I import A.OFX and chose to create a new bank account "Targo" in the
>>    process.
>>    The transaction import dialog comes up with the list of all
>>    transactions and I import them without changing anything.
>>    Then I proceed to import B.ofx. The transaction import dialog comes up
>>    empty with no transactions.
>>    In order to show that file B.ofx in itself has no problems, I remove
>>    the account "Targo" and chose to delete all transactions in it.
>>    Then I import B.ofx, and chose to create a new account "Targo2" the
>>    process.
>>    This time, the transaction import dialog comes up with all the
>>    transactions in B.ofx.
>>    I import them without changing anything.
>>    Then I try importing A.ofx, which fimported fine earlier. This time,
>>    the transaction import dialog comes up empty.
>>    The transaction that had been listed earlier when importing into a new
>>    account "Targo" do no longer show up.
>>    What could be the problem here?
>>    Thank you in advance for any help...
> That probably means either that the two files contain the same transactions, so once you've imported them GnuCash won't import them again. If that's not the case, it means that your bank is reusing OFX transaction IDs. That would be bad, because it would mean that you can't use OFX to import more than once.
>
> Regards,
> John Ralls
>
>
>



More information about the gnucash-user mailing list