We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
Hello,
I have a problem with importing data table from excel.(cell contains Valuta in €)
When I import a table from Excel to create a table with prices in Euro (like € 100) the Euro sign € in WP data tables creates €/ (adds an / after the €).
I tried with other Valuta currencies like USdollar or pound and that gives no problem, only with EUR and €.
I did not have this problem with the free version of WP datatables.
https://www.bmair.nl/wp/trip/bangkok-koh-samui-tour/
(click tab PRIJSTABEL to see the table on our website)
How can I make this work again, (I already checked in the cell content suffix nothing there (there is no /). Also I don't want to use the pefix set as an € and then import from excel as a number, this works but then I need to change every colum etc., so I don't want to make use of the prefix function)
Hope you can help me solve this problem,
Thanks + brgds,
Ron Verbon
Hello Ron.
I don't know why this happens until I take a look at the file. Would you be able to send me that Excel file (just zip it and attach it to your response)?
If it contains some sensitive data, please make sure to enable the Private response.
My advice would be to remove the € sign, and use the column prefix. You can easily find & replace "€ " (euro sign followed by a space) with an empty value "", and it would remove the sign (and the space after it), and store the column as integer (or float):
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 Aleksandar,
Thank you for your reply.
Hereby the excel-file in .zip format it's just a test file.
However I need to import hundreds of tables later from excel, that's why I want to find out what is wrong. I don't want to change all the € (Euro) signs, also when I use the function of Master Detail tables, the Euro sign will not show if I use only numbers in Excel (that's also a reason I don't want to use the prefix / suffix).
I also have another question.
Is it also possible to automatically find the lowest price in a WPData Table and then show the lowest price somewhere separate from the table (like a placeholder) in a page (without using the Master Detail page, because this only refers to one page)
We use the latest version of Office 365 with Excel.
Brgds,
Ron
Hello again Ron
I believe the issue lies somewhere in the formatting.
When I copy the contents of your file into a new spreadsheet, and add the currency symbol, and format the date as 31.12.1999 it works normally:
Can you try with the attached file, and see if it will work normally?
As for the lowest price - that is possible, but only if you add the columns as integers or floats. Then, when you go to column settings/Data tab, you will see calculation options MIN, MAX, AVG and SUM which have their own shortcodes you can place somewhere outside the table. It will not work for strings, though.
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
Hello Aleksander,
Thanks for your solution.
Changing the € type in Excel into "€ "#.##0 works ok now.
Also the lowest price.
Thanks + brgds,
Ron
Great news, Ron
Thanks for letting me know.
If you have any further questions or issues, please feel free to open a new ticket, and we'll gladly help.
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