magento / magento2

Prior to making any Submission(s), you must sign an Adobe Contributor License Agreement, available here at: https://opensource.adobe.com/cla.html. All Submissions you make to Adobe Inc. and its affiliates, assigns and subsidiaries (collectively “Adobe”) are subject to the terms of the Adobe Contributor License Agreement.
http://www.magento.com
Open Software License 3.0
11.55k stars 9.32k forks source link

Store settings Import/Export feature #3094

Closed MonteShaffer closed 8 years ago

MonteShaffer commented 8 years ago

I turned on the MYSQL.log to see what was going on as I was saving parameters in the store-configuration settings.

Most variables are stored in the core_config_data table, such as:

INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'design/watermark/image_size', NULL)
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'design/watermark/image_imageOpacity', NULL)
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'design/watermark/image_position', 'stretch')
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'design/watermark/small_image_size', NULL)
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'design/watermark/small_image_imageOpacity', NULL)
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'design/watermark/small_image_position', 'stretch')
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'design/watermark/swatch_image_size', NULL)
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'design/watermark/swatch_image_imageOpacity', NULL)
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'design/watermark/swatch_image_position', 'stretch')
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'design/watermark/thumbnail_size', NULL)
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'design/watermark/thumbnail_imageOpacity', NULL)
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'design/watermark/thumbnail_position', 'stretch')

And then for some reason, an object of settings is mapped as a serialized array for the default user:

