How do I include multiple class years in participant exports for name tags.

Michelle Lancto

With more and more individuals getting multiple degrees from the same institution, we need to be able to export multiple class years for name tags. When I add a primary alumni column and an education relationship column(s), the primary class year shows up twice, once under primary and once under education relationship. In addition to getting the primary class year twice, we also get blank columns for non-degree or incomplete degrees. Despite ordering them in ascending order by date added, they are often exported out of order.

Does anyone have any ideas on a clean way to extract this class information from Raiser's Edge?

Joe Moretti

Attached your query to an export (do not export straight from a query). Chose the info you want, Last Name, First, whatever you want and the for the education, just go to Relationship, Education, then pick what you want, School Name, Class of, Degree, whatever. Your criteria for the number to export should be whatever you think is the most number of schools, degrees or year one person has. You do not need to choose the Primary Alumni Info, since that only pulls the primary and not any others, but the Education Relationship will pull all that info, including the Primary.

Your results: