Gigabytz SharePoint Tips

Fix the SharePoint DCOM 10016 error on Windows Server 2008 R2

2010-12-16T12:36:00.000-05:00

http://www.wictorwilen.se/Post/Fix-the-SharePoint-DCOM-10016-error-on-Windows-Server-2008-R2.aspx

Thank you Wictor for this great post......Works perfectly.

Schannel error showing up on your front-ends event log

2010-12-16T12:32:00.000-05:00

I am posting this as I have search the web for quite awhile and found a lot of issues surrounding this. However for SharePoint related issues I found very little. It seems this error could be realted to you using https in your sharepoint farm and a process or user initiates a http request instead. This error is just reporting it. As far as I know, these errors are common and not serious, it is simply a Security feature of Windows Server 2008 R2 that any negotiation or problem of unexpected messages for secure channel can be recorded. The Schannel level of logging can be configured as described in:

NPS: SCHANNEL
http://technet.microsoft.com/en-us/library/dd197492%28WS.10%29.aspx

The General error is
The following fatal alert was generated: 10. The internal error state is 1203 "or it could be 10".
The Details are
- System
- Provider
[ Name] Schannel
[ Guid] {1F678132-5938-4686-9FDC-C8FF68F15C85}
EventID 36888
Version 0
Level 2
Task 0
Opcode 0
Keywords 0x8000000000000000
- TimeCreated
[ SystemTime] 2010-06-18T04:51:41.830028400Z
EventRecordID 10087
Correlation
- Execution
[ ProcessID] 604
[ ThreadID] 3828
Channel System
Computer
- Security
[ UserID] S-1-5-18
- EventData
AlertDesc 10
ErrorState 1203 or it could be 10

SharePoint 2010 Training for end users FREE from Microsoft!

2010-12-14T13:25:00.000-05:00

http://www.microsoft.com/downloads/en/details.aspx?familyid=4AAA9862-E420-4331-8BC3-469D7BAE0FF1&displaylang=en&hash=hu2XviPPtxw6tFJenXjgvWNraiuxnCoBXGJu9%2bRI3wD%2bUX7Mk9G25uOXKhaDm9wv8C%2bN7q%2brxXG6HKiG2pFaMQ%3d%3d

SharePoint 2010 search does not display numbers like IP addresses

2010-12-14T10:16:00.001-05:00

Just click the top checkbox and run a full crawl. Your numbers will now appear!

Kudos http://blogs.msdn.com/b/enterprisesearch/archive/2010/01/21/regular-expressions-support-in-crawl-rules.aspx

Added SSL now crawls stopped

2010-12-02T14:10:00.002-05:00

First, open IIS manager, go to the sharepoint site, then double click SSL settings, check if you set “client certificates:” to Accept, if you did, change it to Ignore.

Second, use the default content access account when you specify authentication in crawl rules.

:)

The credentials you provided for the sql server service are invalid & The current SKU is invalid

2010-11-16T08:52:00.001-05:00

Summary: The credentials you provided for the sql server service are invalid & The current SKU is invalid
Details:

Ok, disk problems resolved, resuming the install (not doing advanced prepare this time!)
Successfully installed first single node cluster, hoooooray!!!!
When attempting to add node to the cluster, it failed stating “the credentials you provided for the sql server service are invalid”. It Failed on SQL Server / SQL Server Agent. I attempted to change the password to no avail, failed every time.
Found this article: http://support.microsoft.com/default.aspx/kb/955948/ which states “To work around this issue, type the domain account manually in the Account Name text box.” This is not true, as the boxes are grayed out and do not allow you to change the account.
Unsure to as where I got the information from, but I had read somewhere that CU1 would resolve this specific issue (trying to find link).
Ok, installed SP1 on the node which has the single node cluster setup.
Attempted to add node, “Failed: SQL 2008 Cluster – The current SKU is invalid.”
Found these articles: http://support.microsoft.com/kb/957459/ & https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=363036&wa=wsignin1.0M
Install SP1 on a node that doesn’t have SQL installed huh? Interesting. The 2008 cluster install doesn’t use the task scheduler any more, and the nodes have to be manually installed, so why do I need to patch a server that doesn’t have any trace of SQL on it yet?
Low and behold, when I went to install SP1 on each of the other nodes, it patched the “shared features” successfully.
Tried to add node to cluster, successful on each node!
Had to install SP1 again on each node after I completed the install.
What did I learn?
You need to install SP1 (or at least CU1) after installing your first single cluster node. After that, you have to install SP1 (or CU1) prior and post to adding any other nodes on the cluster. Crazy, but at least I know now.

--------------------------------------------------------------------------------

GREAT POST FROM SQLSLAYER

Migrate 07 Content DB to 2010--last two steps!

2010-11-16T08:50:00.001-05:00

Reset Site Definition under site actions, then go in and do visual upgrade.

:)

SharePoint-Visio-Stencils

2010-10-07T12:48:00.003-04:00

Download them here, I forgot where I got them from...

http://www.gigabytz.net/sharepoint-visio-stencils.zip

John

SharePoint Server 2010 performance and capacity test results and recommendations

