“League Table” Documentation by “DAEXT” v2.09

“League Table”

Created: 17/08/2020
By: DAEXT
Email: support@daext.com

Thank you for using League Table. If you have any questions that are beyond the scope of this help file please contact us via email or with the contact form available in our CodeCanyon Profile.

Video Tutorials
Installation (Single Site)
Installation (Multisite)
Tables Menu
Import Menu
Export Menu
Options Menu
Include a table in a post
Upgrade from version 1.x to 2.x
Credits
FAQ

A) Video Tutorials

This video series covers the functionalities of the the League Table plugin.

Please note that not all the aspects and implications are covered in this section, it's recommended that you read the entire documentation (FAQ included) before using this plugin in a production environment or asking for support to the plugin author.

B) Installation (Single Site)

With this procedure you will be able to install the League Table plugin on your WordPress website.

Visit the Plugins -> Add New menu
Click on the Upload Plugin button and select the zip file you just downloaded
Click on Install Now
Click on Activate Plugin

C) Installation (Multisite)

This plugin supports both a Network Activation (the plugin will be activate on all the sites of your WordPress Network) and a Single Site Activation in a WordPress Network environment (your plugin will be activate on a single site of the network).

With this procedure you will be able to perform a Network Activation:

Visit the Plugins -> Add New menu
Click on the Upload Plugin button and select the zip file you just downloaded
Click on Install Now
Click on Network Activate

With this procedure you will be able to perform a Single Site Activation in a WordPress Network environment:

Visit the specific site of the WordPress Network where you want to install the plugin
Visit the Plugins menu
Click on the Activate button

The League Table -> Tables menu is the most important administrative page of this plugin and allows you to create, edit and delete tables.

With this procedure you will be able to create a table:

In the main form enter the Name and the Description of the table
Set the Rows and the Columns of the table
Enter the values that will be displayed in the table in the Data spreadsheet editor
Customize the look and the behavior of the table with the 105 available options (to receive more information about a specific option hover the mouse cursor over the black question mark on the right of the option)
Save the table by clicking the Add Table button

With this procedure you will be able to edit a table:

Click the pencil icon associated with the table
Modify the table options and data based on your needs
Use the Update Table button to save your changes

If you want to customize a specific cell of the table this plugin gives you the ability to create and delete cell properties. Follow this procedure to create cell properties:

In the Data spreadsheet editor click the cell for which you want to add the properties
Use the 17 properties that will appear on the cell properties area to customize the cell (to receive more information about a specific cell property hover the mouse cursor over the black question mark on the right of the cell property)
Click the Add Cell Properties button to create the properties

With the League Table -> Import menu you will be able to import tables previously exported with the League Table -> Export menu.

Follow this procedure to import a table or multiple tables:

Click the Choose File button
Select the XML file that includes the tables
Click the Upload file and import button

With the League Table -> Export menu you will be able to generate an XML file that includes all your tables. Having your tables saved in an XML file is extremely convenient as a backup method, or if you want to move your tables between different WordPress installations or between different sites of a WordPress network.

Follow this procedure to export your tables:

Click the Export button
The XML file will be downloaded in the default download folder of your operative system

The League Table -> Options menu allows you to configure the plugin options. To receive more information about a specific option hover the mouse cursor over the black question mark on the right of the option.

H) Include a table in a post

Please follow this procedure to include a table in a post with the TinyMCE editor

Edit a post, page or custom post type
Set the editor in Visual Mode
Click the League Table button
Search or select a table with the provided select box
Click the Add Table button

Please follow this procedure to include a table in a post with the League Table block:

Edit a post, page or custom post type
Select the Visual Editor mode
Add the League Table block
Search or select a table with the provided select box

I) Upgrade from version 1.x to 2.x

The tables of version 2.x are stored inside database tables that have a structure partially compatible with the database tables used in version 1.x, for this reason not all the information associated with the tables created with version 1.x will be available in version 2.x

Only the following data will be transferred from version 1.x to version 2.x:

