How can I stop a String field from cutting off after 200-odd characters? This is happening on import from Excel sheet or from a Google spreadsheet. The only documentation I could find on this had to do with grabbing data from a MySQL database.
When you're importing an external file, you need to choose the editor input type to be "multi-line edit", instead of "single-line edit". Single-line stores the column with type VARCHAR, which has a default limit of 255, and multi-line stores it as TEXT, which doesn't have a defined limit.
Got it for manual files. How would you deal with this from a Google Spreadsheet – that phase of the input process where you choose those settings doesn't appear. You put in the URL and nothing happens until you hit "apply," and then the table just appears. If there isn't a way to do this please consider it a feature request for a future release. Thanks!
I guess you're linking to an existing Google Spreadsheet, and not importing it, correct?
If you're linking to it, then the column type selection screen will not appear. Unfortunately, it cannot be done in that case. I have forwarded this suggestion to our development team, and they'll see if there's anything they can do for one of our future releases.
How can I stop a String field from cutting off after 200-odd characters? This is happening on import from Excel sheet or from a Google spreadsheet. The only documentation I could find on this had to do with grabbing data from a MySQL database.
Hello Chris.
Thank you for your purchase.
When you're importing an external file, you need to choose the editor input type to be "multi-line edit", instead of "single-line edit". Single-line stores the column with type VARCHAR, which has a default limit of 255, and multi-line stores it as TEXT, which doesn't have a defined limit.
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
Got it for manual files. How would you deal with this from a Google Spreadsheet – that phase of the input process where you choose those settings doesn't appear. You put in the URL and nothing happens until you hit "apply," and then the table just appears. If there isn't a way to do this please consider it a feature request for a future release. Thanks!
Hi Chris.
I guess you're linking to an existing Google Spreadsheet, and not importing it, correct?
If you're linking to it, then the column type selection screen will not appear. Unfortunately, it cannot be done in that case. I have forwarded this suggestion to our development team, and they'll see if there's anything they can do for one of our future releases.
Thank you.
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
Correct, thanks for forwarding to the development team. You can close this ticket out – thanks again.
Chris
You're welcome Chris.
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