[GNC-dev] Nice Job All!

D. sunfish62 at yahoo.com
Thu Jan 7 19:48:26 EST 2021


I'll jump in to say that:

1) xml is still considered the primary storage format, and
2) the xml format is by default gzipped, which will render a cat illegible. You can turn off compression in GnuCash, or you can gunzip the file and cat the results. 

HTH,
David



-------- Original Message --------
From: Scott Morgan <scott at adligo.com>
Sent: Thu Jan 07 19:30:14 EST 2021
To: John Ralls <jralls at ceridwen.us>
Cc: gnucash-devel at gnucash.org
Subject: Re: [GNC-dev] Nice Job All!

Ok, thanks for the clarification.   If SQL is the main model format where
is the best place to look for docs on the SQL schema ?   I don't even seem
to be able to get see the XML correctly, I will log this as a bug (perhaps
the older 3.11 version [on an old mac 10.10.5])  ie;

cat 2020-01-07.gnucash.xml.gnucash


4???p?~???'??M??f??

I'm digging in the bug list, but is this known to anyone?

On Thu, Jan 7, 2021 at 5:17 PM John Ralls <jralls at ceridwen.us> wrote:

>
>
> > On Jan 7, 2021, at 1:40 PM, Scott Morgan <scott at adligo.com> wrote:
> >
> > Hey All,
> >
> >  I just wanted to thank you all for working hard to bring gnucash into
> the
> > world.  I am curious about your XML formats, are you using XSD schema
> files
> > or DTD files.
> >  #2 is there a good way to transfer the XML files to a SQL db and vice
> > versa with gnucash?
> >  #3) As an avid developer (Java / https://github.com/adligo) I have
> become
> > sick of XML and JSON and I am looking for collaborators to develop a new
> > binary data format that is mostly text.  What I really mean is that I am
> > looking to build a pluggable parsing strategy that avoids s-expressions
> and
> > allows csv file data inside of trees called;
> > Classification Markup Notation
> >  Let me know if any of you are interested in this idea and would like to
> > collaborate.
> >
>
> Scott,
>
> Neither DTD nor XML:Schema nor relax, we don't use parser validation. All
> of the XML semantics are hard-coded in the SAX handlers. There are some
> DTDs and a relax schema in libgnucash/doc/xml, but they're for
> documentation only.
>
> The only way at present to convert between XML and SQL is File>Save As
> from an open book. We have it on the long-term todo list to write a more
> direct conversion but it hasn't even been started.
>
> Regards,
> John Ralls
>
>

-- 
Regards,
Scott Morgan
President & CEO
Adligo Inc
http://www.adligo.com
https://www.linkedin.com/in/scott-morgan-21739415
A+ Better Business Bureau Rating
<https://www.bbb.org/chicago/business-reviews/computer-software-publishers-and-developers/adligo-inc-in-chicago-il-88381256>
https://github.com/adligo

By Appointment Only:
1-866-968-1893 Ex 101
scott at adligo.com
skype:adligo1?call
Send Me Files Securely:
*https://www.sendthisfile.com/f.jsp?id=ewOnyeFQM18IDRf7MMIdolfI
<https://www.sendthisfile.com/f.jsp?id=ewOnyeFQM18IDRf7MMIdolfI>*
_______________________________________________
gnucash-devel mailing list
gnucash-devel at gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel



More information about the gnucash-devel mailing list