I'm trying to upload a csv spreadsheet as a new table, but it loads the rows and columns in as String by default. Is there something different I need to do to the spreadsheet to make them Field by default? I have nearly 100 tables to upload, and I want to avoid manually changing each one from String once imported.
Regardless if I create a table linked to the CSV file, or if I choose to import the file, all columns except for the "Vendor" column are saved as "Integer", not "String".
Maybe you were referring to "Float"? Float is not recognized automatically because all numerical data is .00 so the plugin's logic doesn't actually see that. Because of this, you need to access column settings and change the type to Float.
I'm trying to upload a csv spreadsheet as a new table, but it loads the rows and columns in as String by default. Is there something different I need to do to the spreadsheet to make them Field by default? I have nearly 100 tables to upload, and I want to avoid manually changing each one from String once imported.
Hey Samantha
Thank you for your purchase.
Regardless if I create a table linked to the CSV file, or if I choose to import the file, all columns except for the "Vendor" column are saved as "Integer", not "String".
Maybe you were referring to "Float"? Float is not recognized automatically because all numerical data is .00 so the plugin's logic doesn't actually see that. Because of this, you need to access column settings and change the type to Float.
Kind Regards,
Aleksandar Vuković
aleksandar.vukovic@tmsproducts.io
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