Have a question about CiviCRM? Get it answered quickly at the new CiviCRM Stack Exchange Q+A siteThis forum was archived on 25 November 2017. Learn more.How to get involved.What to do if you think you've found a bug.
{ "is_error":0, "undefined_fields":["domain_id"], "version":3, "count":1, "id":1, "values":[{ "is_enabled":"0", "domain_group_id":"0", "event_price_set_domain_id":"0", "uniq_email_per_site":"0", "tag_unconfirmed":"Unconfirmed", "petition_contacts":"Petition Contacts", "contact_view_options":["1","2","3","4","5","6","7","8","9","10","11","13"], "contact_edit_options":["1","2","3","4","5","6","7","8","9","10","11"], "advanced_search_options":["1","2","3","4","5","6","7","8","9","10","11","12","13","15","16","17","18","19"], "user_dashboard_options":["1","2","3","4","5","7","8"], "address_options":["1","2","3","4","5","6","8","9","10","11"], "address_format":"{contact.address_name}\n{contact.street_address}\n{contact.supplemental_address_1}\n{contact.supplemental_address_2}\n{contact.city}{, }{contact.state_province}{ }{contact.postal_code}\n{contact.country}", "mailing_format":"{contact.addressee}\n{contact.street_address}\n{contact.supplemental_address_1}\n{contact.supplemental_address_2}\n{contact.city}{, }{contact.state_province}{ }{contact.postal_code}\n{contact.country}", "display_name_format":"{contact.individual_prefix}{ }{contact.first_name}{ }{contact.last_name}{ }{contact.individual_suffix}", "sort_name_format":"{contact.last_name}{, }{contact.first_name}", "editor_id":"2", "contact_ajax_check_similar":"1", "activity_assignee_notification":"1", "contact_autocomplete_options":["1","2"], "contact_reference_options":["1","2"], "enable_cart":"0", "profile_double_optin":"1", "track_civimail_replies":"0", "civimail_workflow":"0", "civimail_server_wide_lock":"0", "mailing_backend":{ "outBound_option":"3" }, "profile_add_to_group_double_optin":"0", "uploadDir":"upload\/", "imageUploadDir":"persist\/contribute\/", "customFileUploadDir":"custom\/", "extensionsDir":"\/var\/www\/civi.custom\/extensions" }],
"advanced_search_options":["1","2","3","4","5","6","7","8","9","10","11","12","13","15","16","17","18","19"],
{ "is_error":0, "version":3, "count":42, "values":[{ "group_name":"UrlPreferences", "name":"userFrameworkResourceURL", "type":"String", "add":"4.1", "is_domain":"1", "is_contact":"0", "description":"CiviCRM Resource URL", "validate_callback":"CRM_Utils_Rule::url" }, { "group_name":"UrlPreferences", "name":"imageUploadURL", "type":"String", "add":"4.1", "is_domain":"1", "is_contact":"0", "description":"Image Upload URL", "validate_callback":"CRM_Utils_Rule::url" }, { "group_name":"UrlPreferences", "name":"customCSSURL", "type":"String", "add":"4.1", "is_domain":"1", "is_contact":"0", "description":"Custom CiviCRM CSS URL", "validate_callback":"CRM_Utils_Rule::url" }, { "group_name":"Member Preferences", "name":"default_renewal_contribution_page", "type":"Integer", "html_type":"Select", "pseudoconstant":{ "name":"contributionPage" }, "add":"4.1", "title":"Default online membership renewal page", "is_domain":"1", "is_contact":"0", "description":"If you select a default online contribution page for self-service membership renewals, a \"renew\" link pointing to that page will be displayed on the Contact Dashboard for memberships which were entered offline. You will need to ensure that the membership block for the selected online contribution page includes any currently available memberships." }, { "group_name":"Multi Site Preferences", "name":"is_enabled", "type":"Integer", "add":"4.1", "is_domain":"1", "is_contact":"0", "description":"Multisite is enabled" }, { "group_name":"Multi Site Preferences", "name":"domain_group_id", "type":"Integer", "add":"4.1", "is_domain":"1", "is_contact":"0", "description":"Image Upload URL" }, { "group_name":"Multi Site Preferences", "name":"event_price_set_domain_id", "type":"Integer", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"Multi Site Preferences", "name":"uniq_email_per_site", "type":"Integer", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"Address Standardization Preferences", "name":"address_standardization_provider", "type":"String", "html_type":"Select", "add":"4.1", "title":"Address Standardization Provider.", "is_domain":"1", "is_contact":"0", "help_text":"CiviCRM includes an optional plugin for interfacing with the United States Postal Services (USPS) Address Standardization web service. You must register to use the USPS service at https:\/\/www.usps.com\/business\/webtools-address-information.htm. If you are approved, they will provide you with a User ID and the URL for the service. Plugins for other address standardization services may be available from 3rd party developers. If installed, they will be included in the drop-down below. " }, { "group_name":"Address Standardization Preferences", "name":"address_standardization_userid", "type":"String", "html_type":"Text", "add":"4.1", "title":"Web service user ID..", "is_domain":"1", "is_contact":"0" }, { "group_name":"Address Standardization Preferences", "name":"address_standardization_url", "type":"Text", "html_type":"Text", "add":"4.1", "title":"Web service user ID..", "is_domain":"1", "is_contact":"0", "help_text":"Web service URL.", "validate_callback":"CRM_Utils_Rule::url" }, { "group_name":"Campaign Preferences", "name":"tag_unconfirmed", "type":"String", "html_type":"Text", "default":"Unconfirmed", "add":"4.1", "title":"Tag for Unconfirmed Petition Signers", "is_domain":"1", "is_contact":"0", "help_text":"If set, new contacts that are created when signing a petition are assigned a tag of this name." }, { "group_name":"Campaign Preferences", "name":"petition_contacts", "type":"String", "html_type":"Text", "default":"Petition Contacts", "add":"4.1", "title":"Petition Signers Group", "is_domain":"1", "is_contact":"0", "help_text":"If set, new contacts that are created when signing a petition are assigned a tag of this name." }, { "group_name":"CiviCRM Preferences", "name":"contact_view_options", "type":"String", "html_type":"Checkboxes", "add":"4.1", "title":"Tag for Unconfirmed Petition Signers", "is_domain":"1", "is_contact":"0" }, { "group_name":"CiviCRM Preferences", "name":"contact_edit_options", "type":"String", "html_type":"Text", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"CiviCRM Preferences", "name":"advanced_search_options", "type":"String", "html_type":"Text", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"CiviCRM Preferences", "name":"user_dashboard_options", "type":"String", "html_type":"Text", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"CiviCRM Preferences", "name":"address_options", "type":"String", "html_type":"Text", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"CiviCRM Preferences", "name":"address_format", "type":"String", "html_type":"Text", "default":"{contact.address_name}\\n{contact.street_address}\\n{contact.supplemental_address_1}\\n{contact.supplemental_address_2}\\n{contact.city}{, }{contact.state_province}{ }{contact.postal_code}\\n{contact.country}", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"CiviCRM Preferences", "name":"mailing_format", "type":"String", "html_type":"Text", "default":"{contact.addressee}\\n{contact.street_address}\\n{contact.supplemental_address_1}\\n{contact.supplemental_address_2}\\n{contact.city}{, }{contact.state_province}{ }{contact.postal_code}\\n{contact.country}", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"CiviCRM Preferences", "name":"display_name_format", "type":"String", "html_type":"Text", "default":"{contact.individual_prefix}{ }{contact.first_name}{ }{contact.last_name}{ }{contact.individual_suffix}", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"CiviCRM Preferences", "name":"sort_name_format", "type":"String", "html_type":"Text", "default":"{contact.last_name}{, }{contact.first_name}", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"CiviCRM Preferences", "name":"editor_id", "type":"String", "html_type":"Text", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"CiviCRM Preferences", "name":"contact_ajax_check_similar", "type":"String", "html_type":"Text", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"CiviCRM Preferences", "name":"activity_assignee_notification", "type":"String", "html_type":"Text", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"CiviCRM Preferences", "name":"contact_autocomplete_options", "type":"String", "html_type":"Text", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"CiviCRM Preferences", "name":"contact_reference_options", "type":"String", "html_type":"Text", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"Event Preferences", "name":"enable_cart", "type":"String", "html_type":"Text", "add":"4.1", "title":"Tag for Unconfirmed Petition Signers", "is_domain":"1", "is_contact":"0", "help_text":"If set, new contacts that are created when signing a petition are assigned a tag of this name." }, { "group_name":"Mailing Preferences", "name":"profile_double_optin", "type":"Integer", "html_type":"checkbox", "default":"0", "add":"4.1", "title":"Enable Double Opt-in for Profile Group(s) field", "is_domain":"1", "is_contact":"0", "description":"When CiviMail is enabled, users who \"subscribe\" to a group from a profile Group(s) checkbox will receive a confirmation email. They must respond (opt-in) before they are added to the group." }, { "group_name":"Mailing Preferences", "name":"track_civimail_replies", "type":"Integer", "html_type":"checkbox", "default":"0", "add":"4.1", "title":"Enable Double Opt-in for Profile Group(s) field", "is_domain":"1", "is_contact":"0", "description":"When CiviMail is enabled, users who \"subscribe\" to a group from a profile Group(s) checkbox will receive a confirmation email. They must respond (opt-in) before they are added to the group.", "validate_callback":"CRM_Core_BAO_Setting::validateBoolSetting" }, { "group_name":"Mailing Preferences", "name":"civimail_workflow", "type":"Integer", "html_type":"checkbox", "default":"0", "add":"4.1", "title":"Enable Double Opt-in for Profile Group(s) field", "is_domain":"1", "is_contact":"0", "description":"When CiviMail is enabled, users who \"subscribe\" to a group from a profile Group(s) checkbox will receive a confirmation email. They must respond (opt-in) before they are added to the group." }, { "group_name":"Mailing Preferences", "name":"civimail_server_wide_lock", "type":"Integer", "html_type":"checkbox", "default":"0", "add":"4.1", "title":"Enable Double Opt-in for Profile Group(s) field", "is_domain":"1", "is_contact":"0", "description":"When CiviMail is enabled, users who \"subscribe\" to a group from a profile Group(s) checkbox will receive a confirmation email. They must respond (opt-in) before they are added to the group." }, { "group_name":"Mailing Preferences", "name":"mailing_backend", "type":"Array", "html_type":"checkbox", "default":"0", "add":"4.1", "title":"Enable Double Opt-in for Profile Group(s) field", "is_domain":"1", "is_contact":"0", "description":"When CiviMail is enabled, users who \"subscribe\" to a group from a profile Group(s) checkbox will receive a confirmation email. They must respond (opt-in) before they are added to the group." }, { "group_name":"Mailing Preferences", "name":"profile_add_to_group_double_optin", "type":"Integer", "html_type":"checkbox", "default":"0", "add":"4.1", "title":"Enable Double Opt-in for Profile Group(s) field", "is_domain":"1", "is_contact":"0", "description":"When CiviMail is enabled, users who \"subscribe\" to a group from a profile Group(s) checkbox will receive a confirmation email. They must respond (opt-in) before they are added to the group." }, { "group_name":"Directory Preferences", "name":"uploadDir", "type":"Url", "html_type":"Text", "add":"4.1", "is_domain":"1", "is_contact":"0", "help_text":"If set, new contacts that are created when signing a petition are assigned a tag of this name." }, { "group_name":"Directory Preferences", "name":"imageUploadDir", "type":"Url", "html_type":"Text", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"Directory Preferences", "name":"customFileUploadDir", "type":"Url", "html_type":"Text", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"Directory Preferences", "name":"customTemplateDir", "type":"Url", "html_type":"Text", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"Directory Preferences", "name":"customPHPPathDir", "type":"Url", "html_type":"Text", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "group_name":"Directory Preferences", "name":"extensionsDir", "type":"Url", "html_type":"Text", "add":"4.1", "is_domain":"1", "is_contact":"0" }, { "title":"Fields you wish to filter by e.g. array(\"group_name\" => \"CiviCRM Preferences\")" }, { "title":"id of relevant component" }],
2) Looking at your output the getfields array doesn't seem to be keyed by the setting name which seems like a bug.
3) CiviCRM is already stored integers as strings in the settings table - that's what you are seeing. Probably should be fixed but not necessarily in the scope of this.
4) language/currency/countries... If these aren't in the list they are probably still stored in the civicrm_domain table. They should be moved. I think most will be fairly simple but ..5) the handling of allowed states / countries need some thought - the current method is memory intensive. We could save the array as json in the settings table & unserialise it / use only when there is a country box. But there are other problems with the current method - e.g people like to restrict front end country entry - but then they can't even see the country for imported contacts from a non-permitted country. So, would be good to be clear firstly (because I'm not) what we expect from the country / state list restriction & then potentially look at how to store that.
Joe / others reading - it would be great if someone could compile a list of the things they usually change so I can focus on those settings. (I found the whole settings definition pretty exhausting so I went for a get-em-in-quick & tidy up after approach)