Tuesday, August 09, 2011

SharePoint Multiple File Upload in Windows 7 64 bits

After a cilent of mine upgraded his OS to Windows 7 64 bits he lost his ability to upload multiple files. There are many posts on several issues with working on SharePoint content in Win7.

The solution is to use the IE 32 bits which is not the default browser in a common win 7 installation. It is related to SharePoint 2007 while 2010 has a replacement and lets you drag and drop files from Windows Explorer.
A nice article explaining this issue can be found here.

Saturday, July 16, 2011

The Conditional Formatting in Excel Pivot Table Disappears upon Refresh (Excel 2007, 2010)

Let's say you want to conditionally format your SharePoint exported pivot table (or any Excel table). In this example one column includes the classes A and B and another is a sub-class A1, A2, B1, B2 etc., and you want all class and subclasses show in different colors, in this case if the text in column A starts with A, or B.

 The 2 rules you need may look like this: (the range A5:F95 contains the pivot table)

And the specific rule uses the left 1 character of the cell in column A (take away the $ sign from the row # to let the reference be relative):

Now, if you refresh the table, it may look like this:

If you analyze again your rules if will find that they were changed. Why? I don't know:

The work around is just to select the cells in column A starting with A5 (in this example), and 'format copying them (the brush icon) the equivalent cells in B-F columns. You will get the colors back and a refresh will not blow away the colors in the data area.

Excel adds two new rules that apparently solve the issue:

Friday, April 29, 2011

Where is my SharePoint Rcycle Bin?

If you get a complaint on a missing list item a user owned, you can direct the user to restore it from his site's recycle bin (in case it has been deleted). However, if he or she can't find it in spite of having contributor permissions for that list, they may have only read permissions for the site itself and therefore the recycle bin will be missing for that user.

Sunday, February 27, 2011

WSS 3.0 Upgrade to SharePoint Foundation and Search Server 2010 Express Tips

I upgraded lately a WSS 3.0 application to Search Server 2010 Express. This was not a seamless process and required me to call Microsoft support. Here are several tips that may help better planning such an upgrade. This post assumes that you have already done your homework and are ready to get going.
  1. After upgrading to SPF, you will find that if you need your PDF documents searched you have to further upgrade to Search Server 2010 Express.
  2. Search Server 2010 Expresshas several advanced features such as the enterprise search. You get a search administration page where you can configure advanced search options.
  3. Verify that all you extra Web Parts and solutions are supported. uninstall, if possible, unsupported ones otherwise you may end up with a failure when the SharePoint Products and Techologies wizard runs and completes the process. In such a case you will need to re-run it from the command line / powershell. I had several solutions from codeplex that I would have better removed beforehand.
  4. If you were running Reporting Services reports on SQL 2005 they will not be running anymore. Remove all related web parts before the upgrade. I had to keep WSS 3.0 running on the original server as a separate farm just tokeep these reports going.
  5. When upgrading from SPF to Search Server, make sure that you don't have a WSS 3.0 installed side by side on this server. I had to uninstall everithing, remove WSS 3.0 that was accidentally installed on this server, and reinstall SPF and then upgrade again to Search Server 2010 Express. To remove WSS 3.0 was not a piece of cake.
  6. If you have processes that export to Excel large lists or smaller ones with many columns you may end up with empty lists / tables. This looks like a bug MS needs to fix. I had to split my views to either contain less entries ot less columns and combine the results in Excel. Not an exciting workaround experience.

Monday, January 03, 2011

PDF Search in SharePoint Foundation 2010

Consider this tip before upgrading your WSS 3.0 to SharePoint Foundation:

If PDF search is important in your company you would better upgrade to Search Server 2010. In SharePoint Foundation you can't configure the search service to include PDF iFilter indexing.

Error when Designing a Custom Data Form in SharePoint Foundation 2010

If you upgrade your WSS 3.0 to SharePoint Foundation and have custom forms with too many columns you ma gett into troubles (as of 1.1.2011, because I am sure that this is going to fixed in the next CU).

All worked fine for me when adding columns to the form until I suddenly received an error:

"Unable to display this Web Part. To troubleshoot the problem, open this Web page in a Microsoft SharePoint Foundation-compatible HTML editor such as Microsoft SharePoint Designer. If the problem persists, contact your Web server administrator.

Correlation ID:somestring"

It turned out that after I exceeded 64 columns I received the error. Removing some columns brought back the form too life. There was one reference to this issue which was answered by Microsoft that indeed this is a problem and the current workaround is to remove the description control to free more space for columns. This tip didn't work for me. Here I quote the answer:

"We have found you can remove the sharepoint:fielddescription control to help increase the number of fields on the web part before it errors out.

To read the original post click here.