Importing large record in csv file upload

  • Resolved anbuwp

    (@anbuwp)


    2 years, 6 months ago

    I need to import the csv file around 170,000 records with around 85 columns. I need to import the above csv file and upload and mapping with database table columns. I tried to upload with 170,000 records in my dev environment, but it was timed out. So, i have make the subset by splitting the records so up to 35,000 records only i can upload in a single stretch.
    So, I need a solution to upload 170,000 records at a single phase. Currently I’m using free version of wp-data access.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor Kim L

    (@kimmyx)

    2 years, 6 months ago

    Hi @anbuwp,

    Thanks for the post.

    Please try the solutions we’ve outlined here: Import file too large | WP Data Access

    Let us know if that helps or if you have other questions. 😊

    Thread Starter anbuwp

    (@anbuwp)

    2 years, 6 months ago

    Thanks for your response, Kim. Actually, I need to import csv file in the import csv- upload csv file not a SQL file in the data explore section. So, compressing SQL file and upload it as a ZIP file there is not possible. I have checked all the memory configs it already set to the higher limit. The upload csv file size was around 249 MB. Is there any other solution?

    Plugin Contributor Kim L

    (@kimmyx)

    2 years, 6 months ago

    Hi @anbuwp,

    Thanks for the response.

    The CSV file is indeed too large for a single upload. Since you already maxed your limits, we suggest splitting the file as you’ve already done since this also reduces the chances of failure.

    Hope that helps.

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Importing large record in csv file upload’ is closed to new replies.