After upgrading some workstations to Windows 7 / 64b, users started having problems while saving big Excels. Sometimes when they open up a big Excel they get an empty error dialog window.

After editing and trying to save the document they get the following of 2 errors, they change from time to time, but most of the time it is the “File is checked out or locked for editing by someone else” error.

I noticed the error only appearing with big Excel documents so after some trial and error I found out the erros started appearing when the file was > 50.000.000 bytes. I knew the default file upload size in SharePoint is 50 MB, but this is quite easy to change. Go to Central Administration -> Web Application General Settings. Select the Web Application you want to change, and you will see a textbox to specify the maximum upload size. Problem solved? Not. I should have known because users on WinXP systems weren’t experiencing the same problems, so it had to be something client side.

After some googling I found the following Microsoft KB: You receive a folder copy error message when you try to download a file that is larger than 50000000 bytes from a Web folder. It was a long shot because there was nothing about SharePoint in the KB, but I tried. And, to my surprise, after changing the registry setting, all worked fine! No more errors!

No related posts.

This release includes a “go-live” license for users who want to use VS in a production environment.

Remark: Before installing the Release Candidate you will have to uninstall any previously installed Visual Studio 2010 Beta 2 versions.

Related posts:

1. SharePoint 2010 Beta 2 and Silverlight 4 Beta available
2. CTP of Visual Studio 2008 extensions for WSS v1.3
3. Visual Studio 2008 extensions for WSS v1.2

Related posts:

1. SharePoint 2010 Beta 2 and Silverlight 4 Beta available

Related posts:

1. Microsoft Expands List of Formats Supported in Microsoft Office
2. Link To a Document In Another Document Library
3. Bulk editing metadata in a Sharepoint Picture Library

http://blogs.msdn.com/sharepoint/archive/2009/11/18/sharepoint-2010-public-beta-is-now-available-for-download.aspx

At the PDC in n Los Angeles, Scott Guthrie announced the availability of Silverlight 4 beta:

http://team.silverlight.net/announcement/silverlight-4-beta-is-now-available/

http://www.silverlight.net/getstarted/silverlight-4-beta/

Related posts:

1. Silverlight 3 Released
2. SharePoint Connections 2010 Amsterdam Videos
3. VS2010 / .NET Framework 4 Release Candidate now available!

In a Document library you can do this by using the “Edit in datasheet” option, in the datasheet  you can bulk edit the metadata, but for some reason the Picture Library doesn’t have that option.

But, if you have Access 2007 installed on your pc,  you can create an Access View which allows you to use Access 2007 to populate the metadata.

1. Go to your Picture Library and Create a new view

2. Choose Access View

3. Save the file somewhere

4. Datasheet is the best way to edit bulk data

5. Edit your metadata, click in another record to save the changes

Related posts:

1. Metadata not saving when Office Document is password protected
2. Link To a Document In Another Document Library
3. Customize the People Search Results – Part 1

You can read more about Silverlight 3 in the following blog posts:

• What’s New in Silverlight 3? (silverlight.net)
• Silverlight 3 Released (Scott Guthrie)
• Silverlight 3 Released! What is new/changed? (Tim Heuer)
• Biggest Suprises in Silverlight 3 (Shawn Wildermuth)
• Silverlight 3 Released – Exciting Stuff Here! (Dan Wahlin)
• Silverlight 3 and Expression Studio 3 (RC) Released! (Jeff Barnes)
• Welcoming Silverlight 3 RTW (Pete Brown)
• See the Light: Silverlight 3 & Expression 3 Launch (The Silverlight Blog)
• Get Silverlight 3 and Microsoft Expression 3 Now (The Silverlight Blog)

Related posts:

1. SharePoint 2010 Beta 2 and Silverlight 4 Beta available

• If you need an extranet, VPN could be an option.
• If you have 2 Web Front End servers, one for Intranet and one for Internet, keep both web applications on both servers, it’s easier to update.
• Web Application Best Practices:
  • Don’t allow servers to access the internet.
  • 64 bit hardware.
  • Use Network Intrusion Detection (Host based detection causes extra server load).
  • Consider Transport Layer Security(SSL, IPSEC) between servers carefully, it’s complex.
