When trying to retreive and view data from InfoPath repeating tables using a no code solution you have a couple of options.

1.
When publising your form you can select the column in the repeating table and modify the column function from (first) to (merge). This merges all the repeating values into one column so you can see all the values in your SharePoint View. One problem with this approach
is that the output doesn’t contain a delimiter for each column value so this makes it difficult for reporting

2.
Another option is to add a textbox to the form which will concatinate the values and seperate them via a deliminator (in this case a semi-              colon ‘;’).

In the value area of the textbox add the following formula.
xdMath:Eval(xdMath:Eval(/my:travelRequest/my:trips/my:trip, ‘concat(concat(concat(my:Airline_Name, concat(” – “, my:Flight_Identifier)), concat(” – “, my:Destination_EndDate)), “;”)’), “..”)

This outputs “Air France – GL3444 – 2009-11-05;Qantas - DJ3456 – 2009-11-27;”

To display this information in a SharePoint view you need to create a column in the Form Library for example FlightDetails and when you publish the form add a column mapping that maps FlightDetails to your textbox identifier.

Fill out a form and view the Flight information in a SharePoint view concatenated via a semi-colon. Now we have a ‘;’ deliminator we can easily extract/filter data when exported to an excel spreadsheet.

If you want to you can hide the textbox so users don’t see the value when filling out the form.

If you implement paging and sorting in a GridView control then you need to maintain column level sorting when you move between pages.

I apoligise for the code formatting but wordpress doesn’t format code blocks very well.

General Methods
//general method to bind grid. Pass in true if this method is called from the page index event
protected void GridBind(bool IsPageIndexEvent)
{
    GridRequests.DataSource = SortDataTable(GetRequestsDataTable(LoginCode), IsPageIndexEvent);
    GridRequests.DataBind();
}

private string GridViewSortExpression
{
    get { return ViewState["SortExpression"] as string ?? “Request Id”; }
    set { ViewState["SortExpression"] = value; }
}

//this method is called to alternate sort direction
private string GetSortDirection()
{
    switch (GridViewSortDirection)
    {
        case “ASC”:
            GridViewSortDirection = “DESC”;
            break;
        case “DESC”:
            GridViewSortDirection = “ASC”;
            break;
    }
    return GridViewSortDirection;
}

 
//alternate sort direction and maintain page index
void GridRequests_Sorting(object sender, GridViewSortEventArgs e)
{
    GridViewSortExpression = e.SortExpression;
    int pageIndex = GridRequests.PageIndex;
    GridBind(false); //pageindex event did not fire binding
    GridRequests.PageIndex = pageIndex;
}

I am currently up in the sugar capital of Australia, Mackay delivering a 3 day SharePoint designer training course.

Lots of cool things learned:

• Embedding/displaying videos from a document library in a web page
• Branding: Custom master page design, CSS and overriding core.css
• Integrate Twitter into your site
• DataView Web Part: integration with databases, web services and rss (and sharepoint rollups)
• IE Developer Toolbar is your best friend

And why are those Fab 40 templates so crap!

I have been asked this a few times. How can I remove the View All Site Content link for certain users?

The View All Site Content link can be a great navigational link or a problematic link that confuses end users.

The default security setting for this SPLinkButton is set to be displayed to everyone…and when I say everyone I mean everyone…viewers and even anonymous users. This is found in the master page in your site.

1. Open up the master page in SharePoint designer
2. Place the page into split view
3. Click the View All Site Content link and in you code window you should see the following

<Sharepoint:SPSecurityTrimmedControl runat=”server” PermissionsString=”ViewFormPages”>
        <div class=”ms-quicklaunchheader”><SharePoint:SPLinkButton id=”idNavLinkViewAll” runat=”server” NavigateUrl=”~site/_layouts/viewlsts.aspx” Text=”<%$Resources:wss,quiklnch_allcontent%>” AccessKey=”<%$Resources:wss,quiklnch_allcontent_AK%>”/></div>
</SharePoint:SPSecurityTrimmedControl>

Thankfully we can easily upgrade the security to different security level. For example, if we change the PermissionsString=”ManageWeb” then only users who have this permission level (site admins) will see the View All Site Content link.

<Sharepoint:SPSecurityTrimmedControl runat=”server” PermissionsString=”ManageWeb”>
        <div class=”ms-quicklaunchheader”><SharePoint:SPLinkButton id=”idNavLinkViewAll” runat=”server” NavigateUrl=”~site/_layouts/viewlsts.aspx” Text=”<%$Resources:wss,quiklnch_allcontent%>” AccessKey=”<%$Resources:wss,quiklnch_allcontent_AK%>”/></div>
