Pods CMS » Packages » Pod Page Export

Pod Page: Export

Version 1.0.1 added 9 months ago by chris.pilko

{"meta":{"version":"174","build":"1255619476"},"pod_pages":[{"uri":"export","title":"","phpcode":"<?php\n$out_file = 'file.csv';          \/\/This would open file.csv in the blog root.\n$use_pod = 'events';         \/\/The name of the pod to use.\n$export = \"csv\";               \/\/ Can be \"php\" or \"csv\" (default: php)\n$Record = new PodAPI($use_pod, $export); \n$data = $Record->export();\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\n  if (($fp = fopen($out_file, 'w')) === FALSE) {         \/\/Attempt to open $out_file for writing and check for success.\n    die (\"Could not open $out_file. Export aborted.\");  \/\/Fail if unable to.\n  }\n\n\n  if ('csv' == strtolower($export)) {            \/\/If a CSV file is desired\n    $data_keys = array_keys($data[0]);      \/\/Get the pod column labels\n    fputcsv($fp, $data_keys);                    \/\/Write the column labels as the first line of the CSV file.\n    foreach ($data as $line) {                    \/\/Loop through the data line by line\n       foreach ($line as &$field) {                \/\/Loop through each line of data by field\n          if (is_array($field)) {                     \/\/If the field is a PICK column\n           array_walk($field, 'comma_trans');      \/\/Translate any commas in the field to HTML \"&#44;\"\n           $field = 'array(' . implode(', ', $field) . ')';  \/\/Implode the items into a comma separated list wrapped in array().\n          }\n       }\n      fputcsv($fp, $line);       \/\/Write the line to the file.\n    } \n  } else {                           \/\/Otherwise, output the data as PHP\n    fwrite($fp, var_export($data, TRUE));\n  }\n  fclose($fp); \/\/Close the file\n\n  echo \"Export complete. <a href='$out_file'>Open $out_file<\/a><br \/><br \/>\\n\";\n\n} else {                                  \/\/User doesn't have permission\n  include(get_404_template());   \/\/Nothing to see here, move along...\n  exit();                                  \/\/Exit.\n}\n\nfunction comma_trans(&$item)\n{\n    $item = strtr($item, ',', '&#44'); \/\/Translates any commas into their HTML entity.\n}\n?>","precode":"","page_template":"page_pod.php"}]}

1.0.1 Notes

Changed encoding of PICK arrays to eliminate single quotes, instead replacing commas with ,. Works with Pod Page: Import

About this Package

Change the variable definitions in the first three lines of code to customize this.

Pod page is restricted to administrators only. If a user tries to access the Pod who is not logged in or authorized, your 404 error page is displayed. Change this on line 10.