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?

Hi Aleksandar,

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?

Hi Aleksandar,

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. :)

Thanks,
Lori

Aleksandar,

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.

Aleksandar,

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)?

Thanks,
Lori