Skip to content

Instantly share code, notes, and snippets.

@geoffyuen

geoffyuen/readme.md

Created November 22, 2018 15:56
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save geoffyuen/d3e9154db842aba9cd3e9e61523c4028 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save geoffyuen/d3e9154db842aba9cd3e9e61523c4028 to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. geoffyuen created this gist Nov 22, 2018.
    31 changes: 31 additions & 0 deletions readme.md
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,31 @@
    Via: https://felicoz.com/en/2017/05/acf-import-repeater-field-values-csv-programmatically/

    1. Prepare your CSV file with columns matched to the repeater sub fields
    2. ACF – create a csv file select field
    3. ACF – set up the repeater field with sub fields
    4. create a new post
    5. From the post, upload your csv
    6. create empty repeater fields depending on the number of rows you have in csv
    7. In the front page, paste this php code:

    ```
    <?php
    if(get_field('csv_file'))
    {
    // load csv with SERVER PATH instead of URL
    $csv = get_attached_file(get_field('csv_file')['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('repeater_name', $count, 'name'), $data[0]);
    update_sub_field(array('repeater_name', $count, 'address'), $data[1]);
    update_sub_field(array('repeater_name', $count, 'phone'), $data[2]);
    $count++;
    }
    fclose($handle);
    }
    }
    ```