Jump to content

Steven Cotterell

Hornbill Users
 View Profile  See their activity

  • Posts

    199

  • Joined

  • Last visited

  • Days Won

    1

 Content Type 

Everything posted by Steven Cotterell

  1. Steven Cotterell
    @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.
  2. 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.)
  3. Steven Cotterell
    @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.
  4. Steven Cotterell
    +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.
  5. Steven Cotterell
    Thanks from us too @Steven Boardman. Would folders still possibly be on the roadmap to group the views better?
  6. Steven Cotterell
    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.
  7. Steven Cotterell
    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?
  8. Steven Cotterell
    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.
  9. Steven Cotterell
    +1 for us too - prefer this method.
  10. Steven Cotterell
    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.
  11. Steven Cotterell
    +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.
  12. Steven Cotterell
    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.
  13. Steven Cotterell
    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)?
  14. Steven Cotterell
    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.
  15. Steven Cotterell
    @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.
  16. Steven Cotterell
    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?
  17. Steven Cotterell
    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.
  18. Steven Cotterell
    +1 from us - that would help maintain a better audit trail. Yes please.
  19. Steven Cotterell
    @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.
  20. Steven Cotterell
    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.
  21. Steven Cotterell
    +1 from us - we will be crying out for this soon. (no pressure @Victor)
  22. Steven Cotterell
    +1 for this idea please .....we too have a lot of views and they've quickly become unmanageable.
  23. Steven Cotterell
    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.
  24. Steven Cotterell
    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.
  25. Steven Cotterell
    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.
×
×
  • Create New...