I need to create approximately 100 tables and 100 charts based on CSV data for Country dashboards. There are a total of 140 countries. Therefore, I need to create a total of 14,000 tables and 14,000 related charts. The tables and charts are structurally the same for each country- The only difference being the CSV file they are referencing.
Is there a way to use one set of tables and charts to create the new tables and charts? In essence, I would like to export a sample country’s 100 tables and 100 charts into an Excel file, modify all of the data for a new country in excel or some other format (minor customizations and re-referencing the tables and charts). After which I can import the new country data back into the WordPress system.
The alternative is to individually duplicate tables and charts which will take an extremely long time for 14000 tables and 14000 charts.
Whatever approach you choose, you're in for a long process.
I don't understand, though, your terminology. You're mentioning 100 tables and 100 charts, then 14,000 and 14,000 charts. Are you maybe referencing columns or rows?
If you can manage one Excel file, you could import it to generate new tables from it.
It is 100 tables and 100 charts PER country. There are 140 countries - thus 14000 tables and charts total (100 x 140). Each country will have a dashboard environment on my site which plots the 100 charts. Each country dashboard will have the same Structure but will reference different csv files related to the specify country. The number of tables will probably be slightly less than the number of charts since in some cases multiple charts will reference the same table.
The CSV files are automatically generated and saved to the website through a python script cron.
I am in the process of creating the first country dashboard with all required tables and charts. As you mentioned, this is quite time-consuming. Instead of duplicating and customizing the individual tables and charts to then create the next dashboard, I am trying to find a way to export the entire wpdatatables content (which would include the first country’s tables and charts) to a csv or excel file so that I can quickly bulk duplicate and make global reference changes and then reimport with the additional country tables and charts.
If this is possible I can then simply duplicate the dashboard environments and reference the new table and chart ids for each country.
That depends on how you're creating these dashboards.
If each country has a subdomain on your website (multi-site), you could export wp_wpdatatables and wp_wpdatatables_columns database tables from the first dashboard, and then import them in other subdomains.
That would give the exact replica of the first site on your other subdomains. The only thing you would need to do after that is change the "Content" column in wp_wpdatatables database table, so they pull the data from correct CSV files.
thanks Alexander. That is a good suggestion but each country will not have it on subdomain. However, I am considering hiring someone to create a customized plug-in for me that can handle the work. Can you tell me where In the mySQL that all of the data is stored for the tables and charts?
I know there are multiple tables and if you can let me know which tables I need to reference and what is actually in those tables I can hopefully get a solution. Appreciate your continued help.
wpDataCharts table consists of basic info - chart's ID, ID of the table the chart is created from, engine (Highcharts, Google or Charts.js), chart type, and the rendered data in JSON format in the last column.
wpDataTables stores settings for each table, and content - source for table creation, along with table settings;
wpDataTables_columns contains info about every column in each table (type, filtering type, editing type, order, column ID, conditional formatting, etc)
wpDataTables_rows table is for simple tables since they can't be used as other manual tables.
Hi Aleksandar. I have not found a solution to this issue yet and am now at a point where I am ready for mass duplication of some tables and charts.
Do you have any suggestions for a company that could create a plug-in for me that will allow me to export existing table and chart data to excel or csv and then modify/append the excel or csv so that I can reimport the updated data that would modify existing existing tables and charts AND automatically create new tables and charts based on the changes and additions to the excel or csv file?
I am not aware of any other companies that do this custom work, other than WP Kraken. They are a bit pricy, though, so you can send them the request, but I don't know how much they'd charge for something like this.
I need to create approximately 100 tables and 100 charts based on CSV data for Country dashboards. There are a total of 140 countries. Therefore, I need to create a total of 14,000 tables and 14,000 related charts. The tables and charts are structurally the same for each country- The only difference being the CSV file they are referencing.
Is there a way to use one set of tables and charts to create the new tables and charts? In essence, I would like to export a sample country’s 100 tables and 100 charts into an Excel file, modify all of the data for a new country in excel or some other format (minor customizations and re-referencing the tables and charts). After which I can import the new country data back into the WordPress system.
The alternative is to individually duplicate tables and charts which will take an extremely long time for 14000 tables and 14000 charts.
Appreciate any help you can provide
Hello Terry
Whatever approach you choose, you're in for a long process.
I don't understand, though, your terminology. You're mentioning 100 tables and 100 charts, then 14,000 and 14,000 charts. Are you maybe referencing columns or rows?
If you can manage one Excel file, you could import it to generate new tables from it.
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
It is 100 tables and 100 charts PER country. There are 140 countries - thus 14000 tables and charts total (100 x 140). Each country will have a dashboard environment on my site which plots the 100 charts. Each country dashboard will have the same Structure but will reference different csv files related to the specify country. The number of tables will probably be slightly less than the number of charts since in some cases multiple charts will reference the same table.
The CSV files are automatically generated and saved to the website through a python script cron.
I am in the process of creating the first country dashboard with all required tables and charts. As you mentioned, this is quite time-consuming. Instead of duplicating and customizing the individual tables and charts to then create the next dashboard, I am trying to find a way to export the entire wpdatatables content (which would include the first country’s tables and charts) to a csv or excel file so that I can quickly bulk duplicate and make global reference changes and then reimport with the additional country tables and charts.
If this is possible I can then simply duplicate the dashboard environments and reference the new table and chart ids for each country.
Hi again Terry
That depends on how you're creating these dashboards.
If each country has a subdomain on your website (multi-site), you could export wp_wpdatatables and wp_wpdatatables_columns database tables from the first dashboard, and then import them in other subdomains.
That would give the exact replica of the first site on your other subdomains. The only thing you would need to do after that is change the "Content" column in wp_wpdatatables database table, so they pull the data from correct CSV files.
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
thanks Alexander. That is a good suggestion but each country will not have it on subdomain. However, I am considering hiring someone to create a customized plug-in for me that can handle the work. Can you tell me where In the mySQL that all of the data is stored for the tables and charts?
I know there are multiple tables and if you can let me know which tables I need to reference and what is actually in those tables I can hopefully get a solution. Appreciate your continued help.
Hello again Terry
Well, there's not much in the database. Without manually generated tables, the tables generated by the plugin are:
wp_wpdatacharts
wp_wpdatatables
wp_wpdatatables_columns
wp_wpdatatables_rows
wpDataCharts table consists of basic info - chart's ID, ID of the table the chart is created from, engine (Highcharts, Google or Charts.js), chart type, and the rendered data in JSON format in the last column.
wpDataTables stores settings for each table, and content - source for table creation, along with table settings;
wpDataTables_columns contains info about every column in each table (type, filtering type, editing type, order, column ID, conditional formatting, etc)
wpDataTables_rows table is for simple tables since they can't be used as other manual tables.
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 Aleksandar. I have not found a solution to this issue yet and am now at a point where I am ready for mass duplication of some tables and charts.
Do you have any suggestions for a company that could create a plug-in for me that will allow me to export existing table and chart data to excel or csv and then modify/append the excel or csv so that I can reimport the updated data that would modify existing existing tables and charts AND automatically create new tables and charts based on the changes and additions to the excel or csv file?
Hello Terry
I am not aware of any other companies that do this custom work, other than WP Kraken. They are a bit pricy, though, so you can send them the request, but I don't know how much they'd charge for something like this.
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