Add this line to your application's Gemfile:
gem 'jira-worklog'And then execute:
$ bundle
Or install it yourself as:
$ gem install jira-worklog
You can use JIRA API Client programatically (see lib/jira/worklog/api_client.rb) or as CLI utility jira-worklog
In order to add some worklog from excel, you need to know available issues (key or id). This command helps you to get list of issues:
jira-worklog issues -u MY_USERNAME -p MY_PASSWORD -b https://jira.example.com/rest/api/2/jira-worklog list -u MY_USERNAME -p MY_PASSWORD -b https://jira.example.com/rest/api/2/ --issue ISUE_ID_OR_KEY File must be in excel xlsx form and must contain 4 colums (ussue_id_or_key, date, duration_in_hours, comment). For example file se exmple.xlsx.
jira-worklog add -u MY_USERNAME -p MY_PASSWORD -b https://jira.example.com/rest/api/2/ --xlsx FILE.XLSXjira-worklog delete -u MY_USERNAME -p MY_PASSWORD -b https://jira.example.com/rest/api/2/ WORKLOG_ID1,WORKLOG_ID2,...api = Jira::Worklog::APIClient.new(base_url, user, password)
api.issues() # list issues for logged user
api.worklogs(issue_id_or_key) # fetch stored worklogs for given issue
api.add_worklog(worklog_data) # add worklog - worklog_data is a Hash:
# {issue: 'ISSSUE_ID_OR_KEY', started: Date, duration: in_seconds, comment: 'comment'}
api.delete_worklog(issue_id_or_key, worklog_id) After checking out the repo, run bin/setup to install dependencies. Then, run rake spec to run the tests. You can also run bin/console for an interactive prompt that will allow you to experiment.
To install this gem onto your local machine, run bundle exec rake install. To release a new version, update the version number in version.rb, and then run bundle exec rake release, which will create a git tag for the version, push git commits and tags, and push the .gem file to rubygems.org.
Bug reports and pull requests are welcome on GitHub at https://github.com/[USERNAME]/jira-worklog.
The gem is available as open source under the terms of the MIT License.