Using a combo of a View and Data Connection we will be able to grab ALL of the fields from a List or Library.

1. Open a Text file so you can paste stuff into it.

2. Open the site you want to gather the data from.

3. Navigate to Site Action > Site Settings

4. Under General Settings click on Audience targeting settings. With this page open look at the URL. Starting with the word List, copy everything to the right.

Example: List={515dc5f2-88b9-4f91-80a3-4e133f25d069}

5. Using your Text file, first paste your new List GUID onto the file, next page this string on a another line _vti_bin/owssvr.dll?Cmd=Display&List={GUID}&XMLDATA=TRUE&noredirect=true

6. Now, going back to your List GUID copy everything between the {} brackets. Then paste it into the {GUID} string got from my site, replacing GUID.

Example: _vti_bin/owssvr.dll?Cmd=Display&List={515dc5f2-88b9-4f91-80a3-4e133f25d069}&XMLDATA=TRUE&noredirect=true

7. Go back to your site and paste the long string you just create into the sites URL (see example below for more detail).

Example: http://SiteName/SubSiteName/_vti_bin/owssvr.dll?Cmd=Display&List={515dc5f2-88b9-4f91-80a3-4e133f25d069}&XMLDATA=TRUE&noredirect=true

8. You should now see a page full of XML pertaining to your List or Library.

To take this to the next level you can create a View to narrow down the columns returned in the XML.

1. Create a new View with the fields you want.

2. Edit your newly created view. With the Edit View page open scroll down to Mobile section. Looking at the URL under “Web address for this mobile view:”, grab all the letters and numbers after View=

3. Open this site (http://meyerweb.com/eric/tools/dencoder/) and paste that string into the URL Decoder/Encoder box and click the Decode button.

4. You should now have a cleaner GUID.

5. Paste that new GUID into your Text file.

6. We will now want to join the new GUID with our existing URL string (see below for example).

Example: http://SiteName/SubSiteName/_vti_bin/owssvr.dll?Cmd=Display&List={515dc5f2-88b9-4f91-80a3-4e133f25d069}&XMLDATA=TRUE&noredirect=true&View={8478D19F-831D-45CB-8F24-A481444C5418}

7. You should now see different results than the first URL string we created.

Now the good stuff! Using the URL you can create XML Data Connections in InfoPath and be able to view columns that were once unavailable.

If you are looking for a way to capture the login user name in InfoPath try this.

Dim sUserName As String = System.Enviroment.UserName

If you want to capture user name from SharePoint try this:

http://blogs.microsoft.co.il/blogs/itaysk/archive/2007/04/05/InfoPath-_2D00_-Get-the-current-user-without-writing-code.aspx

 I was seeing duplicate people returned when searching for someone.  Here are a few things I did to locate and fix the problem.

First, check the People scope in the SSP.

Shared Services Administration: SharedServices1 > Search Administration > Scopes

http://moss1:8888/ssp/admin/_layouts/viewscopesssp.aspx?mode=ssp

This scope should have a rule of:

contentclass = urn:content-class:SPSPeople

     Behavior: Require

Take not of the Item Count.

Now take a look at the User Profiles and Properties page.

Shared Services Administration: SharedServices1 > User Profile and Properties

http://moss1:8888/ssp/admin/_layouts/ProfMain.aspx

In the Profile and Import Settings section look at the first item Number of user profiles:.  If this number doesn’t match the Item Count from the Scope you are    pulling too many items into your Local Office SharePoint Server sites  Content Sources.

To check Local Office SharePoint Server sites 

Shared Services Administration: SharedServices1 > Search Administration > Content sources

http://moss1:8888/ssp/admin/_layouts/listcontentsources.aspx

Edit  the Local Office SharePoint Server sites content source

In the Start Addresses section should be the following items

http://(server): (port)/ (SSP)

http://(portalsite)/ (URL of main portal site)

sps3://(server): (port)/ (My Site Host)      Crawl Settings: Crawl everything under the hostname for each start address

Crawl Schedules: Full Crawl: At 12:00 AM every day

Incremental Crawl: Every 2 hour(s) from 7:00 AM for 14 hour(s) every day

Updating the  Local Office SharePoint Server sites fixed my problem.

You updated an existing template with some new fields and data connections then published the form to the library. now users are unable to open any of the older forms they had saved. before the current update users were able to open all the forms with ie.

Error:

There has been an error while loading the form.

Click Try Again to attempt to load the form again. If this error persists, contact the support team for the Web site.Click Close to exit this message.

This form template is not currently browser-enabled. It must either be republished as a browser-enabled form, or opened using Microsoft Office InfoPath 2007.

—————————–

the problem is the older forms are referencing the old template, in my case it was templateOLD.xsn. All i had to do was update all the old forms… below is a block of code that will help you do this. (the forms Modified date and Modified by will change to the current date and the users name that is updating the forms)

Imports System.Text.RegularExpressions

Dim sPath As String
Dim sText As String

For Each file As String In IO.Directory.GetFiles(“\\sharepointed.com\ehaze”) ‘location of your doc library

sPath = file
sText = My.Computer.FileSystem.ReadAllText(sPath)

sText = Regex.Replace(sText, “templateOLD.xsn”, “template.xsn”)

My.Computer.FileSystem.WriteAllText(file, sText, False)

Next