Description

Often the need arises to find pages that have certain content and modify it slightly. If the number of pages is larger, making manual modifications can be painful and error prone. Automation can help, but you have to make sure that you are modifying exactly what you want and not something unintentional. See also this user question for a discussion on this topic.

Go to How to find Confluence pages and then do something for techniques for finding content.

Links

• How to find Confluence pages and then do something
• How to use SQL to find pages
• How to make global changes to comments
• Advanced Searching With CQL

Example 1: Changing a url

Changing a link. For instance: http://myjira.com to http://mynewjira.com.

Steps

Setup an example page 

--action storePage --space xxx --title test --parent @home --content "aaa http://myjira.com bbb"

Construct a modifyPage action for a single page using a simple text replace. Since : (colon) is in the text and is the default key:value separator for CLI, use # instead using the special parameter (spaces are significant!) 

--action modifyPage --space xxx --title at --findReplace "http://myjira.com#http://mynewjira.com" --special " #"

Run against all pages with the link (using unix style escaping - see Tips). Run against your test space first before using @all.

--action runFromContentList --space xxx --common "--action modifyPage --id @pageId@ --findReplace \"http://myjira.com#http://mynewjira.com\" --special \" #\" "

Results 

Run: --action modifyPage --id 112197680 --findReplace "http://myjira.com#http://mynewjira.com" --special " #" 
Page modified: 'at' in space: xxx. Page has id: 112197680
...

 Example 2: Renaming a macro

There are a few cases why you may need to rename a macro:

1. A user macro may need a better name or may conflict with macro from a new plugin
2. A macro may no longer be valid because you have discontinued a plugin or removed a user macro, but you want to save the body of the macro

Steps

1. Determine the kind of body the existing macro has
   1. Plain text like the noformat macro
   2. Rich text like the panel macro
2. Make sure the target macro has the same body type
3. Use the techniques of Example 1 

Use something similar to the following findReplace string 

One rich text macro:
--findReplace "ac:name=~table-plus~#ac:name=~panel~" --special " #  ~"
 
One rich text macro and a plain text macro
--findReplace "ac:name=~table-plus~#ac:name=~panel~,ac:name=~csv~#ac:name=~noformat~" --special " #  ~"

Example 3: Changing XHTML content

This site has many pages created via automation, often by a Bamboo build process. Confluence has an annoying feature  that converts simple wiki text like @entry@ into XHTLM reference to a template variable. There doesn't seem to be a way to escape this behavior. The result is a number of pages with incorrect data. This examples shows how this was corrected.

Steps

...

1. Look at the storage view of the page with the problem
2. In this example: <at:var at:name="entry" /> should have been @entry@
3. In the UI, search for something like: "<at:var" and verify that the pages found represent the problem you are trying to solve

Construct the same search using the CLI and verify results. Suggest you start with a single space first before doing @all. Note you need to escape the double quote using your system specific escaping syntax - see Tips

--action getPageList --space @all

Construct a find/replace string. In this case, the text between the @ signs could be anything, so we will use findReplaceRegex instead of simple text replacement that findReplace does. You need to know a little bit of regex syntax including a find group (in this example: any number of alphabetic characters) and the replacement text referencing the find group: @$1@. Test your regex first. How to use regular expressions has some pointers.

<at:var at:name="([a-zA-Z]*)" /> needs to be replace with @$1@

...

Construct the parameters for find and replace. Use ~ instead of " so we can avoid escaping double quote. Use # as the separator between key and value instead of the default : (colon). For unix based command lines, the $ must be escaped.

--findReplaceRegex "<at:var at:name=~([a-zA-Z]*)~ />#@\$1@" --special " #  ~" 

Construct the CLI command for a single action and test on a single page

--action modifyPage --space xxx --title "my title" --findReplaceRegex "<at:var at:name=~([a-zA-Z]*)~ />#@\$1@" --special " #  ~" 

...

Put every thing together using runFromPageList (this examples using unix based escaping)

--action runFromPageList --space @all --common "--action modifyPage --id @pageId@ --findReplaceRegex \"<at:var at:name=~([a-zA-Z]*)~ />#@\$1@\" --special \" #  ~\" " 

Result

Run: --action modifyPage --id 28901397 --findReplaceRegex "<at:var at:name=~([a-zA-Z]*)~ />#@$1@" --special " #  ~" 
Page modified: '3.0.0 - Documentation' in space: BCLI. Page has id: 28901397
Run: --action modifyPage --id 28901413 --findReplaceRegex "<at:var at:name=~([a-zA-Z]*)~ />#@$1@" --special " #  ~" 
Page modified: '3.0.0 - Documentation' in space: CSOAP. Page has id: 28901413
...