Hi Garrett-S ,
Sure you can follow the below steps:
1. Using SQL query, take the excel export of the idea data like initiatorUserName, Name, ObjectID, progress & status and change the name of idea with the new values
2. Create a new word document and under mailing click on Normal word document
3. Select the existing excel export file
4. Paste the idea tag with the blank values in the document
<Idea initiatorUserName=" " name=" " objectID=" " progress="" status="">
5. Insert the fields (please note I have only added 2 fields)
6. Once added it will look like this and finish it.
7. You will get all the idea tags with the updated name and paste into the XOG below and XOG-IN
<NikuDataBus>
<Header action="write" externalSource="NIKU" objectType="idea" version="8.0"/>
<Ideas>
<paste the coped xml from mail merge>
</Idea>
</Ideas>
</NikuDataBus>
The name will change with the names provided in the excel sheet. You can try with one or two ideas but first try this on pre-prod environment.
Regards
Shubham