• SSL Best Practices:
  • Offload from SharePoint.
  • Sticky session on NLB (see white-paper on combined knowledge site).
  • Use port 443.
  • Use A Records in DNS.
  • Use fixed IP Addresses.
  • Use SSL for Central Administration (password sent over the network).
  • ForeFront Anti-Virus for SharePoint.

SharePoint as an SOA platform. (Brad Smith)

• Service boundaries are explicit.
• Services share schema and contract not class.
• Service compatibility is determined based on policy.
• Services are autonomous.
• SOA is a system design strategy, not a technology.
• Use it when there are environmental boundaries.
• When?
  • Geographical distributed locations.
  • Multiple pre-existing applications or data stores.
  • Continuity of operations.
  • Maintenance cost reduction.
  • Interoperability.
• Why not?
  • SOA strategies can be expensive.
  • You need architects.
  • Lots of code.
  • Do you need distributed computing?
  • Other option is Enterprise Application Integration.
• SharePoint SOA:
  • Federated search, records center.
• What is need to make the SharePoint platform an SOA?
  • Node Topology Service.
  • Service Discovery Service (UDDI).
  • Content Definition Service (format).

Deploying SharePoint sites through multiple environments. (Chris O’Brien)

• http://sharepointnutsandbolts.com
• A site is a mix of .NET and SharePoint artifacts:
  • Files / assemblies.
  • SharePoint schema (content type, site columns, …).
  • Content.
  • Configuration.
• Goals:
  • Repeatable (should be able to rebuild from scratch).
  • Predictable.
  • Acceptable packaging efforts – automation scale.
  • Documentation is critical.
• Features:
  • Pro:
    • Classic approach.
    • Fairly rich framework.
    • Provision files as ‘uncustomized’.
  • Con:
    • Deals with schema only, not data.
    • Steep learning curve.
    • Code often required for updates (featureActivationReceiver).
• STSADM export:
  • Pro:
    • Very simple to use.
    • Site collection/web schema and data.
    • Can be scripted.
  • Con:
    • Doesn’t allow setting of certain switches.
    • All objects given new ID’s (listview web part and infopath problems).
    • Bi-directional can cause problems.
    • Is not a backup/restore solution (alert, audit trail, log, recycle bin, workflow tasks/state are not copied).
• Content deployment wizard:
  • Pro:
    • Same as STSADM + more switches e.g. retain ID’s.
  • Con:
    • Files are deployed as customized.
    • Bi-directional can cause problems.
    • Need to understand capabilities.
• Kivati Studio
  • Pro:
    • Package updates into .exe.
    • Nice structure for e.g. content type updates.
    • Workflow designer type op editor, allowing reuse.
    • Can write custom code if no built-in task is available.
  • Con:
    • Fairly steep learning curve.
    • Potential lock-in.
    • Doesn’t move data.
• Choosing a method:
  • Features are generally the best option.
  • Type of solution:
    • Single site = wizard.
    • Multiple sites = feature.
  • Packaging experience, timeframe.
  • Frequency/type of update, more code for updates.
  • If multiple developers consider team development model:
    • Isolated developers.
    • Development farm.
• Best Practice:
  • Always use .WSP.
  • Document how to deploy/rebuild site.
  • Identify how updates will be rolled out.
• Avoid:
  • STSADM backup/restore.
  • Use ‘save as site template’ to move a site.
  • Modify live features or site definition filtes.

High performance programming (Eric Shupps)

• All list data is stored in a single table for each content database.
• Looping operations in the Object Model are resource intensive.
• Use CAML queries for targeted item selection.
• Maintain SQL indexes for optimal query execution.
• Manipulate item data using in memory objects.
• NO 2000 item limit, only for displaying.
• Beware of caching in ViewState, use PageCache.
• Use SPListItemCollection instead of iterating.
• Use CAML when there are more selection criteria.
• Use Search API to query data.

Related posts:

