can we export ugc report as xls file

[chams09]

how can we export ugc report as xls file 

http://localhost:4502/etc/reports/ugcreport.html

[Sham_HC]

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

[smacdonald2008]

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

[chams09]

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

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