• Locked Locked
  • Replies 1 reply
  • Subscribers 11 subscribers
  • Views 2128 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Content Matrix Issue - Default Value settings for fields in target site

jashwanth nimmala
over 6 years ago

Hi, We're migrating documents from SharePoint 2010 to SharePoint Online using Content Matrix Console - 8.5.0.6. We have an issue with default value for a field in target site. Below are the details:

 

In Target Site we have managed metadata field 'Countries' and we have set default value to 'United States'.

 

In Source Site we have similar managed metadata field 'Countries'.

 

Using Content Matrix console, we're mapping these two fields. Now the expectation is:

  1. If there is no value for countries in source, target should pick the default value i.e. 'United States'
  2. If there is a value for countries in source, target should get these values post migration.

 

Not sure if this scenario is buildin, if not, can you please suggest a transformation.

 

Thank you for your time.

 

Jashwanth

 

Parents
  • over 6 years ago

    Hi Jashwanth,

     

    I apologize for the delayed response as I wanted to reproduce the scenario and provide you with a working recommendation.

     

    Please do the following:

     

    1. On the Managed Metadata Options tab, enable the "Resolve managed metadata by name and hierarchy" and "Copy referenced managed metadata" options.

    2. Enable the "Map term stores for migration" also, then map the term stores of the source and target environments.

    3. On the Mapping Options tab, enable the "Map list item data to different columns" option, then map the Countries column of the source and target environments.

    4. On the Transformations tab, select SharePoint Items on the Available Definitions section.

    5. Click Add Transformer and select Invoke PowerShell script.

    6. On the Transform tab, select "Use Configured Script" and paste the following:

     

    if($dataObject["Countries"] -eq "")

    {

      $dataObject["Countries"] = "<LABEL>|<GUID>" 

    }

     

    where <LABEL> and <GUID> represent the default value on the target environment.

     

    I hope this helps.

     

     

    Regards,

    Cyrus

Reply
  • over 6 years ago

    Hi Jashwanth,

     

    I apologize for the delayed response as I wanted to reproduce the scenario and provide you with a working recommendation.

     

    Please do the following:

     

    1. On the Managed Metadata Options tab, enable the "Resolve managed metadata by name and hierarchy" and "Copy referenced managed metadata" options.

    2. Enable the "Map term stores for migration" also, then map the term stores of the source and target environments.

    3. On the Mapping Options tab, enable the "Map list item data to different columns" option, then map the Countries column of the source and target environments.

    4. On the Transformations tab, select SharePoint Items on the Available Definitions section.

    5. Click Add Transformer and select Invoke PowerShell script.

    6. On the Transform tab, select "Use Configured Script" and paste the following:

     

    if($dataObject["Countries"] -eq "")

    {

      $dataObject["Countries"] = "<LABEL>|<GUID>" 

    }

     

    where <LABEL> and <GUID> represent the default value on the target environment.

     

    I hope this helps.

     

     

    Regards,

    Cyrus

Children
No Data