List view not showing all items using filter

In your SharePoint list, you have column where you want to filter content from in a list view. You create a new view and try to filter content from this column but nothing appear. Even you add column to view. However, this column show content in all items and you can sort the content and filter content using metadata navigation. You also make sure that your filter is defined properly. First this is to do is to try to see the query in SharePoint designer in list view but that doesn’t help.

The only solution is to create a new column with new name, move all content to this column, then recreate the buggy column, and move content back. Then delete the temporary column.

Only problem is when you move content your item get new version and may be workflow also run. The safe way is to disableeventfiring and disable updating the item. In addition, just preform an update to these columns. Here is PowerShell script help you move content from one column to another without having item update. When content is moved, change the column names and move content back.

So you run this script twice. Once when you move form buggy column second you move from temporary column to original column. Make sure you change column names.

Add-PSSnapin Microsoft.SharePoint.PowerShell -EA SilentlyContinue

$myAss = [Reflection.Assembly]::LoadWithPartialName(“Microsoft.SharePoint”);

$type = $myAss.GetType(“Microsoft.SharePoint.SPEventManager”);

$prop = $type.GetProperty([string]”EventFiringDisabled”,[System.Reflection.BindingFlags] ([System.Reflection.BindingFlags]::NonPublic -bor [System.Reflection.BindingFlags]::Static));

$prop.SetValue($null, $true, $null);

$listName = “ListName

$web = Get-SPWeb http://sitecollection

$list = $web.Lists[$listName]

$items = $list.items

foreach($item in $items) { $user = $item[“Lastname“]

$item[“Lastname2“] = $user

$item.SystemUpdate($false)

$prop.SetValue($null, $false, $null);

}

Good luck.

Error “This page is not using a valid pagelayout.”

This is a problem happed when you specially have upgraded from SharePoint 2007 to SharePoint 2010.

The problem is the page cannot be opened and we cannot change the layout. So here is solution.

Go to the site/page where the problem appear, in the link bar add this link /_layouts/viewlsts.asp after site link.

Click on site actions – site settings – Page layout and site templates – Make sure the page layout is here. Just in case everything fine here, click Ok.

Now let’s change the page layout:

  • Go to Site Content and Structure
  • Find the Pages library
  • Find the Pages
  • View Properties of the page
  • Edit item
  • Choose a valid page layout
  • OK

The problem should be solved.

Åpne bibliotek med Windows Utforsker støttes ikke

Åpne bibliotek med Windows Utforsker, gir oss mulighet til å slette, flytte og kopiere dokumentere enkelt og rask. Det er mange som opplever at det kommer feilmelding ved å åpne et bibliotek i Windows utforsker. Meldingen som kommer er følgende:

Klienten har ikke støtte for åpning av denne listen i Windows Utforsker. Eller på engelsk “Your client does not support opening this list with Windows Explorer”. Les mer for å fikse problemet.

Continue reading

Hei alle sammen

Hei alle sammen:)

Hyggelig at du kom innom websiden min. Jeg tenkte å blogge min erfaring og nyttig informasjon om SharePoint. Til å begynne med, har jeg tenkt å ha siden min på engelsk og mine bloggs litt blannet både på norsk og engelsk. Så blir det en del artikler om SharePoint, SharePoint designer og Office 365 frem i tiden. Yeppiii :-)