Macro removal in many pages

[Normann P_ Nielsen _Netic_]

Hi,

We have +500 pages that are affected by 

https://help.refined.com/space/MIGRATETOOLKITCLOUD/5334139038/Preparation+guide and using the old legacy editor in cloud is not a real option.

So - anyone with a good idea / tool to do some change via the databae prior to migration - like remove these parts:

The would prevent the nesting (at least). Such a tool would be gold for many Confluence migrators.

PS: I know of all the dangers regarding this :-)

[Abi Brown- Kolekti]

Hi @Normann P_ Nielsen _Netic_  if you would like some scriptrunner help you can contact the customer success team here 

[Shawn Doyle - ReleaseTEAM]

Hi @Normann P_ Nielsen _Netic_ 

This is a job for Scriptrunner, if you don't already have it, it is one of the addons that I break my rule of not recommending addons by name.  They have a builtin script for removing or updating macros.  

Take a look at this thread as well for more info:

https://community.atlassian.com/forums/App-Central-questions/delete-macro-reference-with-Scriprunner/qaq-p/922084

[Normann P_ Nielsen _Netic_]

Hi - Love scriptrunner - and using it like this:

import com.atlassian.confluence.pages.PageManager

import com.atlassian.sal.api.component.ComponentLocator

import org.jsoup.Jsoup

def pageManager = ComponentLocator.getComponent(PageManager)

def page = pageManager.getPage('SDTEAM', 'CLOUD - How to make change templates') //You can change this line to point to the right parent page.

log.debug "Inspecting page ${page.title}"

def body = page.bodyContent.body

def parsedBody = Jsoup.parse(body)

def macroBody = parsedBody.select('ac|structured-macro').attr('ac:name', 'ui-steps')

def bodyToSave = macroBody.select('ac|rich-text-body')

pageManager.saveNewVersion(page) { pageObject ->

//macroBody.remove() // Removes the entire macro

//macroBody.empty() // Empties the body

//We need to remove the body but keep the body part

XXXXX

// pageObject.setBodyAsString(parsedBody.toString())

}

The XXX is my missing code with i need to replace the entire 'ui-steps' macro with bodyToSave

If I use macroBody.remove() I losse everything

If I use macroBody.empty() its the opposite of what I need.

def macroBody = parsedBody.select('ac|structured-macro').attr('ac:name', 'ui-steps')

give me the inner part, but I need a hadle to the entire macro.

In Short - I want to remove the "ui-steps" macro - BUT keep all inside its rich-text-body

[Normann P_ Nielsen _Netic_]

ok, I am close to giving up - either I am stupid or jsoup is :-/

The page source for my page when fetched like:

def page = pageManager.getPage('SDTEAM', 'CLOUD - How to make change templates') //You can change this line to point to the right parent page.

when I do:

def body = page.bodyContent.body

def parsedBody = Jsoup.parse(body)

this line (for body):

<ac:structured-macro ac:macro-id="c1274913-7457-4d41-95c2-2424dbb3cd57" ac:name="ui-step" ac:schema-version="1">

becomes (for parsedBody):

<ac:structured-macro ac:name="ui-steps" ac:schema-version="1" ac:macro-id="c1274913-7457-4d41-95c2-2424dbb3cd57">

Hence ui-step becoms up-steps ...

[Shawn Doyle - ReleaseTEAM]

I'd ask Scriptrunner support for the syntax, @Abi Brown- Kolekti added a link for them.

If I understand correctly you need to remove the contents from the macro, remove the macro then put the contents into a different macro?  This is doable with script runner I've done something similar in the past.

[Normann P_ Nielsen _Netic_]

Ive submittet a ticket to Adaptavist, and stared https://www.mos-eisley.dk/spaces/ATLASSIAN/pages/279478283/Confluence+Data+Center+to+Cloud+Migration+Tips for advising other on stuff :-)