Re: [GNC] Selective Export of Transactions omitting sub-accounts
> On 13 Aug 2019, at 09:36, Michael Hendry wrote: > >> On 13 Aug 2019, at 08:48, Adrien Monteleone >> wrote: >> >> I have a somewhat detailed asset tree, but I did a test on a subset of it. >> >> I have the following: >> >> Assets:Current Assets:Currency >> >> And under that I have: >> >> Cash in Wallet >> Coin Jar >> Envelopes >> >> The latter was for an experiment trying to shoehorn the envelope method into >> GnuCash. (nutshell - it doesn’t really work without lots of effort) >> >> ‘Coin Jar’ has some sub-accounts and one of them has more subs. >> >> I planned to do two exports as a test: >> >> 1 - Cash in Wallet & Coin Jar including all sub accounts >> 2 - Envelopes >> >> This should fulfill the criteria since these are at least 4 levels down in >> the Asset tree. If one or both fails, but an export of the entire Asset tree >> works, then I’d say I’ve reproduced your bug. >> >> I stopped on the first test because I got a CSV with all transactions from >> every account in that part of the tree. >> >> Note, each transaction appears only once. So where there are moves between >> ‘Cash in Wallet’ and Coin Jar sub-accounts, (that one is a placeholder) they >> are not duplicated later in the file when the Coin Jar subs are listed. This >> makes sense because otherwise a re-import would result in duplicate >> transactions. >> >> It just so happens that I had some unique transactions in each and every >> sub-account that didn’t involve any of the others so every account was >> represented. >> >> It is possible that in your case, duplicates would have resulted, so that is >> why you only saw the one account. >> >> Or else in your case, you found a bug that I can’t reproduce. >> >> Regards, >> Adrien > > Thanks, Adrien, > > With your help, I’ve now completed the transfer of these accounts, so my > earlier setup has been superseded. > > I suspect you may be right, in that not all (and perhaps none) of these > sub-accounts would have had transactions in them, but I’m fairly sure that > there were transactions in the CSV for the sub-accounts when everything in > the Liabilities tree was exported, rather than the selective export of a > branch. > > I’ll have to go to a backup from yesterday and experiment with it to see if > that’s what’s been going on. Maybe later... > > Regards, > > Michael Have done the above, and confirmed that you were right. I had set up the sub accounts for later use, but hadn’t put any dummy transactions into them, so there were no transactions for export! I had previously used the "Export to CSV —> Edit CSV —> Import" cycle to duplicate sub-accounts, which works OK because transactions aren’t required in that context. Humiliating spurious bug-report avoided! Regards, Michael ___ 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] Selective Export of Transactions omitting sub-accounts
> On 13 Aug 2019, at 08:48, Adrien Monteleone > wrote: > > I have a somewhat detailed asset tree, but I did a test on a subset of it. > > I have the following: > > Assets:Current Assets:Currency > > And under that I have: > > Cash in Wallet > Coin Jar > Envelopes > > The latter was for an experiment trying to shoehorn the envelope method into > GnuCash. (nutshell - it doesn’t really work without lots of effort) > > ‘Coin Jar’ has some sub-accounts and one of them has more subs. > > I planned to do two exports as a test: > > 1 - Cash in Wallet & Coin Jar including all sub accounts > 2 - Envelopes > > This should fulfill the criteria since these are at least 4 levels down in > the Asset tree. If one or both fails, but an export of the entire Asset tree > works, then I’d say I’ve reproduced your bug. > > I stopped on the first test because I got a CSV with all transactions from > every account in that part of the tree. > > Note, each transaction appears only once. So where there are moves between > ‘Cash in Wallet’ and Coin Jar sub-accounts, (that one is a placeholder) they > are not duplicated later in the file when the Coin Jar subs are listed. This > makes sense because otherwise a re-import would result in duplicate > transactions. > > It just so happens that I had some unique transactions in each and every > sub-account that didn’t involve any of the others so every account was > represented. > > It is possible that in your case, duplicates would have resulted, so that is > why you only saw the one account. > > Or else in your case, you found a bug that I can’t reproduce. > > Regards, > Adrien Thanks, Adrien, With your help, I’ve now completed the transfer of these accounts, so my earlier setup has been superseded. I suspect you may be right, in that not all (and perhaps none) of these sub-accounts would have had transactions in them, but I’m fairly sure that there were transactions in the CSV for the sub-accounts when everything in the Liabilities tree was exported, rather than the selective export of a branch. I’ll have to go to a backup from yesterday and experiment with it to see if that’s what’s been going on. Maybe later... Regards, Michael ___ 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] Selective Export of Transactions omitting sub-accounts
I have a somewhat detailed asset tree, but I did a test on a subset of it. I have the following: Assets:Current Assets:Currency And under that I have: Cash in Wallet Coin Jar Envelopes The latter was for an experiment trying to shoehorn the envelope method into GnuCash. (nutshell - it doesn’t really work without lots of effort) ‘Coin Jar’ has some sub-accounts and one of them has more subs. I planned to do two exports as a test: 1 - Cash in Wallet & Coin Jar including all sub accounts 2 - Envelopes This should fulfill the criteria since these are at least 4 levels down in the Asset tree. If one or both fails, but an export of the entire Asset tree works, then I’d say I’ve reproduced your bug. I stopped on the first test because I got a CSV with all transactions from every account in that part of the tree. Note, each transaction appears only once. So where there are moves between ‘Cash in Wallet’ and Coin Jar sub-accounts, (that one is a placeholder) they are not duplicated later in the file when the Coin Jar subs are listed. This makes sense because otherwise a re-import would result in duplicate transactions. It just so happens that I had some unique transactions in each and every sub-account that didn’t involve any of the others so every account was represented. It is possible that in your case, duplicates would have resulted, so that is why you only saw the one account. Or else in your case, you found a bug that I can’t reproduce. Regards, Adrien > On Aug 13, 2019, at 2:30 AM, Michael Hendry wrote: > >> On 13 Aug 2019, at 08:07, Adrien Monteleone >> wrote: >> >> Sorry, I forgot to include that in order to see the Income option for type, >> you need to first choose an Income account as a parent. (or make it another >> top level account) >> >> Regards, >> Adrien > > Thanks, Adrien. > > That solved the problem of switching my accounts around in seconds! > > Can you confirm the issue with selective Exporting of Transactions? > > I’d rather not burden Bugzilla with a non-bug because I misunderstood what > was supposed to happen! > > Regards, > > Michael > > ___ 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] Selective Export of Transactions omitting sub-accounts
> On 13 Aug 2019, at 08:07, Adrien Monteleone > wrote: > > Sorry, I forgot to include that in order to see the Income option for type, > you need to first choose an Income account as a parent. (or make it another > top level account) > > Regards, > Adrien Thanks, Adrien. That solved the problem of switching my accounts around in seconds! Can you confirm the issue with selective Exporting of Transactions? I’d rather not burden Bugzilla with a non-bug because I misunderstood what was supposed to happen! Regards, Michael ___ 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] Selective Export of Transactions omitting sub-accounts
Sorry, I forgot to include that in order to see the Income option for type, you need to first choose an Income account as a parent. (or make it another top level account) Regards, Adrien > On Aug 13, 2019, at 2:06 AM, Adrien Monteleone > wrote: > > Changing the account type to Income first should allow the deletion and > re-assignment. > > Since they are both credit type accounts, you are fortunate not to have the > debits and credits reversed. > > Regards, > Adrien > >> On Aug 13, 2019, at 1:42 AM, Michael Hendry wrote: >> >> I have set up some accounts as Liabilities and want to change them to >> Income. This can’t be done by deleting the accounts and transferring the >> transactions to another account because only Liability Accounts are offered >> as alternative destinations. >> >> I would like to export the transactions to CSV, edit the Liability Account >> references to make them refer to Income, and import the resulting CSV. >> >> Let’s say I have the following accounts: >> >> L:A:B >> L:C:D >> >> I use File—>Export—>Export Transactions to CSV, and select the accounts in >> L:A:B (ignoring L:C:D). GC highlights the appropriate accounts in blue and >> leaves the unwanted ones. >> >> The resulting CSV file ignores B, including only transactions in L:A, and >> not L:A’s sub-accounts. >> >> If I select the whole L tree, the resulting CSV file is complete. >> >> Obviously, I can edit out the unwanted transactions, and then adjust the >> destination accounts before I import the result, but I don’t think I should >> need to do it this way. >> >> Am I misunderstanding something, or have I uncovered an "undesirable >> feature" of the "Export Transactions to CSV" process? >> >> Regards, >> >> Michael ___ 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] Selective Export of Transactions omitting sub-accounts
I have set up some accounts as Liabilities and want to change them to Income. This can’t be done by deleting the accounts and transferring the transactions to another account because only Liability Accounts are offered as alternative destinations. I would like to export the transactions to CSV, edit the Liability Account references to make them refer to Income, and import the resulting CSV. Let’s say I have the following accounts: L:A:B L:C:D I use File—>Export—>Export Transactions to CSV, and select the accounts in L:A:B (ignoring L:C:D). GC highlights the appropriate accounts in blue and leaves the unwanted ones. The resulting CSV file ignores B, including only transactions in L:A, and not L:A’s sub-accounts. If I select the whole L tree, the resulting CSV file is complete. Obviously, I can edit out the unwanted transactions, and then adjust the destination accounts before I import the result, but I don’t think I should need to do it this way. Am I misunderstanding something, or have I uncovered an "undesirable feature" of the "Export Transactions to CSV" process? Regards, Michael ___ 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.