2010-10-07T12:39:00.002-04:00

I took the liberty of zipping up all the word docs from MS and giving you guys a link :)

http://www.gigabytz.net/sps2010.zip

Cheers

SharePoint 2010 SharePoint Sizer Tool

2010-10-07T12:33:00.001-04:00

HP has a pretty cool tool for SharePoint Architects, download it here.

http://h20338.www2.hp.com/activeanswers/Secure/548230-0-0-0-121.html

HP Sizer for Microsoft SharePoint is a complimentary planning resource that encapsulates knowledge gained from extensive performance characterization of Office SharePoint Server 2007 and SharePoint 2010 in the HP Alliances Performance and Solutions labs, widespread collaboration between HP and Microsoft, and numerous SharePoint performance whitepapers produced by HP engineering. The Sizer offers a quick and consistent methodology for determining and comparing configurations, as well as detailed, customizable server and storage solutions complete with bill of materials and pricing.

HP Sizer for Microsoft SharePoint solicits data or uses built-in defaults to determine optimal configurations based on SharePoint deployment best practices. Selectable configurations include entry level, highly available, and application optimized solutions. A "what if" feature allows rapid comparison of the effects of workload changes, platform and storage technology selection, and provides role-based server configurations, capacity utilization, and estimated network traffic. Users can select a configuration and then customize their environment by adding or substituting components within best-practice guidelines.

The tool also addresses one of the most critical areas of SharePoint server design: performance and capacity planning for the storage subsystem. Its storage sizing and configuration capabilities offer detailed best-practice storage volume and RAID recommendations to support database and content storage needs using HP direct-attach storage, HP StorageWorks MSA or EVA Storage SAN solutions.

Configure NLB as normal on a windows 2003/2008 box.

2010-10-04T14:26:00.004-04:00

Configure NLB as normal on a windows 2003/2008 box.

Add new server to the farm and select host site on this server

Go into the registry of the server HKLM\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14\WSS

For each server make sure the link is going to the server itself. This fixes your actual server link in the programs shortcuts on each server.

Then, go into Central Admin on either server and configure access mappings.
Drop down the application and click central admin. Make one of them the default and the other the Intranet.

So, you should have for instance: DEFAULT http://gigaportal:9111 and INTRANET http://gigaportal2:9111

SPS 2010 Developer Dashboard...helps in troubleshooting

2010-08-27T15:07:00.002-04:00

Stsadm –o setproperty –pn developer-dashboard –pv ondemand (or “on” or “off”)

This will put a small icon in the top right of your sharepoint page. Click it and it will display debugging info on your page all the way at the bottom. The cool thing is its activated by each person, by that if you click it, only you see the information.

Very useful!

Language Translator for SharePoint

2010-08-27T14:05:00.001-04:00

http://www.microsofttranslator.com/widget/

This thing is cool. Just add a content editor webpart. Paste the code in a .txt file and link the content editor to the .txt file in the sharepoint library.

really cool and a load of time savings!

Moving site collections to new databases SharePoint 2010

2010-08-26T14:21:00.002-04:00

On the SharePoint Server, open command prompt to hive.
Type Stsadm -o enumsites -url > .xml

I used this for example:
Stsadm -o enumsites -url http://sp-giga > c:\sites.xml

Edit the sites.xml file to remove all sites that you do NOT want to move to another content db.

Then once you have done that, save the file back to c:\sites.xml.
Type Stsadm -o mergecontentdbs -url -sourcedatabasename -destinationdatabasename -operation 3 -filename

For example:
Stsadm -o mergecontentdbs -url http://sp-giga -sourcedatabasename wss_content -destinationdatabasename wss_content_sc_IT -operation 3 -filename c:\sites.xml

Check to make sure the sites moved over in central admin, manage content databases

SharePoint 2010 fly-out menu NOPE not there!

2010-08-24T14:23:00.001-04:00

Flyout levels are still a problem for SharePoint, you will need to modify the v4.master page and change the string value DynamicDisplayLevels from “1” to “3”, and this will allow sub menus to fly out three levels. In order to do this, make sure you have the publishing feature on and the navigation is set to show sub-sites. In order to change this value, use SharePoint designer, open up the master page and click code view. Do a find for the string. Save it, publish it, approve it.

SharePoint 2010 .pdf's here we go again

2010-08-24T14:21:00.002-04:00

http://bloggingabout.net/blogs/harold/archive/2008/10/02/index-pdf-documents-on-sharepoint-using-adobe-pdf-ifilter-9.aspx

This post covers everything to a tee, and works perfectly. The only thing I have to add is this:

In the web browser, open Central Admin, under Application Management, click manage service applications.

Left side, click file types. Click new file type, put .pdf in there. Scroll down the list you should see the pdf icon there now and associated to adobe.

This actually worked better in 2010 then 2007!

SharePoint 2010 pre-req's location for download

2010-08-24T13:54:00.002-04:00

Here is the location of all those pesky pre-reqs you need prior to installing sharepoint. You ask why do this? Well, if you have a lab setup with NO internet connectivity it is a very useful thing to have them all on a usb stick!

