Sharepoint Solutions Repository

Error : The attach operation cannot continue because another object in this farm already contains the same ID

In SharePoint 2013. I tried to remove the content DB from the web application by using the remove database option.

after this, I tried to add the content database to the same web application again, but I was continuously getting the error : "The attach operation cannot continue because another object in this farm already contains the same ID"

I found some powershell, through which you can get rid of this problem. it is for sure that the content DB is attached to the web application but some how it is not visible and that's why I was not able the content DB to the web application.

To check if the Database is already connected to the web application, use the below PS command.

Get-SPDatabase | where{$_.Name -eq “Name of your WEB Application“}

This PS will give you the result, if the content DB is already attached.the details provided by this command

Name

Web Application

Server

Current Site count.

Now you can take the ID of this content DB and use the below command to remove this DB from Web application.

Note: You can also use name but sometime name doesn't work properly.


Dismount-SPContentDatabase 12345678-90ab-cdef-1234-567890abcdef
http://technet.microsoft.com/en-us/library/ff607764.aspx

 
This way it will dismout the content DB and now you can add the

content DB to the web application from central admin or use the below

command to mount it

Mount-SPContentDatabase “MyDatabase” -DatabaseServer "MyServer" -WebApplication http://sitename
http://technet.microsoft.com/en-us/library/ff607581.aspx

Get Started with Powershell for SharePoint

Below is the nice link to get start with SharePoint powershell..

simple-talk Link

SharePoint 2010: Content Type Hubs

Sharepoint 2010 and 2013 has a new feature called "Content type hubs". where we can share the same content type between multiple web application. the use of this feature is to reuse the already created content type from one web application to another web application.

below is the nice atricle about this.

Article 1

SharePoint 2013 Basic Search Center Navigation Settings Breaks in June 2013 CU

see the below link for more details..

Nintex Workflow -Display Item Attachment in email or Request Data form

I had a requirement where my customer wants me to display the list item attachment to the "Request Data" form of Nintex workflow.

when a task will be created for first user, he/she should be able to see the attachment tag to the list item. I am not sure if there are many ways to do that, but after checking the nintex website, I found the below solution and found it workable for my case.

Please click on the below link and see the full details about how can you achieve this.

Display list item attachment on Email or Request Data form

Date Format using javascript

Below is the code to change different format of date using a javascript. If you have a date in a string format, you can use the string functions of javascript to give any format you want.

I have a date format which is in m-d-yyyy format and I want to change it in dd-mm-yy format.

$(document).ready(function()

{

var vArticledate=$("#datefield").text();

var dt = vArticledate.split("/");

var iMonth=dt[0];

if(iMonth.length<2)

iMonth="0"+iMonth;

var iDay=dt[1];

if(iDay.length<2)

iDay="0"+iDay;

var iYear=dt[2];

iYear = iYear.substring(iYear.indexOf("0")+1,iYear.length);

document.getElementById('datefield').innerHTML = "<b>"+iDay +"-"+iMonth+"-"+iYear+" </b>";

})

</script>

PowerShell - Update Same ElementTag in many XML files using PowerShell

If you want to update the same ElementTag in many xml files, below is the PowerShell code.

$location = "Specify your location here"
$items = Get-ChildItem -Path $location
foreach ($item in $items)
{
# if the item is a directory, then process it.
if ($item.Attributes -ne "directory")
{
if ($item.Extension -eq ".xml")
{
Write-Host $item.Name
$file = $location + "\" + $item.Name
$file = $item.Name
$xml = New-Object XML
$xml.Load($file)
$xml.ProjectDescription.ChildNodes.Item(0)."#text" = "Value updated by Powershell"
$xml.Save($file)
}
}
}

SharePoint 2007 – Hiding fields on NewForm.aspx and EditForm.aspx, the easy way

To hide fields in a SharePoint 2007 form, follow these steps (I will use the NewForm.aspx in my example)

1. Open SharePoint Designer and navigate to the site that contains the list or document library you wish to customize.
2. Expand the folder named “Forms” under the desired list or document library. You should see about seven .aspx pages (AllItems.aspx, EditForm.aspx, NewForm.aspx, etc)
3. Open the NewForm.aspx page and switch to the “code” view to edit the HTML of the page.
4. Paste the JavaScript code immediately below the the following HTML tag This will add the JavaScript to the HTML inside the content placeholder tag. Note: be sure to include the entire script below, including the

for more details, use the following link :
http://sharepointsherpa.com/2008/08/26/sharepoint-2007-hiding-fields-on-newformaspx-and-editformaspx-the-easy-way/

Renaming folder also changes modified dates of documents

I have seen that many a times when you try to modify the folder in a document library, it also change the modified date of the documents inside it.

see the below link to get this issue in details where many people face this issue.
http://social.technet.microsoft.com/Forums/en-IE/sharepointgeneral/thread/d80f5023-51cf-46ee-9e2f-6d1a1290f564

Microsoft product group is working on this issue to fix this but no updates till now.

The actual issue is:

Rename

To find out Version number of a DLL using Command Prompt

1- Open a Visual studio command prompt.
2- Type the command sn -T yourdllname.dll

Simple !! :)