Jump to content

SamS

Hornbill Developer
 View Profile  See their activity

  • Posts

    1,511

  • Joined

  • Last visited

  • Days Won

    25

 Content Type 

Posts posted by SamS

    Custom Reports

    in Reporting

    Posted

    Hi @Hiten,

    First and foremost: a report which requires a prompt to be filled in, will NOT function as a scheduled report - the report scheduler will wait unsuccessfully for someone (somehow) to provide the parameter.
    You will need to hard-code multiple reports - filtered respectively for each customer.

    The filtering, in the suggestion above, would be done based on Service - customers who have access to the service will be able to see documents associated to that service. You would need to set up a "Report Service" for each customer.

     

    Ability to indent custom form fields one or two times

    in Progressive Capture

    Posted

    Hi @samwoo,

    You might want to try prefixing the question with a colon-character ":". It is part of the Wiki Markupand works only at the beginning of lines.

    Although the ":" and "*" characters will work as "expected", the "#" (numeric list) will NOT work (i.e. it will re-start the count for each question).

    The text box (and other answer field boxes) will NOT get the indentation, though.

     

    That being said, you could create dependent questions either by paging (i.e. if a certain answer is given on Page1 (Customized Form), show Page1b OR by playing with hiding fields and making them visible fields in the same page. Have a look at "Displaying Conditional Fields" on https://wiki.hornbill.com/index.php?title=Progressive_Capture_Designer (it comes with video).

    Potentially, you could also place the question itself in a span and play around with style.color (text color; background-color will NOT work).

    Custom Reports

    in Reporting

    Posted

    Hi @Hiten,

    In addition to the above: Reports can also be stored to Document Manager and then associated to a customer specific service - this way you don't need to send out any emails, anyone (from the company) logging in via the portal will be able to see the document/report.

    Regarding the sub-status data (your item #2), that is stored in the h_itsm_statuses-table.

    As for your item (report) #2:

    1. the "days since last update" calculation is NOT (currently) possible.
    2. Filtering out system updates is not (easily) possible, but invariably those (system) updates are generated by someone actioning the request (and thus it was at least viewed by an analyst).

     

    Pre Populate the Group picker for Division / Department / Costcenter on Intelligent Capture

    in Progressive Capture

    Posted · Edited by SamS
    confirmed that Group ID IS actually captured via IC (Raw selection is possible)

    Hi @yelyah.nodrog,

    Being somewhat familiar with the amount of Divisions/Departments/CCs, I would hesitate to suggest to create sets of simple lists to allow one to dropdown based on selection.

    What I would suggest: do not set this to the "h_department" field, but leave it to just "field_#" or, if you want to name it: "other_dept".

    Change the question to something along the lines of: "If not your standard department, please select the appropriate department". The same Group Picker does, already, allow one to search on various parts in the department name. The Group ID will then also be captured - though I cannot find a way in the BP to change the department of the request. If you need to report on this, then a custom field is the best option to place the info.

     

    Change Control Widget - filter on status

    in Reporting

    Posted

    Hi @QEHNick,

    Unfortunately, it is currently not possible to connect to a second table within the measures. The table one would need is the h_itsm_requests table.

    Another solution would be to allow the creation of measures based on "Entity" - a "Change Request" Entity would do the back-end database hook-up for you.

    Either solution would be considered a Feature Request.

    AzureAD Graph API - User / Group Sync

    in Integration Connectors, API & Webhooks

    Posted

    Hi @Oscar Stankard,

    You could indeed manage it with multiple configuration files and filters.

    That being said, there is a "Type" configuration which allows you manage the user type.

    Setting : 

     "Type": {
            "Action": "Create"
        },

    Set to "Create" in combo with a basic user in the regular configuration will make all new users to be "Basic", but, importantly will NOT modify the current status of full "user" users. So, with this (single) configuration, you just need to manually upscale the necessary users when they start.

    Anyway to change the captured data inserted into a BPM node for Azure automation?

    in Integration Connectors, API & Webhooks

    Posted

    Hi @Adrian Simpkins,

    There are a few solutions.

    You could modify the IC to ask for the firstname.surname instead or alongside the email address.

    You could also create a Human Task to have one of your people to sanity check and insert the (correct) firstname.surname for processing.

    Finally, you might want to have a look under Hornbill Automation where there is a set of "String Utilities" under the "Scope" of "Application" - you'll need the RegEx Substring with a "Regular Expression" of: 

    (.*)\@nhs\.net

    and "Flags" as: 

    /0,1

    that should "result" in what you are looking for.

    • Like 1

    Changing An Asset Class Via PowerShell

    in Integration Connectors, API & Webhooks

    Posted

    Hi @Rob Gething,

    It appears that you are changing the Asset Class. Each Asset Class is linked to a particular secondary table.

    Your API actions have likely broken the link between the main CMDB record and the secondary table data.

    I suspect you tested a few things with Asset 506 which changed that link in a different way to the assets you are currently testing. Hence the difference in behaviour/error message.

    IT is currently not possible via the GUI to change the Asset Class of an asset and there is currently no API to change the Asset Class of an asset either.

    The asset class data link mentioned might not be the only link maintained behind-the-scenes. It is ill-advised to directly manipulate the data without knowing/imagining the possible consequences.

    Email Templates - URLs not formatting correctly

    in System Administration

    Posted

    Hi @Jeremy,

    The best way of working out what is happening is to select/click the "Source" button.

    You then get a view of the HTML which makes up the email. From here it should be relatively simple to figure out what needs changing - provided you know:

    1. a little HTML (specifically how hyperlinks work: https://www.w3schools.com/html/html_links.asp )
    2. that Hornbill Email Template variables are between a double-set of curly braces (in case of:)
    3. Hornbill Email Template variables CAN be part of a URL - ensure it looks correct in the href-attribute

    E-mail Routing - adding details into a ticket

    in Service Manager

    Posted

    Hi @Emily Patrick,

    There is a "Task" of "Regex Substring" under the Scope of "Application", "Type" of "String Utilities".

    This makes it possible to extract specific data from a given Input Text.

    The Input Text can be the result of the Source Email Details of a Request.

    The RegEx that you will need is the "tricky" bit - it heavily depends on the exactness of the input text.

    At a GUESS:
      

    Regular Expression: ^Username:\s(.*)$

Regular Expression Flags: /0,1

     

    Is anyone willing/able to share a TimeSheet Report for billing time back to the Organisation of the Customers of Requests?

    in Timesheet Manager

    Posted

    Hi @Berto2002,

    The seconds field is actually not in use - at one stage this was the intended granularity, but with network delays the accuracy would be misleading.

    The other two fields are only in temporary use - by the app. Even though they populate for the time that the timer is running, the data gets removed once the timer stops.

    The data you are after is the in the "Time" field which contains when the entry was made and the "Minutes" field which holds how much time (in minutes) was spent - which you would want to sum.

×
×
  • Create New...