samsmu / jira2pm

Add-on which allows user to get data from JIRA to Google Spreadsheets easier.

JIRA2PM

JIRA2PM is an add-on for Google Spreadsheets which allows user to get data from JIRA into sheet.

Version 1.0

Using

• Install add-on from Google Store
• Connect to your JIRA
• Write JQL query and select fields you want ot display
• Send request to JIRA and get data
• Check help page for additional information

Using with sources

• Clone repo
• Create new Google App Script in Google Drive
• Add files from add on into it
• Enable Google Sheets API
  • Resources -> Advanced Google Services...
  • Enable Google Sheets API
  • Use link to Google API console at the bottom of Advanced Google Services... window and enable Google Sheets API in it.
• Run Test
  • Publish -> Test as Add-on...
  • Create new test
  • Run it

Contacts

• Author of the Idea, UX/UI Designer

  Valuev Alexander - [email protected]

• Developer

  Buryachenko Artem - [email protected]

  Or add me at Discord: Black Cat!#5337

jira2pm's Issues

Feedback Form inside the plugin

A user should have an ability to send some ideas, problems, feature requests through the google spreadsheets' UI.
The perfect form should collect following information from the user:

• email
• name
• skype\telegram\whatsapp\facebook accounts
• Text Form
• Image Attach form for screenshots

Create a popup window with the attributes were described above and integrate it to the menu and plugin body as a link.

Maybe you will find some ready-to-go solution and you integrate feedback form with automatically issue creation in GitHub project.

Configuration stored at account level instead of sheet level

Hello,

It looks like the configuration is stored at the account level. And I have to setup every time I switch working on each sheet. If property store size is the problem, can we use another storage mechanism and store it at the sheet level?

Optimise/Restructure fetching

Since most of the features are settled down, some optimizations for server side code can be done

Run the script every x hours

Hi - Is it very hard to implement the time triggers to pull the data periodically - like every 6 hours?

I think the number one blocker is not being able to specify the target sheet in the configuration. This also sometimes messes up the sheets (data spread across multiple sheets) if we circle through the sheets in the workbook while the script is pulling data from JIRA.

Also, let me know if I should be submitting a separate issue for the underlying issue.

Not Recognizing New Custom Fields

Hey, it's me again :)
LOVING the add-on thus far! I needed to add another custom field to my JIRA instance, but I don't see it showing up as a new option for one of the columns. How can I refresh the list of available custom fields in the add-on? I tried removing the add-on and re-adding it, no luck there.

Only returning first 101 issues

Hi there! Love using this tool, but the return on my query will only show 100 records, max. Is this a known limitation of the add-on? In JIRA, the same query returned 184 issues.

Add filter by name for fields

Currently it takes a lot of time to find one particular field.
Grouping for fields should probably be removed.

Replace Login\Password Form to JIRA OAuth

It would be more secure and effective to use JIRA authorization with standard JIRA login interface.
[Connection Check] Button should be eliminated after authorization way changes.

1. https://bitbucket.org/atlassian_tutorial/atlassian-oauth-examples?_ga=2.54104875.2079049791.1515494767-1869284875.1510048839
2. https://developer.atlassian.com/cloud/jira/platform/authentication-for-apps/
3. https://github.com/googlesamples/apps-script-oauth2

Support requests for more than 1000 issues

Hi, I suggest turning on the option «Get All Issues (1000+)» by default.
Progress bar it's not a trivial feature and I guess you may implement interactive count of fetched issues. You don't know the whole amount of issues but you can count currently fetched tickets.
It provides a good level of transparency.

Getting connection failure with same login that works

While using the same credentials for jira most times the request or connection fails. And at time it works.. For a co-worker it works always for him with his credentials.

Issue with retrieving available options for a multi-select customfield

Issue with retrieving available options for a multi-select customfield.

The custom field is a multi select field. When I select this field for retrieval, "[object Object]" is what getting written to the spreadsheet.

Any thoughts!!

Storage issue

Hey! I realized you maybe are not working on this project anymore since it no longer appears on the google marketstore, but I am having an issue and I hoped you could point me in the right direction.

