Re: [GNC] No longer able to import OFX
On 24 September 2023 at 10:15, Mike St. Germaine said: > 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. Thank you. Mike S. That suggests that the bank is reusing the "unique" transaction numbers. Not a lot you can do about that except go through the file changing them. ___ gnucash-user mailing list gnucash-user@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.
Re: [GNC] No longer able to import OFX
> On Sep 24, 2023, at 07:15, Mike St. Germaine 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@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.
Re: [GNC] No longer able to import OFX
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 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@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@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.
Re: [GNC] No longer able to import OFX
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 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 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@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@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@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.