Author Topic: Where to find table or list of field labels and possible values (Read 1124 times)

madronemedia · November 10, 2008, 03:27:11 pm

Working on importing data. I read documentation that suggested to first export a test record to reveal field labels that will be used. Great. However, I need a way to easily determine or save a table that lists all (especially custom and multiple choice) field labels and all their corresponding possible values.

I can't find any answer searching the documentation or forums. Anyone else ever deal with this? Thanks.

Dave Greenberg · November 10, 2008, 07:04:03 pm

Most of the option values (including core select lists like gender, as well as ALL custom field multiple choice options) are stored in the civicrm_option_value table. They are organized by "option groups" - with the groups and their id's stored in civicrm_option_group. In general, import expects the "label" of from the option_value table - and (I think) we lower case everything before trying to match - so case-insensitive. HTH.

madronemedia · November 11, 2008, 10:40:51 am

Thanks Lobo, I'm forwarding this info on to my tech geeks to help me create a master reference table. Anyone else already done this?

Mark

CiviCRM Community Forums (archive)

News:

Author Topic: Where to find table or list of field labels and possible values (Read 1124 times)

madronemedia

Where to find table or list of field labels and possible values

Dave Greenberg

Re: Where to find table or list of field labels and possible values

madronemedia

Re: Where to find table or list of field labels and possible values