ZSH script to use of-store to export CSV files for loading into Tableau

of_to_csv

#!/usr/bin/env zsh

BASE=${0%/*}
SQLITE=/usr/bin/sqlite3

echo "Extracting from OmniFocus"
$BASE/of-store --debug --out=$BASE/finished.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;
!