Technical: Microsoft – SharePoint – v2100 – List – Management – Deletion

Technical: Microsoft – SharePoint – v2010 – List – Management – Deletion

Introduction

I have a little assignment; and the assignment is to copy a SharePoint List from an old server to a new one.

Knowing me,  I will likely make a lot of false starts and so let me sure I will be able to remove half-way created lists.

Steps

Navigate to the Site Home

Let us navigate to our Site’s home.

Thank goodness that SharePoint has Navigational panel for sojourning back to the Site’s home page.

Here is our top panel.

TopPanel

At the top of the page we have the little folder Navigation icon folderNavigation

We will use that icon to take us to the Site’s Home page.

Access List Management

Once on the Site’s home page, we will access the List’s management tools.

Pasted below is our Site’s home page.

HomePage

The List’s page is accessible by moving our glance to the left sub-panel and clicking on the Lists hyperlink.

Select List

Here is the list of our currently established lists:

List - StandardView - Lists (include friends)

Because of the Site Template we chose when creating our “Site Collection”, we have a few standard lists:

  • Announcements
  • Calendar
  • Links
  • Tasks

The one list that we created is the Friends List.

And, so that is the one we will offer up.

Navigation Tools

More on Navigational Tools.  I think it is important to know where one is in SharePoint. For the sake of consistency and uniformity most of the screens have a familiar and standard look.

So to know where you really are, I will suggest two ploys:

  • Keeping an eye on your URL box
  • Making note of the middle panel

When on the List View panel, our URL reads http://<sharepointserver>:13201/_layouts/viewlsts.aspx.  The important notifier is the document tag that reads viewlsts.aspx.

And, the middle panel reads:

AllSiteContent

Which to me says that the screen is displaying all sub-sites, lists, and libraries.

List – All Items

Once we chose to go with the Friend’s List, here is where we ended up.

List - Friends - AllItems

Our guide is:

In case we have contents for our lists, they will be noted and listed on our right panel.

List – All Items – Management

To be able to manage the settings on our list, we have to click on the “List Tools/List” icon.

Once we do so, we will see a screen that resembles the screen shot below:

List - Friends - AllItems - Management

List Settings

To manage our List Settings, we will aptly click on the “List Settings” icon.

Upon clicking on the List Settings icon, we are taken to the List Settings page.

List - Friends - ListSettings

 

And, I think this is where we want to be:

We see familiar options, such as:

  • Title, description, and navigation
  • Versioning Settings
  • Advanced Settings
  • Validation Settings
  • Delete this list
  • Save list as template
  • Permissions for the list
  • Workflow Settings
  • RSS Settings

Obviously, our choice it to go with the “Delete this list” choice.

Delete List

Once the “Delete this List” choice is made, the confirmation box is offered:

Are you sure you want to send this list to the site Recyle Bin?

 AreYouSureYouWantToSendThisListToTheSiteRecycleBin

And, we affirmative say OK.

All Site Content

Once the List is removed, we are returned to the “All Site Content” page.

List - Friends - AllSiteContent

Conclusion

Yes, should have read the manual.  But, unlike my last few posted and best left private posts, did not pay bitterly for not reading the manual.

Now on to reviewing the steps for exporting and importing SharePoint Lists.

References

Technical: Microsoft – SharePoint 2010 Administration Toolkit – SharePoint Diagnostic Studio – Error – Microsoft SharePoint is not supported with version 4.0.30319.18051 of the Microsoft .Net Runtime

Technical: Microsoft – SharePoint 2010 Administration Toolkit – SharePoint Diagnostic Studio – Error – Microsoft SharePoint is not supported with version 4.0.30319.18051 of the Microsoft .Net Runtime

Background

A week ago or so, I downloaded and installed a fresh copy of Microsoft SharePoint 2010 Foundation Services.

Upon installation everything worked well. But, it appears that as I played around with stsadm, I possibly messed up my install.

Introduction

As I tried to recover from the problem stated above, one of the tools that I discovered on the Net is Microsoft SharePoint 2010 Administration Toolkit; and the main component from that kit is SharePoint Diagnostic Studio.

In this post, I will list a specific problem we ran into upon trying to use that tool on an MS Windows 2012 box.

Error Message

Upon targeting the SharePoint Diagnostic Studio against my local MS Windows 2012 box, I am getting the message stated below:


Microsoft SharePoint is not supported with version 4.0.30319.18051 of the Microsoft .Net Runtime.

So it seems the that I have to get the Application to target a lower level version of Microsoft .Net:

Possible Fixes

Possible Fixes – Application Configuration File

