tag:blogger.com,1999:blog-59774879282097356892024-03-05T17:37:22.273+10:00Derek Halstead's SharePoint 2007/2010 BlogHello and welcome to my SharePoint Blog. Here you can keep uptodate with all my latest SharePoint 2007/2010 blog entries. Find code examples and share information with the rest of the SharePoint world. Enjoy!Derek Halsteadhttp://www.blogger.com/profile/14401859286291954030noreply@blogger.comBlogger6125tag:blogger.com,1999:blog-5977487928209735689.post-26104517225489057702010-11-30T22:08:00.001+10:002010-11-30T22:09:33.071+10:00Create a three tier SharePoint 2010 Development Environment.<div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">Ok, so today we are going to look at setting up a three tier SharePoint 2010 Development environment real quick. I spent alot of time trying to figure out how to get this done and in the end it turned out to be real simple.<br />
<br />
<b>What you will need:</b></span></div><ul style="font-family: Verdana,sans-serif;"><li><span style="font-size: x-small;">VMWare Workstation 7.1</span></li>
<li><span style="font-size: x-small;">500GB External USB drive</span></li>
<li><span style="font-size: x-small;">Laptop with 8GB memory</span></li>
<li><span style="font-size: x-small;">Windows Server 2008 R2 64 Bit</span></li>
<li><span style="font-size: x-small;">Windows Server 2003 (optional)</span></li>
<li><span style="font-size: x-small;">SQL Server 2008 R2 64 Bit</span></li>
<li><span style="font-size: x-small;">SharePoint Server 2010</span></li>
</ul><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br />
<b>How to do this:</b><br />
<br />
First thing you need to do is create 4 virtual machines</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"></span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br />
<br />
<table border="0" cellpadding="1" cellspacing="1" style="width: 500px;"><tbody>
<tr> <td><span style="font-size: x-small;">Server Name</span></td> <td><span style="font-size: x-small;">Memory</span></td> <td><span style="font-size: x-small;">Disc Space</span></td> <td><span style="font-size: x-small;">Processor</span></td> </tr>
<tr><td colspan="5"></td></tr>
<tr> <td><span style="font-size: x-small;">Domain Controller</span></td> <td><span style="font-size: x-small;">512 MB</span></td> <td><span style="font-size: x-small;">20 GB</span></td> <td><span style="font-size: x-small;">1</span></td> </tr>
<tr> <td><span style="font-size: x-small;">Web Server</span></td> <td><span style="font-size: x-small;">2048 GB</span></td> <td><span style="font-size: x-small;">50 GB</span></td> <td><span style="font-size: x-small;">1</span></td> </tr>
<tr> <td><span style="font-size: x-small;">Application Server</span></td> <td><span style="font-size: x-small;">2048 GB</span></td> <td><span style="font-size: x-small;">50 GB</span></td> <td><span style="font-size: x-small;">1</span></td> </tr>
<tr> <td><span style="font-size: x-small;">SQL Server</span></td> <td><span style="font-size: x-small;">2048 GB</span></td> <td><span style="font-size: x-small;">50 GB</span></td> <td><span style="font-size: x-small;">1</span></td> </tr>
</tbody></table><br />
The Web, Application and SQL servers will form the three tier. For the Domain controller I chose to install Windows Server 2003. Microsoft have some great articles on how to configure a Domain Controller here <a href="http://technet.microsoft.com/en-us/library/cc759011%28WS.10%29.aspx">http://technet.microsoft.com/en-us/library/cc759011%28WS.10%29.aspx</a><br />
</span><br />
<span style="font-size: x-small;"><br />
<b>Step 1</b><br />
<br />
For the other servers I installed Windows Server 2008 R2. You can create one windows server 2008 and then run SysPrep to ensure each copy you make of the original thereoff will be unique. This will be our template. Make 3 copies of the template.<br />
<br />
Great, so at this stage you should have 3 Windows Server 2008 R2 servers and 1 Windows Server 2003 Domain Controller called "DomainController".<br />
<br />
<b>Step 2</b><br />
<br />
Go ahead and install SQL Server 2008 on one of the servers and make sure you give the server a reasonable name, I have named mine "SQLServer"...literally, no confusion here! Also, ensure TCP/IP connections are set to allow for network configuration.<br />
<br />
<b>Step 3</b><br />
<br />
Grab another copy of the Windows Server 2008 template and use this as the Application Server. We will call this "AppServer". On this server you will install SharePoint Server 2010 but will not configure SharePoint 2010 just yet.<br />
<br />
<b>Step 4</b><br />
<br />
Grab another copy of the template and use it as the Web Server, call it "WebServer", and on this we will install SharePoint Server 2010 but will leave the configuration for later.<br />
<br />
To give these servers a proper name go to Computer Properties and change the name accordingly but make sure you document everything.<br />
<br />
<b>Step 5</b><br />
<br />
Now for the all important bit....to get 4 virtual machines talking to each other you will need to ensure that the "Network Adapter" setting in VMWare Workstation 7.1 for each VM is set to "Host Only". <br />
<br />
Next, power on each of the Servers and log in with the default Administrator password (not the domain account but the local account).<br />
<br />
<b>Step 6</b><br />
<br />
Starting with the Domain Controller, change the IP configuration details to the following sample configuration. Uncheck the Get Automatic IP Address and enter a manual one.<br />
<br />
<b> Domain Controller</b> - "DomainController"<br />
<br />
IP: 192.168.0.12<br />
Subnet Mask: 255.255.255.0<br />
Default Gateway: 192.168.0.1<br />
Preferred DNS Server: 192.168.0.34<br />
<br />
<b> For the Application Server</b> - "AppServer"<br />
<br />
IP: 192.168.0.13<br />
Subnet Mask: 255.255.255.0<br />
Default Gateway: 192.168.0.3<br />
Preferred DNS Server: 192.168.0.12 (notice the IP address here is the IP address of the Domain Controller)<br />
<br />
<b> For the SQL Server</b> - "SQLServer"<br />
<br />
IP: 192.168.0.11<br />
Subnet Mask: 255.255.255.0<br />
Default Gateway: 192.168.0.2<br />
Preferred DNS Server: 192.168.0.12 (notice the IP address here is the IP address of the Domain Controller)<br />
<br />
<b> For the Web Server</b> - "WebServer"<br />
<br />
IP: 192.168.0.14<br />
Subnet Mask: 255.255.255.0<br />
Default Gateway: 192.168.0.4<br />
Preferred DNS Server: 192.168.0.12 (notice the IP address here is the IP address of the Domain Controller)<br />
<br />
Now reboot all the servers and login with the domain\Administrator account on each of the servers.<br />
<br />
<b>Step 7</b><br />
<br />
To configure SharePoint 2010 is easy! Create 2 accounts (spAdminAcct and spFarmAcct) with least priviledges - meaning don't add them to the Admins group on the Domain Controller. Add the spAdminAcct to the Administrator group on the Application Server, Web Server and in the SQL Server, create a new Login for spAdminAcct and check the DBCreator and SecurityAdmin checkboxes. Do not add the spFarmAcct to the Adminstrators group on the servers.<br />
<br />
Run the SP 2010 installation with the SPAdminAcct and use the SPFarmAcct as the Farm Account when prompted.<br />
<br />
<b>Kerberos Configuration</b><br />
<br />
I used Kerberos Authentication which involved a couple of extra steps wherein I had to allow the two accounts and the AppServer to be trusted for delegation in Active Directory, and then I ran the following command: setspn -a http/appserver.domain.local domain\spAdminAcct. Download the SetSpn.exe from the Microsoft website (see suggested reading below).<br />
<br />
<b>Join Web Server to Farm</b><br />
<br />
Next, run the SP 2010 configuration on the Web Server and during configuration make sure you select the "Add to existing farm" setting and follow the steps from there.<br />
<br />
And there you have it, 4 virtual machines comprising of a Domain Controller, a Web Server, an Application Server and a SQL Server with SharePoint 2010.</span><br />
<br />
<span style="font-size: x-small;">This article was more about getting 4 virtual machines talking to each other with the basics of installing and configuring SharePoint 2010.<br />
<br />
If you have any questions please feel free to ask, any suggestions please let me know.<br />
<br />
Regards,<br />
<br />
Derek</span><br />
<span style="font-size: x-small;"><br />
<br />
<b> Suggested Reading:</b><br />
</span><br />
<ul><li><span style="font-size: x-small;"> <b>Installing a Domain Controller:</b> <a href="http://technet.microsoft.com/en-us/library/cc759011%28WS.10%29.aspx">http://technet.microsoft.com/en-us/library/cc759011%28WS.10%29.aspx</a></span></li>
</ul><ul><li><span style="font-size: x-small;"> <b>Installing SharePoint 2010 on a three tier farm:</b> <a href="http://technet.microsoft.com/en-gb/library/ee805948.aspx">http://technet.microsoft.com/en-gb/library/ee805948.aspx</a></span></li>
</ul><ul><li><span style="font-size: x-small;"> <b>Download SetSpn.exe:</b> <a href="http://www.microsoft.com/downloads/en/details.aspx?familyid=5fd831fd-ab77-46a3-9cfe-ff01d29e5c46&displaylang=en">http://www.microsoft.com/downloads/en/details.aspx?familyid=5fd831fd-ab77-46a3-9cfe-ff01d29e5c46&displaylang=en</a></span></li>
</ul><ul><li><span style="font-size: x-small;"><b> VMWare Workstation:</b> <a href="http://downloads.vmware.com/d/info/desktop_downloads/vmware_workstation/7_0">http://downloads.vmware.com/d/info/desktop_downloads/vmware_workstation/7_0</a></span></li>
</ul><span style="font-size: x-small;"> <br />
<br />
<b> Thought for the day:</b> </span><br />
<ul><li><span style="font-size: x-small;">Learn to live a carefree life.</span></li>
</ul><span style="font-size: x-small;"> <br />
<br />
<br />
</span></div>Derek Halsteadhttp://www.blogger.com/profile/14401859286291954030noreply@blogger.com0tag:blogger.com,1999:blog-5977487928209735689.post-3223221876057199522010-11-29T21:10:00.003+10:002010-11-29T21:17:38.889+10:00Cannot generate SSPI context<span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;">While working with MOSS 2007, you may come across the errors below while trying to open up your MOSS 2007 and Central Administration websites.</span><br style="font-family: Verdana,sans-serif;" /><br style="font-family: Verdana,sans-serif;" /><span style="font-family: Verdana,sans-serif;">The error message "<b>Cannot connect to the Configuration database</b>" is displayed in the browser, while "<b>Cannot generate SSPI context</b>" is found in the Event Viewer.</span></span><br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNjwpYg5H7mGDebgTYb2tBos3w-hrEWvPQTIfn8iSZKq4L6ieXRNuWF7nbtLTqcVpk5Y3KOeWJueJ50Zj95EQvlUr_P59OLJfdu2B2shdZ3UuFxhepPNvz1O1m5Vl4BwdlHQw_fcUoFh8/s1600/Error.jpg" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="320" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjNjwpYg5H7mGDebgTYb2tBos3w-hrEWvPQTIfn8iSZKq4L6ieXRNuWF7nbtLTqcVpk5Y3KOeWJueJ50Zj95EQvlUr_P59OLJfdu2B2shdZ3UuFxhepPNvz1O1m5Vl4BwdlHQw_fcUoFh8/s320/Error.jpg" width="289" /></a></div><span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;"> </span><br style="font-family: Verdana,sans-serif;" /><br style="font-family: Verdana,sans-serif;" /><span style="font-family: Verdana,sans-serif;">Most of the online blogs and the solutions found on the Microsoft website are helpful, but none of them may be of any help to you.</span><br style="font-family: Verdana,sans-serif;" /><br style="font-family: Verdana,sans-serif;" /><span style="font-family: Verdana,sans-serif;"><b>One way to solve this problem is to</b>:</span></span><br />
<ul><li><span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;">Log into the SQL Server box, open up SQL Management Studio and once connected right click on the Server Name and select "Activity Monitor". This should tell you if there are any incoming connections to the SQL Server.</span></span></li>
</ul><ul><li><span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;">If you notice there is no activity from the Web Server, then it is pretty obvious the Web Server cannot make contact with the SQL Server.</span></span></li>
</ul><span style="font-size: x-small;"></span><br />
<div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">Thanks to my mate Des for this helpful suggestion.</span></div><span style="font-size: x-small;"><br style="font-family: Verdana,sans-serif;" /><span style="font-family: Verdana,sans-serif;">To test this theory, on the Web Server Desktop create a temporary "Test.UDL" connection file and try to connect to the SQL Server, first using the IP Address of the SQL Server and then using the Name of the SQL Server. Also, use either Windows Authentication of a dedicated SQL Account to connect.</span><br style="font-family: Verdana,sans-serif;" /><br style="font-family: Verdana,sans-serif;" /><span style="font-family: Verdana,sans-serif;">You may be able to connect with the IP Address but not the name of the server or vice versa. This is a DNS issue which is preventing the Web Server from making contact. Immediately get in touch with your Network Administrator to resolve the DNS issue.</span></span><br />
<br />
<span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;">The problem may have occurred after installing updates on the Server. </span></span><br />
<br />
<span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;">A .UDL file must be able to connect to the SQL Server with the IP Address or the Name of the SQL Server. The .UDL file is created to test connection between the servers only and not for any other purpose.</span></span><br />
<span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;"> </span></span><br />
<span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;"> </span></span><br />
<span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;">Any questions please just ask.</span></span><br />
<br />
<span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;">Regards</span></span><br />
<br />
<span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;">Derek</span></span><br />
<span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;"><br />
</span></span><br />
<span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;"><br />
</span></span><br />
<span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;"><b>Helpful links</b>: </span></span><br />
<ul><li><span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;"><a href="http://support.microsoft.com/kb/811889">http://support.microsoft.com/kb/811889</a></span></span></li>
</ul><br />
<b><span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;">Other solutions:</span></span></b><br />
<ul><li><span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;">Check the Application Pool accounts for the Central Administration website and the MOSS 2007 website in IIS and ensure that the domain account used has proper rights on the SQL Server box, and has access to all the MOSS 2007 databases with the DBCreator and Security Admin permissions included.<br />
</span></span></li>
</ul><b><span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;">Thought for the day:</span></span></b><br />
<ul><li><span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;">Believe you are the best and work just like that!</span></span></li>
</ul><span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;"><br />
</span></span><br />
<span style="font-size: x-small;"><span style="font-family: Verdana,sans-serif;"><br />
</span></span><br />
<span style="font-size: x-small;"></span><br />
<span style="font-size: x-small;"></span><br />
<span style="font-size: x-small;"></span><br />
<span style="font-size: x-small;"></span><br />
<span style="font-size: x-small;"></span><br />
<span style="font-size: x-small;"></span><br />
<span style="font-size: x-small;"></span><br />
<span style="font-size: x-small;"></span><br />
<span style="font-size: x-small;"></span><br />
<span style="font-size: x-small;"></span><br />
<span style="font-size: x-small;"><br style="font-family: Verdana,sans-serif;" /></span>Derek Halsteadhttp://www.blogger.com/profile/14401859286291954030noreply@blogger.com0tag:blogger.com,1999:blog-5977487928209735689.post-28195545119642215472010-10-06T14:05:00.004+10:002010-11-29T21:32:30.263+10:00List does not display in Datasheet view<div style="font-family: Verdana,sans-serif;"><span style="color: black; font-size: x-small;"><b>When you open a List, it won't open in Datasheet view.</b></span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br />
</span></div><div style="font-family: Verdana,sans-serif;"><span style="color: black; font-size: x-small;">Category: SharePoint 2010</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br />
</span></div><div style="font-family: Verdana,sans-serif;"><span style="color: black; font-size: x-small;">You see the following error message:</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br />
</span></div><div style="font-family: Verdana,sans-serif;"><span style="color: black; font-size: x-small;"><i>The list is displayed in Standard view. It cannot be displayed in Datasheet view for one or more of the following reasons: A datasheet component compatible with Microsoft SharePoint Foundation is not installed, your browser does not support ActiveX controls, a component is not properly configured for 32-bit or 64-bit support, or support for ActiveX controls is disabled.</i></span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br />
</span></div><div style="font-family: Verdana,sans-serif;"><span style="color: black; font-size: x-small;">To solve this problem simply download and install the following on the user PC:</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br />
</span></div><div class="MsoNormal" style="font-family: Verdana,sans-serif; margin: 0cm 0cm 0pt;"><span style="color: black; font-size: x-small;"><b>2007 Office System Driver: Data Connectivity Components</b> which can be found at the link below.</span></div><div class="MsoNormal" style="font-family: Verdana,sans-serif; margin: 0cm 0cm 0pt;"><span style="font-size: x-small;"><br />
</span></div><div class="MsoNormal" style="font-family: Verdana,sans-serif; margin: 0cm 0cm 0pt;"><span style="color: black; font-size: x-small;"><a href="http://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en">http://www.microsoft.com/downloads/en/details.aspx?familyid=7554f536-8c28-4598-9b72-ef94e038c891&displaylang=en</a></span></div><div class="MsoNormal" style="font-family: Verdana,sans-serif; margin: 0cm 0cm 0pt;"><span style="font-size: x-small;"><br />
</span></div><div class="MsoNormal" style="font-family: Verdana,sans-serif; margin: 0cm 0cm 0pt;"><span style="color: black; font-size: x-small;">Approximately 25 MB in size</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br />
</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br />
</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">Any questions please just ask. Any alternative suggestions please let me know.</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br />
</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">Cheers</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br />
</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">Derek</span></div>Derek Halsteadhttp://www.blogger.com/profile/14401859286291954030noreply@blogger.com0tag:blogger.com,1999:blog-5977487928209735689.post-42657940941286001012010-10-06T13:43:00.002+10:002010-10-06T14:06:01.470+10:00How to display the List item ID at the top of the List Item window<span style="font-family: Calibri;"><strong>Display the List item ID at the top of the List item window.</strong> </span><br />
<br />
<span style="font-family: Calibri;">Category: SharePoint 2010</span><br />
<br />
<br />
This is useful when you need to print out a single List item (<a href="http://derekhalstead.blogspot.com/2010/10/print-single-list-item-in-sharepoint.html">see how to print a single List item</a>) and share with your team.<br />
<br />
Thank you to <a href="mailto:Christophe@PathToSharePoint.com">Christophe@PathToSharePoint.com</a> for the code to display the List Item ID.<br />
<br />
<div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: -18pt;"><span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">a.</span><span style="font-family: "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Open the List</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: -18pt;"><span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">b.</span><span style="font-family: "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Hit the List tab</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: -18pt;"><span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">c.</span><span style="font-family: "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Click the Form Web Parts dropdownlist</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: -18pt;"><span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">d.</span><span style="font-family: "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Choose “Default Display Form”</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: -18pt;"><span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">e.</span><span style="font-family: "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">At the top of the Page – Insert Tab, Click the Web Part button to add a new Content Editor web part.</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: -18pt;"><span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">f.</span><span style="font-family: "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">From Categories choose “Media and Content” > “Content Editor” and add it to the main section of the page</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: -18pt;"><span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">g.</span><span style="font-family: "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Click the “Click here to add content” and then click the HTML button in the Ribbon to bring up the Edit source code window.</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: -18pt;"><span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">h.</span><span style="font-family: "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">In the window add the following code to display the Item ID at the top of the list item window.</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: -18pt;"><span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">i.</span><span style="font-family: "Times New Roman";"> </span></span></span><span style="font-family: Calibri;"><code><br />
<script type="text/javascript"></span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>//</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>// Item ID in DispForm.aspx and EditForm.aspx</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>// Feedback and questions: Christophe@PathToSharePoint.com</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>//</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>function DisplayItemID()</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>{</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>var regex = new RegExp("[\\?&]"+"ID"+"=([^&#]*)");</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>var qs = regex.exec(window.location.href);</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>var TD1 = document.createElement("TD");</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>TD1.className = "ms-formlabel";</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>TD1.innerHTML = "<h3 class='ms-standardheader'>Issue ID</h3>";</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>var TD2 = document.createElement("TD");</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>TD2.className = "ms-formbody";</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>TD2.innerHTML = qs[1];</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>var IdRow = document.createElement("TR");</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>IdRow.appendChild(TD1);</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>IdRow.appendChild(TD2);</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>var ItemBody = GetSelectedElement(document.getElementById("idAttachmentsRow"),"TABLE").getElementsByTagName("TBODY")[0];</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>ItemBody.insertBefore(IdRow,ItemBody.firstChild);</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>}</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span><span style="mso-spacerun: yes;"> </span></span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span>_spBodyOnLoadFunctionNames.push("DisplayItemID");</span></div><div class="MsoListParagraphCxSpMiddle" style="margin: 0cm 0cm 0pt 72pt; mso-add-space: auto;"><span style="font-family: Calibri;"><span style="mso-tab-count: 1;"> </span></script></span><span style="font-family: Calibri;"></code></span></div><div class="MsoListParagraphCxSpLast" style="margin: 0cm 0cm 10pt 72pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: -18pt;"><span style="mso-bidi-font-family: Calibri; mso-bidi-theme-font: minor-latin;"><span style="mso-list: Ignore;"><span style="font-family: Calibri;">j.</span><span style="font-family: "Times New Roman";"> </span></span></span><span style="font-family: Calibri;">Ignore any Warnings! </span><span style="font-family: "Calibri", "sans-serif"; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-AU; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Next hit the Page tab at the top of the page and view the list item. Done!</span></div><div class="MsoListParagraphCxSpLast" style="margin: 0cm 0cm 10pt 72pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-indent: -18pt;"><br />
</div><div class="MsoListParagraphCxSpLast" style="margin: 0cm 0cm 10pt 72pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-align: left; text-indent: -18pt;"><span style="font-family: "Calibri", "sans-serif"; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-AU; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Any questions please just ask.</span></div><div class="MsoListParagraphCxSpLast" style="margin: 0cm 0cm 10pt 72pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-align: left; text-indent: -18pt;"><br />
</div><div class="MsoListParagraphCxSpLast" style="margin: 0cm 0cm 10pt 72pt; mso-add-space: auto; mso-list: l0 level2 lfo1; text-align: left; text-indent: -18pt;"><span style="font-family: "Calibri", "sans-serif"; font-size: 11pt; line-height: 115%; mso-ansi-language: EN-AU; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: "Times New Roman"; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: Calibri; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin;">Derek </span></div>Derek Halsteadhttp://www.blogger.com/profile/14401859286291954030noreply@blogger.com0tag:blogger.com,1999:blog-5977487928209735689.post-11975952433159917802010-10-06T13:31:00.002+10:002010-10-06T14:06:57.105+10:00Print a single List item in SharePoint 2010<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><span style="font-family: Verdana, sans-serif; font-size: x-small;"><strong>How to print a single list item in SharePoint 2010</strong></span><br />
<br />
<span style="font-family: Verdana; font-size: x-small;">Category: SharePoint 2010</span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">You may need to print a single list item in SharePoint 2010. However, this functionality does not exist unless you print with Excel, which isn't what you are looking for anyway.</span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">So, how do we go about accomplishing this?</span><br />
<br />
<ol><li><span style="font-family: Verdana, sans-serif; font-size: x-small;">Open a List</span></li>
<li><span style="font-family: Verdana, sans-serif; font-size: x-small;">Hit the List tab</span></li>
<li><span style="font-family: Verdana, sans-serif; font-size: x-small;">Click the Form Web Parts dropdownlist</span></li>
<li><span style="font-family: Verdana, sans-serif; font-size: x-small;">Choose “Default Display Form”</span></li>
<li><span style="font-family: Verdana, sans-serif; font-size: x-small;">At the top of the Page – Insert Tab, Click the Web Part button to add a new Content Editor web part (CEWP).</span></li>
<li><span style="font-family: Verdana, sans-serif; font-size: x-small;">From Categories choose “Media and Content” > “Content Editor” and add it to the main section of the page.</span></li>
<li><span style="font-family: Verdana, sans-serif; font-size: x-small;">Click the “Click here to add content” and then click the HTML button in the Ribbon to bring up the Edit source code window.</span></li>
<li><span style="font-family: Verdana, sans-serif; font-size: x-small;">In the window add the following code to display a Print Button at the top of the list item window. </span><br />
<div></div><div><span style="font-family: Verdana, sans-serif; font-size: x-small;"><code><br />
<input type="button" value=" Print this page " onclick="window.print();return false;" /> </span></div><div><span style="font-family: Verdana, sans-serif; font-size: x-small;"></code></span></div></li>
<li><span style="font-family: Verdana, sans-serif; font-size: x-small;"><br />
<div>Ignore any warnings.</div></span></li>
<li><span style="font-family: Verdana, sans-serif; font-size: x-small;"><br />
<div>Next, hit the Page tab at the top of the page to view the List item. You should see the Print button.</div></span></li>
<li><span style="font-family: Verdana, sans-serif; font-size: x-small;"><br />
<div>Hit the Print button to print just the list item.</div></span></li>
</ol><span style="font-family: Verdana, sans-serif; font-size: x-small;">So there you go, with just a little tweaking you can print a single List item.</span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Any questions please just ask.</span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;">Derek</span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span><br />
<span style="font-family: Verdana, sans-serif; font-size: x-small;"></span>Derek Halsteadhttp://www.blogger.com/profile/14401859286291954030noreply@blogger.com13tag:blogger.com,1999:blog-5977487928209735689.post-85739470644305386342010-05-26T16:25:00.000+10:002010-05-26T16:25:24.853+10:00SharePoint 2007 Installation<span style="font-size: x-small;"></span><span style="font-size: x-small;"></span><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;">Installation steps:</span></div><div style="font-family: Verdana,sans-serif;"><span style="font-size: x-small;"><br />
</span></div><ol style="font-family: Verdana,sans-serif;"><li><span style="font-size: x-small;">Install Windows Server 2003 plus IIS from Additional Components</span></li>
<li><span style="font-size: x-small;">Install SQL Server 2005 + Service Pack 3</span></li>
<li><span style="font-size: x-small;">Install .NET Framework 3.5</span></li>
<li><span style="font-size: x-small;">Install SharePoint 2007</span></li>
<ul><li><span style="font-size: x-small;">Configure servers</span></li>
<li><span style="font-size: x-small;">Configure services</span></li>
<li><span style="font-size: x-small;">Configure shared services provider</span></li>
</ul><li><span style="font-size: x-small;">Create a top level site, do not pick '/sites' from the dropdownlistbox. Pick '/' instead to create a top level site so when you type in the url of the web server 'http://myserver' this should bring up your top site.</span></li>
<li><span style="font-size: x-small;">Install Visual Studio 2010 but first make sure you have Windows Server 2003 Service Pack 2 installed on your server.</span></li>
</ol>Derek Halsteadhttp://www.blogger.com/profile/14401859286291954030noreply@blogger.com0