Richard Williams

Hi, I am trying to use the Hornbill data export tool. my config file is setup as follows: { "APIKey": "*****", "InstanceID": "*****", "Database":{ "Driver": "mssql", "Server": "WFSQLTEST", "Database": "Hornbill_AD_export", "Authentication": "Windows", "UserName": "svcintSqlServer2", "Password": "*****", "Port": 3389, "Encrypt": false }, "Reports":[ { "ReportID":209, "ReportName":"Test update of Active Directory", "DeleteReportInstance": true, "DeleteReportLocalFile": false, "Database":{ "TableName":"tblAD_Update", "PrimaryKey":"samaccountname", "Mapping":{ "SamacCountName":"samaccountname", "GeneralTelephone":"generaltelephone", "OrganisationDepartment":"OrganisationDepartment", "AddressStreet":"addressstreet", "ManagersamAccount":"managersamaccount" } } } ] } after I run the utility exe I get the following output from the log file 2019/06/26 13:54:20 ---- Hornbill Data Export Tool v1.2.0 ---- 2019/06/26 13:54:20 Flag - Configuration File: conf.json 2019/06/26 13:54:20 Flag - Debug: false 2019/06/26 13:54:20 [DEBUG] Loading Config File: D:\Hornbill data export - TEST/conf.json 2019/06/26 13:54:20 Instance ID: walthamforest 2019/06/26 13:54:20 [DEBUG] Connecting to Database Server: WFSQLTEST 2019/06/26 13:54:20 2019/06/26 13:54:20 Running Report: Test update of Active Directory [209] 2019/06/26 13:54:20 Checking Report Run ID [923] for completion... 2019/06/26 13:54:23 Checking Report Run ID [923] for completion... 2019/06/26 13:54:23 Retrieving CSV Report File Test update of Active Directory_923.csv... 2019/06/26 13:54:23 Retrieved report data from D:\Hornbill data export - TEST/reports/Test update of Active Directory_923.csv 2019/06/26 13:54:23 Processing 4 Records from Test update of Active Directory_923.csv... 2019/06/26 13:55:23 [ERROR] [DATABASE] Ping Error: read tcp [::1]:49464->[::1]:3389: wsarecv: An existing connection was forcibly closed by the remote host. 2019/06/26 13:55:23 [ERROR] Unable to map any values from the returned record: 2019/06/26 13:55:23 [RECORD] {"addressstreet":"92 Leyton Green Rd E10 6DA","generaltelephone":"020 1111 2222","managersamaccount":"STorres-Catmur","organisationdepartment":"Chief Executives","samaccountname":"LGiles"} 2019/06/26 13:55:23 [MAPPINGS] null 2019/06/26 13:56:23 [ERROR] [DATABASE] Ping Error: read tcp 10.135.21.63:49504->10.135.21.63:3389: wsarecv: An existing connection was forcibly closed by the remote host. 2019/06/26 13:56:23 [ERROR] Unable to map any values from the returned record: 2019/06/26 13:56:23 [RECORD] {"addressstreet":"Cedar Wood House Fulbourne Rd E17 4EE","generaltelephone":"020 3333 4444","managersamaccount":"JBasey","organisationdepartment":"Families and Homes","samaccountname":"RWilliams"} 2019/06/26 13:56:23 [MAPPINGS] null 2019/06/26 13:57:23 [ERROR] [DATABASE] Ping Error: read tcp 10.135.21.63:49546->10.135.21.63:3389: wsarecv: An existing connection was forcibly closed by the remote host. 2019/06/26 13:57:23 [ERROR] Unable to map any values from the returned record: 2019/06/26 13:57:23 [RECORD] {"addressstreet":"Walthamstow Assembly Hall Town Hall Complex, Forest Rd E17 4JF","generaltelephone":"020 7777 4444","managersamaccount":"NAlavi","organisationdepartment":"Neighbourhood and Commercial Services","samaccountname":"JBasey"} 2019/06/26 13:57:23 [MAPPINGS] null 2019/06/26 13:58:23 [ERROR] [DATABASE] Ping Error: read tcp [::1]:49592->[::1]:3389: wsarecv: An existing connection was forcibly closed by the remote host. 2019/06/26 13:58:23 [ERROR] Unable to map any values from the returned record: 2019/06/26 13:58:23 [RECORD] {"addressstreet":"Rowan House 1 Cecil Rd E11 3HF","generaltelephone":"020 8888 1111","managersamaccount":"RBlack","organisationdepartment":"Economic Growth","samaccountname":"STorres-Catmur"} 2019/06/26 13:58:23 [MAPPINGS] null 2019/06/26 13:58:23 Processing Complete 2019/06/26 13:58:23 ====Report Processing Statistics==== 2019/06/26 13:58:23 * Test update of Active Directory [209] 2019/06/26 13:58:23 * Total Records Found: 4 2019/06/26 13:58:23 * Rows Affected: 0 2019/06/26 13:58:23 * Successful Queries: 0 2019/06/26 13:58:23 * Failed Queries: 4 2019/06/26 13:58:23 Deleting Report Run Instance... 2019/06/26 13:58:44 [ERROR] Post https://mdh-p01-api.hornbill.com/walthamforest/xmlmc//reporting/?method=reportRunDelete: read tcp 10.135.21.63:49461->78.129.173.117:443: wsarecv: An established connection was aborted by the software in your host machine.

Hi I would like to create a report on Catalogue item config and wanted to know which tables would be involved in the report structure. The fields/columns are: Service, Email template, Resolution category level, Portal visibility, catalogue item, type of item, Progressive capture, BPM workflow, Visibility and Status

Thanks much appreciated

Hi Trevor, Thanks for the feedback. The gentleman (Stuart Tores-Catmur) who normally looks after the hornbill system is currently on leave. could you provide some steps to correct the username and password? regards

Thanks Victor, The data categories on our old support-works system had become a little inconsistent due council reshuffles and redundancies so management decided start off with a fresh slate. This means we didn't want to import old data that will be categorised in a better way with the hornbill launch. A few of our departments still need to reference historic information and retrieve attachment occasionally for legal reasons. I was thinking about a folder structure where all attachments are in a folder named with the call ref. Is this possible? regards

Hi, We are currently in the process of decommissioning our old support-works application but need staff to be able to access old calls and their attachments (i.e. maybe in a excel file or Access DB) Do you currently have a solution for companies that decommissioned support-works in the past? is there a way of storing attachments in a directory structure so staff can access? Is there any useful advice on the best way to go about? regards Richard

Thanks Trevor Much appreciated

Hi, I would like to create a report for active (non-Archived) user accounts and cannot find any obvious fields that I can reference to achieve this. Which table and field dictates if a record/user account (in h_sys_accounts) is archived or not? regards

Thanks, that link is much appreciated

Hi, We have a security incident at the moment with Hornbill whereby the Hornbill service is sending data in to Exchange across the Internet using POP3 (Port 110) but is not using an encrypted (TLS) connection. As a result, Usernames and Passwords are being sent in clear text across the Internet to our Exchange environment. We have identified the cause and we would like to switch on TLS for POP3 connections ASAP – however, can you please confirm with Hornbill that they are able to communicate using POP3 with TLS before we do so?

Thanks Lyonel. much appreciated

Hi, I'm trying to create a report that displays the account type which is "Basic" or "Full". Does anyone know which table and field i need to reference in order to display the user Type? Note: I have already tried including the field "h_sys_accounts-> h_user_type" in the report config but it comes up empty