xlsx2jira-worklog-script

Install dependencies

pip3 install -r requirements.txt

Prepare config.json file with connection configuration

User / Password Auth

{
  "url": "https://externalhttpuser:externalhttppassword@company.com/jira/rest",
  "username": "ldapUser",
  "password": "ladpPassword"
}

API Token Auth

{
  "url": "https://externalhttpuser:externalhttppassword@company.com/jira/rest",
  "api_token": "user-api-token"
}

Cookie Auth

{
  "url": "https://externalhttpuser:externalhttppassword@company.com/jira/rest",
  "cookie": "user-session-cookie"
}

Run script:

python3 xlsx2jira-worklog.py worklog.xlsx

Tests

python -m unittest