As previously announced via banners and our newsletters, support is no longer available through this platform.
For easier navigation, you can still click on "Submit a Ticket" here, choose the appropriate category, and you'll be redirected to the correct support channel for your plugin.
You can still access your previous tickets and browse public tickets, but please note that responding to tickets is no longer possible.
Paid customers: Please log in to your store account for support.
Pre-purchase questions: Use the support widget in the bottom-right corner of our websites:
https://wpamelia.com
https://wpdatatables.com
https://wpreportbuilder.com
Formatting when importing from Excel is not respected by Datatables and some kind of conversion takes place.
See screenshot
No problems when I define columns as "Strings" but then I cannot use this in the charts. Example of this on screenshot where it looks as you multiply with 100. This when defined as float or integer.
What to do?
Kind regards
Lars Pehrsson
Hi, Lars.
Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.
-
1. Can you first please check if you selected the right Number Format,
in the main plugin settings?
It needs to match the same number format and number of decimals as from the source Data.
2. If that does not help, we currently have an issue that happens only in Manual tables ( same as for imported tables);
Our developers confirmed they are aware of it, they will work on improving this in the future.
By default, all float columns for Manual Tables will initially be created in the database with 4 decimals.
I can't say an ETA when it will be improved,
but you follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;
and our newsletter, so you're informed about new features, bug fixes, freebies, etc.
-
For the time being, we have two possible workaround solutions when we need a higher number of decimal places:
1. If you want to get it working as Float Type, with proper numeric sorting,
you can change the column setting directly in your database for the table.
Here is my example via PhPMyAdmin with screenshots for setting 6 decimal places.
( My apology if you already know how to do this, i will share it just to be safe)
First, we check what is the SQL table name, in the Editing tab:
-
Then we find the table in PhPMyAdmin and edit the column(s) we need to have 6 decimals :
-
Change the Length/Values for the Float Column from initial "16,4" to the decimal number you need;
in this case "16,6" - that will allow you to get 6 decimals without issues.
-
Once you go back to the table in our plugin, you will be able to have 6 decimals in this column for new rows.
-
2.
Or you can set up a new column as String type, it will also work that way to display the value,
but then you won't get proper numeric sorting.
Let me know if that makes sense and if you have any questions. 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