I have looked over all your support and do not see the same option to update the data source of my existing data table. I created the table with a .csv file that I upload to the media folder for my wordpress site. Under the Data Source tab it is not giving me any options to update the .csv file. I have attached a screen shot to show you the options that the tab does show. I need to be able to update that existing table by pointing to an updated .csv. How do I do that?
After that you can not update it with a new CSV as built-in feature, from the plugin,
because now a new Manual table is created.
-
The only two options you have to update it via CSV is like this:
1. If you want to update using CSV file;
You would have to leave only the new rows of the CSV, delete old rows and headers;
and then import this CSV into the table in the database, using something like phpMyAdmin, or by using a custom SQL query function to update from CSV;
Here is how to find which table it is in the database, on the Editing tab, you have to enable editing just to see the MySQL table name, like this:
Then you can find the table in the database
And you can import the updated CSV, but as mentioned earlier, delete headers, and delete old rows, just update new rows;
-
2.
The second option is to use an SQL Query to pull the data from this table in a new wpDataTable.
*Please note: Using the plugin's MySQL feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need. If you do not know how to use MySQL, refer to the “Create a MySQL-query-based table by generating a query to MySQL database” section. It will explain how to create complete tables or MySQL queries without this basic knowledge. Please be advised that preparing MySQL queries for you is not included in the plugin support.
-
I will also provide more information to differentiate two ways how you can use CSV files in wpDAtaTables;
As you can see, if you import the data to make a new Manual table, it can be editable on WP-Admin and front-end, but it loses the link to the source; if you update the CSV, the table won't pick that up;
Or if you link the CSV to a table; then the changes of values on the source will reflect the output table, but it can't be editable on WP-Admin or front-end.
-
I am hoping i explained this in a clear way, but let me know if you have any questions. Thanks
I have looked over all your support and do not see the same option to update the data source of my existing data table. I created the table with a .csv file that I upload to the media folder for my wordpress site. Under the Data Source tab it is not giving me any options to update the .csv file. I have attached a screen shot to show you the options that the tab does show. I need to be able to update that existing table by pointing to an updated .csv. How do I do that?
-Mark
Hi, Mark
Firstly i want to apologise for the delayed response time.
We celebrated our Orthodox Easter, which has slowed down our working pace.
Thank you very much for your patience.
-
When you import a CSV to create a table, a new table gets created in the WP database;
After that you can not update it with a new CSV as built-in feature, from the plugin,
because now a new Manual table is created.
-
The only two options you have to update it via CSV is like this:
1. If you want to update using CSV file;
You would have to leave only the new rows of the CSV, delete old rows and headers;
and then import this CSV into the table in the database, using something like phpMyAdmin, or by using a custom SQL query function to update from CSV;
Here is how to find which table it is in the database, on the Editing tab, you have to enable editing just to see the MySQL table name, like this:
Then you can find the table in the database
And you can import the updated CSV, but as mentioned earlier, delete headers, and delete old rows, just update new rows;
-
2.
The second option is to use an SQL Query to pull the data from this table in a new wpDataTable.
*Please note: Using the plugin's MySQL feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need. If you do not know how to use MySQL, refer to the “Create a MySQL-query-based table by generating a query to MySQL database” section. It will explain how to create complete tables or MySQL queries without this basic knowledge. Please be advised that preparing MySQL queries for you is not included in the plugin support.
-
I will also provide more information to differentiate two ways how you can use CSV files in wpDAtaTables;
As you can see, if you import the data to make a new Manual table, it can be editable on WP-Admin and front-end, but it loses the link to the source; if you update the CSV, the table won't pick that up;
Or if you link the CSV to a table; then the changes of values on the source will reflect the output table, but it can't be editable on WP-Admin or front-end.
-
I am hoping i explained this in a clear way, but let me know if you have any questions. Thanks
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