Table import from excel works in demo sandbox version but not my purchased plugin version. Copied screenshot of working demo side by side with error message from purchased version below. Please advise.
Ok thank you! Hopefully this works - please let me know if not. Also, this will be a working spreadsheet that I will be updating and reloading - this is a draft with just a small amount of data that I hope to have in it (much more to add I mean).
Which version of wpDataTables do you have installed? If you're not on v3.0.3, please update it and try again.
If that fails also, I'll need to take a look at your website.
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.
1. No formatting can be transferred from Excel to wpDataTables, so the plugin stores what it sees, not the link behind it. You have two options, but they both involve editing the Excel file:
And save the column in wpDataTables as a regular string column.
2. I believe you're referring to a select-box filter. Please check it out.
3. If you set the table to be limited to page's width, it will be shrunk to the width of the element it resides in. You can disable "Limit table width", and enable "Scrollable" option, and that will expand the table, but in this case it can go outside page's borders, so people would need to scroll through it horizontally.
Hello! Thank you so much for this information! I was able to implement number 2 - thank you for that link! Also - thank you for the answer in No.1 - I had implemented a work around for it and am glad to know this as a solution as an option. I appreciate all your help and patience. I think that is all of my questions of a technical nature right now. Will that cause this ticket to close then? I'm guessing if something else arises I can submit a new one? I will answer on the other ticket regarding the other issue. Thank you again for your expertise - stay safe and well - peace always.
Sure, if this topic is closed, the ticket will close itself after a week of no replies. If you need any further assistance with something else, just open a new ticket.
Hey there! So sorry to bother so soon. It appears after loading in more data - I can't get the sort boxes to filter. I'm uncertain what has changed. I was trying to filter to Middle school on the Grade Range box. At one point I did get it to filter by subject but that appears to be hit or miss. I select the keyword in the sort box - but the box stays blank and the filter doesn't happen. I don't know what has changed unless it is because I added more data? I have much more to add so am a little concerned if that is it. Is there a limit on how many rows you can have in a table? If so - is there a way to get more? I've copied the link here: http://www.wvallstar.org/learning-resource-guide/
Thank you for any guidance you can provide! Stay safe and well.
Thank you for your reply! So when I go to the website on my phone, my computer or my daughter’s computer, it lets me select the drop down keyword, but it neither shows up in the box or filters to that selection. It basically acts like I never selected it. I just refreshed it and tried again and it did the same. I’m not sure what I’ve done to mess it up - it was working last week. Over the weekend I tried going back and using the spreadsheet version that was working instead (lesser number of rows) but it did the same thing as the new version. Thank you for your continued help!!
Good Morning! Thank you for your help! I just checked the main settings on the plugin and there is a blue checkmark on the "include bootstrap on front end" so I'm guessing it is still on. I appreciate your help! I'm trying to roll this out this week but am holding off until this option is working. Please let me know what else I can provide if it will help. I'm sorry for the bother! Stay safe
One quick other thing to mention. Per another ticket with Aleksandar- because we are a nonprofit- I canceled our basic upgrade and then repurchased this plugin with a discount last Thursday. Everything was working prior to that and then stopped on Friday. That could be a coincidence but I thought I would mention it in case it could be a factor. I purchased the same package with the coupon and did the canceling the old one and repurchasing within minutes of each other. Thank you!
I apologize for this but I’m starting to get frustrated with this response - your screenshot does not show the filters working and even though I can see you aren’t getting the correct result - I tried what you suggested and it still does not work. If it did - as it was working before, the keyword you would select would show up in the box and the data would be narrowed down. This is not working on multiple devices and indicates the cache is not the issue. I cleared mine anyway and it is doing the same problem as before. Also, the work I’m doing is time sensitive and waiting for a response for 24 hours is not helpful - especially when there does not seem to be an understanding of the issue that I’m having. Here is what I get when I filter for Middle School: it lets me select the keyword (picture 1), never shows it in the box (picture 2)(which it used to), and then never actively filters it to Middle School (picture 3). I need this resolved quickly please - like today.Thank you.
In first response I mean that you have issue with loading filters not their functionality. Sorry about that.
Yes you are right this filter is not working and all other filters that have special characters like (,),-,%...
That is the bug with non server side tables and our dev team will fix it in one of the next updates. It is not a easy to solve because there are a lot of combinations and functionality that goes throw filters, so we will need a lot of testing to cover all the cases.
For now my suggestion is to create new table with third option in table wizard with which you will create server-side table where filters are working fine with special characters.
Thank you for your quick response. I’m sorry but I don’t understand what “create new table with third option in table wizard with which you will create server-side table where filters are working fine with special characters” means?
What is the third option in table wizard?
How do I create a server side table?
Any further explanation would help - I apologize I’m not a programmer by nature. Thank you for your help!
Also - do the underlines and forward slashes count as special characters?
I’m sorry to post again but I think after thinking for a few minutes I know what you meant. You are suggesting I build the table in wpDataTables rather than importing from Excel if I want to use special characters at this time -is that right?
There are reasons I need to build this as an Excel table and would like to edit/update only one table to reduce errors between using two tables. However, I can explore some workarounds on my Excel table to eliminate special characters for the import to wpDataTables if that would be another fix. I just need to make sure I understand what is not considered a special character in your plugin. Thank you for your patience with me!!
No problem, then you need to avoid those special characters in Excel file:
( , ) , ?, %, \ ,^, *, [
After investigation, we found issues for those, but there are a lot of other special characters that need to be tested but this is the common one that break filter.
Thank you!!! I will get to work removing those then and try again. Will be back in touch if other issues - including an update if it all works too. Thank you for your help - it was timely too - just talked with an end user who is going to be using it. Stay safe
If you have any other issue or question please open new ticket, and we help you out.
I’d like to ask you a favor. Would you mind taking a few minutes to write a review for us, please on this link?
Our free version is the only place where we can have proof for our hard work; your comments are beneficial for others to know what to expect when they’re looking for our plugin.
Thank you in advance. It means a lot to us, and I am looking forward to reading your comment.
Thank you! I tried registering a new account yesterday and was met with all kind of denials on username and such - don’t know why (most likely me!). This link worked today - thank you for that - and I’ve left a review- hopefully it helps! Thank you for all of your help! Stay safe and well.
Table import from excel works in demo sandbox version but not my purchased plugin version. Copied screenshot of working demo side by side with error message from purchased version below. Please advise.
F
Hello Deana
Thank you for your purchase.
Unfortunately I don't see any screenshots.
Can you please send me that file, so I can take a look?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
how do I send you the file?
did you mean the error file or my excel spreadsheet I’m trying to load in?
Hi Deana
I mean your Excel spreadsheet.
You can zip it and add it as an attachment to this ticket.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Ok thank you! Hopefully this works - please let me know if not. Also, this will be a working spreadsheet that I will be updating and reloading - this is a draft with just a small amount of data that I hope to have in it (much more to add I mean).
Hello again Deana
I have no issues whatsoever using this document:
Which version of wpDataTables do you have installed? If you're not on v3.0.3, please update it and try again.
If that fails also, I'll need to take a look at your website.
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.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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 again Deana
Here's your issue: Fatal error: Uncaught Error: Class 'ZipArchive' not found
You need to contact your hosting provider, and ask them to install the ZipArchive on the server.
After they do that, you should have no issues creating tables from imported files.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
You're welcome, Deana
I'm glad to hear the issue is resolved.
1. No formatting can be transferred from Excel to wpDataTables, so the plugin stores what it sees, not the link behind it. You have two options, but they both involve editing the Excel file:
That way (notice || in there), when you add this column as URL Link column, you will see only hyperlinked Google.
And save the column in wpDataTables as a regular string column.
2. I believe you're referring to a select-box filter. Please check it out.
3. If you set the table to be limited to page's width, it will be shrunk to the width of the element it resides in. You can disable "Limit table width", and enable "Scrollable" option, and that will expand the table, but in this case it can go outside page's borders, so people would need to scroll through it horizontally.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Hello! Thank you so much for this information! I was able to implement number 2 - thank you for that link! Also - thank you for the answer in No.1 - I had implemented a work around for it and am glad to know this as a solution as an option. I appreciate all your help and patience. I think that is all of my questions of a technical nature right now. Will that cause this ticket to close then? I'm guessing if something else arises I can submit a new one? I will answer on the other ticket regarding the other issue. Thank you again for your expertise - stay safe and well - peace always.
You're welcome, Deana
Glad I could be of service.
Sure, if this topic is closed, the ticket will close itself after a week of no replies. If you need any further assistance with something else, just open a new ticket.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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! Stay safe and well!
You're welcome, Deana
Thank you, you too!
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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
Hey there! So sorry to bother so soon. It appears after loading in more data - I can't get the sort boxes to filter. I'm uncertain what has changed. I was trying to filter to Middle school on the Grade Range box. At one point I did get it to filter by subject but that appears to be hit or miss. I select the keyword in the sort box - but the box stays blank and the filter doesn't happen. I don't know what has changed unless it is because I added more data? I have much more to add so am a little concerned if that is it. Is there a limit on how many rows you can have in a table? If so - is there a way to get more? I've copied the link here: http://www.wvallstar.org/learning-resource-guide/
Thank you for any guidance you can provide! Stay safe and well.
Hi again Deana
I'm not sure I understand what the issue here is. As far as I can see, the filters on that page are working just fine:
Can you explain what's wrong in a bit more detail?
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
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 your reply! So when I go to the website on my phone, my computer or my daughter’s computer, it lets me select the drop down keyword, but it neither shows up in the box or filters to that selection. It basically acts like I never selected it. I just refreshed it and tried again and it did the same. I’m not sure what I’ve done to mess it up - it was working last week. Over the weekend I tried going back and using the spreadsheet version that was working instead (lesser number of rows) but it did the same thing as the new version. Thank you for your continued help!!
Hi Deana
Aleksandar is assign on our other products this week, so I will help you out.
Can you please tell me did you turn off option Include bootstrap on front-end in Main settings of plugin?
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Good Morning! Thank you for your help! I just checked the main settings on the plugin and there is a blue checkmark on the "include bootstrap on front end" so I'm guessing it is still on. I appreciate your help! I'm trying to roll this out this week but am holding off until this option is working. Please let me know what else I can provide if it will help. I'm sorry for the bother! Stay safe
One quick other thing to mention. Per another ticket with Aleksandar- because we are a nonprofit- I canceled our basic upgrade and then repurchased this plugin with a discount last Thursday. Everything was working prior to that and then stopped on Friday. That could be a coincidence but I thought I would mention it in case it could be a factor. I purchased the same package with the coupon and did the canceling the old one and repurchasing within minutes of each other. Thank you!
I apologize for this but I’m starting to get frustrated with this response - your screenshot does not show the filters working and even though I can see you aren’t getting the correct result - I tried what you suggested and it still does not work. If it did - as it was working before, the keyword you would select would show up in the box and the data would be narrowed down. This is not working on multiple devices and indicates the cache is not the issue. I cleared mine anyway and it is doing the same problem as before. Also, the work I’m doing is time sensitive and waiting for a response for 24 hours is not helpful - especially when there does not seem to be an understanding of the issue that I’m having. Here is what I get when I filter for Middle School: it lets me select the keyword (picture 1), never shows it in the box (picture 2)(which it used to), and then never actively filters it to Middle School (picture 3). I need this resolved quickly please - like today.Thank you.
here is the correct picture 1 which shows the selection of Middle school not sure what happened to the 1st picture attached in the last email
Hi Deana,
Sorry for misunderstanding,
In first response I mean that you have issue with loading filters not their functionality. Sorry about that.
Yes you are right this filter is not working and all other filters that have special characters like (,),-,%...
That is the bug with non server side tables and our dev team will fix it in one of the next updates. It is not a easy to solve because there are a lot of combinations and functionality that goes throw filters, so we will need a lot of testing to cover all the cases.
For now my suggestion is to create new table with third option in table wizard with which you will create server-side table where filters are working fine with special characters.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Thank you for your quick response. I’m sorry but I don’t understand what “create new table with third option in table wizard with which you will create server-side table where filters are working fine with special characters” means?
What is the third option in table wizard?
How do I create a server side table?
Any further explanation would help - I apologize I’m not a programmer by nature. Thank you for your help!
Also - do the underlines and forward slashes count as special characters?
Thank you again!
I’m sorry to post again but I think after thinking for a few minutes I know what you meant. You are suggesting I build the table in wpDataTables rather than importing from Excel if I want to use special characters at this time -is that right?
There are reasons I need to build this as an Excel table and would like to edit/update only one table to reduce errors between using two tables. However, I can explore some workarounds on my Excel table to eliminate special characters for the import to wpDataTables if that would be another fix. I just need to make sure I understand what is not considered a special character in your plugin. Thank you for your patience with me!!
Hi Deana,
Yes I mean exactly on that.
No problem, then you need to avoid those special characters in Excel file:
( , ) , ?, %, \ ,^, *, [
After investigation, we found issues for those, but there are a lot of other special characters that need to be tested but this is the common one that break filter.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Thank you!!! I will get to work removing those then and try again. Will be back in touch if other issues - including an update if it all works too. Thank you for your help - it was timely too - just talked with an end user who is going to be using it. Stay safe
Hi Deana,
You are welcome.
If you have any other issues or question, please open the new ticket, and we will help you out.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Thank you so much for your help! I removed the special characters and everything is working now. Stay safe and well!
Hi Deana,
You are welcome.
If you have any other issue or question please open new ticket, and we help you out.
I’d like to ask you a favor. Would you mind taking a few minutes to write a review for us, please on this link?
Our free version is the only place where we can have proof for our hard work; your comments are beneficial for others to know what to expect when they’re looking for our plugin.
Thank you in advance. It means a lot to us, and I am looking forward to reading your comment.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
Thank you! I tried registering a new account yesterday and was met with all kind of denials on username and such - don’t know why (most likely me!). This link worked today - thank you for that - and I’ve left a review- hopefully it helps! Thank you for all of your help! Stay safe and well.
Hi Deana,
You are welcome.
Thank you so much for the great review.
It means us a lot.
Have a nice weekend.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables