Please wait...

Table Creation Wizard for WordPress

Video versionA video overview of Table Creation Wizard

Step 1First step - choose the type of table that you would like to create

Table Creation Wizard in WordPress

In the first wizard step you see different ways of creating a table – which result in different table types. The explanation of differences is provided under each option. There is no configuration – on this step you just need to choose one of the options and click “Next“.

If you choose the first option, you will be redirected to the Configure table page, where you can choose the data source (MySQL, Excel, CSV, Google Spreadsheet, JSON, XML, Serialized PHP array) and create the table – you can read more about it here.

Step 2, manually created tablesConfigure the table and column structure

If you choose to create a table manually, on the second step you will be able to configure the table structure: set the table name, number of columns, each column name, column data type, define possible values if necessary and the default value for the editor.

Once you configure the structure and press ‘Create the table’, your table will be created, and you will be redirected to the table configuration editor.

You can read full instructions about creating this type of tables here.

Step 2, importing table dataProvide the CSV/Excel file or link to Google Spreadsheet with the data to import

If you choose to create a table by importing table data from one of the possible data sources (Excel or CSV file, or Google spreadsheet) on the second step you will be asked to provide a file (if you use Excel or CSV), or paste a URL if you use Google Spreadsheet.

Read here the full instructions for creating this type of tables.

Step 2, generate a WordPress DB queryChoose the posts and post properties that you would like to add to the query

If you choose to create a table based on a query to WordPress database, you will see a screen where you would need to choose the posts and post properties that you can use in the table.

In the first column you see all the post types registered in your WordPress, you can select the ones that you want to use and click “Add” so that they would appear in the second column. Then in the third column you can see the list of post properties available to be displayed in the table – you can add these post properties similarly to the fourth column, which will be the list of your table fields.

In the bottom part you can configure conditions for the query, and the grouping rules.

You can read the full instruction on creating such tables here.

When you define all the query parameters, you can click ‘Next‘ to go to the table preview step.

Step 2, generate a MySQL DB queryChoose tables and columns that you would like to add to the query

Table Creation Wizard - create MySQL query

If you choose to create a table based on a query to MySQL database, you will see a screen where you would need to choose the tables and columns that you can use in the table.

In the first column you see all the tables registered in your MySQL database, you can select the ones that you want to use and click “Add” so that they would appear in the second column. Then in the third column you can see the list of post columns available to be displayed in the table – you can add these columns similarly to the fourth column, which will be the list of your table fields.

In the bottom part you can configure conditions for the query, and the grouping rules.

You can read the full instruction on creating such tables here.

When you define all the query parameters, you can click ‘Next‘ to go to the table preview step.

Step 3, Configure table importChoose which columns to import and set the new column types

When you are creating a table by importing data from a data source, on the third step you will preview the columns that wpDataTables fetched in the provided file or URL, see the ‘guessed’ data type (and change it if necessary), preview the data, and remove some columns from import if necessary, or optionally add new ones.

You can find the full instructions on how to create wpDataTables based on importing data from different data sources here.

When you finish with configuring and click ‘Next‘, the table will be created, data imported, and you will be redirected to the table configuration page.

Step 3, Preview generated querySee the query that has been generated and the preview the result

wpDataTables generated query preview

When you are creating a table by generating a query to WordPress database or MySQL database, the third step of the wizard is previewing the query, with an option  to edit it if necessary, and preview of first rows of the future table.

You can click on refresh button if you edit the query to refresh the preview.

Once you are satisfied with the preview, you can click ‘Next‘ to create a wpDataTable based on this query.

You can read full instructions about creating this type of tables here for MySQL and here for WordPress databases.

Never miss new features!

Join 2000+ newsletter subscribers

Never miss notifications about new cool features, promotions, giveaways or freebies - subscribe to our newsletter! We send about one mail per month, and do our best to keep our announcements interesting.

We never spam or disclose your address to anyone.