enhancement SQL Organisation Import Tool - option to use Organisation ID as key

[Martyn Houghton]

@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

[Victor]

@Martyn Houghton - I'll look into adding this in the tool