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!

Jacques Malgrange

<p>This lightweight plugin makes it easy to install the millions of GEONAMES Data on your WordPress site.<br />
It allows :</p>
<ul>
<li>Install data from one or more file (place & postal code) ;</li>
<li>Choose column to install to avoid excessive enlargement of the base ;</li>
<li>Choose type of data to install (city, park, road…) ;</li>
<li>Remove all the data.</li>
<li>Check data in the database.</li>
<li>Edit and change datas from Dashboard.</li>
<li>Display the places on OpenStreetMap.</li>
</ul>
<p>A shortcode is also available to create a city region and country taxonomy.</p>
<p>This plugin will give you plenty of ideas to improve the quality of your website.</p>
<p>Official <a href="http://www.geonames.org/" rel="nofollow ugc">GeoNames</a> website.</p>
<h3>1.9.1</h3>
<p>05/12/2024</p>
<ul>
<li>Fix XSS vulnerability in shortcode attributes</li>
<li>Fix translation issue with WP 6.7</li>
</ul>
<h4>1.9</h4>
<p>18/10/2024 – Fix XSS vulnerability on geoSearch field</p>
<h4>1.8</h4>
<p>08/02/2022</p>
<ul>
<li>Update Leaflet 1.7.1.</li>
<li>Update SumoSelect 3.4.2.</li>
<li>Split admin sidet in a specific file.</li>
</ul>
<h4>1.7</h4>
<p>21/03/2020</p>
<ul>
<li>Fix issue with very long line in Geoname DB.</li>
<li>Add nonce.</li>
<li>Braces style standardisation in the code.</li>
</ul>
<h4>1.6</h4>
<p>14/03/2019 – Add Postal code database.</p>
<h4>1.5.1</h4>
<p>27/01/2018 – Curl used by default if exists in place of File_Get_Content.</p>
<h4>1.5</h4>
<p>12/01/2018 – Add tab to edit and change datas.</p>
<h4>1.4</h4>
<p>24/06/2017</p>
<ul>
<li>Add Taxonomy.</li>
<li>Add shortcode to create taxonomy in the site.</li>
<li>Add template to customize the taxonomy form.</li>
<li>Ability to download multiple files in one click.</li>
<li>Check the database with a taxonomy form and display the place on OpenStreetMap.</li>
<li>Multisite.</li>
</ul>
<h4>1.3</h4>
<p>09/10/2015 – Fix “Fatal error: Out of memory (allocated xxx) (tried to allocate xxx bytes)”.</p>
<p>07/06/2016 – 1.3.1 – Fix error when reactivate (header already sent…).</p>
<h4>1.2</h4>
<p>06/08/2015 – Fix installation bug.</p>
<h4>1.1</h4>
<p>01/12/2014 – Add Ajax hook.</p>
<h4>1.0</h4>
<p>25/11/2014 – First stable version.</p>


WP GeoNames

Allows you to insert all or part of the global GeoNames database in your WordPress base.

SQL To CPT vs WP GeoNames