Gnucash 2.0.2 looses transactions if the file contains special characters

classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

Gnucash 2.0.2 looses transactions if the file contains special characters

Stephane Carrez
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi!

I've migrated my accounts from Gnucash 1.8 to Gnucash 2.02.  My accounts contain
several transactions with latin1 characters.  During the conversion, some
translation from iso-latin1 to utf-8 was made.  The special characters are
used for the transaction description (<act:description>).

I've then worked on the accounts (OFX import, price editor, reports), saved the file
and exited Gnucash.

Once I've re-started Gnucash 2.0.2, *many* *many* of the transactions in several
accounts have *disappeared*.  Some of the transactions were created more than a year ago
and there were gone!  Quite frightening at that point!!!

I tried to re-launch Gnucash with --debug --loglevel 6 on a backup file, still the same
problem and no message to understand what happened.

The good news is that the saved Gnucash 2.0.2 file *does* contain these missing transactions.
So, after de-compressing the Gnucash file (it's a gzip XML), I've imported the file in
Grisby (http://www.grisbi.org/) and during the import it barks at the special characters.
After editing the XML, replacing the special characters, Gnucash was able to read and
retrieve all the transactions.

If it happens to you, do:
- - do not save (because the missing transactions will really be removed from the file)
- - if you've saved, get a backup of the file
- - decompress the file with gzip
- - edit the file and replace every special character with an ascii character
- - load the file in Gnucash until you see again the missing transactions


Stephane

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.3 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFFzuqdNyQxO2LzKT0RAjlZAKDjEwjyaK84faIfTqGc6SwfoaojBwCgqT40
a+eNDihVlyGPI//TJWmQjZs=
=HdUr
-----END PGP SIGNATURE-----
_______________________________________________
gnucash-user mailing list
[hidden email]
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.
Reply | Threaded
Open this post in threaded view
|

Re: Gnucash 2.0.2 looses transactions if the file contains special characters

Derek Atkins
2.0.4 is current..   Try 2.0.4 and see if it still has the problem?

-derek

Quoting Stephane Carrez <[hidden email]>:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Hi!
>
> I've migrated my accounts from Gnucash 1.8 to Gnucash 2.02.  My
> accounts contain
> several transactions with latin1 characters.  During the conversion, some
> translation from iso-latin1 to utf-8 was made.  The special characters are
> used for the transaction description (<act:description>).
>
> I've then worked on the accounts (OFX import, price editor, reports),
> saved the file
> and exited Gnucash.
>
> Once I've re-started Gnucash 2.0.2, *many* *many* of the transactions
> in several
> accounts have *disappeared*.  Some of the transactions were created
> more than a year ago
> and there were gone!  Quite frightening at that point!!!
>
> I tried to re-launch Gnucash with --debug --loglevel 6 on a backup
> file, still the same
> problem and no message to understand what happened.
>
> The good news is that the saved Gnucash 2.0.2 file *does* contain
> these missing transactions.
> So, after de-compressing the Gnucash file (it's a gzip XML), I've
> imported the file in
> Grisby (http://www.grisbi.org/) and during the import it barks at the
> special characters.
> After editing the XML, replacing the special characters, Gnucash was
> able to read and
> retrieve all the transactions.
>
> If it happens to you, do:
> - - do not save (because the missing transactions will really be
> removed from the file)
> - - if you've saved, get a backup of the file
> - - decompress the file with gzip
> - - edit the file and replace every special character with an ascii character
> - - load the file in Gnucash until you see again the missing transactions
>
>
> Stephane
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.3 (GNU/Linux)
> Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
>
> iD8DBQFFzuqdNyQxO2LzKT0RAjlZAKDjEwjyaK84faIfTqGc6SwfoaojBwCgqT40
> a+eNDihVlyGPI//TJWmQjZs=
> =HdUr
> -----END PGP SIGNATURE-----
> _______________________________________________
> gnucash-user mailing list
> [hidden email]
> 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.
>



--
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       [hidden email]                        PGP key available

_______________________________________________
gnucash-user mailing list
[hidden email]
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.