Jump to content

Search the Community

Showing results for tags 'request import'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Hornbill Platform and Applications
    • Announcements
    • Blog Article Discussions
    • General Non-Product Discussions
    • Application Beta Program
    • Collaboration
    • Employee Portal
    • Service Manager
    • Project Manager
    • Supplier Manager
    • Customer Manager
    • Document Manager
    • Configuration Manager
    • Timesheet Manager
    • Live Chat
    • Board Manager
    • Mobile Apps
    • System Administration
    • Integration Connectors, API & Webhooks
    • Performance Analytics
    • Hornbill Switch On & Implementation Questions
  • About the Forum
    • Announcements
    • Suggestions and Feedback
    • Problems and Questions
  • Gamers Club's Games
  • Gamers Club's LFT

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start








Website URL





Found 5 results

  1. When importing requests into Service Manager using the Request Import Tool, the requests are being matched to the correct organisation, with h_container_id and h_company_name being populated, but the h_org_id field is not populated with the link organisation id. The the application uses the container id for the link, we also use the organisation id as a field in some of our widgets to show top 5 logging organisations etc. Cheers Martyn
  2. Can I raise an enhancement to provide a Request Attachment Importer tool. Like the current SQL Request Import tool, provide a mechanism where the attachments information containing the case reference, visibility and file path can be queried form a database and the tool loads the attachments against the referenced requests. It it could also have the ability to match the case reference to a custom field/External Reference field, so that the source only has to have the legacy unique ID in it. Cheers Martyn
  3. We had an occurrence during a import load at the BPM Spawning stage where it overwhelmed our instance, causing http 502 response and the import process hanging. Would it be possible for the import tool to pause when it gets this type of error at this stage and await user input before retrying and continuing, to avoid having only partial BPM's spawned? 2019/03/22 14:07:18 [DEBUG] Spawning BPM [idox-open-objects-sr-slm] for [IDXSR00088697] 2019/03/22 14:07:18 [DEBUG] BPM Spawned: BPM20190322000769 2019/03/22 14:07:18 [ERROR] API Call Failed: Associate BPM to Request: Invalid HTTP Response: 502 2019/03/22 14:07:18 2019/03/22 14:07:18 [DEBUG] Spawning BPM [idox-open-objects-sr-slm] for [IDXSR00088698] 2019/03/22 14:07:18 [DEBUG] BPM Spawned: BPM20190322000770 2019/03/22 14:07:18 [ERROR] API Call Failed: Associate BPM to Request: Invalid HTTP Response: 502 Cheers Martyn
  4. Can the current Hornbill Request Import V1.2.0 be updated to include the following additional capabilities. Support the import and matching of Sub Status, only current supports parent status. Support the import and matching of Service Level Agreement and Service Level's. Extend current supported request types, Incident & Service Request, to include all other types, i.e. Change, Problem, Known Error and Release. Also as per the SQL Contact Import also support MySQL v8 connection with the new authentication method. Cheers Martyn
  5. As first indicated in my earlier post (link below), we are having issues with importing anymore than one request using the Hornbill Request Import v1.2.0. We have been testing with single rows, but now we have got to the stage were we want to test with increasing volume, the utility will only ever retrieve the first row from the RequestQuery table, irrespective of the where clause or even if you do not enter a where clause. The symptoms are as if the SQL is being run with the Limit 1 row setting. The secondary RequestHistoricUpdateQuery is retrieve successfully all the comment rows for 1 selected request row fine. We have also used the exact same database source for the DB2Hcontactimport v1.2.2 to insert over 3,000 contact records. Originally we where using a view as the source and I have created a physical table form the view, but the issue occurs for that as well. Environment is MySQL 5.7.24, as I downgraded from MySQL v8 which the tool does not yet support. Any ideas? Cheers Martyn
  • Create New...