Young's SharePoint: 2012

Tuesday, November 20, 2012

Deleting the SharePoint2010 Search service application

Deleting the SharePoint2010 Search service application

Posted July 18, 2011 by Gangadhar Kotu in SharePoint Server 2010. Tagged: Configuration, Delete, Search, SharePoint Server 2010. Leave a Comment

To delete the Search service application, perform the following.

Go to Central Administration
Click on ‘Manage Services applications’ under Application Management.
Select the ‘Enterprise Search Service Application’ from the list of service applications. The name may differ as per your configuration.
Click on ‘X’ Delete button from the Ribbon.
Check the ‘Delete the content database as well’ option from the diaglog.
Click OK.

While deleting the search service application, the page hangs and keeps showing the same messaging like “Deleting the service application…..”. Even if you leave it untouched for hour or two or three like that… nothing happens, it would just hang on from the Central administration.

In such case, perform the below operations to get them cleaned fully from the Farm.

Get the Search Service application Id – You would get it when you click on the Search Service application from the Manage Service Applications page.
Execute the following STSADM command

Stsadm -o deleteconfigurationobject -id f1d41cf0-50d0-4fcc-9087-344103757277

Connect to the DataBase Server
Delete the Search Service Application Specific databases (CrawlStoreDB, Application_DB and PropertyStore_DB ) manually.

Now that the Service application has been cleaned successfully. You could go ahead and configure the Search service application now.

Note: STSADM command is still powerful in this case over PowerShell Command. Here is the PowerShell command as an alternative:

$spapp = Get-SPServiceApplication -Name "Enterprise Search Service Application"

Remove-SPServiceApplication $spapp -RemoveData

http://subhashkotu.files.wordpress.com/2011/07/removingsearchserviceappusingpowershell.png?w=570&h=74

This is still taking 15 and more… and executing..

Wednesday, August 15, 2012

Link to JQuery Library

Go to jquery.com and download the latest jQuery library to your desktop. You want to get the compressed production version, not the development version.
Open SharePoint Designer (SPD) and connect to the root level of your site's site collection.
In SPD, open the "Style Library" folder.
Create a folder named "Scripts" inside of the Style Library.
Drag the jQuery library JavaScript file from your desktop into the Scripts folder.
In the Scripts folder, create a new JavaScript file and name it (e.g. "actions.js").
Open your master page file in SPD.
Within the <head> tag of the master page, add a script reference to the jQuery library just above the content place holder named "PlaceHolderAdditonalPageHead" (and above your custom CSS references, if applicable) as follows:
<script src="/Style%20Library/Scripts/{jquery library file}.js" type="text/javascript"></script>
Immediately after the jQuery library reference add a script reference to your custom scripts file as follows:
<script src="/Style%20Library/Scripts/actions.js" type="text/javascript"></script>

Wednesday, August 8, 2012

Hide First Tab in SharePoint 2010 Navigation and Comment & Rating

I created a blog post on this for SharePoint 2007 HERE: But SharePoint 2010 is a bit more complex. Since it uses UL’s and Li’s for it’s navigation it is a bit harder to hide just one element.

You will notice that the Home tab actually is the first node and then has a child UL which represents the rest of the navigation Items. So the approach is to hide the first <li> <a> (display: none) and then simply just use (display:block ) to show the hidden <ul> <li> <a> tags.

Here is the CSS you could use to hide just the first node (home) tab in a SharePoint 2010 application:

.s4-tn li.static > a{
display: none !important;
}
.s4-tn li.static > ul a{
display: block !important;
}

As well as, if you want to remove "Comment and Rating" as shown below, please add the following code.

.s4-socialdata-notif
{
display: none !important;
}

Monday, July 30, 2012

SharePoint 2013 OOB Look and feel with Publishing Portal template

Finally, I could see an initial screen of SharePoint 2013.

SharePoint Server 2013 Installation error

<Summary>

The solution to this can be found on this technet link. It’s quite simple (once you know it). Open your commandline prompt and navigate to “C:\Program Files\Common Files\microsoft shared\Web Server Extensions\15\BIN”

There you execute the command:

psconfig.exe -cmd Configdb create SkipRegisterAsDistributedCacheHost

