3621 comments found.
too many requests to the server, My hosting is asking me to reduce the requests made by admin-ajax.php can anything be done?
solved… All the best
Thanks for letting us know the issue has been resolved!
If you need some further assistance, please feel free to reach out to us.
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 WPdatatables seo friendly?
Hello there, thank you for reaching out to us!
The plugin is SEO friendly, especially if you’re creating tables linked to an existing data source (Excel, CSV, PHP, etc). If you’re creating server-side tables (manual, MySQL, or imported), though, the search engines will only be able to see the first page of the table.
So, for example, if wpDataTables are configured to display only the first 10 rows, and split the rest into pages, the search engines will be able to see those 10 rows.
If you need some further assistance, please feel free to reach out to us.
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 there…
I was wondering is there any add-ons that I can by, that can help me colour with CSS or add date column, or some class to filed that user edit?
I have some data, and I’m receiving email when user edit his entry…but I also want to colour that row for example…
Tried to submit this to your support , but it’s now allowing since my licence expired but I should be to write you….
Ok, forget this I manage to resolve it. But I have issue adding and removing column from Manual Table… If I click anything I just get modal opening and it’s blank …
Hello there.
Thank you for reaching out to us, and sorry for the late response.
We can’t say what caused this without accessing your site. Please open a ticket on our official support platform, mention that you were directed there from a comment made on CodeCanyon and we’ll gladly help you 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.
No forget about it… it’s not so big issue… But I have question, I’m using your place holder CURRENT_DATETIME for predefined value ... was wondering when user edit his data, can that field be again CURRENT_DATETIME with new date and time? To overwrite previous one…smt like modification date column. Thanks
Hi again.
Not in that way. You would need to do this:
1. Create a column (for example “Updated”) in your table
2. In column settings set the type to be “DateTime” (in the “Data” tab), and in the “Editing” tab set the “Editor Input Type” to “none”.
3. In the database, run this query:
ALTER TABLE `table_name` CHANGE `updated` `updated` DATETIME NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;
Please note that you need to replace ‘table_name’ with the actual database table name. You can find the database name of the table in the Editing tab above the table, in the “MySQL query name for editing” field.
Hope that 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.
Thank you, this did the trick!
You’re welcome!
If you need some further assistance, please feel free to reach out to us.
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.
Hoping for help.. Sadly it shows only the post ID when adding title with link. No function to show the permalink of the posts
I made a table from wordpress query.
It should show Post Title (post_title_with_link_to_post ) and date.
1. Sadly the url of the posts shows url.com/?p=337
instead of the permalink? how can i make wpdatatables show permalinks?
2. How can I exclude drafts? as 90% listed under post are drafts
solved nr 1. But nr. 2 I dont know how to solve
Now I have the big issue that Search doesnt find anything: No matching records found always
Hello there.
Thank you for reaching out to us.
Since you can only do this with custom MySQL queries, you’ll need to create a query that excludes drafts, by applying conditions through query statements. Please be advised that preparing MySQL queries for you is not included in the plugin support.
As for search – we use a 3rd party PHP SQL parser which is somewhat limited, and if you include CONCAT, UNION, JOIN, or similar MySQL functions, search, filtering, and sorting will not work properly. The available workaround would be to create a MySQL view which will return the data you need, name it “view1” for example, and then create a table using 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.
Hi guys i did not find a solution to display a price correctly in your plugin. For example I have an price of 1.580,80 €. the only solution to display the thousand point and the comma for the cents is to use it as float. in this case the system makes me an 158.080,00 price! so i am searching for an solution to display the price correctly, when i use string the comma and the point is changed so i get an 1,580.00 price which is not correct in germany. Please help me!
maybe it is an problem with the correct formating in ecel what would be the correct format there
Hello there.
Only floats can display decimal places, that is true. You can change the number format in wpDataTables settings, so it can be either 15.000,00 or 15,000.00.
The format needs to be the same in wpDataTables, Excel, and your local machine in order for wpDataTables to import it correctly.
If you still face issues with this, please feel free to open a pre-purchase ticket on our official support platform, and our support agents will gladly assist you 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.
Gents can the plugin track changes. i.e if i have Company table and the name of the company is Amazon Ltd, I then change it to Bezos Ltd.Can it create a trail of the when I changed it from Amazon Ltd to Bezos Ltd?
Hello there.
Thank you for reaching out to us.
We’re sorry to disappoint you, but unfortunately, wpDataTables can’t do anything like that.
We hope it will be available in the future, but we can’t say for sure.
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.
No matter what I try when trying to import a csv file it says that the header has no description?!!
Hello there.
This error indicates that one of the columns doesn’t have a header, which is needed for generating a table. If you’re certain that all your columns do have a header, most likely some of the other columns to the right of the data are formatted, and therefore seen as valid, not empty columns.
Try opening the CSV file in Excel and copying only the columns and rows that contain data. Create a new Excel file and save it as CSV, and try importing the file again.
If you’re still having issues after that, please feel free to send us a ticket on our official support platform, send us that file in a private ticket, and our support managers will gladly 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.
I have done exactly what you said and I simplified form and removed all formulation, still this message: There was an error while trying to save the table! OK WDTException: [0]: One or more columns doesn’t have a header. Please enter headers for all columns in order to proceed.
I just want to import a excel file. why is this so difficult!!!
I dont tell me to send ticket as I dont have support anymore.
Hello there.
The error itself indicates there’s a column without a header, so you do have a column that doesn’t have a header – most likely there’s some leftover formatting.
You can’t import a table without a header, because the database entry wouldn’t allow the plugin to save a table without a header.
You can still open a Pre-Purchase ticket on the link we sent you in our previous response -> here: https://tmsplugins.ticksy.com/submit/#100010481.
Send us a private ticket along with the file, and our support managers will gladly see what caused this to happen.
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.
Please reset my license. It looks like it’s registered on a different domain.
Hello there.
We don’t have insight into your purchase code based on your Envato nickname, so please open a Pre-Purchase ticket on our official support platform, and our support managers will gladly assist you there.
Make sure to open a private ticket, so you can share your purchase code with 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.
Hello! Is it possible using your plugin to create a table with woocommerce products where product name is an active link to the product page and replace standard woocommerce loop to show products only in this table?
Hello there.
Thank you for reaching out to us.
Unfortunately, we don’t have a native integration with WooCommerce, so the only way of setting this up would be through MySQL query-based tables, but since this feature requires some knowledge of SQL, and preparing MySQL queries for you is not included in the plugin support, we wouldn’t be able to help you create a query that pulls the data you need.
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, but is it possible to do what I ask?
Hi again.
Yes, if you know your way around MySQL queries, it is possible.
For the product name to be a hyperlink to the product page, you’d need to include the CONCAT function, but in order to use wpDataTables as the listing, you’d need to forward the purchase directly to the checkout (if we understood correctly what you asked).
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 two columns, Column A is filled with numbers, and Column B is a Yes or No string column. I want to Sum values in the Column A, however where the Column B says “No”, I want there to sum the value “0” instead of real value from Column A. How can this be achieved?
Hello there.
We’re sorry to disappoint you, but unfortunately something like this can’t be done with the plugin’s built-in features.
There’s no conditional formatting between columns at this point, but our developers will be working on that in the future.
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.
Hello, I need to keep all the created tables with headers and only delete the data within each. Via SQL I tried with the DELETE function but is there a command to do “DELETE ALL TABLES WITH TABLE_NAME BEGIN WITH” xx_wpdatatable_% ”? Or a plugin function? Thank you, best regards
Hello there.
We’re sorry to disappoint you, but unfortunately something like this can’t be done with the plugin’s built-in features.
You can check out this thread on stack overflow and see how you can delete data from the table in the database, without losing the table structure.
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.
Presale question: is possible with the forminator plugin add on, to submit an embed iframe from youtube video and then on datatable show the link or a button and when is clicked appear the video to play like a modal o pop up? Thank you
Hello there.
Thank you for your interest in our plugin.
If Forminator Forms accepts an embed code, then you should have no issues creating a table from that form’s entries, and if the column in which the iframe is is saved as a string – the plugin should display it.
You can copy the embed code from YouTube and add it to wpDataTables, and it will work, so if Forminator allows this in their forms, there’s no reason why it wouldn’t work in wpDataTables.
We haven’t tested this, and we don’t know if Forminator accepts embed codes, though, so we can’t say for sure.
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.
https://wpdatatables.com/documentation/table-examples/catalog-of-books/
In this example you have a catalogue of books… I want the same only for Car Make and Model..
I have Woocommerce Car Parts shop – you choose car make + model it shows products..Interesting if it’s possible to “shortcode a table” for example only for Audi A4, A6, A8 + all categories as a list… technically the same books catalogue only to show specific stuff..
Hello there.
wpDataTables doesn’t yet have a native integration with WooCommerce, so all data from their database needs to be extracted using custom MySQL queries.
To use this feature, you would need some advanced knowledge of MySQL, so you’d be able to create a query that pulls the data you need, and we do not provide support for custom queries.
You can also try using our MySQL query constructor, but please note that this tool is not an ultimate query generator, and it should be treated as a helper for constructing a suggestion of a query, by trying to ‘guess’ what you want. We are constantly working to improve it, but SQL is such a complicated and flexible language that fully automating the process for constructing queries is hardly possible. Consequently, the more complicated your request is, the higher is the probability that it will not return exactly what you need.
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 meta_value in the postmeta table showing as below, for example.
a:5:{s:3:”SGD”;a:5:{s:4:”rate”;s:5:”1.358″;s:3:”pos”;s:4:”left”;s:8:”decimals”;s:1:”2″;s:6:”custom”;s:0:””;s:4:”hide”;s:1:”0″;}}
will I be able to make this into a table using the plugin?
expected outcome of table is something like this..
currency rate SGD 1.358
Can you please advise me on this? I am not so well-versed with php and sql.
Thank you
Hello there.
Sorry for the late response.
The plugin can pull only what it sees in the database, so you would need to unserialize this data using a MySQL query, as mentioned here, but this falls under custom work, so we cannot provide any support for 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.
Thank you for the update. That’s amazing way to create a table from the unserialzied data. That opens up my view and see how I can use this plugin.
Thank you for that.
You’re welcome! Glad we could be of assistance.
If you have some other questions or issues, please feel free to reach out to us, and we’ll gladly help.
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 got questions
1. is there any limit to the data I can put in the plugin?
2. Can I use the plugin on as many projects as possible?
3. Can I limit users from accessing data; like if I don’t want a user to see data and another user to see it; can I decide who sees what?
4. Can I simply upload existing documents and create a table that can be edited by users?
5. I dont know sql; can I still use this plugin?
Hello, thank you for your interest in our plugin.
1. If you’re using server-side tables (manual, imported, or SQL query-based), there’s virtually no limit to the number of rows, as the plugin can display millions of rows. The limitation applies to tables linked to sources like Excel, CSV, JSON, etc. and the limit is around 2.000 – 3.000 rows (no exact limit, as it varies depending on the server’s configuration, internet speed, the amount of data, etc).
2. What are you refferring to as “projects”?
3. You can only enable “Users see and edit only own data” which allows users to see and edit only their own entries.
4. You can use the “Create a table by importing data from a data source” in which case the plugin reads the source, and creates a manual table which can be edited, but it will no longer be connected to the source file.
5. Yes, you don’t need to create MySQL query-based tables if you are not familiar 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
Quick question. Is there a way to restrict the visibility of the data on the table to a current user?
Let’s say I build a report that contains the sales data for merchant A, B, C
I would like to control that merchant A gets to see the data belongs to them same goes to merchant B and C
A simple way i can think of is to create 3 sets of reports with pre-set filter. but i am trying to see if there is any way the report can recognize the current user’s (customer ID or merchant ID) dynamically and filter the data before displaying it on the page.
Is this possible? Please advise.
Thank you
Hello there.
You can create a table where users can see and edit only own data.
If you only need to let them see the tables, without the ability of editing, adding, or deleting rows, you can hide the edit buttons with the code provided on this page.
Please let us know if you have any further questions.
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.
For the last several updates, I’ve manually updated my plugin from the code canyon download page. It unfortunately remains at v3.4.3 after going through all the hoopla of deleting the files via ftp, uploading it up, deactivating the plugin and then activating it. Am I doing anything wrong? All of the plugin files have been 14.7MB and I can not find any info inside when unzipped about what version it is.
Hello there.
We’ve uploaded the latest update (3.7.1) here yesterday, so please try downloading the plugin again, and you should have no issues updating it.
If you still face issues, please open a pre-purchase ticket on our official support platform, where you can send us your receipt from Envato, and we’ll gladly send you the new installation file.
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.
Data is populating my Table when I’m logged into WP, but when I log out, the table shows with no data.
Hello there.
Sorry for the late response.
Do you maybe have the “Users see and edit only own data” feature enabled? If you do, then you can only see the data linked to the user who added the rows, and since non-logged-in users have User ID: 0, you cannot see anything.
If this doesn’t help, please feel free to open a pre-purchase ticket on our official support platform, and our support managers will gladly help.
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.
Is there a way to make a json feed create an actual table with the database to use as dynamic values so I can call them within something like gravity forms? If no will this ever be added as a feature perhaps?
Hello there.
We’re not exactly sure what you mean, but if you want to create a table from a JSON file, you can do that. Please check our documentation about it.
If you’re referring to the REST API, unfortunately, that can’t be done. It is planned for the future, but we can’t provide you with an 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 interest to buy this plugins. But before I buy this plugins, I have a question. Can Editor Role create new table and chart using this plugins or only administrator can access the plugins?
Thanks.
Hello there.
Thank you for reaching out to us.
Only Administrators of the website have access to wpDataTables’ back-end. Even though you may be able to edit other roles to gain access to wpDataTables’ features, it is not recommended, as they would also gain access to other segments of your site.
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.
