CiviCRM Community Forums (archive)

Hi all,

I want to allow users to enter the countries they are working in -- some have operations in many countries -- so I am trying to make a multi-select custom field containing nearly every country name. I created the field through the UI, but with some help from _dalin on IRC I used the following SQL statements to populate the field with 245 values and labels:

INSERT INTO tbl_temp (name, iso_code) SELECT name, iso_code FROM civicrm_country;
INSERT INTO civicrm_option_value (option_group_id, label, value, name, is_active) SELECT 41, name, iso_code, name, 1 FROM tbl_temp;
This almost works, but the countries are not in alphabetical order in the multi-select field even though they are alphabetical in civicrm_option_value. I can't edit the order manually. If I try to view/edit multiple choice options I get an out of memory error:

Fatal error: Out of memory (allocated 32768000) (tried to allocate 1171 bytes) in /homepages/15/d225854661/htdocs/drupal2/sites/all/modules/civicrm/CRM/Utils/Weight.php on line 325

Unfortunately I'm developing in a shared environment and can't get to php.ini. Should 245 country names require this much memory? Any ideas about increasing the memory, or a better approach?

Yep, works great. That will have to do for now. Thanks!