chriscorcoran

@James Ainsworth thanks, its what I thought but just wanted to double check before I started

@James Ainsworth It was just to copy a load of sub categories from of our other services to a newly created service. We split our root categories by service, we dont share across services as they tend to be different in most cases. For example Category Service1 > Sub Cat > test1, test2, test3, test4 etc Category NewService > Sub Cat > copy the ones in Service1 plus new ones (would be useful if I can grab the sub categories from Service1 to save me time retyping.)

Is there a way to copy categories from one service to a newly created one?

In my business process when a call is resolved it goes back to the service desk team for a period where it is either automatically closed by the timer or manually closed by the analyst. We had a case this week, where a call was resolved, then reopened (before it was closed). The reopened call followed the process and went back to the team but because it was marked as resolved it automatically closed after the set time in the process, so the person working on the call lost visibility of the ticket from their view. Can anyone suggest a better way so that if a call is reopened it stops closing automatically and must be resolved, or passed back to the service desk a second time and closed manually?

I have setup a new transport rule in office 365 to warn staff of emails from outside the orgainsation. I want to exclude emails from hornbill, I can't for the life of me workout what email address\domain emails are coming from. I have included everything I can think off. ANyone have ideas? thanks

Thanks! @Nanette

Are there any issues with email being sent from hornbill this morning?

Seems a lot better now! Thanks if anything was done

Happy New Year, Hornbill team! I'm finding Hornbill really slow this morning, failing to load requests lists and email inbox, not sure if anyone else is seeing this? All other internet sites seem to be reposning fine.

I have created a couple of extra fields in the request details section. I need to report on those fields. How do I find out what they are called in the reporting console? I assume they will be called CustomA etc?

@Steve Giller not sure if its officlally been fixed but I have switched back to csv using the latest R script and my dashboards are now updating OK. Thanks.

script attached, im using minus instance and key hornbill script.txt

Hi @Steve G I have given it a try today but getting error below. I noticed the report seems to be still trying to output as csv even though I selected xlsx, thanks

@Steve G Thanks, I will keep my eye on here.

@Paul Alexander thanks, thats what I'm seeing.

I have gone back to the report it is using in Hornbill and when I export the csv the report is corrupt. Looks fine in preview. Are there issues with the reporting?

spoke to soon getting the following when I updated the script in my source settings OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)).

My bad, typical man, hadnt read through readme, I forgot the issue of Details: "Unable to translate bytes [E2][80] at index 0 from specified code page to Unicode. is caused by UTF-8, chnaged it to ISO-8859-1 This will usually be "UTF-8", but if you have issues returning data with certain characters (the Windows E2 80* characters are the usual culprits) then choose a different character set to use, ie: "ISO-8859-1"

I did notice a new script posted in git so I have tried thet but now get We encountered an error while trying to connect. Details: "Unable to translate bytes [E2][80] at index 0 from specified code page to Unicode." Tested on two seperate reports that use R and both fail with the same error.

Just refreshing a report this morning and getting the following erro, nothing I know of has changed. I have set myself a new API key just in case but I still get ADO.NET: R script error. Error: Argument 'txt' must be a JSON string, URL or file. Execution halted Any ideas?

Also sites are no longer picking up when raising a call. You can get the site form the list once a call has been logged. Not sure if thats the same bug?

thanks @Alberto M and @HHH

Over the last few weeks when raising a call, the customer name is not pulled through from the database. If you go back and try again it often works. You can type the name in and it finds the customer but all calls when raising show customer as blank, even when they have a record in the database. Any ideas? All users are using Chrome.

thanks @Keith Stevenson yes it seemed to resolve after a few hours. Thanks

Morning, anyone else getting POP3 read failure emails into Hornbill mailbox this morning? There was a problem reading mail from the POP3 account:Server: outlook.office365.comPort: 110User: Password: The error reported by the server was:ChilkatLog:FetchByMsgnum(61984ms):DllDate: May 23 2020ChilkatVersion: 9.5.0.83UnlockPrefix: HRNBLL.CBX102021Architecture: Little Endian; 64-bitLanguage: Visual C++ 2019 / x64VerboseLogging: 1Component successfully unlocked using purchased unlock code.msgnum: 1PopCmdSent: LIST 1sendCommand: Elapsed time: 0 millisecPopCmdResp: +OK 1 59356getOneLineResponse: Elapsed time: 16 millisecfetchSingleFull(61953ms):PopCmdSent: RETR 1sendCommand: Elapsed time: 0 millisecFailed to read beginning of SSL/TLS record.b: 0dbSize: 0nReadNBytes: 0idleTimeoutMs: 60000Failed to receive more TLS application data.tlsApp: Socket operation timeout.elapsedMs: Elapsed time: 61938 millisecpop3_getRetrResponse1: Socket operation timeout.Failed to receive 1st line of response from POP3 servergetRetrResponse: Elapsed time: 61938 millisecFailed to fetch POP3 emailmsgNum: 1--fetchSingleFullFailed.--FetchByMsgnum--ChilkatLog