Hello Josh

Thank you for your purchase, and sorry for the inconvenience.

Please note that tables linked to an existing data source (Excel, CSV, Google Spreadsheet, XML, PHP Array and JSON) are not editable. 

As for the issue with the browse button, it usually occurs when there is a conflict either with the theme currently active on your website, or another plugin you have installed.

Can you please change the theme and see if the issue is resolved? If not, then please deactivate all other plugins except for wpDataTables, refresh the page where the issue is, and see if it is resolved (it should be). If it is, then start activating other plugins one by one, and after each activation refresh the page to see if the issue reoccurred. Once it does reoccur, you will have found the plugin causing the issue.

If you're not able to locate the issue, 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.

Thanks, Josh

There's an issue with ace.js and I have forwarded the issue to one of our developers for testing. Please leave the log-in credentials active, so we can debug the issue.

Hi again Josh

To create tables from that spreadsheet, you will need to exclude the first two rows. The source table needs to have a basic structure: columns*rows. Additional rows above the table will cause the plugin not to render the table properly.

You can create new sheets in that Spreadsheet with the IMPORTRANGE function, where you would import the range of cells from original sheets. Any formatting applied to that sheet will not be carried over to wpDataTables, so once you get the data you want to display in a wpDataTable, you will also need to apply formatting to that table. When you update the spreadsheet, wpDataTable will be updated too, but keep in mind that there is cache on Google's side so it might take 5 - 15 minutes for the changes to be seen in our tables.

I have forwarded the "Browse" button issue to one of our developers, and I'll get back to you on that as soon as possible.

Sorry for the delay.

Hello again Josh.

When you click on browse, a WordPress function for media holder is being called, and it's using jQuery. Ok your website, the jQuery core file is being loaded after these files and that's why an error occurs.

By default, jQuery is loaded in the header, but on your website that is not the case. The issue could be coming from the currently active theme, or the plugin settings on your server.

When you inspect the page, you can see that the error doesn't come from any of our files, but in WordPress'.

There are some good articles on stackoverflow and other resources online on how you can include jQuery in the header.

I hope that helps

Hi again Josh

Sure, I'll do my best to help you out.

However, I'm out of office at the moment (we work from 10:00 - 17:00 CET, business days), so I can't remote in and take a look without my laptop.

When I do log in, first thing in the morning, do I have your permission to deactivate plugins and change the theme to troubleshoot the issue?

Hey Josh

Can you please provide me the host (URL) where I can log in with those credentials?

You're welcome Josh

Thanks for confirming.

If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.

Sorry Josh, I can't access the page with that password.

If I understood you correctly, you simply enabled Responsiveness, correct?

If that is true, you also need to choose which columns you want to hide on mobiles and/or tablets, and those columns will collapse under the first column.

Please take a look at our documentation about this to see how it's done.

Great news, Josh

Thanks for confirming.

If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.

Hi Josh

In wpDataTables settings, there's a slider "Prevent deleting tables from the database". If you enable that slider, your tables will be saved when you delete the current version of the Plugin.

Hello Josh

This is not possible with the plugin's built-in features, but one of our customers managed to achieve this. We did not have the time to test it, so you can try if it's working for you.

He actually created a fixed header and column using translation of x and y (no absolute or fixed position used), and here's his solution, take a look:

First of all, you gotta set the z-index for each component below:

jQuery("#table td").css({"z-index": "-1", "position": "relative"});  
jQuery("table tr td:first-child").css({'z-index': '1', 'position': 'relative'});
jQuery("table th:first-child").css({ 'z-index':'2','position':'relative'});

Then you gotta add listener on scroll like this:

jQuery('document').scroll(function () {
   scrollBlock();
});

If your table is set to be scrollable, then you might want to add this in as well:

jQuery('.wdtscroll').scroll(function () {
 scrollBlock();
});

And here's the scrollBlock() part, it is ugly though, but it works for me though. (noted: the numbers work for my theme, if it is not working correctly on yours, then try to adjust the number until it fits.)

function scrollBlock(){
                        var table = document.querySelector('table');
            var top = table.getBoundingClientRect().top;
            top = document.body.className.search('admin') > 0 ? top - 32 : top + 3; // this value can change
            var left = table.getBoundingClientRect().left;
            if(left >= 20){ // before scrolling left (before transforming)
                                if(top >= 0){ // before reaching header bar
                    jQuery("#table_1 thead th").css("transform", "translateY(0px)");
                     translate(jQuery("table th:nth-child(1)"), 0, 0);
                     translate(jQuery("table td:nth-child(1)"), 0, 0);
                                    } else{ // after reaching header bar
                     jQuery("#table_1 thead th").css("transform", "translateY( " + (-top) + "px)");
                     translate(jQuery("table th:nth-child(1)"), 0, -top);
                     translate(jQuery("table td:nth-child(1)"), 0, 0);
                 }
            } else{ // after scrolling left
                                if(top >= 0){
                    jQuery("#table_1 thead th").css("transform", "translateY(0px)");
                    translate(jQuery("table th:nth-child(1)"), -left + 46, 0);
                    translate(jQuery("table td:nth-child(1)"), -left + 46, 0);
                                    } else{
                     jQuery("#table_1 thead th").css("transform", "translateY( " + (-top) + "px)");
                     translate(jQuery("table th:nth-child(1)"), -left + 46, -top);
                     translate(jQuery("table td:nth-child(1)"), -left + 46, 0);
                     }
                }
            }
function translate(element, x, y) {
               var translation = "translate(" + x + "px," + y + "px)"
                element.css({
                        "transform": translation,
                                "-ms-transform": translation,
                                "-webkit-transform": translation,
                                "-o-transform": translation,
                                "-moz-transform": translation,
                });
}

It is kind of messy, you definitely can't copy and paste and expect it to work for you. You need to spend some time to figure it out. 

I hope that helps.

Hello Josh

For future reference:

When you have questions or issues which are not related to the title of the active ticket can you please open a new one, and we will help you there. In that way, issues and questions which are related to different subjects will be in different tickets so other customers or our support agents can find it easily. Our policy is to have one issue or question per ticket because of the reasons that is described already.

Thank you for understanding.

If that font is not available in wpDataTables settings, you would need to add it manually through a custom CSS.