Talk to us
Back to blogs
January 18, 2021Written by Trantor4 min read

Content Migration using Bots

January 18, 2021Written by Trantor4 min read

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

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.

  • 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

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.

  • 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

=Tech Stack Used:

  • Win Automate

  • Gather Content

  • MS Excel

  • AEM

Link copied