elazdins/json2csv.php

## json2csv.php
#!/usr/bin/php
<?php
/*
* Convert JSON file to CSV and output it.
*
* JSON should be an array of objects, dictionaries with simple data structure
* and the same keys in each object.
* The order of keys it took from the first element.
*
* Example:
* json:
* [
*  { "key1": "value", "kye2": "value", "key3": "value" },
*  { "key1": "value", "kye2": "value", "key3": "value" },
*  { "key1": "value", "kye2": "value", "key3": "value" }
* ]
*
* The csv output: (keys will be used for first row):
* 1. key1, key2, key3
* 2. value, value, value
* 3. value, value, value
* 4. value, value, value
*
* Uses:
* json-to-csv.php file.json > file.csv
*/

error_reporting(E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED);

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('php://output', 'w');
$firstLineKeys = false;
$keys = array();

//first collect keys
foreach($array as $line){
    foreach($line as $key => $value){
        if(!in_array($key, $keys))
            $keys[] = $key;
    }
}

$keyString = implode(",", $keys);
fwrite($f, "$keyString\n");

foreach ($array as $line)
{
    $outputArray = array();
    foreach($keys as $key){
        if(array_key_exists($key, $line)){
            $outputArray[] = str_replace(',', '', $line[$key]);;
        } else {
            $outputArray[] = "";
        }
    }

    $outputString = implode(",", $outputArray);
    fwrite($f, "$outputString\n");
}

fclose($f);
?>
	#!/usr/bin/php
	<?php
	/*
	* Convert JSON file to CSV and output it.
	*
	* JSON should be an array of objects, dictionaries with simple data structure
	* and the same keys in each object.
	* The order of keys it took from the first element.
	*
	* Example:
	* json:
	* [
	* { "key1": "value", "kye2": "value", "key3": "value" },
	* { "key1": "value", "kye2": "value", "key3": "value" },
	* { "key1": "value", "kye2": "value", "key3": "value" }
	* ]
	*
	* The csv output: (keys will be used for first row):
	* 1. key1, key2, key3
	* 2. value, value, value
	* 3. value, value, value
	* 4. value, value, value
	*
	* Uses:
	* json-to-csv.php file.json > file.csv
	*/

	error_reporting(E_ALL & ~E_NOTICE & ~E_STRICT & ~E_DEPRECATED);

	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('php://output', 'w');
	$firstLineKeys = false;
	$keys = array();

	//first collect keys
	foreach($array as $line){
	foreach($line as $key => $value){
	if(!in_array($key, $keys))
	$keys[] = $key;
	}
	}

	$keyString = implode(",", $keys);
	fwrite($f, "$keyString\n");

	foreach ($array as $line)
	{
	$outputArray = array();
	foreach($keys as $key){
	if(array_key_exists($key, $line)){
	$outputArray[] = str_replace(',', '', $line[$key]);;
	} else {
	$outputArray[] = "";
	}
	}

	$outputString = implode(",", $outputArray);
	fwrite($f, "$outputString\n");
	}

	fclose($f);
	?>