Please see more details on this link below.
http://www.alexandervanwynsberghe.be/sharepoint-foundation-2013-installation-error/

Friday, July 27, 2012

Migrate SharePoint List Templates STP’s from SharePoint 2007 to SharePoint 2010

Rename the original .STP to .CAB
Extract its manifest.xml to a local folder.
Search for the ProductVersion element. This should have a value of 3
Change its value to 4

5. Repackage the manifest.xml into a .CAB. I've done this by using makecab.exe in the C:\Windows\System32 folder

Syntax: makecab.exe {workingfolder}\manifest.xml {workingfolder}\{template-name}.cab

6. Change the generated cabinet's extension from .CAB back to .STP and upload it into the _catalogs/lt

Programmatically get InternalFieldName

SPListItem item = GetMyItem(someParameter);string itemInternalName = item.Fields["Field Display Name"].InternalName;
string theValueOfTheFieldWeWant = item[internalName].ToString();

Wednesday, July 25, 2012

Enable reservation of resources in a calendar

The group calendar feature enables you to reserve resources, such as conference rooms and audio-visual equipment. For example, you can know the availability and reserve a conference room when you are schedule a meeting. You can also reserve just a resource, such as teleconferencing equipment.

The following steps must be completed before resources can be reserved.

In this article

Step 1: Activate the Group Work Lists feature for the site

Step 2: Enable resource reservation for a calendar

Step 3: Add resources to the Resources list

Step 4: Group resources in the Resources list

Find more information about calendars and related features in the See Also section.

Step 1: Activate the Group Work Lists feature for the site

Note To activate a site feature, you must have at least the permissions obtained by being added to the default <Site Name> Owners SharePoint group for the site.

Click the Site Action menu and then click Site Settings.

Under Site Actions, click Manage site features.

Activate Group Work Lists.

Step 2: Enable resource reservation for a calendar

Note To change list settings you must have at least the default Designer permission level, or the equivalent.

In the calendar, in the ribbon, click the Calendar tab, and then click List Settings.

On the List Settings page, click Title, description, and navigation.

On the General Settings page, in the Group Calendar Options section, set Use this calendar for Resource Reservation to Yes, and then click Save.

Step 3: Add resources to the Resources list

Note To add items to a list, you must have at least the permissions obtained by being added to the default <Site Name> Members SharePoint group for the site.

Click the Site Actions menu and then click View All Site Content.

On the All Site Content page, in the Lists section, click Resources.

Important Resources is a default list for most sites. If the Resources list does not exist on your site it must be created.

On the Resources page, click Add new item.

In the Resources dialog, type the Name for the resource, add an optional descriptions, and then click Save.

Repeat the procedure to add additional resources to the list.

Following is an example of a Resource list created using the previous procedure,

Top of Page

Step 4: Group resources in the Resources list

If you have many items of one type, such as conference rooms, or many different types of resources, you might find it helpful to create groups for the resources. When someone is looking for a conference room or audio-visual equipment, they only have to view the type of resources they are looking for.

Note To add items to a list, you must have at least the permissions obtained by being added to the default <Site Name> Members SharePoint group for the site.

From the Resources list, in the ribbon, point to New Item, click the down arrow, and then click Resource Group.

In the Resources – New Item dialog box, do the following:

Type the Name for the group, such as Conf Rooms.

Select the resources you want to add to the group and click Add. You can hold down the CTRL key to select multiple resources at the same time.

Type an optional description for the group.

Click Save.

Create a Template from an Existing SharePoint 2010 Team Site

In order to create a site template from an existing SharePoint 2010 Team site, first of all, you need to deactivate "SharePoint Server Publishing" features under Manage site features. Without deactivation of this feature, you could not see "Save site as template" link.

When you clicking on Save site as template, you will see the following screen.

If you use this site template in different portal, add this site template under Look and Feel > Page layouts and site templates.

Monday, July 23, 2012

SharePoint 2010 – 403 error when updating metadata

I have spent a month troubleshooting a crazy problem with SharePoint 2010, stumping everyone that worked on it. The problem was just resolved, and it involves something I’ve never seen before, so I thought I would share so that the solution is out there on the intarwebs :)