I am getting the following error when fetching settings, I believe since the storage is no longer working:
ScriptError: Exception: Data storage error

If a server change is needed could you point me to where in the code to make said change so I can provide it with my own server?

Many thanks.

Onboarding

Add some sort of onboarding for project

Merge all steps into one

There is no point now in having all pages separate, it only affects performance and user experience. All pages should be merged into one page with several tabs.

"SyntaxError: Expected end of stream at char 4"

Getting this error when getting the result.

Connection to Jira is fine.
Same error no matter what JQL i use.

custom fields

Hi BlackCatter,

It's possible to help me with the configuration of custom fields?

I have two custom fields that I would like to add in my google sheet table (customfield_10105 and customfield_10104), but I can't find a way to do this.

I have the setup done, but I don't see any options fields or a group called Custom Fields to add any custom field by writing it's name in JIRA.

Can you help me on this configuration?

Redesign UX

There are some obvious problems with current design.

• Checkboxes doesn't work with multiple lines well
• Custom field regular expressions are a mess
• Send request button at the last tab is not responsive enough

Connection does not work with same credentials

Hi,

I am getting connection error while using the same credentials as usual.

Maybe it is related to this mail I received from Atlassian a while ago :

At Atlassian, we take your security seriously. That's why we've introduced support for API tokens on all Atlassian Cloud sites, replacing Atlassian account passwords for all Jira and Confluence APIs.
--
This means you may need to take action.
By 3rd June 2019, if you're using a REST endpoint in Jira or Confluence Cloud with basic authentication, you will need to have updated your app or integration to use an API token, OAuth, or Atlassian Connect. | By 3rd June 2019, if you're using a REST endpoint in Jira or Confluence Cloud with basic authentication, you will need to have updated your app or integration to use an API token, OAuth, or Atlassian Connect.

Do you think basic authentification still works with your plugin (which is awesome btw) ?

Thanks

Nicolas

Return issue sorting feature

Return issue sorting by it's epic parent. Was implemented before, but got disabled due to another features.

Fix tracking code for JIRA2PM website

Causing annoying warning in google analytics

Error 400 when fetching issues

Error 400 is displayed whenever fetching issues from JIRA.

For further information I'm logged in with a JIRA API Token, and the fields I am displaying are Key (as a link), Summary, Project, Priority, Status, Asignee, Reporter and Created.

The issues are not fetched and the api gets stuck.

Rework options saving

Takes a lot of calls to resave options. Caching mechanism for options should be implemented to resolve this issue

Bug. Fetch only 100 issues when user send an empty JQL request

When I send an empty JQL request this addon post only 100 issues to google sheet table. There isn't expected result according to API documentation.

Last Comment made in Jira issue

Is there a way to pull the last comment made in the Jira issue?

Refresh every.. not working

Firstly, thank you for the add-on.
Issue: Using the add on for the first time.. wanted to check how does Refresh every work. deleted last row from the sheet, have set to refresh every 1 minute but it didn't work. Also, tried with Refresh every 1 hour. Please help. @cnd @korabelnikov @reshetov-integer @artsocode @bychenkov

like your approach

Hi guys, just came across your add-on while i was updating my release Jira Sheet Tool.

I like your sidebar approach and the more techi way of providing JQL editor for the more advanced users.

Maybe you guys are interested of joining forces and do 1 awesome add-on rather than 2 (just) good ones? :)

Retrieving custom fields

Hi!
Thank you for this amazing Addon!!!! it saved my life!! :)
I have a customized field which i need retrieved, how can i do this and see it added to the sheet?
Thanks!

Custom field of type multiple versions shows as Object

Hello,

We have a custom field of type multiple versions (Advanced). When pulling that field, we get "[object Object]" instead of the actual value.

Add Helpers to the Request Fields

Hi! I think it's not so hard to add icon (?) nearby some fields to link a wiki page with additional information about functionality.
For example, a configuration of custom fields by RegExp it is very difficult and volume theme. And you may help a user to find relevant tips and tricks by direct link to the wiki page