All About SharePoint

Liedong(Ken) Zheng,SharePoint Leader at SIMPLOT

Archive for the ‘Sharepoint’ Category

SharePoint survey error – duplicate values

Posted by ken zheng on March 25, 2013

One day, a user is getting errors for a survey when a responder changes their choice on a Choice type question.

I have looked the survey settings, there are a few columns are Choice that only have Yes or No choice.

image

The cause of the error is that you set the column as unique, so the user cannot select the same value of another column twice. There has another response in this survey which had selected the same value.

image

 

So just changed the “Enforce unique values” to No, the problem is solved.

Posted in Sharepoint | Tagged: | Leave a Comment »

Id ‘Safari2′ has already been specified and must be unique

Posted by ken zheng on March 4, 2013

one day, when I tried to edit the compat.browser in the root directory of the web application (C:\inetpub\wwwroot\wss\VirtualDirectories\<port number>\AppBrowsers). I made a copy of the original file that cause the error. so remove the backup as it should only 2 files compat.browser and compat.moss.browser

Posted in Sharepoint | Tagged: | Leave a Comment »

The g_instanceId undefined error in Meeting Workspaces

Posted by ken zheng on February 20, 2013

 

If you’re utilizing a custom master page derived from the OOB v4.master page, you’ll probably notice Re-occurring meeting workspaces begin to fail when trying to navigate between dates of said workspace.  To reproduce the problem, simply create a calendar, add a re-occurring event to the calendar and choose the option to use a meeting workspace to manage the events.  Click through to the workspace and then use the date navigation in the left hand side nav bar… If you haven’t implemented the fix below, you will see a JavaScript ‘g_instanceId is undefined’ or similar error.

image

To resolve, edit your custom masterpage and add the ‘Meetings’ Tag Prefix below the ‘Microsoft.SharePoint’ namespace import declaration as per below

<%@ Import Namespace="Microsoft.SharePoint" %>
<%@ Register
Tagprefix="Meetings"
Namespace="Microsoft.SharePoint.Meetings"
Assembly="Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" %>

.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }

then, simply add the meetings ‘PropertyBag’ web control directly after the opening <body> tag:

<body scroll="no" onload="if (typeof(_spBodyOnLoadWrapper) != 'undefined') _spBodyOnLoadWrapper();" class="v4master">
 
<Meetings:PropertyBag ID="PropertyBag1" runat="server"/>