To do so, I tried creating configuration files:

The configuration files will be placed in our target folder for “SharePoint 2010 Administration ToolKit”.  In our case, the target folder is “E:\Program Files\Microsoft\SharePoint 2010 Administration Toolkit”.

So we create a file that looks like the one below.  Our targeted file is named SPDIAG.EXE, and we will be adding .CONFIG to it and so we end up with SPDIAG.EXE.CONFIG.

The contents of our App Config file is shown below:

AppConfig

The key elements are that we un-checked v4.0, and list v2.0x as the lone supported and required runtime version.

But, still getting the same error. And, so I am getting a bit un-convinced that I am on the right path.  And, I really in need of a miracle here.

SysInternals – Process Explorer

Let us try out SysInternal’s Process Explorer and see what it says about our Application’s running environment.

Please start Process Explorer as a Administrator

Once SysInternal’s Process Explorer is up, look for the SPDIAG.EXE process.

Once you focus in on SPDIAG.EXE, you can transverse each tab and get specific sets of data:

SPDIAG.EXE – Properties – Image

ProcessExplorer-Image

SPDIAG.EXE – Properties – .Net Assemblies

ProcessExplorer-DotNetAssemblies

Explanation:

  • On the left tab, the Structure column shows that we are using CLR v2.0.50727
  • And, the right tab, specifically the Path column shows that the files are being sourced from “C:\Windows\assembly\GAC_64\mscorlib\2.000_ ” and “C:\Windows\assembly\NativeImages_v2.0.50727_64”

Conclusion:

So though SPDIAG is target CLR v2.x, we are still failing….

SysInternals – Process Explorer

Again running as an Administrator, launch Process Explorer and filter our tangential processes.

Here are pertinent events:

  • Operation:- RegOpenKey\
    Path :- HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Image File Execution Options\powershell.exe
  • Operation :- ProcessCreate
    Path :- C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe
    Command line: powershell  -command “& {& ‘C:\Users\<computer-name>\Documents\SharePoint Diagnostic Studio\Server Extensions\RemoteInstall-ExtendedDiagnosticProviders.ps1’ <computer-name>}”
  • Operation :- ProcessStart
    Path :-
    Command line:
    powershell  -command “& {& ‘C:\Users\<username>\Documents\SharePoint Diagnostic Studio\Server Extensions\RemoteInstall-ExtendedDiagnosticProviders.ps1’ COMFORT}”
    Environment :

    
    =C:=C:\Windows\System32
    	=E:=E:\Program Files\Microsoft\SharePoint 2010 Administration Toolkit
    	ALLUSERSPROFILE=C:\ProgramData
    	APPDATA=C:\Users\<username>\AppData\Roaming
    	asl.log=Destination=file
    	CommonProgramFiles=C:\Program Files\Common Files
    	CommonProgramFiles(x86)=C:\Program Files (x86)\Common Files
    	CommonProgramW6432=C:\Program Files\Common Files
    	COMPUTERNAME=<computer-name>
    	ComSpec=C:\Windows\system32\cmd.exe
    	FP_NO_HOST_CHECK=NO
    	HOMEDRIVE=C:
    	HOMEPATH=\Users\<username>
    	LOCALAPPDATA=C:\Users\<username>\AppData\Local
    	LOGONSERVER=\\<AD Server>
    	NUMBER_OF_PROCESSORS=2
    	OS=Windows_NT
    
    

Here are the relevant screen-shots:

ImageFileExecutionOptions:

Looking to determine whether an ImageFileExecutionOptions are defined in the registry for PowerShell.exe

ImageFileExecutionOption

Process Create:

Reviewing what command line options are passed to Powershell.exe when the process is being created:

Here they are:

  •  -command “& {& ‘C:\Users\<username>\Documents\SharePoint Diagnostic Studio\Server Extensions\RemoteInstall-ExtendedDiagnosticProviders.ps1’ <computer-name>}”
  • So we have the name of the PowerShell script to invoke — RemoteInstall-ExtendedDiagnosticProviders.ps1

Process Create – Tab – Event

ProcessCreate

Process Create – Tab – Process

ProcessCreate-Process

Process Start:

  • The environment options details all the environment options that are either created a-new or passed along from the invoking-parent’s process

ProcessStart

Conclusion:

From the screen shot above, we can tell that that the lone argument that is passed to PowerShell is the -command argument.

Our required/supported CLR version 2 is not being passed along.

 

Overall Conclusion

As  SharePoint Diagnostic Studio predates MS Windows 2012 it rightfully does not consider the new PowerShell v3.0’s graceful ability to expose PowerShell v2.0 via command line arguments.

