Tip: Moving folders in SharePoint

My easiest way for doing this is to open the document library within the Windows Explorer using the button: "Open with Explorer"

- Make sure that you are using IE 32 bit.

You can know that by opening the Task manager and checking the process name, if suffixed by *32, then it is the 32 bit version of browser.

By default, usually the 32 bit version from the browser is launched.

- Don't use compatibility mode while opening the SharePoint site.

SharePoint 2010: Format Form View date using xsl

Microsoft SharePoint Designer 2010:

<xsl:value-of select="ddwrt:FormatDateTime(string($thisNode/@*[name()=current()/@Name]) ,1033 ,'dd-MMM-yyyy ')"/>

Microsoft Access: Error copying data to Sharepoint

Error Reproduction:
1) Open Excel file in Access
2) EXTERNAL DATA --> More --> SharePoint List


Error message:
There was an error copying data to a SharePoint list.Duplicate output destination 'Title'.

Workaround:
In my case that was a column with the title "title", just by removing it from the source Excel sheet, the export completed successfully, and even with the column title in the destination!

Another recommendation I read somewhere was to rename the Excel sheet filename to eliminate any special characters, which wasn't my issue.

Astonished: SharePoint 2013 support for Windows Server 2012 R2

Un-supported!!!

Leaving the rest for the readers imaginations!

http://support.microsoft.com/kb/2891274/en-us

Options for accessing \ reporting for SharePoint Lists

My research revealed that there is no built in feature to do it, so you have to implement your own technique. I have got into the following options, with my recommendation for the first one:

1) SSIS

http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652

2) Using the supported .NET API's for SharePoint.

http://splistwithsqlclr.codeplex.com/

3) Linked server:

http://easepoint.blogspot.com/2012/05/how-to-pull-sharepoint-list-data-from.html

http://weblogs.sqlteam.com/jhermiz/archive/2007/08/15/60288.aspx

Difference between SharePoint "View Only" & Read permissions

View Only: Can view all site objects within the application; however, unable to open content within client side applications.
Quote:
"If the document has a server-side file handler available, they can only view the document using the server-side file handler."
UnQuote


Read: View Only + open content within client side applications, such as word documents from Ms Office Word application on the client.