1) I'm using wpdatatables to query and edit tables in MYSQL. Since MYSQL only accepts dates in the YYYY-MM-DD format, I find it puzzling why this format is not in the drop-down of date display choices for wpdatatables. The result is that when filtering the data, the correct rows only appear when entered in the YYYY-MM-DD format, despite being displayed in one of the other formats offered by wpdatatables.
2) For many simple queries (select * from table) Excel-like tables often show no data while the standard view works fine. When the Excel-like tables do show data, it does not fit on a single page, unlike the standard view. Setting scrollable both on or off doesn't help. I can squish the column contents by selecting off on scrollbar and on for limit table width, but then the columns are too narrow to see the entries. The Excel-like tables overflow out of the page frame in both the vertical and horizontal directions.
We made some changes in the 2.2 version to work with large amount of data. if you have data that is confidential can you please tell me do you maybe have some test environment with the 2.2 version so I can take a look about that circular arrows.
I just downloaded the new version (2.2?) and the circular arrows are gone. The formatting issues and blank table problem are still there for the Excel view. I can get rid of the blank table problem by limiting the size of my search to a few rows, but I don't want to do that. It would be tough to set up a test environment. I could do it if it's really needed.
Thanks, I see that "pagination" and "scrollable table" are "not yet supported." But I don't see why they are not supported yet. How useful is a giant excel table w/o pagination or being scrollable? I just downloaded today's update. Still no support for the MYSQL standard YYYY-MM-DD format and the problem of displaying no data for a large table in the Excel view is still there, which I guess is the not supported for "server-side processing/very large tables". One of my tables which doesn't show up in the Excel view is only 6000 rows, which I would not classify as "very large."
The engine that Excel like tables are using (Handsontable engine) are not easy to implement and to be compatible with DataTables engine so everything will run smoothly like in Standard table view.
We are looking to add this functionalities for next versions of our plugin as long as the format of the date ( which is already on our TODO list)
I'm using version 4.9.5. I have two issues :
1) I'm using wpdatatables to query and edit tables in MYSQL. Since MYSQL only accepts dates in the YYYY-MM-DD format, I find it puzzling why this format is not in the drop-down of date display choices for wpdatatables. The result is that when filtering the data, the correct rows only appear when entered in the YYYY-MM-DD format, despite being displayed in one of the other formats offered by wpdatatables.
2) For many simple queries (select * from table) Excel-like tables often show no data while the standard view works fine. When the Excel-like tables do show data, it does not fit on a single page, unlike the standard view. Setting scrollable both on or off doesn't help. I can squish the column contents by selecting off on scrollbar and on for limit table width, but then the columns are too narrow to see the entries. The Excel-like tables overflow out of the page frame in both the vertical and horizontal directions.
Hi Ned,
1)
Do you have any example of this table and query so I can take a look.
2)
You ca take a look at our documentation where you can see differences and possible feature for Standard and Excel like tables.
Best regards.
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
HI Ned,
We made some changes in the 2.2 version to work with large amount of data. if you have data that is confidential can you please tell me do you maybe have some test environment with the 2.2 version so I can take a look about that circular arrows.
Best regards.
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
I just downloaded the new version (2.2?) and the circular arrows are gone. The formatting issues and blank table problem are still there for the Excel view. I can get rid of the blank table problem by limiting the size of my search to a few rows, but I don't want to do that. It would be tough to set up a test environment. I could do it if it's really needed.
Also, still don't see a YYYY-MM-dd date format, which is the native format used by MySQL.
Hi Ned,
1. The formatting issues and blank table problem are still there for the Excel view
Can you please send me the screenshot of this so I can take a look.
2. YYYY-MM-dd format as you can see is not supported at the moment
The list of available date formats is on the attachment below.
We are looking to add YYYY-MM-dd date format for our next versions of the plugin.
Best regards.
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
Hi Ned,
Can you please tell me did you take a look at this documentation about the difference between standard and excel like tables.
Best regards.
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
Thanks, I see that "pagination" and "scrollable table" are "not yet supported." But I don't see why they are not supported yet. How useful is a giant excel table w/o pagination or being scrollable? I just downloaded today's update. Still no support for the MYSQL standard YYYY-MM-DD format and the problem of displaying no data for a large table in the Excel view is still there, which I guess is the not supported for "server-side processing/very large tables". One of my tables which doesn't show up in the Excel view is only 6000 rows, which I would not classify as "very large."
HI Ned,
The engine that Excel like tables are using (Handsontable engine) are not easy to implement and to be compatible with DataTables engine so everything will run smoothly like in Standard table view.
We are looking to add this functionalities for next versions of our plugin as long as the format of the date ( which is already on our TODO list)
Best regards.
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