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
working on datatables right now. Uploading an excel or converting it to a csv messes all formatting up as far a number values are concerned. It will change "." to a comma, some values to random numbers, etc I have around 70 pages to do. I am attaching the excel file so you can see for yourself. Thank you
Hi joshuadbroadwater,
Thank you for your purchase.
Formatting from Excel file will be lost in wpDataTables (Colors, Fonts, Borders...).
Can you tell me exactly what columns did not import well in wpDataTable so I can take a look?
When you import the numbers would change and add a . or , where they shouldn't be. So for example the column ceiling a number should be 39.99 and it will import to 39,99. IF you have two columns the same name it will also import only one. I went ahead and changed column type to string and that fixed the problem on the periods instead of commas
Hi Joshua,
"When you import the numbers would change and add a . or , where they shouldn't be. So for example the column ceiling a number should be 39.99 and it will import to 39,99."
- You can choose Number format on wpDataTables settings page. You can select comma to be decimal separator or to be thousand separator.
"IF you have two columns the same name it will also import only one."
- Yes, all columns should have different name in Excel file. Later when you create wpDataTable you can change names of the columns in Display Header and you can call them whatever you want.