CiviCRM Community Forums (archive)

Hi,
I'm trying to set Civi installation up so that default country, currency, etc are automagically populated rather than needing to be done via the admin UI.
I'd assumed that it would be possible to add these to the "civicrm.settings php" like so:
define('CIVICRM_COUNTRY_LIMIT','GB');
etc, etc.
However, this can't be done prior to installation, so I was hoping that subsequently editing the "civicrm.settings php" would suffice - however, my edits are not being picked up (probably because the database has already been populated).

Is there a way to do this via this or similar approach?

Thanks,
Eddie


D7, Civi 4.2.6

Hi Eddie,

The constants for CIVICRM_COUNTRY_LIMIT and CIVICRM_PROVINCE_LIMIT were deprecated some time ago, although I see one or two comment in the CiviCRM code still referring to them.

Initially, a long long time ago, CiviCRM had constants for most settings, which were defined in the civicrm.settings.php (CiviCRM 1.x). In CiviCRM 2.x and 3.x, those settings were progressively migrated to options that could be configured from the administrative interface, and stored in the database. However, they were often stored in the "civicrm_domain" table (in a serialized field). Around 3.4/4.0, settings were migrated to the civicrm_option_name / civicrm_option_value table, because some of those fields had huge lists of possible values.

More recently, the need for API calls to manage those settings has become more and more important, especially for those of us who manage turn-key hosting farms (reduce installation costs). A new "settings" mechanism is available in CiviCRM since 4.2 (I think), but not all configurations have been migrated to it. Country/province settings are one of those not migrated yet (I think they are still in the "civicrm_domain" table). This migration is a lot of work, since it standardizes many different old mechanisms, and civi developers are trying to pick up best practices from Drupal 8's configuration management initiative.

Long story short, here is an example of what I use to set the country/province and other localization settings. I'm using it on a CiviCRM 4.1 farm, however, and it has not been upgraded to 4.2 yet.

$params = array(
    'enableComponents' => array(),
    'enableComponentIDs' => array(),
    'moneyformat' => '%a %c',
    'monetaryThousandSeparator' => ' ',
    'monetaryDecimalPoint' => '.',
    'dateformatDatetime' => '%Y/%m/%d %k:%M', // 2012-01-31 5:30
    'dateformatFull' => '%Y/%m/%d', // 2012-01-31
    'dateformatPartial' => '%B %Y', // janvier 2012
    'lcMessages' => 'fr_CA',
    'defaultContactCountry' => 1039,
    'defaultCurrency' => 'CAD',
    'enableSSL' => TRUE,
  );

  civicrm_initialize(TRUE);
  require_once "CRM/Core/BAO/Setting.php";
  CRM_Core_BAO_Setting::add($params);

In 4.2, CRM_Core_BAO_Setting::add($params) was changed to CRM_Core_BAO_ConfigSetting::add($params);

For example, you can see in CRM/Admin/Form/Setting/Localization.php, it sets an array of values, and then calls the parent commonProcess() function, in CRM/Admin/Form/Setting.php.

  // $params = array(... );

  civicrm_initialize(TRUE);
  require_once "CRM/Core/BAO/ConfigSetting.php";
  CRM_Core_BAO_ConfigSetting::add($params);

Mathieu / bgm on IRC

Under 4.3 the settings that are in the domain table and those stored in civicrm_settings are available through a new settings api - so you would be able to do

$param = array('version' => 3,
    'enableComponents' => array(),
    'enableComponentIDs' => array(),
    'moneyformat' => '%a %c',
    'monetaryThousandSeparator' => ' ',
    'monetaryDecimalPoint' => '.',
    'dateformatDatetime' => '%Y/%m/%d %k:%M', // 2012-01-31 5:30
    'dateformatFull' => '%Y/%m/%d', // 2012-01-31
    'dateformatPartial' => '%B %Y', // janvier 2012
    'lcMessages' => 'fr_CA',
    'defaultContactCountry' => 1039,
    'defaultCurrency' => 'CAD',
    'enableSSL' => TRUE,
   'default_renewal_contribution_page' => 3,

   );

civicrm_api('setting', 'create', $params);

(We have backported this to 4.2 - https://github.com/fuzionnz/civicrm)