I'm highly disappointed, the feature caused me to buy this plugin just doesn't work: "Create a data table linked to an existing data source" (see image 1).
CSV data source should be the most basic data source you can get, right? Amounts are handled as "float", so they all get a decimal (xx,00) and period (.) thousand separator (see image 2). In this example, first amount should be 236,81 but is shown as 23.681,00...
BTW, the same it's happening using excel dataset, so it's no just csv...
It isn't happening when a I use the option "Create a data table by importing data from a data source", manual work, create a new "Manual" table each time, that I would like to avoid, that's why I bough this plugin.
Now the workaround is crazier than the case I should avoid, use Power Query to first handle a CSV dataset so to transform amounts into "Whole Number".
I hoop you could do something about it, or just remove that option, it doesn't work!
Hi,
I'm highly disappointed, the feature caused me to buy this plugin just doesn't work: "Create a data table linked to an existing data source" (see image 1).
CSV data source should be the most basic data source you can get, right? Amounts are handled as "float", so they all get a decimal (xx,00) and period (.) thousand separator (see image 2). In this example, first amount should be 236,81 but is shown as 23.681,00...
BTW, the same it's happening using excel dataset, so it's no just csv...
It isn't happening when a I use the option "Create a data table by importing data from a data source", manual work, create a new "Manual" table each time, that I would like to avoid, that's why I bough this plugin.
Now the workaround is crazier than the case I should avoid, use Power Query to first handle a CSV dataset so to transform amounts into "Whole Number".
I hoop you could do something about it, or just remove that option, it doesn't work!
Grtz,
Attached files: 1.jpg
2.jpg
Hi, Kelvin.
Sorry for the delay.
Can you please go to the main plugin settings/Number Format,
and change the number format of the plugin, then Save Changes?
Also make sure to have the right number of decimals selected in the main plugin settings.
Let me know if that fixes the issue with the correct float and decimal places.
Thank you.
Kind Regards,
Miloš Jovanović
[email protected]
Rate my support
Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/
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
Great, it solved the issue!