SHAREPOINT DESIGNER 2007 IS NOW FREE!

SharePoint Designer 2007 provides the powerful tools you need to deliver compelling and attractive SharePoint sites and quickly build workflow-enabled applications and reporting tools on the SharePoint platform, all in an IT-managed environment.

You can download it at http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=baa3ad86-bfc1-4bd4-9812-d9e710d44f42.

How to Download all files from SharePoint Library?

Using following code we can download all the documents including Subfolders.

SPList list = web.Lists["Shared Documents"];
SPView view = list.Views["All Documents"];
SPQuery squery = new SPQuery(view);
squery.ViewAttributes = “Scope=\”Recursive\”";
SPListItemCollection items = list.GetItems(squery);

//Read all documents and write those files to Local Machine
foreach (SPListItem item in items)
{
byte[] binfile = item.File.OpenBinary();
FileStream fstream = new FileStream(”F:\\” + item.File.Name, FileMode.Create, FileAccess.ReadWrite);
fstream.Write(binfile, 0, binfile.Length);
fstream.Close();
}

Microsoft Office SharePoint Server 2007 and Related Technologies pricing

http://office.microsoft.com/en-us/sharepointserver/FX102176831033.aspx

Sharepoint Price Calculator

http://community.bamboosolutions.com/blogs/sharepoint-price-calculator/default.aspx

How to Shrink SharePoint content database size?

Run following SQL command to free up space of sharepoint content database

dbcc shrinkdatabase(WSSContentDatabaseName)

How to set permission and restrict view to particular user

Using following tool you can set permissions to views and restrict views to particular users. This feature is not available in MOSS 2007.

http://www.codeplex.com/SPViewPermission

How to set field permission in Sharepoint List

Folllowint tool providing advanced settings to customize list form rendering in new, display and edit mode.

http://splistdisplaysetting.codeplex.com/

Disable Right Click on Sharepoint Portal

Add a content editor web part and add following code in the source editor

 

Microsoft Best Practices Analyzer for 2007 Microsoft Office System

The Microsoft Best Practices Analyzer for Windows SharePoint Services 3.0 and the 2007 Microsoft Office System Best Practices Analyzer programmatically collects settings and values from data repositories such as MS SQL, registry, metabase and performance monitor. Once collected, a set of comprehensive ‘best practice’ rules are applied to the topology.

Administrators running this tool will get a detailed report listing the recommendations that can be made to the environment to achieve greater performance, scalability and uptime.

http://www.microsoft.com/downloads/details.aspx?familyid=cb944b27-9d6b-4a1f-b3e1-778efda07df8&displaylang=en

Microsoft Released MOSS End User Training Materials

Microsoft have released end user training materials for MOSS 2007. A good starter material for organizations looking to publish end user help guide. Download it from 

http://blogs.msdn.com/sharepoint/archive/2007/09/07/customizable-everyday-productivity-education-epe-content-developed-by-microsoft-it-for-end-user-training.aspx

Backup Script fo MOSS 2007

MOSS have some out of box backup/restore functionality, but doesnt have scheduer. So I have created batch file with using of STSADM feature. You can schedule this file in Windows Scheduler, it will generate filename with datestamp. Here is the script

@echo off
echo ====================================================
echo Ful Backup Script For Office SharePoint Server 2007
echo ====================================================
cd \Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\BIN
@echo off
@For /F "tokens=2 delims=/ " %%A in ('Date /t') do set DAY=%%A
@For /F "tokens=3 delims=/ " %%B in ('Date /t') do set MONTH=%%B
@For /F "tokens=4 delims=/ " %%C in ('Date /t') do set YEAR=%%C
Set CUSTOMDATE=%YEAR%-%MONTH%-%DAY%
stsadm.exe -o backup -url http://portal -filename E:\Backupsharpoint\portal_%CUSTOMDATE%.bak -backupmethod full -overwrite

@echo off
cd\
echo completed