Microsoft Office SharePoint Server (MOSS) 2007
We have two events happening in March that you should be aware of if you are in the Oklahoma City metro area. It will be great time to share what you are doing with SharePoint and struggles you are having. Perhaps there will be someone in attendance that can provide an answer to your problem.
When: March 11th, 2010 11:30am - 1:00pm (please rsvp, see below)
Dell Oklahoma City office
3501 SW 15th
Bldg A, Hudson Hall on 1st Floor
Oklahoma City, OK 73108
Eric Shupps, The SharePoint Cowboy will be our guest speaker for this first meeting of the Oklahoma City SharePoint...
I recently attempted to move a subsite from one location to another on our SharePoint 2007 platform. I received an error upon restoring. The backup seemed to successfully complete, but the restore kept failing with Could not find the file C:\Windows\Temp\[someguid]\Exportsettings.xml.
I found out this happens when the content size exceeds 25MB and it fails to include the mentioned file - Exportsettings.xml. I found a workaround solution at this particular blog.
Here's the jest of what needs to happen:
Recover leftover files from the original backup site location (via Recycle Bin)
Select all recovered files (locate at the root of...
An update has been published on Patterns & Practices as related to SharePoint Application Development. This is a great resource to follow as you are developing your custom SharePoint solutions.
[via Stefan Keir Gordan]
I found a Stock Ticker implementation over on StefanOnSharePoint's blog. He implements a timer job code originally published by AC. We have something similar at the company I work at; however, we pull the stock data directly from within the webpart. Stefan proposes updating a custom list with unlimited number of stock quotes and using a "simple data view" to display the results.
Here's the reference: http://www.keirgordon.com/post/SharePoint-Stock-Ticker.aspx
Check out some of the new features in SharePoint 2010 coming our way in Beta form (later this year) and RTM first quarter 2010.
[via Stefan Gossner]
We have recently discovered a bug with Service Pack 2 (SP2) that affects all customers that have deployed it for SharePoint Server 2007. During the installation of SP2, a product expiration date is improperly activated. This means SharePoint will expire as though it was a trial installation 180 days after SP2 is deployed. The activation of the expiration date will not affect the normal function of SharePoint up until the expiration date passes. Furthermore, product expiration 180 days after SP2 installation will not affect customer’s data, configuration or application code but will render SharePoint inaccessible for end-users. We...
[via Bob Fox]
New additions in MOSS 2007 SP2
preupgradecheck - Bob shows how he ran this new stsadm switch on his test lab. It is available in SP2 to preview readiness in upgrading to SharePoint Server 2010. He provides helpful insight on what this information provides.
Backup, Set your databases to Read Only - "If you run this command on a working environment there will always be a chance for the job to fail if users are adding content to the sites. To prevent this we now have a new feature that allows us to lock the DB and make it read only."
If you believe Microsoft's Virtual PC has been abandoned or VMWare is too pricey for your budget, give the free Open Source alternative a try. I have been reading some forums and blog posts from some happy folks using it. Also, as of this posting date, the community is really active in keeping it cutting edge.
Virtual Box - http://www.virtualbox.org/
"VirtualBox is a family of powerful x86virtualization products for enterprise as well as home use. Not only is VirtualBox an extremely feature rich, high performance product for enterprise customers, it is also the only professional solution that is freely available as Open...
Office 2007 Service Pack 2 including the service packs for WSS 3.0 and MOSS 2007 has just been released. Be sure to read the KB articles below as they contain important information about SP2 including known issues with these service packs.
KB Article Links
Description of Windows SharePoint Services 3.0 SP2 and of Windows SharePoint Services 3.0 Language Pack SP2
Description of 2007 Microsoft Office servers Service Pack 2 (SP2) and of 2007 Microsoft Office servers Language Pack Service Pack 2 (SP2)
Please check the above listed KB articles. They contain the download locations for the service packs and...
I caught this over at Stefan's blog. MSDN's ramp up site has a SharePoint Development Track available, located directly at http://msdn.microsoft.com/en-us/rampup/dd221355.aspx.
Some of the tracks include:
Level 1: Web Parts
Did you know that in SharePoint you can build pages as easy as in ASP.NET – and allow end users to create dashboards? Web parts allow for creating components of Web user interface that can be reused on multiple Web pages. These are introduced in ASP.NET and built on in SharePoint where they can be added to pages by end users and managed by IT Professionals. In this topic you will learn about...
Missing your SQL Server Management Studio after installing SQL Server 2005? When creating my Microsoft Office SharePoint Server (MOSS) development environment I had the same problem. Thankfully, Pete Orologas posted a solution and it worked for me. Apparently, if there is already a \Program Files\Microsoft SQL Server\90\Tools folder that exists then the installer moves on to the next step. How does that subfolder get there? Well, if you install Visual Studio before SQL it creates the folder when installing SQL Express. Or if you install the SQL Express edition it will create the tools folder.
Rename the Tools folder to something...
"cannot get the list schema column property from the SharePoint list"
Have you ever got this error? Recently, when troubleshooting a problem my manager was having while Exporting a custom list from MOSS 2007 WSS 3 to Office Excel 2003 I found a solution.
I found a thread of folks experiencing the same issue. In that thread I found that someone had pinpointed their problem to a date column. They changed the definition from date to 'Single Line Of Text' and then back to "Date" (Date Only) and fixed the problem.
So, I tried that and everything started working again. I have Office...
I have started a SharePoint resource page. I have been recommending (and still do) some of the great ones out there. However, I have found that some of my experiences and needs differ in a lot of ways. As with others, my resource page has started out as something I use to personally reference in my day-to-day work routine. If it helps others that would be great too. Here's the beginnings of my MOSS SharePoint InfoPath Workflow .NET Resource Page. It will be growing significantly over the coming days.
Waynester's SharePoint Resource page
Great Resource for us SharePoint developers!
Do you need hands-on development experience with Windows SharePoint Services 3.0 Applications? Here's a link to start your journey:
Hands on Labs for Developing Applications on Windows SharePoint Services 3.0
Each application template has a companion set of two datasheets. For business decision makers, the functional overview (BDM datasheet) highlights the features and details of the scenario which can be used to consider deployment. The technical overview (TDM datasheet) is for IT professionals and describes the scenario, Web parts, relevant workflows, lists, and document libraries that are part of the template.
If you can, and it's free, hook into these upcoming SharePoint developer training series:
SharePoint Developer MSDN Web Cast Series
Last Thursday I got "the call" that all employees dread - "you're no longer needed". Our company went through yet another round of layoffs and this time my number was called. I had survived so many of these over the 14 1/2 years of my career - with the same company (very rare, I know). It caught me by complete surprise. I was their number one "MOSS" man, they told me just days before. Then came "the call".
I guess I've been very fortunate in my career. I've only experienced two layoffs in 20 years. I do not recommend it to...
Andrew Connell has two more WSS 3.0 HOW-To videos published up on MSDN:
MSDN Visual How To: Adding Code-Behind Files to Master Pages and Content Pages in Windows SharePoint Services 3.0
Learn how to use code-behind files in custom content pages in Windows SharePoint Services 3.0.
MSDN Visual How To: Creating, Deploying, and Debugging Custom Timer Jobs in Windows SharePoint Services 3.0
Learn how to harness the power of custom timer jobs in Windows SharePoint Services 3.0.
You can find the links on his posting by going to:
[via John Holliday]
John has an in-depth video demonstrating how to build custom Content Types for SharePoint 2007 in Visual Studio. By way of Reflection he shows how to integrate content types 'your way' and staying within the best practice boundaries. I found it very helpful.
Check it out here:
We have been migrating tons of content from IBM Lotus Notes to SharePoint the past 2 years. The majority of content can go over pretty smoothly. However, there may be some former Lotus Notes users who want to keep their "Notes Links" features they've come to use and depend upon. A particular site we are analyzing currently falls under this scenario.
In my research I came across a good reference of what this "Link Mania" is all about. Before you can come up with a solution or recommend an alternative it's always good to know what "it" currenty does.
Here's some references I found:
In a previous posting I mentioned a training course I was taking by Andrew Connell in Dallas. It focused on Web Content Management (WCM) Sharepoint 2007. One of the highlights was how AC showed us how to create and deploy solutions. This involved code behind files in your basic ASP.NET 2 environment. Most of the Microsoft development world has probably heard of bad experiences from us "V2" warriors. Well, "V3" brings to the table none of that. All is forgotten and old things have passed away and Good-God, Sharepoint was built on top of ASP.NET 2.0 - making life for us a lot nicer.
I'm heading to Dallas next week to sit under Andrew Connell's teaching. Andrew is conducting a 4 day hands-on class for WCM. He also provides this class online. If you cannot make the trip to one of his hands-on classes, catch one of his online offering. I look forward to learning some insights on Developing Publishing Sites with SharePoint Server 2007 WCM. It seems the past few months I've been pulled to other ASP.NET projects within my corporation - preventing me from staying fine-tuned into WCM. I've been told that I'm going to be thrown into the fire this time; hence the intense training under AC's expertise.
Deploying an InfoPath 2007 Form that contains Managed Code to a Browser-Enabled WSS v3 Library can be done. Trying to find the How To in some of the recommended top books on the subject? Good luck! Josh Meyer explains it (free of charge) in a step-by-step approach at the following web site:
A question was posed last week from a coworker on the maximum number of items allowed in a Form Library. You see, with this current project we are taking on - there's potential for massive content. We are looking at pumping this puppy with beau-coup InfoPath form entries (xml files). So, today, one of my colleagues pointed out to the team that 2,000 is the maximum number of items in a SharePoint Library. Where did he get this? From Chapter 14, page 708, in Scott Roberts and Hagen Green's book, Designing Forms for Microsoft Office InfoPath and Forms Services...
I just ordered copies of two books off Amazon related to InfoPath 2007 and MOSS Workflow. We have a major project inside the corporation we are ramping up. My fellow coworkers, Scott Hankins & Marcel Janda, will be working together to make this happen. Scott already purchased these and I got a chance to glance over them at lunch yesterday. They look worthwhile and are from solid authors. Here's a link reference if you are interested...
Mie Ying has recently posted some informative material on Sharepoint and Lotus Notes integration. One familar post talks about displaying Lotus Notes Document Titles in SharePoint Search Results. The other deals with using Sharepoint 2007 to Index a Lotus Notes Database. Pretty good stuff if you are tasked with integrating the two competing platforms.
This is a boon for InfoPath developers out there! I caught this over at Jan Tielens' blog. It's concerning the use of newly introduced Universal Data Connection (UDC) files. In previous postings I ranted about the lack of (or pain of) accomodations for distributed solutions in InfoPath. I found myself creating data sources in development that were difficult to change when migrating to Testing or Production environments. Jan does a swell job of explaining this new approach. He also throws in some upgrade and migration tips.
External Data & InfoPath: Server Upgrade and Migration Tool
I caught this over at Andrew Connell's blog. AC makes reference to Ted Pattison's “What are Features?” post to understand them. If you are into MOSS and/or WSS v3 you'll want to get up-to-speed. AC also has updated his resource page covering Features, and it can be found at http://andrewconnell.com/blog/articles/MossWcmResources.aspx#Features- - great stuff!
I caught this over at AC's blog. Joel Oleson has made available a case study looking at a few areas in migration: (Navigation, Search, Summary pages, Deployment scripts, Form login screens and Developing the approval workflow). They also present some best practices in migration.
» Improving an IT Self-Help Portal User Experience - Technical Case Study
I got wind of these from a co-worker, Jake Wilds. Microsoft has provided free eLearning courses on MOSS 2007 and Office 2007 Client Suite. You can find them here:
Need a place to hold-up for awhile and absorb all things Microsoft Web Content Management? Well, stop your looking by golly. Andrew Connell has built the Wal-Mart of WCM Resources - and has done a fine job at it. When you first walk in (er, click in) the eye-candy is appealing. Yeah, this is where it's at - hands down. Book mark it, Add it to your favorites, pass the word around and wake the kids.
Andrew Connell's Web Content Management Resource Site - *** The Definitive Source ***
Andrew Connell (AC) has been a busy little beaver. It took me a few gulps of caffeine to get through his recent posting, “RECAP: Tampa Code Camp - July 15, 2006 “. In my humble opinion AC is developing a repertoire of development tools comparable to none other than the Computer Zen (Hanselman) himself. Okay, he has a ways to go, but his focus on Virtualization (found here and here) is something you don't see much information on. Specifically, how we as developer's can utilize VPC environments to improve our development time.
[via Ted Pattison]
The August 2006 article in MSDN magazine titled Gathering MOSS, New Dev-Centric Features In Office SharePoint Server Keep Your Apps Rolling does a good job in explaining what MOSS 2007 is all about. If you haven't jumped into the Callaborative World of SharePoint, now is a good time to get up-to-speed on what it's all about. Microsoft did something radical in this product by including a totally different architecture for Web Content Management. This was a classic Microsoft move - one that most could see coming if you ventured into the MCMS 2002 infrastructure.