3 stable releases
2.0.1 | Feb 16, 2023 |
---|---|
2.0.0 | Feb 15, 2023 |
1.0.0 | Feb 11, 2023 |
#39 in #chart
17KB
283 lines
Jira CSV to Gantt Chart JSON Converter
This program converts Jira CSV exports to a format that can be ingested by the gantt_chart tool.
Install with cargo install jira_to_gantt
. Run with jira-to-gantt
.
Notes
The tool uses the following Jira fields:
- Issue key - Gives a short description of the item
- Status - Used to mark the task open or close on the chart
- Assignee - Used to group the tasks
- Original Estimate - Task duration
- Created (optional) - Used if no Starts On date is provided on the command line
Jira CSV export has numerous problems and inconsistencies which the tool handles, including:
- There are extra non-CSV format lines at the start and end of the output
- Dates are in a non ISO format
- Any backlog sort order is not honored
- There are bad UTF-8 characters in the output
- Quoting is inconsistent
You can use iconv -c -t utf-8 bad.csv > stripped.csv
to clean bad UTF-8 characters from export. See iconv. The tool does this automatically.
You can use xsv slice -s 3 -n -o bad.csv jira.csv
to remove the first 3 lines. Again, the tool does this automatically.
The tool uses structures from the gantt_chart crate to ensure compatability of the JSON5 output.
Dependencies
~8–22MB
~281K SLoC