Hi Phil, I have a 21M xml file with transactions in both CAD and USD back to 99, so lots (maybe too much) stuff to work with.
I can open the xml file and saveas to a new sqlite file just fine. It appears that I can continue to work with the sqlite file with no apparent issues. I have imported a couple of ofx files, closed and reopened the file several times. Ok for now. However with either sqlite or mysql I cannot save back to xml without major problems to the data file. If I work with a mysql database, once I close the db and then restart gnucash --nofile, choose the most recent 'file', my balances are all 0. On the mysql command line: select count(*) from transactions returns 6494 the same as the sqlite file. So I will work with sqlite for the time being.... When I open the 'sqlite_to_xml' file back in gnucash 2.2.7, I notice the following: Of all my accounts, only two liability credit card accounts(a visa and mc) have correct balances. The only transactions left in any other equity, income or expense accounts are the 'other side' of the visa or mc account transactions. The only other exception is that in my chequing account there are a few payments to Expenses:Vacation. I will start over again and see if I get identical results. At this point are you preferring to work with mysql or sqlite or indifferent? I will be on vacation for 3 weeks, but when back I will probably want to keep both the 2.2.7 xml version and trunk sqlite versions up-to-date. Thanks, Boyd On Wed, 2008-12-24 at 09:35 -0500, Phil Longstaff wrote: > At this point, feedback is great. This should be on gnucash-devel, not > gnucash-user, though because it is for an upcoming release, not released > software. > > Save-As will save to either an sqlite db or xml file. If the file already > exists, it will save in that format. Otherwise, any newly created file will > be > an sqlite file. I plan to allow the user to select format in the near > future. > So, if you want to save an sqlite file contents as xml, you need to save over > an existing xml file. Perhaps make a copy of your current file and then save > over that. > > Phil > > On December 23, 2008 09:31:50 pm Boyd Kelly wrote: > > Hi, > > > > I have compiled gnucash trunk with --enable-dbi, and sucessfully brought > > a copy of my gnucash data file into a mysql db. > > > > I have entered a bunch of transactions, and first thing I wanted to test > > was can I get this back into an xml file. > > > > I noticed that the saveas function will enable me to save (takes > > forever) as an sqlite db. This however doesn't produce a functional > > copy of my data. Note that I *do* realize that this is a work in > > progress. > > > > Question is: Can I make the dbi enabled gnucash to save its data to an > > xml file? Do you even want any feedback at this time from those who > > choose to test this out? > > > > Thanks, > > > > Boyd > > > > _______________________________________________ > > gnucash-user mailing list > > [email protected] > > https://lists.gnucash.org/mailman/listinfo/gnucash-user > > ----- > > Please remember to CC this list on all your replies. > > You can do this by using Reply-To-List or Reply-All. > > _______________________________________________ > gnucash-user mailing list > [email protected] > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
