BaraTables
| 开发者 | nathannoom |
|---|---|
| 更新时间 | 2026年11月1日 23:44 |
| PHP版本: | 7.4 及以上 |
| WordPress版本: | 7.1 |
| 版权: | GPLv2 or later |
| 版权网址: | 版权信息 |
详情介绍:
BaraTables builds interactive tables and charts from manual rows, CSV uploads, snapshots, WordPress content, or an external database, published by shortcode or block.
Import a JSON, XML, HTML, CSV, TXT, XLSX, ODS, or ZIP export from another plugin.
Tables can include search, sorting, pagination, filters, export buttons, responsive stacking, and column visibility. Charts draw from any table.
Features:
- Search, sorting, pagination, and dropdown, multi-select, checkbox, or radio filters, with category and tag filtering
- Export to CSV, Excel, or PDF, copy, or print
- Reorder columns, control visibility, keep headers visible, freeze leading columns on scroll
- Strict numeric sorting, conditional colors, and filtered sum, average, min, or max footers
- Fetch a bounded snapshot from a public CSV, JSON, or Google Sheet; pages never contact the source
- Page large external MySQL/MariaDB tables on demand
- Collapse wide tables into stacked rows on small screens
- Match your theme automatically: colors follow its palette, with an optional accent
- Style tables and charts without code in the Design tab, with a live preview
- Restrict rows by role or user metadata
- Remember table state between visits; control scrolling, column sizing, and row limits
- Create bar, horizontal bar, line, area, radar, pie, donut, treemap, scatter, bubble, heatmap, funnel, and Gantt charts
- Light frontend styles that are easy to override
安装:
- Upload the
baratablesfolder to/wp-content/plugins/. - Activate the plugin through the Plugins menu in WordPress.
- Create a table under Tables, then embed it with
[bara_table id="your-table-slug"].
屏幕截图:
常见问题:
What data sources are supported?
CSV files, manual data, WordPress content, external MySQL/MariaDB databases, and snapshots from public CSV, JSON, or Google Sheets URLs.
Remote snapshots are manual and administrator-only: save the public HTTPS URL and format, click Fetch snapshot, and published tables use the stored snapshot without contacting the source. CSV endpoints must return text/csv or application/csv; text/plain is rejected. JSON endpoints may also be served as text/plain. Authentication, private Sheets, scheduled refresh, and schema changes are not supported; re-create the table when remote columns change.
Which plugin exports can I import?
Use a TablePress single-table JSON export; Ninja Tables classic and drag-and-drop JSON also work (export an externally connected Ninja table as CSV). WP Table Builder, Visualizer, Supsystic, League Table, wpDataTables, TableKit, and Tablesome exports import too, as do HTML tables; a ZIP imports the first supported table. Imports rebuild table data and compatible display settings, not styling, formulas, macros, shortcodes, charts, or connections. XLSX and ODS formulas use cached results and are never executed; save legacy XLS or encrypted workbooks in a current format first. Uploads are capped at 5 MB; a ZIP holds 50 entries of 5 MB each.
How many rows can a table load?
Tables load 1,000 rows by default; the Options tab sets a limit from 1 to 10,000 on every source. External MySQL/MariaDB tables can instead page large tables on demand: at most 100 rows per request, paged, sorted, and searched by the database within a 100,000-result limit. It requires selected columns, pagination, and a non-null single-column primary or unique key; access rules, transforms, filters, footers, exports, print, and charts load as usual. Database search follows the source collation. Encrypt the connection with TLS for any host outside your own machine. TLS needs the path of the CA certificate that signed it: PHP's MySQL driver cannot use the system trust store.
Can I link to a filtered view of a table?
Yes. Filtering or searching updates the page address, so you can share the view, or build it 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 chart linked to it, embedded with [bara_chart id="your-chart-slug"].
Can I customize the table appearance?
Yes. The Design tab (charts get one too) styles tables without code: presets, colors, typography, spacing, and a per-chart palette, each live in the preview as you type. It also takes per-table Additional CSS. Styles print as CSS custom properties, so your theme keeps what you leave blank.
How do numeric rules and footer calculations work?
Choose Number in a column's settings: plain decimals such as -12.5 join numeric sorting, conditional styles, and footers, while currency symbols, percentages, grouped numbers, words, blanks, 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 row limit and exports are excluded.
Can I style BaraTables with custom CSS?
Minimal frontend styles keep your theme in control; adjust colors, spacing, and typography with your theme, the Site Editor, or custom CSS. The Design tab writes its choices as --btbl-* custom properties on .btbl-table-wrapper -- a stable API for themes: set them globally to re-skin every table, or copy the block with Copy CSS and manage it in your theme via the "Theme CSS" output mode. Tokens cover header, stripe, hover, border, footer, conditional, and chart colors, type, padding, and radius.
Where can I see examples?
See https://ktisisweb.com/baratables/ for screenshots and styling guidance, or the WordPress.org demo.
更新日志:
2.0.1
New:
- External database sources can encrypt their connection with TLS. Give the source the path of the CA certificate that signed it: PHP's MySQL driver cannot use the system trust store.
- Tables with a hidden column load again instead of showing an error and losing paging, sorting, and search.
- Additional CSS keeps a "<" that cannot break out of the style element, so a content string with markup in it is no longer altered.
- Styles for one table no longer reach a sibling table whose ID starts with the same characters.
- A merged cell value used in a regex replacement is no longer destroyed when it contains "$1".
- The Design tab shows the color a save will keep, and no longer marks a short "#fff" as invalid.
- The Copy CSS message is translated like the rest of the interface.
- A remote snapshot URL that resolves to a link-local, carrier-grade NAT, or benchmarking address is refused instead of being fetched.
- A Design tab for tables and charts: presets, colors, typography, spacing, and a per-chart series palette, with a live preview updating as you type.
- The table preview now renders the real table visitors see, so what you style is what you publish.
- Copy CSS hands the styles to your theme, and the "Theme CSS" output mode lets that copy take over.
- Per-table Additional CSS, auto-scoped to the table, plus a documented
--btbl-*token API for themes. - Accent color and the style toggles moved into the Design tab.
- 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 without JavaScript.
- 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 your own wording 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, showing their title, name, or contents.
- Manual data grids hold up to 25,000 cells; the editor warns when your server's form-field limit is too low for 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 past 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 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, 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 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.