Re: Loading csv giving error

Why do you use the File class if you want to use the CSV class?

You can use CSV::open instead. This would print out every row using the
headers.

CSV.open("test.csv", headers: true) do |csv|
  csv.each do |line|
    puts line["PARTNO"] + " and " line["PRICE"]
  end
end



On Thu, Jul 4, 2013 at 1:07 PM, Nithi anand <[e-mail]> wrote:

> hi guys I am trying to compare some data so I create one file name
> called "Price_lookup" in notepad then saved in plugin folder
> "Price_lookup.csv".
> Price_lookup.csv contain like below
>
> "PARTNO", "PRICE"
> 600157,402.20
> 600163,424.16
> 600169,445.00
> 600175,468.96
> 600181,492.01
> 600187,516.69
>
> then I wrote small ruby script for testing. when I start the sketchup
> It's gives an error as follows "Error Loading File CSV_Test.rb no such
> file to load -- csv". any idea what I am doing wrong here???? thank you
>
> here is my code.
>
>
>
>     require 'sketchup.rb'
>     require 'csv'
>
>     def csv_Test
>
>             model =3D Sketchup.active_model
>             ent =3D model.active_entities
>
>             csv_text =3D File.read('Price_lookup.csv')
>             csv =3D CSV.parse(csv_text, :headers =3D> true)
>             csv.each do |row|
>             result =3D csv.find {|row| row['PARTNO'] =3D=3D '600181'}
>
>             UI.messagebox "Your Output #{result}"
>             end
>     end
>
>     if (not $csv_Test_menu_loaded)
>
>       UI.menu("Tools").add_item("CSV_TEST") { csv_Test }
>
>       $csv_Test_menu_loaded =3D true
>     end
>
> --
> Posted via http://www.ruby-forum.com/.
>
>


--=20
*Richard Wilson*
Proteous Trading Group
ph. - [phone]
Skype - r.crawfordwilson
email - [e-mail]

=93*This email may contain confidential and/or privileged information. If y=
ou
are not the intended recipient or have received this email in error, please
notify the sender immediately and destroy this email. Any unauthorized
copying, disclosure or distribution of the information contained on this
email is prohibited=94.*