wpDataTables
Forum Replies Created
-
Hello,
We are not sure what you are trying to achieve exactly when you say a ‘painting’, but if you wish to make a background of our Table transparent, here is how it can be done with adding custom CSS to the Page where your table is.
For making the background transparent ( if you use table linked from CSV or Excel) for the Table’s HTML container, try this CSS :
.wpdt-c .wpDataTables.wpDataTablesWrapper {
background: transparent !important;
}Custom code needs to be applied to the page where the booking form is. Depending on what you’re using (Gutenberg blocks, or some page builder), adding the CSS or JS can be done in a few different ways.
If you need help with adding custom CSS to the page, please take a look at this article.
Here is how my example Table looks, when i set a purple background color on the Page, and the Table container is transparent :
We also have a “Customize” Section where you could easily set some colors inside your table, like odd and even row background color, etc, but the Customize is not available in our Free version.If you need more details on that subject, please open a ticket on our main Support platform here,
and one of our Agents will respond as quickly as possible.
If you don’t have a licence (or if it expired), please open a pre-purchase ticket which doesn’t require a purchase code.
Premium products are not supported in these forums, as per this comment by ww.wp.xz.cn moderators.
2. Or if you use a Simple table type, then you can use this CSS to make the background color of the entire table, including all cells transparent by adding the alpha value as 0.0 in RGBA :
.wpdt-c.wpDataTableContainerSimpleTable .wpdtSimpleTable.wpDataTable tbody td {
background-color: rgba(0, 0, 255, 0.0) !important;
}Or if you just wish to ‘target’ a specific Simple Table, you can add its ID like this :
table#wpdtSimpleTable-135 tbody td {
background-color: rgba(0, 0, 255, 0.0) !important;
}Just make sure to use your Table ID instead of 135 in the code.
Here are two ‘before’ and ‘after’ CSS screenshot comparisons to see how it makes the Simple table transparent for all cells :
Let us know if this achieves your desired use-case or if you wanted something else/ or more specific.
Kind regards.
Hello,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
Can you tell us do you have any symbols inside the cells where your numeric data is,for example a currency sign or percentage symbol?
If so, this will not work with our Plugin for numeric Columns such as Floats or Integers.
The solution is, to remove any symbols and just leave pure numeric data in the cells of your source Sheet, then you can make integer or Float Column from this in our connected Table.
( Just also double check if you have the same Number Format matched in the main plugin settings, and the decimal numbers)
After this, just go in the Display settings of the column, and add any prefix or suffix symbol there.
Let us know if that helps, it should work to be able to change this Column from String to Float or integer.
Or if you make a new Table from the source, the Plugin should automatically ‘guess’ the right Numeric Column format right away.
Then you will be able to use it in a Pie chart as the ‘slices’/series data.Thank you.
Hello,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
There are several important points to be aware of when working with a CSV in our Plugin.
1. Firstly, make sure not to use duplicate header names in origin Headers for columns.
If you make a duplicate Header name for one or more columns, our Plugin only takes the first occurence and ignores the other, duplicate column Header. So for column “Number” duplicate header, just add anything, in this case we add space and letter B (“Number B”) just to have it generate the table with three Columns and later we go in the Column Display settings and change the “Displayed Header” to the duplicate, now it shows both as “Number”.
So the original Header row in the CSV is like this :
Name, %, Number, Number B
The first row of data will be like :
UNITED STATES, 18.3, 42.07, 3.51
and second row, we added just to test sorting for numerical/floats :
Serbia, 10.02, 02.83, 5.33
We change the “Number B” Displayed Header to “Number” in order to have them both as duplicate Header in the Table visually.
2. Make sure to set our CSV delimiter to comma in Main Plugin Settings.
3. The Number Format for Floats is set to the US Format ( comma for thousands separator, dot for decimal separator).
4. One more important point, remove the percentage symbol from any numeric data if you need it to render as Floats ( or integer).
Then in our Plugin’s column display settings, simply add it as suffix.
And this is how a new Table connected to this CSV looks. The sorting for Floats also works.
We recorded a Video demonstration, so you can see how it looks bad if we change the CSV delimiter or wrong Number Format, etc, you can download it here.
Let us know if that helped to fix the issues when you follow these pointers or if you still encounter any issue?
If there is still an issue, it is best to first record a Video of your screen to show us the exact steps you do when you are creating the Table and how are all these settings configured on your Plugin installation.
Then, send us your CSV source file here so we can inspect if it has some specific formatting or anything like that which we did not take into account to try and reproduce the issue, etc.
If the Video or CSV does not contain any sensitive data, you can just upload to weTransfer and send us a download link.
Or if it shows any sensitive data, please open a ticket on our main Support platform here and one of our Agents will respond as quickly as possible to help you with further troubleshooting.
If you don’t have a licence (or if it expired), please open a pre-purchase ticket which doesn’t require a purchase code.
Thank you for understanding.
Hello,
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
Thank you for the kind words about the Plugin.
When it comes to the use-case you described, there might be a couple of different ways to achieve that kind of filtering for the Charts.1. For example, if you wish to have one or more column filters which can be used on front-end by a user to select which ‘year’ value they wish to change to;
we have a workaround to have the filters and the chart showing similar to one of the examples from that Page, as on this screenshot :
We use custom CSS to hide the Table, then we can just leave the filters with the chart on the Page, and we have a “Follow Table filtering” feature for Charts to achieve that ‘change data on the fly per chosen filter value’ effect.
But that is not available in the free/Lite Plugin version, since both advanced column filters and the ‘follow table filtering’ are only included with premium version;
so we are unable to discuss any details on that here.
If you wish to see the full guide how that is done for the premium version, please open a ticket on our main Support platform here, and one of our Agents can show you more details about that use-case.
If you don’t have a licence (or if it expired), please open a pre-purchase ticket which doesn’t require a purchase code.
Premium products are not supported in these forums, as per this comment by ww.wp.xz.cn moderators.
Thank you for understanding.
2. Or, if you use Tabs, at the moment we do have some issues with specific tab solutions.
Our developers are working on a fix, but we can’t say an exact ETA.
It will be best if you can also open a ticket for that on our main Support, and please send us more details here such as how you created the tabs/content via chart shortcode inside and if you added any kind of custom code/script on your Page;
then we can investigate it there in more details.
Thank you.
Hello,
Firstly, thank you for taking the time to evaluate our plugin’s functionalities and provide feedback. We are truly sorry to hear about your negative experience with our plugin so far.
After checking with our Support Team on both the Lite and Premium platforms, we were unable to find any support ticket under your name. Could you please confirm if you reached out to our Support Team before posting your review?
If not, it’s unfortunate, as our Support Team could have likely resolved most, if not all, of the issues you described. We prefer not to speculate without knowing the full details of your use case, such as the type of table you are using, whether you have any symbols combined with numbers in the numeric cells of your source data, and your specific concerns about import/export functionalities.
Here are some potential solutions based on the issues you mentioned, just please note, these are only our assumptions based on initially reading the description from your end. For more detailed advice, our Support would still ask you additional questions.
1. You mentioned an import/export feature.
We have the Table Tools feaure which allows you to export table data as CSV, Excel, copy to clipboard, or print the data from the table, but we are not sure exactly what you meant by that point.
2. In regards to importing the data, we have this premium feature which you can use to create an editable/Manual table made by importing the data from your Sheet (CSV/Excel/Google Sheet);
and you can also update an existing Manual table via file upload.
We are just not allowed to discuss any details here about premium features, since this Forum is only made for the Lite/Free Plugin Support.
You can reach out to our Main Plugin Support Team here, though, with a pre-purchase ticket, if you have any question about any premium functionality.
3. In regards to what you described about the Plugin reading the numbers wrong :
– If you have floats in your Source data, and perhaps the Table does not show/match the correct Float Number Format, this can be solved by changing the default Number Format in your Main Plugin Settings.
You can also set your default desired decimal point number there, and later on you can change the number of decimals per individual column setting.
4. Additonally, if you have any symbol combined with numbers in the source numeric cells, this can’t be rendered as numbers in our Plugin, but there is a solution.
You would remove any symbols from the numeric cells in the source data/so just leave the pure numbers in your source cells – then in our Plugin, you can set a prefix/or suffix in the Column Display settings, such as a currency sign, for example or any other content.
Then the Plugin will read this as numeric Data and you won’t have to change it to String Column type.
5. Integers showing a decimal separator :
Do you perhaps mean the thousands separator?
If that is the case, please enable the “Skip thousands separator” option in the Data tab of your integer column settings to resolve this.
6. Tables with larger data :
The loading speed depends on multiple factors, but our Plugin has multiple features to handle larger tables.
For the Lite version, please try using the Cache and Auto-Update Cache Feature for source files up to few thousand rows.
This can help with performance, but only up to around 5 to 6 thousand rows.
If your source file gets larger than that, and if you reach the limits of your Hosting Server and WordPress in general( such as extremely slow load or crash of the Page), then you would need to try the premium Plugin’s server-side processing, there is no other way to solve that specific issue.
That issue does not come from our Plugin itself, but you are rather simply reaching the limit of what WordPress and your Hosting Server performance can achieve.
With non-server-side tables, when the row count goes over a certain number, you can reach the limit of the Hosting Server, if you encounter extremely slow table load, or even crash the browser; because in that case, all the rows are loading at the same time via the HTML of the browser Page;
compared to server-side processing Tables, they use an Admin-Ajax call to only load one Table’s page at a time, which is useful for very large tables, but that would require you to move to SQL based Tables and import your Excel/CSV data in the Database, which is only available in our premium Plugin version.
For example, you can check the table on this Documentation Page, which has 2.560.000 rows and see how it loads.
Please note, that table is an SQL Query based type and uses the said server-side processing to achieve this performance.
We are not allowed to discuss any details about premium features here due to forum guidelines, but our Support Team is ready to assist you further if you open a ticket on our main support platform.
If you would give the Plugin another chance, please open a ticket on the main Support platform here and one of our Agents will respond to advise you on all issues/details as quickly as possible.If you don’t have a licence (or if it expired), please open a pre-purchase ticket which doesn’t require a purchase code.
Premium products are not supported in these forums, as per this comment by ww.wp.xz.cn moderators.
Just to be clear, if you plan to have only up to around few thousand rows in your source Sheet for the linked Tables, as you wrote ~1000 rows, then we should be able to easily help you solve any slow load with the Lite Plugin version;
We are just unsure about all the details needed, and that is why we recommend it is best to reach out to our Main Support, so they will advise you if all of the details for your use-case can be achieved with the Lite Plugin or if some premium function is needed for one or more points.We hope you will give our Support Team a chance to help you resolve these issues and consider updating your review.
Kind regards.