Content Bulk Import

[Thom_Kerekes]

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

[smacdonald2008]

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]

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.

[Sam205505050]

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 · Accepted solution]

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