Service Desk Practitioners Forum
cancel
Showing results for 
Search instead for 
Did you mean: 

Blocked & Unique Person Records

Highlighted
reAnimate
Occasional Contributor

Blocked & Unique Person Records

Service Desk 4.5 SP 16 - Importing person records from an Oracle database problem.

Two fields of interest:

HOTID - a unique identifier for the Person, e.g. UI000123

BLOCKED - set to YES or NO.

The HOTID is the unique identifier, and has been mapped to the SEARCHCODE field of the person item

The BLOCKED field has been mapped to the Blocked field of the person item.

The Oracle DB has 6 records in it, with one of the records BLOCKED set to YES

The first time I load all the records, it loads in 6 person records, one of which is set to Blocked, as you would expect.

If I run the import again, it adds another record for the user who is blocked - it seems that the unique identifer is not checked if the user is Blocked, very odd.

Any ideas?

Thanks,


Simon.
5 REPLIES

Re: Blocked & Unique Person Records

in your import mapping, did you use the blocked also a unique key binding? This would explain why you have 2 records instead of one...

Lawrence
we have been where you wanna go..
reAnimate
Occasional Contributor

Re: Blocked & Unique Person Records

No, I didn't use the blocked as a unique identifier.

Re: Blocked & Unique Person Records

can you send a printscreen of the import mapping that you have done.
You should only have one for this purpose and personally i suggest to use the e-mail address since this is always unique.

Lawrence
we have been where you wanna go..
Anda Apine
Member

Re: Blocked & Unique Person Records

We have SD 4.5 SP13 and in our case if person record is blocked it is not updated at all. It seems import script can not update blocked items.
Which version of Service Desk you have?
Look on import log file is there any errors during import?

Do you have information about data when person has been blocked in your Oracle database? If you have, then you restrict sql query, so that it does not loads blocked records twice.
reAnimate
Occasional Contributor

Re: Blocked & Unique Person Records

Ho Ho!

http://openview.hp.com/ecare/getsupportdoc?docid=ITSM008306

SP18 is no good to anyone as you won't be able to upgrade to sp5.1 from it.

Grrrr.
//Add this to "OnDomLoad" event