Environment

I have a large document library, using managed metadata columns and metadata navigation. I had created some custom term sets at the site collection level, which were consumed by site columns in my document library. My users were all granted contributor permissions to the library, and could successfully upload documents into the document library.

Symptoms

Although users could upload to the library, they could not edit the properties of documents they had just uploaded. When trying to do so, they would receive an IIS 403 (access denied) error as below. Strange, as they had the right permissions, and this was an IIS 403 error, not a standard SharePoint access denied message.

Users would also be able to browse the document library with no problems, but if they tried to navigate via the metadata navigation, they would again receive the 403 access denied error. Strange… users could see ALL documents, but not a filtered view.

Everything worked fine for site collection administrators (one of the support folks just suggested that I make all site collection users to be site collection admins, but I did not think that was a very good idea ;)

Resolution

The common thread for both of these issues was the managed metadata. Users did have permissions in the library, and to the managed metadata service. It turns out that SharePoint 2010 has a hidden list at the site collection level called… appropriately enough, “TaxonomyHiddenList”. You can access this by going tohttp://servername/sitecollectionname/Lists/TaxonomyHiddenList/. As near as I can figure, this list holds all of the taxonomy items at the site collection level. You can visit and see all sorts of back-end information that probably means something to a programmer, but absolutely nothing to me.

In any case… my issued was caused by the fact that this list was not inheriting permissions from the site collection. Once I changed the permissions for this list to inherit from the site collection, everything started working. Good times! Hope this helps someone.

*Update: I spoke with the developer in charge of this feature (make sure to add the Microsoft Enterprise Content Management (ECM) team blog to your RSS reader BTW). This list should not inherit permissions from the site collection, but it SHOULD have read permissions for all authenticated users (this permission was missing in my case).

Friday, July 20, 2012

Programmatically create List during an initial addition using SharePoint 2010 Visual Web Part

The following code can create the list when the web part is inially added to the web part zone:

using System;
using System.ComponentModel;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using Microsoft.SharePoint.Utilities;
using Microsoft.Office.Server.UserProfiles;
using Microsoft.Office.Server;

namespace USRDC.WebParts.DocAuthorOrganizer
{
    [ToolboxItemAttribute(false)]
    public class DocAuthorOrganizer : WebPart
    {
        // Visual Studio might automatically update this path when you change the Visual Web Part project item.
        private const string _ascxPath = @"~/_CONTROLTEMPLATES/USRDC.WebParts/DocAuthorOrganizer/DocAuthorOrganizerUserControl.ascx";

