<?php header('Content-type: application/json'); // Function to convert CSV into associative array function csvToArray($file, $delimiter) { if (($handle = fopen($file, 'r')) !== FALSE) { $i = 0; while (($lineArray = fgetcsv($handle, 4000, $delimiter, '"')) !== FALSE) { for ($j = 0; $j < count($lineArray); $j++) { $arr[$i][$j] = $lineArray[$j]; } $i++; } fclose($handle); } return $arr; } function formatArray ($feed) { $keys = array(); $newArray = array(); $data = csvToArray($feed, ','); $count = count($data) - 1; $labels = array_shift($data); foreach ($labels as $label) { $keys[] = $label; } $keys[] = 'id'; for ($i = 0; $i < $count; $i++) { $data[$i][] = $i; } for ($j = 0; $j < $count; $j++) { $d = array_combine($keys, $data[$j]); $newArray[$j] = $d; } return $newArray; } $feed = 'https://docs.google.com/spreadsheets/d/e/2PACX-1vQUspPunAmkZrtfhMgMvGYGTK_4ONsCnSoe6OcTFc-4ILRHTatdPIwgRx1eRM1qFTkYFMrvcx8OI4cv/pub?output=csv'; $data = formatArray($feed); $info = json_encode($data); $infoAsJson = json_decode($info); $handle = fopen("renglones.json", 'w'); fwrite($handle, $info); for ($i = 0; $i < count($infoAsJson); $i++) { $renglon = formatArray($infoAsJson[$i]->Link); $renglonInfo = json_encode($renglon); $renglonAsJson = json_decode($renglonInfo); $my_file = $infoAsJson[$i]->Renglones . ".json"; $handle = fopen($my_file, 'w') or die ('Cannot open file'); fwrite($handle, $renglonInfo); } ?>