Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

There's no way to cancel an OFX import "unknown account" #408

Closed
iffy opened this issue Jul 8, 2019 · 4 comments
Closed

There's no way to cancel an OFX import "unknown account" #408

iffy opened this issue Jul 8, 2019 · 4 comments
Labels
included in next release The work is done, it's just waiting to be released. papercut Annoying things
Milestone

Comments

@iffy
Copy link
Contributor

iffy commented Jul 8, 2019

Related to #324, if you import an OFX file for an unknown account, the unknown account lingers without a way to remove it.

@dragos240
Copy link

Just commenting that this bug still exists and that it's still an issue.

However for those still having this issue, I do have a fix. Open the Buckets database with your SQLite client of choice and one of the tables contains unlinked accounts. You can delete the row belonging to that import from there. Just make sure you backup your Buckets database (by creating a copy) and making sure Buckets is closed. Once you do this, the unlinked account will disappear.

@iffy iffy added this to the v1 milestone Dec 7, 2021
@iffy
Copy link
Contributor Author

iffy commented Dec 14, 2021

You can use the debugger within Buckets to run the SQL (until this issue is fixed):

  1. Make a backup of your budget file (as @dragos240 said)!
  2. Click Tools > Debugger
  3. Paste this into the SQL Query box: DELETE FROM unknown_account
  4. Click Run
  5. Maybe you have to close and restart? Maybe not.

@iffy iffy added the papercut Annoying things label Dec 14, 2021
@gitchap
Copy link

gitchap commented Dec 30, 2021

I have a similar issue with one of my banks (Alliant Credit Union) having multiple entries for each account.

(Seems like once a year or so some kind of system maintenance makes copies of all the accounts and the old versions -- with no new activity -- hang around in the system indefinitely.)

Even if I clear the list, they come back every time I sync. Would be great to have an option to move them to an "ignored accounts" list. Current workaround is to add them as off budget, then close them, but that's messy. :)

@iffy iffy added the included in next release The work is done, it's just waiting to be released. label Feb 10, 2022
@iffy
Copy link
Contributor Author

iffy commented Feb 17, 2022

Included in v0.65.0 release (AUTOMATED COMMENT)

@iffy iffy closed this as completed Feb 17, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
included in next release The work is done, it's just waiting to be released. papercut Annoying things
Projects
None yet
Development

No branches or pull requests

3 participants