Jump to content

Joanne

Hornbill Users
  • Content Count

    35
  • Joined

  • Last visited

Community Reputation

2 Neutral

About Joanne

  • Rank
    Advanced Member

Profile Information

  • Location
    Newport

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. That worked, thanks for the quick turnaround
  2. Hello, I'm trying to use the hornbill export tool but getting some issues. Which i believe is to do with the spaces in my column names. If my config file looks like ReportID":4, "ReportName":"JBURR Test3", "DeleteReportInstance": true, "DeleteReportLocalFile": true, "Table":{ "TableName":"Requests2", "PrimaryKey":"Request ID", "Mapping":{ "Request ID":"Request ID", "Date Logged":"Date Logged", "Summary":"Summary" } } I get the following error [DATABASE] Connection Successful 2019/03/18 08:20:12 [DATABASE] Query:INSERT INTO Requests2 (Request ID, Date Logged, Summary) VALUES (:Request ID, :Date Logged, :Summary) 2019/03/18 08:20:12 [DATABASE] Binding: 2019/03/18 08:20:12 [DATABASE] :Date Logged = 2019-01-11 20:19:31 2019/03/18 08:20:12 [DATABASE] :Summary = Service is unavailable 2019/03/18 08:20:12 [DATABASE] :Request ID = IN00000002 2019/03/18 08:20:12 [ERROR] [DATABASE] NamedExec Error: could not find name Request in map[string]interface {}{"Request ID":"IN00000002", "Date Logged":"2019-01-11 20:19:31", "Summary":"Service is unavailable"} but if i add [] to accommodate for the spaces "Reports":[ { "ReportID":4, "ReportName":"JBURR Test3", "DeleteReportInstance": true, "DeleteReportLocalFile": true, "Table":{ "TableName":"Requests2", "PrimaryKey":"[Request ID]", "Mapping":{ "[Request ID]":"Request ID", "[Date Logged]":"Date Logged", "[Summary]":"Summary" } } } i get [DATABASE] Connection Successful 2019/03/18 08:21:56 [ERROR] Unable to map any values from the returned record: 2019/03/18 08:21:56 [RECORD] {"Actions Control":"","Activity Stream ID":"urn:buzz:activityStream:e03ec7ac-614f-45a7-8f0e-0798c1a48ad7","Archived":"Yes","BPM Activity Update ID":"","BPM ID":"BPM20190111000001","BPM Stage Expired":"No","BPM UI state":"","BPM authorised":"0","Call Back Date":"","Cancellation Reason":"Created In Error","Catalog":"Apply For A Design","Catalog ID":"29","Category ID":"","Category Name":"","Closed By Team":"","Closed By Team ID":"","Closed By User ID":"","Closed By Username":"","Closure Category ID":"","Closure Category Name":"","Company":"","Company ID":"","Created by":"admin","Custom 21":"","Custom 22":"","Custom 23":"","Custom 24":"","Custom 25":"","Custom 26":"","Custom 27":"","Custom 28":"","Custom 29":"","Custom 30":"","Custom A":"","Custom B":"","Custom C":"","Custom D":"","Custom E":"","Custom F":"","Custom G":"","Custom H":"","Custom I":"","Custom J":"","Custom K":"","Custom L":"","Custom M":"","Custom N":"","Custom O":"","Custom P":"","Custom Q":"","Custom R":"","Custom S":"","Custom T":"","Customer ID":"admin","Customer Name":"System Administrator","Customer Organization Container ID":"","Customer type":"0","Date Closed":"2019-01-13 20:15:54","Date Logged":"2019-01-11 20:19:31","Date Modified":"2019-01-13 20:15:55","Date Placed On Hold":"","Date Resolved":"","Description":"","External Reference Number":"","Feedback Status":"awaiting","Feedback Status ID":"0","First Time Fix":"","Freetext Search Index":"lid_35c613c9-f899-4ccc-bcde-48c6598496a4","Historic Request":"","Image":"","Impact":"","Impact Id":"","Is Analyst Unread":"1","Is Customer Unread":"","Last Date an email was sent from the request details":"","Last Update Activity ID":"urn:buzz:activity:acc43ab9-0dd1-46b6-83b8-b0e6de847257","Locked":"Unlocked","On Hold Until":"","Priority ID":"5","Priority Name":"Priority 2","Profile Code":"","Rating":"","Related Activity ID":"","Reopen Date":"","Reopened By Team":"","Reopened By Team ID":"","Reopened By User ID":"","Reopened By Username":"","Reopened Count":"0","Request ID":"IN00000002","Request Language":"en-GB","Request Owner ID":"","Request Owner Name":"","Request Owner Type":"","Request Prefix":"IN","Request Resolution Timer ID":"","Request Resolve By":"","Request Resolve Seconds":"","Request Resolve Time":"","Request Respond By":"","Request Response Seconds":"","Request Response Time":"","Request Response Timer ID":"","Request Total Onhold Time":"","Request Type":"Incident","Resolution":"","Resolved By Team":"","Resolved By Team ID":"","Resolved By User ID":"","Resolved By Username":"","Service ID":"23","Service Level Agreement ID":"","Service Level Agreement Name":"","Service Level Changed":"","Service Level Date Changed":"","Service Level ID":"","Service Level Name":"","Service Name":"Apply for a Design","Site":"Concept House","Site ID":"1","Social Object Ref":"urn:sys:entity:com.hornbill.servicemanager:Requests:IN00000002","Social Object URN":"urn:sys:user:admin","Source ID":"admin","Source Type":"Self Service","Status":"status.cancelled","Sub-status Id":"","Sub-status Text":"","Summary":"Service is unavailable","Team ID":"IPO/IT/OPS/APPSL2/","Team Name":"L2 Applications","Urgency":"","Within Resolve Time":"","Within Response Time":"","h_itsm_requests Organisation Id":"0"} 2019/03/18 08:21:56 [MAPPINGS] {"[Date Logged]":"Date Logged","[Request ID]":"Request ID","[Summary]":"Summary"} any help would be appreciated Cheers Jo
  3. This worked, many thanks. Is there anything in the roadmap to allow me to use a dropdown / or search in the prog capture to search for a document based on tags etc. At the moment i intend on using a simple list and put the docid in as a value so i can auto link it, but obviously this will at some point become unmanageable. Many Thanks Jo
  4. Hello, I will like to auto assign a call to the team of who even requested it but i get an error, not sure if i'm putting it in correctly. I would be grateful for some help
  5. I would be grateful for some help with this Many Thanks Jo
  6. Hello, I have only used this and the azure devops one so far. Many Thanks Jo
  7. Hello, I'm trying to export the h_cmbd_assets so i can import into an SQL database so that going forward my discovery tools can auto update the SQL database and then I use the import tool exe tool to update the hornbill CMDB I know there is a 10k limit and i have roughly 16k in there so thought i would split the export, but there seems to be an issue with the primary key. Even ordering by the PK does seem to work, have attached ss and you can see that asset 999 appears in the middle of the higher numbers. . would be very grateful for a response.
  8. is anyone able to help with this Many Thanks Jo
  9. Hello, Do you have any examples of this, i keep getting this error - iBridge Method: /Hornbill/Docmanager/Link Document.m Error: SyntaxError: Unexpected token < in JSON at position 1
  10. Hi, I'm trying to use the iBridge link document but not sure what i should be putting in the following params:- Application Entity Entity id Can anyone help with this Many Thanks Jo
  11. Sorry, I'm struggling to understand this, do you have 30 min free tomorrow morning to discuss, while i don't yet have a support contact i do have hours left in my SOW that we can dip into Many Thanks Jo
  12. Hi Victor, I'm very confused, there has been no change to the processes and as of yesterday my users can raise call and the BPM would automatically get users from a group and create an activities, so i'm not trying to do anything different form yesterday. When all of my IT staff create a change request the BPM is failing here, and i don't understand what has changed (it maybe something that we have changed here), but more important i do not know how to fix this issue Is it possible to have a telephone conversation Many Thanks Jo
  13. the next step in my BPM is to get a list of people and assigned a task to them to authorise cheers jo
  14. Yes, i have restarted the processes. Can you you let me know what rights they would need? is is a particular role Many Thanks Jo
×
×
  • Create New...