Perform the following using a PowerShell transformer script:
- Strip out the domain name from account IDs. For example, "metalogix\sptestuser01" will be replaced by "sptestuser01". SharePoint Online should be able to resolve the users based on the account name "sptestuser01".
- Link correction to replace the source web URLs with the target web URL. For example:
Source: http://vmn56-sp2010/sites/site/InfoPath/Shared%20Documents/test1.txt
Target: https://metalogix.sharepoint.com/sites/TestSite/Shared%20Documents/test1.txt
Please follow the steps below to leverage the transformer. Note: Make sure to enable the Advanced Mode on the Settings tab of the Content Matrix Console.
- Download the attached PowerShell script, change the following lines of code and save it as "TransformInfoPathForms.ps1".
- Update $emailHost to your Office 365 domain ($emailHost = "@metalogix.net" ).
- Update the following lines of code to replace the Windows domain/s in the form. You may add additional lines for each domain.
$newString = $String.Replace("METALOGIX\","")
- Configure a new migration action to copy the Forms library. You can either do a "Paste List" or a "Paste All List Items and Folders" job.
- In the Transformations tab, select "SharePoint Items" from the list of Available Definitions.
- Next, select "Invoke PowerShell Script" from the "Add Transformer" dropdown on the right pane.
- In the configuration dialog, go to the Transform tab, select "Use Script From File" and point it to "TransformInfoPathForms.ps1".
When the action is run, the data inside the forms will be corrected.
DISCLAIMERQuest is providing this PowerShell script (hereafter called the "Transformer") available for general use.
The Transformer has not been tested or approved for use in a production environment.
By using the Transformer Customer acknowledges and assumes the risk of installing, using, and relying upon this Transformer.
Any and all modifications to this Transformer made by Quest for specific uses outside of its original intent will require additional Professional Services.