Jump to content

Search the Community

Showing results for tags 'import tool'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • 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
    • 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

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Organisation


Location


Interests


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype

Found 7 results

  1. @Steve G @Victor Could I request a enhancement to the Contact Import Tool, to have the option to have the option to use the h_organisation_id as well as the current company parameter, as the key to match the contact's organisation. The reason for this is that we are trying to do data matching between systems and updating Hornbill with a contact information from other system such as Sales Force. Though company name is unique, it can also be updated/changed, thereby breaking the updating. We would prefer once we have matched the organisation records to use the h_organization_id which does not change. Cheers Martyn
  2. Linked to the post below, we have just imported in a number of organisation including populating their region (h_region) with the ISO Code for the region. The code matches the code added into the External Organisation Region simple list, but does not show the Display Text (or the code). If we select the region from the simple list on the imported organisation it then shows properly, but the region(h_region) field value is identical, so not sure why it does not show immediately after the import. Any ideas? Cheers Martyn
  3. @Steve G Could I request a enhancement to the Organisation Import Tool, to have the option to us the h_organisation_id as the key when using the 'Update' action, rather the the h_organisation_name. The reason for this is that we are trying to do data matching between systems and updating custom fields in Hornbill with a cross references to other system such as Sales Force. Though h_organisaiton_name is unique, it can also be updated/changed, thereby breaking the updating. We would prefer once we have matched the organisation records to use the id which does not change. Cheers Martyn
  4. @Steve G I am once again importing a new set of organisation and users into Hornbill as we integrate another part of the business. We have started using the region field and to a lesser degree the timezone field in the organisation table. However when I attempt to update the SQL Organisation Import Tool, I am not able to get it to accept region or h_region as a valid target field. Is this accessible in the tool or is this an enhancement request to get the fairly recent field added to the tool? Cheers Martyn
  5. The Asset Import utility v1.9.0 was executed to test the removal of values for a specific field using the '__clear__' as clearcolumn in the SQL statement within the config file but it does seem that the utility inserts a new duplicate record for each asset record instead of updating the existing asset by clearing the value in the existing field.
  6. @Victor In relation to the Organisation Import Tool (1.0.0), there are some fields missing from the example field mapping in the json configuration file. In particular the 'h_notes' field is the one I am after at the moment, but 'h_timezone' and 'h_region' appear also to be missing, but language is present. If I add the missing ones in to the field mapping, will they work or does this require a change to the tool itself? Cheers Martyn
  7. We are importing/updating assets using the asset import tool and SCCM. We use the managedBy attribute in AD to store the asset's assigned owner, and can easily import this into Service Manager. Before I do, my question is; will Service Manager recognise that the CN stored in that field is a user, or will it blindly try and shove the whole CN in there, probably returning a "too long" type error? The Wiki states "h_owned_by":"[UserName]" - when a valid Hornbill User ID (for a Full or Basic User) is passed to this field, the user is verified on your Hornbill instance, and the tool will complete the h_owned_by and h_owned_by_name columns appropriately. however the User ID is the sAMAccountName, not the full CN.
×
×
  • Create New...