Brian said that JSON uses a key:value format, but it is really just a
shorthand for Javascript literals. Which means you can easily
represent ordered lists like CSV data as well:
[ [ 'c', 's', 'v' ], [ 'c', 's', 'v' ], ... ]
To get around the cross-domain restrictions and to solve your
conversion issue, maybe you should write a script on the server that
pulls the data, caches it, and writes out JSON.
Assuming you were using PHP on the server, and assuming the PHP
settings allow fopen wrappers for URLs, this would be pretty easy:
define('DATA_FILE','data.json'); // must be writable
if (file_exists(DATA_FILE) and filemtime(DATA_FILE) > (time() - 900))
readfile(DATA_FILE);
else {
$fh = fopen('http.../yoururl/data.csv','r');
$rows = array();
while($rows[] = fgetcsv($fh)) { }
$json = json_encode($rows);
file_put_contents(DATA_FILE,$json);
echo $json;
fclose($fh);
}
I didn't test this code but it should be pretty close.
On May 20, 7:45 am, brian <bally.z...@gmail.com> wrote:
> There's quite a difference between the two. JSON uses a key: value
> format, while CSV is generally value only
>
> On Wed, May 20, 2009 at 6:28 AM, Nitin Sawant <nitin.jays...@gmail.com> wrote:
>
> > How to convert csv file to json using jquery / javascript??
