Re: [GNC] Import Map Editor - accidentally deleted account
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 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 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 > > > > >
Re: [GNC] Import Map Editor - accidentally deleted account
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 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 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 > > > 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 wrote: > > > > > > > Hello, does anybody have a suggestion how to fix the import map > editor? > > > > > > > > On Wed, May 11, 2022, 12:26 Bogdan 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, >
Re: [GNC] Import Map Editor - accidentally deleted account
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 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 > > > 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 wrote: > > > > > > > Hello, does anybody have a suggestion how to fix the import map > editor? > > > > > > > > On Wed, May 11, 2022, 12:26 Bogdan 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@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@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@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@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.
Re: [GNC] Import Map Editor - accidentally deleted account
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 > 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 wrote: > > > > > Hello, does anybody have a suggestion how to fix the import map editor? > > > > > > On Wed, May 11, 2022, 12:26 Bogdan 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@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@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@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.
Re: [GNC] Import Map Editor - accidentally deleted account
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 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 wrote: > >> Hello, does anybody have a suggestion how to fix the import map editor? >> >> On Wed, May 11, 2022, 12:26 Bogdan 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@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@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.
Re: [GNC] Import Map Editor - accidentally deleted account
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 wrote: > Hello, does anybody have a suggestion how to fix the import map editor? > > On Wed, May 11, 2022, 12:26 Bogdan 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@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@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.
Re: [GNC] Import Map Editor - accidentally deleted account
Hello, does anybody have a suggestion how to fix the import map editor? On Wed, May 11, 2022, 12:26 Bogdan 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@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.
[GNC] Import Map Editor - accidentally deleted account
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@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.