Content Bulk Import | Community
Skip to main content
Thom_Kerekes
Thom_Kerekes
October 16, 2015
Solved

Content Bulk Import

  • October 16, 2015
  • 4 replies
  • 1487 views

Hi All,

I am working on migration project where customer going to migrate their website from existing CMS to our new  CQ 5.6.1.

There are fix number of "templates".  Customer going to provide data in CSV file  format per template.

Is there any way we can BULK import those existing pages into our CQ system.

Please let us know.

 

Thanks in advance

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by smacdonald2008

You can write a custom CQ service that is able to - for example - read data located in an Excel file and process the data. For example - you can store the data retrieved from the Excel spreadsheet into the AEM JCR. For information on How To perform this use case -- see:

http://helpx.adobe.com/experience-manager/using/creating-custom-excel-service-experience.html

4 replies

smacdonald2008
smacdonald2008
Level 10
October 16, 2015

To import an existing site -- CQ supports Site Importer. See:

http://dev.day.com/docs/en/cq/current/developing/site_importer.html

the above topic discusses the available functionality. 

Thom_Kerekes
Thom_KerekesAuthor
October 16, 2015

Thanks for the reply. However, we want to import data from a word document or an excel or CSV file. Please suggest how this can be achieved.

A quick response is highly appreciated.

S
Sam205505050
Level 6
October 16, 2015

one way of doing this is to read csv file and create content.xml(this will have node type info etc) using ant and xslt which is understandable by cq packagemanger and then upload in CQ

smacdonald2008
smacdonald2008Accepted solution
Level 10
October 16, 2015

You can write a custom CQ service that is able to - for example - read data located in an Excel file and process the data. For example - you can store the data retrieved from the Excel spreadsheet into the AEM JCR. For information on How To perform this use case -- see:

http://helpx.adobe.com/experience-manager/using/creating-custom-excel-service-experience.html

Terms & ConditionsAccessibility statement

Loading footer...