Hi Eberhard
I can't help you with this problem, but for a different approach, this
project manipulates GnuCash via its database instead of using the API:
https://github.com/sdementen/piecash
Regards
Geoff
=====
On 29/09/2024 6:42 am, Eberhard Beilharz 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.
