Author Archives: Bill Daugherty II

I had issues trying to research and find a way to add to my Quick Launch menu or my Top Navigation menu, programmatically.  This was a huge challenge.  One of my employees found this link: http://www.anmolrehan-sharepointconsultant.com/2011/09/sharepoint-working-with-quicklaunch.html.  This was something we were able to start out with to add items to the quick launch.  I further [...]

GridView Control Please reference this: http://tablesorter.com/docs/ for the actual source. Step 1: Add the following to the ASP code: (Note, you will want to copy the js and css files to a local network server, I am just using the source) <script type="text/javascript" src="http://tablesorter.com/jquery-latest.js"></script> <script type="text/javascript" src="http://autobahn.tablesorter.com/jquery.tablesorter.js"></script> <link rel="stylesheet" href="http://tablesorter.com/themes/blue/style.css" type="text/css" media="print, projection, screen" /> [...]

Modify Your Quick Launch First, modify your quick launch: http://xxxxxxx/_layouts/quiklnch.aspx Add a javaScript modal popup Next, get the link of the item you want to add, and make sure it has the IsDlg=1 in the URL, add it as a link in the following format: javascript:function tdql1(){SP.UI.ModalDialog.showModalDialog({url:’/xxx/Lists/xxx/NewForm.aspx?RootFolder=&IsDlg=1′,title:’Press Publication’})}tdql1();

Here is some sample code on how to capture the enter key on a textbox in ASP.NET. I am posting this because I use it a lot. function KeyDownHandler() { if (event.keyCode == 13) { event.returnValue = false; event.cancel = true; document.getElementById(‘cphmainContent_C008_LoginButton’).click(); } } Then add this to your textobox: onkeydown=”KeyDownHandler();”

Microsoft Download Site: http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=26623

So the strangest error came up in our environment today. When users go to open excel documents, they get this message: Unable to process the request.  Wait a few minutes and perform this operation again. I did a trace in ULSLogViewer: There was an error in communicating with Excel Calculation Services http://xxxxxx:12345/fc4fbe4d08ge4a5589e844e33e8d3c08/ExcelService*.asmx exception: An error [...]

Microsoft Expressions Blend has some very useful functionality and I just wanted to share this. Here is the overview for SketchFlow by Microsoft: http://www.microsoft.com/expression/products/sketchflow_overview.aspx Jeff Rix who works with me created this in about 15 minutes within SketchFlow.  It is much better UI prototyping than Excel or Visio.   I really suggest this application to [...]

All, SCRUM is GREAT with Agile programming, however; sometimes you need to change things up a bit.  Sometimes, you have a small enough team that you may need to combine SCRUM with Kanban. Please see this site for Kanban starting material: http://www.crisp.se/kanban/ and Kanban kick-start example – Crisp   As you can see below, we [...]

I get so many folks contacting me asking what do I recommend when storing massive amounts of files in SharePoint.  Using SP as a document management tool.  As a developer I recommend creating an application that will do this for them.  However I know the answer is “We have to use SharePoint” and that’s very [...]

In this video I will create a set of cascading drop down fields using two other SharePoint lists.  This is a pretty common request, and it is fairly simple task to accomplish.

In this blog posting, I will take you step by step on creating an InfoPath Form that connects to a web service stored on another server (normally causing cross-domain issues). The business need: SharePoint List – A SharePoint List to hold SoE documents (Separation of Employment) Employee’s Location Drop Down Box – The employees have [...]

