List of designees

Jennifer Gamache

Hello, does anyone know how to export a list of all fund designations stored in Luminate Online? 


Thanks from Northeastern U.

Matthew Smith 2

If you have access to Luminate Online Web Services you can find this list with the query "select * from Designee".

Brian Mucha

Matthew pointed out a good way. But rather then writing a page or something to call Web Services, you can use the console.


It's buried in a super weird place, but it's so useful.


Set Up > Site Options > Open API Configurations > Configure or View API logs > Then scroll to the bottom where you see...


Access Luminate Online Web Services log monitor: https://webservices.cluster3.convio.net/1.0/ABC/monitor


Whew! Now that we're at the webservices monitor you can click CONSOLE at the top of the page.


FINALLY! Now check out the Query tab. You can put Matt's query there, or experiment with other versions.



A second option is to contact Support. There is a hidden report that can be turned on called SITE AUDIT, which you would access under Data Management > Import/Export.


Holy cow it reports on just about every document in your system.


audit.PageBuilderVersions.csv

audit.PageBuilderPages.csv

audit.PhotoAlbum.csv

audit.Events.csv

audit.Survey.csv

audit.SurveyQuestion.csv

audit.TeamRaiserCampaigns.csv

audit.TeamRaiserPartTypes.csv

audit.TeamRaiserAutoResponders.csv

audit.PersonalFundraisingFunds.csv

audit.DonClassic.csv

audit.Don2.csv

audit.DonDesignees.csv

audit.Don2CustomElements.csv

audit.EcommStores.csv

audit.EcommProducts.csv

audit.EcommDiscounts.csv

audit.ActionAlerts.csv

audit.EmailCampaign.csv

audit.EmailMessage.csv

audit.Ecards.csv

audit.EmailStationary.csv

audit.Groups.csv

audit.Interests.csv

audit.ImageLibrary.csv

audit.DocumentLibrary.csv

audit.URLShortcuts.csv

audit.SecCats.csv

audit.SecCatCounts.csv

audit.AdminPerms.csv

audit.PageWrapper.csv


BPM