Expand my Community achievements bar.

SOLVED

Content Bulk Import

Avatar

Level 1

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

1 Accepted Solution

Avatar

Correct answer by
Level 10

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

View solution in original post

4 Replies

Avatar

Level 10

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. 

Avatar

Level 1

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.

Avatar

Level 6

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

Avatar

Correct answer by
Level 10

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