Comparing two GC files

Alois Mahdal alois.mahdal.1-ndmail at zxcvb.cz
Thu Jul 11 13:40:26 EDT 2013


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.

-- 
Alois Mahdal


More information about the gnucash-user mailing list