From: Colby Callahan Date: 2013-02-06T03:37:01+09:00 Subject: Re: Ruby could recognize the values when putting into a webpage text filed. --0015175cd372db111d04d4fe7dbe Content-Type: text/plain; charset=ISO-8859-1 I am just saying that the browser thinks the information it is receiving is of encoding type X while the server/program is sending encoding type Y. e.g. ruby sends UTF-8, but excel 2010 is encoded with ANSI by default (i think). This would mean that your special characters are not going to be available. Program sends I know of only two reasons why it would not be able to properly read or display any character (not specific to ruby or any language): Encoding Mismatch or Missing Fonts. My guess is encoding. e.g This may help with checking/changing your encoding. http://www.ruby-doc.org/core-1.9.3/Encoding.html (checking encoding within ruby) http://www.surveygizmo.com/survey-software-support/tutorials/getting-started/how-to-encode-an-excel-file-to-utf-8-or-utf-16/ (specifically how to change excel encoding) Hope that helps... On Tue, Feb 5, 2013 at 6:28 AM, Love U Ruby wrote: > Hans Mackowiak wrote in post #1095331: > > how do you read the csv file? > > have you maybe thought about that the encoding may be wrong? > > what ruby version do you using? > > I am using Ruby 1.9.3 latest version. I am using win32ole library with > Excel - 2010. > > until number_of_list_values == 0 > > number_of_list_values = number_of_list_values - 1 > element = driver.find_element :id => "codeExt" > element.send_keys wbs.cells(rows,2).value > element = driver.find_element :id => "descriptionExt" > element.send_keys wbs.cells(rows,3).value > driver.find_element(:name, "btnSaveandNew").click if > number_of_list_values != 0 > wbs.cells(rows,5).value = "done" > rows = rows + 1 > driver.find_element(:name, "btnSave").click if number_of_list_values > == 0 > > end > > -- > Posted via http://www.ruby-forum.com/. > > --0015175cd372db111d04d4fe7dbe Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

I am just saying that the browser thinks the information i= t is receiving is of encoding type X while the server/program is sending en= coding type Y. =A0e.g. =A0ruby sends UTF-8, but excel 2010 is encoded with = ANSI by default (i think). =A0This would mean that your special characters = are not going to be available. =A0Program sends I know of only two reasons = why it would not be able to properly read or display any character (not spe= cific to ruby or any language): Encoding Mismatch or Missing Fonts. =A0My g= uess is encoding. =A0e.g =A0This may help with checking/changing your encod= ing.

http://www.ruby-doc.org/core-1.9.3/Encoding.html =A0 =A0 (checking enc= oding within ruby)

http://www.surveygizmo.com/survey-software-support/tuto= rials/getting-started/how-to-encode-an-excel-file-to-utf-8-or-utf-16/ = =A0(specifically how to change excel encoding)

Hope that helps...

On Tue, Feb 5, 2013 at 6:2= 8 AM, Love U Ruby <lists@ruby-forum.com> wrote:

Hans Mackowiak wrote in post #1095331:

> how do you read the csv file?
> have you maybe thought about that the encoding may be wrong?
> what ruby version do you using?

I am using Ruby 1.9.3 latest version. I am using win32ole library wit= h
Excel - 2010.

until number_of_list_values =3D=3D 0

=A0 number_of_list_values =3D number_of_list_values - 1
=A0 element =3D driver.find_element :id =3D> "codeExt"
=A0 element.send_keys wbs.cells(rows,2).value
=A0 element =3D driver.find_element :id =3D> "descriptionExt"<= br> =A0 element.send_keys wbs.cells(rows,3).value
=A0 driver.find_element(:name, "btnSaveandNew").click if
number_of_list_values !=3D 0
=A0 wbs.cells(rows,5).value =3D "done"
=A0 rows =3D rows + 1
=A0 driver.find_element(:name, "btnSave").click if number_of_list= _values
=3D=3D 0

end

--
Posted via http://= www.ruby-forum.com/.

--0015175cd372db111d04d4fe7dbe--