I am encountering an issue where wpDataTables is misinterpreting the decimal separator in your CSV file, leading to incorrect data representation in your WordPress table.
I have csv file with floating numbers using dots to separate decimal numbers like that: 184.40. Then when creating and adjusting a table in wpdatatables, if you select floating number type in a column and 2 decimal places, I end up with a number in table like: 1844.00 . Clearly ether I do not know how to get the plugin to recognize dots rather then comma in csv file or maybe you know how to help me with it so that numbers taken from csv file are correctly recognized.
Where to check the settings in wpDataTables to see if there is an option to set the decimal separator explicitly? If the plugin is set to expect a comma as a decimal separator, it will misinterpret dots, leading to the issue you described.
It must be an abvious issue however I am strugling to find settings for that.
I am encountering an issue where wpDataTables is misinterpreting the decimal separator in your CSV file, leading to incorrect data representation in your WordPress table.
I have csv file with floating numbers using dots to separate decimal numbers like that: 184.40. Then when creating and adjusting a table in wpdatatables, if you select floating number type in a column and 2 decimal places, I end up with a number in table like: 1844.00 . Clearly ether I do not know how to get the plugin to recognize dots rather then comma in csv file or maybe you know how to help me with it so that numbers taken from csv file are correctly recognized.
Where to check the settings in wpDataTables to see if there is an option to set the decimal separator explicitly? If the plugin is set to expect a comma as a decimal separator, it will misinterpret dots, leading to the issue you described.
It must be an abvious issue however I am strugling to find settings for that.
I found similar ticket that refers to a solution here : https://tmsplugins.ticksy.com/ticket/3643956/
However seems there is no content under this link
Fixed it: "change the Number Format in the Main Plugin settings, save changes, then refresh your table and check it that fixes the issue"
Attached files: Screenshot from 2024-05-20 11-34-40.png
Thank you for letting us know that the issue was resolved, Kamil.
Please feel free to reach out to us if you have any further questions or concerns!
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