We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #3217933
char length
Closed

Comments

  • Mark A Szymanski started the conversation

    Hello. We are importing from a google doc. Some of the text value characters are a little long and its cutting off the last few characters.

    Im not seeing any settings I can alter that affect the char length. Also sure its not an html or css thing, the values are not saving completely in the backend. Thanks

  •  1,894
    Miloš replied

    Hi, Mark 

    Thanks for reaching out to us

    -

    When you're importing some cells that might have longer character number,  

    during the table "preview" in the import,  you will see the option to choose the column types.

    For columns that will have longer text,  the best will be to choose a "multi-line string",

    that way this table will create a TEXT data type in your database, rather than "VARCHAR" , which is limited to 255 characters.

    -

    - Basically, at this moment, if you have already set that column to be a "one-line string" when it was created; you can either go to your database using something like PhPMyAdmin, 

    and manually change the type of column from VARCHAR( which has a limitation of 255 characters) to TEXT ( 65,535 limit) ,

    - or you can delete and recreate this column in wpDataTables and set it right away to be a "multi-line string", this way you will ensure that it has this much higher character limit.

    This depends on the type of table, if it will allow you to remove/add new columns.

    Let me know how it goes, and if you need further assistance, please. Thanks.


    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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