SQL To CPT

Descripción

This plugin helps you migrate legacy SQL database tables to WordPress’ Custom Post Types (CPT). It provides a user-friendly UI interface that enables users upload an SQL file which is then parsed and converted to a CPT with meta data that is recognisable within WordPress.

If you ever need to migrate a non-WordPress database table into WP, look no further. This is exactly what you need!

✔️ Features

Our plugin comes with everything you need to easily migrate SQL tables to CPTs.

✔️ Import & Convert to CPT feature.
✔️ Quick & Lightening Fast uploads.
✔️ Friendly, User Interface (UI).
✔️ Custom Post Type Capabilities.
✔️ Error Loggging Capabilities.
✔️ Custom Hooks to help you customize plugin behaviour.
✔️ Available in mutiple langauges such as Arabic, Chinese, Hebrew, Hindi, Russian, German, Italian, Croatian, Spanish & French languages.
✔️ Backward compatible, works with most WP versions.

✨ Getting Started

Head over to the SQL to CPT options page. Upload an SQL file of your choice by clicking on the Import SQL File. This would analyse your SQL table and show you the table name and table columns you are about to import. Once ready, click on the Convert to CPT button to complete the process.

On import completion, you should now be re-directed to the Custom Post Type page of your newly imported data!

You can get a taste of how this works, by using the demo link.

⚡ Why SQL to CPT ?

  1. Because you need something that works great and fast!
  2. Because you want to port your data across platforms easily.
  3. Because you don’t want to spend hours building custom software for this.
  4. Because you think SQL to CPT is cool.

NB: At the moment, the SQL to CPT 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.

🔌🎨 Plug and Play or Customize

The SQL to CPT plugin is built to work right out of the box. Simply install, activate and start using.

Want to add your personal touch? All of our documentation can be found here. You can override the plugin’s behaviour with custom logic of your own using hooks.

Contribute

If you’d like to contribute to the development of this plugin, you can find it on GitHub.

To build, clone repo and run yarn install && yarn build

Capturas

  • Import SQL File screen – Upload your SQL File by clicking on the ‘Import SQL File’ button.
  • Import Modal – Select the SQL file you intend to import.
  • Custom Post Type page – List of uploaded data from SQL file.
  • Custom Post Type screen – Imported SQL data showing custom fields in CPT.

Instalación

  1. Go to ‘Plugins > Add New’ on your WordPress admin dashboard.
  2. Search for ‘SQL To CPT’ plugin from the official WordPress plugin repository.
  3. Click ‘Install Now’ and then ‘Activate’.
  4. Head over to the ‘SQL to CPT’ options page.
  5. Upload an SQL file of your choice and convert it to a Custom Post Type (CPT).

Reseñas

No hay reseñas para este plugin.

Colaboradores y desarrolladores

«SQL To CPT» es un software de código abierto. Las siguientes personas han colaborado con este plugin.

Colaboradores

Traduce «SQL To CPT» a tu idioma.

¿Interesado en el desarrollo?

Revisa el código , echa un vistazo al repositorio SVN o suscríbete al registro de desarrollo por RSS.

Registro de cambios

1.1.0

  • Fix missing Import route class.
  • Implement Post class for handling CPTs.
  • Add new Custom Hooks: sqlt_cpt_post_title, sqlt_cpt_post_labels, sqlt_cpt_post_options.
  • Add new screenshot images.
  • Update README notes.
  • Tested up to WP 6.7.1.

1.0.1

  • Change hook names to use sqlt prefix.
  • Custom Hooks now bear sqlt_cpt_table_name, sqlt_cpt_table_columns, sqlt_cpt_table_rows.
  • Tested up to WP 6.6.2.

1.0.0

  • Add ability to upload SQL file to Custom Post Type (CPT).
  • Custom Hooks sqlt_cpt_table_name, sqlt_cpt_table_columns, sqlt_cpt_table_rows.
  • Custom Options page.
  • Fix bugs & linting issues.
  • Tested up to WP 6.6.2.