http://download.microsoft.com/download/C/9/F/C9F6B386-824B-4F9E-BD5D-F95BB254EC61/Redist/amd64/Microsoft%20Sync%20Framework/Synchronization.msi
http://download.microsoft.com/download/c/c/4/cc4dcac6-ea60-4868-a8e0-62a8510aa747/MSChart.exe
http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe
http://download.microsoft.com/download/2/8/6/28686477-3242-4E96-9009-30B16BED89AF/Windows6.0-KB968930-x64.msu
http://download.microsoft.com/download/D/7/2/D72FD747-69B6-40B7-875B-C2B40A6B2BDD/Windows6.1-KB974405-x64.msu
http://download.microsoft.com/download/6/8/1/681F5144-4092-489B-87E4-63F05E95079C/Windows6.0-KB976394-x64.msu
http://download.microsoft.com/download/E/C/7/EC785FAB-DA49-4417-ACC3-A76D26440FC2/Windows6.1-KB976462-v2-x64.msu
http://download.microsoft.com/download/D/7/2/D72FD747-69B6-40B7-875B-C2B40A6B2BDD/Windows6.0-KB974405-x64.msu
http://download.microsoft.com/download/3/5/5/35522a0d-9743-4b8c-a5b3-f10529178b8a/sqlncli.msi
http://download.microsoft.com/download/b/9/a/b9a78047-d269-4a25-88a1-9c4321d90677/SQLSERVER2008_ASADOMD10.msi
http://download.microsoft.com/download/1/7/1/171CCDD6-420D-4635-867E-6799E99AB93F/ADONETDataServices_v15_CTP2_RuntimeOnly.exe
http://download.microsoft.com/download/B/8/6/B8617908-B777-4A86-A629-FFD1094990BD/iis7psprov_x64.msi
http://download.microsoft.com/download/1/0/F/10F1C44B-6607-41ED-9E82-DF7003BFBC40/1033/x64/rsSharePoint.msi
http://download.microsoft.com/download/8/D/F/8DFE3CE7-6424-4801-90C3-85879DE2B3DE/Platform/x64/SpeechPlatformRuntime.msi
http://download.microsoft.com/download/E/0/3/E033A120-73D0-4629-8AED-A1D728CB6E34/SR/MSSpeech_SR_en-US_TELE.msi

SQL server at (Blank) has an unsupported version 10.0.2531.0

2010-08-20T15:16:00.003-04:00

You update SQL 2008 to SP1 thinking ok I am ready......NO U R NOT! You will get the folowing error:

SQL server at [Your-DATABASE-SERVER] has an unsupported version 10.0.2531.0. Please refer to “http://go.microsoft.com/fwlink/?LinkId=165761” for information on the minimum required SQL Server versions and how to download them.

You might see threads here an there say that the minimum build number for SQL server is 10.0.2531.0. This is not very accurate as the minimum build for SPS 2010 for the SQL 2008 Enterprise Edition is the version number 10.0.2714.0 which is the cumulative update package 2. They are up to five now which I will post the link here: http://support.microsoft.com/kb/975977/en-us

If I had read the Pre-req from Microsoft for SharePoint 2010 it does state this.......But who reads! :)

SharePoint 2010 n SQL 2008 can't connect to DB

2010-08-20T12:31:00.003-04:00

Open the SQL Server Configuration Manager (Start > SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager
Navigate to the SQL Server Network Configuration > Protocols for MSSQLSERVER node in the tree view
Enable TCP/IP and Named Pipes (you’ll be warned that these changes will not apply until you the service is shut down)

That will allow you when installing SPS 2010 to connect to a SQL 2008 Server. This took 4 hours to finally figure out.

Infopath - no access to pull ad data?

2009-02-19T15:51:00.002-05:00

I was getting the following error during my first try:
The query cannot be run for the following DataObject: GetUserProfileByNameInfoPath cannot run the specified query.The SOAP response indicates that an error occurred on the server:
Server was unable to process request. ---> Attempted to perform an unauthorized operation.

Cause: I was calling the web service against the server root that I didn’t have access to. For example http://server/_vti_bin/userprofileservice.asmx but I didn’t have access to http://server

Solution: Call the web service against the site the InfoPath template lives in, which the current user has access to. For example http://server/sites/sitename/_vti_bin/userprofileservice.asmx

Infopath - pull into the form current user

2009-02-19T15:20:00.002-05:00

http://blogs.microsoft.co.il/blogs/itaysk/archive/2007/04/05/InfoPath-_2D00_-Get-the-current-user-without-writing-code.aspx

This worked like a charm, good find and great post.

Still need help and I hope all these posts help someone else like me who is in the process of living inside SharePoint :)

Spellcheck does not work

2009-02-18T15:02:00.002-05:00

Stumbled across this and found two options as a workaround for now.

Solution:

1) Give all necessary users the contribute permission level on the top site (“read” is not sufficient). Next, break the inheritance on all lists, libraries and subsites of the top site where you do not want those users to have contributor access.
Which users? You can use all authenticated users, but it is only those users that will be wanting to use the spell check for whom it’s necessary. So de facto that means only contributors or higher.

