Quite often, I had always wondered if there was an easy out to export the results from a CMC to excel.
There is of course, the tool that can be found online, that runs against a macro and exports it to Excel, but I wanted to see if something can be done directly out of the CMC itself.
With this background, I stumbled on this little workaround that uses a little known plug in that can do that. Of course, it involves a few steps, but in the end it will get the job done.
Uploading the document, for the benefit it of SCN users.
This is my first upload here, so I do not know how this works. Hopefully it will be useful to someone.
Disclaimer: This will work only with FIREFOX BROWSER
- Open CMC in a Browser ( Firefox)
- Activate FIREBUG Plug in ( found on the top right hand side of the toolbar)
3. This will open a new window or a small window at the bottom of the current browser. You also have an option of opening it in a new window if it opens in a same window by clicking the icon
4. Click on the little Arrow icon, found on the top left hand side of the menu bar of the firebug window
5. Highlight the first row in CMC, that you want the query to be saved into Excel
6. The min u do the selection in the above step, the code in the FIREBUG window gets highlighted on the row that the data on the CMC window was selected
7. Carefully, identify the <Table id> code, which can be found a few lines above the selected
8. Locate <DIV ID> which is right above the <TABLE ID> pointer and place the mouse on that line, right click the mouse and select “COPY INNER HTML” from the selected pop up menu
9. Save this code to a Notepad and save it as .HTML file or a.XLS file
10. Either of the 2 files will take a long time to open and will also get saved with the icons from CMC.
11. Copy/select individually the columns that are needed, to the next tab for a cleaner and neater output.
12. Finally … since CMC has a restriction to display only 500 objects at one time, you might have to do this multiple times, by navigating to the next page and starting the process from step 1, if your list of objects runs into more than 500.