League Table

Table of Contents

  1. Video Tutorials
  2. Installation (Single Site)
  3. Installation (Multisite)
  4. Tables Menu
  5. Import Menu
  6. Export Menu
  7. Options Menu
  8. Include a table in a post
  9. Upgrade from version 1.x to 2.x
  10. Credits
  11. FAQ

1) Video Tutorials

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

Please note that not all the aspects and implications are covered in this section.

2) Installation (Single Site)

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

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

3) Installation (Multisite)

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

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

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

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

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

4) Tables Menu

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:

  1. In the main form, enter the Name and the Description of the table
  2. Set the Rows and the Columns of the table
  3. Enter the values that will be displayed in the table in the Data spreadsheet editor
  4. Customize the look and the behavior of the table with the other 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.
  5. Save the table by clicking the Add Table button

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

  1. Click the pencil icon associated with the table
  2. Modify the table options and data based on your needs
  3. 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:

  1. In the Data spreadsheet editor, click the cell for which you want to add the properties
  2. Use the two 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.
  3. Click the Add Cell Properties button to create the properties

5) Import Menu

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:

  1. Click the Choose File button
  2. Select the XML file that includes the tables
  3. Click the Upload file and import button

6) Export Menu

With the League Table -> Export menu, you will be able to generate an XML file that includes all your tables.

Follow this procedure to export your tables:

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

7) Options Menu

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.

8) Include a table in a post

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

  1. Edit a post, page, or custom post type
  2. Set the editor in Visual Mode
  3. Paste the shortcode associated with the table in the post editor

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

  1. Edit a post, page, or custom post type
  2. Select the Visual Editor mode
  3. Add the Shortcode block
  4. Paste the shortcode associated with the table in the input field of the block

9) 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:

  1. Backup your website
  2. From the plugins menu, click “Deactivate” to deactivate League Table version 1.x
  3. Completely delete the public_html/wp-content/plugins/league-table/ folder from your server file system
  4. Create the public_html/wp-content/plugins/league-table/ folder and include the files of League Table 2.x
  5. 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 also have to update the shortcodes used to include the tables in your posts.

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

10) Credits

This plugin makes use of the following resources:

11) FAQ

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

You can avoid images 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
  • Insert 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 is the text of a cell distributed on multiple lines?

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

Which date format should I use?

To sort a table based on a column that includes dates, please use this reference:

FormatExample 1Example 2Example 3Example 4Example 5
Time03:00 AM08:2014:4018:0007:15 PM
ISO Date1981-02-152015-01-152017-03-212018-12-242021-05-27
US Long Date07 Nov 194606 Apr 198423 Nov 201125 Oct 201612 Nov 2023
Short Date (DDMMYYYY)25/12/201625-12-201625.12.201625,12,201625 12 2016
Short Date (YYYYMMDD)2016/12/252016-12-252016.12.252016,12,252016 12 25
Short Date (MMDDYYYY)12/25/201612-25-201612.25.201612,25,201612 25 2016

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.