Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
#!/usr/bin/env zsh
BASE=${0%/*}
SQLITE=/usr/bin/sqlite3
echo "Extracting from OmniFocus"
$BASE/of-store --debug --out=$BASE/finished.db
$BASE/kanban-fetch --debug --out=$BASE/inprogress.db
echo "Exporting to tasks.csv"
$SQLITE $BASE/finished.db <<!
.headers on
.mode csv
.output tasks.csv
select * from tasks;
!
echo "Exporting to projects.csv"
$SQLITE $BASE/finished.db <<!
.headers on
.mode csv
.output projects.csv
select * from projects;
!
echo "Exporting to kanban.csv"
$SQLITE $BASE/inprogress.db <<!
.headers on
.mode csv
.output kanban.csv
select * from projects;
!
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.