I Need To Build A Json File

[stanf 43]

i have a csv file that i need to convert into a json file.

can someone provide my with instructions in how to do this.

[LoWrIdErTJ - BotGuru 904]

I do so via php
this way I can load csv data to it and then convert to json

 

[stanf 43]

do you want to part with it?

[LoWrIdErTJ - BotGuru 904]

// path to file

$file="1_23.csv";



// reads in the file

$csv= file_get_contents($file);



// creates array of data

$array = array_map("str_getcsv", explode("\n", $csv));



// encodes to json

$json = json_encode($array);



// returns json data 

print_r($json); 

[stanf 43]

thanx tj

i have xamp installed on this machine, so i gonna play with

[Bot-Factory 602]

http://www.csvjson.com/csv2json

 

Someone might even automate that site somehow 

[deliter 203]

set table cell(&myT,0,0,"Apples")
set table cell(&myT,0,1,"Oranges")
set table cell(&myT,1,0,1)
set table cell(&myT,1,1,3)
run javascript("//var csv is the CSV file with headers
function csvJSON(csv)\{

  var lines=csv.split(\"\\n\");

  var result = [];

  var headers=lines[0].split(\",\");

  for(var i=1;i<lines.length;i++)\{

	  var obj = \{\};
	  var currentline=lines[i].split(\",\");

	  for(var j=0;j<headers.length;j++)\{
		  obj[headers[j]] = currentline[j];
	  \}

	  result.push(obj);

  \}
  
  //return result; //JavaScript object
  return JSON.stringify(result); //JSON
\}")
alert($eval("csvJSON(`{&myT}`)"))

Remember the little ` ` marks for the eval bit, if your csv's have that symbol the code will break but I doubt they would

**Does not work with Chrome 21