[GNC] Selective Export of Transactions omitting sub-accounts

[Michael Hendry]

> On 13 Aug 2019, at 09:36, Michael Hendry <hendry.michael at gmail.com> wrote:
> 
>> 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

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