Skip to content

Maritz Event Data File Queries

VIDEO TRANSCRIPT | Recorded: 2025-10-31 | Verify against current system state

Abstract

Overview of SQL Server Management Studio queries used to generate event data files for Maritz. Covers three main data exports: registrant/badge data, session assignments, and ticket information. Shows how to validate data by cross-referencing registrant IDs and discusses custom badge indicator fields.

Key Procedures

  • Open SSMS and navigate to event data queries
  • Run registrant query with student contact IDs, international IDs, and event key
  • Export badge data in required structure and sequence
  • Replace NULL values with empty strings before import
  • Run session assignments query sorted by Reg key
  • Validate data using SP_get_badges_and_tickets with sample Reg key
  • Verify data matches between export and stored procedure
  • Customize badge indicators (Custom 07 field) for member types

Notable Statements

  • 0:00:14 "You'll have these three files that you can pull"
  • 0:00:28 "It's a subset of SP get badges and attendees, but it's not specifically just that"
  • 0:00:39 "Here you're pulling out... the student contact ID list, you need international contact IDs, and then... the event key"
  • 0:00:57 "This is the badge data that's going to be imported into the system"
  • 0:01:15 "Custom 07, which is the types of indicators that appear on a badge itself"
  • 0:01:23 "Like I am a member, I am a student, I am an international member"
  • 0:01:34 "This year I had to add the international piece"
  • 0:01:40 "It's in the exact structure and the exact sequence that you need it to be"
  • 0:01:53 "I always clear out the nulls... make sure those are empty strings instead"
  • 0:02:16 "What I've done is I've sorted by the Reg key, which is the registrant ID"
  • 0:02:20 "It's not really a person ID, but it's the event attendee ID"
  • 0:02:65 "I pull the Reg key for this person, and then I go over to the SP get badges and tickets"
  • 0:03:08 "I paste in the Reg key and I run it and make sure that it matches what I've got in the system"
  • 0:03:40 "Reg key is event attendee ID"

Systems & Configurations

Systems Mentioned

  • SQL Server Management Studio (SSMS)
  • Aptify (source database)
  • Teamwork (task management - contains query files)

Specific Configurations

Item Value/Setting Timestamp Notes
Data file location Teamwork task 0:00:11 Three query files
Badge indicator field Custom 07 0:01:15 Member/Student/International flags
Primary key Reg key (Event Attendee ID) 0:02:16 Not Person ID
Validation SP SP_get_badges_and_tickets 0:02:66 Cross-reference query
Main badge SP SP_get_badges_and_attendees 0:00:28 Source procedure

Credentials/Access Mentioned

  • SSMS access to production and QA databases
  • Teamwork access for query files

Vendor Contacts Mentioned

  • Maritz (event data recipient)

Errors & Troubleshooting

  • Issue: NULL values in export
  • Cause: Database returns NULLs for empty fields
  • Resolution: Replace NULLs with empty strings before template import
  • Timestamp: 0:01:53

Transcript Gaps & Quality Notes

  • Recording cut short due to meeting conflict
  • References to prior meeting covering data details
  • Screen sharing of SSMS not captured in audio
  • Keith mentioned as knowledge transfer recipient
  • Recording ends abruptly at 4 minutes