Exporting List and Lookup Groups to Excel

[Ed Bellman]

I'd like to export all of our List and Lookup Groups into Excel so we can do some review, cleanup, etc. I've only been able to create a query for individual List Groups and not all of them at once and I assume I'll run into the same thing with Lookup Groups.

Am I missing an easy way to do this? I feel like it should be a relatively simple thing to do but I'm scratching my head a bit on actually doing it!

TIA,

Ed

[Steve Van Dyke]

Hi Ed, no you are not missing anything. A query will need to be created for each. Ah but wait, I wonder if this will help

Go into LU Group Maintenance and List Group Maintenance respectively and although their is no easy and quick way to export all LU's and Lists to Excel at once, you can always chose the LU from the dropdown, highlight each header first the ID and right click on the column and choose Copy, then paste this directly to Excel, then the same for the Group Description. Next LU in the dropdown and so on. I know this isnt what you hoped for but Prolog doesnt have a quick export for all LU' and Lists to Excel. Maybe this will be quicker than creating a query for each LU and List.

Copy, Paste, Dropdown
Copy, Paste, Dropdown
etc

[Ed Bellman]

Thanks Steve, while not as fast and convenient as a single query export the cut-n-paste method works fairly well, even thru Citrix.