{"id":78546,"date":"2017-12-12T09:32:45","date_gmt":"2017-12-12T09:32:45","guid":{"rendered":"https:\/\/wordpress.org\/plugins\/external-database-based-actions\/"},"modified":"2018-01-04T10:51:16","modified_gmt":"2018-01-04T10:51:16","slug":"external-database-based-actions","status":"closed","type":"plugin","link":"https:\/\/wordpress.org\/plugins\/external-database-based-actions\/","author":15767420,"comment_status":"closed","ping_status":"closed","template":"","meta":{"version":"0.1","stable_tag":"trunk","tested":"4.7.33","requires":"4.6","requires_php":"5.6","requires_plugins":"","header_name":"External Database Based Actions","header_author":"Cesar Morillas","header_description":"Do configurable actions conditioned by an external database","assets_banners_color":"edeeed","last_updated":"2018-01-04 10:51:16","external_support_url":"","external_repository_url":"","donate_link":"https:\/\/www.paypal.me\/CesarMorillas","header_plugin_uri":"http:\/\/apainmaculada.com","header_author_uri":"https:\/\/profiles.wordpress.org\/cmorillas1\/","rating":0,"author_block_rating":0,"active_installs":10,"downloads":1734,"num_ratings":0,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","faq","changelog"],"tags":[],"upgrade_notice":{"0.1":"<p>0.1 is the first release. Make a backup before upgrading.<\/p>"},"ratings":{"1":0,"2":0,"3":0,"4":0,"5":0},"assets_icons":{"icon-128x128.jpg":{"filename":"icon-128x128.jpg","revision":"1785333","resolution":"128x128","location":"assets"},"icon-256x256.jpg":{"filename":"icon-256x256.jpg","revision":"1785333","resolution":"256x256","location":"assets"}},"assets_banners":{"banner-1544x500.jpg":{"filename":"banner-1544x500.jpg","revision":"1785324","resolution":"1544x500","location":"assets"},"banner-772x250.jpg":{"filename":"banner-772x250.jpg","revision":"1785324","resolution":"772x250","location":"assets"}},"assets_blueprints":{},"all_blocks":[],"tagged_versions":[],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":"1785266","resolution":"1","location":"assets"},"screenshot-2.png":{"filename":"screenshot-2.png","revision":"1785266","resolution":"2","location":"assets"},"screenshot-3.png":{"filename":"screenshot-3.png","revision":"1785266","resolution":"3","location":"assets"},"screenshot-4.png":{"filename":"screenshot-4.png","revision":"1785266","resolution":"4","location":"assets"},"screenshot-5.png":{"filename":"screenshot-5.png","revision":"1785266","resolution":"5","location":"assets"}},"screenshots":{"1":"SQLite in connection tab.","2":"Google Sheets in connection tab.","3":"MySQL in connection tab.","4":"SQL Query conformation tab.","5":"Select an action."}},"plugin_section":[],"plugin_tags":[2423,153,1920,150,9471],"plugin_category":[59],"plugin_contributors":[150563],"plugin_business_model":[],"class_list":["post-78546","plugin","type-plugin","status-closed","hentry","plugin_tags-actions","plugin_tags-database","plugin_tags-external","plugin_tags-google","plugin_tags-spreadsheet","plugin_category-utilities-and-tools","plugin_contributors-cmorillas1","plugin_committers-cmorillas1"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/external-database-based-actions_edeeed.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/external-database-based-actions\/assets\/screenshot-1.png?rev=1785266","caption":"SQLite in connection tab."},{"src":"https:\/\/ps.w.org\/external-database-based-actions\/assets\/screenshot-2.png?rev=1785266","caption":"Google Sheets in connection tab."},{"src":"https:\/\/ps.w.org\/external-database-based-actions\/assets\/screenshot-3.png?rev=1785266","caption":"MySQL in connection tab."},{"src":"https:\/\/ps.w.org\/external-database-based-actions\/assets\/screenshot-4.png?rev=1785266","caption":"SQL Query conformation tab."},{"src":"https:\/\/ps.w.org\/external-database-based-actions\/assets\/screenshot-5.png?rev=1785266","caption":"Select an action."}],"raw_content":"<!--section=description-->\n<p>It provides an alternative way of getting data from an external database:\n*   Google Sheets\n*   SQLite\n*   MySQL\n*   Progresql<\/p>\n\n<p>A SQL query can be configured to get data from these databases and be used as method for authentication or for populate post or pages.<\/p>\n\n<p>The plugin is modular, so, new actions for the data gathered can be added to the plugin with minimal programming. You can contact me at cmorillas1@gmail.com<\/p>\n\n<!--section=installation-->\n<ol>\n<li>Upload the plugin files to the <code>\/wp-content\/plugins\/plugin-name<\/code> directory, or install the plugin through the WordPress plugins screen directly.<\/li>\n<li>Activate the plugin through the 'Plugins' screen in WordPress<\/li>\n<li>Use the Settings-&gt;Plugin Name screen to configure the plugin<\/li>\n<\/ol>\n\n<!--section=faq-->\n<dl>\n<dt>Installation Instructions<\/dt>\n<dd><ol>\n<li>Upload the plugin files to the <code>\/wp-content\/plugins\/plugin-name<\/code> directory, or install the plugin through the WordPress plugins screen directly.<\/li>\n<li>Activate the plugin through the 'Plugins' screen in WordPress<\/li>\n<li>Use the Settings-&gt;Plugin Name screen to configure the plugin<\/li>\n<\/ol><\/dd>\n<dt>I have the following error: \"cURL error 7: Failed to connect\". What is that ?<\/dt>\n<dd><p>It is a problem with cURL, may be you are in a free hosting and it doesn't allow you to connect external sites with cURL.<\/p><\/dd>\n<dt>Can I request an action ?<\/dt>\n<dd><p>You can contact with me at cmorillas1@gmail.com.<\/p><\/dd>\n<dt>Can I make my own action ?<\/dt>\n<dd><p>Yes you can, but please let me be aware of the new action in order to the action be included in next releases.<\/p><\/dd>\n<dt>Is there documentation to create my own actions ?<\/dt>\n<dd><p>Not yet, but you can contribute to the plugin if you wish.<\/p><\/dd>\n\n<\/dl>\n\n<!--section=changelog-->\n<h4>0.1<\/h4>\n\n<ul>\n<li>First release.<\/li>\n<\/ul>","raw_excerpt":"Get data from external database (including google sheets) and do configurable actions based on these data.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/78546","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=78546"}],"author":[{"embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/cmorillas1"}],"wp:attachment":[{"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=78546"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=78546"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=78546"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=78546"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=78546"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=78546"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}