badasswp

<p>This plugin helps you <strong>migrate legacy SQL database tables</strong> to WordPress’ <strong>Custom Post Types (CPT)</strong>. It provides a <strong>user-friendly UI interface</strong> that enables users upload an SQL file which is then parsed and converted to a CPT with meta data that is recognisable within WordPress.</p>
<p>If you ever need to migrate a non-WordPress database table into WP, look no further. This is exactly what you need!</p>
<h4>✔️ Features</h4>
<p>Our plugin comes with everything you need to easily migrate SQL tables to CPTs.</p>
<p>✔️ <strong>Import & Convert to CPT</strong> feature.<br />
✔️ <strong>Quick & Lightening Fast uploads</strong>.<br />
✔️ <strong>Friendly, User Interface (UI)</strong>.<br />
✔️ <strong>Custom Post Type Capabilities</strong>.<br />
✔️ <strong>Error Loggging Capabilities</strong>.<br />
✔️ <strong>Custom Hooks</strong> to help you customize plugin behaviour.<br />
✔️ Available in <strong>mutiple langauges</strong> such as Arabic, Chinese, Hebrew, Hindi, Russian, German, Italian, Croatian, Spanish & French languages.<br />
✔️ <strong>Backward compatible</strong>, works with most WP versions.</p>
<h4>✨ Getting Started</h4>
<p>Head over to the <strong>SQL to CPT</strong> options page. Upload an SQL file of your choice by clicking on the <strong>Import SQL File</strong>. This would analyse your SQL table and show you the <strong>table name</strong> and <strong>table columns</strong> you are about to import. Once ready, click on the <strong>Convert to CPT</strong> button to complete the process.</p>
<p>On import completion, you should now be re-directed to the Custom Post Type page of your newly imported data!</p>
<p>You can get a taste of how this works, by using the <a href="https://tastewp.com/create/NMS/8.0/6.7.0/sql-to-cpt/twentytwentythree?ni=true&origin=wp" rel="nofollow ugc">demo</a> link.</p>
<h4>⚡ Why SQL to CPT ?</h4>
<ol>
<li>Because you need something that works great and fast!</li>
<li>Because you want to port your data across platforms easily.</li>
<li>Because you don’t want to spend hours building custom software for this.</li>
<li>Because you think <strong>SQL to CPT</strong> is cool.</li>
</ol>
<p>NB: At the moment, the <strong>SQL to CPT</strong> plugin currently does not provide a way for users to import more than one SQL table at a time, this feature should be available in future releases as well as the option to remove unused CPTs.</p>
<h4>🔌🎨 Plug and Play or Customize</h4>
<p>The SQL to CPT plugin is built to work right out of the box. Simply install, activate and start using.</p>
<p>Want to add your personal touch? All of our documentation can be found <a href="https://github.com/badasswp/sql-to-cpt" rel="nofollow ugc">here</a>. You can override the plugin’s behaviour with custom logic of your own using <a href="https://github.com/badasswp/sql-to-cpt?tab=readme-ov-file#hooks" rel="nofollow ugc">hooks</a>.</p>
<h3>Contribute</h3>
<p>If you’d like to contribute to the development of this plugin, you can find it on <a href="https://github.com/badasswp/sql-to-cpt" rel="nofollow ugc">GitHub</a>.</p>
<p>To build, clone repo and run <code>yarn install && yarn build</code></p>


SQL To CPT

Import & Convert SQL tables to Custom Post Types (CPT). Migrate legacy SQL table data to WordPress custom post types of your choice. It's super fast!

Guaven Labs

<p>The plugin can create beautiful charts based on your SQL queries, then you can use those charts in any part of your website.<br />
You can use both native wp and non-wp mysql tables in your queries.</p>
<h3>Pie chart, Donut chart, Line chart, Bar chart, Column chart, Area chart</h3>
<h4>How to use</h4>
<ol>
<li>
<p>Give any name to your report.</p>
</li>
<li>
<p>Use our preinstalled chart or create new one yourself: choose desired chart type, type sql query,<br />
enter field names, labels and then press to Publish/Update</p>
</li>
<li>
<p>You can use multiple SQL queries too. Just split them by ; sign. You can also add shortcode argument to SQL query. For example if you<br />
type “select * from wp_posts where ID>{arg1}” then it you can pass arg1 value to the query with  [gvn_schart_2 id=”2″ arg1=”11″] shortcode.</p>
</li>
<li>
<p>After update/save you will see needed shortcode below there. You can use that shortcode anywhere in your website: in pages, posts, widgets etc.</p>
</li>
<li>
<p>Just check “Show table-view data below the graph” in order to get table-list view below each chart.</p>
</li>
<li>
<p>Using “Dynamic Filters” you can create dynamic variables inside SQL code. It also creates corresponding dynamic input form above each chart.</p>
</li>
</ol>
<h4>Dynamic filters</h4>
<p>Use this format: variable_name~default_value~variable_label~variable_type | variable_name~default_value~variable_label~variable_type etc.</p>
<ul>
<li>variable_name – any single name you want.</li>
<li>default_value – default value when no any variable chosen by a user</li>
<li>variable_label – Label which would be visible at a form above the chart</li>
<li>variable_type – number, text or date</li>
<li>~ is a separator between variable elements.</li>
<li>| is a separator between variables</li>
</ul>
<p>For example if to put</p>
<p>limit_tag~10~Count~number | post_date_tag~2010-07-05 17:25:18~Date Published~date,</p>
<p>then you can use this SQL code</p>
<p>select * from wp_posts where post_date<{post_date_tag} limit {limit_tag}</p>
<p>in SQL CODE field.<br />
{post_date_tag} and {limit_tag} would be replaced with dynamic variables.</p>
<p>So, the plugin will automatically recognize it and put corresponding selectboxes above the chart.</p>
<h4>Website</h4>
<p><a href="https://guaven.com/my-sql-charts/" rel="nofollow ugc">https://guaven.com/my-sql-charts/</a></p>
<h4>Documentation</h4>
<p><a href="https://guaven.com/my-sql-charts/#docs" rel="nofollow ugc">https://guaven.com/my-sql-charts/#docs</a></p>
<h4>Bug Submission and Forum Support</h4>
<p><a href="https://guaven.com/contact/solution-request/" rel="nofollow ugc">Contact Page</a></p>
<h4>Please Vote if you liked our plugin</h4>
<p>Your votes really helps us. Thanks.</p>
<h3>Available Filters</h3>
<p>apply_filters( ‘guaven_sqlcharts_table_empty_cell’);</p>
<p>apply_filters(‘guaven_sqlcharts_pre_print_vars’);</p>
<p>apply_filters( ‘guaven_sqlcharts_final_output’);</p>
<p>apply_filters(‘guaven_sqlcharts_rendered_sql’);</p>


SQL Chart Builder

Unfortunately, this plugin is only useful for very specific use-cases, because it supports ONLY two database fields (i.e. X and Y axis, which almost never makes sense for the supported pie chart type but anyway). The external MySQL connector works well, so that part is great, but the shortcode doesn't output the charts and the "preview" doesn't honor the width and height settings. So, this could have been great, with just a little more love and attention. Ah well.

I had such high hopes :(

Turn Your SQL Queries to Beautiful Dynamic Charts- Pie, Line, Area, Donut, Bar Charts with date/input filters.

SQL To CPT vs SQL Chart Builder