Beskrivning

Need to insert a table into your page or post? WordPress Tables plugin will take your data in CSV/JSON format or directly from MySQL table and create an interactive data table. With WPTables plugin, you can easily create and manage your tables from the WordPress administration. Simply insert a shortcode into your page, article or post, and you are ready to go. That’s it! Enjoy your new table.

DEMO | SUPPORT | RECENSIONER | WEBBPLATS

WP Tables plugin’s main features are:

Infogar data med kraftfull kalkylbladredigerare
Importerar data från CSV- och JSON-filer
Showing data directly from MySQL database: by selecting a table or writing custom SQL query
Ändrar kolumnrubriker, sortering och synlighet
Number formatting
Sortera alfabetiskt och numeriskt
Pagination with options
Konfigurerbar bredd och höjd
Exportera skapad tabell till CSV-fil
6 fördefinierade färgteman
Stöder kortkoder från andra tillägg inne i tabell
Stöder länkar och bilder

Efter installationen av tillägget skapas tabeller i några få väldigt grundläggande steg:

Navigate to the `WPTables` menu in the WordPress administration dashboard
Click `Add New Table` and enter a name for the new table
Välj ett datakällsformat och infoga dina data (till exempel CSV-filen)
Efter att ha importerat data kan du redigera tabellfält och andra alternativ
Copy and paste the generated shortcode into your page or post (you can also use a button in the WordPress text editor to insert a table)

Skärmdumpar

Visualisera dina data i tabellen
Admin > Adding new table
Admin > Managing the table
Admin > Editing table data
Admin > All tables list
Admin > Table live preview

Vanliga frågor

Hur ändrar man tabellbredd/höjd?

Width of the table is 100% by default. Height is auto. But you can override these parameters by modifying a shortcode as following:
[wp_table id=”77″ width=”640px” height=”480px”]

Hur formaterar man nummer?

You can define a custom number format for columns with type Number.
1. In the WordPress administration open the table for editing.
2. In the Fields section find the necessary field and make sure that the type is Number
3. You will see the Formatting button next to the Type drop-down.
4. Set the desired format and click Apply.

Hur lägger man till valutasymbol till värden?

I WordPress-adminpanel, öppna tabellen för att redigera.
In the Fields section find the necessary field and make sure that the type is Number
You will see the Formatting button next to the Type drop-down.
Add currency symbol to the format (i.e. ’$0,0.00’).
Klicka på tillämpa.

Hur ställer man in länktext?

With Link field type you can use Markdown syntax to set the link text.

Recensioner

crimsonblackbeard 13 september 2021

This is a really good plugin which has a lot of potential. edit: Oh, I saw this project is no longer active. 🙁 Anyway, how to change the link text in the pagination view (I am using swedish)? Next, Prev, Last, First...

laymonk 22 april 2021

This is a very useful and fast loading plugin, with decent displays. Very straight-forward to use. Shame it doesn't have filters, but then again that will add load times. Not updated in a while, but still works flawlessly.

franmoracr 21 september 2020

Excelent plugin for display mysql custom tables.

oligarxuz 1 maj 2019

Ian Sadovy, Спасибо за плагин! НО есть одно НО! Иногда долго загружаются данные с таблиц!

minjambres 8 april 2019

Great!

Antonio 15 mars 2019

Hello , Really , very simple install and use ! It's working straight and very nice ! So , I need to populate the table by users accessing on my web site . Have you a solution to insert the data in the tables from the web sessions and not only from the web site admin console ? Thanks in advance for your answer.

Läs alla 34 betyg

Bidragsgivare och utvecklare

”WordPress Tables” är programvara med öppen källkod. Följande personer har bidragit till detta tillägg.

Ian Sadovy

”WordPress Tables” har översatts till 2 språk. Tack till översättarna för deras bidrag.

Översätt ”WordPress Tables” till ditt språk.

Intresserad av programutveckling?

Läs programkoden, kika på SVN-filförvaret eller prenumerera på utvecklarloggen via RSS.

Ändringslogg

VERSION 1.3.9

Added abitity to assign HTML ID to the table in the shortcode using html_id attribute.
Fixed the issue with exporting tables that are created using MySQL query.
Fixed the issue with exporting tables that contain characters like Chinese or Korean.
Fixed the issue with exporting column names insted of titles.
Stöd för WordPress 4.9.4.

VERSION 1.3.8

Fixed the issue with MySQL when correct (but empty) query results ”Invalid query. Please check the syntax and try again.” error.

VERSION 1.3.7

Added support for variables in the MySQL queries.

VERSION 1.3.6

Allow Editors to access WPTables.
Stöd för WordPress 4.9.2.

VERSION 1.3.5

Fixed the issue when table appears at the top of the page.
Lagt till kompatibilitet med LABJS.
Added compatibility with shortcodes plugins.

VERSION 1.3.4

Fixed the issue when jQuery is loaded in the footer.

VERSION 1.3.3

Fixed the issue with MySQL queries.
Fixed the issue with removing rows.

VERSION 1.3.2

Added support for custom MySQL queries.

VERSION 1.3.1

Åtgärdat horisontell justering.
Fixed mixing up tables with other post types.
Fixed the issue with Unicode symbols.

VERSION 1.3.0

Brand new admin UI with drag’n’drop file import and much more.
Brand new powerful data editor for imported files, including CSV and JSON.
Support of importing JSON data.
Improved CSV parsing.
Adding/removing new columns.
Search and bulk actions for created tables.
Cloning tables.

VERSION 1.2.10

Improved MySQL support: now it is possible to load data from any database that is available for the DB user, not only WP tables.
Stöd för WordPress 4.9.

VERSION 1.2.9

Fix fatal error on PHP < 5.5.

VERSION 1.2.8

Added support for custom currency symbols in number formatting.
Fixed the issue with saving table updates.

VERSION 1.2.7

Fixed compatibility with FancyBox library prior version 3.

VERSION 1.2.6

Fixed the issue with adding new table using CSV/MySQL.

VERSION 1.2.5

Lagt till stöd för anpassat nummerformat (decimaler, tusenseparator, valutasymbol, procent, etc.).
Lagt till stöd för länkar inne i tabell.

VERSION 1.2.4

Lagt till stöd för kortkoder inne i tabell.
Fixed issue with missing sort icons.

VERSION 1.2.3

Lagt till stöd för Unicode-tecken.
Åtgärdat problem med en apostrof (’).

VERSION 1.2.2

Fixed CSV parsing with dots in column names.

VERSION 1.2.1

Fixed editing HTML-like data.

VERSION 1.2.0

Lagt till 6 fördefinierade färgteman.

VERSION 1.1.0

Added a ”manual” mode for creating tables. It is possible now to edit the data in a spreadsheet-like interface.

VERSION 1.0.1

Added help and about sections.

VERSION 1.0.0

Initial version where most features are ready and pretty stable.