Re: [GNC] Sub-accounts disappeared during upgrade 3.5 > 3.7
Are you sure they are really gone? Find a transaction in an account which was the other side of one of the missing sub accounts (so maybe a checking account transaction that went to the Main House expense account for example) open that transaction and see what it shows. Try clicking on the button that takes you to the other side of the transaction (Jump it is labelled I think) and see where it takes you. Colin On Mon, 16 Dec 2019 at 01:37, Paul Kroitor wrote: > > Hello. Rather bizarrely, one group of sub-accounts has disappeared from the > chart of accounts in one of our books. They we there when I last closed the > file in GnuCash 3.5 a few days ago, and they're gone when I first opened them > in 3.7. > > I am wracking my brain trying to understand what's special about this > particular group, but there's nothing I can see that makes them different > from others that didn't disappear. It's a straight-forward chart of accounts, > it has about 15 sub-accounts under expenses, and three of these sub-accounts > are divided into sub-subaccounts. Two of the groups didn't lose their > subaccounts, but one did. > > Specifically, I had: > > Expenses > Groceries > House Insurance > Hydro > Main House > Retreat > A-frame > Meals > Medical > > And now (as soon as it was opened with 3.7) the three sub-sub-accounts under > "Hydro" are gone, and all the bookings in them have been relocated to the > parent account (Hydro). Happily, nothing is actually gone. There are other > sub-accounts with children where this hasn't happened, so I am at a loss. > > Any ideas? It's not too late to roll it all back for trouble-shooting if that > would help resolve it. > Paul > > ___ > 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] Sub-accounts disappeared during upgrade 3.5 > 3.7
Thanks for your reply. Yes, I am sure, at least in terms of everything I can think of to look at. The payments in the chequing account have all been changed to Expenses:Hydro rather than Expenses:Hydro:Main House. More importantly, exporting a Chart of Accounts doesn't show any of the sub-accounts. EXPENSE:"Expenses:Groceries":Groceries::Groceries:::CAD:CURRENCY:F:F:F EXPENSE:"Expenses:House Insurance":House Insurance::House Insurance:::CAD:CURRENCY:F:F:F EXPENSE:"Expenses:Hydro":Hydro::Hydro-Quebec:::CAD:CURRENCY:F:F:F EXPENSE:"Expenses:Meals":Meals::Restaurants, Fast food:::CAD:CURRENCY:F:F:F EXPENSE:"Expenses:Medical Expenses":Medical Expenses::Medical Expenses:::CAD:CURRENCY:F:F:F One thing I did do a couple of weeks back is to check "Only display leaf account names" in the preferences, and I may not have opened the book since then. But surely this is just a display option and doesn't affect the underlying data at all. There are only a couple of dozen transactions, and it's not hard to repair it manually, but I thought I should report the occurrence just in case anyone else see similar weirdness. Paul -Original Message- From: Colin Law Sent: December 16, 2019 6:00 AM To: Paul Kroitor Cc: gnucash-user@gnucash.org Subject: Re: [GNC] Sub-accounts disappeared during upgrade 3.5 > 3.7 Are you sure they are really gone? Find a transaction in an account which was the other side of one of the missing sub accounts (so maybe a checking account transaction that went to the Main House expense account for example) open that transaction and see what it shows. Try clicking on the button that takes you to the other side of the transaction (Jump it is labelled I think) and see where it takes you. Colin On Mon, 16 Dec 2019 at 01:37, Paul Kroitor wrote: > > Hello. Rather bizarrely, one group of sub-accounts has disappeared from the > chart of accounts in one of our books. They we there when I last closed the > file in GnuCash 3.5 a few days ago, and they're gone when I first opened them > in 3.7. > > I am wracking my brain trying to understand what's special about this > particular group, but there's nothing I can see that makes them different > from others that didn't disappear. It's a straight-forward chart of accounts, > it has about 15 sub-accounts under expenses, and three of these sub-accounts > are divided into sub-subaccounts. Two of the groups didn't lose their > subaccounts, but one did. > > Specifically, I had: > > Expenses > Groceries > House Insurance > Hydro > Main House > Retreat > A-frame > Meals > Medical > > And now (as soon as it was opened with 3.7) the three sub-sub-accounts under > "Hydro" are gone, and all the bookings in them have been relocated to the > parent account (Hydro). Happily, nothing is actually gone. There are other > sub-accounts with children where this hasn't happened, so I am at a loss. > > Any ideas? It's not too late to roll it all back for trouble-shooting if that > would help resolve it. > Paul > > ___ > 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] Sub-accounts disappeared during upgrade 3.5 > 3.7
Thanks David, I'm on Win 10, fully patched. I did try to look at the XML data files. Unfortunately I had turned on compression and thus they're not human readable unless someone knows a simple Windows decompression command line (ideally with 7zip, which is already on the box). There are several other place in the CoA that go three levels deep, and none of those have disappeared. The Hydro account, as far as I remember, *was* a placeholder account when it was set up (I wouldn't have wanted entries into it), but it no longer is. I do have all the relevant backup and log files, and am very comfortable working with them. I'm considering restoring the old data file, rolling back to 3.5, and then trying to reproduce the issue. However, it's a fair bit of work at a very busy time of year, and, as I've mentioned elsewhere, it isn't all that hard to repair manually. At your suggestion I've looked at the logfile from the first 3.7 open, which is interesting but not entirely clear to me. Here are my observations: 1. There are indeed entries for the three missing sub-accounts: for each sub-account, there are four pairs of two entries each. All eight entries for a sub-account are identical except for the mod field. Thus = START B ..(seven guids and dates). Auto Main Hydro . B ..(seven guids and dates). Auto Main Hydro . = END = START R ..( seven guids and dates). Auto Main Hydro . R ..( seven guids and dates). Auto Main Hydro . = END = START B ..(seven guids and dates). Auto Main Hydro . B ..(seven guids and dates). Auto Main Hydro . = END = START R ..(seven guids and dates). Auto Main Hydro . R ..(seven guids and dates). Auto Main Hydro . = END Then we get * Eight apparently unrelated entries about a different account * A group just like the above but for "Retreat" rather than Main Hydro * Eight apparently unrelated entries about a different account * A group just like the above for "A-Frame" (Main Hydro, Retreat, and A-Frame being the three missing sub-accounts) 1. These all seem to be about pending automatic entries: there were entries due for creation for all three missing accounts as well as the other accounts interspersed above (but the sub-accounts in the interspersed entries have not disappeared). 1. The titles don't seem to accurately correspond to the data (or maybe they correspond to different record types than are in this log). The titles, after acc_guid, are: "acc_name num description notes memo action reconciled amount value date_reconciled", but the data lines end in "Auto Main Hydro n 0/1 0/100 1970-01-01 00:00:00". Only the first and last of these fields actually correspond. All-in-all I don't see any smoking gun in the log - it seems to me the log file entries I'm seeing might just be normal entries for the scheduled transactions - EXCEPT that there are no dollar amounts anywhere. Paul -- AFAIK there were no data format changes between 3.5 and 3.7. and no previously reported problems of this sort with this upgrade. I moved my data files from 3.5 to 3.7 (on Linux Mint 19.2) with expense subaccount nesting > 4 deep with no problems a few months ago. Are you using the xml datafile or a database backend and what is your OS? I assume the Expenses top level account is a placeholder and similarly with the Hydro subaccount. This is an option in the edit account dialog. If it is a placeholder account then it can't be the target for splits in a transaction. This shouldn't matter anyway as Gnucash can cope with subaccounts summing into a non-placeholder parent account in my experience but I don't know whether that affects it at upgrade. It shouldn't in theory. It has on occasions caused problems with reports though, but not the CoA AFAIK. You should find a series of backup and log files in the same directory as your main data file. If you locate the backup file with a timestamp immediately before you opened the file with 3.7 you could make a copy of it. The logfile for the session in which you first opened it in 3.7 may give some indication of what happened. If there is nothing obvious you could try opening the copy of the backup with 3.7 to check whether the behavior is consistent. To be safe I would make a copy of the whole directory including the backup and log files and keep it pristine and work on a secondary copy until you have isolated how this happened. David Cousens ___ 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
Re: [GNC] Sub-accounts disappeared during upgrade 3.5 > 3.7
The leaf display option would have rendered the opposite effect. You’d have seen only the child (sub-account) names with none of the parents. So instead of: Expenses:Hydro:Main House Expenses:Hydro:Retreat Expenses:Hydro:A-frame you’d see: Main House Retreat A-frame Since it is a small number of transactions, I’d recreate those sub-accounts and then re-assign those splits manually. Certainly though, GnuCash shouldn’t delete and merge sub-accounts without at least a warning. (you can do this intentionally and get a dialog asking what you want to do - merge or delete the transactions) It might be worth filing a bug over, but tracing down the cause and being able to repeat the bug might be tough. Regards, Adrien > On Dec 16, 2019 w51d350, at 8:52 AM, Paul Kroitor wrote: > > Thanks for your reply. > > Yes, I am sure, at least in terms of everything I can think of to look at. > The payments in the chequing account have all been changed to Expenses:Hydro > rather than Expenses:Hydro:Main House. More importantly, exporting a Chart of > Accounts doesn't show any of the sub-accounts. > > EXPENSE:"Expenses:Groceries":Groceries::Groceries:::CAD:CURRENCY:F:F:F > EXPENSE:"Expenses:House Insurance":House Insurance::House > Insurance:::CAD:CURRENCY:F:F:F > EXPENSE:"Expenses:Hydro":Hydro::Hydro-Quebec:::CAD:CURRENCY:F:F:F > EXPENSE:"Expenses:Meals":Meals::Restaurants, Fast food:::CAD:CURRENCY:F:F:F > EXPENSE:"Expenses:Medical Expenses":Medical Expenses::Medical > Expenses:::CAD:CURRENCY:F:F:F > > One thing I did do a couple of weeks back is to check "Only display leaf > account names" in the preferences, and I may not have opened the book since > then. But surely this is just a display option and doesn't affect the > underlying data at all. > > There are only a couple of dozen transactions, and it's not hard to repair it > manually, but I thought I should report the occurrence just in case anyone > else see similar weirdness. > > Paul ___ 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] Sub-accounts disappeared during upgrade 3.5 > 3.7
Yes, I think 7zip can decompress the file. Check the wiki, or maybe a Windows user on the list can help out with doing so. One thing to consider, how do you normally open your GnuCash data file to start working in it? Do you open the GnuCash app and let it open the last used file automatically, or do you click the data file itself? If the latter, are you 100% certain you are looking at a copy of the data file that is current and not one before you created the sub-accounts? That is, did you at one time have only the main Hydro account and then later refactored those transactions to sub-accounts? Perhaps you opened an older copy of the data file before that refactoring. Regards, Adrien > On Dec 16, 2019 w51d350, at 10:12 AM, Paul Kroitor wrote: > > Thanks David, > > I'm on Win 10, fully patched. I did try to look at the XML data files. > Unfortunately I had turned on compression and thus they're not human readable > unless someone knows a simple Windows decompression command line (ideally > with 7zip, which is already on the box). > > There are several other place in the CoA that go three levels deep, and none > of those have disappeared. The Hydro account, as far as I remember, *was* a > placeholder account when it was set up (I wouldn't have wanted entries into > it), but it no longer is. > > I do have all the relevant backup and log files, and am very comfortable > working with them. I'm considering restoring the old data file, rolling back > to 3.5, and then trying to reproduce the issue. However, it's a fair bit of > work at a very busy time of year, and, as I've mentioned elsewhere, it isn't > all that hard to repair manually. > > At your suggestion I've looked at the logfile from the first 3.7 open, which > is interesting but not entirely clear to me. Here are my observations: > > 1. There are indeed entries for the three missing sub-accounts: for each > sub-account, there are four pairs of two entries each. All eight entries for > a sub-account are identical except for the mod field. Thus > = START > B ..(seven guids and dates). Auto Main Hydro . > B ..(seven guids and dates). Auto Main Hydro . > = END > = START > R ..( seven guids and dates). Auto Main Hydro . > R ..( seven guids and dates). Auto Main Hydro . > = END > = START > B ..(seven guids and dates). Auto Main Hydro . > B ..(seven guids and dates). Auto Main Hydro . > = END > = START > R ..(seven guids and dates). Auto Main Hydro . > R ..(seven guids and dates). Auto Main Hydro . > = END > > Then we get > > * Eight apparently unrelated entries about a different account > * A group just like the above but for "Retreat" rather than Main Hydro > * Eight apparently unrelated entries about a different account > * A group just like the above for "A-Frame" > (Main Hydro, Retreat, and A-Frame being the three missing sub-accounts) > > > 1. These all seem to be about pending automatic entries: there were entries > due for creation for all three missing accounts as well as the other accounts > interspersed above (but the sub-accounts in the interspersed entries have not > disappeared). > > > > 1. The titles don't seem to accurately correspond to the data (or maybe > they correspond to different record types than are in this log). The titles, > after acc_guid, are: "acc_name num description notes memo action reconciled > amount value date_reconciled", but the data lines end in "Auto Main Hydro n > 0/1 0/100 1970-01-01 00:00:00". Only the first and last of these fields > actually correspond. > All-in-all I don't see any smoking gun in the log - it seems to me the log > file entries I'm seeing might just be normal entries for the scheduled > transactions - EXCEPT that there are no dollar amounts anywhere. > > Paul ___ 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] Sub-accounts disappeared during upgrade 3.5 > 3.7
Update: after looking at a number of older log files, in which the same entries are present, I've concluded this is just GnuCash's processing of scheduled transactions. I therefore don't see anything in the logs that raises my suspicions. I'm beginning to think this is something that I did myself, either accidentally or as some misguided simplification attempt I've now totally forgotten about. As someone who's developed software for 45-plus years, either of these would be so improbable in the past that they could be dispensed with. But as I get older I find these sources of errors occurring once in a while. Unless others are encountering similar issues I think we might ascribe this one to approaching senility. P From: Paul Kroitor Sent: December 16, 2019 11:12 AM To: 'davidcous...@bigpond.com' Cc: 'gnucash-user@gnucash.org' Subject: Re: [GNC] Sub-accounts disappeared during upgrade 3.5 > 3.7 Thanks David, I'm on Win 10, fully patched. I did try to look at the XML data files. Unfortunately I had turned on compression and thus they're not human readable unless someone knows a simple Windows decompression command line (ideally with 7zip, which is already on the box). There are several other place in the CoA that go three levels deep, and none of those have disappeared. The Hydro account, as far as I remember, *was* a placeholder account when it was set up (I wouldn't have wanted entries into it), but it no longer is. I do have all the relevant backup and log files, and am very comfortable working with them. I'm considering restoring the old data file, rolling back to 3.5, and then trying to reproduce the issue. However, it's a fair bit of work at a very busy time of year, and, as I've mentioned elsewhere, it isn't all that hard to repair manually. At your suggestion I've looked at the logfile from the first 3.7 open, which is interesting but not entirely clear to me. Here are my observations: 1. There are indeed entries for the three missing sub-accounts: for each sub-account, there are four pairs of two entries each. All eight entries for a sub-account are identical except for the mod field. Thus = START B ..(seven guids and dates). Auto Main Hydro . B ..(seven guids and dates). Auto Main Hydro . = END = START R ..( seven guids and dates). Auto Main Hydro . R ..( seven guids and dates). Auto Main Hydro . = END = START B ..(seven guids and dates). Auto Main Hydro . B ..(seven guids and dates). Auto Main Hydro . = END = START R ..(seven guids and dates). Auto Main Hydro . R ..(seven guids and dates). Auto Main Hydro . = END Then we get * Eight apparently unrelated entries about a different account * A group just like the above but for "Retreat" rather than Main Hydro * Eight apparently unrelated entries about a different account * A group just like the above for "A-Frame" (Main Hydro, Retreat, and A-Frame being the three missing sub-accounts) 1. These all seem to be about pending automatic entries: there were entries due for creation for all three missing accounts as well as the other accounts interspersed above (but the sub-accounts in the interspersed entries have not disappeared). 1. The titles don't seem to accurately correspond to the data (or maybe they correspond to different record types than are in this log). The titles, after acc_guid, are: "acc_name num description notes memo action reconciled amount value date_reconciled", but the data lines end in "Auto Main Hydro n 0/1 0/100 1970-01-01 00:00:00". Only the first and last of these fields actually correspond. All-in-all I don't see any smoking gun in the log - it seems to me the log file entries I'm seeing might just be normal entries for the scheduled transactions - EXCEPT that there are no dollar amounts anywhere. Paul -- AFAIK there were no data format changes between 3.5 and 3.7. and no previously reported problems of this sort with this upgrade. I moved my data files from 3.5 to 3.7 (on Linux Mint 19.2) with expense subaccount nesting > 4 deep with no problems a few months ago. Are you using the xml datafile or a database backend and what is your OS? I assume the Expenses top level account is a placeholder and similarly with the Hydro subaccount. This is an option in the edit account dialog. If it is a placeholder account then it can't be the target for splits in a transaction. This shouldn't matter anyway as Gnucash can cope with subaccounts summing into a non-placeholder parent account in my experience but I don't know whether that affects it at upgrade. It shouldn't in theory. It has on occasions caused problems with reports though, but not the CoA AFAIK. You should find a series of backup and log files in the same directory as your main data file. If you locate the backup file with a tim
Re: [GNC] update quotes hanging
I have built myself a solution for this. I'm not certain why asking
gnucash to add the price quotes hangs for me. However I found that if I
used Python to call the perl script for each individual stock and then
the GNUCash Python API to write the information it all works.
The script "get_quotes.py" in the repository
https://github.com/jpschewe/gnucash-stock-portfolio implements this. It
looks for stocks and mutual funds that have non-zero balances and have
online quotes enabled. It respects the alphavantage API rate limit and
has an automatic backoff.
Note that this is a fork of a repository from Henning Jacobs. I found
that repository to have a good start on this and a nice patch for
ensuing that GncPrice objects are properly created.
Jon Schewe
On 9/24/19 5:43 AM, Jon Schewe wrote:
I took my gnucash file and stripped out everything except the price
database and the commodities and found the same behavior. Since this
doesn't have any personal information, other than which commodities
I'm watching, I'm comfortable sharing it. Perhaps someone else has a
configuration that works and I can replicate it.
I'm running "gnucash --add-price-quotes accounts.gnucash".
On 9/24/19 5:09 AM, Jon Schewe wrote:
According to gnc-fq-check I have 1.47. The 5 quotes/minute
restriction would explain why when I ran the gnc-fq-dump commands
manually I didn't get quotes for a lot of the commodities. However it
doesn't explain the process hanging.
I left it running all night last night in strace and it never finished.
It was sitting here all night:
8835 write(2, "Use of uninitialized value $q[1]"..., 116) = 116
8835 write(2, "Use of uninitialized value $q[2]"..., 116) = 116
8835 write(2, "Use of uninitialized value $q[1]"..., 116 ...>
8826 <... poll resumed> ) = 0 (Timeout)
8826 poll([{fd=11, events=POLLIN}], 1, -1
On 9/23/19 10:25 PM, John Ralls wrote:
Have you updated Finance::Quote to 1.49? It throttles the
Alphavantage requests to comply with their 5 quotes/minute restriction.
You might also consider using yahoo_json for as many non-currency
commodities as you can. Yahoo! still supports the json API and
doesn't require throttling.
Regards,
John Ralls
On Sep 23, 2019, at 6:59 PM, Jon Schewe wrote:
I just tried 3.7.0 from ppa:sicklylife/gnucash and the behavior
hasn't changed.
On 9/23/19 2:25 PM, Adrien Monteleone wrote:
There are no updates to the 2.6 series any longer. 2.6.21 is the
last one and nearly 18 months old. There have been eight 3.x
releases so far.
You can build from source, or there are debs floating around on
the list for 3.7 that you should be able to install on 18.04.
Regards,
Adrien
On Sep 23, 2019 w39d266, at 5:58 AM, Jon Schewe
wrote:
I'm using GnuCash 2.6.19 that ships with Ubuntu 18.04. I'm
finding that the update price quotes process is hanging, both
from within GnuCash and from the command line.
I've created a CSV file of all of my commodities and tested them
individual using gnc-fq-dump and they all return fairly quickly.
Not all of them have valid prices, but none hang. Below is the
script that I have used with cron in the past to update my quotes
at regular intervals.
When the process is running I can strace it and I find that the
perl process is usually in a write call writing "use of
uninitialized value".
Does anyone have suggestions to determine why updating the quotes
is hanging?
Is this a problem with this version of gnucash? I would prefer to
stick with the version of gnucash that comes with my distribution
so that I get automatic updates, however I can build a custom
version if that is what is needed.
#!/bin/sh
ALPHAVANTAGE_API_KEY=XXX
export ALPHAVANTAGE_API_KEY
env $(dbus-launch) sh -c 'trap "kill $DBUS_SESSION_BUS_PID" EXIT;
/usr/bin/gnucash --add-price-quotes
${HOME}/Documents/banking/gnucash/accounts.gnucash' 2>&1 | grep
-v "Found Finance::Quote"
--
http://mtu.net/~jpschewe
___
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.
--
http://mtu.net/~jpschewe
___
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
Re: [GNC] Sub-accounts disappeared during upgrade 3.5 > 3.7
On 16 December 2019 at 16:12, Paul Kroitor said: > Thanks David, > > I'm on Win 10, fully patched. I did try to look at the XML data files. > Unfortunately I had turned on compression and thus they're not human > readable unless someone knows a simple Windows decompression command line > (ideally with 7zip, which is already on the box). Doesn't 7zip show up on the Explorer right-click menu? It does on my system. If not then you could copy the file renaming the copy to .gz and that should get recognised (it's what I used to do on Win2K, where 7zip didn't install itself suitably - can't recall exact details). ___ 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] Sub-accounts disappeared during upgrade 3.5 > 3.7
No need for 7-Zip or any such decompression program, just go to Preferences >> General and uncheck the compress files option and save the file to save it as uncompressed Cheers Dave H. On Tue, 17 Dec 2019 at 02:14, Paul Kroitor wrote: > Thanks David, > > I'm on Win 10, fully patched. I did try to look at the XML data files. > Unfortunately I had turned on compression and thus they're not human > readable unless someone knows a simple Windows decompression command line > (ideally with 7zip, which is already on the box). > > There are several other place in the CoA that go three levels deep, and > none of those have disappeared. The Hydro account, as far as I remember, > *was* a placeholder account when it was set up (I wouldn't have wanted > entries into it), but it no longer is. > > I do have all the relevant backup and log files, and am very comfortable > working with them. I'm considering restoring the old data file, rolling > back to 3.5, and then trying to reproduce the issue. However, it's a fair > bit of work at a very busy time of year, and, as I've mentioned elsewhere, > it isn't all that hard to repair manually. > > At your suggestion I've looked at the logfile from the first 3.7 open, > which is interesting but not entirely clear to me. Here are my observations: > > 1. There are indeed entries for the three missing sub-accounts: for > each sub-account, there are four pairs of two entries each. All eight > entries for a sub-account are identical except for the mod field. Thus > = START > B ..(seven guids and dates). Auto Main Hydro . > B ..(seven guids and dates). Auto Main Hydro . > = END > = START > R ..( seven guids and dates). Auto Main Hydro . > R ..( seven guids and dates). Auto Main Hydro . > = END > = START > B ..(seven guids and dates). Auto Main Hydro . > B ..(seven guids and dates). Auto Main Hydro . > = END > = START > R ..(seven guids and dates). Auto Main Hydro . > R ..(seven guids and dates). Auto Main Hydro . > = END > > Then we get > > * Eight apparently unrelated entries about a different account > * A group just like the above but for "Retreat" rather than Main Hydro > * Eight apparently unrelated entries about a different account > * A group just like the above for "A-Frame" > (Main Hydro, Retreat, and A-Frame being the three missing sub-accounts) > > > 1. These all seem to be about pending automatic entries: there were > entries due for creation for all three missing accounts as well as the > other accounts interspersed above (but the sub-accounts in the interspersed > entries have not disappeared). > > > > 1. The titles don't seem to accurately correspond to the data (or maybe > they correspond to different record types than are in this log). The > titles, after acc_guid, are: "acc_name num description notes memo action > reconciled amount value date_reconciled", but the data lines end in "Auto > Main Hydro n 0/1 0/100 1970-01-01 00:00:00". Only the first and last of > these fields actually correspond. > All-in-all I don't see any smoking gun in the log - it seems to me the log > file entries I'm seeing might just be normal entries for the scheduled > transactions - EXCEPT that there are no dollar amounts anywhere. > > Paul > > -- > > > AFAIK there were no data format changes between 3.5 and 3.7. and no > previously reported problems of this sort with this upgrade. I moved my > data files from 3.5 to 3.7 (on Linux Mint 19.2) with expense subaccount > nesting > 4 deep with no problems a few months ago. Are you using the xml > datafile or a database backend and what is your OS? I assume the Expenses > top level account is a placeholder and similarly with the Hydro subaccount. > This is an option in the edit account dialog. If it is a placeholder > account then it can't be the target for splits in a transaction. This > shouldn't matter anyway as Gnucash can cope with subaccounts summing into a > non-placeholder parent account in my experience but I don't know whether > that affects it at upgrade. It shouldn't in theory. It has on occasions > caused problems with reports though, but not the CoA AFAIK. > > You should find a series of backup and log files in the same directory as > your main data file. If you locate the backup file with a timestamp > immediately before you opened the file with 3.7 you could make a copy of it. > The logfile for the session in which you first opened it in 3.7 may give > some indication of what happened. If there is nothing obvious you could try > opening the copy of the backup with 3.7 to check whether the behavior is > consistent. To be safe I would make a copy of the whole directory including > the backup and log files and keep it pristine and work on a secondary copy > until you have isolated how this happened. > > David Cousens > > ___
