# The email message below came through a remailer.
# The originator of the message is unknown and untraceable.
# To stop receiving emails from this remailer, send an email to:
# br...@grizfrom.com
#
# In the body of the message include the phrase:
# destination-block
#
# or
#
# just reply to this message and your address will be blocked.
Package: ledger
Version: 3.1+dfsg1-2
Followup-For: Bug #740757
Martin> However, someone recently wrote a Python script to convert gnucash
Martin> files to ledger:
Martin>
Martin> https://github.com/MatzeB/pygnucash
The pygnucash package is not a debian package and in fact it's an
undocumented experimental hack. And worse, it's also broken:
$ git clone https://github.com/MatzeB/pygnucash
$ aptitude install libdbd-sqlite3
$ gnucash2ledger.py
Invocation: gnucash2ledger.py gnucash_filename
It does not say if "gnucash_filename" is the gnucash native data file,
or the one exported manually using the GUI to trigger the libdbd
mechanism. Trying both--
This is the output with the native file:
] $ gnucash2ledger.py my_jailed_books.gnucash
]
] Traceback (most recent call last):
] File "pygnucash/gnucash2ledger.py", line 12, in
] data = gnucash.read_file(sys.argv[1])
] File "pygnucash/gnucash.py", line 147, in read_file
] return read_data(conn)
] File "pygnucash/gnucash.py", line 82, in read_data
] for row in c.execute('SELECT guid, namespace, mnemonic, fullname FROM
commodities'):
] sqlite3.DatabaseError: file is encrypted or is not a database
The error suggests that maybe pygnucash needed the exported sqlite
file. So I fed the dodgy sqlite3 file to it:
] $ gnucash2ledger.py my_jailed_books.gnucash.sqlite3
]
] Traceback (most recent call last):
] File "pygnucash/gnucash2ledger.py", line 12, in
] data = gnucash.read_file(sys.argv[1])
] File "pygnucash/gnucash.py", line 147, in read_file
] return read_data(conn)
] File "pygnucash/gnucash.py", line 82, in read_data
] for row in c.execute('SELECT guid, namespace, mnemonic, fullname FROM
commodities'):
] sqlite3.OperationalError: no such table: commodities
I say the sqlite3 is dodgy, because it only contains 1 table with no rows.
-- System Information:
Debian Release: 8.0
APT prefers stable-updates
APT policy: (500, 'stable-updates'), (500, 'stable')
Architecture: amd64 (x86_64)
Foreign Architectures: i386
Kernel: Linux 3.16.0-4-amd64 (SMP w/2 CPU cores)
Locale: LANG=en_US.UTF-8, LC_CTYPE=en_US.UTF-8 (charmap=UTF-8)
Shell: /bin/sh linked to /bin/dash
Init: systemd (via /run/systemd/system)
Versions of packages ledger depends on:
ii libboost-filesystem1.55.0 1.55.0+dfsg-3
ii libboost-iostreams1.55.0 1.55.0+dfsg-3
ii libboost-regex1.55.0 1.55.0+dfsg-3
ii libboost-system1.55.0 1.55.0+dfsg-3
ii libc6 2.19-18
ii libgcc11:4.9.2-10
ii libgmp10 2:6.0.0+dfsg-6
ii libicu52 52.1-8
ii libmpfr4 3.1.2-2
ii libstdc++6 4.9.2-10
ledger recommends no packages.
ledger suggests no packages.
-- Configuration Files:
/etc/emacs/site-start.d/50ledger.el 0450a71ec52941dd8cdcef94e8ed2ee2 [Errno 2]
No such file or directory: u'/etc/emacs/site-start.d/50ledger.el
0450a71ec52941dd8cdcef94e8ed2ee2'
-- no debconf information
--
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org
