I know this has little to do with SQL Server (and therefore, not quite like me to post this), but it’s a nifty little script in Powershell which I’ve been working on recently, and I believe other people may find use for it as well (someone, somewhere, maybe?).
This script basically takes a Trello JSON file (created using their Export feature), connects to a GitHub repository, and creates one GitHub issue per each Trello card. Any labels are copied over, any checklists in the Trello card will be added into the issue body as checklists, and any attachments in the Trello card will be added into the issue body as an unordered list of links. Finally, at the bottom of the issue’s body there would be a link back to the original Trello card.
The Script
First of all, without any further ado, you may find the aforementioned Powershell script in my GitHub Gists here:
Instructions
See below the steps you’d need to take in order to make use of the script:
1. Export your Trello board
First we need to get our hands on a JSON file containing all of your Trello board data.
1.1. Go to your Trello board, and click on the “Show Menu” button on the right (fig. 1)
1.2. Then, click on “… More” (fig. 2)
1.3. Click on “Print and Export” (fig. 3)
1.4. Click on “Export as JSON” (fig. 4)
1.5. You will get a JSON file representing your entire Trello board. Save it in an accessible path on your computer.
2. Get your GitHub personal access token
In order to be able to connect to your GitHub repository using Powershell, we’d first need to generate a personal access token. Click here for the GitHub’s instructions page for generating personal access tokens.
In short:
Log into GitHub, [1] click on your Profile pic, [2] click on Settings, [3] click on “Developer Settings” on the left-hand menu, [4] click on “Personal access tokens”, and then [5] click on “Generate new token” (fig. 5)
Give a description to your new token, and give it the “repo” permission scope (fig. 6)
Once you click on the green “Generate token” button, you’d be presented with the token string. You must copy it and save it somewhere safe, because you won’t be able to get it again from GitHub without creating a new token.
3. Run the Script
That should be enough preparation. You can now start running the Powershell script.
The script accepts the following mandatory parameters:
- GitHubToken – enter here the personal access token you’ve created in step 2.
- GitHubOwner – enter here your GitHub username
- GitHubRepo – enter here the name of the relevant repository. Needless to say, the issues feature would need to be enabled for this repository in order for the script to work.
- SourceTrelloJsonFile – enter here the full path to the json file you’ve created in step 1.
There are also a few optional parameters:
- TrelloLists – this is an array of strings, that can optionally contain a list of Trello column names. If this parameter was provided, only the lists specified here would be imported.
- UpdateExistingIssuesByTitle – true by default. If enabled, before adding each card, the script will check for existing open issues with the exact same title. If found, the existing issue will be updated instead of adding a new one.
- AddNonExistingIssues – true by default. If enabled, the script will add each card as a new issue, if it doesn’t already exist with the same title. Disabling this option can be useful when you only want to update existing issues without adding new ones.
- Logging – true by default. If enabled, informational messages will be printed to screen about any cards found, issues updated, added or skipped. Disable this option for a silenced mode which will only output something if an error occurred.
4. See the magic happen
That’s it! Once you’ve completed all preparations and set up all parameters properly, you should be able to run the script, sit back and enjoy the show, while your GitHub issues pile up.
example issue imported from Trello using the script
Conclusion
Note that any unicode text would have to be converted to ASCII, so if you have Unicode characters in your Trello cards, they may look a bit different by the time they reach GitHub.
After importing all the Trello cards as issues, you can start using the labels to make it easier for you to further organize your issues: Filter by labels to easily set assignees, milestones, and/or add to projects.
Something doesn’t work? Got questions or comments? Or just feel like praising the free fruits of my hard labor? Leave a comment below!