The Static URL Replacement functionality does replacement of URLs in metadata, links in webparts, Navigation, Quick Launch and Top Link Bar links using rules from Status URL Replacement section in profile Manager.
This section of the Profile Manager contains all the options for managing the Static URL Replacement settings.
In order to access the Static URL Replacement section, do the following:
1.From the Help tab, select Profile Manager.
2.Within the Profile Manager window, select the Static URL Replacement tab from the left hand menu.
The following is the required formatting in the CSV:
Where replacement rules would work:
·Copy any List Type with Copy Content Types checkbox and the value in the hyper link column would be copied with replacement rules.
·Copy Links List with/without Content Types checkbox and the value in the hyper link column would be copied with replacement rules
·Copy Publishing Pages Library with/without content types and URL in page body <mso:PublishingPageLayout>...</mso:PublishingPageLayout> will be copied with replacement rules
·Copy single Publishing Page and URL in page body, <mso:PublishingPageLayout>...</msoo:PublishingPageLayout> will be copied with replacement rules
·All mentioned above as part of Site/Site Collection Copy
·For any other copy scenarios functionality is not applied