2) If you think the above solution is quite drastic and requires too much maintenance or could cause a security leak later, you can also

a. On the top site, create a new permission level, e.g. “spellcheck”. Assign only the following site permissions to the permission level:
- browse directories

- view pages

- use remote interfaces

- open

Any other will give more rights, any less will not solve the problem.

b. On the top site again, assign the new permission level to the necessary users. The effect will be that

i. they càn access the topsite but not view any content. They can use it to browse to their subsite

ii. they can use the spellcheck

http://social.technet.microsoft.com/forums/en-US/sharepointadmin/thread/1fd7350f-742d-4e32-8b57-3c32e5838d2a/

Populate InfoPath forms with AD Information - NO CODE

2009-02-18T11:22:00.001-05:00

http://kwizcom.blogspot.com/2007/11/importing-data-from-ad-to-infopath-2007.html

This is so easy, Kudos for the post Thank you....

Import AD accounts into InfoPath form...EASY!

2009-02-18T11:18:00.001-05:00

http://kwizcom.blogspot.com/2007/11/importing-data-from-ad-to-infopath-2007.html

This is a perfect way to not use code to obtain information from AD in an InfoPath form.

Kudos to this blog, and its so easy a caveman could do it!

Visio Stencils for Sharepoint Server

2008-09-25T10:59:00.001-04:00

Found this pretty cool site that has a very useful tool for visio.

http://blogs.msdn.com/roberdan/archive/2006/03/05/543967.aspx

Kudos

John

Alternate Access Mapping

2008-05-20T10:58:00.002-04:00

Okay, to do this, Central Administration, Alternate Access Mappings, right side....

Scenario----You want to make your sharepoint site open to the public from the internet, how do you do it?

Click edit public urls button
Alternate Access Mapping Collection drop down, drop down to your main portal site

In your default field type the internet url, such as http://sharepoint.mydomain.com

Add internal urls that match your host headers if you have any.

Add mysites.mydomain.com to a custom internal url.

That should do it.

Searching for people does not come back with results

2008-05-20T10:50:00.003-04:00

In search center you attempt to search for people and the results are blank.

In your ssp admin page, search settings, content sources. Edit the local sharepoint servers. Make sure sps3://mysites/ is there in the list and if you are using host headers make sure you have sps3://mysites.blankblank.com. Select full crawl and now the people should show up in your search.

Adding images to filetypes in SharePoint

2008-05-15T12:01:00.003-04:00

First, you need to obtain the images of the icons you want and make sure they are 16 x 16. Then, upload them to the sharepoint server, in this directory, C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\IMAGES

next, add them to the docicon.xml file located here, C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\XML .

do a iisreset and you are done.

these need to be scaled down.

Creating custom search scope for your search center

2008-05-15T10:44:00.002-04:00

have loads of sharepoint sites, dont want to do a generic search all sites from the search center? Then, create individual scopes to scale down the search, just like the search on the individual sites.

First thing to do, go into your ssp admin, search settings, create new scope (call it what your site is). Then click on the rule link to create the rule. I used the web option, then added the link to the site itself.

Once you have created all your scopes, and they r ready to be used, go into your actual site, under site settings, all settings. Under site collection administration, click search scopes. Create new display group.

Last step is to modify the web part so that the new display group is dispalyed. Site actions, edit page, modify web part. In the Search Box tool pane, click the plus sign (+) next to Miscellaneous. In the Scope Display Group text box, type the name of the display group that you want to use, and then click Apply. Click OK to close the tool pane.

On the Search Center page, click either Publish or Check In to Share Draft, depending on your site permissions and workflow.

Done

Windows XP issues a 'Delayed Write Failed' message when you perform file management tasks

2008-05-15T09:41:00.004-04:00

Turn off Enable write caching on the disk:

1. Use My Computer or Windows Explorer to right-click your disk and press Properties.

2. Select the Hardware tab.

3. Select the disk and press the Properties button.

4. Select the Policies tab.

5. Clear the Enable write caching on the disk check box.

6. Press OK and OK.

7. Repeat steps 3 through 6 for each disk.

Another possible cause of this is your sql server is out of disk space because the db files on stored on the c drive.

Last possible reason you need to bump the maximum file size in your web.config on your Sharepoint server under inetpub directory. maxRequestLength property

I have seen this issue before on windows xp.

Increase maximum file size for uploading in SharePoint

2008-05-15T09:38:00.000-04:00

Got to SharePoint Central Administration page
Under Application Management on Web Application General Settings in section "Maximum Upload Size" you can specify the file upload size you wish. By default it is 50mb.

Exclude sites for indexing, 'private sites'

2008-05-15T09:35:00.004-04:00

I was asked to create sites for the CEO and CIO but they were to be kept under wraps because of obvious reasons. The way to exclude sites from search/index is as follows.

Navigate your way to your ssp admin page, click on search settings under search. Click Crawl Rules. Select New Crawl Rule.

Put the path to the SharePoint site you wish to 'Exclude', then check off exclude all items in the path option. That's it. You can test it by using the test feature right above the 'new crawl rule' screen.

need to extract all documents from sharepoint libraries (updated)

