Jump to content

Search the Community

Showing results for tags 'sql request importer'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Hornbill Platform and Applications
    • OpenForWork
    • Announcements
    • Blog Article Discussions
    • General Non-Product Discussions
    • Application Beta Program
    • Collaboration
    • Employee Portal
    • Service Manager
    • IT Operations Management
    • Project Manager
    • Supplier Manager
    • Customer Manager
    • Document Manager
    • Timesheet Manager
    • Live Chat
    • Board Manager
    • Mobile Apps
    • System Administration
    • Integration Connectors, API & Webhooks
    • Performance Analytics
    • Hornbill Switch On & Implementation Questions
    • GRC Manager
  • 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 3 results

  1. Can we requests an enhancement to be able to import multiple connections on a request as part of the SQL Request Importer. We would envisage this as an additional sub query process much like the historic updates/comments. We would want to be able to pass both Co Worker id's and for Contacts, the Contact ID or Contact email address. Cheers Martyn
  2. @Steve G @Victor Can I clarify which value related to the Logging and Closure category is to be entered into the 'CategoryMapping' and 'ResolutionCategoryMapping' sections. In the example json files it mentions ID for the former and Code latter, but neither have an actual example value. }, "CategoryMapping": { "External Category": "Service Manager Category ID" }, "ResolutionCategoryMapping": { "External Resolution Profile Code": "Service Manager Resolution Profile Code" }, At the moment I have tried the code as copied from the admin screen with the - delimiter and also the key value from the same screen but to no avail. Cheers Martyn
  3. I am currently undertaking test migrations using the SQL Request Importer (v1.3.1), and I am trying to carry over a much information into the Historic Updates that the tool allows. Would it be possible to get some clarification on the below:- h_updatedby and h_updategroup, are these just literal values or are there lookups applied to them such as the User lookup and Team Mapping? h_actiontype and h_actionsource I am presuming these are textual literal values which we can pass in any text from the source system? h_timespent is passed in as an integer in the unit of minutes? Cheers Martyn
  • Create New...