SharePoint Infrastructure Update download

For reference the following products require the following updates to be applied.

If you are running SharePoint Server 2007 you should:

1.
Install Windows SharePoint Services 3.0 Service Pack 1 (SP1) if you haven’t already
2.
Install 2007 Microsoft Office Servers Service Pack 1 (SP1) if you haven’t already.
3.
Install the Infrastructure Update for Windows SharePoint Services 3.0 (KB951695).
4.
Cancel out of the “SharePoint 3.0 Products and Technologies Configuration Wizard”. (You CAN run the wizard if you want. It will just save you time if you run it once at the end.)
5.
Install Infrastructure Update for Microsoft Office Servers (KB951297)
6.
Run the “SharePoint 3.0 Products and Technologies Configuration Wizard”.

If you are running Project Server 2007 you should:

1.
Install Windows SharePoint Services 3.0 Service Pack 1 (SP1) if you haven’t already
2.
Install 2007 Microsoft Office Servers Service Pack 1 (SP1) if you haven’t already.
3.
Install the Infrastructure Update for Windows SharePoint Services 3.0 (KB951695).
4.
Cancel out of the “SharePoint 3.0 Products and Technologies Configuration Wizard”. (You CAN run the wizard if you want. It will just save you time if you run it once at the end.)
5.
Install Infrastructure Update for Microsoft Office Servers (KB951297)
6.
Run the “SharePoint 3.0 Products and Technologies Configuration Wizard”.
7.
You should also then install the Infrastructure Update for Microsoft Office Project 2007 (KB951547) on all Project Professional 2007 client PC’s.

If you are running Search Server 2008 or Search Server 2008 Express you should:

1.
Install the Infrastructure Update for Windows SharePoint Services 3.0 (KB951695).
2.
Cancel out of the “SharePoint 3.0 Products and Technologies Configuration Wizard”. (You CAN run the wizard if you want. It will just save you time if you run it once at the end.)
3.
Install Infrastructure Update for Microsoft Office Servers (KB951297)
4.
Run the “SharePoint 3.0 Products and Technologies Configuration Wizard”.

If you are running Project Professional 2007 you should Install the Infrastructure Update for Microsoft Office Project 2007 (KB951547).

The installation process will incur server and farm downtime that you will need to plan for – updates should be installed on all servers in a farm.

More details:
http://markharrison.co.uk/blog/2008/07/sharepoint-infrastructure-update.htm
http://blogs.msdn.com/sharepoint/archive/2008/07/15/announcing-availability-of-infrastructure-updates.aspx

Update Data Connection in InfoPath Form

If you have 10 data connection that you need to update the address, there is a way.

1.save the XSN as resources in a folder

2.Close infopath

3.then modify what you need (manifest.xsf) update the web service address

4.right clicl on the manifist file and click on design

5. save as XSN again

the dependencies for the object cannot be determined

The issue has very little support out there, so I wanted to post a few fixes I read about, and their result. I’ll post what fixed it for me, but I’m still searching for the all-encompassing solution. Maybe some of the fails below could fix your issue… Please post if you have ideas:

* Tried: Removing and re-adding setup projects: Result: fail
* Tried: Removing my database project and restarting VS: Result: fail
* Tried: Many, MANY, cleans and rebuilds of my solution: Result: fail
* Tried: Reinstall of VS Service Pack 1: Result: No immediate effect
* Tried: Remove and re-add of all project outputs and custom actions: Result: fail
* Tried: Opened the setup projects .vdproj file via Notepad, and removed references to offending project. Re-added my project outputs as usual using File Editor: Result: SUCCESS!

Top 25 Downloads For SharePoint On Codeplex

http://sharepoint.microsoft.com/blogs/mikeg/Lists/Posts/Post.aspx?List=1b3bbb8f%2D4b5a%2D4f72%2D94c4%2D94cb80bc3866&ID=1426

Troubleshooting Access denied errors in SharePoint 2007

Just follow this blog and I found way to figure out the access denied erros in SharePoint 2007.

First, if the error url look like

http://[ServerName]/_layouts/AccessDenied.aspx?Source=[AnyUrl] &Type=list&name=%7B12151589%2D7A0B%2D40EE%2DBD92%2DADB851B3D78E%7D

That’s means you don’t have permission to access one list whose GUID is
%7B12151589%2D7A0B%2D40EE%2DBD92%2DADB851B3D78E%7D
. Then go to List Edit page and replace the GUID with this one so you will know which list give permission error.

More Detaisl:
http://blog.tylerholmes.com/2008/02/troubleshooting-access-denied-errors-in.html

Create a SharePoint Web Application With Host Head

First, go to Central Admin then create a web application with url http://test

Make sure you run IISRESET /NOFORCE after the web application created. Then create a site collection.

Open IIS and click the Property of your site, click Advanced next to IP address of Web Site tab.
Add TCP Port: 80 and Host Header Value: test.

Then on your client machine, open C:\WINDOWS\system32\drivers\etc\hosts file by Notepad, add
127.0.0.1 localhost
???.???.?.? test

The server’s IP address you can get it by PING the server.

Now you are ready to go

Quick CSS Reference

Selector {Declaration}  	H1 {color: red}  	Any H1 tag used in the site (<H1>)

Selector.Class {Declaration} 	H1.Alert {color: red}  	Any H1 tag that uses the class name of Alert (<HI Class="Alert">)
-OR- 	-OR-
.Class {Declaration} 	.Alert {color: red} 	Any tag that uses the class name of Alert (<XXX Class="Alert">)

Selector#ID {Declaration} 	H1#Alert {color: red}  	A H1 tag that uses the ID Alert (<HI ID="Alert">)
-OR- 	-OR-
#ID {Declaration} 	#Alert {color: red} 	A tag that uses the ID Alert (<XXX ID="Alert">)

More details read here

Create a path to the SharePoint command line tools

The following steps make it easy to run common SharePoint administrative tools such as STSADM and PSCONFIG from a command line without having to navigate to folder that contains these tools.
1. Select Start > Control Panel > System
2. Under the Advanced tab select ‘Environment Variables’
3. Select the ‘Path’ variable, click ‘Edit’ and enter the following text (note the semi-colon):
;C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN
4. Close any open command windows to allow the change to take effect

Steps To Install WSP file in STSADM

1. Add the solution
stsadm -o addsolution -filename {WSPFILENAME}
2. Deploy the solution
stsadm -o deploysolution -name {WSPFILENAME} -url {SITEURL}
3. Install the feature
stsadm -o installfeature -filename {FeatureFolder}\feature.xml
4. Activate the feature
stsadm -o activatefeature -id {FEATUREID} -url {SITEURL} -force
5. Deactive the feature
Stsadm.exe -o deactivatefeature -filename “C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\FEATURES\ViewFormPagesLockDown\feature.xml” -ur http://servername/
6.Uninstall the feature
stsadm -o uninstallfeature -filename
7.Retract Solution
stsadm -o retractsolution

-name

[-url]

[-allcontenturls]

[-time]

[-immediate]
8.Delete Solution
stsadm -o deletesolution

-name

Reference

Replace Text in InfoPath XML file

I have an interesting problem when trying to update an InfoPath Form Data. If I use XMLDOCUMNET and node to update the xml file. I got problem to load the data. So I have to use

StreamReader sr = new StreamReader(filename);
String file = sr.ReadToEnd();
sr.Close();
file = file.Replace(oldtext, newtext);
StreamWriter sw = new StreamWriter(filename);
sw.Write(file);
// Close StreamWriter
sw.Close();