Bulk change ownership during XML Space Import

As a system admin
I want to have a way to change pages owners (author, last modifier) during a Space import operation
So that If I receive an exported space in XML format, I can easily do a "from-to" operation to assign pages to new owners

Suggestion Summary

• Customer company A is bought by company B.
• Both have Confluence, Directories are not integrated
• Sysadmins on company B create users for employees from company A, but they do not always match the ones they had in A (such as, A is johnsmith, B is jsmith)
• Customer would rather have pages assigned correctly, than listing unknown user johnsmith

Proposed Solution

Import operation could allow admins to input a from-to CSV file indicating old user names and new ones, to prevent that issue.

Possible Workarounds

• Have the space imported in a non-production instance and run the procedures from:
  How To - Transfer Content Ownership in between Users
• Try find-and-replace operations on the XML file such as

sed -i.tmp 's@<property name="name"><!\[CDATA\[oldusername\]\]></property>@<property name="name"><!\[CDATA\[newusername\]\]></property>@g' entities.xml

sed -i.tmp 's@<property name="lowerName"><!\[CDATA\[oldusername\]\]></property>@<property name="lowerName"><!\[CDATA\[newusername\]\]></property>@g' entities.xml

Again, we must be mindful about the space name. I don't think you gonna have spaces with usernames on it, but, just in case, be mindful about that. If that happens, after you have SED'ed your way, open the entities.xml file and look for the tag below:

 <object class="Space" package="com.atlassian.confluence.spaces">
 <id name="id">3440641</id>
 <property name="name"><![CDATA[OldUserName]]></property>
 <property name="key"><![CDATA[MAR]]></property>
 <property name="lowerKey"><![CDATA[mar]]></property>

Once you found it, just replace the name accordingly to respect the previous space name and save the file. Then follow the steps previously outlined here and we should be fine.