CA Clarity Tuesday Tip: Export to Excel Alternative

Discussion created by Kathryn_Ellis Employee on Sep 11, 2012
Latest reply on Oct 1, 2012 by another_martink
Is there a way to export data to Microsoft Excel from Clarity when the page does not have this option?

Yes. Using Clarity XML Open Gateway (XOG) is an alternative that can be used in some pages. For example, a customer asked how they can get details of a Security Access Group Definition exported into Excel for easier analysis. To do read out the groups, use the sample 'groups_read.xml' to read out the Group information. Then open the output file as an XML table. This will allow the user to see the data in columns and then manipulate it further.