        private String primaryAuthorList = "Primary Author";
        [WebBrowsable(true),
        WebDisplayName("List Name"),
        WebDescription(""),
        Personalizable(PersonalizationScope.Shared),
        Category("Settings"),
        DefaultValue("Primary Author")
        ]
        public string PrimaryAuthorList
        {
            get
            {
                return primaryAuthorList;
            }
            set
            {
                primaryAuthorList = value;
            }
        }
        private int rowLimitPerPage = 2000;
        [WebBrowsable(true),
        WebDisplayName("Row Limit"),
        WebDescription(""),
        Personalizable(PersonalizationScope.Shared),
        Category("Settings"),
        DefaultValue(1000)
        ]
        public int RowLimitPerPage
        {
            get
            {
                return rowLimitPerPage;
            }
            set
            {
                rowLimitPerPage = value;
            }
        }
        private string sharePointGroup = "OperationalReports";
        [WebBrowsable(true),
        WebDisplayName("SharePoint Group Name"),
        WebDescription(""),
        Personalizable(PersonalizationScope.Shared),
        Category("Settings"),
        DefaultValue(1000)
        ]
        public string SharePointGroup
        {
            get
            {
                return sharePointGroup;
            }
            set
            {
                sharePointGroup = value;
            }
        }
        public bool isconfig;
        private Button btnSave;
        protected void BtnSave_Click(object sender, EventArgs e)
        {
            SPWeb web = SPContext.Current.Web;
            web.AllowUnsafeUpdates = true;
            if (!Utilities.ListExists(web, primaryAuthorList))
            {
                // Create a list
                Guid listId = web.Lists.Add(primaryAuthorList, "A list for storing a primary author for document library", SPListTemplateType.GenericList);
                SPList newList = web.Lists[listId];
                newList.OnQuickLaunch = false;
                newList.ContentTypesEnabled = true;
                newList.EnableFolderCreation = false;
                newList.Update();

                SPListItem item = newList.Items.Add();
                item["Title"] = "Young Ryu";
                item.Update();

                // Set DefaultView with AllItems
                SPView listView = newList.DefaultView;
                listView.Update();
            }
            isconfig = false;
        }
        protected override void CreateChildControls()
        {
            Control control = Page.LoadControl(_ascxPath);
            Controls.Add(control);
            WebPartManager wp = WebPartManager.GetCurrentWebPartManager(Page);
            if (wp.DisplayMode == WebPartManager.BrowseDisplayMode)
            {
                btnSave = new Button();
                btnSave.ID = "btnSave";
                btnSave.Text = "Submit";
                Panel pnl1 = new Panel();
                LiteralControl ltc = new LiteralControl("<Div class='ConfigWebPartTitle'>The following SharePoint List must be created:</Div>");
                pnl1.Controls.Add(ltc);
                ltc = new LiteralControl("<Div class='ConfigWebPartText'>Lists: " + primaryAuthorList + "</Div>");
                pnl1.Controls.Add(ltc);
                pnl1.Controls.Add(btnSave);
                btnSave.Click += new EventHandler(BtnSave_Click);
                this.Controls.Add(pnl1);
                isconfig = true;
                if (!Page.IsPostBack)
                {
                    if (Utilities.ValidateCollateral(SPContext.Current.Web, "Item", primaryAuthorList))
                    {
                        this.Controls.Remove(pnl1);
                        isconfig = false;
                    }
                }
                else
                {
                    if (Utilities.ValidateCollateral(SPContext.Current.Web, "Item", primaryAuthorList))
                    {
                        this.Controls.Remove(pnl1);
                        isconfig = false;
                    }
                }
            }
        }
    }
}

Utilites Class for supporting SharePoint

Here is the code: Get File Size By

// Added by Young Ryu
public static string GetFileSizeBy(string fileSize)
{
    string[] sizes = { "B", "KB", "MB", "GB" };
    double len = Convert.ToDouble(fileSize);
    int order = 0;
    while (len >= 1024 && order + 1 < sizes.Length)
    {
        order++;
        len = len / 1024;
    }
    string result = String.Format("{0:0.##} {1}", len, sizes[order]);
    return result;
}

Here is the code: SharePoint domain user contains in Active Directory.

// Added by Young Ryu
public static bool IsUserContainedToAD(SPWeb myWeb, string user)
{
    try
    {
        SPUser _user = myWeb.EnsureUser(user);
        return true;
    }
    catch (SPException ex)
    {
        return false;
    }
}
Here is the code: Identify the user is FTE

//Added by Young Ryu
public static bool IsUserFTE(string strAuthor)
{
    string employeeID = strAuthor.Remove(0, 1);
    double Number;
    bool isNumber = double.TryParse(employeeID, out Number);
    if (isNumber)
        return true;
    else
        return false;
}

Here is the code: Group Exists in Web

//Added by Young Ryu
//Check if a group exists in a website
public static bool GroupExistsInWebSite(SPWeb web, string name)
{
    return web.Groups.OfType<SPGroup>().Count(g => g.Name.Equals(name, StringComparison.InvariantCultureIgnoreCase)) > 0;
}

Here is the code: Group Exists in Site Collection

//Added by Young Ryu
//Check if a group exists in a site collection
public static bool GroupExistsInSiteCollection(SPWeb web, string name)
{
    return web.SiteGroups.OfType<SPGroup>().Count(g => g.Name.Equals(name, StringComparison.InvariantCultureIgnoreCase)) > 0;
}

Here is the code: Get InternalFieldName programmatically

Check if the user has a permission

Here is the code to check if the user has a permission to see the web part:

Set the fields in Document Library on Page Load

Here is the screenshot that sets the following columns in Document Library:

Type
Name
Author
Modified By

Here is the code: