Re: [jQuery] Re: csv2table

Hi Toshiro Takahashi,

Is there anyway without using server side scripting ...
This is wat i am searching for more than a week .....
could u tell me...

Thanks in advance

On Fri, Nov 27, 2009 at 1:45 PM, tato <tato@game.gr.jp> wrote:

Hi, Ram

You can simplify it if you can use PHP.

You acquire yahoo data in following PHP and receive it in csv2table of
same domain.

<?php

$url="http://download.finance.yahoo.com/d/quotes.csv?s=
%5EIXIC&f=sl1d1t1c1ohgv&e=.csv";

$data=file_get_contents($url);

// for safe Tag to &lt; &gt;
echo htmlspecialchars($data, ENT_QUOTES);

?>

But please be careful about security.

and, csv2table HTML is follow.

<script src="../js/jquery-1.3.2.min.js" type="text/javascript"></
script>
<script src="../js/jquery.csv2table-0.02-b-2.9.js" type="text/
javascript" charset="utf-8"></script>

<script>
$(function(){
 $('#view1').csv2table({
   url:'./getcsv.php',
   appendThead:['a','b','c','d','e','f','g','h','i']
 })
});
</script>

<div id="view1"></div>


@see Sample:
http://jsgt.org/lib/jquery/plugin/csv2table/v002/test/test.htm

On 11月27日, 午後1:34, Ram <naviamarkets....@gmail.com> wrote:
> Hi  Toshiro Takahashi
>
> First i should say thanks to you for replying
> Actually i need to read data from yahoo stock quotes and show it in my
> website .... so can you guide me to get data.....
>

> http://download.finance.yahoo.com/d/quotes.csv?s=%5EIXIC&f=sl1d1t1c1o...

>
> Pls in detail.
>
> On Nov 27, 7:10 am, tato <t...@game.gr.jp> wrote:
>
> > By the way, the reason why csv2table cannot read the text file of the
> > other domain is because it uses $.get method of jQuery.
>
> > But I do not get along well even if I change $.get in $.getScript.
>
> > When capture a TCP packet, the data body arrives,; but csv data as for
> > the JavaScript is because is not it.
>
> > The method to obtain it thought, but a person distributing json in the
> > other domain is that it is easy first of all :p
>
> > --

> > Toshiro Takahashihttp://plugins.jquery.com/project/csv2tablehttp://plugins.jquery.com/...

>
> > On 11月27日, 午前10:49, Toshiro Takahashi <t...@game.gr.jp> wrote:
>
> > > Hi, Ram
>
> > > Thank you for using my plugin.
>
> > > On Thu, 26 Nov 2009 02:21:19 -0800 (PST)
>
> > > Ram <naviamarkets....@gmail.com> wrote:
> > > > I am new to jquery.... Its nice
> > > > in csv2table i need to get values dynamically from a particular url
> > > > everyminute ...
> > > > i dont know how to get from particular url (  www.websitename.com?asdfasdf.csv
> > > > ) and generate table for that value.
>
> > > Is the 'particular url' another Domain from yuor html?
> > > You cannot read the csv when that is it.
>
> > > If you can process the text file of the other domain, there is a method
> > > you make it json not csv, and to access.
>
> > > However, json does not implement it in csv2table.
>
> > > If get time; I may make json2table if you are necessary.
>
> > > > $(function(){
> > > >     $('#view1').csv2table('book12.csv');
> > > > });
>
> > > > any help will be appreciated ..
>
> > > --
> > > Toshiro Takahashihttp://plugins.jquery.com/project/csv2tablehttp://plugins.jquery.com/...