I use SQL2Excel to export meeting info for my Admins and all the event info used to be stored in jos_dtregister_user. Now the eventID is there, but nothing is stored in that table any more. Is it somewhere new in v 2.7.5e?
The actual event info was never stored in jos_dtregister_user. That is info for the registration record. The event details are stored in jos_dtregister_group_event. The slabId in that table is what connects to the eventId in other tables like jos_dtregister_user.
The table structure did change with 2.7.x but not again since 2.7.0 outside of adding new fields and such here and there.
Is there a data structure (tables and link ids) that could be made available for those of us that report using tools external to DTRegister? I too have found the new (post 2.7) structure complicated to work out especially in the case of group registrations. Even just the table relations part of the SQL query used to produce the CSV export would be most helpful
Thanks
Bernard