db backend observations

[Boyd Kelly]

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
> > gnucash-user at gnucash.org
> > 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
> gnucash-user at gnucash.org
> 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.