Get Adobe Flash player

SharePoint

How to sort numeric SharePoint field

VN:F [1.9.22_1171]
Rating: 5.0/5 (1 vote cast)

Have you ever wanted to have a numeric field to sort the numbers but didn’t need the comma for the digit grouping?

Well, my tip is add a new calculated field which is based on the number field. As the formula add

Formula
=TEXT([Fieldname],”0”) 

Add the numbers of “0” of the maximum length of the digits, let’s say your biggest number is 654321 then the formula would look like

Formula
=TEXT([Fieldname],”000000”) 

This will create leading zeros on numbers like 004321 and makes the list sortable. Modify the view to just display the number field and sort by the new hidden calculated field.

File not found [solved]

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)

After importing [stsadm –o import –url http://myurl –filename d:\exports\filetoimport.cmp] a site from a SharePoint export to my SharePoint server I opend the URL and got the following error: “File not found”
File not found

After looking around I found nothing. What file could SharePoint mean? The first thing I always try is to open the “/_layouts/settings.aspx” If the page opens this is a good hint to where the problem could be. If you check the Pages library (if Publishinging Feature is activated) you will see a page with a name like Home (default) for example. This is the page the users seePageLayoutCatalog first when opening the site. This is defined under “Look and Feel” – Welcome page. To every page there is a Page layout and a master page that both need to be in the gallerie in order for the page to display at all. If any of these 2 pages are not there the “File not found” error will show up. These files will not be in the export because these files are part of the file system and not the Database of the site. When you upload the files to the “Master pages and page layouts” Gallerie be sure to check the files in or the files can not be accessed. In this library you will also find the PageLayoutxxx.aspx and default.master files. The master file is set under “Look and Feel” – Master Page settings.

SharePoint authentication window pops up when opening document library in Explorer View [solved]

VN:F [1.9.22_1171]
Rating: 5.0/5 (1 vote cast)

If you want to open a document library with “Open with Windows Explorer” you use the WebDAV protocol to list the folder contents on a SharePoint. This can be very helpful if you need to copy a lot of files from or to your computer. Opening the Explorer View on a Windows 7 computer you get an logon window to enter your credentials. It works, is little annoying though. To fix this you need to change a setting in your registry:

Regedit
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\WebClient\Parameters] AuthForwardServerList

Adding the URL of your SharePoint server will automatically forward your credentials the next time (after reboot) you open the Explorer View.WebDavAuthForward

Remote Power Shell Session [gelöst]

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)

Wie bekommt man es hin mit Power Shell remote auf einem System zu arbeiten? Jeder der einen SharePoint administrieren möchte kann dies jetzt machen. Hier sind die notwendigen Schritte:

Zuerst geht es darum zu prüfen ob überhaupt Remote Management aktiv ist. dazu auf den zu verwaltenden Server per RDP und Power Shell öffnen. Ich bevorzuge die PS ISE, das ist ein Editor wo man Scripte schreiben und abspeichern kann anstatt nur eine CMD. Dann folgenden Befehl eingeben:

Power Shell Befehl
get-service winrm

Weiterlesen

SharePoint List and WebDAV

VN:F [1.9.22_1171]
Rating: 0.0/5 (0 votes cast)

WebDAV FehlerEs kommt nicht selten vor, dass Listen mit über 10,000 Einträgen im SharePoint verwaltet werden. Manche User mappen sich auch gerne ein Laufwerk auf eine Bibliothek und laden so Dokumente hoch. Kann ich auch verstehen. Zu welchem Zweck auch immer kann es sein, dass eine Fehlermeldung kommt, dass auf das Laufwerk nicht zugegriffen werden kann. “WebDavParametersis not accessible. You might not have permission to use this network resource. Contact the administrator of this server to find out if you have access permissions. A device attached to the system is not functioning.” Das Problem liegt nicht wie man vielleicht vermutet auf dem Server sondern auf dem WebDAV Client, in dem Fall der aufrufende Computer. Es gibt bestimmte Einstellungen die in der Registry die gesetzt werden müssen, dass es wieder funktioniert. In dem Screenshot rechts ist das Attribut was geändert werden muss. Dies steht unter: [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\WebClient\Parameters]

Danach is ein Neustart notwendig, dass die Einstellungen ziehen.