Skip to content

Instantly share code, notes, and snippets.

@nathansmith

nathansmith/sprintly.bash

Last active July 18, 2018 15:23
Show Gist options
  • Save nathansmith/5349682 to your computer and use it in GitHub Desktop.
Save nathansmith/5349682 to your computer and use it in GitHub Desktop.
Download ZIP
Used to export Sprint.ly data to CSV format.
Raw
sprintly.bash
# Sprint.ly Export
alias sprintly='cd ~/sprintly-csv/ && curl -s -u name@example.com:API_KEY "https://sprint.ly/api/products/PRODUCT_ID/items.csv?status=backlog,in-progress,accepted,someday,completed&limit=99999" > temp.csv && iconv -f utf-8 -t cp1250 temp.csv > sprintly_$(date +"%Y-%m-%d_%I-%M-%S").csv && rm temp.csv && open .'
@nathansmith
Copy link
Author

This will take a CSV export of your project's data in Sprint.ly, and convert it from utf-8 to cp1250 (Windows compatible) format. That way, any "curly quote" type characters will show up correctly when you open the file in Excel.

If you're wondering what this is all about, read more here…

https://sprintly.uservoice.com/knowledgebase/articles/120542-exporting-to-csv-via-the-api

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment