Re: [GNC-dev] Nice Job All!

[Adrien Monteleone]

Is this what you are looking for?

https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png

And there is also this: https://wiki.gnucash.org/wiki/SQL

Regards,
Adrien

On 1/7/21 6:30 PM, Scott Morgan wrote:

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?


___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] Nice Job All!

[D. via gnucash-devel]

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 
Sent: Thu Jan 07 19:30:14 EST 2021
To: John Ralls 
Cc: gnucash-devel@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  wrote:

>
>
> > On Jan 7, 2021, at 1:40 PM, Scott Morgan  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://github.com/adligo

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

___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

Re: [GNC-dev] Nice Job All!

[Scott Morgan]

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  wrote:

>
>
> > On Jan 7, 2021, at 1:40 PM, Scott Morgan  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://github.com/adligo

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

Re: [GNC-dev] Nice Job All!

[John Ralls]

> On Jan 7, 2021, at 1:40 PM, Scott Morgan  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

___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel

[GNC-dev] Nice Job All!

[Scott Morgan]

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.

-- 
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://github.com/adligo

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