[GNC] Question about OFX imports

David Reiser dbreiser at icloud.com
Mon May 13 18:12:37 EDT 2024


> On May 13, 2024, at 17:50, David Carlson <david.carlson.417 at gmail.com> wrote:
> 
> Now it is my turn to ask a question.
> 
> My bank recently had an issue with the description text for a few
> transactions that resulted in the transactions being reposted with
> corrected descriptions.  Now I am trying to import the corrected
> transactions but they do not appear in the OFX importer even though they
> are in the file generated by the bank.
> 
> My question is: If I delete the previously imported transactions, can I
> import the corrected transactions?

yes.

> A corollary; is there any way to check, edit or remove the FITID value of a
> transaction that prevents the duplicate import without doing tricks in the
> OFX file before importing?

only if you are willing to risk damaging your datafile editing it outside of gnucash. The FITID values are stored as a key/value pair like:

        <slot>
          <slot:key>online_id</slot:key>
          <slot:value type="string">20180906246910059666</slot:value>
        </slot>

and finding specific transactions in the raw XML is harder than you might imagine. The online_id is not available to the user anywhere in the gnucash interface.

I have never tried editing a gnucash SQL file outside of gnucash.

> 
> -- 
> David Carlson
> _______________________________________________


--
Dave Reiser
dbreiser at icloud.com







More information about the gnucash-user mailing list