Content Matrix 9.6 - eRoom Edition User Guide

Permission Mapping Between eRoom and SharePoint

Question

How are permissions mapped between eRoom and SharePoint?

Answer

The following table lists the SharePoint permission mappings for various permission scenarios in eRoom:

DB_Owner Permission

Question

Are read and write permissions to the SharePoint content database sufficient for the Metalogix Extensions Web Service to perform migration?

Answer

As you may know, the Metalogix Extensions Web Service requires read and write permissions to the Content Database, according to a Microsoft KB article (http://support.microsoft.com/kb/935751. However, this is only a solution if you have encountered the message "Unhandled Exception: system.IO.FileNotFoundException" when using the SharePoint object model. We have found that few users have reported this issue, since the Web Service account is usually granted the sysadmin server role, which has complete control over all database functions.

After some internal testing we have determined that the Web Service installing account requires more than read and write permissions to function without database errors.

1."db_owner" rights to the SharePoint Content Database is required.

If the Web Service account does not have the db_owner right to the SharePoint Content Database, Metalogix Content Matrix will not be able to migrate list items using the Web Service, and may receive one of the following errors:

4/19/2010 7:13:53 PM Error copying list item: 1/1 (id: 1, title: Get Started with Windows SharePoint Services!): Service Error: [MLSPService could not add items: MLSPServiceMethods.AddListItems() Failed: Cannot open database "WSS_Content" requested by the login. The login failed.

4/20/2010 10:21:01 AM Error copying list item: 1/2 (id: 1, title: Get Started with Windows SharePoint Services!): Service Error: [MLSPService could not add items: MLSPServiceMethods.AddListItems() Failed: Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT))

2."db_owner" or "WSS_Content_Application_Pools" rights to the SharePoint Admin Content Database is required.

If the Web Service installing account does not have db_owner or WSS_Content_Application_Pools rights to the SharePoint_AdminContent, Metalogix Content Matrix will not be able to create/paste site collections, and will receive an error.

With these cases in mind we have determined that the Metalogix Extensions Web Service account should be granter the db_owner permission rights, at a minimum, to allow Metalogix Content Matrix to correctly migrate content to the target SharePoint instance.

Keyboard Shortcuts

Question

Are there any keyboard shortcuts in the Metalogix Content Matrix Console? If so, what are they?

Answer

Yes, there are a few basic keyboard shortcuts within the Metalogix Content Matrix Console. They are:

·Ctrl + A - This will Select All items within the Items view or in any of the logging sections (such as the Job List section or the Log Viewer).

·Ctrl + C - This will Copy any selected item(s) within Explorer view or Item view, including sites and lists. It will also copy any selected item(s) or information within the logging sections (such as the Job List section or the Log Viewer).

·Ctrl + V - This will Paste any selected item(s) within Explorer view or Item view, including sites and lists. It will also paste any selected item(s) or information within the logging sections (such as the Job List section or the Log Viewer).

·F2 key - This will Rename any selected job list in the Job List in the main UI. Simply select the desired job list, in the Job List section, press F2, and type in the new name for the job list.

Activating the License Key Silently

Question

I would like to activate my license outside of the Content Matrix Console.  Is that possible?

Answer

You can activate your Content Matrix license using PowerShell.  Follow the steps below.

NOTE:  This method can only be used for online activations.

1.Open the Content Matrix PowerShell Console.

2.Run the following cmdlet, which includes specifying the Content Matrix Console Edition for which you want to activate the license.

if (Get-Command Set-MetalogixJobPrerequisites -ErrorAction SilentlyContinue){ Set-MetalogixJobPrerequisites -Value "Content Matrix Console - <Edition_name>" }

NOTE:  Valid values for <Edition Name> are SharePoint Edition, eRoom Edition, Public Folder Edition.  If you license covers more than one Edition, it is only necessary to activate one.  The license activation will automatically be applied to any other Edition for which you are licensed.

3.Run the Set-MetalogixLicense cmdlet.  Note that additional parameters are required if a proxy server is used.

Without proxy server:

Set-MetalogixLicense -Key "<license_key>"

With proxy server:

Set-MetalogixLicense -Key "<license_key>" -ServerUrl "<proxy_server_IP_addres>" -Port "<proxy_port_number>" -UserName "<user_account>" -Password "<password>"

NOTE:  When entering the license key, include hyphens.