Hi, I am trying to use loadobject to import incidents captured by the call centre, we have over 5000 clients with lots of duplicate names. I have managed to import SC’s but don’t know what to use as a unique key for person and how to access this on the import mapping.
If any of you have done this, would you mind letting me know what you have used and how. In the case of duplicate person name what key should be used and how you map this?
Hi, For example two people call to call center having the same names? How call center people know who is who? Of course you can differentiate by organization, but what do they do if two people from the same organization have the same names?
I can get the call centre to include the personâ s OID in the incident they have logged. I am not sure in data exchange how and where to define reference to personâ s OID when importing Service calls, I can not see where you map this?
Hi, Ok, i expect you imported OID value in field person.sourceid
Then open service call import mapping and look for field caller. Open it.
Enter value for "reference to" - click button "quick find" and select source id value (look at column search code). Another way to do it - just type text "Source ID" in that field. Now enter value for "external attribute" and thats it.
Many thanks for getting back to me; the OID I was refereeing to is the person OID. We initially supplied the call centre with the list of all people we support this database included the OID from the person record as a unique identifier. The call centre, whilst they are recording the incident they will if identify the person from a list of People on the supplied database (as mentioned before there could be more than one person with the same name, the agent at the call centre during the course of conversation through department, organisation, location and position will identify the caller).
This incident is then sent to us by call centre which will contain the unique persons OID. I am trying to import the incident into the openview.
However, I also tried what you assumed, I copied the OID value in the SOURCE_ID of the person record and tried importing the incidentrecord and got the attached error.
I really appreciate your comment and help. I hope I am making sense, if not please let me know.
Hi, I expect there are two problems: 1. You checked that caller is primary key, but service call source id field should be primary key. That way if two sc come from the same person import will think that it is the same sc (because primary identification key is the same) 2. Error says that it cant find person, which has value 269570864481510393 field persons.sourceid (or maybe it finds two persons and cant decide)
Error says that you dont provide value for primary key (or maybe thera are some errors).
One way to solve this problem is to "divide and conquere" - give values for all mandatory fields in sc template, which you use for import and it should start to work, just some wont import. Then one by one you could find all errors.
And could you show how you invoke load object - maybe there are some problems in providing values for import?
I must be missing something guys; I am going to start again and hope to cover all my steps.
Objective: To import new incidents or update the existing incidents received by the centre (the Call centre do not use HPOpenview).
Method of Migration: ovobsloadobject
Call centre are supplied with the database which contains the list of the clients (persons), the above database contains duplicate names (as well a search code).
So far: I have managed to import incidents when the caller name is unique without any problem, for this import I used the caller search code.
Problem: When I tried importing incidents where there are more than one person, it fails I assume this is due to duplicate search code.
To overcome the duplication, I was trying to use the Person OID key but could not see this on the import mapping. Then I took Rytis idea and stored a unique value on the person Source_id, or Markâ s suggestion which is Unique User ID field I have added to the person record.
I attached the details together with the error message I am getting, also included the person record for your information.
I hope this helps. Once more many thanks for you input.