Author Topic: bulk import select option fields (Read 1263 times)

Clifford Meece · June 07, 2010, 06:57:12 am

Hi,
I am trying to create a custom data item called 'school' and I would like to populate a select box (or advanced multi-select box) with a list of schools. I have over 500 schools. What is the easiest way to get them into the system? One at a time will take forever, but I didn't see any bulk import function.

Secondly, am I going about this the wrong way? Should these instead be a 'group' or an 'organization'? I'm also a little hazy on the difference between custom data and profile fields. Is Custom data just a new type of field that can then be added to a custom profile? If I add a custom data and profile field, is there any way to treat contacts with a given option as a group for the purposes of mailings and other outreach?

Thanks,

Donald Lobo · June 07, 2010, 04:20:17 pm

to go down the custom field route, i would do 3-10 schools and check what happens in the civicrm_option_value table

the remaining 490-497, you could do a direct mysql import using PHPMyAdmin or your favorite mysql tool

profiles are just views of standard data + custom data. they do not introduce new fields. might want to take a quick read of the book:

http://en.flossmanuals.net/CiviCRM

lobo

Clifford Meece · June 07, 2010, 04:43:35 pm

Thanks for the reply. Am I right to assume that the Custom Data route is appropriate for my use case, then?

Donald Lobo · June 07, 2010, 09:54:58 pm

yes

lobo

CiviCRM Community Forums (archive)

News:

Author Topic: bulk import select option fields (Read 1263 times)

Clifford Meece

bulk import select option fields

Donald Lobo

Re: bulk import select option fields

Clifford Meece

Re: bulk import select option fields

Donald Lobo

Re: bulk import select option fields