1. SharePoint Best Practices Conference Notes (London 2009) – Day 1
2. SharePoint Best Practices Conference Notes (London 2009) – Day 2

Related posts:

1. System Center Data Protection Manager – Service Pack 1
2. Microsoft Expands List of Formats Supported in Microsoft Office
3. Microsoft SharePoint Designer 2007 is now FREE

SPOShowBirthdayWebPart is a webpart that will display all users whose birthday is coming up in x days.

Changed in V2.0:

• Replaced username by Firstname and Lastname.
• Made Name column link to the user profile page

Download SPOShowBirthdayWebPart v2.0.

Prerequisites
This webpart uses the RunWithElevatedPrivileges function to impersonate the administrator in SharePoint Server 2007. After you do this, you may receive the following error message when you try to enumerate all user profiles:

“Access Denied. Only an administrator may enumerate through all user profiles.”

Microsoft released a hotfix package for this bug “SharePoint Server 2007 hotfix package: May 8, 2008″,
http://support.microsoft.com/kb/952294

Related posts:

1. Web Part to show upcomming birthdays in SharePoint
2. Expand and Collapse All Feature v1.0 Released

• http://sharepointcowboy.com
• Themes – SharePoint Designer – Site Definitions.
• Site Definitions:
  • Pro
    • Packaged customization.
    • Easy migration.
    • Best performance.
    • Complex functionality.
  • Con
    • Difficult to create.
    • Programming.
    • Only for new sites.
• upgradeSolution – STSADM

Search can be your best friend. (Agnes Molnar)

• Information Workers search for about 8h/week, 3.5h/week they don’t find what they are looking for.
• Use keywords, best bets (site collection admin only).
• Different Search result web parts depending on searched keywords.
• Google cannot be federated because it doesn’t return RSS or ATOM.
• Use scopes.
• Use Master Site Directory.
• Train users.
• Use content types.
• Add SharePoint search to IE (Harrison has a post on how to use this with a Group Policy).

Creating Custom Field Types. (Todd Bleeker)

• Custom data validation.
• Custom field rendering.
• Custom behavior logic.
• Limitations.
  • Not in Document Information Panel.
  • Not in datasheet.
  • Farm level.
  • Complex coding.
• Coding:
  • Required.
    • Field Definition (XML).
    • Field Class.
  • Optional.
    • Control Class (custom presentation).
    • Value Class (special data structure).
  • User Controls.
    • Schema User Control (custom properties).
    • Field User Control (for new / edit).
    • Rendering Template (ASCX).
• Field Definitions – fldtypes_Foo.xml
  • .\12\template\xml\fldtypes_*.xml.
• Field Class – FooField.cs
  • .\12\templates\fldtypes.xml.
  • Inherits the field type that comes closest.
• Control Class – FooFieldControl.cs
  • Renders the field types properties.
  • If not used, it uses the default presentation.
• Value Class – FooFieldValue.cs
  • Maintain multiple values in a single field.
  • Custom data validation (getValidatedString).
  • Use SPFieldValidationException for a user friendly error message.
• User controls – FooFieldEditControl.cs – FooFieldPropertyControls.cs
• Start with a class library
• Visual Studio: add user control – use GUID hack (slides)
• Testing:
  • Spaces in column name.
  • 2 Columns in 1 list.
  • Export to Excel.
  • Document Information Panel.
  • Edit custom properties.
  • Required fields.
  • Empty/large values

Building high performance solutions for Publishing Sites. (Andrew Connel)

