Steven Cotterell
-
Posts
199 -
Joined
-
Last visited
-
Days Won
1
Content Type
Profiles
Forums
Enhancement Requests
Posts posted by Steven Cotterell
-
-
Thanks @Steve G. An iBridge utility would be useful, for this and I imagine, other purposes. it seems a shame that one custom field per datetime value has to be used just for the purpose of being able to display that datetime value in the appropriate timezone, when really, whenever you would want to display a datetime value, in the vast majority of cases it's unlikely that UTC will suffice. (Hope that makes sense.)
-
@Steve G - Hope you had a good & well deserved break.
Superb!! Thanks for following this up. Sorry to have created more work for you guys, but hope this helps others out in the future.
I'm determined to get this posting to Teams working. This has been more work than I/we expected, given how easy it was with our previous ITSM tool. Still a few more teething troubles to get sorted (see my other post re: Date fields showing as UTC in 'HTTP Request' post to Microsoft Teams ) - we are really keen to get this sorted.
-
+1 from us too please. We could use this. We have all our 'services' that we offer to our customers patternized, so at some point we would like to automate the build of the services directly from our patterns making it as much as 'single button press to deploy' as possible.
-
1
-
-
Thanks from us too @Steven Boardman. Would folders still possibly be on the roadmap to group the views better?
-
Good morning @James Ainsworth, I really appreciate your reply.
I take it then from your update that it's not possible to populate a custom field with a date/timestamp and have it formatted correctly according to the persons profile? The date/time custom fields look to be only populate'able from a date/time picker, but say if you wanted to take the date/time a ticket was raised, add some time onto it (like for example setting an expected delivery/completion date of 3 days after a ticket was raised) and populate a custom text field with that for subsequent communications directly from Hornbill (be that viewing in a ticket or in an email sent from Hornbill), that it would only be displayable in a UTC format?
Yes, our current goal is to get the 'Scheduled Start & End' dates & times posted to a Microsoft Teams message to advise the company when a Change Request is due to be implemented, following its approval. Also when a Change is started and finished.
Another requirement I have been challenged with is to get the details of any High Priority Incidents posted to Microsoft Teams when any are raised. This would naturally need to include the date & time the Incident was raised. Subsequently any notable updates which have dates/timestamps would need to go to Microsoft Teams, e.g. SLA Target breaches, Resolution Updates.
Thanks James.
-
On 8/20/2019 at 8:57 AM, Steven Cotterell said:
Still happening this morning. Screenshot attached shows trying to add a file that is larger than 10MB. I can add this file from the Analyst view, just cannot do it from the customer's perspective in the Customer portal. File is 19,999,999 bytes.
Again, today we had an instance where the customer needed to attach a file larger than 10MB.
Is there any reason why on the customer portal this is limited to 10MB, yet as an Analyst you can add a file up to 20MB?
-
On 8/30/2019 at 2:33 PM, Steven Cotterell said:
Can someone from Hornbill please review and comment. What do other people here in the community think of this??
Morning all.
Another week begins and dare I say it, but another week closer to the 'C' word!
.
.
.
Yes that's right, "Collaboration". (Sorry, couldn't resist)
My latter attempts on Friday to get updates relating to requests out into Microsoft Teams looked really promising, until I hit what I really think must be a 'bug' or a coding oversight in the 'Update Request' node in the Business Process Designer.
I would really appreciate it if someone from Hornbill (and other community members) could review my last post and see what you think.
Cheers.
-
On 8/27/2019 at 12:06 PM, Dan Munns said:
Hi,
Could we have an option to create a new email template from within the BPM.
Ideally a pop out email template editor from the template selection field if you select 'New...' or similar but even the option to open the email template editor in a new tab when selecting 'New...' would be good.
Thanks,
Dan
+1 for us too - prefer this method.
-
I've been exploring other ways of getting date fields to be displayed in a non-UTC format and thought I had cracked it.
Sadly not - but I feel I must be close some how.
In my testing BPM I decided I would try using an 'Update Request' node to populate a TEXT field with the date field and surround this with square brackets, as per the WIKI (see below)
I am then using this custom field in the JSON payload, (by the way, note the typo in the Response Parameters section "Status Cose" instead of "Status Code" - oops - one for bugfix I think)
However, I'm still getting the field being displayed in UTC time.... aaaaarrrrggghh. Just adding the square brackets in the 'Update Request' node just seems to literally 'add square brackets around the UTC time stamp'.
I really did not expect THIS behavior as I was using the square brackets within a Hornbill managed operation, just like you would quite successfully use square brackets around a date/timestamp when formulating an email body.
Surely this is not the right behavior for an Update Request. You could quite legitimately want to populate a custom field with a date/timestamp and have it formatted correctly according to the locale for someone to see in a request.
Can someone from Hornbill please review and comment. What do other people here in the community think of this??
Cheers.
-
+1 for us too please. This was asked of me a few weeks ago and they accepted my answer of 'not doable within the current config', so would be nice to surprise them soon.
-
Thanks @Steve Giller & @James Ainsworth for your assistance so far with this, but I have hit a real road block with being able to change the time to be displayed from UTC to a BST variant.
Firstly the URL that has been shared in this thread (and others) which shows how to construct the 'Input Format' & 'Output Format' fields is not the correct one. The 'codes' that describe the different values are incorrect. I have found a more accurate URL which you might want to share with others in the future and update the WIKI to point people to. The URL is https://www.php.net/manual/en/function.date.php
Secondly, all the 'Date Formatter' integration seems to do is just alter the 'look' of the date/time, e.g. change how the month is displayed from '02' to 'Feb' or change the minute to be a single digit value if the minute value is between 0-9, etc....
I cannot find anything that will allow me to take the 'UTC Date/Time' that is stored in the DB and output it to a field that I can use in the HTTP Post as a 'BST Date/Time'.
The way it's looking at the moment, I'm going to have to give up any hope of getting a post containing a timestamp into our Microsoft Teams channel that makes sense, unless someone can come up with some magic ( @Victor or @Steve G any ideas please....??? )
Even if we were using the Microsoft Teams integration itself I believe we would still have this issue.
The Input Format I am using is:-
- Y-m-d H:i:s
I have tried the following Output Formats (not necessarily in this order):-
- Y-m-d H:i:s eP
- Y-m-d H:i:s TZ
- Y-m-d H:i:s e
- Y-m-d H:i:s Z
, and none of these will add on the extra hour to reflect the time in BST.
-
On 8/22/2019 at 6:34 PM, Steven Cotterell said:
Hi @Steve G,
Have added a custom button to a Service Request and I'm trying to use the 'HTTP Request'' iBridge integration to post to a Webhook in Teams as per your earlier post.
I have two questions....
Why do I get the 'Credentials' box showing as a mandatory field for the 'HTTP Request integration?
Also, why am i getting the following error whenever I click the custom button?
Thanks in advance.
Is there anyone that can answer this question please, specifically the one surrounding why, for the 'HTTP Request' iBridge integration which I believe does not require any credentials to be specified, is there a mandatory 'Credentials' field. Also, is this what could be generating the error in red (also shown in previous post in the EspServerService.log)?
-
Thanks @Steve Giller, saw that link on the original link that James sent me. Still not 100% sure I follow how to make it do the conversion.
I have put something together in a BPM. Will try it out, but I think it's going to be a lot of trial and error until I hopefully get it working.
Was hoping someone could give me the correct input & output strings to show a GMT date & time - we are already well behind on getting Hornbill communicating with Microsoft Teams for notifications on Change Requests.
-
@James Ainsworth, also looking at the PHP page you linked, I'm still not clear how I would get the date/time formatted to BST. I can see how you can use this to change the physical formatting eg '2nd February 2019' instead of '02/02/2019'.
Could you (or someone else) elaborate please?
Thanks in advance.
-
Thanks @James Ainsworth, so let me understand your response.
Are you saying that before I call the 'HTTP Request' Cloud Automation node, I will need to insert two 'Date Formatter' Cloud Automation nodes and utilise two custom fields as 'temporary' fields and then use these custom fields in the BODY for the HTTP Request?
-
Hi,
In a test BPM I have set-up an iBridge (Cloud Automation) node to use an 'HTTP Request' to post to a Microsoft Teams channel when a Change Request is scheduled.
The problem is that the 'Scheduled Start' & 'Scheduled End' date/time fields are being sent as UTC, not in BST.
This is despite taking the advice in the WIKI to wrap any date/time field in 'square brackets' to get it to use the profiles regional settings.
Anyone have any ideas?
I did have an idea of pushing the two 'Scheduled' date/time fields to another two 'text' custom fields in the BPM and use these in 'BODY', but I dismissed this for two reasons.
- I wanted to maintain easy field management
- Also as the Scheduled date/times fields can be changed independently of the BPM at any time, I cannot always enforce updates to the custom fields.
Thoughts anyone please?
Thanks.
-
+1 from us - that would help maintain a better audit trail. Yes please.
-
1
-
-
@Steve G, I've found the logging in the EspServerService log and I cannot obviously see the error being caused by anything that I've put into the 'body' of the method call.
Any ideas?
Cheers.
-
Hi @Steve G,
Have added a custom button to a Service Request and I'm trying to use the 'HTTP Request'' iBridge integration to post to a Webhook in Teams as per your earlier post.
I have two questions....
Why do I get the 'Credentials' box showing as a mandatory field for the 'HTTP Request integration?
Also, why am i getting the following error whenever I click the custom button?
Thanks in advance.
-
+1 from us - we will be crying out for this soon. (no pressure @Victor)
-
1
-
-
+1 for this idea please .....we too have a lot of views and they've quickly become unmanageable.
-
1
-
-
18 hours ago, Steven Cotterell said:
Is there anyone that can look into this please - we have two occurrences this morning where our customers have wanted to upload a zip file of logs for us to investigate an Incident they have logged with us.
Thanks in advance.
Still happening this morning. Screenshot attached shows trying to add a file that is larger than 10MB. I can add this file from the Analyst view, just cannot do it from the customer's perspective in the Customer portal. File is 19,999,999 bytes.
-
Is there anyone that can look into this please - we have two occurrences this morning where our customers have wanted to upload a zip file of logs for us to investigate an Incident they have logged with us.
Thanks in advance.
-
24 minutes ago, Steve G said:
@Steven Cotterell Those utility operations should actually not be premium on your instance, they are free to use - I just had this switched on in my development instance from some previous testing...
I've just updated the datasource which is used to return the Teams as part of the Post To Channel operation, so that it's now a search box rather than a drop-down select box, and it'll also now not return security groups (which it was doing previously). Give it 5 mins for the content pack to get to your instance, then try searching with the first few letters of the Team group display name... Note - this will only do a "starts with..." search on the display name, as the MS API we're using to return groups doesn't support "contains" as an operator.
Let me know how you get on.
Cheers,
Steve
Works great now - I can get a 'valid' & accepted node in the BPM. Will get to testing it out to see if I can get parameter driven & meaningful content into the Teams message.
Thanks @Steve G for all the tweaks & help you've given.
Really appreciated. I hope this helps others to get good use out of the Microsoft Teams integration.
Steve.
-
1
-
Attachment Restriction - File Size Setting
in System Administration
Posted
@TrevorHarris
Thanks. Great news that the reason for the error is understood. I will feed this back to the team and will look forward to the new setting being implemented.
Cheers
Steve.