sharry-jira-tool 0.1.28

Sort Jira stories in Excel

Jira Tool - userful tool to sort jira stories

Installation

jira-tool can be installed from PyPI using pip (note that the package name is different from the importable name):

pip install -U sharry-jira-tool

Download

jira-tool is available on PyPI https://pypi.org/project/sharry-jira-tool

Code

The code and issue tracker are hosted on GitHub: https://github.com/SharryXu/jira-tool

Features

• Parsing the excel file which usually been downloaded from the Jira platform.

• Sorting the excel records using some specific logic.

• Generating the target excel file which contains the result.

• The excel file structure can be customized by JSON file.

Quick example

Here’s a simple program, just to give you an idea about how to use this package.

import pathlib
from jira_tool import process_excel_file
HERE = pathlib.Path().resolve()
process_excel_file(HERE / "source.xlsx", HERE / "target.xlsx")

If you want to customize the definition file to adapt the new Excel, you can do below steps.

1. Creating the definition file like below. Inside the SortStrategyPriority list, you can decide the sort algorithms’ order.

[
    {
        "SortStrategyPriority": [
            "InlineWeights",
            "SortOrder",
            "RaiseRanking"
        ]
    },
    {
        "Columns": [
            {
                "Index": 1,
                "Name": "entryDate",
                "Type": "datetime",
                "RequireSort": false,
                "SortOrder": false,
                "InlineWeights": 0,
                "RaiseRanking": 0
            }
        ]
    }
]

2. Indicating the definition file location to the process_excel_file method like below.

process_excel_file(
    HERE / "source.xlsx",
    HERE / "target.xlsx",
    excel_definition_config=HERE / "definition_file.json"
)

Meantime, you can follow the same way to customize the milestone priority file.

1. Configuration file

[
    {
      "Priority": 1,
      "Sprints": ["R134 S1", "M109"]
    }
]

2. Code example

process_excel_file(
    HERE / "source.xlsx",
    HERE / "target.xlsx",
    excel_definition_config=HERE / "definition_file.json",
    sprint_schedule_config=HERE / "milestone_priority.json"
)

Author

The jira-tool module was written by Sharry Xu <[e-mail]> in 2022. The original idea comes from Andy Wu <[e-mail]>.

Starting with version 0.1.13, the main function of this project has been totally finished.

Contact

Our mailing list is available at [e-mail].

License

All contributions after December 1, 2022 released under MIT license.