Active Directory
(1)
SharePoint
(1)
InfoPath
(1)
GetUserProfileByName
(1)
VPN
(1)
TonThe
(1)
ClayI
(1)
Accelerator
(1)

Accessing AD data from user name using codeless solution

Asked By Ian
14-Nov-07 03:50 PM
Hi

I have a form that refers to users (other than the current user) and I want
to validate them and access their Active Directory data. I have played with
the method outline in the first part of wkriebel's blog:
http://weblogs.asp.net/wkriebel/archive/2005/01/24/359669.aspx
This involves setting the query value field in the GetUserProfileByName
webservice (supplied with MOSS) to the user Name and interrogating the
results.

From analysis I know the query field is being updated but for some reason
the query doesn't seem to be firing as the results are not updated.

Can anyone help with this - I have trolled the Internet without success

Note that I am using MOSS and Infopath 2003 SP2 (which seems to be supplied
with MOSS). Any solution has to be codeless


Thanks

Ian B

Hey Ian.

Asked By ClayFo
14-Nov-07 03:55 PM
Hey Ian.

Have you looked at the AD webservice included with the Database Accelerator
at http://www.qdabra.com?
It is codeless and can do a lookup and return all of the data on a
particular user, return the current user's domain account(not just the local
account which can be different in a VPN or RAS scenario), and verify a user's
group membership.

I use that so I am not real familiar with the MOSS version.
--
Thanks

Clay Fox

Qdabra Software
http://www.qdabra.com

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

Thanks ClayI just need something to tidy up a process - theres no will to buy

Asked By Ian
14-Nov-07 04:06 PM
Thanks Clay

I just need something to tidy up a process - theres no will to buy a
solution.  There are some web services around on the net that provide some of
the funtionality but I am trying to work under the IT radar. From what I have
seen I should be able to do this relatively simply using inbuilt Infopath
functionality. I'm just missing that vital piece of the jigsaw

Ian

I'm unfamiliar with the solution, but have you added a rule somewhere (such as

Asked By SYMWongATo
16-Nov-07 01:32 AM
I'm unfamiliar with the solution, but have you added a rule somewhere (such
as on a button) with an Action to "Query using a data connection" and
selected the "GetUserProfileByName" data connection? You need to query the
data connection after you've set the value for the username, otherwise no
data will be returned.
---
S.Y.M. Wong-A-Ton
Thanks Wong-A-TonThe information you provided worked and the codeless updating
Asked By Ian
18-Nov-07 10:31 PM
Thanks Wong-A-Ton

The information you provided worked and the codeless updating of user
details is functioning from the user account name which is a great step
forward.

Is there a web sevice (or some other way) that will support a query on Full
Name and either return account name or other profile details?

Thanks

Ian
I don't know of any, but I'm sure you could write a custom web service to
Asked By SYMWongATo
19-Nov-07 07:44 PM
I don't know of any, but I'm sure you could write a custom web service to
retrieve that kind of information. It might be worth posting your question in
one of the SharePoint groups?
---
S.Y.M. Wong-A-Ton
Post Question To EggHeadCafe
Office InfoPath 2003 Form with Active Directory Permissions Hi, Please help an InfoPath Newbie with form permissions. It is possible to manage an InfoPath 2003 Form based on Active Directory groups? In other words, a user's AD account would be a member of group I know I could use SharePoint to host this form and manage access to it. However, management does not want it on SharePoint because they do not want users requesting access to this form when they are denied but then presented with the SharePoint request access form. So, I think the form should be
Office InfoPath 2003 connect to Active Diretory Hello, How can i connect from an InfoPath 2003 document to active directory. For example: I want pick the name out in a QADWS I hope it will be helpful - - Kalyan G Reddy - INFOPATH MVP 2007 http: / / www.ggktech.com Hello Also look into www.sharepointblogs.com / mdlotter / archive / 2007 / 07 / 08 / simple-corporate-directory-with-infopath-2007-sharepoint-2007-and-web-service.aspx - - Kalyan G Reddy - INFOPATH MVP 2007 http: / / www.ggktech.com keywords: InfoPath, 2003, connect
Office InfoPath and populating email, name, phone from Active directory I have some nice Inopath forms working, but I would 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 way to invoke that same type of functionality into an InfoPath form. Thanks for anyone's help or pointers for where of webservices at http: / / www.qdabra.com it includes an Active Directory Webservice as well as you can get it by itself Qdabra Software http: / / www.qdabra.com InfoPathDev.Com The Largest InfoPath Forum in the World http: / / www.infopathdev.com Have you
Office How to setup web service to access Active Directory I would like to setup a web service so Infopath 2007 can access AD information, I tried to use the task? Thanks - - kb Hi, Follow below steps: 1. Click on Active Directory web service link 2. Click on Run in the security 5. Click on Next to Confirm installation a. Enter the Active Directory Path as per the example in the install window and with install as per the installer window. 7. Open the SharePoint central administration in the administrative tools. 8. Select Configure virtual GGKtech.com keywords: How, to, setup, web, service, to, access, Active, Directory description: I would like to setup a web service so
Office Code Backed Forms in Infopath Hi, I have created an infopath form which contains fields for Active Directory lookups. Several fields query the AD and display user related form with a certificate and published the form successfully to Sharepoint (MOSS2007) so that it published in a browser. However, when I try to open the form in a browser from Sharepoint, before the form is displayed, it errors and says an aspx&DefaultItemOpen = 1, Form ID: urn:schemas-microsoft-com:office:infopath:Holiday-Request-Form:-myXSD-2008-03-07T12-43-21, Type fields being populated. I've been told in another Forum (Sharepoint Portal Server) that this is a problem with the code I have used. However, when I preview the form inside Infopath (2007) the form loads and displays correctly and all fields a browser form. I have a web service which queries Active Directory information and is browser compatible. Email me if you
Office Code Does Not Run When Published to SharePoint I created an Infopath form template using InfoPath 2007 and have assigned it Full Trust and signed with certificate. I have a loading event handler that reads from Active Directory and fills out fields within the form based on the open the form from my desktop, but after publishing to SharePoint, the form opens fine, but the fields are not filled out. I see no errors in the Sharepoint logs and no errors are presented to the users. What and whether there are any errors? I am new to InfoPath. Hi, You need to debug the Onload code in Infopath form. Just open one form from sharepoint. And add the debug to code (Make sure add the
Office Populate dropdown with Active Directory username Hi I want to populate a dropdown with the interrogate Has anyone done this? Thanks IanB If you have SharePoint 2007, there is a web service that you can use www.qdabra.com / proddetail.asp?prod = QADWS - - Clay Fox / Microsoft InfoPath MVP www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To, Experts, Forum keywords: Populate, dropdown, with, Active, Directory, username description: Hi I want to populate a dropdown with
Office Form creation for Active Directory Account creation Hi, I am looking for a template or this please. regards sanjeev I would create the form in InfoPath and then use out ofthe box workflow or SharePoint Designer for the workflow. Set the workflow so that it you company needs more complex workflows. keywords: Form, creation, for, Active, Directory, Account, creation description: Hi, I am looking for a template