[GNC] No longer able to import OFX

Mike St. Germaine mstgermaine at gmail.com
Sun Sep 24 16:49:11 EDT 2023


I opened one of the OFX files and every transactions have a FITID of "unknown"
That's certainly what's causing the issue. Seems like the bank is not
even using the FITID appropriately though.
Thank you for the help.

On Sun, Sep 24, 2023 at 12:50 PM Jean Laroche <ripngo at gmail.com> wrote:
>
> I think many people have run into that problem, and some wrote some
> python scripts that modify the bank FITID for example by adding part of
> the date, so it becomes unique. It's a kludge of course, but it works.
>
> You could look for such scripts on github for example, or write your own
> from the available python based ofx libraries
>
> Jean
>
> On 9/24/23 9:18 AM, john wrote:
> >
> >> On Sep 24, 2023, at 07:15, Mike St. Germaine<mstgermaine at gmail.com>  wrote:
> >>
> >> Hello,
> >> At some point earlier in the year I started receiving the attached
> >> message when attempting to import an OFX from Citizens bank (the
> >> message is "found 1 previously imported transactions, no new
> >> transactions" -- the number always matches the number of transactions
> >> i'm trying to import). These are transactions that have definitely not
> >> been imported before. I've been manually entering all transactions for
> >> a while now and that's getting pretty old.
> >> This change seemed to coincide with a major change the bank made to
> >> their website though that could very well be a coincidence.
> >> If I create a new Gnucash file and import the OFX, it works just fine.
> >> It just won't allow me to import to the file I've been using for the
> >> past year or so. Also worth mentioning I'm still able to import OFX
> >> files from other banks with no issue.
> >> I deleted the account assignment through the import map editor but
> >> that didn't work either. It did ask for a new account assignment when
> >> importing but then I just received the same message described above.
> > This problem is usually because your bank is reusing FITID values. Those are supposed to be unique to enable software reading the OFX to identify duplicate transactions.
> >
> > Regards,
> > John Ralls
> >
> >
> > _______________________________________________
> > gnucash-user mailing list
> > gnucash-user at gnucash.org
> > To update your subscription preferences or to unsubscribe:
> > https://lists.gnucash.org/mailman/listinfo/gnucash-user
> > -----
> > Please remember to CC this list on all your replies.
> > You can do this by using Reply-To-List or Reply-All.
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.


More information about the gnucash-user mailing list