我正在尝试使用
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","value_1":"000000167865321","value_3":"YYYY","value_4":"12668","value_5":"0"},"stream_type":"COOKIE"}
{"type":"NON_ATTRIBUTED","value_1":"000000134535321","value_3":"AAAA","value_4":"12669","value_5":"9"},"value_1":"000000100357651","value_3":"WWWW","value_4":"12670","value_5":"2"},"stream_type":"COOKIE"}
我得到的输出是:
类型,转换,的stream_type
NON_ATTRIBUTED,阵列,COOKIE
NON_ATTRIBUTED,COOKIE
我期望的输出是:
类型,value_1,value_3,value_4,value_5,stream_type
NON_ATTRIBUTED,000000100355321,XXXX,1267,6,COOKIE
..
任何帮助赞赏,因为这对我来说非常新鲜