Pre-migration process for HTML macro

This article contains information about the process and checks to be performed before migrating the HTML macro content from server to cloud.

Due to restrictions in Confluence cloud, the HTML macro name must be changed to HTML-bobswift. Use Migration to Confluence Cloud in HTML for Confluence Configuration to initiate a process that automatically updates the macro name to prepare your content for migration.

Once this process is completed, administrators can run the Confluence Cloud Migration Assistant to migrate all your content to Confluence cloud.

1 Instructions 1.1 See how many comments, pages, and/or templates in your instance require the HTML macro name update 1.2 Update the macro name from HTML to HTML-bobswift on all relevant comments, pages, and templates in your instance 2 Troubleshoot issue

1 Instructions 1.1 See how many comments, pages, and/or templates in your instance require the HTML macro name update 1.2 Update the macro name from HTML to HTML-bobswift on all relevant comments, pages, and templates in your instance 2 Troubleshoot issue

With the introduction of the HTML macro name update process, the macro name is now updated from HTML to HTML-bobswift for all comments, pages, and/or templates.

This article contains the relevant information required to transition HTML content from server to cloud seamlessly.

Instructions

The instructions are divided into two parts: understanding how many comments, pages, and/or templates need updates and running the actual update process. The first part merely allows administrators to check for any errors or mismatches in the number of updates made in the second part.

See how many comments, pages, and/or templates in your instance require the HTML macro name update

Select > Administration > Macro usage, or search for Macro usage.
Scroll down to Bob Swift Atlassian Apps - HTML and see the number of pages mentioned for the html entry.

This is the number of comments, pages, and/or templates that require the HTML macro name change.

Before migration:

Image shows the number of pages that require the macro name change.

Before migration statistics

After migration:

Image shows the number of pages that were changed after the macro name change.

After migration statistics

How do you confirm if all pages and/or templates are updated?

After completing this update process, you can revisit the Macro usage page to verify that all the required comments, pages, and/or templates that use the HTML macro name are updated. This may take a few seconds depending on the total number of comments, pages, and templates that were affected due to the update process.

Update the macro name from HTML to HTML-bobswift on all relevant comments, pages, and templates in your instance

Select > Manage apps.
Search for HTML for Confluence or scroll to Bob Swift Configuration, and click HTML to view app configuration. This opens the HTML for Confluence Configuration page.

Try this for older Confluence versions!

Navigate to CONFLUENCE ADMINISTRATION > Settings > ATLASSIAN MARKETPLACE > HTML > Profiles.

Select Migrate to Confluence Cloud. This tab displays information about the macro name update process.
Click Macro upgrade status to know more about HTML macro usage in your instance. Until the previous release, these statistics were shown directly before the next step.
Click Update pages to start the update process.
After the update process is completed, the macro usage information on the page is updated. These updates can be verified through the Macro usage page as mentioned in the previous section.

Troubleshoot issue

There is a known issue where the pre-migration process stalls when migrating huge loads. If an issue occurs with the migration tool, you can update the database directly as a workaround. Try executing the following queries:

-- This is to pull all the records with given macro it could be html or html-bobswift

SELECT  distinct s.spaceid,s.spacekey 
FROM CONTENT c
JOIN BODYCONTENT bc
	ON c.contentid = bc.contentid
JOIN SPACES s
	ON c.spaceid = s.spaceid
WHERE 
	c.contenttype IN ('PAGE', 'BLOGPOST', 'COMMENT')
	AND bc.body LIKE '%ac:name="html"%';



-- Update html with html-bobswift 

UPDATE bodycontent
SET body = replace(body,'ac:name="html"','ac:name="html-bobswift"') 
WHERE bodycontentid in (
  SELECT bc.bodycontentid
  FROM CONTENT c
  JOIN BODYCONTENT bc
      ON c.contentid = bc.contentid
  WHERE c.contenttype IN ('PAGE', 'BLOGPOST', 'COMMENT')
    AND bc.body LIKE '%ac:name="html"%'
)
;