For this exercise we are going to base ourselves on 2 posts that we detail below: For the exercise, we will go to our personal Gmail account and create a Google Sheet Note that the name of the Sheet/Page is “people“ Now we are going to create the Google App Script, for this, we will…
Read MoreHow to connect Power BI to Jira Cloud using the new Token Auth
After the deprecation of the Basic Auth in all Jira Cloud instances, a lot of apps needs to be reconfigured ( in this case the Jira integration settings). Deprecation notice – Basic Auth – Jira Cloud – Atlassian After this change, there is a lot of confusion of how to setup the new settings. Need…
Read MoreIs there a way to change the “Resolution Date” in Jira?
First you must read this trick: Example of script field in Jira to know the Closing date After this, try to: Just export a CSV of the issues you need to update. Add a “resolved date” column, populate dates, then import into JIRA as Admin via External System Import. Note1: If you CSV contain more…
Read MoreScriptRunner for Jira – Script Fields trick to use Common Classes
For a large scripts exist a trick to reduce the complexity of the Script Fields if you use classes that can be “common” and reused between other Script Fields. For example, imagine we want to create a Script field that show a report HTML inside the tickets with the Lean metrics. Something like this: And…
Read MoreCreate sub-task with specific label with Scriptrunner and Jira Server
Usually we want to create automatically subtasks in a transition and sometimes with a specific label. We use usually the plugin Adaptavist Scriptrunner in Jira Server to do tasks like this. Just creating a Postfunction in the Workflow. We can use the “Create Sub-task” script Postfunction with the usual parameters… In the “additional issue…
Read MoreHow to merge some Jira Cloud projects into an existent Jira Server instance
Imagine this situation Currently we have JIRA Cloud and JIRA Server instance running. Both instance were up and running, having data in both instances. We want to merge both JIRA Cloud and JIRA Server instance into the JIRA Server instance. Explanation We can not import JIRA Cloud as a project into JIRA Server directly. We need to…
Read MoreAutomatically Import Jira Backlog Into Google Spreadsheet
Amazing post of bluemonkey, see here
Read MoreHow to Export/Import Space in Confluence
Very easy! Go to your Confluence SPACE settings (Space Tools –> Content Tools) and Select “Export to XML” Then export to generate the .ZIP file Then go to the Confluence “Administration Page” and select “Import Spaces” Click in “Import Spaces” and upload your .ZIP file to Import. Link to Cloud Project isn’t Mandatory let it…
Read MoreHow to change the issue creation date in JIRA
You have two options: Change it using CSV Import (more info) Change it using a database Update (more info, depends on the version of JIRA)
Read MoreApache Tomcat Tricks
Cloud Servers Virtual Machines Native Installers Configuration file(s) /opt/bitnami/apache-tomcat/conf/server.xml /opt/bitnami/apache-tomcat/conf/server.xml install_dir/apache-tomcat/conf/server.xml Log file(s) /opt/bitnami/apache-tomcat/logs/* /opt/bitnami/apache-tomcat/logs/* install_dir/apache-tomcat/logs/* Default port 8080, 8443 (SSL) 8080, 8443 (SSL) 8080, 8443 (SSL) AJP port 8009 8009 8009 System user account tomcat tomcat tomcat Service control sudo /opt/bitnami/ctlscript.sh start|stop|restart tomcat sudo /opt/bitnami/ctlscript.sh start|stop|restart tomcat install_dir/ctlscript.sh start|stop|restart tomcat How to configure the…
Read MoreeazyBI JIRA add-on cannot cancel IMPORT ( seems ZOMBIE the import process)
Connect to the MySQL eazybi_jira database Launch this sentence “SELECT * FROM eazybi_jira.source_applications;“ Change the status to “imported” for example
Read More