I tried your example code, and I'm sorry to say "it works for me". Took a
bit to extract it from the email (NBSP is not my friend) but here's what I
see when running it locally:
$ python3 m.py
Root
Expenses
I'm assuming you get an error of some sort?
If I import the create_accounts() method into an interactive session, (and
open up a session of my own) I see:
>>> root_acct.get_children()
[<gnucash.gnucash_core.Account object at 0x7fb778446120>,
<gnucash.gnucash_core.Account object at 0x7fb778444da0>,
<gnucash.gnucash_core.Account object at 0x7fb77804d9a0>]
>>> [ca.name for ca in root_acct.get_children()]
['Expenses', 'Savings', 'Opening Balance']
>>>
This is on Ubuntu 24.04.1, using system installed gnucash and
python3-gnucash packages.
Ross
On Sat, Sep 28, 2024 at 3:43 PM Eberhard Beilharz <e...@sil.org> wrote:
> Hi,
>
> I'm trying to create a Python script with the GnuCash API. I started
> with the `simple_test.py` sample and extended that a bit (see below).
> However, I ran into a problem: after re-opening the session and getting
> the root account, it doesn't show any child accounts. I tried different
> ways, but no luck. I guess that I'm missing something, but I don't know
> what because all the examples I could find do it the same way, and
> things work when newly creating the file and accounts.
>
> Any ideas?
>
> Thanks,
> Eberhard
>
> GnuCash 5.8 built from git
>
> #!/usr/bin/env python3
>
> from gnucash import (
> Session, Account, Transaction, Split, GncNumeric, SessionOpenMode)
>
> FILE_1 = "/tmp/example3.gnucash"
>
> def create_accounts():
> with Session("xml://%s" % FILE_1,
> SessionOpenMode.SESSION_NEW_OVERWRITE) as session:
>
> book = session.book
> root_acct = Account(book)
> expenses_acct = Account(book)
> savings_acct = Account(book)
> opening_acct = Account(book)
> trans1 = Transaction(book)
> trans1.BeginEdit()
> trans2 = Transaction(book)
> trans2.BeginEdit()
>
> split1 = Split(book)
> split3 = Split(book)
> comm_table = book.get_table()
> cad = comm_table.lookup("CURRENCY", "CAD")
>
> num1 = GncNumeric(4, 1)
> num2 = GncNumeric(100, 1)
>
> #Set new root account
> book.set_root_account(root_acct)
>
> #Set up root account and add sub-accounts
> root_acct.SetName("Root")
> root_acct.SetType(13) #ACCT_TYPE_ROOT = 13
> root_acct.append_child(expenses_acct)
> root_acct.append_child(savings_acct)
> root_acct.append_child(opening_acct)
>
> #Set up Expenses account
> expenses_acct.SetCommodity(cad)
> expenses_acct.SetName("Expenses")
> expenses_acct.SetType(9) #ACCT_TYPE_EXPENSE = 9
>
> #Set up Savings account
> savings_acct.SetCommodity(cad)
> savings_acct.SetName("Savings")
> savings_acct.SetType(0) #ACCT_TYPE_BANK = 0
>
> #Set up Opening Balance account
> opening_acct.SetCommodity(cad)
> opening_acct.SetName("Opening Balance")
> opening_acct.SetType(10) #ACCT_TYPE_EQUITY = 10
>
> split1.SetValue(num1)
> split1.SetAccount(expenses_acct)
> split1.SetParent(trans1)
>
> split3.SetValue(num2)
> split3.SetAccount(savings_acct)
> split3.SetParent(trans2)
>
> trans1.SetCurrency(cad)
> trans1.SetDate(14, 3, 2006)
> trans1.SetDescription("Groceries")
>
> trans2.SetCurrency(cad)
> trans2.SetDate(7, 11, 1995)
> trans2.SetDescription("Opening Savings Balance")
>
> split2 = Split(book)
> split2.SetAccount(savings_acct)
> split2.SetParent(trans1)
> split2.SetValue(num1.neg())
>
> split4 = Split(book)
> split4.SetAccount(opening_acct)
> split4.SetParent(trans2)
> split4.SetValue(num2.neg())
>
> trans1.CommitEdit()
> trans2.CommitEdit()
> session.save()
> session.end()
>
>
> def read_accounts():
> with Session("xml://%s" % FILE_1,
> SessionOpenMode.SESSION_READ_ONLY) as session:
> book = session.book
> root_acct = book.get_root_account()
> print(root_acct.name)
> expenses_acct = root_acct.nth_child(0)
> print(expenses_acct.name)
> savings_acct = root_acct.lookup_by_name("Savings")
>
>
> create_accounts()
> read_accounts()
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user@gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> 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
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
