Support

Account

Home Forums General Issues Import ACF Repeater Field Values from CSV

Helping

Import ACF Repeater Field Values from CSV

    • bravo

    • January 12, 2021 at 8:25 pm

    I’m trying to import a load of data into a sub fields of a repeater field (mortgage_providers) using file field (dd_csv) to upload the file to a post and return an array. Then loop through each row with PHP and update the repeater fields. I have tried the following but I can’t seem to get it to work.

    if( get_field('dd_csv') ) {
            // load csv with SERVER PATH instead of URL
            $csv = get_attached_file(get_field('dd_csv')['id']);
            if(($handle = fopen($csv, "r")) !== FALSE) {
              $count = 0;
              while(($data = fgetcsv($handle, 1000, ",")) !== FALSE) {
                // $count = acf row, $data[0] = csv column 1 value
                update_sub_field(array('mortgage_providers', $count, 'mortgage_provider_name'), $data[0], 'option');
                $count++;
              }
    
              fclose($handle);
            }
          }

    Here’s a sample of the data:

    at symbol Sipp
    012 Property Shares
    121 Legals
    1st Source Direct
    1st Stop Finance
    33 KWS
    3i
    3M
    3mc
    3XD
    5 Arrows
    AA Commercial Insurance
    AIG
    A1 Lender not relevant
    AA Friendly Society
    AA Insurance
    Abacus

    In total there’s over 1000 rows in column 1 of the CSV.

    Thanks

  • Adding rows to a sub field requires using add_row().

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic.

We use cookies to offer you a better browsing experience, analyze site traffic and personalize content. Read about how we use cookies and how you can control them in our Cookie Policy. If you continue to use this site, you consent to our use of cookies.