</SharePoint:SPSecurityTrimmedControl>

There are a number of different permission levels that you can view here.

The SharePoint:SecurityTrimmedControl is a handy control that can be used in many locations. For example, wrap it around the Site Actions control for custom and you remove this control based on security.

This has always been a problem for developers with requirements to support multiple browsers. When writing code various browsers render the exact same peice of code differently. So the development process consists of programming workarounds so they render the same or very similar.

Now we have a free tool that we can use to test multiple browsers easily during our development process.

http://www.xenocode.com/browsers/

I have been developing inside SharePoint for a while now and while things are getting easier with tools I think this process for developing User Controls inside SharePoint gives me a lot of control.

1. I have a Graphical User Interface
2. I have a separate project to build and test outside of SharePoint
3. I can easily update and view my project html and binary code

Currently this process doesn’t create me any SharePoint Solution files to deploy across environments. I think to achieve this I will need to create a VS 2008 SharePoint Project…but so far these projects seem to add weight and time that I don’t want at the moment…while I am developing.

1. Create a VS2008 web project
2. In IIS create an IIS Application under your SharePoint web site that has a path to your VS2008 web project created above. This helps for updating content
3. In your VS2008 project create some user controls and test that they function
4. In VS2008 project properties under the Build Events tab point the Post Build events text box and add a copy statement to copy your .dlls and .pdbs to your SharePoint web sites bin directory. This will deploy a new .dll every time you build your VS2008 project. I had problems when I put the VS2008 project .dll into the GAC…it only worked when I put it into the SharePoint’s web sites bin directory
5. Update your master page with CSS references if your VS2008 project contains a style sheet.
6. In SPD in your Page Layout add a Register directive to register your user control
   “<%@ Register Src=”~/UI/UserControls/JobGoals.ascx” TagPrefix=”uc1″ TagName=”JobGoals” %>”
   OR
   Update the SharePoint web site web.config file
   <pages>
     <controls>
           <add src=”~/UI/UserControls/MyAttributes.ascx” tagPrefix=”uc1″ tagName=”MyAttributes”/>
           <add src=”~/UI/UserControls/JobGoals.ascx” tagPrefix=”uc1″ tagName=”JobGoals” />
       </controls>
   </pages>
7. Add the User Control to the Page Layout
   <uc1:JobGoals ID=”JobGoals1″ runat=”server” />