2008-05-07T16:00:00.005-04:00

I have found a better way, and much easier way to accomplish this.

http://blog.krichie.com

the app is called spiefolder, and it can be batched to rip your whole sharepoint site down in minutes. Great tool and a must have.

Syntax

SYNTAX: SPIEFolder.exe []

where:

The Web URL where the list exists
Name of the list (Document Library)
File System directory
[] Import or export (defaults to export)

spiefolder http://krichiemoss "Shared Documents" c:\spiefolder\SeedFiles
spiefolder http://krichiemoss "Shared Documents" c:\spiefolder\SeedFiles import

How to combine document libraries and discussions

2008-05-07T10:29:00.002-04:00

SharePoint offers both document libraries and threaded discussions however they are located in different SharePoint lists. Some clients would like to have both located together to facilitate the process of discussing documents. Document Discussion allows you to have a threaded discussion around a specific document by combining the standard SharePoint document library with the standard SharePoint discussion on a single screen.

VISIT HEDGEHOG WEBPARTS GALLERY

Keeping track of the changes made to the intranet can be difficult

2008-05-07T10:26:00.000-04:00

From the guys over at Hedgehog www.hhogdev.com,

Keeping track of the changes made to the intranet can be difficult. In order to accomplish this, you need to subscribe to a list to know if the item(s) has changed. Subscribing to the many lists available or having knowledge of the lists can be difficult and time consuming. SiteTracker will display all the items that have change in the areas that you are interested in and allow you to mark them as read so that SiteTracker can start to watch for new changes.

SITE-TRACKER LINK

Email sharepoint documents as attachments

2008-05-07T10:07:00.002-04:00

This link works like a charm. To make it work, I added the sharepoint site to the local intranet zone, and adjusted the setting as outlined in the link. Perfect.

https://blogs.pointbridge.com/Blogs/ayyapusetty_raja/Pages/Post.aspx?_ID=11

Kudos

Import and Export lists or libraries

2008-04-23T13:15:00.004-04:00

Using stsadm tools from, http://stsadm.blogspot.com/2007/09/importexportcopy-lists.html

I created a batch file to help you do mass imports and exports...

echo on
set cmmand="C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\stsadm.exe"

%cmmand% -o gl-exportlist -url "http://yoursharepointserver/shared documents/forms/allitems.aspx" -filename "c:\export\shared" -includeusersecurity -versions 4 -nofilecompression

%cmmand% -o gl-importlist -url "http://yoursharepointserver/" -filename "c:\export\shared" -includeusersecurity -updateversions 2 -nofilecompression

Foldering in Document Libraries

2008-04-22T14:09:00.002-04:00

Why do people insist on using folders in SharePoint like they are using 'My Documents' on there computer? I have seen this more often than not, then the users complain on the folder hierachy, it's too much. Well, this is partly Microsoft's fault :( The best approach I have learned when it comes to document libraries is to refrain from using folders as much as possible. Instead, create 2 custom columns or three if you want. Name the first column 'Document Type', make it a choice, then populate the choice fields with possible categories you would use. Let's say we are creating a Helpdesk Support Doc Library. Make some choices, desktop, server, internet, applications etc...Each document that is upload to this list should have a doc type assocaited to it. You could then create another column, say department if you are in a big company. This way maybe different departments have different solutions to the same problem. When you are done, create views to filter the doc types or departments or any variation. Then, group them by doc type, this will create a folder like look. Hope this makes sense.

John

Guidelines for using folder structures in document libraries

2008-04-17T20:31:00.001-04:00

When using document libraries in SharePoint try to avoid creating nested folders. There are several reasons you do not want to create folders more than one level deep if you need to create them at all.

Security can't be applied to a folder in SharePoint
Currently, you can't add a folder by itself to a web page in a web part
Why would you continue nesting folders, you are then recreating your file server structure all over again.

Instead of creating folders in Document Libraries create a seperate document library, this allows users to consume the content most important to them and you have more control over security and other features such as custom views.

Index JPEG, GIF, TIFF, PNG, PS, EPS, PSD, AI and SVG files

2008-04-17T15:19:00.000-04:00

XMP IFilter lets you index and search JPEG, GIF, TIFF, PNG, PS, EPS, PSD, AI and SVG files. It extends Microsoft Index Server to extract metadata from Adobe XMP compatible files. XMP IFilter supports Dublin Core, Adobe Photoshop, XMP Basic and other XMP schemas. XMP IFilter is easily extensible and can support other XMP core schemas such as XMP Exif schema. If your metadata needs are not covered by the core schemas, you may add custom schemas as extensions. For better integration with Microsoft applications XMP IFilter also outputs common office document properties such as 'DocTitle', 'DocKeywords', 'DocCreatedTm' and others.

http://www.ifiltershop.com/xmpfilter.html

$300 for the server edition :)

View data easily from any sql server in sharepoint!

2008-04-17T15:17:00.000-04:00

Great product and CHEAP!

http://www.lightningtools.com/pages/lt%20data%20viewer%20web%20part.aspx

STSADM tools that are essential to SharePoint Administration

2008-04-17T13:52:00.000-04:00