UPDATE `admin_user` SET `extra` = 'a:1:{s:11:\"configState\";a:234:{s:15:\"general_country\";s:1:\"1\";s:14:\"general_region\";s:1:\"1\";s:14:\"general_locale\";s:1:\"1\";s:25:\"general_store_information\";s:1:\"1\";s:25:\"general_single_store_mode\";s:1:\"0\";s:12:\"design_theme\";s:1:\"1\";s:11:\"design_head\";s:1:\"1\";s:27:\"design_search_engine_robots\";s:1:\"1\";s:13:\"design_header\";s:1:\"1\";s:13:\"design_footer\";s:1:\"1\";s:12:\"design_email\";s:1:\"1\";s:16:\"design_watermark\";s:1:\"0\";s:17:\"design_pagination\";s:1:\"0\";s:16:\"currency_options\";s:1:\"1\";s:20:\"currency_webservicex\";s:1:\"1\";s:15:\"currency_import\";s:1:\"1\";s:15:\"contact_contact\";s:1:\"1\";s:13:\"contact_email\";s:1:\"1\";s:25:\"newrelicreporting_general\";s:1:\"1\";s:22:\"newrelicreporting_cron\";s:1:\"1\";s:20:\"catalog_fields_masks\";s:1:\"1\";s:14:\"catalog_review\";s:1:\"1\";s:16:\"catalog_frontend\";s:1:\"1\";s:20:\"catalog_productalert\";s:1:\"1\";s:25:\"catalog_productalert_cron\";s:1:\"1\";s:19:\"catalog_placeholder\";s:1:\"1\";s:25:\"catalog_recently_products\";s:1:\"1\";s:21:\"catalog_product_video\";s:1:\"1\";s:13:\"catalog_price\";s:1:\"1\";s:26:\"catalog_layered_navigation\";s:1:\"1\";s:14:\"catalog_search\";s:1:\"1\";s:11:\"catalog_seo\";s:1:\"1\";s:18:\"catalog_navigation\";s:1:\"1\";s:20:\"catalog_downloadable\";s:1:\"1\";s:22:\"catalog_custom_options\";s:1:\"1\";s:24:\"cataloginventory_options\";s:1:\"1\";s:29:\"cataloginventory_item_options\";s:1:\"1\";s:16:\"sitemap_category\";s:1:\"1\";s:15:\"sitemap_product\";s:1:\"1\";s:12:\"sitemap_page\";s:1:\"1\";s:16:\"sitemap_generate\";s:1:\"1\";s:13:\"sitemap_limit\";s:1:\"1\";s:22:\"sitemap_search_engines\";s:1:\"1\";s:10:\"rss_config\";s:1:\"1\";s:12:\"rss_wishlist\";s:1:\"1\";s:11:\"rss_catalog\";s:1:\"1\";s:9:\"rss_order\";s:1:\"1\";s:16:\"sendfriend_email\";s:1:\"1\";s:25:\"customer_online_customers\";s:1:\"1\";s:22:\"customer_account_share\";s:1:\"1\";s:23:\"customer_create_account\";s:1:\"1\";s:17:\"customer_password\";s:1:\"1\";s:16:\"customer_address\";s:1:\"1\";s:16:\"customer_startup\";s:1:\"1\";s:26:\"customer_address_templates\";s:1:\"1\";s:16:\"customer_captcha\";s:1:\"1\";s:16:\"wishlist_general\";s:1:\"1\";s:14:\"wishlist_email\";s:1:\"1\";s:22:\"wishlist_wishlist_link\";s:1:\"1\";s:33:\"promo_auto_generated_coupon_codes\";s:1:\"1\";s:18:\"persistent_options\";s:1:\"1\";s:13:\"sales_general\";s:1:\"1\";s:17:\"sales_totals_sort\";s:1:\"1\";s:13:\"sales_reorder\";s:1:\"1\";s:14:\"sales_identity\";s:1:\"1\";s:19:\"sales_minimum_order\";s:1:\"1\";s:15:\"sales_dashboard\";s:1:\"1\";s:12:\"sales_orders\";s:1:\"1\";s:18:\"sales_gift_options\";s:1:\"1\";s:10:\"sales_msrp\";s:1:\"1\";s:19:\"sales_email_general\";s:1:\"1\";s:17:\"sales_email_order\";s:1:\"1\";s:25:\"sales_email_order_comment\";s:1:\"1\";s:19:\"sales_email_invoice\";s:1:\"1\";s:27:\"sales_email_invoice_comment\";s:1:\"1\";s:20:\"sales_email_shipment\";s:1:\"1\";s:28:\"sales_email_shipment_comment\";s:1:\"1\";s:22:\"sales_email_creditmemo\";s:1:\"1\";s:30:\"sales_email_creditmemo_comment\";s:1:\"1\";s:17:\"sales_pdf_invoice\";s:1:\"1\";s:18:\"sales_pdf_shipment\";s:1:\"1\";s:20:\"sales_pdf_creditmemo\";s:1:\"1\";s:11:\"tax_classes\";s:1:\"1\";s:15:\"tax_calculation\";s:1:\"1\";s:12:\"tax_defaults\";s:1:\"1\";s:11:\"tax_display\";s:1:\"1\";s:16:\"tax_cart_display\";s:1:\"1\";s:17:\"tax_sales_display\";s:1:\"1\";s:8:\"tax_weee\";s:1:\"1\";s:16:\"checkout_options\";s:1:\"1\";s:13:\"checkout_cart\";s:1:\"1\";s:18:\"checkout_cart_link\";s:1:\"1\";s:16:\"checkout_sidebar\";s:1:\"1\";s:23:\"checkout_payment_failed\";s:1:\"1\";s:15:\"shipping_origin\";s:1:\"1\";s:24:\"shipping_shipping_policy\";s:1:\"1\";s:21:\"carriers_freeshipping\";s:1:\"1\";s:17:\"carriers_flatrate\";s:1:\"1\";s:18:\"carriers_tablerate\";s:1:\"1\";s:12:\"carriers_ups\";s:1:\"1\";s:13:\"carriers_usps\";s:1:\"1\";s:14:\"carriers_fedex\";s:1:\"1\";s:12:\"carriers_dhl\";s:1:\"0\";s:16:\"google_analytics\";s:1:\"1\";s:14:\"google_adwords\";s:1:\"1\";s:46:\"payment_us_paypal_group_all_in_one_wps_express\";s:1:\"1\";s:34:\"payment_us_authorizenet_directpost\";s:1:\"1\";s:18:\"payment_us_account\";s:1:\"1\";s:28:\"payment_us_braintree_section\";s:1:\"1\";s:38:\"payment_us_braintree_section_braintree\";s:1:\"0\";s:57:\"payment_us_braintree_section_braintree_braintree_required\";s:1:\"1\";s:57:\"payment_us_braintree_section_braintree_braintree_advanced\";s:1:\"0\";s:65:\"payment_us_braintree_section_braintree_braintree_country_specific\";s:1:\"0\";s:55:\"payment_us_braintree_section_braintree_braintree_paypal\";s:1:\"0\";s:57:\"payment_us_braintree_section_braintree_braintree_3dsecure\";s:1:\"0\";s:34:\"payment_us_paypal_group_all_in_one\";s:1:\"1\";s:51:\"payment_us_paypal_group_all_in_one_payflow_advanced\";s:1:\"0\";s:69:\"payment_us_paypal_group_all_in_one_payflow_advanced_required_settings\";s:1:\"1\";s:87:\"payment_us_paypal_group_all_in_one_payflow_advanced_required_settings_payments_advanced\";s:1:\"1\";s:92:\"payment_us_paypal_group_all_in_one_payflow_advanced_required_settings_advanced_advertise_bml\";s:1:\"0\";s:123:\"payment_us_paypal_group_all_in_one_payflow_advanced_required_settings_advanced_advertise_bml_advanced_settings_bml_homepage\";s:1:\"0\";s:127:\"payment_us_paypal_group_all_in_one_payflow_advanced_required_settings_advanced_advertise_bml_advanced_settings_bml_categorypage\";s:1:\"0\";s:126:\"payment_us_paypal_group_all_in_one_payflow_advanced_required_settings_advanced_advertise_bml_advanced_settings_bml_productpage\";s:1:\"0\";s:123:\"payment_us_paypal_group_all_in_one_payflow_advanced_required_settings_advanced_advertise_bml_advanced_settings_bml_checkout\";s:1:\"0\";s:78:\"payment_us_paypal_group_all_in_one_payflow_advanced_settings_payments_advanced\";s:1:\"1\";s:114:\"payment_us_paypal_group_all_in_one_payflow_advanced_settings_payments_advanced_settings_payments_advanced_advanced\";s:1:\"0\";s:132:\"payment_us_paypal_group_all_in_one_payflow_advanced_settings_payments_advanced_settings_payments_advanced_advanced_settlement_report\";s:1:\"0\";s:123:\"payment_us_paypal_group_all_in_one_payflow_advanced_settings_payments_advanced_settings_payments_advanced_advanced_frontend\";s:1:\"0\";s:77:\"payment_us_paypal_group_all_in_one_payflow_advanced_settings_express_checkout\";s:1:\"1\";s:112:\"payment_us_paypal_group_all_in_one_payflow_advanced_settings_express_checkout_settings_express_checkout_advanced\";s:1:\"0\";s:43:\"payment_us_paypal_group_all_in_one_wpp_usuk\";s:1:\"0\";s:67:\"payment_us_paypal_group_all_in_one_wpp_usuk_paypal_payflow_required\";s:1:\"1\";s:95:\"payment_us_paypal_group_all_in_one_wpp_usuk_paypal_payflow_required_paypal_payflow_api_settings\";s:1:\"1\";s:96:\"payment_us_paypal_group_all_in_one_wpp_usuk_paypal_payflow_required_paypal_payflow_advertise_bml\";s:1:\"0\";s:133:\"payment_us_paypal_group_all_in_one_wpp_usuk_paypal_payflow_required_paypal_payflow_advertise_bml_paypal_payflow_settings_bml_homepage\";s:1:\"0\";s:137:\"payment_us_paypal_group_all_in_one_wpp_usuk_paypal_payflow_required_paypal_payflow_advertise_bml_paypal_payflow_settings_bml_categorypage\";s:1:\"0\";s:136:\"payment_us_paypal_group_all_in_one_wpp_usuk_paypal_payflow_required_paypal_payflow_advertise_bml_paypal_payflow_settings_bml_productpage\";s:1:\"0\";s:133:\"payment_us_paypal_group_all_in_one_wpp_usuk_paypal_payflow_required_paypal_payflow_advertise_bml_paypal_payflow_settings_bml_checkout\";s:1:\"0\";s:67:\"payment_us_paypal_group_all_in_one_wpp_usuk_settings_paypal_payflow\";s:1:\"1\";s:100:\"payment_us_paypal_group_all_in_one_wpp_usuk_settings_paypal_payflow_settings_paypal_payflow_advanced\";s:1:\"0\";s:125:\"payment_us_paypal_group_all_in_one_wpp_usuk_settings_paypal_payflow_settings_paypal_payflow_advanced_paypal_payflow_avs_check\";s:1:\"0\";s:133:\"payment_us_paypal_group_all_in_one_wpp_usuk_settings_paypal_payflow_settings_paypal_payflow_advanced_paypal_payflow_settlement_report\";s:1:\"0\";s:124:\"payment_us_paypal_group_all_in_one_wpp_usuk_settings_paypal_payflow_settings_paypal_payflow_advanced_paypal_payflow_frontend\";s:1:\"0\";s:75:\"payment_us_paypal_group_all_in_one_wpp_usuk_paypal_payflow_express_checkout\";s:1:\"1\";s:116:\"payment_us_paypal_group_all_in_one_wpp_usuk_paypal_payflow_express_checkout_paypal_payflow_express_checkout_advanced\";s:1:\"0\";s:72:\"payment_us_paypal_group_all_in_one_wps_express_express_checkout_required\";s:1:\"1\";s:115:\"payment_us_paypal_group_all_in_one_wps_express_express_checkout_required_express_checkout_required_express_checkout\";s:1:\"1\";s:86:\"payment_us_paypal_group_all_in_one_wps_express_express_checkout_required_advertise_bml\";s:1:\"0\";s:108:\"payment_us_paypal_group_all_in_one_wps_express_express_checkout_required_advertise_bml_settings_bml_homepage\";s:1:\"0\";s:112:\"payment_us_paypal_group_all_in_one_wps_express_express_checkout_required_advertise_bml_settings_bml_categorypage\";s:1:\"0\";s:111:\"payment_us_paypal_group_all_in_one_wps_express_express_checkout_required_advertise_bml_settings_bml_productpage\";s:1:\"0\";s:108:\"payment_us_paypal_group_all_in_one_wps_express_express_checkout_required_advertise_bml_settings_bml_checkout\";s:1:\"0\";s:58:\"payment_us_paypal_group_all_in_one_wps_express_settings_ec\";s:1:\"1\";s:79:\"payment_us_paypal_group_all_in_one_wps_express_settings_ec_settings_ec_advanced\";s:1:\"0\";s:114:\"payment_us_paypal_group_all_in_one_wps_express_settings_ec_settings_ec_advanced_express_checkout_billing_agreement\";s:1:\"0\";s:114:\"payment_us_paypal_group_all_in_one_wps_express_settings_ec_settings_ec_advanced_express_checkout_settlement_report\";s:1:\"0\";s:105:\"payment_us_paypal_group_all_in_one_wps_express_settings_ec_settings_ec_advanced_express_checkout_frontend\";s:1:\"0\";s:34:\"payment_us_paypal_payment_gateways\";s:1:\"0\";s:74:\"payment_us_paypal_payment_gateways_paypal_payflowpro_with_express_checkout\";s:1:\"0\";s:98:\"payment_us_paypal_payment_gateways_paypal_payflowpro_with_express_checkout_paypal_payflow_required\";s:1:\"1\";s:126:\"payment_us_paypal_payment_gateways_paypal_payflowpro_with_express_checkout_paypal_payflow_required_paypal_payflow_api_settings\";s:1:\"1\";s:127:\"payment_us_paypal_payment_gateways_paypal_payflowpro_with_express_checkout_paypal_payflow_required_paypal_payflow_advertise_bml\";s:1:\"0\";s:164:\"payment_us_paypal_payment_gateways_paypal_payflowpro_with_express_checkout_paypal_payflow_required_paypal_payflow_advertise_bml_paypal_payflow_settings_bml_homepage\";s:1:\"0\";s:168:\"payment_us_paypal_payment_gateways_paypal_payflowpro_with_express_checkout_paypal_payflow_required_paypal_payflow_advertise_bml_paypal_payflow_settings_bml_categorypage\";s:1:\"0\";s:167:\"payment_us_paypal_payment_gateways_paypal_payflowpro_with_express_checkout_paypal_payflow_required_paypal_payflow_advertise_bml_paypal_payflow_settings_bml_productpage\";s:1:\"0\";s:164:\"payment_us_paypal_payment_gateways_paypal_payflowpro_with_express_checkout_paypal_payflow_required_paypal_payflow_advertise_bml_paypal_payflow_settings_bml_checkout\";s:1:\"0\";s:98:\"payment_us_paypal_payment_gateways_paypal_payflowpro_with_express_checkout_settings_paypal_payflow\";s:1:\"1\";s:131:\"payment_us_paypal_payment_gateways_paypal_payflowpro_with_express_checkout_settings_paypal_payflow_settings_paypal_payflow_advanced\";s:1:\"0\";s:156:\"payment_us_paypal_payment_gateways_paypal_payflowpro_with_express_checkout_settings_paypal_payflow_settings_paypal_payflow_advanced_paypal_payflow_avs_check\";s:1:\"0\";s:164:\"payment_us_paypal_payment_gateways_paypal_payflowpro_with_express_checkout_settings_paypal_payflow_settings_paypal_payflow_advanced_paypal_payflow_settlement_report\";s:1:\"0\";s:155:\"payment_us_paypal_payment_gateways_paypal_payflowpro_with_express_checkout_settings_paypal_payflow_settings_paypal_payflow_advanced_paypal_payflow_frontend\";s:1:\"0\";s:106:\"payment_us_paypal_payment_gateways_paypal_payflowpro_with_express_checkout_paypal_payflow_express_checkout\";s:1:\"1\";s:147:\"payment_us_paypal_payment_gateways_paypal_payflowpro_with_express_checkout_paypal_payflow_express_checkout_paypal_payflow_express_checkout_advanced\";s:1:\"0\";s:50:\"payment_us_paypal_payment_gateways_payflow_link_us\";s:1:\"0\";s:72:\"payment_us_paypal_payment_gateways_payflow_link_us_payflow_link_required\";s:1:\"1\";s:98:\"payment_us_paypal_payment_gateways_payflow_link_us_payflow_link_required_payflow_link_payflow_link\";s:1:\"1\";s:99:\"payment_us_paypal_payment_gateways_payflow_link_us_payflow_link_required_payflow_link_advertise_bml\";s:1:\"0\";s:134:\"payment_us_paypal_payment_gateways_payflow_link_us_payflow_link_required_payflow_link_advertise_bml_payflow_link_settings_bml_homepage\";s:1:\"0\";s:138:\"payment_us_paypal_payment_gateways_payflow_link_us_payflow_link_required_payflow_link_advertise_bml_payflow_link_settings_bml_categorypage\";s:1:\"0\";s:137:\"payment_us_paypal_payment_gateways_payflow_link_us_payflow_link_required_payflow_link_advertise_bml_payflow_link_settings_bml_productpage\";s:1:\"0\";s:134:\"payment_us_paypal_payment_gateways_payflow_link_us_payflow_link_required_payflow_link_advertise_bml_payflow_link_settings_bml_checkout\";s:1:\"0\";s:72:\"payment_us_paypal_payment_gateways_payflow_link_us_settings_payflow_link\";s:1:\"1\";s:103:\"payment_us_paypal_payment_gateways_payflow_link_us_settings_payflow_link_settings_payflow_link_advanced\";s:1:\"0\";s:134:\"payment_us_paypal_payment_gateways_payflow_link_us_settings_payflow_link_settings_payflow_link_advanced_payflow_link_settlement_report\";s:1:\"0\";s:125:\"payment_us_paypal_payment_gateways_payflow_link_us_settings_payflow_link_settings_payflow_link_advanced_payflow_link_frontend\";s:1:\"0\";s:89:\"payment_us_paypal_payment_gateways_payflow_link_us_settings_payflow_link_express_checkout\";s:1:\"1\";s:137:\"payment_us_paypal_payment_gateways_payflow_link_us_settings_payflow_link_express_checkout_settings_payflow_link_express_checkout_advanced\";s:1:\"0\";s:45:\"payment_us_paypal_alternative_payment_methods\";s:1:\"1\";s:65:\"payment_us_paypal_alternative_payment_methods_express_checkout_us\";s:1:\"0\";s:91:\"payment_us_paypal_alternative_payment_methods_express_checkout_us_express_checkout_required\";s:1:\"1\";s:134:\"payment_us_paypal_alternative_payment_methods_express_checkout_us_express_checkout_required_express_checkout_required_express_checkout\";s:1:\"1\";s:105:\"payment_us_paypal_alternative_payment_methods_express_checkout_us_express_checkout_required_advertise_bml\";s:1:\"0\";s:127:\"payment_us_paypal_alternative_payment_methods_express_checkout_us_express_checkout_required_advertise_bml_settings_bml_homepage\";s:1:\"0\";s:131:\"payment_us_paypal_alternative_payment_methods_express_checkout_us_express_checkout_required_advertise_bml_settings_bml_categorypage\";s:1:\"0\";s:130:\"payment_us_paypal_alternative_payment_methods_express_checkout_us_express_checkout_required_advertise_bml_settings_bml_productpage\";s:1:\"0\";s:127:\"payment_us_paypal_alternative_payment_methods_express_checkout_us_express_checkout_required_advertise_bml_settings_bml_checkout\";s:1:\"0\";s:77:\"payment_us_paypal_alternative_payment_methods_express_checkout_us_settings_ec\";s:1:\"1\";s:98:\"payment_us_paypal_alternative_payment_methods_express_checkout_us_settings_ec_settings_ec_advanced\";s:1:\"0\";s:133:\"payment_us_paypal_alternative_payment_methods_express_checkout_us_settings_ec_settings_ec_advanced_express_checkout_billing_agreement\";s:1:\"0\";s:133:\"payment_us_paypal_alternative_payment_methods_express_checkout_us_settings_ec_settings_ec_advanced_express_checkout_settlement_report\";s:1:\"0\";s:124:\"payment_us_paypal_alternative_payment_methods_express_checkout_us_settings_ec_settings_ec_advanced_express_checkout_frontend\";s:1:\"0\";s:25:\"payment_us_cashondelivery\";s:1:\"0\";s:23:\"payment_us_banktransfer\";s:1:\"0\";s:15:\"payment_us_free\";s:1:\"0\";s:18:\"payment_us_checkmo\";s:1:\"0\";s:24:\"payment_us_purchaseorder\";s:1:\"0\";s:13:\"oauth_cleanup\";s:1:\"1\";s:14:\"oauth_consumer\";s:1:\"1\";s:12:\"admin_emails\";s:1:\"1\";s:13:\"admin_startup\";s:1:\"1\";s:9:\"admin_url\";s:1:\"1\";s:14:\"admin_security\";s:1:\"1\";s:15:\"admin_dashboard\";s:1:\"1\";s:13:\"admin_captcha\";s:1:\"1\";s:11:\"system_cron\";s:1:\"1\";s:17:\"system_cron_index\";s:1:\"1\";s:19:\"system_cron_default\";s:1:\"1\";s:11:\"system_smtp\";s:1:\"1\";s:15:\"system_currency\";s:1:\"1\";s:24:\"system_adminnotification\";s:1:\"1\";s:13:\"system_backup\";s:1:\"1\";s:22:\"system_full_page_cache\";s:1:\"1\";s:30:\"system_full_page_cache_varnish\";s:1:\"1\";s:34:\"system_media_storage_configuration\";s:1:\"1\";s:34:\"dev_front_end_development_workflow\";s:1:\"1\";s:12:\"dev_restrict\";s:1:\"1\";s:9:\"dev_debug\";s:1:\"1\";s:12:\"dev_template\";s:1:\"1\";s:20:\"dev_translate_inline\";s:1:\"1\";s:6:\"dev_js\";s:1:\"1\";s:7:\"dev_css\";s:1:\"1\";s:9:\"dev_image\";s:1:\"1\";s:10:\"dev_static\";s:1:\"1\";s:8:\"dev_grid\";s:1:\"1\";}}' WHERE (user_id = 1)

