Pods CMS » Packages » Pod Page Csv Import

Pod Page: CSV Import

Version 1.0.0 added 9 months ago by chris.pilko

{"meta":{"version":"174","build":"1255625751"},"pod_pages":[{"uri":"import","title":"","phpcode":"<?php\n$in_file = 'file.csv';          \/\/This would open file.csv in the blog root.\n$use_pod = 'test';         \/\/The name of the pod to use.\n$import = \"csv\";               \/\/ Can be \"php\" or \"csv\" (default: php)\n\nglobal $user_ID , $user_level;\nget_currentuserinfo();     \/\/Get the information about the current user.\nif ($user_ID && (10 == $user_level)):                       \/\/Check to see if the user is logged in and is an administrator\n  $php_data = pods_csv_import($in_file, ',', 5000);\n  $Record = new PodAPI($use_pod, 'php');\n  $Record->import($php_data);\n\n  echo \"<pre>\\n\";\n  var_dump($php_data); \n  echo \"<\/pre>\\n\";\n  \nelse: \/\/User isn't logged in or an administrator\n  include(get_404_template());   \/\/Nothing to see here, move along...\n  exit();                        \/\/Exit.\nendif;\n\nfunction pods_csv_import($filename, $delimiter = ',', $max_line_len = 1000) {\n\t$first_row = true;\n\tif (false == ($handle = fopen($filename, \"r\"))) die(\"<p>Could not open $filename<\/p>\");\n\twhile (($data = fgetcsv($handle, $max_line_len, $delimiter)) !== FALSE) {\n\t  if ($first_row) {\n\t\t$field_names = $data;\n\t\t$first_row = false;\n\t  } else {\n\t  foreach ($field_names as $key => $field) {\n\t\tif ($data[$key] <> ($new_data =  preg_replace('\/^array\$(.*)\$$\/is', '$1', $data[$key]))) {\n\t\t\t$new_data = explode(\",\",trim($new_data));\n\t\t\tarray_walk($new_data, 'comma_trans');\n                        $data[$key] =  $new_data;\n\t\t}\n\t\t$tmp[$field] = $data[$key];\n\t  }\n\t  $out[] = $tmp;\n\t  }\n\t}\n\tfclose($handle);\n\treturn $out;\n}\n\nfunction comma_trans(&$item)\n{\n    $item = strtr($item, '&#44', ','); \/\/Translates HTML &#44; to commas\n}\n\n?>","precode":"","page_template":""}]}

1.0.0 Notes

Original release

About this Package

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, 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.