http://stsadm.blogspot.com/2007/09/importexportcopy-lists.html

Increase the size limitation while you save site as template include content in MOSS 2007

2008-04-17T11:29:00.001-04:00

In MOSS 2007 you can change that limit using stsadm execute the following command :
stsadm -o setproperty -pn max-template-document-size -pv 40000000

40mb

MAXIMUM SETTING IS 500MB

Edit in Datasheet View in Office 2003 does not work

2008-04-17T09:13:00.000-04:00

Article Content
The papers that Microsoft at present (June 2004) have comparing what you get with Office 2000; Office XP and Office 2003 say that "Edit in Datasheet View" is a function of Office 2003.
It is but only if you are running Office 2003 Professional.
It is not included in either Office 2003 Standard or Office 2003 Small Business Edition.
Finally, a source that prefers to remain anonymous told me that it is possible to get Edit in Datasheet to work with Office 2003 Business Edition (*note that Monty extends this to Standard Edition*) by making a registry change. Here's his (or her!) text.

"It seems that if you set:

[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\11.0\Common\ProductVersion]"ProInfo"=dword:00000001

on a machine with Office SBE or Standard you don't even need to exit IE. The next time you click on "Edit in Datasheet", off you go."

Alex Angas points out that the KB article http://support.microsoft.com/kb/909506

Create color in your bland SharePoint Calendar

2008-04-17T04:50:00.000-04:00

Explained in this blog, you can add color to your SharePoint calendar so it mimics Outlook.

http://www.codeplex.com/planetwilson

http://planetwilson.blogspot.com/

DO NOT USE NETWORK SERVICE FOR ANY ACCOUNTS!

2008-04-17T04:46:00.000-04:00

This seems to be debated at length on the web but from my experience, when configuring services in your SharePoint farm, every time I would try and use the service account I ran into bizarre issues. You should use an actual account and preface the account name with the domain, such as
corp\johndoe. Doing this seems to resolve a lot of issues.

Useful SharePoint Designer Custom Workflow Activities

2008-04-17T04:42:00.000-04:00

This link will take you to codeplex where there are a handful of really useful already configured workflows for your SharePoint sites.

http://www.codeplex.com/SPDActivities

Project Description
This project takes aim at making it easier to create advanced workflows using Sharepoint Designer by providing a set of custom workflow activities.

Want to get involved in the project? Contact me

Check out my blog at http://unclepaul84.blogspot.com or my LinkedIn profile

Configure usage reporting

2008-04-17T04:36:00.000-04:00

Usage reporting is a service that enables site administrators, site collection administrators, and Shared Services Provider (SSP) administrators to monitor statistics about the use of their sites. Usage reporting also includes usage reporting for search queries that can be viewed by SSP administrators for search and site collection administrators.

After usage reporting is enabled, site administrators and site collection administrators can view site usage summary pages that have the following information for their sites and site collections:

Requests and queries in the last day and the last 30 days.

Average number of requests per day over the last 30 days.

A chart of requests per day over the last 30 days.

A list of the top page requests over the last 30 days.

A list of top users over the last 30 days.

A chart of top referring hosts over the last 30 days.

A chart of top referring pages over the last 30 days.

A list of top destination pages over the last 30 days.

Top queries for the last 30 days (if search usage reporting is enabled).

Search results top destination pages (if search usage reporting is enabled).

SSP administrators for the search service can view a search usage reports page that tracks the following information.

Number of queries per day over the previous 30 days.

Number of queries per month over the previous 12 months.

Top queries over the previous 30 days.

Top site collections originating queries over the previous 30 days.

Queries per search scope over the previous 30 days.

Site collection administrators for the SSP site can view a usage summary page that tracks the following information:

Total amount of storage used by the site collection.

Percent of storage space used by Web Discussions.

Maximum storage space allowed.

Number of users for all sites in the hierarchy.

Total hits and recent bandwidth usage across all sites.

Site collection administrators can also view a site usage report that includes monthly and daily page hit totals filtered by the following criteria:

Page

User

Operating system

Browser

Referrer URL

Enable usage logging for the farm

1.On the Central Administration home page, click Operations.
2.On the Operations page, in the Logging and Reporting section, click Usage analysis processing.
3.On the Usage Analysis Processing page, in the Logging Settings section, select Enable logging.
4.Type a log file location and number of log files to create.
5.In the Processing Settings section, select Enable usage analysis processing, and then select a time to run usage processing.
6.Click OK.

Enable usage reporting

1.On the SSP home page, in the Office SharePoint Usage Reporting section, click Usage reporting.
2.On the Configure Advanced Usage Analysis Processing page, in the Processing Settings section, click Enable advanced usage analysis processing.
3.In the Search Query Logging section, select Enable search query logging.
4.Click OK.

Save site as a template disappeared

2008-04-17T04:21:00.000-04:00

So, you have created some sites in SharePoint right. Then, you decided to go into site features and activate everything under the sun. You then go back to a site you want to use as a template, but that option is no longer there. Well, if you selected server side publishing as a feature and activated it, this removes the save site as a template option in site settings. FYI. There is a way to make it work, you could append your http link with _layouts/savetmpl.aspx that would give you the screen to save as a site template.

