# 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 <module> ] 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 <module> ] 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 libgcc1 1: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
