sharepoint interview questions with answers: ListVsLibrary

<<Previous post>>

Move documents between document libraries along with versions?

You can only copy the documents to others along with major version only.

Exception: “The data source control failed to execute the update command”

Got the above exception while trying to attach the file to the list item in MOSS2007

The reason for the exception is attaching file name exceeded the limit (max size limit for single file is 128 characters).

Exception: “The specified file or folder name is too long. The URL path for all files and folders must be 260 characters or less (and no more than 128 characters for any single file or folder name in the URL). Please type a shorter file or folder name”

By default, SharePoint limitation for Size of URL is 260 characters.

Microsoft recommended size limit for single file name is 128 characters and URL limit is 260 characters. 

I have uploaded one document to the document library and when I open it through browser the size of the URL is 258 characters(max limit 260) and later on I have changed the web application “http://India.com” tohttp://allindia.test.IND.com and now my the document size of the URL is 263 characters(means exceeded the limit).

As per my understanding: you can’t edit/download the document but we can view the document through browser.

Copy/Move items from one list to another list in sharepoint

Scenario:

List AA fields: Name, Title, User Name, Religion, Qualification.

List BB fields: Name, Title, User Name, Qualification, Designation, Salary and Description

Common field names: Name, Title, user name, Qualification

Now, I want to copy the common field values from List AA to List BB.

Approach:

//Read the list item values by ID and add the common field values as new item into the another list

SPListItem spLstItemsAA = listNameAA.GetItemById(ItemID); //ItemID of List AA

SPListItem spLstItemBB = list.Items.Add();

foreach (SPListItem spLstItemAA in spLstItemsAA.ListItems)

{

       for (int i = 0; i < spLstItemAA.Fields.Count; i++)

       {

          if ((!spLstItemBB.Fields[i].Hidden) && (!spLstItemBB.Fields[i].ReadOnlyField) &&    

                                  !(customfields.Contains(item.Fields[i].Title)))

           {

               spLstItemBB [item.Fields[i].Title] = spLstItemAA [item.Fields[i].Title];

             }

        }

 }
 spLstItemBB ["Salary"] = "50k";
spLstItemBB ["Description"] = "sharepointquicksolutions.blogspot.in ";
spLstItemBB.Update();

Condition#1: !spLstItemBB.Fields[i].ReadOnlyField

Condition#2: !spLstItemBB.Fields[i].Hidden

The above 2 conditions are used for to skip the read only and hidden fields.

Note: By default, every sharepoint list and library will have the below fields.

SharePoint administrator interview questions and answers: Recycle Bin3

<<Previous page>>                                                                                            

<<Next Page>>

Is it possible to re create the same site collection after immediate deletion of this?

We can recreate the site collection after immediate deletion of site but before starts we have to perform either of the below two actions otherwise you will get the below exception:

               "A site collection with the same URL is already in the Recycle Bin"

Action#1: Manually starts the “Gradual site delete:” timer Job.

Action#2: Return the “GradualDelete” parameter a $False in the PowerShell

Note: Microsoft recommending does not use the action#2 for in case of deleting the site collection which has larger volume. Reason it increases the load on the system during the deletion process.

I delete a site which has other sub sites. Now, is it possible to restore the deleted sub sites? I mean is it possible to restore the child sites without first restoring the parent sites.

Remember, Restore a child of site that has also been deleted, you need to restore the parent first. For example: If you try to restore “/sites/site1/subsite1/subsite2/sub3” before restoring the parent /sites/site1/subsite1/subsite2”, nothing happens.

Getting the exception “Specified method is not supported” while trying to delete the site?

Upgrade your databases to SP1.

What is the method to delete all the deleted site collections in web application?

Method to delete all the “deleted” site collections under a specified web application.

Get-SPDeletedSite -webapplication http://sharepoint | Remove-SPDeletedSite

Note: You will be prompted to delete them one by one, if you want it to run through them all without further prompts just enter the letter “A”

How to delete site that has other sub sites sharepoint?

SharePoint will give error “you can’t delete a site that has sub sites when we try deleting a site having sub sites”.
Good tip to overcome this and delete the site along with sub sites is using Site content and structure

In SP2007: using stsadm cmd, you cannot delete the sub site if it contains other sub sites.

Scenario on Office 365:

Deleted site collections go into the site collection Recycle Bin and are retained for a 90 day period. If you accidentally delete a site collection, it can be restored from the site collection Recycle Bin by a site collection administrator within 90. If you need a site collection restored after this 90-day period has elapsed, it can be restored by Microsoft within 14 days by contacting Office 365 via a Service Request.

<<Previous page>>                                                                                            

<<Next Page>>

Please provide your valuable feedback if it's really helps you.

List doesn’t exist. The page you selected contains a list that doesn’t exist. It may have been deleted by another user

Recently I encountered the below issue while trying to recreate the same document library from the template.
“List doesn't exist. The page you selected contains a list that doesn’t exist. It may have been deleted by another user.”

Scenario: I got a requirement like recreate the same document library which is already present.
Approach: Save that document library as template and recreate wherever/how times you want. I did the same thing. But I got the above exception when I tried to recreate the same document library by referring the template.

Solution: Check the enterprise keyword column is used in the document library. Delete it and recreate it again.

I did the same thing and it’s works fine.

-Thanks,
sasi Kumar Reddy