Scrumdog – a program to download Jira Issues to a local database • Hacker News Board

Re: Scrumdog – a program to download Jira Issues to a local database

#61

Post by eliaspro » Sun, Jul 17, 2022, 8:06 AM UTC

You might also be interested in the excellent Bugwarrior [1] which syncs issues from a wide variety of issue trackers (JIRA is amongst them) [2] to your Taskwarrior [3] database.

[1] https://bugwarrior.readthedocs.io/en/latest/

[2] https://bugwarrior.readthedocs.io/en/latest/services.html

[3] https://taskwarrior.org/

Re: Scrumdog – a program to download Jira Issues to a local database

#62

Post by simonw » Mon, Jul 18, 2022, 9:17 PM UTC

iampims wrote: post #59

simonw wrote: post #10

Absolutely love this. I have a whole bunch of similar tools for importing stuff from different services into SQLite but I never got up the courage to take on Jira! Here's my github-to-sqlite tool which imports GitHub Issues https://datasette.io/tools/github-to-sqlite - being able to query them in a local SQLite database is super-handy. I run a demo instance of the resulting database here: https://github-to-sqlite.dog…

Heads up: > Error 500 cannot import name 'etree' from 'markdown.util' (/usr/local/lib/python3.8/site-packages/markdown/util.py)

Thanks for letting me know - fixed that here: https://github.com/dogsheep/github-to-sqlite/issues/74

Re: Scrumdog – a program to download Jira Issues to a local database

#63

Post by crestfallen » Tue, Jul 19, 2022, 4:32 PM UTC

ako wrote: post #56

crestfallen wrote: post #25

Earlier quoted context omitted.

I'm curious about this. I would say I'm fairly versed in Excel but haven't dug too deep into Power Query / the data model. If you wouldn't mind, how is this done?

Looks like it's documented on the atlassian website: https://community.atlassian.com/t5/Jira-Core-Server-question...

I didn't get back to this in a timely manner but I wanted to thank you.