“A duplicate field name “” was found” Error In SharePoint 2010

I was recently Exporting and Importing a SharePoint 2010 Site Collection in my SharePoint environment and I ran into  this error when trying to Import the Exported Site Collection into a brand new Site Collection:

“A duplicate field name “” was found”

If you run into this problem, to determine what duplicate field name its causing this error, run this PowerShell script.

1.  Open up notepad, paste the script, change the Get-SPWeb and the “” attributes and save the file with the .ps1 extension.
$web = Get-SPWeb “http://portal”
foreach ($field in $web.Fields)
{
if($field.Id -eq “”)
{
write-output “Title: $($field.Title) | ID: $($field.Id)”
}
}
$web.Dispose()

2.  Open up SharePoint 2010 Management Shell, change directory to the location you saved the .ps1.
3.  Execute the .ps1
4.  Once Executed you will see the name of the duplicate field and its ID.

Now you can go back to your Site Collection and delete that duplicate field, and try your Export/Import again.