Steve G

@Jeremy Yeah that makes sense, I've added a new output parameter to both the Sheets operations that will contain the row number that has been updated/appended. I've just released them to live, so your instance should have the updates in the next 5 minutes. Let me know how you get on with this. Cheers, Steve

What's Changed Google Sheets iBridge integrations - new output parameter to pass back the number of the row that has been updated/appended.

Hi @Jeremy, As long as you know the row number, and the column you want to start stiring from, then this is possible with the Google > Sheets > Update operation. See ther Row and Starting Column input parameters here: Cheers, Steve

Hi @Dan Munns, Yeah you should be able to pick that out of the request description and tag on to the end of the request summary in the BPM workflow without too much of a headache. If you have 2 nodes in your workflow, one to grab the request details, and one to update the summary: And the Summary field is populated with: &[global["flowcode"]["summary"]] : &[global["flowcode"]["description"].match(/(WKS[0-9]{4})/) ? global["flowcode"]["description"].match(/(WKS[0-9]{4})/)[1] : "Not Found"] This will overwrite the summary with itself, followed by a colon, and then whatever has been matched by your regular expression from the description field. In my example, I'm looking for WKS followed by 4 numeric digits: You'll notice that the regex is being done twice - this is just a bit of ternary logic, to make sure that the workflow doesn't fail if the regex doesn't match anything. Cheers, Steve

Hi @Andytaylor93, The Hornbill API requires datetimes to be provided in UTC, and that is how they are stored in the database. When viewing request data (vi the main app), these UTC datetimes are displayed in the session users local timezone (BST in your case). Is the issue actually with Jira providing the scheduled datetime in your local timezone (BST) rather than UTC? Cheers, Steve

Hi @dwalby, I've had a cursory look at their API documentation and we should be able to implement some iBridge integrations to PivotalTracker easily enough, as they have RESTful APIs with pretty basic token authentication. What specific integrations were you thinking about? Giving their endpoint list a once-over may help for you to work out what we can do compared to what you need https://www.pivotaltracker.com/help/api/rest/v5#Endpoints Cheers, Steve

Whats New New Hornbill Service Manager integrations - Log New Change Request; Log New Known Error; Log New Problem; Log New Release. Whats Changed Hornbill Service Manager integrations, added new exception handling - Log New Incident; Log New Service Request. Whats Fixed iBridge integration - HTTP Request - Basic Auth. Fixed typo in output parameters display name.

Just to close this topic off, v1.8.0 of the asset import tool has fixed this issue. The latest version of the tool can be downloaded from here: https://github.com/hornbill/goDBAssetImport/releases/latest Steve

What's Changed Password Generator utility - added support to exclude specific characters from the generated password

Hi @Jeremy I've added support for the above in to the password generator utility, it's been released so should be on your instance in the next few minutes. Config as below. Cheers, Steve

Hi @MikeW, I've just given your config a whirl through v1.2.0 of the import tool (with a number of non-visible characters stripped out - I presume these were added by this forum though), and have been unable to replicate your issue Could you re-run the tool with the -dryrun=true command line parameter, and post the log file output so I can take a look, please? Thanks, Steve

Hi @Paul Alexander, The first message I'm not sure about to be honest, your Azure admin may be able to help with that. The second message suggests that the keysafe key that the integration node is configured against has been deleted? Could you check the integration node in your workflow and make sure it's got an active key defined against it? Cheers, Steve

Hi @SimonSheldon, The logs should be in a /log subfolder within the folder that holds the import executable. Cheers, Steve

Hi @David Longley, Re ITOM availability, you may want to follow this post Re attachments, no this isn't possible currently, as there's no method to pull the files together in the BPM to send to a Zendesk integration node. I reckon it could be done easily enough with a Powershell script though, so may be another job for ITOM... Cheers, Steve

The latest build of Hornbill iBridge Content Pack (123) has been released to live.Change Log for this release are as follows: Fix DocuSign Send Envelope Template integration - fixed issue where we were unable to populate envelope with multiple document tabs of the same type.

@SimonSheldon Yeah exactly, import your cost centres then follow it up directly with your user import. SQL would be the preferred option for us, the tool already supports SQL Server, MySQL, MariaDB and ODBC. I'll give @Victor a nudge to get it released, as he's the one who's been writing it Cheers, Steve

Hi @Paul Alexander, This will most likely be due to an Azure session being active in the current browser (or the Stay logged in option has been taken on a previous Azure login, so the session information is kept in the browser storage). So when keysafe launches the Microsoft page for authorisation, the MS page detects an existing account session and uses that for the key... Hard-logging out of Azure in your browser before trying to re-connect the key should fix this. Cheers, Steve

Hi @Izu, From that page, you need to click Releases to get to the executable downloads. Or visit the Latest Release page directly. Cheers, Steve

Hi @SimonSheldon, The LDAP import tool won't currently import new cost centre records if a match is not found. Are these cost centres just in your LDAP, or are they stored seperately in your accounts system too? The reason I ask is that we're in the process of writing an import tool for group type records (so cost centres, departments, teams etc) which could be pointed at a database or ODBC data source of your choice, that could be scheduled to regularly import any new cost centre records in to Hornbill. Cheers, Steve

Hi @David Longley, The custom button functionality can only write its output to a popup on the screen and/or in to a message in the request timeline. It can't actually write in to fields within the request itself for further automations to use I'm afraid - you can only do that with the BPM workflows currently. But! There is functionality on its way that will allow you to do this - as part of the ITOM release that Gerry spoke about at Insights, so watch this space Cheers, Steve

Hi @Paul Alexander, I've just done some testing, and that error is returned from Intune if the Azure user who the Keysafe key is created with doesn't have an Intune license, or access to those records. If the key is created with the details of a user who does have access to the record, the connector returns the device details as expected. I will improve that error message though! Cheers, Steve

@David Longley Sorry I should've been clearer - it's not in that node, it's the Update Text option in the Write Zendesk Details to Timeline node: Cheers, Steve

Morning @David Longley, Just had a look at the Zendesk API, and that returned URL is the one for the API rather than the web view - and they don't actually return the web app view URL in the API response. You could construct the URL in the workflow node that writes to the timeline though, so looking at your screenshot above you would replace: URL: &[global["integration"]["url"]] With: URL: https://sequelchorus.zendesk.com/agent/tickets/&[global["createticket"]["id"]] And on my instance this would look like: Cheers, Steve

Hi @Paul Alexander, I've made a few changes to the Hornbill Cleaner tool, it's currently at v1.10.0, and allows you to delete targeted sets of assets based on a single asset class and/or type. I wasn't able to allow multiple classes and/or types to be configured for deletion, as a change to Service Manager was required - which I've actually done, but Service Manager isn't due for release for a little while as yet, so until that's released you'll just be able to delete assets of a single class or type. Let me know how you get on with this. Cheers, Steve

@David Longley No worries, glad it worked for you Zendesk is pretty basic, and doesn't have the concept of resolution notes... But! To work around this limitation, I've added a couple more methods to the iBridge: One to get the last comment from a Zendesk ticket; One to get a Zendesk Users details (so you can get the comment author details from the last comment node). So you can now get the last comment that was added to the Zendesk ticket (which includes the author ID), and then go get the Author details (name, phone, email, role), before writing both in to your Hornbill request timeline. I've attached the demo workflow again, which includes the new nodes so you can see how they work. I've just promoted these new methods to live, so you should see them on your instance in the next few minutes! Let me know how you get on with these. Cheers, Steve zendesk.bpm.txt