Category Archives: SharePoint

Cannot open files in Microsoft Excel from SharePoint

Recently I uploaded a file in a document library on a SharePoint site. I had created a report and wanted to publish it. After reviewing client requested some changes in it, I tried to open that file from SharePoint directly in Microsoft Excel using “Open in Excel”.

Whatever I tried I always received an error “The file is corrupt and cannot be opened”. Did a little search on the web and found the solution.

  • Open Microsoft Excel
  • Go to File > Options
  • Click on the Trust Center at the bottom of left panel
  • Click on “Trust Center Settings” button on displayed pane
  • Choose “Protected View” from left panel
  • Uncheck all options on displayed pane, and click “OK” till back

sp-excel-trust-center

Now when you open that file again, you will be able to do that, until any further issue, will keep that handy.

Empty a large list using powershell

Recently I wanted to delete all entries in a large list, but manually it was hectic and time consuming. One way could have been to delete and re-create that list, but that list was tightly bound to an InfoPath form, and I did not had any backup source available.

I had been experimenting in PowerShell these days, so looked around for any script which I could modify for my purpose.

Here is that script, took it from different sources mentioned here.

Continue reading

Deployment problems for sandbox solutions

I will list here different problems and their resolutions when we are trying to deploy sandbox solutions. That might help me quickly resolve these in future.

Problem 1: Error occurred in deployment step ‘Retract Solution’: Cannot start service SPUserCodeV4

I was working on a project which involved creating a simple Webpart and must be tested in sandbox environment, I tried to deploy it after some initial working, I got that message on deployment.

Where did that service is, I looked around and found that I need to start that service in Central Administration, as outlined below.

  1. Open Central Administration
  2. Click on “System Settings”
  3. Then click on “Manage services on this server”
  4. A list of services will be displayed, some of them will be stopped
  5. Look for “Microsoft SharePoint Foundation Sandboxed Code Service”
  6. Click on “start” on the last column, your services will be started shortly.

Now go back to your solution and try re-deploying.

Installing pre-requisites for SharePoint Foundation 2010

Installing any application is not a hard part, but preparing your system for that installation takes some time and considerations. While installing Foundation today, I had the same issue myself. I did not know which pre-requisites should be installed first. I searched for it, and found different combinations, but one told me to run the pre-requisite installer first, it will let you know what are missing for you. Here are those which were required on my machine.

For some you will have to look for the specific download for your operating system (x86 / x64).

I downloaded and installed them, and was able to proceed next. By the way, did I mentioned that I am using Windows Server 2008 R2 Standard with Service Pack 1.

UPDATE: I found a PowerShell script for downloading all these pre-requisites, grab it from here, it might be handy too. http://gallery.technet.microsoft.com/office/bcf3332d-f726-4ac7-b01a-eeda4b7ece8e

which webservices are available in which version of SharePoint

We are working on a client application, which required to access data from SharePoint too. The best way to do that is to consume webservices exposed by SharePoint. While consuming them, we wanted to make sure which services are available in which version. We tried to find any matrix for that, but could not find one. So I thought of building it myself, so that others can reference it.

Continue reading

List of books for SharePoint 2010

I was looking for some resources for learning SharePoint 2010, and stumbled upon some information mentioned on various places, I have collected them in one place and am posting it here for keeping it as a repository for not only myself, but share with others.

Although I have not gone through all of them, but plan to touch each one of them in future. If someone finds any interesting item, just let me know.

Continue reading

Prepare base Windows 2003 image using SysPrep

After installing Windows 2003 and required updates on your virtual machine, we now need to prepare it for easy duplication later. Now extract files from system preparation package, which we had previously downloaded. As we have installed Service Pack 2 for Windows 2003, so we will use only preparation package related to that.

SP-055 Now run “setupmgr.exe” from the extracted files. This is a setup wizard which will help you create your configuration set and answer file for automating your duplication process.

Continue reading

Installing Windows 2003 on virtual machine

Previously we had created our first virtual machine, and then I showed you how we can configure it further for our likings. Now we need to install any guest operating system on this machine. As we have to create an environment where we can emulate a full intranet system, with its own domain controller, so we need to install any server operating system which can support these things.

I know currently Microsoft is planning to release Windows 2008 Server, but I could only get my hand to a Windows 2003 media for installation. I will use our first virtual machine as a base machine, and would create other machines from this, just by creating another copy out of it. That way we don’t have to install things on each machine.

Continue reading

Configuring a virtual machine

Lastly we had created our first virtual machine. We had provided some configuration options while creating that machine. Mostly that would work for our purpose, but if someone want to tweak some configuration items, then this would help him do whatever he needs to change.

That machine is now listed on your virtual server main page. You can see this machines settings and configure it further, to do that, click on “Virtual Machines” > Configure > WIN2K3 menu item on the left sidebar.

Continue reading