CSV has a $ sign in front of numbers. After import, it shows 0. The work around to treat them as strings loses accurate sorting in wpdatatables.
Other online tools such as Airtable and Startinfinity don't have this issue. Basically, if I tell them this is a number column, they'll treat it as numbers and don't touch whatever prefix or suffix there is. Besides, they can also add a prefix or suffix, just like wpdatatables can.
Can wpdatatables skip the $ sign (just like wpdatatables skip "," the thousands separator), and then process the integers? That way, I can still add a prefix to solve the problem.
Unfortunately at the moment that is the logic that is created for Integers and floats columns. If those columns contain any other than number format they will be treated as string and if you set those columns as integer or float data will be replaced with 0.
Like you said you will need to insert only numbers and then in wpdatatables you can set prefix or suffix.
This what you need is not the issue it is the new feature that need to be implement so you will be able to import numbers like you need.
Thank you for your suggestion. We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time,.
We constantly strive to make our product better, and deliver the most value for our end users - so please share your feedback on what features you need in next versions link.
Unfortunately, no, it's not that basic, otherwise it would've already been implemented.
I can't say much about other tools, since I haven't used them, but wpDataTables stores all data of imported files in the database, and works with SQL in the back to bring the info from the database to the plugin's UI.
Just like you can't add anything other than an actual number in a numerical column the database, you can't do that with wpDataTables either.
I suppose the other tools you're mentioning don't save the data in the database, or if they do, they serialize it, or split it into different tables.
CSV has a $ sign in front of numbers. After import, it shows 0. The work around to treat them as strings loses accurate sorting in wpdatatables.
Other online tools such as Airtable and Startinfinity don't have this issue. Basically, if I tell them this is a number column, they'll treat it as numbers and don't touch whatever prefix or suffix there is. Besides, they can also add a prefix or suffix, just like wpdatatables can.
Can wpdatatables skip the $ sign (just like wpdatatables skip "," the thousands separator), and then process the integers? That way, I can still add a prefix to solve the problem.
Otherwise, could you please fix this issue?
Hi Lingxi,
Thank you for your purchase.
Unfortunately at the moment that is the logic that is created for Integers and floats columns. If those columns contain any other than number format they will be treated as string and if you set those columns as integer or float data will be replaced with 0.
Like you said you will need to insert only numbers and then in wpdatatables you can set prefix or suffix.
This what you need is not the issue it is the new feature that need to be implement so you will be able to import numbers like you need.
Thank you for your suggestion. We carefully follow customers requirements and try to implement most of them if they appear in requests from time to time,.
We constantly strive to make our product better, and deliver the most value for our end users - so please share your feedback on what features you need in next versions link.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables
"This what you need is not the issue it is the new feature that need to be implement"
Isn't it a feature just as basic as the thousand separator? It is so basic a feature that most other tools have it.
Hello again Lingxi Kong
Unfortunately, no, it's not that basic, otherwise it would've already been implemented.
I can't say much about other tools, since I haven't used them, but wpDataTables stores all data of imported files in the database, and works with SQL in the back to bring the info from the database to the plugin's UI.
Just like you can't add anything other than an actual number in a numerical column the database, you can't do that with wpDataTables either.
I suppose the other tools you're mentioning don't save the data in the database, or if they do, they serialize it, or split it into different tables.
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