Fetch page properties and update in excell

[Ricky99999]

Hi,

I got a requirement to list of below properties from page and update them in excell

1.tags

2. title

3. page title

4. Publish status

5. Description

I have thousands of pages, and child pages too , how can I a give this.

Thanks in advance

Thanks

[Kiran_Vedantam]

Hi @Ricky99999 

You can achieve your use case in the below ways:

1. use query builder API to get the properties you want
2. use page or node API and getting the value map of the resource

and finally write them into an excel file in java

Query builder sample query:

path=/content/we-retail
type=cq:Page
path=/content/we-retail
type=cq:Page
group.1_property=jcr:content/cq:productMaster
group.1_property.value=
/var/commerce/products/we-retail/wo/pants/faba_running_pants
group.2_property=jcr:content/cq:template
group.2_property.value=
/conf/we-retail/settings/wcm/templates/product-page
p.limit=-1

Node or Page API:

Once you get the page resource, iterate it and adapt it to Node or Page API

final resourceresolver resolver = request.getresourceresolver();
final resource res = resolver.getresource(page_path);

Page:
final page requestedpage =res.adaptto(page.class);

Node:

final Node requestedNode =res.adaptto(node.class);

Hope it helps!

Thanks,
Kiran Vedantam

[Gaurav_Sachdeva_ · Accepted solution]

Hi @Ricky99999 

There is an ACS common tool to fetch page report which gives page details under specific path, have a look at https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/index.html

Hope this helps!!

Thanks,

Gaurav Sachdeva

[Ricky99999]

Hi @Gaurav_Sachdeva_ 

@Thanks for the reply.

By using ACS commons I can get title, tags and replication status and I believe they are default properties. Correct me.

Do we have any way to get customised page properties in Excell. 

[DEBAL_DAS]

If you are allowed to use ACS AEM Commons in your project, then you can use page report mechanism for this requirement.

1. Please refer existing ACS AEM Commons page report here https://adobe-consulting-services.github.io/acs-aem-commons/features/report-builder/index.html

2. Create another page report as per your need.

ACS AEM Commons page report will save your time and effort.

[Ricky99999]

Hi @DEBAL_DAS @Gaurav_Sachdeva_ 

Thanks for the reply.

By using ACS commons I got title, tags and replication status and I believe they are default properties. Correct me.

Do we have any way to get customised page properties in Excell. 

[DEBAL_DAS]

Yes, I used ACS commons with customized page property also and it worked.

In result column you need to mention this (giving example) -

Heading

Field Label [Some meaningful name] of custom property

Property

jcr:content/cutomproperty

Hope this helps.

[Gaurav_Sachdeva_]

Hi @Ricky99999 

you can customize the page report and change the complete report according to your requirement just go here and try.

Thanks,

Gaurav