[GNC] Import Map Editor - accidentally deleted account
davidcousens49 at gmail.com
davidcousens49 at gmail.com
Fri May 20 05:45:45 EDT 2022
Bogdan,
I have no problem deleting individual match strings in the import map editor in
GC4.10 on Linux mint 20.3. I used to do it occasionally in several of the 3.x
versons as well but I have never deleted all the strings for a given account. It
may be that action which is causing the problem. For some reason the Bayesian
editor includes date information in the account matching so the token database
ends up with a lot of entries with a frequency of 1 or 2 which should have
little or no effect on the Bayesian matching. The matching process is also
different if you have the Bayesian matching disabled although I think it is now
the default matching process.
David.
On Fri, 2022-05-20 at 10:26 +0200, Bogdan wrote:
> Hi David,
> Thanks, that's of course how I tried to delete an individual token - by
> highlighting the item and yet it would delete the entire account. That bug
> happened on several accounts but I can't reproduce it on some other accounts
> where I could delete tokens just fine. So I guess this is something to watch
> out for if other users complain.
> The problem is not so much the loss of the previously created tokens /
> mappings but inability to create new tokens for the account. I've tried to
> start from scratch hoping new imports would create tokens for the account but
> they do not and the account / new mappings simply do not show up in the Import
> Map Editor after new imports. The same is actually true even for newly-created
> accounts - tokens are not recorded on import. What could be wrong?
> Thanks!
>
> On Fri, May 20, 2022 at 2:39 AM <davidcousens49 at gmail.com> wrote:
> > Bogdan,
> > When you open the import map editor it normally shows a list of accounts and
> > each of those accounts has an down arrow to the left of it. If you click on
> > the down arrow the list will expand to show the token entries (match
> > strings) associated with that account. You can then select the specific
> > search strings you want to delete and these will be highlighted. Mmultiple
> > items can be selected using the usual Ctrl-click and Shift-click mechanisms.
> > Only the highlighted strings will then be deleted. If you highlight the
> > account entry at the top of the list then all entries associated with that
> > account get deleted which would appear to be what has happened in your case.
> > Unfortunately there is no undo button so the information is permanently
> > lost. The documentation is in the help manual at
> > https://www.gnucash.org/docs/v4/C/gnucash-help/trans-import.html#:~:text=Import%20Match%20Editor,Map%20Editor%20from%20the%20menu
> > . however the above drop-down action is not documented there. I will patch
> > it to add the above.
> > It might be more appropriate to issue a warning that you are going to delete
> > all match information for an account where the item selected is an account
> > entry rather than an individual match string and ask for confirmation that
> > this is what is intended
> > David Cousens
> > On Fri, 2022-05-20 at 00:29 +0200, Bogdan wrote:
> > > Hello,
> > >
> > > The course of the problem is that I tried to delete a specific mapping for
> > > a specific account in the Import Map Editor and instead it would delete
> > > the entire account with all mappings (that is, in the Map Editor, not the
> > > account itself). That looks like a bug.
> > >
> > > Anyway, it doesn't seem possible to retrain the system by new importing
> > > (and setting values) i.e. identical transactions are not recognized on
> > > subsequent imports. I assume it's because the account is no longer being
> > > mapped to on import (and is not visible anymore in the Map Editor as
> > > mentioned above). Hence my original question on how to re-instate the
> > > account in the datafile / Map Editor for mapping if possible at all?
> > >
> > >
> > >
> > > On Thu, May 19, 2022, 04:14 <davidcousens49 at gmail.com> wrote:
> > > > Bogdan
> > > >
> > > >
> > > >
> > > > AFAIK the import mapping data is stored in the main data file as is the
> > > > price
> > > >
> > > > database data. I don't know if the log files record changes to the
> > > > import map
> > > >
> > > > editor or only transaction changes. I suspect if you have deleted
> > > > something in
> > > >
> > > > the import map editor your only recourse will be to retrain the system
> > > > by
> > > >
> > > > setting the values for unmapped transactions during the import process.
> > > > It
> > > >
> > > > probably pays to have a very good idea of how the import mapping
> > > > functions
> > > >
> > > > before editing the map data as it can have some unwanted consequences.
> > > >
> > > >
> > > >
> > > > David Cousens
> > > >
> > > >
> > > >
> > > > On Wed, 2022-05-18 at 23:45 +0200, Bogdan wrote:
> > > >
> > > > > Hello,
> > > >
> > > > >
> > > >
> > > > > I don't have a "qif-accounts-map" file on my system. I've been
> > > > importing
> > > >
> > > > > OFX rather than QIF format. Where else would the mapping for these
> > > > imports
> > > >
> > > > > be stored?
> > > >
> > > > >
> > > >
> > > > >
> > > >
> > > > > On Wed, May 18, 2022 at 1:28 AM Tommy Trussell <
> > > > tommy.trussell at gmail.com>
> > > >
> > > > > wrote:
> > > >
> > > > >
> > > >
> > > > > > I don't regularly import data, so I am not sure...
> > > >
> > > > > >
> > > >
> > > > > > HOWEVER what happens if you quit GnuCash, move the qif-accounts-map
> > > > file
> > > >
> > > > > > to another place, then open GnuCash and try the import again?
> > > >
> > > > > >
> > > >
> > > > > > https://wiki.gnucash.org/wiki/Configuration_Locations
> > > >
> > > > > >
> > > >
> > > > > > If this is "dangerous" I hope someone jumps in. Since I haven't used
> > > > the
> > > >
> > > > > > importer on this system I don't even see the file, so I presume it
> > > > gets
> > > >
> > > > > > automatically created when necessary during the import process.
> > > >
> > > > > >
> > > >
> > > > > > Please be sure to report back whether thad does or does not work!
> > > >
> > > > > >
> > > >
> > > > > >
> > > >
> > > > > > On Sat, May 14, 2022 at 2:26 AM Bogdan <sinovij at gmail.com> wrote:
> > > >
> > > > > >
> > > >
> > > > > > > Hello, does anybody have a suggestion how to fix the import map
> > > > editor?
> > > >
> > > > > > >
> > > >
> > > > > > > On Wed, May 11, 2022, 12:26 Bogdan <sinovij at gmail.com> wrote:
> > > >
> > > > > > >
> > > >
> > > > > > > > Hi,
> > > >
> > > > > > > >
> > > >
> > > > > > > > I've accidentally deleted several accounts in the Import Map
> > > > Editor -
> > > >
> > > > > > > > Bayesian (actually, I was trying to delete a match string but it
> > > > would
> > > >
> > > > > > > > delete the entire source account with all match strings). Now,
> > > >
> > > > > > > obviously,
> > > >
> > > > > > > > matching on import no longer works for these accounts.
> > > >
> > > > > > > >
> > > >
> > > > > > >
> > > >
> > > > > > > Is there a way to restore it?
> > > >
> > > > > > >
> > > >
> > > > > > > Making a new import does not record the missing account in the
> > > > Import Map
> > > >
> > > > > > > > Editor (and match strings are not recorded).
> > > >
> > > > > > > >
> > > >
> > > > > > > > Thanks!
> > > >
> > > > > > > >
> > > >
> > > > > > > _______________________________________________
> > > >
> > > > > > > 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
> > > >
> > > > > > > If you are using Nabble or Gmane, please see
> > > >
> > > > > > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > >
> > > > > > > -----
> > > >
> > > > > > > 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
> > > >
> > > > > If you are using Nabble or Gmane, please see
> > > >
> > > > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > >
> > > > > -----
> > > >
> > > > > 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
> > > >
> > > > If you are using Nabble or Gmane, please see
> > > > https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> > > >
> > > > -----
> > > >
> > > > 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