John

Add column numbering in SharePoint Data List View

2008-04-16T22:06:00.000-04:00

When you insert a Data View Web Part, you can add a column to the table and have it display a running count of records in your XSLT Data View. To add a column to your XSLT Data View, Follow these steps:
1. Put the insertion point inside any table cell that contains XML data.
2. On the Table menu, point to Insert, and then click Rows or Columns.
3. Click Columns, and then click OK.
4. Put the insertion point inside one of the new table cells that you created in the same row as the data that you want to work with.

Do not use the header row of the table for this purpose.
5. Click the down arrow next to the button on the Quick Tag Selector tool bar.
6. Click Insert HTML.
7. Replace "<>" with .
8. Click the green checkmark to approve the change.
You will now have a value in each row that indicates the number of records in the Data View.

Embed Visio Diagrams inside SharePoint web part page

2008-04-16T22:01:00.000-04:00

http://www.gigabytz.net/embedvisio.pdf

Index PDFs in SharePoint - Not by Default!

2008-04-16T21:56:00.000-04:00

This link describes exactly how to do it. Piece of cake.

http://support.microsoft.com/kb/832809

Maximum File Size for Crawling - DID YOU KNOW?

2008-04-16T21:53:00.000-04:00

Maximum File Size for Crawling

By default, Search Services can crawl and filter a file with a size of up to 16 megabytes (MB). It will always crawl the first 16MB of a file. After this limit is reached, SharePoint Portal Server enters a warning in the gatherer log “The file reached the maximum download limit. Check that the full text of the document can be meaningfully crawled.”

To increase the limit of 16 MB, you must add in the registry new entry MaxDownloadSize. To do this, follow these steps:

1. Start Registry Editor (Regedit.exe).

2. Locate the following key in the registry:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0 or whatever it is on your server\Search\Global\Gathering Manager

3. Open Edit - New - DWORD Value. Name it MaxDownloadSize.

4. Double-click, change the value to Decimal, and type the maximum size (in MB) for files that the gatherer downloads.

5. Restart the server.

6. Start Full Crawl.

NOTE: Increasing the file size may cause a timeout exception because the crawler can timeout if the file takes too long to crawl/index (because of its size). To increase timeout value, follow these steps:

1. In Central Administration, on the Application Management tab, in the Search section, click Manage search service.

2. On the Manage Search Service page, in the Farm-Level Search Settings section, click Farm-level search settings.

3. In the Timeout Settings section change Connection and Request acknowledgement time.

Installing SharePoint 2007 - the quick of it :)

2008-04-16T21:42:00.000-04:00

I have read a lot of posts on the web about this subject, most of them for some reason skip steps that would of really helped me out greatly when i started working with SharePoint.

Here is a quick list of things I have learned along the way.

When you have finished the actual installation and are ready to begin configuring, try this:

Create three web applications

Call the first one Intranet and use port 80, for the content db name, append it so that it looks like Wss_Content_Intranet or something of the likes. Makes it much easier to find in SQL and you know exactly what DB does what.
Second one, call MySites and again use port 80, also append the db
Third one, call SSPAdmin, you can use port 80 or whatever port you like, and append the db again.

Create Site Collection next

When you do this, select the appropriate web application for sspadmin and mysites since you created them already.

Create SSP

These three steps will at least get you up and running pretty quick.

Next thing you can do, go inside the SSP admin site and configure the crawl rules and import rules. While you are there, go to personalization links and add a link to your intranet page, this way when folks are in mysites, they can get back to the main portal. Configure usage reports because you are going to want to see who is actually using this beast of a product. I will post about these steps individually as I go on.

SharePoint goodies like 'Print List'

2008-04-16T21:39:00.000-04:00

This is a collection pack on codeplex. Use my batch file and your off and working in no time.

The Print list is cool, you can print any list you have in sharepoint
The log viewer, also a cool feature.

http://www.codeplex.com/features/Release/ProjectReleases.aspx?ReleaseId=2502

SharePoint Sushi

2008-04-16T21:35:00.000-04:00

Another Great Tool from CodePlex!

http://www.codeplex.com/sushi

SUSHI was built and is maintained by Joseph Fluckiger, Senior SharePoint Consultant at Catapult Systems. Read Joseph's blog.

SharePoint Content Deployment Wizard

2008-04-16T21:29:00.000-04:00

OMG, this tool rocks. If you have had the request to say take all content from one sharepoint site and populate another totally different sharepoint site, then this tool is for you. I have used it at length and so far, this thing is such a time saver, KUDO's to Chris O'Brien.

http://www.sharepointnutsandbolts.com/2007/12/introducing-sharepoint-content.html

you can get the tool here http://www.codeplex.com/SPDeploymentWizard

Creating views in SharePoint

2008-04-16T21:26:00.000-04:00

http://www.gigabytz.net/creatingviewsinsharepoint.swf

SharePoint Free Application Templates and batch file

2008-04-16T21:20:00.000-04:00

http://technet.microsoft.com/en-us/windowsserver/sharepoint/bb407286.aspx
This is the link to Microsoft's 'Fab40'

