quick n’ dirty CLI tool to copy your pivotal tracker data to an sqlite database. unlike the csv export built into pivotal tracker, this tool brings in comments and file attachments.
# visit https://www.pivotaltracker.com/profile and 'create new token'
PIVOTAL_TRACKER_API_KEY="<your-api-key>" npx @tanooki/storyexporter dump --project <your-project-id> -o my-project.db
for anyone moving over to Linear, you might find this fork of their CLI importer useful. see the pull request to see how that works.
$ npm install -g @tanooki/storyexporter
$ storyexporter COMMAND
running command...
$ storyexporter (--version)
@tanooki/storyexporter/0.4.36 darwin-arm64 node-v20.5.0
$ storyexporter --help [COMMAND]
USAGE
$ storyexporter COMMAND
...
saves configuration to ~/.config/storyexporter/config.json
USAGE
$ storyexporter configure --apiKey <value>
FLAGS
--apiKey=<value> (required) API key
DESCRIPTION
saves configuration to ~/.config/storyexporter/config.json
EXAMPLES
$ storyexporter configure
See code: src/commands/configure.ts
exports pivotal tracker data to sqlite database
USAGE
$ storyexporter dump -o <value> -p <value>
FLAGS
-o, --database=<value> (required) path to sqlite database file, e.g. output.db
-p, --project=<value> (required) project id to dump
DESCRIPTION
exports pivotal tracker data to sqlite database
EXAMPLES
$ storyexporter dump
See code: src/commands/dump.ts
Display help for storyexporter.
USAGE
$ storyexporter help [COMMAND...] [-n]
ARGUMENTS
COMMAND... Command to show help for.
FLAGS
-n, --nested-commands Include all nested commands in the output.
DESCRIPTION
Display help for storyexporter.
See code: @oclif/plugin-help