How to export product data from we-retail into csv | Community
Skip to main content
Community Advisor
March 14, 2018
Solved

How to export product data from we-retail into csv

  • March 14, 2018
  • 3 replies
  • 1619 views

How can I export the data in csv format in AEM 6.3 for other e-commerce system.

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 kautuk_sahni

Export to CSV feature allow your to export Metadata (Published date, modified date) + Analytics + Page Path+ etc. It is more of the information about your pages.

But if you need to export data other then this then you would need to write custom service using JCR API, SQL Queries etc.

Example :-

1. Adobe Experience Manager Help | Querying Adobe Experience Manager 6 data using the Sling getServiceResourceResolver meth…

2. Adobe Experience Manager Help | Using Sling APIs to retrieve content from the Adobe Experience Manager Repository

-Kautuk

3 replies

smacdonald2008
Level 10
March 14, 2018

You would need to write a custom Service that reads the JCR data you want to export, format the data to CSV and then return it. Purhaps a Sling Servlet.

smacdonald2008
Level 10
March 14, 2018

My first answer is based on if you want to perform additional operations on the data. For example, you can use Java logic to perform some additional encoding operations and check the data and so on.

Alternatively - you can simply dump data by following this: Export to CSV

kautuk_sahni
Community Manager
kautuk_sahniCommunity ManagerAccepted solution
Community Manager
March 15, 2018

Export to CSV feature allow your to export Metadata (Published date, modified date) + Analytics + Page Path+ etc. It is more of the information about your pages.

But if you need to export data other then this then you would need to write custom service using JCR API, SQL Queries etc.

Example :-

1. Adobe Experience Manager Help | Querying Adobe Experience Manager 6 data using the Sling getServiceResourceResolver meth…

2. Adobe Experience Manager Help | Using Sling APIs to retrieve content from the Adobe Experience Manager Repository

-Kautuk

Kautuk Sahni