Trying to copy items from a large list where you only want the items with Status = "something". You use a filter and type in "Status" to the "Field" column in the filter. But Content Matrix is confusing this field with an internal field from the object.
The error message received should match the below on copying items.
Status: Failed
Operation: Copying Item
Item Name: 1_.000
Information:
Exception: Complete is not a valid value for ConnectionStatus.
Details:
Stack: at System.ComponentModel.EnumConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)
at Metalogix.Data.Filters.FilterExpression.Evaluate(Object component, Comparison`1 comparer)
at Metalogix.SharePoint.Actions.Migration.PasteListItemAction.CopyListItem(SPListItem sourceItem, Int32 iItemIndex, Nullable`1 iParentItemID, SPFolder targetFolder, SPListItemCollection sourceItems, SPListItemCollection& targetItems, Boolean bIsFolder, Boolean bPreservingItems, Boolean bIsNwsTarget, Boolean bIsCopyRoot, ListTemplateType targetListTemplate, Dictionary`2& itemIdMap, List`1 filteredFolders)
Type: System.FormatException
HResult:-2146233033
Inner Exception Stack: at System.Enum.TryParseEnum(Type enumType, String value, Boolean ignoreCase, EnumResult& parseResult)
at System.Enum.Parse(Type enumType, String value, Boolean ignoreCase)
at System.ComponentModel.EnumConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)
Type: System.ArgumentException
HResult:-2147024809
Content Matrix is confusing this field with an internal field from the object
Use Transformer for workaround in the "Transform" tab and replace "something" with the field entry you'd like to copy over
if ($dataObject["Status"] -ne "something") { $dataObject = $null }
Update: Fixed as part of version 9.0 of Content Matrix Link to download latest version -> https://support.quest.com/metalogix-content-matrix/9.4/download-new-releases
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center