Q: Just purchased this deal and Straight off the bat - I do not like that we cannot import a xls or cvs file ...
(like we can in Tablepress) directly from my computer. I do not like that I have to import the file to Media Library and then from there select it. Personal Preference BUT a very big deal for me. I prefer not to have to upload tons of excel files just to then go select them. Your "Create a table by importing data from data source" is not a true statement (or at least how I interpret it). YOU NEED TO HAVE BOTH OPTIONS - if one chooses they can upload their file to media library OR if one chooses they can upload directly from their computer (like Tablepress does). If a free Plugin like Tablepress has this option then you as a Paid Plugin should also have this option. Please advise if you do have this option and maybe I just don't see it yet. Because quite honestly my only other option (for my scenario) is to manual create tables and that is a lot of data I would have to manual create - could be a deal breaker (I purchased 4 codes) as to whether I keep this deal.....still exploring wpDataTables, but like I said at the beginning Straight off the bat - big red flag of an issue for me.
FYI - I did watch your video "Creating editable tables by importing data from Excel, CSV or Google Spreadsheets" and saw no option for direct import from computer.
Thank You in advance for any guidance.
Hi there,
Thank you for your purchase.
Sorry for inconvenience,
In our plugin you have two options:
1) Creating tables linked to existing data source, in which case you will upload the file and initialize the table, whereupon it will be read every time on page load. Then you can overwrite this file to update the data. Such tables won’t be editable within WordPress, and if they are larger than 3000-5000 rows, the page load and generation time will be slow.
2) Importing table data to WordPress. The initial data will be read and imported from the provided file or a Google Spreadsheet. You can select to skip certain columns, or add columns. You can edit both the structure and the data within the table at an any point later, but the table won’t be synced with the source file as is the case with the first option; e.g., if you change something in CSV or in source Google Spreadsheet, your wpDataTable data will stay the same because the data will be already imported to the database.
For both case we are using WordPress media library to import those files. At the moment we don't have functionality that you can import directly from your computer in wpdatatables. (importing is over WordPress media library).
There are a difference in functionality in all table plugins, and we are always listening request from our customers what they need and based o that we made priorities. This functionality is not something that is requested from them so far.
We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time, so we will add to our idea list and look into some possible solutions on plugin side in the future.
We constantly strive to make our product better, and deliver the most value for our end users - so please share your feedback on what features you need in next versions or vote for existing ones on this
link https://wpdatatables.com/documentation/feature-suggestion/.
If you have any other question or issue please contact us on our support platform https://tmsplugins.ticksy.com/ and our support agents will help you out.
Best regards.
Thank You for the response - I understand what you are saying on the options of how to use. I truly hope you put "upload directly from computer" on your roadmap to accomplish. It may not seem like a big deal to other people as they might go ahead and follow how you would like them to use your plugin, but for me I don't always want to upload everything to WordPress Media Library.
Now if I am going to continuing using wpDataTables I have to figure out how I am going to get the data in there - without uploading files to media library - which either means using manual method or taking our excel files and creating google spreadsheets and maybe trying that method....whatever method it is, there is extra long work involved, which could be eliminated if we have a "upload directly from computer" method.
I hope you can see my viewpoint as a customer using your product.
Thank You for your time in answering my concerns/question.
Hi there,
Yes we listen every customer opinion and suggestion and then make a list and priorities based of number of requests. This we will definitely consider for implementation in the future.
In meanwhile if you have a lot of CSV files on your computer my suggestion is to import it in your database and then make very simple SQL query. Here you can read more about Creating MySQL-based tables with server-side processing - https://wpdatatables.com/documentation/creating-wpdatatables/creating-mysql-based-wpdatatables-with-server-side-processing/
First you will need to import that CSV in database and it is not so hard and it will not take much of your time to do that. There is a lot of instructions on net and this is one of them https://stackoverflow.com/questions/23815741/import-csv-file-into-mysql-using-phpmyadmin
If you explore little more about SQL queries you will see how is powerful and how you can manipulate with data only with one table.
Best regards.