Are you getting the most out of your AWS investment? Get your free AWS Well-Architected Assessment.

2021 Fillmore Street #1128

}

24/7 solutions

How to Export GitHub Issues to Excel Easily

It is way more challenging than it should be to export GitHub issues to Excel . In the past, prior to Two Factor Authentication, you could use curl with your username and password to return JSON. curl -i "http://api.github.com/repos/{repo_name}/{project_name}/issues" -u "{user_name}" Unfortunately, you need Two Factor Authentication turned on for your GitHub organization. We require […]

It is way more challenging than it should be to export GitHub issues to Excel . In the past, prior to Two Factor Authentication, you could use curl with your username and password to return JSON.

curl -i "http://api.github.com/repos/{repo_name}/{project_name}/issues" -u "{user_name}"

Unfortunately, you need Two Factor Authentication turned on for your GitHub organization. We require all of the organizations that AllCode works with to turn on Two Factor Authentication.
For querying GitHub’s REST API with two factor authentication, your best solution is to make use of a Personal Access Token, but in order for the Personal Access Token to work, your app needs to be a GitHub App or OAuth App. None of our repos are.
So how do you dump all of your GitHub Issues to Excel so you can share the issues with the client. The answer is you make use of the hub command line utility. To get started,

  1. Clone the repo from GitHub into your working directory.
  2. Install hub (e.g. on macOS run: brew install hub). If you don’t have Homebrew, you can find it here
  3. Run: hub issue in your repo directory to list the open issues (it’s in Markdown format).
  4. If you have Two Factor Authentication turned on, you’ll be prompted for your username, password, and two factor authentication code.
  5. Supply the appropriate credentials for your GitHub account
  6. Run the follow command in the terminal hub issue -f "Issue|%I%nTitle|%t%nBody|%b%n%n" > GitHubIssues-01032019.txt

You’ll notice that the printf formatting is a little tricky. Details on this formatting are here.

-f, –format FORMAT

Pretty print the contents of the issues using format FORMAT (default: “%sC%>(8)%i%Creset %t% l%n”). See the “PRETTY FORMATS” section of git-log(1) for some additional details on how placeholders are used in format. The available placeholders for issues are:

%I: issue number

%t: title

%b: body

Hub Issue Formatting can be found here.

This command will generate a pipe delimited text file with the main attributes on the first line, and the body on 2 through n lines. The body of our issues are typically verbose.

Now open your GitHubIssues-01032019.txt file in Excel. When you’re prompted by Excel to specify Fixed Width or Delimiter, specify the pipe as the delimiter. You should be good to go.

Export GitHub Issues to Excel

Export GitHub Issues to Excel

Joel Garcia

Joel Garcia

Joel Garcia has been building AllCode since 2015. He’s an innovative, hands-on executive with a proven record of designing, developing, and operating Software-as-a-Service (SaaS), mobile, and desktop solutions. Joel has expertise in HealthTech, VoIP, and cloud-based solutions. Joel has experience scaling multiple start-ups for successful exits to IMS Health and Golden Gate Capital, as well as working at mature, industry-leading software companies. He’s held executive engineering positions in San Francisco at TidalWave, LittleCast, Self Health Network, LiveVox acquired by Golden Gate Capital, and Med-Vantage acquired by IMS Health.

Related Articles

AWS Think Big with Small Business Program’s Competitive Edge

AWS Think Big with Small Business Program’s Competitive Edge

The Amazon Cloud can help alleviate most issues involving transitioning the cloud. Businesses of any scope can hope to build solutions that are scalable and adaptable to their industry of work. Smaller or minority-owned businesses may still struggle to stand out among bigger companies or make an AWS environment as efficient as possible with fewer funds to spend. To alleviate these burdens, Amazon has the Think Big With Small Business program available through their Public Sector partnership program.

AWS Think Big for Small Business, Data Analytics, and Business Intelligence

AWS Think Big for Small Business, Data Analytics, and Business Intelligence

The AWS Think Big for Small Business Program is an outreach program designed to provide small and/or minority-owned public sector organizations support in the form of business intelligence, technical expertise, and marketing strategies. With cloud-based solutions and experience, various public institutions globally have seen continued success in government, educational, and nonprofit sectors. While the funding provided can help significantly to meet business objectives, the expertise on navigating the cloud and how to extend outwards towards customers is just as critical.

Best Practices for Using AWS Systems Manager

Best Practices for Using AWS Systems Manager

As newer users adopt the AWS cloud, it can be difficult to watch for issues and resolve them as needed. AWS Systems Manager grants better visibility over the AWS environment by clustering resources, providing legible and usable data based on performance, and actions to take that abide by AWS compliance requirements and best practices. This service provides everything management needs to evaluate the cloud and ensure continued functionality.