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 <jra...@ceridwen.us> wrote: > > > > On Jan 7, 2021, at 1:40 PM, Scott Morgan <sc...@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 sc...@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@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-devel
