can we export ugc report as xls file | Community
Skip to main content
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 smacdonald2008

You sure can -- a CQ page is only a JSP script - you can place a button on it and then call the OSGi service that knows how to get the users and dump the result set into Excel. If you wanted to -- you could even program the OSGi service to email the report by getting the Java Mail API into the OSGi service - see:

http://scottsdigitalcommunity.blogspot.ca/2012/07/creating-custom-cq-email-services.html

Between the ability of coding the front end and the back end -- you can  meet your business requirements - even if the feature is not OOTB. 

Thxs

4 replies

Sham_HC
Sham_HC
Level 10
October 16, 2015

Take a look at http://blogs.adobe.com/livecycle/2011/11/export-reports-into-csv.html

smacdonald2008
smacdonald2008
Level 10
October 16, 2015

Out of the box no - but you  can customize AEM to address this use case. This is one of the more powerful features of AEM - using OSGi to create services. 

You want to use the User Manager API (com.day.cq.security.UserManager) to get the users. See:

http://scottsdigitalcommunity.blogspot.ca/2013/07/using-ajax-requests-to-display-adobe-cq.html

Then you want to create a custom Excel service for AEM. See:

http://scottsdigitalcommunity.blogspot.ca/2013/08/creating-custom-excel-service-for-adobe.html

Then program the app logic of the service to dump the result set of the User Manager API into Excel via the Excel Java API that is part of the OSGi bundle.

HTH

C
chams09Author
October 16, 2015

Thanks for the reply

can you please tell me if it is possible to mount or get this report on a cq page so that I can publish this report onto publish instance so that regular users (non-admin) can look at this report.

smacdonald2008
smacdonald2008Accepted solution
Level 10
October 16, 2015

You sure can -- a CQ page is only a JSP script - you can place a button on it and then call the OSGi service that knows how to get the users and dump the result set into Excel. If you wanted to -- you could even program the OSGi service to email the report by getting the Java Mail API into the OSGi service - see:

http://scottsdigitalcommunity.blogspot.ca/2012/07/creating-custom-cq-email-services.html

Between the ability of coding the front end and the back end -- you can  meet your business requirements - even if the feature is not OOTB. 

Thxs

Terms & ConditionsAccessibility statement

Loading footer...