Almost anything can be customized with CSS, so we don't have any document about this. The plugin's features are described in our documentation, but custom solutions such as CSS, javascript, SQL query creation, etc. are not.
From your first screenshot, I see you want to hide the table headers, and that you're targeting table #1. This is usually used when you have a few tables on a single page, and in between the <style>...</style> tags when you're creating the page. If you leave it like this, and have a few pages with multiple tables shown, it will always hide the first table regardless.
All table wrappers are added as odd numbers; for example if you have three tables, they'd be identified as:
table_1_wrapper
table_3_wrapper
table_5_wrapper
So, to hide only the headers of the first table on that page, the code needs to be:
So, the same as you have it entered, but in between the <style>...</style> tags.
If you want to hide all tables' headers, you can do this with this CSS:
.wpdt-c thead {
display: none !important;
}
If you have only one table on your page, you need to remove it from Custom CSS in main settings of wpDataTables, and paste it between the <style>Your code</style> tags on the page where the table is located.
Now, the error shown in the second attachment will be shown no matter what you try to change in main settings of wpDataTables, if I'm not mistaken. For example - try changing the number format, and the error will appear again.
It indicates there's a separate DB connection that is either missing the connection parameters, or they are invalid. You can test this by clicking on the "TEST DB SETTINGS" button. When one of the connections fails, you'll find the connection causing the error.
Thanks for the explanation regarding the use of CSS.
Regarding the error - the connection I created the an additional MySQL DB works well. the "Test DB" button returns success and I use the connection in few tables
If I'm not mistaken - you kept getting the separate DB connection, correct?
If that is true - you were missing the port # in its settings. I added the default port 3306 and it should be working fine.
Can you please check and let me know?
As for inserting the CSV data to an existing MySQL table created with wpDataTables - unfortunately that is not possible. However, if the CSV file has the same structure, you can add it to the table through PHPMyAdmin, by clicking on "Import" in the top menu of that table.
I'm trying to customize some of the table styles but it fails with an error, see attached screenshot
Also, is there a document describing which styles can be customized
Hello Shai.
Almost anything can be customized with CSS, so we don't have any document about this. The plugin's features are described in our documentation, but custom solutions such as CSS, javascript, SQL query creation, etc. are not.
From your first screenshot, I see you want to hide the table headers, and that you're targeting table #1. This is usually used when you have a few tables on a single page, and in between the <style>...</style> tags when you're creating the page. If you leave it like this, and have a few pages with multiple tables shown, it will always hide the first table regardless.
All table wrappers are added as odd numbers; for example if you have three tables, they'd be identified as:
table_1_wrapper
table_3_wrapper
table_5_wrapper
So, to hide only the headers of the first table on that page, the code needs to be:
So, the same as you have it entered, but in between the <style>...</style> tags.
If you want to hide all tables' headers, you can do this with this CSS:
If you have only one table on your page, you need to remove it from Custom CSS in main settings of wpDataTables, and paste it between the <style>Your code</style> tags on the page where the table is located.
For example:
Now, the error shown in the second attachment will be shown no matter what you try to change in main settings of wpDataTables, if I'm not mistaken. For example - try changing the number format, and the error will appear again.
It indicates there's a separate DB connection that is either missing the connection parameters, or they are invalid. You can test this by clicking on the "TEST DB SETTINGS" button. When one of the connections fails, you'll find the connection causing the error.
I hope this helps.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hi
Thanks for the explanation regarding the use of CSS.
Regarding the error - the connection I created the an additional MySQL DB works well. the "Test DB" button returns success and I use the connection in few tables
Still, I get this error
Hello again Shai.
I tried logging into https://www.prettyballerinas.co.il with those credentials, but failed.
Can you please provide the URL where I can log in, as well?
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
Hello Shai.
If I'm not mistaken - you kept getting the separate DB connection, correct?
If that is true - you were missing the port # in its settings. I added the default port 3306 and it should be working fine.
Can you please check and let me know?
As for inserting the CSV data to an existing MySQL table created with wpDataTables - unfortunately that is not possible. However, if the CSV file has the same structure, you can add it to the table through PHPMyAdmin, by clicking on "Import" in the top menu of that table.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
You are welcome Shai. Glad that we solved the issue.
If you have any more issues or questions feel free to open a new ticket, we will gladly help.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables