I have tables with between 6,000 and 7,000 rows. The exact number of rows will fluctuate over time.
I'm using the excel-like editor to update them, by pasting in new data. Normally I have to update multiple columns for all rows.
But this method only seems to update the first few hundred rows. Testing it, it only updates about 400 rows, even though I paste in several thousands of rows. After the first few hundred, the update just seems to stop.
I've tried pasting in 400 rows at a time. This works, but it's really tedious and time-consuming, especially if a table has to be updated frequently.
What would cause a problem like this? How can it be fixed, so that thousands of rows can be updating by pasting into the excel-like editor?
If this is a bug, is there another way to mass-update a large table?
FYI, it's version 1.7.2 of the plugin and I initially used a CSV file to create the table in MySQL with server-side processing.
I want to add that it creates the 'appearance' of the new data being pasted in. Looking at the excel-like editor after pasting, it seems to have accepted the new data.
But when I check the table on the front end after that, the updated data isn't there.
wp-content/plugins/wpdatatables/assets/js/handsontable/handsontable.full.js and around line 6045 find this line of code
copyRowsLimit: 1000,
and change the number 1000 to your desire. After that turn off Use minified wpDataTables Javascript option from the wpdatatables settings page.
Please be aware that memory limit is set because of the performance issues so if you set that number significantly higher that can impact the performance of the website.
This worked the first time, but it's not working now. I changed the 1000 to the larger figure, and changed the minified javascrift setting, and haven't changed them back.
After it worked the first time, I thought it was settled, but it doesn't work anymore.
The only thing I thought might be affecting it, is a cache/minify plugin I'm using.
I've tried disabling that on the wp-admin page but the problem was still there. I also tried disabling that plugin entirely, but that didn't change anything. Pasting in an updated data set still only updates the first few hundred rows. This time it worked for about 600 rows before stopping.
I can give you admin rights if you'd like to go in and have a look. I can also send an updated data set example, for what should be pasted in there.
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID and if you can give me some guide what to copy paste so I can try to recreate the issue.
Hi,
I have tables with between 6,000 and 7,000 rows. The exact number of rows will fluctuate over time.
I'm using the excel-like editor to update them, by pasting in new data. Normally I have to update multiple columns for all rows.
But this method only seems to update the first few hundred rows. Testing it, it only updates about 400 rows, even though I paste in several thousands of rows. After the first few hundred, the update just seems to stop.
I've tried pasting in 400 rows at a time. This works, but it's really tedious and time-consuming, especially if a table has to be updated frequently.
What would cause a problem like this? How can it be fixed, so that thousands of rows can be updating by pasting into the excel-like editor?
If this is a bug, is there another way to mass-update a large table?
FYI, it's version 1.7.2 of the plugin and I initially used a CSV file to create the table in MySQL with server-side processing.
Thanks and regards.
I want to add that it creates the 'appearance' of the new data being pasted in. Looking at the excel-like editor after pasting, it seems to have accepted the new data.
But when I check the table on the front end after that, the updated data isn't there.
It's the same problem on version 2.0.2
Hi Aidan,
Thank you for your purchase.
In case like this my suggestion is to go in file
wp-content/plugins/wpdatatables/assets/js/handsontable/handsontable.full.js and around line 6045 find this line of code
and change the number 1000 to your desire.
After that turn off Use minified wpDataTables Javascript option from the wpdatatables settings page.
Please be aware that memory limit is set because of the performance issues so if you set that number significantly higher that can impact the performance of the website.
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,
This worked the first time, but it's not working now. I changed the 1000 to the larger figure, and changed the minified javascrift setting, and haven't changed them back.
After it worked the first time, I thought it was settled, but it doesn't work anymore.
What would cause this?
Regards
Hi Aidan,
Very strange.
Can you please tell me did you do some updates of the plugin or something else that might cause this issue.
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
The only thing I thought might be affecting it, is a cache/minify plugin I'm using.
I've tried disabling that on the wp-admin page but the problem was still there. I also tried disabling that plugin entirely, but that didn't change anything. Pasting in an updated data set still only updates the first few hundred rows. This time it worked for about 600 rows before stopping.
I can give you admin rights if you'd like to go in and have a look. I can also send an updated data set example, for what should be pasted in there.
Hi Aidan,
Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.
Also point me to the table ID and if you can give me some guide what to copy paste so I can try to recreate the issue.
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 Aidan,
Unfortunately there are some limitations.
All online tools are generally not designed for just copying and pasting and dealing with such amount of data.
We strongly suggest in case like this to use some import functionalities rather than copy and paste option.
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
Thank you for having a look. I'll remove the temporary admin access now.
Can you recommend any import method/plugin in particular? Alternatively is there a method/plugin that you don't recommend?
Thanks and regards.
Hi Aidan,
When you are dealing with the large data our suggestion is to make a table based on MySQL.
Make that large file and Import it in your database.
You can find some more useful hints in our documentation.
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