Tag: "visual-basic"

I have read this article: https://community.atlassian.com/t5/Jira-questions/How-to-authenticate-to-Jira-REST-API/qaq-p/814987 Also able complete basic authentication login on a standard Jira server ...

• Jira
• Question
• authentication
• cloud
• jira
• jira-software
• jira-software-cloud
• +1 more tag...

Hi, I have a excel file stored on confluence with data that needs to be updated now and then.  I want to be able to open the excel file stored on confluence in edit mode and add data to the fi...

• Confluence
• Question
• confluence
• edit
• macro
• ms-excel
• visual-basic

Hi all, I'm working with Excel to access the xml data, in my test case, access a specific ticket. I'm using the handy VBA function created by Tim Hall. This seems to be widely used. I successfully...

• Jira
• Question
• jira
• jira-server
• json
• server
• visual-basic

Hi, is there a good and maintained plugin for Bitbucket Server to navigate code with CTRL+Click for  .Net (C# + VB.Net) ? I found Code Navigation for Bitbucket | Atlassian Marketplace&nbsp...

• Bitbucket
• Question
• .net
• bitbucket
• bitbucket-server
• c
• server
• +1 more tag...

Hello, I have multiple excel files regarding my projects in my computer and I have also pages for every project in my company's confluence space. So when the excel is updated, I wanna update automati...

• Confluence
• Question
• confluence
• confluence-server
• ms-excel
• server
• update
• +1 more tag...

...sxml3.dll This the code I'm using Public Sub setStatus(ByVal issueId As Long) Dim oJIRA As Object Set oJIRA = CreateObject("MSXML2.XMLHTTP") With oJIRA .Open "POST", sURL &a...

• Jira
• Question
• error
• jira
• jira-server
• server
• transition
• +1 more tag...

I have successfully extracted a number of documents we have in Jira Work Management and parse the XML and put data into an access database to make some queries and reports. Now I want to automate th...

• Jira
• Question
• jira-work-management
• visual-basic
• xml

I am wondering how to get the specific attachment link/url from a Jira issue using VBA. Let's say my jira issue is FXX-123 and has multiple attachments. I would like to get the link only for the atta...

• Jira
• Question
• cloud
• jira
• jira-cloud
• rest-api
• visual-basic

...ith ActiveSheet.Cells(rs, 8).Value = ResponseTxt Set JiraService = Nothing Next End Sub ' Module CommonFunction Public Function EncodeBase64(text As S...

• Jira
• Question
• cloud
• jira
• jira-cloud
• rest-api
• visual-basic

Hi, everybody!    I’m trying to get the active Sprint ID using REST API in VBA Excel. I successfully got authentication, but when I try to get the Sprint ID, I have got the following mess...

• Jira
• Question
• api
• cloud
• jira
• jira-cloud
• ms-excel
• +3 more tags...

Hi everyone I am writing a script in VBA to pull issues from my server and populate it into Excel. Everything is working the only problem being I have to manually enter the number of elements in the ...

• Jira
• Question
• jira
• jira-server
• ms-excel
• rest
• rest-api
• +2 more tags...

I followed this guide:  https://developer.atlassian.com/server/jira/platform/basic-authentication/ I entered the line into command prompt: "curl -H "Authorization: Basic MYBASE64STRING" -X GE...

• Jira
• Question
• api
• jira
• jira-server
• ms-excel
• rest-api
• +2 more tags...

So in JIRA if you export the issues (Export->CSV) you get get it into Excel. I am trying to make a button in Excel using VBA that will get the data for me. How do I do this? (Not using cloud). Tha...

• Jira
• Question
• jira
• jira-server
• ms-excel
• server
• visual-basic

Hello Jira Community I am trying to develop a little Excel tool to access to Jira's table and hopefully be able to modify several records at once depending on epic and other criterias. But for the ...

• Jira
• Question
• cloud
• external
• jira
• jira-cloud
• visual-basic

I am looking for an end to end working example,  I have been to all the links I can find, but have been unable to put together a working vba version.  Any help would be most appreciated &n...

• Jira
• Question
• developer
• jira
• ms-excel
• visual-basic
• worklog

columnaIdJira = Sheets("Params").Range("B4") sUsername = Sheets("Params").Range("B2") sPassword = Sheets("Params").Range("B3") 'Se codifica las credenciales en Base64 para poder realizar la conexi...

• Jira
• Question
• api
• atl-adm
• developer
• jira
• jira-core
• +1 more tag...

Session (cookie) has been successfully created api/2/issue/{issueIdOrKey} ,api/2/field all work OK. Only api/2/search with a jql query (to search for a specific project) returns error. (Works...

• Jira
• Question
• cookie
• jira-software
• rest-api
• visual-basic

I'm working on a project in MS Excel. The VBA source code is stored in modules. I can check in/out the whole XLSX file but is there a way to compare side by side the modules source code?  The o...

• Bitbucket
• Question
• bitbucket
• compare
• developer
• microsoft
• module
• +3 more tags...

I am able to create parent and sub-task with below format json using VBA. But, my requirement is to create parent and sub-task together. So, I will not be able to provide the id/key for the par...

• Jira
• Question
• api
• jira
• rest-api
• visual-basic

Trying to add new user, by posting user details in to REST API: "/rest/api/2/user". If i use postman utility then it works fine. But, if i use VBA code for the same then it throws the error "This re...

• Jira
• Question
• jira
• jira-server
• jira-software
• rest-api
• server
• +1 more tag...

Hi, I am trying to logon to JIRA using VBA and access a predefined filter for issues and then export it as a JSON file. I took help from old posts on this forum but so far no success in getting the...

• Jira
• Question
• jira
• visual-basic

Hello I'm attempting to write code that will allow an issue to be created in Excel and uploaded to the project as with VBA. I#ve read a bit about it from the community but my understanding of VBA is ...

• Jira
• Question
• jira
• ms-excel
• visual-basic

Hi Guys,  i created macro where i did output folder with 2 Excel files.  And now i want to use my macro to push these files to remote repository.    My idea is to copy my crea...

• Sourcetree
• Question
• automation
• bash
• code
• ms-excel
• script
• +1 more tag...

Hi Folks! I'm doing Confluence-Page synthesizing via VBA. Now I need to insert JIRA-Tickets into the page. When I just insert the URL into the HTML-Source-Code, the page ends up with displaying the...

• Confluence
• Question
• confluence
• jira
• macro
• url
• visual-basic

Trying to get familiar with REST calls and require some assistance. The problem that I am facing is different behavour in two different projects on the same instance when called from two differe...

• Atlassian Account
• Question
• api
• chrome
• developer
• jira
• ms-excel
• +2 more tags...