.csharpcode, .csharpcode pre
{
font-size: small;
color: black;
font-family: consolas, “Courier New”, courier, monospace;
background-color: #ffffff;
/*white-space: pre;*/
}
.csharpcode pre { margin: 0em; }
.csharpcode .rem { color: #008000; }
.csharpcode .kwrd { color: #0000ff; }
.csharpcode .str { color: #006080; }
.csharpcode .op { color: #0000c0; }
.csharpcode .preproc { color: #cc6633; }
.csharpcode .asp { background-color: #ffff00; }
.csharpcode .html { color: #800000; }
.csharpcode .attr { color: #ff0000; }
.csharpcode .alt
{
background-color: #f4f4f4;
width: 100%;
margin: 0em;
}
.csharpcode .lnum { color: #606060; }

 

You can Edit the Master Page via SharePoint Designer and set the page to custom master page.

 

image

Posted in Sharepoint | Tagged: | Leave a Comment »

Welcome 2013

Posted by ken zheng on February 19, 2013

It is 2013 now and SharePoint 2013 will be in release very soon. So it is time to speed up with the 2013 training. Below is the links for me to read:

you start your SharePoint 2013 training roadmap:

  • Training
  • Information on TechNet and MSDN
  • Software and SDK downloads
  • Visio diagrams
  • Key articles that will be of interest to ITPros and Developers.

SharePoint 2013 Preview Technical Resources

Now available on MSDN: deep training on SharePoint Server 2013! These multi-module, comprehensive training sessions are available for IT pros and developers.

SharePoint 2013 training for IT pros

http://bit.ly/PigeB8 or http://msdn.microsoft.com/en-us/sharepoint/Fp123606

Here are the videos of all sessions for this training course.  These were based on information a little before Beta 2 shipped.  Learn to deliver collaborative capabilities with the new SharePoint, Project, and Visio. Also learn how to efficiently share, build, and organize project work within your team.

For background on this class see the following blog post by one of my fellow course instructors:

http://blogs.msdn.com/b/vesku/archive/2012/07/17/sharepoint-2013-it-pro-and-developer-training-materials-released.aspx

Developer training

http://bit.ly/MXe9Lm or http://msdn.microsoft.com/en-US/office/apps/fp123626

Developer-focused how to training and walkthrough videos about Office 2013 and SharePoint 2013 including changes and new features for search, social, ECM, WCM, and REST. Learn about apps for Office and SharePoint.  Learn how to use the new Office and SharePoint development scenarios to efficiently build solutions. These modules are designed for Office and SharePoint developers experienced in developing, deploying, and supporting Office and SharePoint customizations

MSDN

Apps for Office and SharePoint

The new cloud app model gives you maximum choice and flexibility to build a new class of apps for Office and SharePoint using familiar languages, tools, and hosting services. Find out more at the Apps for Office and SharePoint Developer Center.

SharePoint 2013
Find developer documentation and SDKs, reference content, how-tos, and walkthroughs for the most recent version of SharePoint including:
SharePoint 2013 development overview
What’s new for developers in SharePoint 2013
Related products located in other
sections of the MSDN library:

SharePoint Development in Visual Studio 11 Beta

What’s new for developers in SharePoint 2013

Learn about new features and functionality in SharePoint 2013 Preview, including the new Cloud App Model, development tools, platform enhancements, mobile apps, and more.

http://msdn.microsoft.com/en-us/library/jj163091(v=office.15)

Apps for SharePoint overview

http://msdn.microsoft.com/en-us/library/office/apps/fp179930(v=office.15)

Learn what apps for SharePoint are, why you should build them, and the concepts that are fundamental to building them in SharePoint 2013 Preview.

Start: Set up the development environment for SharePoint 2013

Learn the steps to set up a SharePoint 2013 Preview development environment by installing SharePoint 2013 Preview and Visual Studio
2012.

Sign up for an Office 365 Developer Site

Learn how to sign up for an Office 365 Developer Site to
develop, test, and deploy apps for Office and SharePoint.

SharePoint Development in Visual Studio

http://msdn.microsoft.com/en-us/library/ee330921(v=vs.110).aspx

Technet

SharePoint 2013 for IT pros

Get the IT pro resources you need to try SharePoint Foundation 2013 and SharePoint Server 2013 on-premises including details about installation, upgrade, migration, and services.

TechNet evaluation articles for SharePoint 2013 Preview

The following articles about how to evaluate SharePoint 2013 Preview are available to view online. Writers update articles on a continuing basis as new information becomes available and as users provide feedback.  Each of these documents provides a good
overview of these topics.

  1. What’s new in authentication for SharePoint 2013 Preview
  2. What’s new for Business Connectivity Services in SharePoint 2013 Preview
  3. What’s new in eDiscovery in SharePoint Server 2013 Preview
  4. What’s new for mobile devices in SharePoint 2013 Preview
  5. What’s new in records management and compliance in SharePoint Server 2013 Preview
  6. What’s new in business intelligence in SharePoint Server 2013 Preview
  7. What’s new in social computing in SharePoint Server 2013 Preview
  8. What’s new in web content management for SharePoint 2013 Preview publishing sites
  9. Changes from SharePoint 2010 to SharePoint 2013 Preview
  10. Test lab guides for SharePoint Server 2013

Downloadable content for SharePoint 2013 Preview

Download the preliminary content in the SharePoint 2013 Preview TechNet library for offline viewing.

Downloads

SharePoint 2013 Technical Library in Compiled Help

Downloadable
CHM version of SharePoint 2013 content on TechNet.

Downloadable eBook: Deployment guide for SharePoint 2013 Preview

Download this free ebook to learn how to install and configure SharePoint Server and SharePoint Foundation.

Solution:  Surface external data from AdventureWorks in SharePoint 2013 Preview and Office 2013 Preview (white paper)

Learn how to use a customer view in an external data source, configure SharePoint 2013 Preview services and accounts, choose and implement an authentication mode, define an external content type, create and authorize…

SharePoint 2013: presentation: IT pro training

Download walkthroughs, training, and reviews of new features, changes and options in Office 2013 for ITPros. 
(The zip file at the bottom of the list of downloads contains all of the presentations).

Visio Diagrams:

Design Sample: Extranet with Dedicated Zones for Authentication for SharePoint 2013 Preview

This design sample illustrates many top-level project sites with vanity URLs by using host-named sites for each project site (instead of organizing project sites underneath a top-level site collection).

Design Sample: Corporate Portal with Host-named Sites for SharePoint Server 2013 Preview

This design sample illustrates the use of host-named site collections with all sites deployed in a single web application on the farm. This method is highly scalable and is flexible in managing URLs.

Design Sample: Corporate Portal with Path-based Sites for SharePoint Server 2013 Preview

This design sample illustrates the use of path-based site collections with sites organized into dedicated web applications and a single top-level site collection per web
application.

Enterprise search architectures for SharePoint Server 2013 Preview

This design sample shows the search architecture for a variety of sizes of server farms.

Search architectures for SharePoint Server 2013 Preview

This design sample shows the search architecture for a medium size server farm.

SharePoint 2013 Preview Upgrade Process

This model explains the process that you use when you upgrade from SharePoint Foundation 2010 or SharePoint Server 2010 to SharePoint Foundation 2013 Preview or SharePoint
Server 2013 Preview.

SharePoint 2013 Preview: How to Test Upgrade

This model explains how to create a test environment to use when you upgrade from SharePoint Server 2010 or SharePoint Foundation 2010 to SharePoint 2013 Products Preview.

Back up and restore: SharePoint Server 2013 Preview

This model illustrates various ways that you can back up and restore a SharePoint environment.

Services in SharePoint Server 2013 Preview

This illustration provides information about services that are available in SharePoint Server 2013 Preview.

Test Lab Guides

Test Lab Guide:  Demonstrate Intranet Collaboration with SharePoint Server 2013 Preview

This paper helps you configure an environment to demonstrate the intranet collaboration features of SharePoint Server 2013 Preview.

Test Lab Guide:  Configure SharePoint Server 2013 Preview in a Three-Tier Farm

This paper provides a brief introduction to SharePoint Server 2013 Preview and illustrates how to create a three-tier test lab.

Test Lab Guide: Demonstrate SAML-based Claims Authentication with SharePoint Server 2013 Preview

This paper provides a brief introduction to SharePoint Server 2013 Preview and illustrates how to create a three-tier test lab that uses SAML-based claims authentication.

SDKs

SharePoint Server 2013 Client Components SDK

The SharePoint Server 2013 Client Components SDK can be used to enable remote and local development with SharePoint Server 2013

SharePoint 15 Technical Preview Interoperability API Documentation

This download provides documentation of APIs related to Interoperability with SharePoint 15.

SharePoint 2013 SDK – (coming soon)

Downloads

Download the tools, products, and resources you need to create apps for Office and SharePoint.

Software Downloads

Microsoft Office Web Apps Server Preview

…PowerPoint, Excel, and OneNote. A single Office Web Apps Server farm can support users who access Office files through SharePoint 2013 Preview, Lync Server 2013 Preview, Exchange Server 2013 Preview, shared folders, and web sites.

SharePoint Foundation 2013 Preview

SharePoint Foundation 2013 is the essential solution for organizations that need a secure, manageable, web-based collaboration platform.

Download Microsoft SharePoint Server
2013 Preview

SharePoint Server 2013 Preview is designed to bring people together to get work done. Whether you’re using it to manage your enterprise content, make it easy for business end users to share ideas and information, or help developers build innovative new applications, SharePoint Server 2013’s improvements in scale, security, and flexibility have you covered.

SharePoint Designer 2013

SharePoint Designer 2013 is the tool of choice for the rapid development of SharePoint applications.

Language Packs for SharePoint Foundation 2013 Preview

Language packs enable creation of sites and site collections in multiple languages without requiring separate installations of SharePoint Foundation 2013 Preview

Language Packs for SharePoint Server 2013 Preview

Language packs enable creation of sites and site collections in multiple languages without requiring separate installations of SharePoint Server 2013 Preview

SharePoint Online Management Shell Preview

The SharePoint Online Management Shell is a tool that contains a Windows PowerShell Module to manage your SharePoint Online subscription in the Office 365 Preview.

Microsoft Office 2013 Preview Language Pack

Microsoft Office Language Interface Pack 2013 Preview – provides a user interface for many Microsoft Office 2013 Preview programs.

Language Packs for Microsoft Office Web Apps Server Preview

Language Packs enable the installation of additional interface languages to Office Web Apps Server Preview.

MICROSOFT® SQL SERVER® 2012 SERVICE PACK 1 (SP1), COMMUNITY TECHNOLOGY PREVIEW 3 (CTP3)

…intended ONLY for those customers who are testing Business Intelligence capabilities available in Office 2013 and SharePoint 2013 public preview program. DO NOT install this early CTP3 release for general SQL Server 2012 patches and bug fixes…

Microsoft Office 2013 Audit and Control Management Server

Microsoft Audit and Control Management Server provides powerful change management features for Excel and Access files.

Posted in Sharepoint | Tagged: | Leave a Comment »

Troubleshooting FAST Search

Posted by ken zheng on June 4, 2012

It started that I found one managed property not being crawled, then I saw the full crawling have been running for a few days without completing. So below is the process I checked where is the problem.

You can check if the crawl did input by go to the crawl History

image

To make sure the FastSearch is working, here is the TechNet doc.

If the content sources stuck on “Crawling” or “Stopping”

  • Restart the FAST Search for SharePoint on the FAST search server and see if that fixes the problem.
  • Reboot the FAST search server and see if that fixes the problem.
  • Restart SharePoint Search 14 services on all SharePoint web front-ends and see if that fixes the problem. ( I will try this first)
  • Reboot all SharePoint web front-ends and see if that fixes the problem.
  • Navigate to Central Administration\Manage service application\FAST Content SSA, Reset Index and see if that fixes the problems.

Then on the Search 14 Services server I found the error in the event log:

Failed to connect to xxx:13391 Failed to initialize session with document engine: Unable to resolve Contentdistributor

It turns our my fast search cert is expired. So to re-install the cert and SSL, you can check Manage certificates (FAST Search Server 2010 for SharePoint).

then

  1. Copy the script securefastsearchconnector.ps1 from the FAST Search Server 2010 for SharePoint admin server to the SharePoint Server 2010 server. The securefastsearchconnector.ps1 script is in the installation folder, under installerscripts.
  2. Copy the certificate file FASTSearchCert.pfx from the FAST Search Server 2010 for SharePoint admin server to the SharePoint Server 2010 server. The certificate file is in the installation folder, under datadata_securitycert.
  3. Open a Microsoft SharePoint 2010 Administration Shell with the Run as administratoroption on the SharePoint Server 2010 server.Navigate to the directory where you copied the securefastsearchconnector.ps1 script and run it, replacing the necessary parameters with the values for your environment. The domain and user name should reflect the details of the user running theSharePoint Server Search 14 (OSearch14) service.
  4. .\SecureFASTSearchConnector.ps1 –certPath “path of the certificatecertificatename.pfx” –ssaName “name of your content SSA” –username “domainusername”

When prompted to enter the certificate password, enter the certificate password that you supplied when you ran the post-setup configuration of FAST Search Server 2010 for SharePoint.

Ff381261.Important(en-us,office.14).gifImportant:

The script verifies the connection to FAST Search Server 2010 for SharePoint. Therefore, make sure that all servers in the FAST Search Server 2010 for SharePoint farm are running before you run this script.

Posted in Fast Search, Sharepoint | Tagged: | 1 Comment »

Value does not fall within the expected range. Iterating SPListItems

Posted by ken zheng on April 3, 2012

I got this error when I used SPQuery to get all list items and check the version count.

foreach (SPListItem item in myItems)
{

item.Versions.Count

}

after a while searching, you have to change your code like

SPListItem itemCurr = item.ParentList.GetItemById(item.ID);

 

Below is my code to count all documents including versions

SPDocumentLibrary docLib = (SPDocumentLibrary)oSPWeb.Lists[docLibName];

                        Console.WriteLine("Library Name: " + docLib.Title);

                                              

                        SPQuery query = new SPQuery();

                        query.ViewAttributes = "Scope=\"RecursiveAll\"";

                        SPListItemCollection myItems = list.GetItems(query);

                        Console.WriteLine("total Items: " + myItems.Count);

                        foreach (SPListItem item in myItems)
                        {
                            if (!IsFolder(item))
                            {

                                SPListItem itemCurr = item.ParentList.GetItemById(item.ID);
                                Console.WriteLine("item count value: " + itemCurr.Versions.Count);
                                total = total + itemCurr.Versions.Count;
                            }
                        }

Posted in Sharepoint | Tagged: | 1 Comment »

How To Find Crawled Properties for the columns in SharePoint

Posted by ken zheng on February 27, 2012

You may find frustration when you have columns in the same name but across a few sites. When you need to map the managed property, which crawled property should I map to?

The way I found is to use U2U CAML Query to find the internal column name

image

so the crawled property will be

image

Here is the steps how you

Map a Crawled Property to Managed Properties (FAST for SharePoint – PowerShell)

Posted in Sharepoint | Tagged: | Leave a Comment »

SharePoint 2010 101 code Samples

Posted by ken zheng on February 22, 2012

It is a good start to learn some coding of SharePoint 2010

http://code.msdn.microsoft.com/SharePoint-2010-101-Code-da251182

Posted in .Net, Sharepoint | Tagged: | Leave a Comment »

SharePoint 2007 Backup Failed – Cannot open backup device

Posted by ken zheng on January 3, 2012

You may have seen this error Error: Object SharePoint_Config failed in event OnBackup. For more information, see the error log located in the backup directory. SqlException: Cannot open backup device ‘\\servername\backup\spbr0001000001.bak’. Operating system error 5(error not found).

NB: Use UNC Path ”\\172.16.5.138\c$\Temp”

Here are the steps You need to check

  • Set the SQL Server (MSSQLSERVER) Windows service to run as a domain account. Will require a restart of the service and IIS.
  • Setup sharing on the backup folder. Grant access for the identity that the Central Administration Application Pool runs under, the database SQL account, the identity that the Timer service runs under, to change and read rights.
  • On each of the SharePoint servers check you can access the share.
  • On each of the database servers check you can access the share.
  • Set the folder security, grant privledges for the identity that the Central Administration Application Pool runs under, the database SQL account, the identity that the Timer service runs under to all rights apart from Full Control.

Posted in Sharepoint, SQL | Tagged: | 1 Comment »

 
Follow

Get every new post delivered to your Inbox.

Join 28 other followers