I created a batch file to make this process much easier. create a bat file name it whatever, and follow along with the guidelines below.

echo on

set cmmand="C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN\stsadm.exe"

%cmmand% -o addsolution -filename ApplicationTemplateCore.wsp
%cmmand% -o deploysolution -name ApplicationTemplateCore.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename BudgetingTrackingMultipleProjects.wsp
%cmmand% -o deploysolution -name BudgetingTrackingMultipleProjects.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename BudgetingTrackingMultipleProjects.wsp
%cmmand% -o deploysolution -name BudgetingTrackingMultipleProjects.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename BugDatabase.wsp
%cmmand% -o deploysolution -name BugDatabase.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename CallCenter.wsp
%cmmand% -o deploysolution -name CallCenter.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename ChangeRequest.wsp
%cmmand% -o deploysolution -name ChangeRequest.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename ComplianceProcessSupport.wsp
%cmmand% -o deploysolution -name ComplianceProcessSupport.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename ContactsManagement.wsp
%cmmand% -o deploysolution -name ContactsManagement.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename DocumentLibraryReview.wsp
%cmmand% -o deploysolution -name DocumentLibraryReview.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename EventPlanning.wsp
%cmmand% -o deploysolution -name EventPlanning.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename ExpenseReimbursementApproval.wsp
%cmmand% -o deploysolution -name ExpenseReimbursementApproval.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename HelpDesk.wsp
%cmmand% -o deploysolution -name HelpDesk.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename InventoryTracking.wsp
%cmmand% -o deploysolution -name InventoryTracking.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename ITTeamWorkspace.wsp
%cmmand% -o deploysolution -name ITTeamWorkspace.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename JobRequisition.wsp
%cmmand% -o deploysolution -name JobRequisition.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename KnowledgeBase.wsp
%cmmand% -o deploysolution -name KnowledgeBase.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename LendingLibrary.wsp
%cmmand% -o deploysolution -name LendingLibrary.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename PhysicalAssetTracking.wsp
%cmmand% -o deploysolution -name PhysicalAssetTracking.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename ProjectTrackingWorkspace.wsp
%cmmand% -o deploysolution -name ProjectTrackingWorkspace.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename RoomEquipmentReservations.wsp
%cmmand% -o deploysolution -name RoomEquipmentReservations.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

%cmmand% -o addsolution -filename SalesLeadPipeline.wsp
%cmmand% -o deploysolution -name SalesLeadPipeline.wsp -allowgacdeployment -force -local
%cmmand% -o copyappbincontent

Add a Print Button to your SharePoint page!

2008-04-16T21:11:00.000-04:00

This is cool for those SharePoint Calendars!

How to do it,

In your SharePoint site, click on a calendar to display the calendar in calendar view. Edit page using modify wep part. You are going to add a web part above the calendar, pick content editor webpart. It will ask you to open tool pane, click that. On the right side, click source, then paste in the following source. Now the only tricky part to this is to find out what webpart you want to print. To do this, just view your site in regular view, right click, view source, and look for this 'WebPartWPQ3' you need to know the number of the webpart you want to print. once you have this, then add that number to the below code. You can change the title by changing the blue font below. http://www.imakenews.com/mernstmann/e_article000435389.cfm

John

Setting the SharePoint 2007 Navigation Flyout Level

2008-04-16T21:05:00.000-04:00

Setting the SharePoint 2007 Navigation Flyout Level One of the biggest improvements with SharePoint 2007 has been navigation. The breadcrumbs help and the tabs make a lot of sense. One of the nice features of the tabs is that you can have an automatic flyout menu for subsites. Let's say you have a top level 'Clients' tab with a subsite per client. The navigation will allow you to hover over the 'Clients' tab and see a flyout menu with links to each client site (automatically). Very nice!

Let's say you have Project sites per client. When you hover over your Clients tab, you don't get an automatic second level for project sites. Why? The default setting is set to only show one level for the flyout. How do you change it? Look for the 'MaximumDynamicDisplayLevels' property in the default.master file. It is set to '1'. Change it to '2' and you have two levels of flyout navigation from your top site. Done. http://blogs.officezealot.com/mauro/archive/2007/05/30/20395.aspx

Now there is one important piece for amateurs like me, how to do this? Well, open SharePoint Designer, open you main site, then navigate to _catalogs and look for master, then default.master. Just right click the default.master file and open as TEXT! , hit the control F, and find the 'MaximumDynamicDisplayLevels', change it and viola............but NOT. One very important thing you need to do to finish ip is check the default.master file back in, otherwise, only you will be able to see the flyout menus.

John
www.gigabytz.net

I wanted to post all i have found out and know about Sharepoint

2008-04-16T21:00:00.000-04:00

First things first, I have been in Technology for quite some time. After being introduced to SharePoint, I was hooked pretty quick.

Now, let me start to dump my knowledge in hopes of helping other guys along the way.

Most of the information I have found on the web in various places, I just wanted to have a central site for myself where i can go to see all the mods that i typically do for sharepoint installs.

John www.gigabytz.net