You can export all users to a CSV file from Active Directory using a tool called CSVDE, it comes with Windows Server 2003, 2003 R2, 2008, and 2008 R2.  It also comes in the RSAT pack for Windows 7 (shown on my blog post here).  Its really simple, Go to Start Go to RUN (if [...]

  All I can say is WOW.   If something as simple as the PeopleEditor takes me a week to implement and that is with having two Microsoft Premier Support cases open on it, than once I figure it out its worth writing an article on it.   My business requirement: I need a grid view [...]

If you want SharePoint 2010 to open the PDF file from within Internet Explorer, follow the instructions below: From Central Administration, go to Manage Web Application under Application Management… Select your web site, then choose General Settings, and again General Settings…   Select the browser file handling to Permissive. Now you can open PDF’s in [...]

I ran across a great blog that shows how to do some pretty cool stuff with the Drop Down within gridviews. http://weblogs.asp.net/vikram/archive/2008/04/17/handling-dropdown-list-inside-gridview-with-autopostback.aspx protected void dropdownlist1_SelectedIndexChanged(object sender, EventArgs e) { // get reference to the row GridViewRow gvr = (GridViewRow)(((Control)sender).NamingContainer); // Get the reference of this DropDownlist DropDownList dropdownlist1 = (DropDownList) gvr.FindControl("dropdownlist1"); // Get the reference [...]

I have been getting the following error for only some users, and on some pages that has a web part that I created that checks for their username information. 403 Forbidden – The website declined to show this page, most likely cause, this website requires you to log in Yes, I tried logging out and [...]

To show a dialog in SharePoint 2010 simply call the OpenPopUpPage() method with the URL as the parameter.  This will look something like this… <a href="javascript:OpenPopUpPage(‘/pages/test.aspx’);">Show this page…</a> NOTE: Be sure to specify the CSSClass “sp-notdlg” in anything that comes up that shouldn’t be coming up in your master page.  My modified ribbon toolbar came [...]

Check this site out… It automatically creates your regular expressions that you like. http://www.txt2re.com/index-csharp.php3  

Okay, so developing a UI is fun, especially when there is some challenges to it. The standard GridView is a very useful dynamic HTML table builder for your data, it can do a lot of different things.  But it is very limited! For example, if you were to create list that had multiple rows of [...]

This article explains how to have your SQL Server Reporting Service cache the report results. http://msdn.microsoft.com/en-us/library/bb283188.aspx I didn’t even know this was possible until I thought to myself how great it would be to see SSRS cache reports that run just a bit longer than normal. Here are the easy steps to do it. First, [...]

There is a national users group meeting event monthly, and they asked if i could speak at it.  Here is a copy of the live meeting video from the SharePoint user group. I showed the old SharePoint site, and the New. http://s977.photobucket.com/albums/ae253/billsecond1/Professional/?action=view&current=livemeeting.mp4

Okay, first, I wanted to say a few things. Weather or not your connection string contains passwords: DO NOT EVER store your connection string in your code… …not even for just a moment!  Even if what you are coding is a web part.  In some companies this will lead to write ups and possible termination!  [...]

Here is some code that I find myself using in all of my web parts.  You are also free to use it.  I simply reuse it in all of my web parts. It returns “DOMAIN\\USERNAME”   private string GetUserAccount() {     // Normally used with all web parts     // By: Bill Daugherty II     [...]

When setting up a test site (one of our many) before we set up our production environment, I have come across this lovely error: An error has occurred in the claim providers configured from this site collection When I went to create the MySite, I scrolled down a bit to the Read Permission Level configuration [...]

So, this is how I decided to spend half of one of my days off.  Isn’t this sad?  I am addicted to development. I created a new voting web part that will allow users to vote once, and it will add a cookie to the users computer that will expire in 14 days, or until [...]

This site is to act as a “code repository” for all of my source code that I use quite frequently. http://helperclass.com/

Here is a great reference from Microsoft regarding some of the SharePoint development tools: http://www.microsoft.com/downloads/details.aspx?familyid=C010FC68-B47F-4DB6-B8A8-AD4BA33A35C5&displaylang=en#filelist

When building SharePoint 2010 web parts, I have stumbled across the fact that there are really no easy ways to add a configuration file such as a web.config or an app.config.  So I decided to add a new project to my solution that I will eventually detach.  I expect it to build as a .DLL [...]

To Deploy a WSP solution to SharePoint 2010 follow the simple steps below:   Set up your path in your environmental table… SET PATH=%PATH%;C:\Program Files\Common Files\Microsoft Shared\web server extensions\14\BIN Locate Your DEBUG or RELEASE folder CD\DEPLOY Add your solution stsadm -o addsolution -filename YESPrep_Redirection.wsp Deploy your solution stsadm -o deploysolution -name YESPrep_Redirection.wsp -url http://nav-test.yesprep.local -allowgacdeployment [...]

All, I just wanted to let the viewers of this blog know that our migration to SharePoint 2010′s second of three milestones have become a huge success.  I was able to implement MySite and it has become a huge success.  I will keep notes on here to see how the progress goes.   Bill.

After SharePoint 2007 SP2 it is easy to make a SharePoint site Read Only.   Simple go to the Content Database that you want to make read only, and right click it, go to Properties… Under Options, select True for the Database Read Only attribute… Select Yes… Your Content DB is now "Read Only"   [...]

Here is some information from Microsoft: http://office2010.microsoft.com/en-us/sharepoint-server-help/basic-tasks-in-sharepoint-server-2010-HA101839175.aspx?origin=HA010371435 I am going to re-use it in our organization to help promote the new MySites.

As part of our migration plan, I would like to move just our MySite first. By doing this first, this will allow users to still reach their MySite as the rest of the intranet is down for several hours or days. In addition we have been really promoting our MySite’s, so we don’t want our [...]

We are getting close to that point where we will turn down the old SharePoint site and bring up the new. I found this from Microsoft: http://technet.microsoft.com/en-us/library/ff607537.aspx.  It is a checklist to go over what is needed and required to upgrade.   Pre-upgrade steps for a database attach upgrade Prepare for upgrade [ ] Run [...]

When adding SSRS Reports to SharePoint 2010 using the new Performance Point Services Report Viewer Web Part, do the following… Under Site Actions, select More Options…   Select Performance Point Content Lists   Select “Add new item”… That will load up a “Click Once” application that will show Performance Point Dashboard Designer…   Click the [...]

Okay, so I just wanted to say that I upgraded our My Site into our staging environment to test and to see how it will work.  I will say it worked out well. This worked out well.  I just combined the two items that I blogged about before: Set up your My Site as a [...]

Changing the look of your top menu navigation bar is rather simple.  I will demonstrate here how to accomplish this. Here is the example below…   In SharePoint Designer 2010, and your site open, go to All Files, then Style Library   From File, create a new CSS file calling it Style…   Open the [...]

The web part headers out of the box are very boring and add a lot of white space. I wanted to show you how to fix that.  I created a gradient image in Adobe Photoshop (2 minute project): Here is the image in case you wanted it: I saved the file to a location that [...]

For those of you who are getting errors in SharePoint and can’t figure out what is going on and how to troubleshoot them?  To the SharePoint Administrator and Developer they are pretty worthless errors.  So I wanted to show you how to further troubleshoot them. You will see the following screens as such: Or the [...]

In this entry, I wanted to show you how we decided to upgrade our SharePoint environment.  As you can tell this is something that you should carefully plan out.  I would like to point out a few links to read up on while planning out your migration: http://technet.microsoft.com/en-us/sharepoint/ee517214.aspx http://msdn.microsoft.com/en-us/sharepoint/ee514557.aspx http://blogs.technet.com/b/tothesharepoint/archive/2009/11/10/3292072.aspx We decided to take a [...]

When creating an environment for SharePoint 2007 for testing I had found a lot of messy documentation out there.  The real point is that I was unable to find great and through documentation.   Here is my situation. ·         I have about 3 sites in SharePoint 2007 that I require to be moved into a [...]

Again, not really a SharePoint topic, however more of a developer topic.   When building WCF web services, you will want to be sure that you allow enough concurrent connections.  The default concurrent connections to your WCF web service is 10.   When you think about it, you may have 3 or 4 calls when [...]

As you can see from the first image below, the out of the box scrolling functionality is somewhat limited, it keeps the ribbon (and possible titles above the scroll bar).  My organization requires that I expand this scroll bar to the full height of the screen because all of our staff for the most part [...]

Removing the left navigation bar (the Quick Launch) all together in SharePoint 2010. In the master page (or even in a web part), add the following to the header (or within the HTML view of the content editor web part)                 <style type="text/css">                                /* removes the left quick launch */                                #s4-leftpanel{                                                 display:none [...]

I couldn’t have said it any better than they did in this article… http://www.sharepointdevwiki.com/display/spadmin2010/15+-+Configure+User+Profile+Synchronization+Service Go to Central Admin, and Central Administration, (It is recommended to do this in the server that you installed SharePoint, however I was unable to when doing so, so I went to my local machine. Start the service User Profile Services [...]

Installing HyperV Tools on your Windows 7 is easy.  Simply download the RSAT (Remote Server Administration Tools) from Microsoft.  Once you have installed the MSI, you will then need to go to “Turn Windows features on or off” from the Add and Remove Programs screen. Select Remote Server Administration Services Under Role Administration Tools, select [...]

In SharePoint (2007 or 2010) I had an issue where I can’t be RDP’ed in the machine and browse to the site.  While I was on a Microsoft Call talking with a tech regarding a ticket that I had opened on another topic, I mentioned this as an issue, and he said we could fix [...]

I ran into an issue where I was sending emails to a document library, and though I had everything set up correctly, I was getting the following message: Delivery has failed to these recipients or groups: test@nav.yesprep.local The recipient e-mail system can’t process this message now. Please try resending the message later. This was a [...]

Within the SharePoint’s Front End Web Server box, you must enable the SMTP Service along with the IIS Manager for 6.0 to manage and configure it… Select SMTP Server Select Add Required Role Services Select Next Select Next Select Install After Installation, select Finish Still in the SP Server, and from Start, select Administrative Tools [...]

In Central Admin, go to System Settings, then under E-Mail and Text Messages (SMS) select Configure Outgoing Email Settings Enter your Outbound SMT Server and From and Reply To address, then choose OK Now under your Exchange Server, open up your Exchange Management Console and choose Hub Transport under Server Configuration, and double click Anonymous… [...]

To correctly set up the “My Site” you should put it in a different application domain.  You will get the following message: Validate the My Site Host and Individual My Sites are on a dedicated Web application and separate URL Domain Here is how to go about doing this: Under Central Administration, select New to [...]

Often it is needed that you set up an A Record (or a sub domain) to your new SharePoint site, here is how you do it.  I am looking to add nav.yesprep.local to access our new intranet site. · I added the A Record in DNS and pointed it to the correct IP Address. · [...]

Over the last two weeks I have been trying to find the Adventure Works site theme… It was under my knows the whole time.  I found it, and here is how.

Here is a great friend of mine’s blog: http://mstecharchitect.blogspot.com/ I RSS his feeds every day, and I have learned a lot of LINQ, C#, and a lot of other development stuff. Please check it out!

I am in the process of moving all of my projects from the old TFS2008 to the new TFS2010, and I am in need of removing the old projects so that none of my developers use them. To do this, first backup your TFS Database as you should have a maintenance plan for it anyway [...]

Okay, so it’s not directly related to SharePoint, but it is related to Team Foundation Server 2010.  I am in charge of our software development team, and we use to be on TFS 2008 Workgroup Edition limiting 5 users.  I had to remove myself and have a few folks share a user ID because a [...]

Though unrelated to SharePoint 2010, I felt it needed to discuss my unique findings with TFS 2010 implementation with others.  With the new TFS 2010 out, and as robust and great as it is, you still have old projects that you still need to maintain in VS2008.  The problem is getting connected to TFS 2010 [...]

You can install SharePoint 2010 on your Windows 7 computer. In my attempt to install SharePoint 2010 on my laptop computer for development reasons, I ran into quite a few issues.  But I was determined. But guess what…  I was able to resolve it. The Problems! When installing SharePoint 2010 on Windows 7, even if [...]

So, I have a project that I am working on, and I felt because there is always a lack of documentation out there for SharePoint (especially 2010) I felt that I should publish my own blog as I go. I will be posting all of my content here. I am moving our Intranet system from [...]

Hello all, Welcome to one of my blogs talking about my SharePoint Experiences.  I am planning on posting all of my experience and tools in my SharePoint Development here.

Here is how to center the width of the body in SharePoint 2010, you use the nosetwidth class for the workspace. <div id=”s4-workspace” class=”s4-nosetwidth” style=”position:relative; width:1024px; margin-right:auto; margin-left:auto; background:white;”>