I imported some data from an Excel spreadsheet and adjusted the float columns' number of decimal places to match what is in the spreadsheet (9). However, the wpDataTable does not seem to have any of the values past the first four after the decimal. For example, this is the number in the spreadsheet 0.072842098, but this is what it shows in the wpDataTable 0.072800000. How can I get it to show all of the numbers in places 5-9 after the decimal?
Instead of changing the number of decimal places in column settings, please go to wpDataTables settings, and increase the number of decimal places there.
When you do that, and import the spreadsheet again, it should load all decimals normally.
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs
You can try wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables
I did what you said (set decimal places to 9 in the general settings) and it would appear to work upon initial import, but after the final step, Create the Table, it goes back to 0000 for those last decimal places. It doesn't matter if you do standard view or Excel-like view. Anything else I can try?
Hello again Lori
Can you please send me the file you're trying to use?
Please note that this is a public ticket, so make sure to enable the PRIVATE response, so it's not visible by everyone.
Thank you for looking into the issue. Please let me know what your developers say. I don't know how to do the phpMyAdmin / SQL query part, so I might need to manually fix the data once imported. I have a bunch of these to do, but they have not been handed off to me yet and the project is due March 5th. Hopefully, this is the only table with that particular problem. Ah, life at the end of the production line. :)
Thank you so much for all of the instruction. I didn't realize about the missing header in that second file. One of our developers might be able to help me this afternoon with the imports, as we don't have phpMyAdmin on our server, but we have MySQLWorkbench.
Of note, when your developers look into this, it appears that many of these tables will have numbers with several places after the decimal point so I will definitely need to set the individual tables/columns with different settings for places after the decimal. However, even when I paste in the full set of numbers into wpDataTables, and then save, it still drops off anything after the first four decimals and changes them to zeros. The next iteration of this project will need to be done by people less tech savvy, so the SQL method will be out for them.
Thanks for the feedback, Lori, I will forward it to our developers.
They have it saved as a task for the next development phase, so hopefully this will be resolved relatively soon.
As this is my first exploration into wpDataCharts, I do have a few other observations, questions and possible bugs. How should I provide them to you? Here or in a separate ticket(s)?
Hi again Lori
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.