I'm having some trouble with the number format in our charts and tables. The number format is changed on the settings of the plugin as shown on the picture attached (1).
The tables format number are 5.000,00 as shown on the picture (2), but when we upload the data to the table, the format doesn't match, and it shows 5,000.00 as shown on picture 3 and 3.1. Can you please help us to fix this? Thank you in advance! Have a nice day!
After further investigation we found out that 3rd party software that is responsible for export tables in Excel does not support European number format. It only works if number contains both dot and comma in Excel. Here is the reference.
My suggestion is to use CSV as an export or to make those columns as a string.
I export the excel file to a .csv as you told me, and I watched the video on the DOcumentation buttom (https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-csv/) and I'm following exactly the same steps. The thing is that in the video, after uploading the csv, the table is separated in columns after the , but in my case, it stays in only one column.
I'm sorry, I'm not a programer, but I'm doing my best to make the graphics page working for my company.
How can I make the CSV become a table with different columns? Here is the result I have in the attachment so you can see how the data is uploaded.
I even downloaded the sublime text as it is shown on the video but not even that is working.
I Really need some patience and help. Thank you in advance,
It seems that the CSV separator you have is a semi-colon ( ; ), not a comma ( , ), so all you need to do is go to wpDataTables settings, and change it to a semi-colon:
Save the settings, and import the file again. It should be working fine after that.
Hi!
I'm having some trouble with the number format in our charts and tables.
The number format is changed on the settings of the plugin as shown on the picture attached (1).
The tables format number are 5.000,00 as shown on the picture (2), but when we upload the data to the table, the format doesn't match, and it shows 5,000.00 as shown on picture 3 and 3.1. Can you please help us to fix this? Thank you in advance! Have a nice day!
Hello Marina
Thank you for your purchase.
After further investigation we found out that 3rd party software that is responsible for export tables in Excel does not support European number format. It only works if number contains both dot and comma in Excel. Here is the reference.
My suggestion is to use CSV as an export or to make those columns as a string.
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
Hi again Marina
The 3rd party software we use doesn't support that format.
So, you should either use the US format, or export the Excel file into CSV, and then use that file to create a table in wpDataTables.
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
Thank you alexandar. I'll try it that way.
Have a nice day.
Hi Aleksandar
So I did what you suggested. But it didn't work.
I export the excel file to a .csv as you told me, and I watched the video on the DOcumentation buttom (https://wpdatatables.com/documentation/creating-wpdatatables/creating-wpdatatables-from-csv/) and I'm following exactly the same steps. The thing is that in the video, after uploading the csv, the table is separated in columns after the , but in my case, it stays in only one column.
I'm sorry, I'm not a programer, but I'm doing my best to make the graphics page working for my company.
How can I make the CSV become a table with different columns? Here is the result I have in the attachment so you can see how the data is uploaded.
I even downloaded the sublime text as it is shown on the video but not even that is working.
I Really need some patience and help. Thank you in advance,
Have a nice day.
Hello Marina
It seems that the CSV separator you have is a semi-colon ( ; ), not a comma ( , ), so all you need to do is go to wpDataTables settings, and change it to a semi-colon:
Save the settings, and import the file again. It should be working fine after that.
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