BaraTables
| 开发者 | nathannoom |
|---|---|
| 更新时间 | 2026年10月3日 13:39 |
| PHP版本: | 7.4 及以上 |
| WordPress版本: | 7.1 |
| 版权: | GPLv2 or later |
| 版权网址: | 版权信息 |
详情介绍:
BaraTables builds interactive tables and charts from manual rows, CSV uploads, public remote snapshots, WordPress content, or an external MySQL/MariaDB database, then publishes them with a shortcode or a block.
Import a JSON, XML, HTML, CSV, TXT, XLSX, ODS, or ZIP export from another table plugin or spreadsheet to rebuild a table.
Tables can include search, sorting, pagination, filters, export buttons, responsive stacking, and column visibility controls. Charts draw from any BaraTables table and embed with their own shortcode.
Features:
- Add search, sorting, pagination, and dropdown, multi-select, checkbox, or radio filters, including filtering by category or tag
- Export table data to CSV, Excel, or PDF, copy it, or print it
- Reorder columns, control column visibility, keep headers visible, and freeze leading columns while scrolling
- Treat a column as strict numbers for reliable numeric sorting, conditional color presets, and filtered sum, average, minimum, or maximum footers
- Fetch a bounded snapshot from a public CSV, JSON record array, or Google Sheet without contacting it from published pages
- Page large external MySQL/MariaDB tables on demand with bounded database queries
- Collapse wide tables into stacked, expandable rows on small screens
- Match your theme automatically: colors follow your theme's palette, with an optional custom accent color
- Restrict WordPress-content, CSV, and external-database rows by user role or user metadata
- Remember table state between visits, and control scrolling, column sizing, and row limits
- Create bar, horizontal bar, line, area, radar, pie, donut, treemap, scatter, bubble, heatmap, funnel, and Gantt charts with ECharts
- Light frontend styles that are easy to override with CSS
安装:
- Upload the
baratablesfolder to/wp-content/plugins/. - Activate the plugin through the Plugins menu in WordPress.
- Go to Tables in the admin menu and create your first table.
- Use the shortcode
[bara_table id="your-table-slug"]to embed it.
屏幕截图:
常见问题:
What data sources are supported?
CSV files, manual data entry, WordPress content, external MySQL/MariaDB databases, and stored snapshots from public CSV, JSON-record, or Google Sheets URLs.
Remote snapshots are manual and administrator-only. Save the public HTTPS URL and format, then click Fetch snapshot. Published tables and charts use the last stored snapshot and never contact the source. CSV and Google Sheets endpoints must return text/csv or application/csv; text/plain downloads are rejected. Authentication, private Sheets, scheduled refresh, and schema-changing refreshes are not supported; create a new table when remote column headings change.
Which table plugin exports can I import?
Use a TablePress single-table JSON export. Ninja Tables classic and drag-and-drop JSON exports work; export an externally connected Ninja table as CSV. WP Table Builder XML or CSV, Visualizer CSV, Supsystic JSON or CSV, League Table XML, and wpDataTables or Tablesome data-only CSV also import, as do HTML tables. A ZIP imports the first supported table and reports how many were found. Imports rebuild table data and compatible display settings, not plugin-specific styling, formulas, macros, shortcodes, charts, or external data connections. XLSX and ODS formulas use cached results and are never executed; save legacy XLS or encrypted workbooks as XLSX, ODS, or CSV first. Uploads and pasted imports can be up to 5 MB. A ZIP can hold 50 entries of up to 5 MB each, and up to 20 MB expanded.
How many rows can a table load?
Each table loads up to 1,000 rows by default. The Options tab sets a limit from 1 to 10,000 rows on every data source. External MySQL/MariaDB tables can instead opt into large database performance mode. It loads at most 100 rows per request and lets the database page, sort, and literally search within your Rows to load limit of at most 100,000 addressable results. It requires selected columns, pagination, and a non-null single-column primary or unique key. Row access rules, value/date transforms, filter controls, footer calculations, exports, print, and charts keep standard loading, preserving their meaning. Database search follows the source collation, which controls case and accent matching.
Can I link to a filtered view of a table?
Yes. Filtering or searching updates the page address, so you can share that exact view, or build the link yourself with btbl_filter[column-slug], btbl_search, and btbl_search_cols.
How do I add a chart?
Create a table first, then go to Charts and create a new chart linked to that table. Use [bara_chart id="your-chart-slug"] to embed it.
Can I customize the table appearance?
Yes. The Options tab provides controls for striping, hover, borders, compact mode, pagination style, button labels, search text, and info display; layout zones control where controls appear.
How do numeric rules and footer calculations work?
Choose Number in a column's settings. Plain decimals such as -12.5 participate in numeric sorting, conditional styles, and footer calculations. Currency symbols, percentages, grouping separators, words, blank cells, and out-of-range values stay visible but are excluded. Footers calculate every loaded row matching the current search and filters, not only the current page; rows beyond the table's row limit and exports are excluded.
Can I style BaraTables with custom CSS?
Yes. BaraTables ships minimal frontend styles so your theme stays in control; adjust colors, spacing, typography, and buttons with your theme, the Site Editor, or custom CSS.
Where can I see examples?
Visit https://ktisisweb.com/baratables/ for screenshots, feature notes, and styling guidance, or try the Live Preview demo on WordPress.org.
更新日志:
1.4.0
New:
- Import XLSX and ODS workbooks, including stored results for formulas without executing them.
- Fetch a stored table snapshot from a public CSV, JSON-record, or Google Sheets URL.
- Keep headers visible and freeze leading columns while a wide table scrolls.
- Add strict numeric sorting, conditional color rules, and filtered footer calculations.
- Page, sort, and search large external MySQL/MariaDB tables on demand with bounded queries.
- Table summaries and the per-page selector say "rows" instead of "entries".
- Charts follow the table's accent color.
- Filter labels containing an ampersand render correctly.
- Table and chart block pickers list every item instead of the first 20.
- Exported and copied table content neutralizes spreadsheet formulas, so cells from imported or remotely sourced tables no longer execute when the file is opened.
- The table preview now clearly indicates when it needs refreshing, stays unavailable until refreshed, and recognizes when changes are undone.
- Option settings remain visible while switched off, with clearer grouping and more consistent spacing.
- Dragging a column no longer leaves a group search on the wrong columns.
- Merge tags like {{meta:Price_USD}} now resolve mixed-case keys.
- A chart-only page no longer flashes unstyled content.
- Switching data sources no longer keeps old columns selected.
- A meta column missing from recent posts is no longer dropped on save.
- A remembered search is now visible and clearable.
- Custom Query date filters now apply as written.
- Ninja Tables custom filter values now import as dropdown options.
- The chart preview shows draft charts instead of Chart not found.
- Removed the PHP adapters deprecated in 1.2.5; use the column-record API instead.
- New block editor blocks: add any table or chart from the block picker instead of pasting a shortcode.
- Wide tables can collapse into stacked, expandable rows on small screens.
- Export any table to PDF with a new Export PDF button.
- Tables match your theme automatically: colors follow its palette, with an optional custom accent color per table.
- Table pages no longer load jQuery, and dropdown filters use a lighter picker, so they load faster.
- The table engine is now DataTables 3; pages with export buttons load fewer files.
- Auto-built dropdown and checkbox filters cap at 250 options, so a near-unique column cannot make the page unresponsive.
- The editor's Options tab is reorganized, and every field shows its default until you change it.
- Tables and charts work better with screen readers: proper column headers, an announced optional caption, labelled charts, and a readable fallback when JavaScript is off.
- Publishing a table for the first time shows its shortcode and block.
- Day-first dates such as 25/12/2026 now format correctly with "Format as date".
- Chart values written with a decimal comma (1.234,56) plot at the correct magnitude.
- Tab-delimited files import as separate columns instead of one long column.
- An invalid external database edit no longer silently keeps the previous connection, and clearing every field removes it.
- Search limited to chosen columns follows columns you move by dragging.
- The settings gear no longer appears on a switched-off control when its inner option is still checked.
- Layout builder drop zones sit where their labels say.
- Imports WP Table Builder XML, Ninja Tables drag-and-drop JSON, Visualizer CSV, Supsystic JSON or CSV, and League Table XML exports.
- Reads table exports from HTML and ZIP files.
- Chart-only pages load faster and large-table searches stay more responsive.
- The chart editor searches table choices as you type, so it stays fast with many tables.
- Empty or incomplete Ninja Tables exports no longer become a live table of WordPress posts.
- Quoted commas and multiline headings no longer break semicolon-delimited imports.
- Hidden columns, footer values, intentional blank rows, and nested cell values are preserved.
- A failed import no longer leaves an incomplete published table behind.
- The plugin activates normally on PHP 7.4 through PHP 8.1.
- A failed table or chart save keeps its data, ID, and linked charts.
- Duplicating a table or chart more than once gives every copy its own ID.
- Missing CSV files and external database failures show a clear error instead of an empty table.
- If an interactive table or chart script fails to load, the loading screen clears to show the table or an error.
- Renaming a Table ID no longer removes backslashes from linked chart names.
- Manual column headings saved by early versions follow the site language after a direct upgrade.
- Validates the contents of table import uploads before processing them.
- Adds radar, heatmap, and treemap charts.
- Fixed scroll height is now a Table controls option, with its height and collapse settings inside. Existing heights carry over.
- Table wording follows your site's language: the search label, the "Show ... entries" selector, the filters heading, and the result summary. Saved tables are included, and wording you typed yourself is kept.
- Tables load without a flash of unstyled content.
- Keyboard and screen reader support: labelled filter controls and option groups, Enter or Space to open the settings gear, focus outlines on taxonomy chips, and arrow keys to arrange the layout.
- Pages with a table and its chart, or the same table twice, load faster on large tables.
- The "Clear filters" and "Edit Table" buttons are styled consistently on any theme.
- Password-protected post content is withheld from visitors who have not entered the password.
- Post passwords cannot be displayed as a column, including through an imported file.
- Hiding a column's heading keeps the custom heading you typed.
- Sticky posts are excluded, so a table stays within its row limit.
- Column filters follow their column when a visitor reorders columns.
- Date columns sort by date, even with empty cells.
- The Column visibility button reveals columns hidden in the table setup.
- Custom meta keys with capital letters or dots (such as Price_USD) match your data.
- Media tables list your attachments.
- Row-level access control on Custom WP Query tables.
- Filtering by category or tag.
- Pages using Advanced Custom Fields Post Object, Relationship, Taxonomy, or Repeater columns load correctly; the columns show their title, name, or contents.
- Manual data grids hold up to 25,000 cells, and the editor warns when your server's form-field limit is too low for a grid that size.
- Two tables on the same page keep their own filters in the shareable link.
- An import that fails to save can be retried without uploading the file again.
- Importing a large table keeps more of its rows and columns.
- Ninja Tables exports apply their saved search, sorting, and pagination settings.
- Editing an external database connection keeps your column and filter setup.
- Saved table state keeps sorting, search, page, and page length between visits.
- A restored search respects the columns you set as searchable.
- "Value overrides" apply to CSV and external database tables.
- "Format as date" is available on CSV, external database, manual, and custom field columns.
- Date columns show the time of day, and timestamps use your site's timezone.
- Blank lines in a CSV file are skipped.
- Custom WP Query tables load up to the row limit you set.
- On CSV and external database tables, row-level access control shows every row a visitor may see, even beyond the row limit.
- Shareable filter links work for a value of 0.
- Unnamed columns from a headerless CSV follow the site language.
- The editor preview uses the same export button labels as the published table.
- Creating a table from an import opens its editor.
- A table loads only the export, column-reorder, and dropdown-filter libraries it uses, cutting about 265KB per page.
- Large tables sort, page, and filter faster.
- The term picker lists the first 200 terms of a taxonomy, plus any already selected.
- The "Strict matching" filter option is removed; filters match whole values exactly.
- A column order set by dragging applies to the current visit only.
- A column heading taken from a CSV file's header row could run script in the table editor. Column headings are now escaped everywhere they appear.
- Table and chart posts are no longer listed by the REST API. Anonymous requests could retrieve their ids, titles, and slugs.
- An external database table with no columns selected no longer publishes the column holding its access tokens.
- Row-level access control was accepted but not applied on manual-data tables. The setting has been removed there.
- Changing a table's data source could leave row-level access control switched on but unenforced, publishing rows it was set to hide. It now applies only to the source it was set up for, and a table whose saved settings cannot be enforced shows no rows until you re-save it.
- New tables default to hiding restricted rows from logged-out visitors. Existing tables keep their saved setting.
- Export a table to Excel with a new table button option.
- Five new chart types: horizontal bar, donut, scatter, bubble, and funnel, each with a preview in the chart-type gallery.
- Remember table state: a table can keep its sorting, search, page, and page length.
- New table controls for horizontal scrolling, vertical scroll height, and column auto-sizing.
- Configurable row loading limit per table (default 1,000 rows, up to 10,000).
- "Format as date" displays the formatted date (e.g. "Mar 18, 2026") on manual data columns.
- Plain numbers such as a year or a count are not read as dates.
- A [bara_table] or [bara_chart] shortcode used without an id shows a "not found" message on WordPress 6.2 through 6.4.
- Importing a file with only a header row, or no rows, creates an empty table.
- Front-end table controls (export buttons, column-visibility menu, "Search in") and the CSV file picker follow the site language.
- Hardened the table editor's "Column heading" field against script injection (XSS).
- Import a table from another table plugin or a spreadsheet: upload a JSON, XML, or CSV export and BaraTables creates a matching table.
- Editable Table ID and Chart ID: rename a table's or chart's shortcode ID after creation. Linked charts update automatically, and a notice reminds you to update shortcodes already placed in your content.
- Reorder manual-data rows in the editor with up and down controls.
- Manual-table column headers are translation-ready and follow the site language.
- Wide manual-data tables scroll horizontally while keeping the row number and controls in view.
- Paste tabular data straight from a spreadsheet into the manual-data grid.
- Smoother admin: one-click copy for shortcodes and IDs, a Show/Hide help text preference, and fewer page reloads while configuring a source.
- Numeric columns sort numerically (e.g. 3.15, 3.2, 3.9).
- Far-future dates display correctly.
- Hardened admin request handling and input validation.
- Improved date formatting controls for WordPress date columns, including support for the site's default date format.
- Security: hardened frontend table and chart configuration output.
- Initial release.