Some of the above is just section-level settings, and some is the actual within-section settings. This seems to be a design flaw.

Regardless, I propose and import/export feature of the store settings. I have seen this done a long time ago as YAML, but XML would see probably the most appropriate.

Initially it could be simply a key=>value pairing

INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'design/search_engine_robots/default_robots', 'INDEX,FOLLOW')

Above would have $key = 'design/search_engine_robots/default_robots' and $value ='INDEX,FOLLOW'

This may become a bit tricky since the value can be text and could get lengthy.

Alternatively, it could be organized like the ADMIN settings are...

Section(s), Key, Value

Above has Section "Design", subsection "Search Engine Robots", Key = "default_robots" and value ='INDEX,FOLLOW'

INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'currency/options/base', 'USD')
INSERT INTO `directory_currency_rate` (`currency_from`,`currency_to`,`rate`) VALUES ('USD', 'USD', '1') ON DUPLICATE KEY UPDATE `rate` = VALUES(`rate`)
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'currency/options/default', 'USD')
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'currency/options/allow', 'CAD,USD')
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'currency/webservicex/timeout', '100')
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'currency/import/enabled', '0')
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'currency/import/service', 'webservicex')
INSERT INTO `core_config_data` (`path`, `value`) VALUES ('crontab/default/jobs/currency_rates_update/schedule/cron_expr', '0 0 * * *')
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'currency/import/time', '00,00,00')
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'currency/import/frequency', 'D')
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'currency/import/error_email', NULL)
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'currency/import/error_email_identity', 'general')
INSERT INTO `core_config_data` (`scope`, `scope_id`, `path`, `value`) VALUES ('default', '0', 'currency/import/error_email_template', 'currency_import_error_email_template')

Section Currency, Subsections (options, import, webservicex should become api/webservicex see #3093 ), and key=>value pairs

Based on section/subsection(s) with key=>values, you could easily develop a XML conversion system. I could save the system settings, which I could edit in a text-format. Import/Export of the XML

This would enhance deployment with more flexibility and extensibility.

MonteShaffer commented 8 years ago

Another note:

currency => exchangeapis => webservicex => {json object of settings} currency => exchangeapis => google => {json object of settings} currency => exchangeapis => yahoo => {json object of settings}

timeout is a feature of the webservice api, but each API may have specific settings.

For example, APIs may require key/value authentications, or a flag to "parse" as discussed in #3093

MonteShaffer commented 8 years ago

Anyone out there?

veloraven commented 8 years ago

@MonteShaffer thank you for your feedback. Is this issue still actual? If it is, please provide the used Magento version and if it was clear install or some upgrade. If it is not, please close the issue.

veloraven commented 8 years ago

According to contributor guide, tickets without response for two weeks should be closed. If this issue still reproducible please feel free to create the new one: format new issue according to the Issue reporting guidelines: with steps to reproduce, actual result and expected result and specify Magento version.