8. Update the SharePoinnt web sites web.config file
   <SafeControl Src=”~/UI/*”  IncludeSubFolders=”True” Safe=”True” AllowRemoteDesigner=”True” />
9. Restart IIS, navigate to a page that uses the page layout and you should see your User Control

Because we created a IIS Application under our SharePoint web site and mapped our VS2008 projects .dll output path to our SharePoints web site, updates are extremely simple.

1. .ascx changes:                modify, save in VS2008 and refresh sharepoint browser
2. .ascx.cs changes:          modify, save, build  in VS2008 and refresh sharepoint browser

I completed my Part 2 presentation on the CQWP today. I thought that the rain may have kept the numbers down so it was great to see a good turn out.

Topic Covered:

• How and where best to use – plan ahead
• Displaying extra columns in result set
• Modifying the ItemStyle.xsl and .webpart files
• XSLT
• Tips and tricks – (thanks Tim for the select=.) tip
• Subclassing using Visual Studio
• Deployment

I always need more time presenting at user groups.

Slide deck and demos will be uploaded to the BSPUG site soon.

I was having a great deal of pain on a new SharePoint development server recently. Environment = Windows 2008, IE7.

Situation

1. Create a SharePoint web application with a host header on port 80. Create a site collection
2. Update host file (or DNS) with new host header entry
3. In IE make sure the web application is in the Intranet Zone
4. Open up browser in IE navigate to site using host header and the authentication dialog login is displayed.
5. Enter my credentials 3 times and receive a 401.1 and an entry in the Security Event log
6. If I open FireFox and browse to the web site the authentication dialog is displayed
7. I enter my credentials and I can log in fine
   Note: To get rid of the authentication prompt in FireFox
1. Open FireFox and in the address type about:config
2. Find the entry network.automatic-ntlm-auth.trusted-uris
3. Set the Key’s value to a comma seperated list of trusted URIs i.e your host header
8. So FireFox is fine but IE is having issues

Solution

I finally stumbled across a blog article from Brian Farnhill and Ishai Sagi that lead me to the solution.

You receive error 401.1 when you browse a Web site that uses Integrated Authentication and is hosted on IIS 5.1 or IIS 6
http://support.microsoft.com/default.aspx/kb/896861

In my case I am using IE 7 and while the Solution/Workaround discusses two separate methods and states that method one is preferred, I could only fix my issue upon completing method 2

A list of useful accessibility resources

Microsoft ASP.Net

• Building ASP.NET 2.0 Web Sites Using Web Standards – a must read
  http://msdn.microsoft.com/en-us/library/aa479043.aspx
  
• Accessibility Support in ASP.Net
  http://msdn.microsoft.com/en-us/library/ms228004(VS.80).aspx
   
• Invaulable resource on .Net controls and their accessibility
  Will explain what controls you can use with no isses (their not listed), what you need to do or not do to use certan controls, and what controls cannot be used full stop.
  http://msdn.microsoft.com/en-us/library/ms227996(VS.80).aspx
   
• How to: Use Label Web Server Controls as Captions – AssociateControlId; AccessKey
  http://msdn.microsoft.com/en-us/library/ms227968(VS.80).aspx
  

SharePoint Specific

• SharePoint Dev Wiki
  http://www.sharepointdevwiki.com/display/public/SharePoint+Accessibility

Tools

• Accessibilty & XHTML  checker.
  Online, Client download and FireFox plug-in - Total Validator
  http://www.totalvalidator.com/index.html
  
• Online Accessiblity Checker
  http://wave.webaim.org/ 

I was recently asked to provide a process for importing Employee pictures into SharePoint so they would show up in search results and various OOTB web parts. This particular client has MOSS but doesn’t use My Sites.

This post by Henry initially helped me out.

They didn’t want the individual users to have the abilty to upload their own photo’s or modify them in any way, this was to be managed by IT.

1. Create a Picture Library in your Intranet. This will store the photo’s for each employee. When storing employee photo’s chose the filename carefully if you want to populate the AD using scripts. I use something like cjames.jpg which is a correlation to the users account name.
2. In Active Directory choose an AD property that will be mapped to your SharePoint User Profile Property. In my case I selected the extensionAttribute1 field that is located in the ExchangedAdvanced tab ((note this field may not show up if the Exchange Mgt Console hasn’t been installed)
3. Populate this field with the URL to the employee’s photo that is in the Picture Library e.g http://sitename/ProfilePhotos/CJames.jpg (look below for a script example)
4. In SharePoint SSP click the User Profiles and Properties link
5. Click the View Profile Properties under the heading User Profile Properties
6. Find the Picture property and select the Edit menu item
7. Make note of the Usage: Number of profiles using this property. This should increase after we complete a full import
8. At the bottom of the screen make sure Master Connection is selected and in the Datasource field to map select extensionAttribute1 (note: this field may not show up if the Exchange Mgt Console hasn’t been installed)
9. Click Ok
10. Complete a StartFull Import
11. Once the full import is complete go back into the the Picture property and again check the Usage:Number of profiles that use this property. This should now contain some values.
12. Verify this by viewing an Employee’s profile and the Picture property

Some things I had issues with:

• Make sure your Import Connection service account has “Manage User Profile” permissions
• May need to execute a Full Search crawl once photos are uploaded in the Picture Library

I also wrote a script to populate the AD extensionAttribute1 field as there were over 1000 employee’s and no one put their hand up for this job. The import thing here was for employee photo images to have a one to one mapping with their login account name (samaccountname). The person who runs this script also needs certain permissions in AD to update AD accounts. I would initially comment out the On Error Resume Next so you see if your account has enough privleges or not.

The script is very limited but hopefully it may provide some insight.

‘On Error Resume Next
Set objParent = GetObject(“LDAP://OU=Users,OU=Austraila,OU=Offices,OU=AU,DC=domain,DC=local“)
objparent.Filter = Array(“user”)
for each objUser in objParent
  Wscript.Echo “Modifying ” & objUser.Get(“samaccountname”) 
  objUser.put “extensionAttribute1″, “http://sitename/ProfilePhotos/” & objUser.Get(“samaccountname”) & “.jpg”
  objuser.Setinfo   
next

Wscript.Echo “End”

Now, IT are responsible whenever they create a new account they must also populate the extensionAttribute1 field with the URL of the picture library and the employee’s picture filename will always be their account name.