Thanks for the idea John.
I had look around for an sqlite tool for analysing the database.
Theres a nice little sqlite reader/editor called sqliteman. However,
when i try to open the gnucash database it responds with:
Unable to open or create file accounts.gnucash. It is probably not a
database
I also found a free reporting tool for sql called openRPT but this
requires an interface to sqlite as its designed for "proper" databases.
The only interface i found is qsqlite which the developer has declared
obsolete and it needs sqlite 2.8. Clearly not a good path to go down.
Does anyone know of any tools (for linux) that will empower me to view
and/or create reports from the database?
On 23/02/15 01:11, John Ralls wrote:
On Feb 22, 2015, at 4:04 PM, Bob Gustafson <[email protected]> wrote:
On 02/22/2015 05:48 PM, John Ralls wrote:
On Feb 22, 2015, at 3:37 PM, Paul <[email protected]> wrote:
Hello all
I admire what you are trying to do and wish to support you with some feedback.
My usecase: "We want to see whats happening to our money."
I downloaded and installed gnucash a couple of days ago because the need arose
to manage our accounts. After connecting to online banking services and
downloading all our transactions I got everything working perfectly. AWESOME!!
Problem solved I thought as I proceeded to the reporting to pull out some data
for my partner...
What a disappointment. The stock reports are imo ugly and inadequate for our
use case. We are interested in cash flow and the editing options for this
report are minimal. Very minimal.
Being a qualified programmer I investigated the options for customising our
reports somehow. I quickly found the answer to all of my reporting woes. I have
to learn not one, but two obscure programming langages, namely guile/eguile and
scheme.
In conclusion: I can't be bothered. I will have a look for something else that
can output beautiful, professional and, if necessary, customizable reports.
I will report back with my findings if you like.
Actually, Guile and Scheme are the same language.
You might consider the SQL backend; one variant, SQLite3 requires no server.
Using that instead of the default XML backend will allow you to query the
database with standard SQL tools and use a SQL-based report writer to generate
prettier reports.
Regards,
John Ralls
That is a great idea John - SQL report generation is quite a flexible solution.
I forgot to throw in the usual caveat: There’s at least one spot in the current
release, the company information on the Business tab in the File>Properties
dialog, that isn’t correctly synced to the SQL backend. That’s fixed for the next
release, and in the meantime you can use File>Save As to force a complete rewrite
of your database to save it if you need to. There may be other bits that I don’t know
about, though I just did another thorough audit and I didn’t find any. Also you
mustn’t write to the database except with GnuCash as all of the business logic is in
GnuCash, not in the database. We haven’t even declared foreign keys in the database
tables.
Regards,
John Ralls
_______________________________________________
gnucash-devel mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
____________________________________________________________
FREE 3D EARTH SCREENSAVER - Watch the Earth right on your desktop!
Check it out at http://www.inbox.com/earth
_______________________________________________
gnucash-devel mailing list
[email protected]
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