• Group anonymous and secured resources for more effective caching.
• Minimize number of secured items.
• Keep files uncustomized, custom pages are subject to the safe mode parser.
• Minimize page payload:
  • CSS based design (no more tables).
  • ISS HTTP Compression (watch out for increase in server load).
  • Lazy load core.js (read MSKB #933823).
  • Clustering of images, clipping the images (http://www.getrpo.com/).
  • IIS 7 > IIS6
  • SharePoint caching per site (output cache).
  • Object cache.
  • Disk based cache.

Dev Expert Panel.

• Don’t use web gardens with SharePoint.
• Using State Workflow when you need to go back up in your WorkFlow.
• When you need to update a used WorkFlow, it’s better to create a new one and use it from then on, you don’t want to update an existing WorkFlow.

Related posts:

1. SharePoint Best Practices Conference Notes (London 2009) – Day 3
2. SharePoint Best Practices Conference Notes (London 2009) – Day 1

10 Steps to a successful SharePoint deployment

• SharePoint = a killer bunny, looks cute, but it can bite you in the…
• Governance: consistent management, cohesive policies, processes and decision-rights for a given area of responsibility.
• Executive sponsor with vision and budget.
• SharePoint team: Site Collection admin, SP Designer or Business analyst, Content Administrator, SP Infrastructure admin, SP Developer [Admin <> Devs].

Best Practices for Developing Web Parts. (Todd Bleeker)

• Start with a well named VS.NET library, e.g. companyProject.content.purpose (content = e.g. webpart, workflow), should be unique on the internet.
• Start with a class library.
• Use common webpart suffixes e.g. FooPart.cs.
• .NET webpart vs. SharePoint webpart – .NET webpart can work in all environments not only in SharePoint.
• Never use Render, Rendercontrol, rarely use RenderContent
• Sign or strong name the assembly.
  • GAC = full trust (bad practice and needs IISRESET).
  • BIN = wss_minimal trust and no recycle of the application pools.
• Get public key options (slides).
• Signing Best Practice: AllowPartiallyTrustedCallers() in assembly.cs.
• Use the 12 hive structure in your project to organize your project.
• Use MakeCab.exe, command line tool to generate CAB/WSP.
• Post build vs. Target, use Target.
• Use XCopy commands to install (slides).
• isCallBackEventHandler(), like AJAX.
• Move the UI to a User control – Page.LoadControl.
• User control  vs. Server Control, use User Control.
• Code Access Security (CAS).
• EnsureChildControls().

Making the most of the Out of the box Web Parts. (Brett Lonsdale)

• Excel Web Access (EE).
• Filter Web Parts (EE).
  • Current User Filter.
  • BDC filter – web service.
  • Choice filter.
  • Date filter.
  • Filter Actions.
  • Page field filter.
  • Query string filter.
  • SharePoint list filter.
  • SQL Server Analysis Services filter.
  • Text Filter.
• Content Query Web Part.
• Summery Link Web Part.
• Table of Contents Web Part.
• Outlook Web Access Web Part.
• BDC Web Parts.
• Data View Web Part, db connection, web service.

Difference between Field Controls and Web Parts in publishing sites. (Andrew Connel)

• Field Controls.
  • Window to content.
  • Content in SPListItems.
  • Content Versioning.
  • Structure of page is important.
  • Page History is important.
  • Consistent branding.
• Web Parts.
  • Content is stored in Web Part in the ASP.NET personalization store.
  • Content in the context of the current page.
  • To provide functionality.
  • History and structure are not important.
• Don’t use Content Editor Web Part on publishing sites.
  • No history.
  • No centralized control.
  • Links are absolute, not relative
  • Content owners can use JavaScript, CSS, HTML.
  • Block usage:
    • <SafeControl Type=”ContentEditorWebPart” Safe=”False” />
• http://blogs.msdn.com/ecm
• http://code.msdn.microsoft.com/ProhibitCEWP

Capacity planning and Performance tuning. (Mike Watson)

• Capacity planning is an educated decision.
• Goals are:
  • Performance.
  • Scalability and affordability.
  • Maintainability.
  • Simplicity.
• Monitor growth of system (trending).
• Cheap, fast, good – choose 2.
• Concurrency increase – plan for it through capacity planning.
• Max 5 web front end servers / SQL instance.
• Use 64bit – 32bit is dead.
  • Sequence of upgrading: SQL Server – index – excel – search – WFE.
• Virtualization:
  • Disks:
    • Use pass through or fixed VHD.
    • No dynamic disks.
  • Networking:
    • Use multiple NIC’s and NIC teaming on the hosts.
• 1.2 – 1.5 times the file system is needed on the SQL server.
• 30% – 50% of the size of all content is needed on the index server.
• Size of index is needed for the Query Server.
• Performance:
  • Mirorring 27% performance loss
  • DAS < 1s., SAN > 5s.
• Performance in Visual Studio Test Suite (Trial), Web Test Edition
  • Use 10% of total users for normal tests, use 50% of users for peak tests.
• SPDataPop, Data Population Tool

Related posts:

1. SharePoint Best Practices Conference Notes (London 2009) – Day 2
2. SharePoint Best Practices Conference Notes (London 2009) – Day 3
3. Dropdown to change the View disappeared

Today Microsoft makes this official with an update on their SharePoint Designer page.

For end users, Microsoft SharePoint Designer opens the door to more advanced customizations, but take care because you can ruin your site in a matter of minutes with SPD.

Microsoft also wrote an open letter to their customers about the change in licensing. You can find some quick answers on common questions about the change.

If you have already made an investment in Office SharePoint Designer and Software Assurance take a look at this blog post.

Related posts:

1. Microsoft Expands List of Formats Supported in Microsoft Office
2. Service Pack 2 for Office SharePoint Server 2007 and Windows SharePoint Services 3.0
3. Microsoft System Center Data Protection Manager

First I will show you the code snippet to create the Alert, after that I will explain the code step by step.

SPAlert newAlert = user.Alerts.Add();
newAlert.Title = list.Title;
newAlert.AlertType = SPAlertType.List;
newAlert.List = list;
//newAlert.EventType = SPEventType.Add; <= doesn’t work
//use the following codes to set the "eventtypeindex" property
//all =0, added = 1, modify = 2, deleted = 3, web discussions = 4
newAlert.Properties["eventtypeindex"] = "1";
newAlert.AlertFrequency = SPAlertFrequency.Immediate;
//passing false to Update method will refrain from sending the alert confirmation mail
newAlert.Update(false);

Step by step:

The first thing to create the alert is to use the Add method of the Alerts property of the SPUser class, in our example “user” is an instance of a SPUser class.

SPUser user = mySite.Users["domain\user"];
SPAlert newAlert = user.Alerts.Add();

If you want to set an alert for a list, you have to set the AlertType property to SPAlertType.List and set the List property to an instance of the SPList class.

newAlert.AlertType = SPAlertType.List;
newAlert.List = list;

If you want to set an alert for a list item, you have to set the AlertType property to SPAlertType.Item and set the Item property to an instance of the SPListItem class.

newAlert.AlertType = SPAlertType.Item;
newAlert.Item = item;

The next property you want to set is the EventType property, this didn’t work out the way I wanted it too. I was having a problem with setting the EventType on an SPAlert to SPEventType.Add.

My code wouldn’t throw an error but neither would it set the EventType to SPEventType.Add, in stead it would stay at SPEventType.All.

I fixed this by using the following codes to set the “eventtypeindex” property of the SPAlert:

• all = 0
• added = 1
• modify = 2
• deleted = 3
• web discussions = 4

//newAlert.EventType = SPEventType.Add;
newAlert.Properties["eventtypeindex"] = "1";

The last properties to set is the AlertFrequency.

newAlert.AlertFrequency = SPAlertFrequency.Immediate;

If you AlertFrequency is different than Immediate you will have to set the AlertTime property, the AlertTime property defines the next time the alert will be sent.

newAlert.AlertFrequency = SPAlertFrequency.Daily;
newAlert.AlertTime = new DateTime(DateTime.Today.Year, DateTime.Today.Month,
 DateTime.Today.Day, 8, 0, 0);

Last but not least you will have to call the Update method of the instance of SPAlert. You can pass a bool parameter which tells the update if it needs to send an alert confirmation mail or not.

newAlert.Update(false);

No related posts.

Following are a few things talked about on the site:

• Team Development
• Source Code Control
• Automated Builds
• Continuous Integration
• Build Testing
• Unit Testing and Test Driven Development
• Solution Versioning

Application Lifecycle Management is the marriage of business management to software engineering made possible by tools that facilitate and integrate requirements management, architecture, coding, testing, tracking, and release management.

Related posts:

1. Microsoft System Center Data Protection Manager

Paul Grenier of EndUserSharePoint.com has written a jQuery script that allows a user to expand all grouped by instances with one click, as a response to a question I asked on the Stump The Panel forum. I loved the script so much I decided to package it for easier use and distribution and put it on my SharePointology project on Codeplex.com.

It is a feature called SPOCollapseAndExpandAll, it is a jQuery feature that adds a + and – to the menu bar of the document/list libraries to Expand/Collapse all grouped by’s with one click. days.

Before expanding:

After expanding:

Download SPOExpandAndCollapseAll v1.0.

Prerequisites

This webpart needs jQuery to be added to your SharePoint pages.

No related posts.

It covers:

• Page Navigation
• Page Branding
• Web Services
• Custom Content Types
• User Management

Microsoft Ramp Up is a completely free, online, community-based program that only requires a Live ID to sign up and dig in. It connects you with other professionals while you’re building your skills.

On Ramp Up you can review the content and advance through the learning track at your own pace. At the end of the each level, you take an assessment to unlock the next level. Once you’ve completed the full learning track, you will have gained new skills integral to a successful developer.

Other tracks you can dig into are:

• SharePoint for Developers – Part I
• Visual Studio 2002/2003 Developer
• Visual Basic 6.0 Developer
• Java Developer
• Aspiring Developer
• Visual Studio 2008 Track

Related posts:

1. Online SharePoint 2007 Development Training
2. SharePoint Developer introduction for .NET developers
3. Visual Studio 2008 extensions for WSS v1.2

It is a project that aims at giving SharePoint users an even more user-friendly experience by providing a useful collection of SharePoint extensions and SharePoint developers some examples on how stuff is done.

My first contribution to this project will be a webpart called SPOShowBirthdayWebPart, it is a webpart that will display all users whose birthday is coming up in x days.

Download SPOShowBirthdayWebPart v1.0.

Prerequisites
This webpart uses the RunWithElevatedPrivileges function to impersonate the administrator in SharePoint Server 2007. After you do this, you may receive the following error message when you try to enumerate all user profiles:

“Access Denied. Only an administrator may enumerate through all user profiles.”

Microsoft released a hotfix package for this bug “SharePoint Server 2007 hotfix package: May 8, 2008″,
http://support.microsoft.com/kb/952294

Related posts:

1. Web Part to show upcomming birthdays in SharePoint V2.0
2. Expand and Collapse All Feature v1.0 Released

http://feeds2.feedburner.com/sharepointology

No related posts.

Quoted from Jason’s article How to make a SharePoint list look the way you want at Get the Point

Lookups are one of the more complicated aspects of list making, but can be really useful if you have a process which requires items of different types to be linked to each other. Let’s take this example: you have a list of employees and a list of possible interests. You want to store other information about the employees and about their interests, but you want to link them together.

• One of the reasons we use Lookup columns in our SharePoint site is because it’s easy to give permissions to a user to update the list where a Lookup column get’s it’s data from, giving them the opportunity to add lines to the selection box.

• Another reason is that the chosen value stays linked to the List where the Lookup column get’s it’s data from, for example, if you change the description of a certain item in the List all references to this value get changed too, this is not the case with a Choice field.

The problems I’m experiencing:

• Let’s say you use one of your Lookup columns in a Content Type and you want the user to have the ability to select a value in a Word 2007 document linked to that Content Type. You would think that adding the Lookup column with a QuickPart to your template (linked to the Content Type) would do the trick. Well it doesn’t … it only seems to display the ID of the selected record in stead of the actual values (Title column) in the documents created from the template?

• You can’t use a the “Contains” or “Begins with” filter on a Lookup column while creating a View. “Is equal to”, “Is not equal to”, … are working though. If you try to pick “Contains” you get a “The filter type you selected cannot be used with this type of column.” error.

Related posts:

1. SharePoint Best Practices Conference Notes (London 2009) – Day 1
2. SharePoint Best Practices Conference Notes (London 2009) – Day 2