Comparing two Gnucash files

[Maf. King]

Hi Alois,

Would there be any merit for you to do a save as....uncompressed XML for both 
sqlite databases - maybe your diff tool will give you a clue about the newer 
file?

I can already hear the howls of anguish from the devs about attempting a merge 
of the 2 data files, though!  Back up and back up often if you take that path. 
- there is a gnucash-qif utility somewhere on the web and possibly you could 
import newer transactions from one of the files, but not sure about how to 
handle date changes or deletions...

HTH,
Maf.


On Thu 11 July 13 19:38:41 Alois Mahdal wrote:
> Hi,
> 
> I need to compare two sqlite-based GC files (holding few months
> of personal finances) that may or may not be different.
> 
> However, if they are, either one of them is newer, or (in worse
> case) they must have a common ancestor, which I guess physically
> does not exist, unless GC saves history of revisions like e.g.
> git.
> 
> Note that the changes on both sides might be as wall additive as
> substractive, so usual rule as "bigger = newer" is way too risky
> here.  Also there won't be many chages, I'd guess minor (like date)
> edits to 10-100 items, maybe a split here and there.
> 
> Now if it was a CSV or any other simple structure, I'd just grab
> <my favorite diff/merging tool> and resolve the "conflict" using
> merge if necessary.  I realize, though, that GC's data structure
> must be very complicated, so if I am able to simply dump the
> sqlite file and give it a try, I could spend hours on it and not
> be sure, and in case of merging, I could easily end up with unusable
> file.
> 
> No backups available :/
> 
> So is ther a "safe way" to do it?  Or should I just bite the bullet,
> flip a coin and carefully revise the data according to other sources?
> 
> Thanks,
> aL.
-- 
Maf. King
PGP Key fingerprint = 8D68 A91F 733B 2C1F 43B7  2B7C E591 E8E1 0DE7 C542