Version 1.2 added 4 months ago by chris.pilko

HOW TO INSTALL: To install this package, copy the following code and paste it into your Pods >> Package Manager under the Import tab and follow instructions there.

{"meta":{"version":"1.12.2","build":"1326491231"},"pod_pages":[{"uri":"import","title":"","phpcode":"","precode":"<?php\n\/*\n * Options to set\n *\/\n\/\/ The path of the file to import from\n$in_file = ABSPATH . '\/file.csv';\n\n\/\/ The name of the pod to import into\n$use_pod = 'test_import';\n\n\/\/ Can be 'php' or 'csv'\n$import_format = 'csv';\n\n\/*\n * Import code (do not modify unless needed)\n *\/\n\n\/\/ Check to see if the user is logged in and is an administrator\nif (!is_user_logged_in() || !pods_access('pod_' . $use_pod)) {\n $pods = 404;\n return;\n}\n\nfunction pods_import_comma_convert (&$item) {\n $item = strtr($item, '&#44', ','); \/\/Translates any comma HTML entities into normal commas.\n}\n\n\/\/ Attempt to open $in_file for reading and check for success.\nif (!file_exists($in_file) || !($fp = fopen($in_file, 'r')))\n wp_die(\"Could not open '{$in_file}'. Import aborted.\");\n\n$import = array();\n\n\/\/ If a CSV file is desired\nif ('csv' == strtolower($import_format)) {\n $field_names = array();\n while (false !== ($data = fgetcsv($fp, 5000, ','))) {\n if (empty($field_names)) {\n $field_names = (array) $data;\n continue;\n }\n $tmp = array();\n foreach ($field_names as $key => $field) {\n if (!isset($data[$key]))\n continue;\n if ($data[$key] != ($new_data = preg_replace('\/^array\\((.*)\\)$\/is', '$1', $data[$key]))) {\n $new_data = explode(',', trim($new_data));\n array_walk($new_data, 'pods_import_comma_convert');\n $data[$key] = $new_data;\n }\n $tmp[$field] = $data[$key];\n }\n if (!empty($tmp))\n $import[] = $tmp;\n }\n}\nelse {\n $data = fread($fp, filesize($in_file));\n if (!empty($data)) {\n $data = @serialize($data);\n if (!empty($data))\n $import = $data;\n }\n}\nfclose($fp);\n\n\/\/ Check for import data\nif (empty($import))\n wp_die(\"No import data found in '{$in_file}'. Import aborted.\");\n\n$pods = new PodAPI($use_pod, 'php');\nif (empty($pods->dt))\n\twp_die(\"The Pod '{$use_pod}' does not exist in your database. Edit line 9 of the Precode field to change this. Import aborted.\");\n\n$pods->import($import);\n\nwp_die(\"Import complete. Data imported from '\" . basename($in_file) . \"'\");","page_template":""}]}

Fixed a duplicate use of the $import variable.
Added checks to make sure a valid pod name is declared.
Works with Pods v1.12.2

Allows you to import data from a CSV file into a Pod, even PICK columns.

Data should be in a standard CSV file.
The first row of the CSV file must contain the column names.

Data for Pick columns should be formatted in the CSV as follows:
"array(Pick1, Pick 2, Pick 3&#44; with a comma in the name)"

Remember, this is uses an INSERT query not an UPDATE query, so it can only be used to add new data to a Pod, not update existing data.