[GNC] Selective Export of Transactions omitting sub-accounts
Michael Hendry
hendry.michael at gmail.com
Tue Aug 13 04:36:38 EDT 2019
> On 13 Aug 2019, at 08:48, Adrien Monteleone <adrien.monteleone at lusfiber.net> 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
More information about the gnucash-user
mailing list