About import/export of table information in AEM | Community

Level 2

Solved

About import/export of table information in AEM

Forum|Forum|3 years ago
December 9, 2022
3 replies
1111 views

We would like to have a table (JSON or spreadsheet) with attribute information defined for each page URL, import that table in AEM, and export it to Publish in JSON or other format.

■Example
・URL: page-url-1
Attribute information 1 (category): Cloud computing
Attribute information 2 (target): For small and medium-sized businesses

・URL: page-url-2
Attribute Information 1 (Category): Digital Marketing
Attribute Information 2 (Target): For large companies

We would also like to export the table information registered in AEM, update it as needed, and import it again.

How can we achieve this kind of functionality in AEM?

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 aanchal-sikka

@satoshi1 : Export/Import metadata is available for Assets OOTB.

https://experienceleague.adobe.com/docs/experience-manager-learn/assets/metadata/metadata-import-export.html?lang=en

May be something similar can be developed for sites as well.

Community Advisor and Adobe Champion

Community Advisor and Adobe Champion

You would have to write two servlets. One for the reading of the spreadsheet or Json in AEM and second for exporting it as JSON.

Import: You can read both types of file either spreadsheet or Json from the file system or placing it inside DAM.

1. Create a POST servlet

2. Write the logic to read the sheet and the page URL mentioned in the sheet.

3. Read the corresponding attribute from the sheet and write the property or node in the JCR:content of the page

Here is the logic explained in the post to read the spreadsheet:

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/how-to-read-excel-file-data/td-p/304703

Export:

Create a get servlet to read the page nodes and build your JSON structure. You can also use various OOB method defined in the below link.

https://experienceleague.adobe.com/docs/experience-manager-65/developing/components/json-exporter.html?lang=en

Hope this helps.

Community Advisor

Accepted solution

Community Advisor

@satoshi1 : Export/Import metadata is available for Assets OOTB.

https://experienceleague.adobe.com/docs/experience-manager-learn/assets/metadata/metadata-import-export.html?lang=en

May be something similar can be developed for sites as well.

Aanchal Sikka

Level 2

@avinash_gupta_ @aanchal-sikka

Thanks for letting me know.
It has been helpful, including past correspondence.

Since what we are trying to do this time includes non-AEM pages, I will set them as JSON in Adobe Collection Tags (Launch) and set them in DataLayer.