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

Regular Advisor
Vikky
Posts: 184
Registered: ‎12-12-2010
Message 2 of 15 (686 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: 385
Registered: ‎06-17-2013
Message 3 of 15 (677 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 (492 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: 385
Registered: ‎06-17-2013
Message 5 of 15 (481 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 (479 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 (476 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: 385
Registered: ‎06-17-2013
Message 8 of 15 (473 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 (462 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: 385
Registered: ‎06-17-2013
Message 10 of 15 (453 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 (434 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 (433 Views)

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

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

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

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