3623 comments found.
Most of my client requests pertain to PDF/Excel functionality… Example have a table that has numeric columns and i use your Calculate Column Total below the column… BUT when they download a PDF or Excel Sheet the column values don’t show … this a huge issue I am trying to overcome
Hi there,
Yes this functionality is based on third party library and those functionality can not be display. You can read more about this on this link in our docs https://wpdatatables.com/documentation/table-features/table-tools/
As alternative you can try our Report builder add on where you can create own DOCX or Excel templates(PDF is not supported at the moment) and also use total values. More info on this link https://wpreportbuilder.com/
You can try it on our Back-end Demo on link below.
FAQ | Official Support | Back-end Trial | Facebook | Twitter
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hi, This is pre-sale question, I’d like to know if this the requirement I’m looking for is possible with wpDataTables or not. Please check this URL (https://www.alltherm.ca/price-catalogue), here there’s two drop-down selection menu, upon selecting the options it will display a table sheet with values. Now there’s also a discount percentage calculation input box where we need to enter some value and it will calculate the value with all the existing values in the displayed table with updated value. Please let me possible f its possible or not.
Hello there.
Sorry for the late response!
When we access that page, a 404 error is returned, so we can’t see what you mean. Can you please provide us with a new link, and we’ll gladly check it out?
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hi, seems the closing bracket was coming with URL, so here it is : https://www.alltherm.ca/price-catalogue
Thanks for that, it worked.
The table itself can be created using wpDataTables, but hiding the table before filtering is applied is offered with our paid add-on Powerful Filters.
Even if you go for that, applying the discount as on that link is not possible with the plugin. There’s no workaround for that, unfortunately.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Question: 1st been using this excellent plugin EXTENSIVELY for quite a while and this plugin is critically important to a client website we deployed it on… Client has asked a valid question asking for the capability to include their company logo in PDF and Excel exports from plugin…. any idea on how to do this?
Hello there.
The PDF export is a part of a 3rd party library, and it can’t be altered. Unfortunately, modifying the template is not possible, so you would not be able to add a logo, a watermark, or anything similar to the exported file.
You may be able to use a 3rd party PDF plugin that generates PDFs, but we don’t guarantee that it will work correctly.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
I already asked this 3 years ago..
Only one user should be able to edit a table?
So basically I have 2 different user roles. 1. Business client (e.g. BC1, BC2, BC3) Can add listings 2. Customer (e.g. CO1, CO2, CO3) Can only see stuff
BC1 bought a subscription package to add a listing. Therefore we setup a basic table, so he can show his inventory. But over time his inventory is going to change, so he needs to edit it by himself without contacting us… (because we have over 4,000 clients) But he should be the only one to edit his table and not BC2, BC3 who also got the same user role…. how to set this up?
Hi there.
You can configure the editing roles when you go to the Editing tab above the table – there you can enable editing for “Business Client” and “Administrator” user roles, so “Customer” user role wouldn’t be able to edit the table.
To allow people to edit only their own data, you need to enable the Users see and edit only their own data feature. So, when they load the page where the table is, they would only be able to see and edit their rows.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hi, but how to bulk add the data for him to see? Can I manually assign the users to the specific table for them to see the rows? So basically give the row the USERIDs = 1, 456
UserID = 1 is Admin UserID = 456 is the allowed customer to edit the table in frontend All other UserIDs only can see the table
So I tried it out. But for my use case every user who wants to see a table he has to be logged in. Therefore the table is empty but should show the values of the editor (either the Admin with UserID 1 or the owner with UserID 456). Only the User 1 and 456 should be able to edit the table entries or add new ones in the FrontEnd.
Hello again.
What you’re looking for to achieve is not possible with the plugin’s built-in features. One row can only consist of one user ID, so user with ID: 456 cannot see entries of user with ID: 1.
You can use the “MySQL table name for editing”, found in the Editing tab above the table, and create a new MySQL query based table which would not be editable. That would allow you to place this new table on the front-end for all users to see entries, but they wouldn’t be able to edit the table.
Admins would still be able to edit the original table.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Alright, is it possible then to bulk import data to a table via CSV file on the frontend? Because the user has to add 80 rows separately is a pain. If not are you going to integrate this feature?
Importing is only possible when a new table is created, so no imports can be conducted from the front-end.
If you want to enable bulk import from the front-end, you can enable editing, and add the Excel-like table on the front-end. In the excel-like editor, you can paste the range of cells into the table.
We’re going to work on updating the table with an imported file, but there’s no ETA on that.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hi, I experience troubles right after having installed your wpTable plugin. Some of the features does not work. For example, creating a simple 2 columns table, nothing happends when I click on the “create the table” button ( /wp-admin/admin.php?page=wpdatatables-constructor ). I suppose it is because I previously activated the plugin for a website . The problem is we deleted this website without having unactivated the table plugin. I bought it and activated it through CodeCanyon (envato) ; | Can you help me make your plugin work on my current website?
Hello there.
Do any of the drop-downs work (for example in wpDataTables Settings)? If they don’t work, there’s a conflict with some other plugin’s (or your theme’s) bootstrap.js files.
Please go to wpDataTables settings, and deactivate the Bootstrap option for the back-end. If that doesn’t resolve the issue, please open a ticket on our official support platform, provide us with a temporary wp-admin (administrator) user, and make sure the Plugin Editor is enabled, and we’ll gladly help you out there.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hello !
Recently at page load, I am getting this message on browsers:
DataTables warning: table id=table_3 – Invalid JSON response. For more information about this error, please see http://datatables.net/tn/1
I am writing it here and not to support page because I am unable to login to your helpdesk as my support has expired and I cannot pay this much to get one single problem fixed in 4 years. I hope you understand my situation. On the other hand, I really need your help as I am not able to fix this myself. Could you please help me to make this warning go away/dissapear from all browser windows? Thanks so much.
PS:The warning message changes according to different browsers :/ For example on Edge it shows an Ajax error like this:
DataTables warning: table id=table_1 – Ajax error. For more information about this error, please see http://datatables.net/tn/7
I have updated to plugin’s latest version and now issue looks like it is gone…
After last update tables are displaying fine BUT Charts are not showing up in frontend at all. Even the newly created ones… (They display fine on backend settings page preview though…) Any advice to help me fix this? Thanks.
Browser Console gives following error:
Uncaught TypeError: $.ready.then is not a function
at wdt.chartsRender.min.js?ver=3.4.4:1
at dispatch (jquery.js?ver=1.12.4-wp:3)
at r.handle (jquery.js?ver=1.12.4-wp:3)
/wpdatatables/assets/js/wpdatatables/wdt.chartsRender.min.js?ver=3.4.4
Happened because of older version of jQuery installed on my website. I have fixed it after the solution you wrote for Dimitri Ticket 2786124 
So, issue is fixed now. Thanx ! Love this plugin :)))
Hello there!
Sorry for the late response!
We’re glad the issue has been resolved, and that you enjoy working with wpDataTables.
If you need any further assistance, please feel free to reach out to us, and we’ll gladly help!
Best regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hello again my friend, I am trying out the free version for the moment and have a question…....... I have a gemstone api that I want to use (imported into mysql) but when I try the query builder I seem to have difficulties seeing and joining the tables image, attribute, attribute, attribute, attribute, link, link, and quick view (I got that working) is there demo data like what you have for the product demo?
I want the display........I want to make sure this is going to work because I have purchase many datatables plugins and none of them are any good, I want to make sure if I buy this one it will actually do what I want.
Thanks
Hello there.
Thank you for reaching out to us.
You can test our plugin on our sandbox site, and see if it works for you.
Our logic is based on a PHP SQL parser which has full support for the SQL dialect for the following statement types
SELECT, INSERT, UPDATE, DELETE, REPLACE, RENAME, SHOW, SET, DROP, CREATE INDEX, CREATE TABLE, EXPLAIN and DESCRIBE.
Some of them are disabled for security reasons.
Filtering, sorting, and search may not work properly if you include:
Accent graves ( ` ) around the table name JOIN functions UNION functions CONCAT functions sub-queries You can try preparing a MySQL view (which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like “SELECT * FROM view1″.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
I ask for your kind services to make the features can group row for manual table.
though not merge cell or row, just can group. I really appreciate. please
Hi there.
Thank you for reaching out to us.
What you’re looking for is not possible, and at the moment you can only use the row grouping feature in non-server-side tables, and it’s not to achieve it in server-side tables.
We will forward the request to our developers so they can take a look, but we can’t make any promises.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
hi if i buy this i can create like a search form with a field and search button. Then after i write something on field and click search should show a table with results from a webservice json.
Thank you
Hello there.
Thank you for your interest in the plugin.
wpDataTables has advanced filtering, that can be applied to each column individually.
Every table has a Global Search, which is working without clicking on the “Search” button, and it’s looking for entered data in all cells within a table.
It looks like you want to hide the table before filtering is applied, and to do that you would need to also purchase the Powerful Filters add-on.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
I have a website and we are into consulting. I want to create a dashboard. Could you please help if this plug in helps. My website is https://www.emergenresearch.com/
Hello there.
Sorry for the late response!
wpDataTables can be used to create tables in WordPress. They can be editable in front-end, but they don’t have to be – it depends on what you want to achieve.
Please take a look at our documentation, check out the table types, and check out our sandbox site. If you have any specific questions about features, please feel free to reach out to our support team over at our official support platform.
Best regards!
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hi there, can you please publish the update on envato the same time? Thank you!
Hello there, sorry for the delay. The new version should be uploaded today.
Thank you for your patience, and sorry for the inconvenience.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
I created a table importing a CSV/Excel File – how would i go about adding more rows to the table after the initial import of say 200 rows… in other words i want to be able to import into this table every week adding the new records to the already existing records?
Hello there.
If you created the table by importing an external data source, the plugin reads the source file and creates a new manual table, which is stored in the database.
To add new data to this table, other than adding rows manually, one by one, you could create a new CSV file that contains only the new entries, locate this table in the database and import that file there.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Buyer beware!
The plugin doesn’t play well with most other modern plugins. You want me to pay you over $515 per year in support fees to get it to work? Sorry, that’s not acceptable, especially for a plugin that updates about once every 12-18 months. I’m writing to Envato over this. Gives devs on here a bad name.
Their model is not selling software, its selling support.
As a basic, you need to ensure that purchasers of the plugin can still use the plugin, or charge a reasonable fee. This plugin has never worked properly; and updates are rare. I received no responses to original questions when in the support period. Cant even find my questions on Ticksy. Strange that! Now outside of the period no way of even submitting a question.
It seems to me that you have a pretty fundamental problem with compatibility to current WP plugins, including any that use Bootstrap. Creating a table button does not work. No dropdowns in the plugin works. Altering the settings within the plugin does not work.
For a costly plugin, this is extremely disappointing.
Hello there.
We’re sorry to hear you’re having issues with the plugin.
The price has increased on Envato because we’ve opted from exclusivity on this market, and we’ve launched our own online store.
From our website you can purchase annual or lifetime licenses per lower prices than what’s listed here, on Envato. Included support for those licenses last as long as the license lasts, so for annual licenses support lasts one year (until it’s renewed one year after that), or it’s a lifetime support (if you purchase lifetime licenses).
You can always open pre-purchase tickets on our official support platform, and our support managers would gladly help you out even if your support expired.
The plugin is stable, and is working fine without issues, so if you’re having issues with the plugin, please reach out to us there, and our managers will help you out. As for the updates – all updates are released on Envato as well as on our store, and you can see the change log here. We tend to release new updates every month, so the plugin definitely doesn’t update once every 12 – 18 months. You probably disabled auto-updates, or haven’t activated your purchase code, if you haven’t seen an option to update the plugin in this period of time.
At any moment, though, you can update the plugin manually by following steps provided on our documentation.
We’ll gladly explain in more detail the price difference, and see what we can do for you (since you’re an old customer) if you wish to open a pre-purchase ticket on our support platform.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
hi, I am very interested in this plugin after trying many others does this plugin handle yith shortcodes and quickview plugins? I want to be able to insert a quickview button in the table to have a popup of the product details…...............do you have documentation explaining this? thanks
Hello there.
Thank you for your interest in our plugin.
We have shortcode support for table cells, but we cannot guarantee that all of them will work. If you purchase the plugin from our website you will have a 15-day money-back guarantee, so if you can’t achieve what you wish to achieve with the plugin, you can be refunded in that period of time.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hello my friend, Thanks for your response…...... I wasn’t quite sure when I would hear from you so I decided to learn how to make tables for myself as a usercontrol given I only need to make one design of the table. I will watch this plugin and maybe buy it in the future. Thanks again
You’re welcome!
If there’s anything we can help you with, please let us know!
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hello. I really need your help please. I have looked through the documentation for your plugin but could not find what I need. I need a hook that works when the table is created (before showing). So that I can dynamically change the structure of the column, row, etc.
For example, I need to add a link for each row in specific columns, for that I need to specify the values of the X, Y columns, concatenate them into a url and add the generated url to the specified columns.
As you can see, I am doing it with js, but it doesn’t work in the mobile version because the structure is different. And the X, Y values will only be generated when I click the + icon (expand), before that I can’t find the values. But if you can specify any hook, filter that can work with rows, columns and values (all data), I will do it with php․ http://shorturl.at/moyM2PS: I just started using the table license but purchased long ago. I can not afford to pay $257.25 for support renewal 
Thank you!
Hello there.
Thanks for reaching out to us.
There’s a filter wpdatatables_filter_initial_table_construct, that receives the wpDataTable object that contains all info about the table. It’s located in wp-content/plugins/wpdatatables/controllers/wdt_functions.php, on line 681.
There’s also the filter wpdatatables_filter_cell_output that receives ($cellVlaue,$tableId,$columnHeader) for non-server-side tables, and it’s located in wp-content/plugins/wpdatatables/templates/frontend/table_body.inc.php on line 13, and for server-side tables also in wp-content/plugins/wpdatatables/source/class.wpdatatable.php on line 2541.
I hope that helps.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hello, The developed reported that after tying some changed based on your suggestions, he is getting the below error. Any clue what could be the cause?
Fatal error: Uncaught Error: Call to a member function generateTable() on null in /home1/pakine81/public_html/wp-content/plugins/wpdatatables/controllers/wdt_functions.php:665 Stack trace: #0 /home1/pakine81/public_html/wp-includes/shortcodes.php(343): wdtWpDataTableShortcodeHandler(Array, ’’, ‘wpdatatable’) #1 [internal function]: do_shortcode_tag(Array) #2 /home1/pakine81/public_html/wp-includes/shortcodes.php(218): preg_replace_callback(’/\\[(\\[?)(wpdata…’, ‘do_shortcode_ta…’, ‘[wpdatatable…’) #3 /home1/pakine81/public_html/wp-content/themes/zeen/inc/classes/class-zeen-blocks.php(665): do_shortcode(‘
[wpdatatable…’) #4 /home1/pakine81/public_html/wp-content/themes/zeen/inc/classes/blocks/class-zeen-block-text.php(40): ZeenBlocks->block_content() #5 /home1/pakine81/public_html/wp-content/themes/zeen/inc/core/tipi-block.php(543): ZeenBlockText->output(false) #6 /home1/pakine81/public_html/wp-content/themes/zeen/inc/builder/app/helpers/class-zeen-builder-helpers.php(1511): tipi_builder_block(Array) #7 /home1 in /home1/pakine81/public_html/wp-content/plugins/wpdatatables/controllers/wdt_functions.php on line 665
Hello again.
Can you please open a pre-purchase ticket on our official support platform, and our support managers will gladly help you there?
Just make sure to reference this thread, so we know it’s you.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hi, Is it possible to set if a speficied column contains value, it is not-editable? Or any workaround?
Thanks.
Or how to disable the edit button when certain/specified column is empty/null via CSS? Now is based on ID, I want to disable the edit button detect if the specified column is empty too. How to know the ID for the edit button? Any help would be much appreciated. Thanks.
Hello there.
Unfortunately, the plugin doesn’t have any options to disable editing of a column based on what a certain field contains.
You can choose whether the column is editable or not in column settings, but that’s pretty much it.
Doing this via CSS maybe is possible, if you combine conditional formatting with hiding the button using CSS found here.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Can it display dynamic data? I have a database in Postgresql which has a table where a new record is generated every minute. So will this plugin help me link that table and show the live table/chart in frontend?
Hi there!
You can connect your PostgreSQL database as a separate DB connection and create SQL query-based tables from that database.
The connection is dynamic, but the tables do not refresh the data automatically. Changes in the database are shown in the table when you refresh the page, but you can also add an auto-refresh timer on the table, so it’s automatically refreshed after X seconds, without refreshing the page.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hi! We need to change thousand separator to dot separator in Y AXIS with Google Charts.
For example, now in Y AXIS shows: 2,000,000 But we want: 2.000.000
How can I change it?
Thanks you!
Hi there.
Sorry for the late response!
Charts don’t yet inherit the number format you set in wpDataTables, so this would have to be done with wpDataCharts callbacks. On this page, you can see an example of how this is done with Highcharts.
Google Charts require different callbacks, so you would need to explore Google Charts API and apply them to the chart.
Please note that using wpDataChart callbacks requires certain level of programming skills and included support refers only to advice.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hi,
After migrating my site to a new server, all of my table content is blank. I can see it all in the database, though, but not in the front end. What can I do to fix? Thanks!!
Hello there, and sorry for the late response.
What most likely happened, is that the MySQL table name of the table, and the “Content” of the table still pulls the old names.
If you migrated the site, most likely your database prefix was changed, so wp_wpdatatable_1 in the database is now xy_wpdatatables_1. In wp_wpdatatables database table, the structure and the creation of the table is done, so in the CONTENT column, check the database table names. If they are still written like this:
SELECT * FROM wp_wpdatatable_1
You will need to modify the query to be:
SELECT * FROM xy_wpdatatable_1
Then, do the same for the mysql_table_name table.
If you’re having issues with this, please feel free to open a pre-purchase ticket on our official support platform, reference this comment and provide our managers with access to your database, and they’ll help you out.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Hello there.
Thank you for reaching out to us.
When working with XML format please note that wpDataTables presently accepts this, and only this, format of XML (see the example): A single root node with several child nodes (one level), where each child node will be treated as a row, and the child row attributes as cells. If your software does not return this format you would need to prepare, as an example, some type of a PHP adapter to return one of the formats that wpDataTables would accept.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Makes sense. Thank you. Who is the best person or people to assist with this customization issue?
Hello again.
Sorry for the late response!
We can only recommend these services for any customization:
They do all kinds of customizations, so please reach out to them.
Kind regards.
FAQ | Official Support | Back-end Demo | Documentation | Twitter | Facebook | Instagram
Make sure to join 3500 subscribers of our newsletter! Be first to find out about new features, releases, plans and promotions from the wpDataTables team.
Thank you.
