I have moved my blog to a SharePoint Foundation 2010 hosted site. Seems to make sense, doesn’t it?
Please update your RSS Feed, Links or other connections to my blog to http://sharepointony.info/blog for continuing updates.
tony
Posted by sharepoinTony on March 15, 2012
I have moved my blog to a SharePoint Foundation 2010 hosted site. Seems to make sense, doesn’t it?
Please update your RSS Feed, Links or other connections to my blog to http://sharepointony.info/blog for continuing updates.
tony
Posted in SharePoint 2007 | Comments Off on Relocation
Posted by sharepoinTony on January 12, 2012
If you who have discovered the benefits of using OneNote shared notebooks AND have sync’d the notebook in a SharePoint library…this post is for you.
We started using OneNote 2010 with our MOSS 2007 farm, and because of the kind of shop we are – we setup a new SharePoint 2010 environment to run beside our MOSS farm. Fast forward to January 2012 and our SP2010 environment is our ‘production’ intranet now. Our MOSS environment is still chugging along and we are going to keep her for a while, but how we use that farm has changed significantly over time.
Now that our SP2010 farm is heavily used, we don’t like that we still have a shared OneNote notebook lingering out there in the old MOSS environment. We do have other OneNote notebooks out there, but they are old, smelly notebooks that we don’t really use. We keep them because they are now an archive of specific notes.
There is one notebook however that is still alive with activity, so we just want it ‘where we are’. We have a better home for that notebook. One that we visit daily and where we have other related content. So it was an easy decision to move the notebook from the MOSS library to the shiny SharePoint 2010 library where it belongs.
To move your OneNote 2010 notebook
Whew! That was tough. WAIT, there is more!
Notify the people sharing that notebook of the new location, they will have to ‘change location’ to sync to the notebook. Here are the arduous steps:
I chose to send folks these steps as part of the message that the notebook was now in it’s new home.
We now return you to your regularly scheduled SharePoint blog browsing. Happy Notes.
Posted in SharePoint 2007, SharePoint 2010, Tips and Tricks | Tagged: OneNote, SharePoint 2010 | 2 Comments »
Posted by sharepoinTony on January 2, 2012
The WordPress.com stats helper monkeys prepared a 2011 annual report for this blog.
Here’s an excerpt:
The concert hall at the Syndey Opera House holds 2,700 people. This blog was viewed about 25,000 times in 2011. If it were a concert at Sydney Opera House, it would take about 9 sold-out performances for that many people to see it.
Posted in SharePoint 2007 | Leave a Comment »
Posted by sharepoinTony on January 2, 2011
The stats helper monkeys at WordPress.com mulled over how this blog did in 2010, and here’s a high level summary of its overall blog health:
The Blog-Health-o-Meter™ reads Wow.
The average container ship can carry about 4,500 containers. This blog was viewed about 14,000 times in 2010. If each view were a shipping container, your blog would have filled about 3 fully loaded ships.
In 2010, there were 33 new posts, growing the total archive of this blog to 84 posts. There were 5 pictures uploaded, taking up a total of 306kb.
The busiest day of the year was January 6th with 153 views. The most popular post that day was Calendar Reminder (Part 2).
The top referring sites in 2010 were google.com, community.sharepointproconnections.com, sharepointproconnections.com, twitter.com, and google.co.in.
Some visitors came searching, mostly for sharepoint calendar reminder, sharepoint calendar reminder email, sharepoint calendar reminders, sharepoint calendar alerts, and moss 2007 file size limit.
These are the posts and pages that got the most views in 2010.
Calendar Reminder (Part 2) April 2009
80 comments
“Conference” Room Manager for SharePoint June 2009
10 comments
Poor Folk’s Calendar Reminder (part 1) April 2009
2 comments
MOSS 2007 size limits – and List Item Attachments June 2009
2 comments
Fab 40 Help Desk Template screen shots November 2009
Posted in SharePoint 2007 | Leave a Comment »
Posted by sharepoinTony on September 8, 2010
The Calendar Reminder (Part 2) post has been the most viewed post on my blog over the past year. There have been a few weeks where other posts surfaced as number 1, but when I review the stats for the past 12 months, the calendar post is certainly the most popular. There is obvious interest in this topic.
Since the time of the original post, I have had several other calendar related requests and from them I have pulled one feature that might be of particular interest to those of you who found the Calendar Reminder post useful. This is a twist on the reminder, but certainly related.
How would you like your SharePoint Calendar event email reminder to include a link to create an Outlook event for the user?
Here is how to accomplish this using SharePoint 2007
Requirements
Steps to add a link to add the event to the users Outlook calendar in the email they receive from SharePoint.
If you would like to add this event to your Outlook calendar, <a href=”http://webappname/sites/sitename/_vti_bin/owssvr.dll?CS=109&Cmd=Display&List={ec72e475-45aa-4f06-83e0-855ec9ca94d4}&CacheControl=1&ID=[%Calendar:ID%]&Using=event.ics“>CLICK HERE</a>, then click to Open, then click Save & Close in the Outlook calendar item.
This example provides both the Outlook calendar item and instructions on how to use it. Notice that the portion highlighted above should contain the link you copied with the ID removed. The link must come from your server and the specific SharePoint Calendar that you are providing to the Outlook item.
Perhaps you would rather not create such a complex workflow as the Calendar Reminder posts provide. If want to just send an email at the time of the event creation that included the ability to add the event to the Outlook calendar – you can simplify the workflow to notify the recipients and include the above link. This allows the user to create their own reminder using Outlook!
I want to point out that this idea originated (for me) with Laura Rogers 2009 post entitled “Appointment email Link, via SPD workflow“. Thanks and kudos to Laura for sharing the idea and steps with the SharePoint community.
Posted in Calendar, SharePoint 2007, Tips and Tricks | Tagged: Calendar, Outlook, Reminder, Tips and Tricks | Leave a Comment »
Posted by sharepoinTony on September 3, 2010
I had a group come to me recently that wanted to set up a subsite to their site and allow a group of users create sites under that subsite. Standard issue for SharePoint. In this case they wanted those sites to all start out the same. They had specific things such as two document libraries and a few other specific lists as the default when those sites get created. Also standard issue for SharePoint…by simply creating a site template the users to select they would get what they wanted.
This request didn’t specifically ask for the restriction of site templates, however since we have had numerous other similar requests we now have a lot of site templates available. So…
To make everyone’s life a little easier I decided to restrict the subsites so the users could only use the template created for them. The group manager was very happy-this made it very simple for them to find and thus the creation of their sites was a snap.
The trick to it all is getting to the Page Layout and Site Template Settings page. This isn’t available to you at the Site level, it is only on the Site Settings menu at the Site Collection level (top-level site). That doesn’t mean you can’t use it to accomplish this task.
After creating the desired site template, go to the site above (parent to) the site where you want the users restricted to specific templates. Replace the aspx page portion of the url with
_layouts/areatemplatesettings.aspx
Make your adjustments to the site templates available to subsites in the Page Layout and Site Template Settings screen, then click OK.
Posted in Administration, SharePoint 2007, Tips and Tricks | Tagged: Administration, SharePoint 2007, Tips and Tricks | Leave a Comment »
Posted by sharepoinTony on July 28, 2010
Posted in Search, SharePoint 2007 | Tagged: Search, Tips and Tricks | 1 Comment »
Posted by sharepoinTony on July 23, 2010
There are many reasons why you might want to e-mail enable a Document Library in SharePoint. One of them could be simply because some manager doesn’t want to navigate to the library to upload a file. Another, better reason is because they are traveling and want to post a document on your Intranet without having to VPN into your network. Regardless of the reason, the steps to make this happen are easy so let’s get started.
Do you want the documents to all go into the root library or into folders?
Do you want anyone in the world to post files to this library?
Will your e-mail system allow incoming email to route to SharePoint?
I will assume you get those questions answered and are ready to go now.
I will use “Shared Documents” for this example.
Note that the full email address contains “@sharepointserver” dot your company domain. This is something you may have to ensure your e-mail system will allow. You also may have to setup a specific e-mail box and use that address here to allow it to work. See the references at the end of this post.
REFERENCES:
Planning for Incoming E-Mail: http://technet.microsoft.com/en-us/library/cc263260.aspx
Reference this article for details on configuring your SharePoint SMTP services: http://technet.microsoft.com/en-us/library/cc262947.aspx
Posted in Install and Configure, SharePoint 2007 | Tagged: Document Library, email | Leave a Comment »
Moving MOSS 2007 SQL Databases part 3
Posted by sharepoinTony on July 27, 2010
If you haven’t seen the earlier posts on this topic: Part 1 and Part 2
D-Day has arrived, it is time to actually move my SharePoint 2007 sql databases to a different SQL Server. My previous posts touched on the research I did leading up to this event. This post will cover the actual tasks and outcome. I am writing this as I go through the process, so let’s all cross our fingers that it goes smooth.
My Plans
A summary of my plan is as follows:
Round 1
I attempted these steps and all went smoothly until I got to step 13 – Restore SSP’s from backup. The restore made it to 50 percent complete then ran into this error:
After several attempts and a grueling session of troubleshooting I found that the SQL Server Agent was not running on my ‘new’ SQL server (SQL Server 2008 R2 64-bit, running on Windows Server 2008 64-bit). The fun part was that I couldn’t get it to start. The Agent would just stop after every attempt to start it. I tried several solutions found on-line, none of which worked.
At this point my weekend was over and we needed the production server back online, so I did the restore BACK to the original SQL Server. SharePoint was up and running fine very quickly.
Finally, I un-installed SQL Server 2008 R2 from the new server and started over. After carefully reinstalling SQL Server 2008 R2 I no longer had any problem with the SQL Server Agent. Hurray, now will the SSP restore work? I have to wait until the next weekend to find out.
Round 2
Friday – A week has gone by and I am now preparing to walk through all of those steps again. More confident than last time perhaps, but concerned at what I might run into this time around. I will do all of the initial steps – the backups – tonight, Friday night. Saturday morning I will start the scary part, removing the SSP’s and moving everything to the new SQL Server.
Saturday – Everything went well up to the restore, again. This time the error was an Access Denied error pointing to the SharePoint backup directory. Short-story resolution: change the SQL Server account to use a Domain account, make sure that domain account had permissions to the backup folder and to the sql database files folder. I also wanted to make sure I didn’t have any more trouble getting to the backup folder so I opened it up (temporarily) to several other accounts – my ssp and app-pool users.
The SSP Restore completed successfully, with zero errors and zero warnings. Hurray!
Hold-on, the process outlined by Microsoft ends here. What about my content databases?
Searching about I found that I need to use stsadm to detach the content databases, one by one, from the SharePoint server and add the databases on the new server. So I begin this task and have no problems until I get to the Config database. It detaches fine, but then the services become disabled and the attach (setconfigdb) results in “Value cannot be null. Parameter name: str” ! What the?! Time for Microsoft Support calls.
Support helped resolve the ‘migration’ issues, however now the SSP is not working-including search, and there are several other things missing. I am told I will have to add any solutions back in, and find whatever features or web parts that might not work and fix them. Also have to open a new ticket for ‘advanced troubleshooting’ on the SSP. It has been a long Saturday.
Round 3
Sunday – Monday (ouch)
After hours on the phone and several rounds of running psconfig we were able to get a new Config db setup and restore over it to capture most of my configuration data. The SSP is a different story. We had to create a new SSP, which left me with a few more days of reconfiguring the SSP, Search, Audiences, etc. before I was “back” to normal.
Wrap-up
Posted in Commentary, Install and Configure, SharePoint 2007 | Tagged: SQL | 2 Comments »