Office - InfoPath and populating email, name, phone from Active directory

Asked By Jim

05-Dec-07 07:04 PM

I have some nice Inopath forms working, but I would love to be able to have
an easy lookup of on my forms for people such as requestors (in a purchase
requisition requestor).  When doing Sharepoint administration I can easily
look up some who is in active directory and give them permissions by putting
in a partial name or email userid and it automatically populates the rest.
THere must be some way to invoke that same type of functionality into an
InfoPath form.
Thanks for anyone's help or pointers for where I can go.
It would also be great to be able to prepopulate the requestor field with
the person who opened the form.
Jim

05-Dec-07 11:16 PM

Hi Jim.

I do this quite frequently and identifying the form user is very nice as
well as being able to access email or group membership.

Check out the Database Accelerator package of webservices at
http://www.qdabra.com it includes an Active Directory Webservice as well as
you can get it by itself.

--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

InfoPathDev.Com
The Largest InfoPath Forum in the World
http://www.infopathdev.com

06-Dec-07 02:23 AM

Have you already seen this article?
http://msdn2.microsoft.com/en-us/library/bb952744.aspx
---
S.Y.M. Wong-A-Ton

06-Dec-07 10:30 AM

S.Y.M. Wong-A-Ton
I will look at that article, thanks.  I am on InfoPath 2003.  I wonder if
the article will staill apply to InfoPath 2003.
Jim

07-Dec-07 12:57 AM

Jim,

The code in the article will be different for InfoPath 2003. The
System.DirectoryServices namespace has been around for a while, so if you're
using managed code (VB.NET or C#), you will be able to use it in older
versions of .NET. Retrieving the user's name is also possible using .NET
code. If you're using script (VBScript or JScript) there is a scripting
language called ADSI that you could use to get data from Active Directory.
All in all, retrieving info from AD is not easy, so if you go down that road,
things might get bumpy...

Tip: Do a search in the newsgroup on Active Directory; many people have
tried to do what you are trying to do now.
---
S.Y.M. Wong-A-Ton

27-Dec-07 04:19 PM

Hi, I used the code directly from the article that you referenced. I can get
the first part to work just fine but the ListAllProperties code keeps
erroring out. I have started from scratch three times to make sure that I was
copying the code correctly. I also had someone else try it and the same thing
happened.

It errors out in the for each userProperty loop at:
xnPropertyName = xnPropertiesTable.SelectSingleNode( _

The error message is:
Object reference not set to an instance of an object.

Any help would be greatly appreciated.
Thanks,
Connie
--
HighlanderMom