Name
Rows
Columns
Show Position
Table Margin Top
Table Margin Bottom
Header Background Color
Header Font Color
Even Rows Background Color
Even Rows Font Color
Odd rows Background Color
Odd Rows Font Color
Header Border Color
Rows Border Color
Phone Breakpoint
Tablet Breakpoint
Position Label
The content of the cells

If you have installed League Table 1.x and you want to update the plugin to League Table 2.x please proceed as follows:

Backup your website
From the plugins menu click "Deactivate" to deactivate League Table version 1.x
Completely delete the public_html/wp-content/plugins/league-table/ folder from your server file system
Create the public_html/wp-content/plugins/league-table/ folder and include the files of League Table 2.x
From the plugins menu click "Activate"

League Table 2.x should now be properly installed. Please note that the identifiers of the tables will change when you import the tables from version 1.x, for this reason you have also to update the shortcodes used to include the tables in your posts. With version 2.x you can easily add the shortcodes in your posts with the The TinyMCE Button.

Please note that this procedure does not delete the database tables used by League Table 1.x, for this reason if you experience any problems during the update process you can go back to the old version simply by copying the files of version 1.x in the public_html/wp-content/plugins/league-table/ folder.

If the upgrade process is successful you can use phpMyAdmin to delete from your database the following database tables used only by version 1.x:

[prefix]_da_lt_table
[prefix]_da_lt_table_item

H) Credits

This plugin makes use of the following resources:

Chosen licensed under the MIT License
Handsontable licensed under the MIT License
TableSorter licensed under the MIT License.

J) FAQ

Why the links placed in the header cells are not displayed?

If the Enable Manual Sorting option is enabled, the links in the header cells will not be displayed because the click event will be used to sort the columns.

Why the images are not aligned with the text of the cell?

You can avoid image collapsing by giving enough space to the table cells that include the images. You can achieve this with one of these methods:

Change the table width by using the Table Width and the Table Width Value options
Set the minimum width of the table with the Table Minimum Width option
Put the table in a container with the Enable Container option and set the appropriate size of the container with the Container Width and the Container Height options
Reduce the number of columns to increase the width available for each column
Decrease the font size of the cells
Decrease the length of the text in the cells
Use a condensed font

Why the text of a cell is distributed on multiple lines?

When there isn't enough space the text of a cell is distributed on multiple lines. You can solve this problem by using the same methods suggested in the Why the images are not aligned with the text of the cell? FAQ.

Which date format should I use?

To sort a table based on a column which include dates please use this table as a reference:

Format	Example 1	Example 2	Example 3	Example 4	Example 5
Time	03:00 AM	08:20	14:40	18:00	07:15 PM
ISO Date	1981-02-15	2015-01-15	2017-03-21	2018-12-24	2021-05-27
US Long Date	07 Nov 1946	06 Apr 1984	23 Nov 2011	25 Oct 2016	12 Nov 2023
Short Date (DDMMYYYY)	25/12/2016	25-12-2016	25.12.2016	25,12,2016	25 12 2016
Short Date (YYYYMMDD)	2016/12/25	2016-12-25	2016.12.25	2016,12,25	2016 12 25
Short Date (MMDDYYYY)	12/25/2016	12-25-2016	12.25.2016	12,25,2016	12 25 2016

How to increase the maximum number of supported rows and columns?

To avoid performance issues the maximum number of rows has been limited to 10000 and the maximum number of columns has been limited to 40. If you want to modify the maximum number of supported rows and columns please contact the plugin support.

Why I receive the message "You can't use multiple times the same shortcode."?

This message is generated in the following situations:

You are using the same shortcode multiple times in a page (this is not allowed, if you want to display the same table multiple times in a page you have to clone the table)
Your theme or one of your plugins is running the shortcode mulitiple times. In this case you can solve by disabling or removing the theme/plugin that is forcing this behavior or alternatively by setting the League Table -> Options -> General -> Verify Single Shortcode option to "No".

Which versions of PHP are supported?

PHP 5.2 and later versions are supported.

Which versions of WordPress are supported?

WordPress 4.0 and later versions are supported.