In later posts will discuss other failed attempts!

PowerShell / Microsoft .Net CLR Version

Background

A week or so ago, I tried running Microsoft SharePoint 2010 Administration Toolkit on an MS Windows box.

I ran into problems due to the SharePoint diagnostic tool not being compatible with the default PowerShell/.Net Framework combo on the Windows 2012 box.

Here is the first in a series of post on the school yard beating I took.

Introduction

In this post, I will limit our discussion to ensuring that our pre-requisites are installed and functioning.   Those pre-requisites are Microsoft PowerShell and Microsoft .Net v4. and v3.5.

Confirm installation of Microsoft .Net 3.5 & PowerShell 2.0 Engine

Courtesy of (http://technet.microsoft.com/en-us/library/hh849675.aspx), here are the install\confirmation steps:

Add Microsoft .Net 3.5

  • In Server Manager, from the manage menu, select the Add Roles and Features
  • Select the Server and click on the “Add Roles and Features” option
  • On the Installation Type page, select “Role-based or feature-based” installation
  • On the features page, expand the .Net 3.5 Framework features and select .Net Framework 3.5 (includes .Net 2.0 and 3.0)

WindowsDotNetFrameworkInstallation

To add the Windows PowerShell 2.0 Engine feature

  • In Server Manager, from the manage menu, select the Add Roles and Features
  • Select the Server and click on the “Add Roles and Features” option
  • On the Installation Type page, select “Role-based or feature-based” installation
  • On the features page, expand the “PowerShell (installed)” option and select the “Windows PowerShell 2.0 Engine” option

WindowsPowerShellInstallation

Get OS/CLR Version

To get OS/CLR Version within PowerShell, we can try the following commands:

  • [System.Environment]::OSVersion.Version
  • (Get-WmiObject -class Win32_OperatingSystem).Caption
  • $PSVersionTable

The most important for our current discussion is the $PSVersionTable command:

Syntax:


$PSVersionTable

 

Output:

On MS Windows 2008/R2 box, you will see:

versionInfoOS2008R2Standard

On MS Windows 2012, you will see:

window2012-default

On MS Windows 2012, if your application demands and requires Version 2, then based on the example documented below, add “-version 2” as a command line argument when starting PowerShell

Syntax Screen:

PowerShellCommandLineVariable

So we issue :

Syntax:


powershell -version 2

And, replay the Version and CLR Info we previously mentioned:

Output:

PowershellCLR2onMSWindows2012

Summary

Here is a quick rundown of OS, PowerShell Version support along with Microsoft.Net CLR support and thereof backward compatibility.

OS PSVersion CLRVersion CLR Version Backward
Win2008-R2  2.0 2.0.50727.572 {1.0,2.0}
Win2012  3.0 4.0.30319.18051 {1.0,2.0,3.0}
Win2012 (-v2)  2.0 2.0.50727.6407 {1.0, 2.0}

System Info Tools

As said, PowerShell loads Microsoft.Net dll depending on the OS Version and/or command line parameters.

One popular tool for reviewing system information and activities are of-course SysInternals set of tools.

Windows 2012

In the screen-shot above, we initiated PowerShell on an MS Windows 2012, and did not pass in any command-line parameter:

SysInternals-PowerShell-Windows2012-Image

Here are the Microsoft .Net Dlls loaded:

SysInternals-PowerShell-Windows2012-DotNetAssemblies

From the screen-shot above, we can see the following:

  • on the left panel, we can see that we are on CLR v4.0
  • On the right panel, we have the listing on .Net 4.0 native assemblies loaded

Windows 2012 (passed in -version 2.0)

The screen below indicates what things look like when we pass in the “-version 2.0” option; please pay attention to the “command line” section.

SysInternals-PowerShell-Windows2012-with-v2-Image

And, here is CLR Version & DLL Listings

SysInternals-PowerShell-Windows2012-with-v2-DotNetAssemblies

So we are able to confirm that when we pass in the “-version 2.0” option, we get PowerShell to go back in time.

Conclusion

In follow-up posts, I will discuss the actual problems I ran into and the series of fruitless steps I tried to correct it.

References

References – Determine Version#

References – PowerShell 2.0 Engine

Microsoft – SharePoint (v2010) – SharePoint Foundation – Get List of Products Installed along with Version#

Microsoft – SharePoint (v2010) – SharePoint Foundation – Get List of Products Installed along with Version#

Which Products are installed?

Using GUI

  • Launch SharePoint 2010 Central Administration
  • Access the default screen
  • Under “upgrade and migration”, select “Check product and patch installation status”
  • The “Manage Patch Status” screen is displayed
  • On that screen you should be able to view products are installed and their corresponding version#

Using PowerShell

PowerShell Query:


get-SPFarm | select Servers, Name, DisplayName, Status, BuildVersion

PowerShell Output:

get-SPFarm

Explanation:

Or do one better and try out someone else’s code:

  • I like Matthias_Einig (RENCORE AB) code and it is available @ http://gallery.technet.microsoft.com/office/Get-cleartext-and-license-008ee875
  • Please download and extract the compressed file
  • Launch Terminal Mode (Command Line Shell – cmd.exe); preferable as an Administrator
  • Using cd <extracted-foldername>, Change directory to the folder where you placed your files
  • Launch Powershell (powershell.exe)
  • Unfortunately, Matthias’ code is not digitally signed and you will have to tell your system it is OK to run it
  • In Powershell, you indicate so by issuing “Set-ExecutionPolicy unrestricted”
  • Run Matthias’s script (note that you have to enter the file’s full name or if you in that folder, place “.\” prior to your file name
          
            .\PrintSPVersionAndproducts.ps1
            

In our case, we got

MatthiasCode

Conclusion

Yes, it is much easier to use the GUI.  But, you might want to get comfortable with the SharePoint Command-Line Tool (stsadm.exe) and the PowerShell Snapin (Microsoft.SharePoint.PowerShell Snap-In).

And, yes GUI’s quickly and readily convey information in easily accessible forms, but the backplane is where all the instrumentation and hard-lifting occurs.

References

MS SQL SERVER – OLE DB / ACE Provider – Unable to update existing records

MS SQL SERVER – OLE DB / ACE Provider – Unable to update existing records

The OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server “LSERVER” could not UPDATE table “[Microsoft.ACE.OLEDB.12.0]”. OLE DB provider “Microsoft.ACE.OLEDB.12.0” for linked server “LSERVER” returned message “You cannot update this field because the value you’re trying to apply is not valid or would break a data integrity rule.  Please correct and try again.”.

While trying to update MS Sharepoint list data from MS SQL Server using the ACE Provider, experienced the error pasted above.

Spent so much time trying to correct:

  1. Reviewed the columns I was updating
  2. In MS Sharepoint, checked that the columns, which were choice columns, were fully defined – that is they contained the corresponding “look-up” values

Checked numerous times, my fingers started to tingle from over-typing

What it ended up being is that though the new data was good, some previous data violated the rule and were now being checked as part of ‘commiting’ this new data.

Ended up relaxing the rules for all choice columns:

Allow ‘Fill-in’ choices:

MS Sharepoint – Sharepoint List – Unable to Edit in DataSheet – The Standard View of your list is being displayed because your browser does not support running ActiveX controls

MS Sharepoint – Sharepoint List – Unable to Edit in DataSheet – The Standard View of your list is being displayed because your browser does not support running ActiveX controls

MS suggests the following culprits:

  • A datasheet component that is compatible with Windows SharePoint Services is not installed
  • A Microsoft Office 2003 Professional edition is not installed on the computer
  • The Web browser does not support Active X controls and/or support for Active X Controls is disabled

Here are some credible links:

  1. Install Microsoft Office XP or later
    http://support.microsoft.com/kb/833714
  2. Make sure that SharePoint support is installed as part of MS Office
    http://support.microsoft.com/kb/833714
  3. Register the Owssupp.dll file
    http://support.microsoft.com/kb/833714
  4. Running a repair of Office 2003 or Office 2007
    http://support.microsoft.com/kb/833714
  5. Launch Control Panel \ Internet Options, then to the Advanced tab, and clicked Reset. After IE was reset to default, it finally worked for some.
  6. Re-register owssupp.dll
    http://www.novolocus.com/2007/11/29/stupid-bloody-owssuppdll/
  7. If you ‘re using MS Office 2007 or later, make use of Office Diagnostics
    http://www.makeuseof.com/tag/how-to-detect-and-fix-ms-office-problems-using-ms-office-diagnostics-windows/
  8. Determine the Internet Explorer Zone that the web site is in — Ensure that Active X is enabled per this site.  Preferable, the web site is in the “Trusted” or “Local Intranet” zone.
  9. Ensure that you are running Professional version of Office, and not Standard Edition
  10. If you are using MS Office 2003, Install MS Office 2003 Web Components
    http://www.microsoft.com/downloads/details.aspx?FamilyId=7287252C-402E-4F72-97A5-E0FD290D4B76&displaylang=en

Suggested Readings: