View Single Post
Old 05-11-2013, 09:06 AM   #4
AlPe
Digital Amanuensis
AlPe ought to be getting tired of karma fortunes by now.AlPe ought to be getting tired of karma fortunes by now.AlPe ought to be getting tired of karma fortunes by now.AlPe ought to be getting tired of karma fortunes by now.AlPe ought to be getting tired of karma fortunes by now.AlPe ought to be getting tired of karma fortunes by now.AlPe ought to be getting tired of karma fortunes by now.AlPe ought to be getting tired of karma fortunes by now.AlPe ought to be getting tired of karma fortunes by now.AlPe ought to be getting tired of karma fortunes by now.AlPe ought to be getting tired of karma fortunes by now.
 
AlPe's Avatar
 
Posts: 727
Karma: 1446357
Join Date: Dec 2011
Location: Turin, Italy
Device: Several eReaders and tablets
Hi,

if you want to export your annotations and highlights to CSV format (e.g., for using them in a spreadsheet program), you can use my Python script which you can download
here.

Usage:
Code:
$ python export_Kobo_notes.py [ARGUMENTS]

Arguments:
 -h, --help          : print this usage message and exit
 -f, --file <file>   : <file> is the path to KoboReader.sqlite
 -c, --csv           : output CSV values, instead of human-readable strings
 -o, --output <file> : write output to <file>

Exit codes:

 0 = no error
 1 = invalid argument(s) error
 2 = file KoboReader.sqlite not found
 4 = provided file is not a valid KoboReader.sqlite db
 8 = output file cannot be written

Examples:

 1. Print this usage message
    $ python export_Kobo_notes.py -h

 2. Print annotations and highlit passages in human-readable form
    $ python export_Kobo_notes.py -f KoboReader.sqlite

 3. As above, but output to file output.txt
    $ python export_Kobo_notes.py -f KoboReader.sqlite -o output.txt 

 4. As above, but output in CSV form
    $ python export_Kobo_notes.py -c -f KoboReader.sqlite

 5. As above, but output to output.csv
    $ python export_Kobo_notes.py -c -f KoboReader.sqlite -o output.csv
AlPe is offline   Reply With Quote