billster

thanks Keith!!!!!

I am importing about 4k incidents from SW to HB and it is emailing analyst that requests have been assigned. how do I turn it off ??

never mind, I was able to achieve what I wanted by creating an inbound rule request with expression ... subject LIKE 'Automatic reply%' and had the match to move to mailbox deleted items folder. I put this rule at the top of the list. lol i keep forgetting things like this exist in HB.

did not work as in just skipped past it. I have the get source's email information. I tried to do with an abort control

Is there a workflow control that will tell Service Manager not to log a request? I have put a decision node in, and had the rule as "email subject contains X" and then it goes to an end process node. however, it still logged the request.

Hi @Jim do you know if there is a column that records the total time a request has been opened?

cheers mate !

Hi, is there a column within the main request table (or other) which records the amount of seconds taken for an incident to be resolved. I see there is one for response time though. https://wiki.hornbill.com/index.php/Table_Info:_Main_Request_Table

Hi, Has any one come across this issue when importing SupportWorks requests to Hornbill? 2024/02/26 11:22:30 [DEBUG] Retrieving File [hehe.pdf] from: D:/Program Files (x86)/Hornbill/Supportworks Server/data/cfa_store/1024/f10247089.001 2024/02/26 11:22:30 [ERROR] File does not exist at location If I browse to the location, I can see the file in question. Thanks

Hi Jim, you could use Last Pass for auto login on the website. You could set the web browser's start up page to the catalog item link, like https://live.hornbill.com/instance/catalog/new-service-request/com.hornbill.servicemanager/15/59/ and when Last Pass signs in automatically, it will redirect you to the catalog item page. I'm unsure if there is a way to have a public facing catalog item, but you could set up email messages to create automatic requests. Thanks

yipeee..looks to be working now...i put it inside of parallel processing nodes.

Like, if I update the incident description, and put the call references from analystGet (Get User Details Automation node) it displays data from customerGet (Get User Details Automation Node). so, if I paste this &[global["flowcoderefs"]["analystGet"]["name"]] into the description of the incident. It gives me the name from &[global["flowcoderefs"]["customerGet"]["name"]] e.g. like &[global["flowcoderefs"]["customerGet"]["name"]] = Markus And &[global["flowcoderefs"]["analystGet"]["name"]] = Billy But when I paste &[global["flowcoderefs"]["analystGet"]["name"]] it shows as Markus

tbh I noticed that and changed it but it didnt make any difference. When you are writing the values to the description, where you have shown them in the screenshot the one you have redacted what are the parameter references in there? They are shown on the actual incident page

Weirdly enough, if I delete updating the customer Hornbill Automation, then updating the owner automation works..

hi Steve, I am using Get Request Information to load the data from the custom fields.

Yes, everything is correct. these are mapped through the import config file. if I return h_custom_c on its own, it returns the right thing. For some reason, just the Owner thing is not working.

Hiya Jim - yes tried this but still the same results...

@Steve Giller @Jim hmm just noticed something weird..... I have two "get user" Hornbill Automations Each with either own unique names.... analystGet and customerGet. Analyst get is used to get the user information from H Custom C which is the Analyst's employee ID. And Customer get is used in the same way by H Custom B instead. But... when I call results from the analystGet Hornbill Automation, it returns customerGet instead??? is this a bug? or can you only have one of these automations per flow???

perfect, works a treat

Hello, I am running a report and I want to do a LIMIT BY 1 to get the latest record in the table as it is pulling through every record there is (per Request ID). I want to have only the record which is circled in blue. here is how I am getting the report...

hi Steve, yes, tried this but in HB just returned blank, even if used h_custom_t for TEXT value... its ok as I am using the below now.

Yesss, I was reading the PHP manual last night before I signed out. shame there is no dd/mm/yyyy format, but I've gone with this instead which is easy to read. F j, Y, g:i a // March 10, 2001, 5:16 pm

this

Yess!! this changes it from timestamp to sql date time you are a genius... tbh I was halfway there, I put the unix timestamp in starting timestamp!! Grrr but for some reason I cannot format the date..... I want to change this --- 2024-02-01 10:04:31 which is set up like yyyy-MM-dd HH:mm:ss but if I try this format dd/MM/yyyy hh:mm it doesn't do anything LOL

Hi Jim, yes-no way to change the date closed after the fact. however, in the reporting, I have unselected DATE CLOSED in favour of the custom mapped field imported from Support Works only thing I need to figure out is if I can use the Hornbill Utilities Cloud Automation to convert the date from EPOH/Unix but looks like it only converts already formatted dates like y-M-d h:i:s to d/m/y h:is Thanks