CiviCRM Community Forums (archive)

Hi Guys,

Me again :/

Do you guys know of any clean way to import/export Individual prefixes and suffixes from install to install?

I've got a list of 60 different prefixes/suffixes that I find myself entering manually way too often...

Using API:

I can hit up option groups 6 & 7 (prefix and suffix)

/civicrm/ajax/rest?json=1&debug=1&version=3&entity=OptionGroup&action=get&id=6
/civicrm/ajax/rest?json=1&debug=1&version=3&entity=OptionGroup&action=get&id=7

And I can also pull a list of existing values in each option group with:

/civicrm/ajax/rest?json=1&debug=1&version=3&entity=OptionValue&action=get&option_group_id=6
/civicrm/ajax/rest?json=1&debug=1&version=3&entity=OptionValue&action=get&option_group_id=7


Oh boy. Answered my own question...and gave myself some homework. I'm going to have to add this to my civi-importer module.


And....for search posterity, and those in a rush:

You can use Xavier's wonderful php CLI csv import/export tools.

They are here: /civicrm/bin/csv/

Usage in this scenario would be as such:

php bin/csv/export.php -u username -p password  -s default OptionValue option_group_id=6

To dump all prefixes into a csv.

php bin/csv/export.php -u username -p password   -s default OptionValue option_group_id=7

for suffixes, and so on and so forth.


Thanks for letting me on here still!