External Program

Wm tcnw81 at tarrcity.demon.co.uk
Fri Jun 10 16:51:58 EDT 2016


On Thu, 9 Jun 2016 20:04:53 -0230, in gmane.comp.gnome.apps.gnucash.user,
Mark Mercer <markm at woodjoint.ca> wrote:

> Thank you both for your replies.
> 
> What I actually did was I went into gnucash and created a record in one 
> of the sections and then I opened up SQL workbench and looked through 
> the tables.  The record I created actually made entries in three or four 
> tables so I studied what each table was for which guid's pointed to 
> where and then duplicated the records in the database and assigned new 
> guid's that I made up.  I opened gnucash and it did not display the new 
> records that I created. Any idea's?  I must be missing something.
> 
> I will use gnucash to enter most records but for these sales receipts I 
> think it will be a bit clunky.  I would rather create a robust app on my 
> own that can enter the data in a few clicks and selecting stuff from 
> dropdows etc.
> 
> If you could help me a little further to get this working it would make 
> everything so much simpler for me.
> 
> Thanks again.

If you've an immediate business problem to solve get your external prog to
create perfectly formed gnc import files, that way you can get on with
doing the important stuff and solve any API issues at your leisure.
Imports are only fiddly if you are doing them as a one off, done regularly
they are efficient.

Meanwhile if you're familiar with relational databases
https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png
can be a good starting point.

I strongly recommend looking at Sebastien's work if you are going to be
looking at gnc from an sql POV in a non-trivial way, start here:

http://piecash.readthedocs.io/en/latest/tutorial/index_existing.html#other-objects

Warning: discussion of writing to a gnc database in an unapproved way may
result in tears.

-- 
Wm



More information about the gnucash-user mailing list