GnuCash and PHP

Derek Atkins warlord at MIT.EDU
Sun Oct 5 21:09:17 EDT 2008


a) could you put this into
b) can you verify that this is what the new dbi-sql-backend looks like?


Quoting Albert Lash <albert.lash at>:

> Hi Jeremy,
> This is a great idea. I've been working on a web-based accounting
> system, and I've been working to get it to use the same SQL backend as
> GnuCash.
> Its not there yet, but I've done some research on the SQL backend,
> though its a little out dated now:
> Albert
> On Sun, Oct 5, 2008 at 8:00 PM, Jeremy Andrews
> <jeremy at> wrote:
>> Hello,
>> I'm exploring the possibility of accessing some GnuCash data through a
>> PHP application.  The short term goal would be the ability to browse
>> financial information through a web browser.  While a long time user of
>> GnuCash, I've never explored it at the code level before.  I spent some
>> time this afternoon poking around, and have a few general questions.
>> Is there a library and/or API making it possible for external programs
>> to access GnuCash data?  I'd prefer accessing through an API, rather
>> than parsing the XML data files directly, or even directly accessing the
>> new SQL back-end.
>> Specifically, my goal is to work on a PHP extension.  The first function
>> I would be interested in would be to retrieve the accounts tree.  The
>> API of this PHP function is not particularly important at this time,
>> though my thought would be that I would specify a depth, and a parent
>> (NULL parent if depth is 0).  Ideally, this would return the same
>> information that is found in the Accounts tab: Account Name,
>> Description, and Total.
>> Later functions would continue to expose additional information via the
>> PHP extension.  I would personally use this PHP extension to write a
>> module for the Drupal CMS, making certain accounting information
>> available online.
>> Down the road, it could be useful to provide PHP functions for updating
>> information, not just viewing it.  But this is beyond what I need now,
>> and not what I wish to focus on in the present.
>> Can anyone point me in the right direction for getting started?  How can
>> I programmatically access the necessary GnuCash data from an external
>> program?  Or is there a better way to achieve my goals that I'm not
>> considering?
>> Thanks,
>>  -Jeremy
>> _______________________________________________
>> gnucash-devel mailing list
>> gnucash-devel at
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at

       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL:    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available

More information about the gnucash-devel mailing list