I'm looking for some recommendations. I've inherited a CiviCRM instance with a quite complicated custom data structure, and I want to review and update it. I was wondering if there were any tools or APIs that would help me export or visualize the data schema/fields for different object types?
The best option I can find is exporting all the fields for each type using the Export to CSV function, but that will require manually selecting hundreds of custom fields for each contact type in the field mapping GUI. UUUUggghhh! :-)
I've found the Data Explorer extension (https://civicrm.org/extensions/data-explorer) and am checking if that's a possibility, but that seems to have the same issues as the Exporter -- lots of manual selection.
Can anyone suggest a better way? Thanks!