EHPT
Description
Employement Hero Pivotal Tracker: A simple command line tool to import stories to Pivotal Tracker via CSV file.
Installation
$ gem install ehpt
Usage
Command
$ ehpt <path_to/stories.csv> <API_TOKEN> <PROJECT_ID>
That's it. Enjoy.
CSV structure
This is the sample csv file. For more information about the story attributes, please visit Pivotal Tracker API Documentation
Note
- You can specify the requester of a story by using the initials. Instead of providing the
requested_by_id
attribute, you can provide the attributerequested_by
with value is the initials of the user. - Similar to
requested_by
, you can specify the owners of a story by using the initial. Instead of providing theowner_ids
attribute, you can provide the attributeowners
with value is the list of initials of the users. - Initials is how your initials will appear to others in PT. Please visit Pivotal Tracker for more information.
API Token
Navigate to https://www.pivotaltracker.com/profile and scroll down, you should see your API TOKEN there. If you don't already have it, create one.
If you don't specify the requested_by_id
or requested_by
in your csv file, the user with this API TOKEN will be the requester of the stories.
Project Id
Navigate to your project dashboard. The last digits in the url is the project's id. The url should be something like https://www.pivotaltracker.com/n/projects/1234567
Thank you
Special thanks to @phthhieu for his initial script and his encouragement.
License
MIT
Caveat
At Employment Hero, we have a practice to prefix the card's title with the last 3 digits of its id. We then refer to the card by this new 3-digits id. If you don't need this 3-digits prefix, you can use the built-in import/export feature from Pivotal Tracker. More information here