Enterprise, zCase Study

Content Migration using Bots

Client is leading publishing company based in Boston, USA. Client had a need to migrate content of its multiple websites from its legacy platform to new version of the AEM. The content was not easily moveable as lift and shift using the APIs and hence a lot of manual work was required to be done for migration followed by content testing. The marketing teams had a strict timeline to migrate due to their financial and business goal

About the Customer & Problem Statement

The client is a leading publishing company based in Boston, USA. The client had a need to migrate the content of its multiple websites from its legacy platform to the new version of the AEM. The content was not easily moveable as lift and shift using the APIs and hence a lot of manual work was required to be done for migration followed by content testing. The marketing teams had a strict timeline to migrate due to their financial and business goal.

Key Challenge

  • Unavailability of APIs to explore data migration through API Calls
  • The content mapping between the two environments was not available
  • Constant updates in the content on production sites resulted in rework
  • No automated way to do the content migration was available

Solutions

Trantor took a self-initiative to build a POC using the Win Automate platform that logs into the data source and exports the data in the excel sheet. Upon export, the bots read the data in the excel sheet and enter the data in respective fields within AEM instances(author mode). The content is saved as an authored draft and is published only after the testing is done by the tester. Key highlights of the situation :

  • Integration with GatherContent to export data from GC to export.
  • Read/Copy the content from the Excel for each content page and paste the same into respective component instances in the AEM content management system
  • Save the entered content as a draft by the author and not publish it.

Key Value Add

  • Successful POC delivered
  • The optimistic goal of 100% cost savings
  • Built data dictionary
  • Bot ideation, development & support
  • True partners invested in client success
  • POC built in 3 weeks
  • Delivered Customer Delight

Next Steps

If you want to discover more about Trantor Inc. Services, Please Contact sales@trantorinc.com.

The Client

  • This is exciting. we never had an idea if this all content migration from one platform to another can be a pain free process as well. Atul and his team were truly amazing. They not only just drove the technology aspect of the POC but were very patient with IT, and digital marketing team who were resistant to change. We love out Trantor team.
    Chief Technology Officer

Project Highlights

Tech Stack Used:

  • Win Automate
  • Gather Content
  • MS Excel
  • AEM

  • Text Hover