Import Contacts from LDAP to SM using Connect-IT (565 Views)
Reply
Trusted Contributor
SanjeevDas
Posts: 383
Registered: ‎06-17-2013
Message 1 of 15 (565 Views)
Accepted Solution

Import Contacts from LDAP to SM using Connect-IT

Hi Experts,

 

I am trying to import all the contacts from LDAP to Service Manager using Connect IT. I am able to import the contacts successfully.

 

The issue is that, I am not able to populate the "HP Service Manager ID(operator. id)" of contact. g with the sAMAccountName from LDAP using CIT.

Can anyone please help me with the mapping for this particluar field. I am Having hard time synchonizing contacts with operators.

 

Thanks and Regards,

Sanjeev

Please use plain text.
Regular Advisor
Vikky
Posts: 182
Registered: ‎12-12-2010
Message 2 of 15 (534 Views)

Re: Import Contacts from LDAP to SM using Connect-IT

Hi,

 

Please provide screen shot of your scenario mapping with sestination feilds & contact.g form with operator.g.

 

Thanks

 

Please use plain text.
Trusted Contributor
SanjeevDas
Posts: 383
Registered: ‎06-17-2013
Message 3 of 15 (525 Views)

Re: Import Contacts from LDAP to SM using Connect-IT

Hi,

 

The issue got resolved.

 

Modified the Contact's External Access Definition by adding operator.id and giving a value to it.

Restarted the CIT. The added value in extaccess got displayed in CIT's destination source.

Mapped the value with the desired LDAP attribute.


Worked like Charm. Contacts and operators got synchronized.

 

Thanks,

Sanjeev

Please use plain text.
Frequent Advisor
JosieJosie02
Posts: 54
Registered: ‎01-05-2012
Message 4 of 15 (340 Views)

Re: Import Contacts from LDAP to SM using Connect-IT

Does anyone have a Connect-IT LDAP to SM scenario they could share?

Please use plain text.
Trusted Contributor
SanjeevDas
Posts: 383
Registered: ‎06-17-2013
Message 5 of 15 (329 Views)

Re: Import Contacts from LDAP to SM using Connect-IT

Hi Josie,

 

Wont be able to share the scenario because I dont have the access to the Connect IT Server right now. But can assist you in building the scenario.

 

Thanks and Regards,

Sanjeev

Please use plain text.
Frequent Advisor
JosieJosie02
Posts: 54
Registered: ‎01-05-2012
Message 6 of 15 (327 Views)

Re: Import Contacts from LDAP to SM using Connect-IT

I am really interested in seeing what AD/LDAP Elements are used and there  Filter clauses.  I would also like to see how people are filtering in their mapping scripts.

Please use plain text.
Frequent Advisor
JosieJosie02
Posts: 54
Registered: ‎01-05-2012
Message 7 of 15 (324 Views)

Re: Import Contacts from LDAP to SM using Connect-IT

Another example would be to see how people are parsing the AD\LDAP name from Distguished Name to contact.name

Please use plain text.
Trusted Contributor
SanjeevDas
Posts: 383
Registered: ‎06-17-2013
Message 8 of 15 (321 Views)

Re: Import Contacts from LDAP to SM using Connect-IT

Hi,

 

As far I remember I have created a scenario which imports the contact from Ad to SM and creates operator at the same time.

 

Scenario:

(To import users from LDAP)

Source Connector 1: LDAP Connector

Destination Connector 1: ServiceDesk Web Services.(Need to publish the table as web service using extaccess. By default Contact table is published as web service.)

Mapping 1:

Document Type: Create Contacts

contact.name(Contact)-->[samAccountName](LDAP)

email(Contact)--->[samAccountName]+"@yourdomain.com"(LDAP)

full.name(Contact)--->[cn.person](LDAP)

operator.id(Contact)--->[samAccountName](LDAP) (Note: You wont find opertor.id in the destination element list untill and unless you add it in contact web services from extaccess)

Key:

contact.name(Contact)--->[samAccountName](LDAP)

 

