3621 comments found.
post again during no reply on ticket
Regarding to the Predefined value(s), instead of CURRENT_DATE , how can I set it to the date value which is fetch from last row of data table?
Also, is that possible to set the input type of the Filtering, such as a date picker?
Hello there.
Thank you for reaching out to us.
Predefined values of date columns can’t use anything other than the placeholder CURRENT_DATE that’s included in wpDataTables.
You can try constructing a custom MySQL query that will pull the data you need, but please note:
- wpDataTables uses a 3rd party PHP SQL parser, and it can’t use all MySQL query functions.
- We do not provide support for writing custom queries.
All available filtering types are in column settings/Filtering tab, and there are no other filtering types in the plugin.
At the moment, only the “Date Range” is available for Date-type columns.
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 guys,
I haven’t used this plugin in a while and I’m wondering if I can create a scheme of different type of weekly reports that I just upload in xls format, instead of filling it with a form. Like an import feature that can create table from file (e.g. xls or csv)?
Hello there.
You can create a table by importing an external source (Excel, CSV, Google Spreadsheet). Once you do this, you will be able to update the manual table by uploading another file. You can read more about this here, but in short – there are 3 options :
- Replace rows with source data where you would replace the data of an existing table with fresh data from an external source that has the same number of columns and the same header names;
- Add rows to current table data where you would add data to an existing table;
- Replace entire table with source where you would replace the entire table with the data of an external file;
Another option would be to create a table by linking an external Excel file, or an external CSV file. This data would be stored in ../wp-content/uploads/YEAR/MONTH/ folder, so you would only need to modify the file in that location, and wpDataTables would automatically load the new data when the table is refreshed.
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.
After latest update (I haven’t updated for some time already), it seems that MySQL table with around 2300 results stoped working with filters. So independently of using the global filter/search or the specific ones for each column, it always show no results.
I’ve noticed other people already complained about this, what is the solution?
Hello there.
Issues like this don’t happen out of the blue, and there’s always a reason for this behavior. Sometimes, it’s the query that changed, sometimes it’s the database prefix that changed, or simply the table grew over 2.000 entries, and switched to Server-Side processing – when that happens, and if your query contains JOINs, UNIONs, CONCATs, or anything other than a simple query, filtering, sorting and editing can stop working.
Unfortunately, we can’t say what caused the issue until we inspect the tables.
Please open a PRIVATE Pre-purchase ticket (if your support expired) on this link, mention that you’ve been instructed to do that in Envato’s comment section, provide us with details about the issue and the login credentials, and we’ll gladly help you out with this issue.
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, I want to be able to get a table of all my woocommerce products with the corresponding name/stock number/sku/... columns… and also a table of all my woocommerce orders with corresponding bought products/tax/... and other columns.
If I’m correct, that is possible with your plugin?
Hello there.
Thank you for reaching out to us.
We currently don’t have a native integration with WooCommerce, but you would be able to create a MySQL query that would pull the data you need from the database.
Please note that we don’t provide support for creating custom queries.
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.
How to add the table in PHP code? Something like php shortcode?
Hello there.
Thank you for reaching out to us.
We’re not exactly sure we understand what you mean.
If you want to create a table from PHP, you can create a table from a Serialized PHP array.
If you have a table, and want to use PHP to place the table on a page, you can use “do_shortcode”. For example:
<?php echo do_shortcode("[wpdatatable id=1]"); ?>
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.
Is it possible to place a form to ask some questions before a specific table is shown with the filtered data? (Based on the answers which are setup as columns and value are true or false)
Hello there.
Thank you for reaching out to us.
wpDataTables still doesn’t have any forms, nor are integration add-ons for Form Builders capable of performing tasks like this.
You can, however, acquire the Powerful Filters add-on, which can hide the table before the filtering is applied. With it, your site visitors would be able to select certain filtering values which, upon submitting, would result in a filtered 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.
Hello there.
The vulnerability was found in the full version of wpDataTables v3.4.1, so all premium versions before that can be affected.
As mentioned in the vulnerability information you shared with us (https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2021-24197), The wpDataTables Tables & Table Charts premium WordPress plugin before 3.4.2 has Improper Access Control.
The vulnerability is usually detected in the Lite version of the plugin because its version is below 3.4.1, so we’re not sure how WordFence reported it for 5.0. Perhaps it just looked at the slug (‘wpdatatables’) which is the same for the full version and the Lite version, while only Lite is available on wordpress.org. We can assure you that the plugin is safe for use.
Thank you for reaching out to us in this regard.
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 the premium version I bought and use license key. Is there anything i can do?
There’s nothing that needs to be done in this case, since this is a false positive.
Unfortunately, there are some cases when this is reported, but as you can see in the vulnerability info, it’s related to an old version of the plugin (before version 3.4.2), while new versions are not affected.
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, before buying can you confirm if I have a list of value but want to filter like they are different prices of plots, but I want to show a range of values like from 300,000, 500,000, etc in drop down instead of values within the column, so if anyone select that range can show those values from a certain range.
Hello there.
Sorry for the late response.
Unfortunately, something like this is not possible with the plugin’s built-in features.
There is a number-range filter, and you can enable the number-range slider, but those work only by allowing customers to manually select or enter the range they want to filter the column in. There’s no filter that would show a range of values.
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 bought the wpdatatables plugin. Is the wpdatatables plugin compatible with bold builder because it is recommended to use elementor and wpbakery. Thank you so much!
Hello there.
Thank you for reaching out to us.
wpDataTables works with the majority of page builders. We haven’t had the chance to test the Bold builder, but on the other hand, we haven’t had any complaints that it’s not working with it.
You should have no issues using it, but if you do, you can always reach out to our technical support via this links, and they’ll gladly help you out if you run into any conflicts.
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.
Thanks for your reply. Ivan
Been over two-days on TICKET #3136429…. thought you said support would be better after the price increase?
Hello there.
Thank you for reaching out to us.
Please note that our work hours are Mon – Fri, from 09:00 – 17:00 CEST. Our support agents go through tickets in the order in which they are received, not prioritizing anyone.
Since you posted your ticket on Friday, at 16:20, and there are other tickets that have been opened before yours, it will take some time before our agents reach your ticket. As soon as they do, they will provide you with a response.
Thank you for your understanding.
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’m busy creating a new website for one of my clients. On their ‘old’ website, I use your great Plugin WP DataTables, which is registered.
Now I want to export the existing data tables + settings from the old website and import them into the new one. Unfortunately, I can’t find out how to do this. My questions:
• How can I export and import existing data tables to a new website? • How can I export and import existing settings to the new install?
I hope this is possible? Otherwise, I have to create all data tables new….which is very time-consuming.
Hope you can help!
Hello there.
Thank you for reaching out to us.
Other than cloning the site using the Duplicator plugin (or something similar), another option would be to copy all database tables (wp_wpdatatable_#) along with tables wp_wpdatatables, wp_wpdatacharts, wp_wpdatatables_rows and wp_wpdatatables_columns. Then, in wp_options table, you would also need to export the following option_names:
wdtPreventDeletingTables
wdtUseSeparateCon
wdtSeparateCon
wdtTimepickerRange
wdtTimeFormat
wdtTabletWidth
wdtTablesPerPage
wdtSumFunctionsLabel
wdtRenderFilter
wdtRenderCharts
wdtIncludeBootstrap
wdtIncludeBootstrapBackEnd
wdtPreventDeletingTables
wdtParseShortcodes
wdtNumbersAlign
wdtBorderRemoval
wdtBorderRemovalHeader
wdtNumberFormat
wdtMobileWidth
wdtMinifiedJs
wdtMinFunctionsLabel
wdtMaxFunctionsLabel
wdtLeftOffset
wdtTopOffset
wdtInterfaceLanguage
wdtGeneratedTablesCount
wdtFontColorSettings
wdtDecimalPlaces
wdtCSVDelimiter
wdtDateFormat
wdtCustomJs
wdtCustomCss
wdtBaseSkin
wdtAvgFunctionsLabel
wdtInstallDate
wdtRatingDiv
wdtMDNewsDiv
wdtTempFutureDateIt is rather cumbersome to do all this, but unfortunately at the moment it’s the only way. Also, for tables linked to an existing data source, you would need to change the file path, because at the moment the file path depends on the domain, so if you change the domain, the URL to the file will also have to be changed.
Our developers are working on creating an “Export” function, so this will be much simpler in the future.
Hope this helps!
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,
Since updating to version 5.0 of WP, something is going wrong in a table that has a connection to a Formidable form. The date fields are not properly taken over. Some are filled, others are empty.
In the entries of the Formidable form, all dates are filled and this worked without problems since 2019.
Does anyone have an idea what could be causing this? Perhaps something is going wrong with the new cache feature?
Hope anyone can help.
Regards, Peter.
Hello Peter,
Thank you for reaching out to us.
We haven’t had any issues with Formidable Forms-based tables. All tables on our sandbox site have been there for quite some time, and they weren’t modified, yet they still work as expected. Moreover, we haven’t updated the Formidable Forms Integration for wpDataTables add-on, so there was nothing to trigger this issue.
If your support expired (Envato purchases expire 6 months after purchase), please open a private pre-purchase ticket on our official support platform by clicking here where you can leave your page for us to inspect, and send us your credentials if we need to inspect something in the back-end.
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,
I’ve found the problem with the dates. The date format was set to Day – Month – Year and this worked until some last update. I changed the format to Year – Month – Day and the problem is solved.
No more empty dates and sorting (I think the problem) wordks correct now.
Regards, Peter.
Hello there,
Thank you for reaching out to us.
We haven’t had any bugs reported in this manner, nor were we able to replicate the issue. Can you please tell us a bit more about what’s going on? How is the table created (separate data source, manual, MySQL, imported…)? Is the format the same as it is in the source file? Were you able to resolve the issue, or is it still occurring?
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,
We have a presale question.
I was wondering if your plugin can support an organization chart.
In google charts: https://developers.google.com/chart/interactive/docs/gallery/orgchart or in Highcharts: https://www.highcharts.com/docs/chart-and-series-types/organization-charti see that it is available.
But can your plugin create a chart like that? Do you support it?
What we want is pull data using a feed (CSV or JSON) and the put the data on an organization chart?
Is it available? Can you help?
Best Regards, Yiannis
Hello Yiannis.
Thank you for reaching out to us.
Unfortunately, organization charts are not available in wpDataTables. Even though they do exist in chart libraries, they need to be programmatically added by our developers.
Please feel free to add this chart type as a feature suggestion on this 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.
Dear friends, I love to use your plugin. I installed it on a domain that is deleted or not longer available for me to check. Is it possible to rest my license so I can use wpdatatables on my current active domain? I also messaged you about this topic but I got no answer here.
When i click on “Activate with Envato”, i get a loading screen and after this, I am redirected back to the activation screen but nothing happened there so far.
Would highly appreciate your help guys.
Hello there,
Thank you for reaching out to us.
After you click on “Activate with Envato”, the plugin should redirect you to Envato’s login page and after you log in, the purchase associated with your account would be activated. Reloading the activation screen is not expected behavior.
It could be that this happens because the license is active on another domain, but that should return the error that you’re trying to activate a license that’s been active on another site.
If you purchased the plugin over 6 months ago, you no longer have premium support, and you will not be able to open a ticket in the “wpDataTables” section on our official support platform. That doesn’t mean that we won’t help you with issues like this, so please access our support platform by clicking on this link and open a pre-purchase ticket.
Open a private ticket, so you can share your purchase code and website’s access credentials, and our support agents will gladly assist you there. Just mention you’re coming from Envato’s support page, 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.
I opened the ticket. I first tried to connect with my Office Browser. Maybe some security restrictions did not let the browser connect. On my private pc I got the message you mentioned “already activated”. I opened a ticket some minutes ago with same name as here.
Thank you in advance
Thank you for opening the ticket. We can see that our support agents responded, so hopefully this will be resolved soon.
Best!
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.
Is it possible to create a URL as “Link” within a Table based on a predefined manual Prefix URL and then a Data-Entry from a column both combined to one URL?
Hello there.
Thank you for reaching out to us.
Unfortunately, adding “https://” as a prefix will not allow you to create URL links. A “URL Link” column requires the full URL to be entered (with “https://” or “http://” included) and the prefix doesn’t help you resolve that.
Combining two columns with some text is possible with the CONCAT function of MySQL. You can take a look at this link to see an example of this being used.
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 the version on Envato seems to be a version behind the changelog? 4.4 is the version here and 4.5 seems to be the latest?
Hello there.
We sincerely apologize for the delayed response.
We’ve just updated wpDataTables to v5.0 and it should be available on Envato as well. Please check it out and let us know if you face any issues with it.
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 Gents – I want a customisation to allow actiity log/ audit trail per user so I can see the history of any changes made. How do I reach out to you guys for such a job?
Hello there.
We sincerely apologize for the delayed response.
We do not provide customization services, unfortunately, so we won’t be able to help you out with this. At the moment, the plugin doesn’t store edit history, and the only thing you can do is add a datetime (timestamp) column to see when a row has been edited for the last time. Everything else requires customization which is not included in the provided support for the plugin.
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 last update I get this error:
Warning: Undefined property: stdClass::$allowAllPossibleValuesForeignKey in /.../wp-content/plugins/wpdatatables/source/class.wdtconfigcontroller.php on line 1332
Warning: Undefined property: stdClass::$allowAllPossibleValuesForeignKey in /.../wp-content/plugins/wpdatatables/source/class.wdtconfigcontroller.php on line 1332
Is anyone else facing the same issue? How can I solve this?
Can I download previous version of the plugin? It was working properly.
Found the error. There was a conflict with another plugin.
Hello there.
Thank you for reaching out to us and for following up on this topic.
Can you please tell us which plugin caused this?
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 have a question, is it possible to increase filters on the left side to display different categories and subcategories within a graph?
Attached link of example image
https://ibb.co/qg3nPKvThanks for your reply
Hello there.
Thank you for reaching out to us.
We’re sorry to disappoint you, but unfortunately something like this is not possible with the plugin’s built-in features.
Also, the integrated charts in wpDataTables don’t have any filters, and the only way you can filter the charts is if you enable the “Follow table filtering” option when creating the chart, and then add the table on the same page.
The filters are not customizable, though, so changing their appearance or size would require custom work which is not included in the provided support for the plugin.
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.
Ok, i understood.
I have a question, is it possible to develop this functionality for the plugin? And if possible, what would be an estimated cost?
Thank you
You can add this as a feature suggestion on this page, so it’s up for voting.
Our developers develop new features based on the number of customer requests. Unfortunately, we do not have any customization services, so we can’t provide you with a quote for creating a custom solution.
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 display different datetime values for users from different timezones? Let’s say I have my data in UTC and wish to display them for +6 hours timezone automatically when visitors accesses the data. Thank you
Hello there.
Thank you for reaching out to us.
Unfortunately, wpDataTables adjusts the time zone to the time zone configured in WordPress’ General settings, and it can’t recalculate the time zone for different browser sessions.
We’ll make sure to forward this as a suggestion to our developers, but in the meantime, please make sure to add it on this 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.
