我试图使用PHP脚本将json文件转换为csv格式.代码如下:
if (empty($argv[1])) die("The json file name or URL is missed\n"); $jsonFilename = $argv[1]; $json = file_get_contents($jsonFilename); $array = json_decode($json, true); $f = fopen('output.csv', 'w'); $firstLineKeys = false; foreach ($array as $line) { if (empty($firstLineKeys)) { $firstLineKeys = array_keys($line); fputcsv($f, $firstLineKeys); $firstLineKeys = array_flip($firstLineKeys); } fputcsv($f, array_merge($firstLineKeys, $line));
}
这种工作,但只返回JSON文件的外部变量,并得到一个"数组到字符串转换"警告
JSON数据如下所示:
{"type":"NON_ATTRIBUTED","conversion":{,"value_1":"000000100355321","value_3":"XXXX","value_4":"12667","value_5":"6"},"stream_type":"COOKIE"} {"type":"ATTRIBUTED","conversion":{,"value_1":"000000167865321","value_3":"YYYY","value_4":"12668","value_5":"0"},"stream_type":"COOKIE"} {"type":"NON_ATTRIBUTED","conversion":{,"value_1":"000000134535321","value_3":"AAAA","value_4":"12669","value_5":"9"},"stream_type":"COOKIE"} {"type":"NON_ATTRIBUTED","conversion":{,"value_1":"000000100357651","value_3":"WWWW","value_4":"12670","value_5":"2"},"stream_type":"COOKIE"}
我得到的输出是:类型,转换,stream_type NON_ATTRIBUTED,数组,COOKIE NON_ATTRIBUTED,数组,COOKIE
我期望的输出是:type,conversion,value_1,value_3,value_4,value_5,stream_type NON_ATTRIBUTED,000000100355321,XXXX,1267,6,COOKIE ..
我非常感谢,因为这对我来说很新鲜
json_decode($ json,true); 将JSON对象转换为关联数组.所以这
{ "type":"NON_ATTRIBUTED", "conversion":{, "value_1":"000000100355321", "value_3":"XXXX", "value_4":"12667", "value_5":"6" }, "stream_type":"COOKIE" }
成为这个:
array(3) { ["type"]=> string(14) "NON_ATTRIBUTED" ["conversion"]=> array(4) { ["value_1"]=> string(15) "000000100355321" ["value_3"]=> string(4) "XXXX" ["value_4"]=> string(5) "12667" ["value_5"]=> string(1) "6" } ["stream_type"]=> string(6) "COOKIE" }
如您所见,有嵌套数组.并且您尝试使用以下行将所有数组元素插入到文本文件中(csv只是一个简单的文本文件):
fputcsv($f, array_merge($firstLineKeys, $line));
当数组的元素是字符串时它很好用.但是当元素是数组时,我们将Array转换为字符串.所以你必须在嵌套数组上使用loop或array_merge来防止这种情况.
我无法清楚地了解您的csv必须如何,但我希望您的代码修复将帮助您.如果没有,请在下面写下评论.
if (empty($argv[1])) die("The json file name or URL is missed\n"); $jsonFilename = $argv[1]; $json = file_get_contents($jsonFilename); $array = json_decode($json, true); $f = fopen('output.csv', 'w'); $firstLineKeys = false; foreach ($array as $line) { if (empty($firstLineKeys)) { $firstLineKeys = array_keys($line); fputcsv($f, $firstLineKeys); $firstLineKeys = array_flip($firstLineKeys); } $line_array = array($line['type']); foreach ($line['conversion'] as $value) { array_push($line_array,$value); } array_push($line_array,$line['stream_type']); fputcsv($f, $line_array); }
你的json中也有一个错误 - 不需要的逗号: "conversion":{,