[Options set] Import values of a custom set of options

[SemperFi]

Hello,

I'd like to know if this is possible to declare a new custom field with "select" as type (or any other type linked to a set of options), and to import the possible values of the set of options with a csv file instead of manually adding them one by one .

For example if I add a custom_group called "Studies" for contacts, with a "select" field named "School", I'd like to be able to manage a list of schools in a set of options imported when creating the field (I've 300 different entries), instead of having a free text field.

Can anyone advise please ?

Thanks

[JonGold]

I would use an API import!

You can do it via the GUI: https://civicrm.org/extensions/api-csv-import-gui
or the command line: https://civicrm.org/blogs/xavier/api_batch_tools

[SemperFi]

Thanks Jon

However, the extension leads me to a blank page when accessing it from the menu (API csv Import) with this message

http://localhost/wprc/wp-admin/admin.php?page=CiviCRM&q=csvimporter/import : Merci de faire de WordPress votre outil de création. Version 4.0

And the command line method is a bit too complicated for a newby like me...
I'll trying to import the field directly in the DB...

FYI : I'm testing 4.5b9 on WP4.0

[petednz]

if API isn't firing for some reason in past i have done this with an 'insert' in to the civicrm_option_value table

generally would make the option_group and first value via the UI

Then look at db, grab that row, put in spreadsheet and do whatever is required to replicate the constant values eg option_group_id etc

then import in to the db

but nothing in the UI for doing this

there would need to be a 'lot' of options to be worth doing though ;-)

[SemperFi]

Thanks Peter,
This was exactly my first thought about how to proceed.