As you know, importing to Pods is a subject that is near and dear to my heart. I've been playing with this in my free time, and found some bugs / solutions.

1) In PodAPI.class.php, the function csv_to_php() does not handle CSV files correctly. I found that when the first data column is enclosed in quotes, it trips up this function. I've tried several other CSV parsing functions on php.net, and none of them worked.

What does work is importing a csv via fgetcsv(). I wrote this code, and it works: <pre> <?php $php_data = pods_csv_import('my_file.csv', ',', 5000); $Record = new PodAPI($use_pod, 'php'); $Record->import($php_data);

function pods_csv_import($filename, $delimiter = ',', $max_line_len = 1000) { $first_row = true; if (false == ($handle = fopen($filename, "r"))) die("<p>Could not open $filename</p>"); while (($data = fgetcsv($handle, $max_line_len, $delimiter)) !== FALSE) { if ($first_row) { $field_names = $data; $first_row = false; } else { $tmp[$field] = $data[$key]; } $out[] = $tmp; } } fclose($handle); return $out; } ?> </pre>

2) I've been looking for a way to import / export pick columns via CSV. The CSV standard doesn't have a protocol for storing nested data, so I've come up with my own.

My steps are: + Replace any commas in the PICK array with &amp;#44; + Implode the array into a comma delimited string + Store the string as 'array(' . $string . ')'

Again, I've tested this, and it works exporting a Pod then importing it too a new Pod. My test Pod has 34 columns (including 5 desc and 8 PICK). The code for export is: <pre> <?php $Record = new PodAPI('my_pod', 'csv'); $data = $Record->export();

if (($fp = fopen('file.csv', 'w')) === FALSE) { //Attempt to open 'file.csv' for writing and check for success. die ("Could not open $out_file. Export aborted."); //Fail if unable to. }

$data_keys = array_keys($data[0]); //Get the pod column labels fputcsv($fp, $data_keys); //Write the column labels as the first line of the CSV file. foreach ($data as $line) { //Loop through the data line by line foreach ($line as &$field) { //Loop through each line of data by field if (is_array($field)) { //If the field is a PICK column array_walk($field, 'comma_trans'); //Translate any commas in the field to HTML "&amp;#44;" $field = 'array(' . implode(', ', $field) . ')'; //Implode the items into a comma separated list wrapped in array(). } } fputcsv($fp, $line); //Write the line to the file. }

function comma_trans(&$item){ $item = strtr($item, ',', '&amp;#44'); //Translates any commas into their HTML entity. }

?> </pre>

The import code gets added to the above code just after "} else {": <pre> foreach ($field_names as $key => $field) { if ($data[$key] <> ($new_data = preg_replace('/^array((.*))$/is', '$1', $data[$key]))) { $new_data = explode(",",trim($new_data)); array_walk($new_data, 'comma_trans'); $data[$key] = $new_data; } </pre>

and the comma_trans function gets added with this modification: <pre> function comma_trans(&$item){ $item = strtr($item, '&amp;#44', ','); //Translates HTML &amp;#44; to commas } </pre>

I've added packages to the library with the full code of my "Import" and "Export" pages.