I would like to duplicate a table 245 times. Please advise how i can do this, or am i expected to upload each one by one ? The same settings for all tables.
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.
- I am very sorry to disappoint you, but at this time, we don't have a way of copying/duplicating multiple tables at the same time;
the only method we have is the built-in duplicate functionality, using the button on the right side of the wpDataTables table list :
- The quickest way for that can be using an SQL query.
Inside your WordPress database, you will find a ' wp_wpdatatables_columns ' table. (the prefix ' wp_ ' might be different for you, depending on how you set it up)
- here is a screenshot from my local example at phpMyadmin :
- The column named ' formatting_rules ', holds all the conditional formatting of all the tables.
You can copy all the conditional formatting for a specific table, and use it through SQL query.
An important thing to mention, you have to be careful only to copy the conditionals for that particular table you need, because if you copy over some additional conditionals belonging to other table ID's, it will present issues.
Here is what I mean, with the column ' table-id ' holding all these table ID's, as shown:
;
You can filter the tables using "search", to show only rows from a specific table ID, like this :
I would like to duplicate a table 245 times. Please advise how i can do this, or am i expected to upload each one by one ? The same settings for all tables.
Please let me know soon. I really need to figure this out.
Hi, John M
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.
- I am very sorry to disappoint you, but at this time, we don't have a way of copying/duplicating multiple tables at the same time;
the only method we have is the built-in duplicate functionality, using the button on the right side of the wpDataTables table list :
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Okay, for now is there any way of duplicating conditional formatting to every column?
Hi, John
- The quickest way for that can be using an SQL query.
Inside your WordPress database, you will find a ' wp_wpdatatables_columns ' table. (the prefix ' wp_ ' might be different for you, depending on how you set it up)
- here is a screenshot from my local example at phpMyadmin :
- The column named ' formatting_rules ', holds all the conditional formatting of all the tables.
You can copy all the conditional formatting for a specific table, and use it through SQL query.
An important thing to mention, you have to be careful only to copy the conditionals for that particular table you need, because if you copy over some additional conditionals belonging to other table ID's, it will present issues.
Here is what I mean, with the column ' table-id ' holding all these table ID's, as shown:
;
You can filter the tables using "search", to show only rows from a specific table ID, like this :
;
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Thank you very much !
Hey, John
- You're welcome.
If there is anything else we could advise about this, contact us again -
or if something that is not related to this subject, please don't hesitate to create new tickets;
Thank you. Have a nice day!
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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