Archive for the ‘SharePoint’ Category

Could Not Open file.doc from SharePoint Server 2010

Monday, June 6th, 2011

I have found a couple of solutions to this on the web, but nothing like this.

We have SharePoint Server 2010 and Office 2010. I was browsing to a file located on My Site, but other documents . Excel or Word would open and then i would be told:

Could not open filename.doc

You would then click ok, the message disappeared and you would not have an open document.

In our case, it was nothing to do with IE security settings, or Office 2010 protected mode.

We had been trialling SharePoint WorkSpace with a copy f my My Site attached so that I could work on my MySite documents at home. The copy that was stored on my computer had not been updated as I had disabled the option to start SharePoint WorkSpace after I was happy that it would work.

The fix for me therefore was to either delete the local sync copy or to have it update the local copy.

Back to be able to get my work.

1 person found this post useful.

Combining SharePoint 2010 and Windows Media Services

Friday, May 20th, 2011

This may already be covered elsewhere, but I am writing it up anyway.

We use SharePoint 2010. We also have a lot of video content, shared amongst many staff, of which presently there are multiple copies of the content scattered around the network. The aim was to remove all these duplicate copies of ‘static’ data, combine them together and add them to a searchable database.

We wanted to use Windows Media Services to allow the media to be streamed to the clients too, so multiple people can watch and share the file simultaneously.

We needed a site which allowed users to upload files to the Windows Media Services Server, but also create the necessary URL links inside SharePoint. If it was too complicated people wouldn’t use it, and us in ICT did not want to spend the next few weeks doing it all for them.

This caused the birth of the Streaming Media Upload site. This site uses the following ideas to simplify making streaming media available.

  1. User browses to the site. They select the file that they want to upload, and enter basic details such as the Title, Author, Information about the clip and the Copyright Holder.
  2. The user also selects the SharePoint List to add the clip to.
  3. The user selects upload.
  4. The media file is uploaded and saved in the Windows Media Services Content Folder
  5. An ASX file is created with a link to the clip, along with the clip information specified to the user. This ASX file is saved in a web directory
  6. A new URL List Item is created in the SharePoint list which refers back to the ASX file.

In this way, SharePoint is not filled up with video content, which would bloat the database, but full details of the videos are stored in SharePoint which can be searched upon.

Full details of how we set up this system are included on the Windows Media Services Upload Site page, at the top.

ISA 2004: Configure HTTP Greyed Out

Thursday, May 5th, 2011

To set the scene, we have just created a WSS 3 site using forms based authentication. Published it through ISA 2004. Browsed to the site and we get this error.

Following Microsoft’s guidance and information on various blogs, it suggetsed to disable the Verify Normalisation and the Block High Bit Characters options in the HTTP filter. We browsed to the rule in question, opened the Properties and selected the Trafic tab. The HTTP and HTTPS protocols are listed, but the Filtering button is disabled.

Things to check to enable this Filtering button are:

  1. Go to Configuration –> Add-Ins
  2. Ensure that the Web Proxy Filter is shown and enabled (if you have the option to disable it)
  3. Select Web Filters and ensure that the HTTP Filter is present and enabled
  4. Go to Firewall Policy and open the HTTP Protocol Properties
  5. On the Parameters tab, in the Application Filters panel ensure that Web Proxy Filter is checked.
  6. Apply your changes.

The Filtering button on the Traffic tab will now be available and the Verify Normalisation and Block High Bit Characters can be disabled.

XSL:Sort by Date Time

Tuesday, September 14th, 2010

If you are stuck trying to sort XML date by date/time then this snippet of code may help you. Been stuck in head first into some XSL scripting, so learning at quite a rate.

<xsl:sort select=”ddwrt:FormatDateTime(@DateTimeField, number($lcid), ‘yyyyMMddHHmm’)” />

In the above line, @DateTimeField is the name of the field to sort, $lcid is your locale number.

By doing this, the data is then sorted as a number, in ascending date order, without having to change the underlying date. By changing the format at the end you could also quickly sort just by time or date, depending on the format of the source data.

Happy sorting!

1 person found this post useful.

Room and Equipment Reservations

Monday, September 13th, 2010

Right, after an extremely frustrating day trying to get my head around XSL – something I never want to repeat again – I am near to having completing a re-hashed template of the Room and Equipment Reservations template originally provided by Microsoft for SharePoint 2007.

Following the post by Samantha – http://blogs.technet.com/b/tothesharepoint/archive/2010/08/18/sharepoint-2010-products-upgrade-and-the-fabulous-40-application-templates.aspx - which explains that the Fab 40 are not to be recreated, and although Khalil is working hard to recreate them on his site http://techsolutions.net/Blog/tabid/65/EntryId/17/Fab-40-Templates-for-MOSS-2010.aspx), I am just impatiant really!

So, for out recently upgraded SharePoint 2010 deployment we will shortly have a working Room Bookings system again.

One of the key changes in my rewrite of the template, is the removal of the need for the list to have to include details of all the time in a day – both available and booked. One of the things that really frustrated me in SharePoint 2007 was the need to make sure when you deleted a booking that the free time was re-calculated – which depending on the view that you were in (we frequently did bulk updates through the datasheet view) didn’t update the list correctly. Bit of a headache to implement in XSL - but nearly there. Also I have managed to break down all of the ‘Free’ time into 30 minute blocks. One of the frequent problems at work was people clicking a section and forgetting to check both the start and the end times – resulting in wasted resources.

I am hoping that I will be able to finish tweaking the template tomorrow. Providing I can sort out restrictions on double booking a resource, I will be able to post the template on this site for others to download. Not saying that it is going to be perfect (still spending a lot of time working on SharePoint and developing my skills) but hopeflly it will help someone else out.

SharePoint Search – Access Denied

Wednesday, September 8th, 2010

Having a bit of a SharePoint day. Had recently noticed that no People were being returned in search results, even if you type in their name exactly.

Went through the check list of possible causes:

  • Default Content Access account permissions to the User Profile Service (Read Profiles for Search Crawler)
  • Full Read permissions on the My Site Web Application
  • Crawl Rule set up for the My Site Web Application
  • Location included in the Content Source

We were still getting Access Denied errors.

Suddenly remembered this little MS article about accessing FQDN’s from the local machine. Turns out it is still relevant in SharePoint 2010.

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

Hope this helps someone else out there with the mysterious Access Denied when crawling Profiles.

Installing SharePoint 2010 on a DC

Tuesday, June 8th, 2010

A disclaimer fist: I am in no way advocating the installation of SharePoint 2010 on a DC in a production environment. This information should only be used to set up SharePoint in a lab environment. Microsoft do not support the installation of SQL Server on a DC, which is why the Standalone option is not available in the SharePoint setup.

Firstly, you need to download SQL Express from here. Install it on your Windows Server 2008 box (I was running R2). Use the default setup options, provide a user account for the service to run under.

Next, install the SharePoint Server. You can choose the installation location, but you will be guided through the complete setup without any choice. Choose any options that you require.

At the end, you will run the SharePoint Technologies Configuration Wizard. In the wizard you will be asked for the location of your SQL Server which is SERVERNAME\SQLEXPRESS. Enter this alongside the user name and password to access the server with. In this very initial test, I have used the administrator password for everything, no permissions issues with anything at the minute.

At the end you will have a working installation of SharePoint 2010 on a DC – great for testing.

My Profile in My Site – Error 404 File Not Found (SharePoint 2007)

Friday, June 4th, 2010

Just doing some pre-upgrade checks on SharePoint 2007. Want to make sure that everything is working as it is before upgrading.

As part of this I went to edit my profile on my personal site. Whenever I did though, I got an error message stating 404 File Not Found. Symptoms are described exactly in this Microsoft KB. http://support.microsoft.com/kb/924399

Started reading through the solution, and walking through the steps. I hesitated on adding another Managed Path though, as there were already managed paths for MySite and Personal.

My advice is to skip to point 3 of the solution first and check that. In my case, it was that the Personal Site Services URL in SharedServices had been changed, which was causing the link to fail.

  1. Under Shared Services Administration, click Shared Service Provider (SSP).
  2. On the home page, click My Site settings under User Profiles and My Sites.
  3. On the My Site settings page, type the URL of the included path in the Personal site provider box in the Personal Site Services area.
  4. Configure the options that you want for the other settings, and then click OK.

In my case, putting ‘/mysite’ at the end of the URL and saving it solved the problem.

So, if you already have a load of Managed Paths, which include MySite, then check your URL first. May save you some time.

1 person found this post useful.

Exchange 2010: No In-Place Upgrade

Wednesday, June 2nd, 2010

Really disappointed to have just found out that an in-place upgrade is not available when migrating from Exchange 2007 to 2010.

Totally understand why this is the case though. Database schema changes and the lack of storage groups in 2010 being the root cause. Not great news for the smaller places which probably haven’t got the finances to purchase a new server for a bare metal installation, or enough hardware to perform some sort of swing installation.

At least on a plus point, SharePoint 2010 does support an in-place upgrade from SharePoint Server 2007 SP2. At least one of the upgrades will be simple this year. Looking forward to trying out the new features. Shortly going to be getting our development system up and running ready to formulate our deployment plans.

Anyway, enough of my drivel. Back to coming up with a plan for our Exchange 2010 upgrade.