CSV encoding and maximum number of rows?

Viewing 7 posts - 1 through 7 (of 7 total)
  • Author
    Posts
  • #14503

    jayzee
    Participant

    Hello!

    1. What is the maximum number of rows that can be imported?
    2. What are the recommended PHP settings for large tables (10K records+)?
    3. For CSV file imports, will any encoding (UTF8, ANSI/ASCII) work?
    2. If the CSV file has data that are HTML entities like &#223, are there any considerations to be made prior to importing?

    Thanks!

    #14592

    Hi @jayzee

    Thank you for contacting us about your questions.

    1. We don’t have limits on the number of rows that can be imported with Data Tables plugin.
    2. Try to allot more time and memory in your PHP settings.
    3. Yes, it will work.
    4. If import of CSV file data, that has HTML entities like &#223 will not work, try to transform it in HTML tag.

    #20804

    cmiller
    Participant

    I’ve been having trouble with exceptionally large tables – more than 500 rows. If there is a table on the page that has too many rows the page will not load.

    I’ve had to break all the long tables into separate tables.
    http://dev.alaskanmalamute.org/working/working-dog-certificates/

    Let me know if there is a solution.

    Thank you!

    #20846

    Ole_Support
    Keymaster

    Hello, @cmiller
    Thank you for contacting us regarding your question.
    Try use feature Server Side processing.
    More about information about this feature you can read on our site – https://supsystic.com/example/tables-with-server-side-processing-example/

    Best regards,
    https://supsystic.com
    Ole

    #20858

    cmiller
    Participant

    Tried server side processing. The pages load but the tables will not sort, and the search and pagination links don’t work.
    I’ve contacted you through internal support.
    Thank you

    #20931

    therealstephtaylor
    Participant

    I keep trying to import my csv file of approximately 900 rows with 9 columns and the plugin just keeps telling me my “Table is loading”. I’ve gone ahead and changed the settings for Server Side Processing, but I’m unable to save the table…just keeps circling, telling me its loading.

    #20942

    Anonymous
    Inactive

    Hello therealstephtaylor,

    Thank you for choosing our plugin.
    Please contact us through our internal support.
    We will help you to solve the issue.

    Best regards,
    https://supsystic.com
    Dante

Viewing 7 posts - 1 through 7 (of 7 total)
  • You must be logged in to reply to this topic.
Thanks so much! Please Enter Your Info Below To Get PRO Discount and Gifts