GNOME Bugzilla – Bug 790141
Removal of unnecessary listed Account names - when importing
Last modified: 2018-06-30 00:00:35 UTC
Gents After a couple of weeks using GnuCash I made a mistake and renamed some of my accounts. In fact in most cases just changed the name from low-case to upper-case so that I could easily identify the headings. What's happened now is that when I import new data and begin to match the incoming sub accounts with mine in GnuCash I now have two sets of headings to sort through, one in upper-case the other in lower. Is there a way of deleting all the lower case account headings to make the importing of data easier. I do recognise that this is a short term issue as over time the accounts will automatically match the headings correctly but it is a bit of a pain at the moment. I've not been able to find any related information in your support documentation. Any assistance would be much appreciated.
There is a way, but not (yet) from inside GnuCash. The next major version fixes this in two ways: First, the accounts are matched by GUID instead of name and second there's an editor for cleaning out old matches. For the current version the only fix is to edit your data file if you're using the XML backend (be sure to turn off compression in Preferences>General, then save) or use a SQL query if you're using a SQL backend. Make a backup first so that if anything goes wrong you can recover without losing data.
John, That UI applies to the OFX importer. This bug refers to the QIF importer (at least according to the Component). Are you sure that this issue is fixed there? It's a different UI, and the qif-import-map is stored separately, outside the data file, and last I checked it still uses strings.
Derek, Ah, didn't notice that.
GnuCash bug tracking has moved to a new Bugzilla host. The new URL for this bug is https://bugs.gnucash.org/show_bug.cgi?id=790141. Please continue processing the bug there and please update any external references or bookmarks.