Hey there, Awesome Customers!
Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.
During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.
We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!
In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.
Thanks a bunch for your understanding and support!
Catch you on the flip side!
Warm regards,
TMS
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