Document Type: Update Contacts

contact.name(Contact)-->[samAccountName](LDAP)

email(Contact)--->[samAccountName]+"@yourdomain.com"(LDAP)

full.name(Contact)--->[cn.person](LDAP)

operator.id(Contact)--->[samAccountName](LDAP)

Key:

contact.name(Contact)--->[samAccountName](LDAP)

 

(Create operators)

Source Connector: Destination Connector 1

Destination Connector 2: ServiceDesk Web Services(Publish the operator table as web service from extaccess also define the fields that you want to use while defining the mapping)

Mapping 2:

Document Type: Create Operators


operator.id(Contact)--->name(Operator)

contact.name(Contact)--->contact.name(Operator)

full.name(Contact)--->full.name(Operator)

email(Contact)--->email(Operator)

key:

operator.is(Contact)--->name(Operator)

 

Document Type: Update Operators


operator.id(Contact)--->name(Operator)

contact.name(Contact)--->contact.name(Operator)

full.name(Contact)--->full.name(Operator)

email(Contact)--->email(Operator)

key:

operator.is(Contact)--->name(Operator)

 

 

Now, run the scenario.

 

Hope that helps,

Sanjeev

Please use plain text.
Frequent Advisor
JosieJosie02
Posts: 54
Registered: ‎01-05-2012
Message 9 of 15 (310 Views)

Re: Import Contacts from LDAP to SM using Connect-IT

Thanks Sanjeev!

 

Do I have to create a separate ServiceDesk Web Services for operator updates or can I use the create one some how?

Please use plain text.
Trusted Contributor
SanjeevDas
Posts: 383
Registered: ‎06-17-2013
Message 10 of 15 (301 Views)

Re: Import Contacts from LDAP to SM using Connect-IT

HI,

 

Yes you have to create an operator webservice using extaccess. Also define the required fields.

 

Thanks,

Sanjeev

 

Please use plain text.
Frequent Advisor
JosieJosie02
Posts: 54
Registered: ‎01-05-2012
Message 11 of 15 (282 Views)

Re: Import Contacts from LDAP to SM using Connect-IT

Hi Sanjeev,

 

I finally was able to get an Operator Add scenario running.  However, when I either produce the document or run it as a service no operator accounts are created. 

 

I have attached my scenario report.

 

Any idea's?

 

Thanks,

 

Josie

Please use plain text.
Frequent Advisor
JosieJosie02
Posts: 54
Registered: ‎01-05-2012
Message 12 of 15 (281 Views)

Re: Import Contacts from LDAP to SM using Connect-IT

Please use plain text.
Frequent Advisor
JosieJosie02
Posts: 54
Registered: ‎01-05-2012
Message 13 of 15 (280 Views)

Re: Import Contacts from LDAP to SM using Connect-IT

sorry next post has scenario
Please use plain text.
Trusted Contributor
SanjeevDas
Posts: 383
Registered: ‎06-17-2013
Message 14 of 15 (273 Views)

Re: Import Contacts from LDAP to SM using Connect-IT

Hi,

 

Can you please post the scenario. Or the mapping that you have defined to import thr operators.

 

However, I couldnot pull in the password of the users from LDAP to HPSM using Connect IT. If you want the operators to get authenticated from LDAP, then you need to configure the scldapconfig file.

 

Thanks,

Sanjeev

Please use plain text.
Frequent Advisor
JosieJosie02
Posts: 54
Registered: ‎01-05-2012
Message 15 of 15 (252 Views)

Re: Import Contacts from LDAP to SM using Connect-IT

Hi Sanjeev,

 

I got my scenarios working.  Thank you for your help.

 

I have a question on creating/filling th mangaer field.

 

My contact name is concatination of contact.name + (operator.id).

 

This statement will get me my contact.name.  RetVal=UCase((RightPart(LeftPart((Replace([manager],"\","")),",OU=",0,"CN=",0)))

 

But how do I get the samaccount name for the name found?

 

Sincerely,

 

Josie

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation