Import Contacts from LDAP to SM using Connect-IT (851 Views)
Reply
Trusted Contributor
SanjeevDas
Posts: 386
Registered: ‎06-17-2013
Message 1 of 15 (851 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

Super Advisor
Vikky
Posts: 192
Registered: ‎12-12-2010
Message 2 of 15 (820 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

 

Trusted Contributor
SanjeevDas
Posts: 386
Registered: ‎06-17-2013
Message 3 of 15 (811 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

Frequent Advisor
JosieJosie02
Posts: 62
Registered: ‎01-05-2012
Message 4 of 15 (626 Views)

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

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

Trusted Contributor
SanjeevDas
Posts: 386
Registered: ‎06-17-2013
Message 5 of 15 (615 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

Frequent Advisor
JosieJosie02
Posts: 62
Registered: ‎01-05-2012
Message 6 of 15 (613 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.

Frequent Advisor
JosieJosie02
Posts: 62
Registered: ‎01-05-2012
Message 7 of 15 (610 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

Trusted Contributor
SanjeevDas
Posts: 386
Registered: ‎06-17-2013
Message 8 of 15 (607 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

Frequent Advisor
JosieJosie02
Posts: 62
Registered: ‎01-05-2012
Message 9 of 15 (596 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?

Trusted Contributor
SanjeevDas
Posts: 386
Registered: ‎06-17-2013
Message 10 of 15 (587 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

 

Frequent Advisor
JosieJosie02
Posts: 62
Registered: ‎01-05-2012
Message 11 of 15 (568 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

Frequent Advisor
JosieJosie02
Posts: 62
Registered: ‎01-05-2012
Message 12 of 15 (567 Views)

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

Frequent Advisor
JosieJosie02
Posts: 62
Registered: ‎01-05-2012
Message 13 of 15 (566 Views)

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

sorry next post has scenario
Trusted Contributor
SanjeevDas
Posts: 386
Registered: ‎06-17-2013
Message 14 of 15 (559 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

Frequent Advisor
JosieJosie02
Posts: 62
Registered: ‎01-05-2012
Message 15 of 15 (538 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

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.