[wtr-general] Re: Data driven test using .CSV file

2009-07-27 Thread sHiVa

Hi Chris,

Your idea of implemnting a CSV based framework is very nice. It used a
lot in my current framework. - Thanks
Regards
Siva

On Jul 27, 10:56 am, takanobu watanabe rreedd...@gmail.com wrote:
 Sorry spread it.
 This is that CSV sample.
 --
 ID,mnemonic,var-name,value
 1,companycode,company_code,51236
 2,companyname,company_name,Watir corp
 3,company-zip-code,zip_code,111011
 4,company-prefecture,select_prefecture,MA
 5,company-prefecture for update,select_prefecture2,TT
 6,company address,address_district,Gossam city
 --
 Just last var is used.





 On Mon, Jul 27, 2009 at 2:47 PM, takanobu watanaberreedd...@gmail.com wrote:
  miscode
  mhc = Array::new
  |
  V
  company = Array::new

  On Mon, Jul 27, 2009 at 2:46 PM, takanobu watanaberreedd...@gmail.com 
  wrote:
  I use CSV like that below

  -import.rb-(csv import)-
  #! ruby -Ku
  #!/usr/bin/env ruby

  require 'csv'

  $KCODE = 'UTF8'

  #import company-data settings
     mhc = Array::new
     CSV.foreach(data/company_var.csv) do |row|
     company  Kconv.kconv(row.join(','),Kconv::UTF8)
     end

     $company_code       = company[1].split(',').last.to_s
     $company_name       = company[2].split(',').last.to_s
     $zip_code = company[3].split(',').last.to_s
     $select_prefecture = company[4].split(',').last.to_s
     $select_prefecture2 = company[5].split(',').last.to_s
     $address_district = company[6].split(',').last.to_s

  something like that.
  then you can use that values
  -Test case file-
  require 'import'

  some test code...
  $company_name...

  But,Maybe someone knows more simple and smart way.

  Hope it help you.
  It is work,I use it for job too.
  tknv/

  On Mon, Jul 27, 2009 at 1:39 AM, Chris
  McMahonchristopher.mcma...@gmail.com wrote:

  On Jul 25, 9:03 am, RAM rahulbhai...@gmail.com wrote:
  Hi allI am very new to Watiranybody here knows how to
  import value from  .CSV files and Export Results into an .CSV file in
  Watir.
  Please reply and provide links if similar subject is already posted.

  I wrote a toy framework that does exactly this:
 http://chrismcmahonsblog.blogspot.com/2009/04/ui-test-framework-desig...

  Please let us know if that is useful.

  -Chris

  --
  tknv/

  --
  tknv/

 --
 tknv/- Hide quoted text -

 - Show quoted text -
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to 
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---



[wtr-general] Re: Data driven test using .CSV file

2009-07-26 Thread Chris McMahon



On Jul 25, 9:03 am, RAM rahulbhai...@gmail.com wrote:
 Hi allI am very new to Watiranybody here knows how to
 import value from  .CSV files and Export Results into an .CSV file in
 Watir.
 Please reply and provide links if similar subject is already posted.

I wrote a toy framework that does exactly this:
http://chrismcmahonsblog.blogspot.com/2009/04/ui-test-framework-design-using-watir.html

Please let us know if that is useful.

-Chris
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to 
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---



[wtr-general] Re: Data driven test using .CSV file

2009-07-26 Thread takanobu watanabe

I use CSV like that below

-import.rb-(csv import)-
#! ruby -Ku
#!/usr/bin/env ruby

require 'csv'

$KCODE = 'UTF8'

#import company-data settings
mhc = Array::new
CSV.foreach(data/company_var.csv) do |row|
company  Kconv.kconv(row.join(','),Kconv::UTF8)
end

$company_code   = company[1].split(',').last.to_s
$company_name   = company[2].split(',').last.to_s
$zip_code = company[3].split(',').last.to_s
$select_prefecture = company[4].split(',').last.to_s
$select_prefecture2 = company[5].split(',').last.to_s
$address_district = company[6].split(',').last.to_s

something like that.
then you can use that values
-Test case file-
require 'import'

some test code...
$company_name...

But,Maybe someone knows more simple and smart way.

Hope it help you.
It is work,I use it for job too.
tknv/

On Mon, Jul 27, 2009 at 1:39 AM, Chris
McMahonchristopher.mcma...@gmail.com wrote:



 On Jul 25, 9:03 am, RAM rahulbhai...@gmail.com wrote:
 Hi allI am very new to Watiranybody here knows how to
 import value from  .CSV files and Export Results into an .CSV file in
 Watir.
 Please reply and provide links if similar subject is already posted.

 I wrote a toy framework that does exactly this:
 http://chrismcmahonsblog.blogspot.com/2009/04/ui-test-framework-design-using-watir.html

 Please let us know if that is useful.

 -Chris
 




-- 
tknv/

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to 
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---



[wtr-general] Re: Data driven test using .CSV file

2009-07-26 Thread takanobu watanabe

Sorry spread it.
This is that CSV sample.
--
ID,mnemonic,var-name,value
1,companycode,company_code,51236
2,companyname,company_name,Watir corp
3,company-zip-code,zip_code,111011
4,company-prefecture,select_prefecture,MA
5,company-prefecture for update,select_prefecture2,TT
6,company address,address_district,Gossam city
--
Just last var is used.

On Mon, Jul 27, 2009 at 2:47 PM, takanobu watanaberreedd...@gmail.com wrote:
 miscode
 mhc = Array::new
 |
 V
 company = Array::new

 On Mon, Jul 27, 2009 at 2:46 PM, takanobu watanaberreedd...@gmail.com wrote:
 I use CSV like that below

 -import.rb-(csv import)-
 #! ruby -Ku
 #!/usr/bin/env ruby

 require 'csv'

 $KCODE = 'UTF8'

 #import company-data settings
    mhc = Array::new
    CSV.foreach(data/company_var.csv) do |row|
    company  Kconv.kconv(row.join(','),Kconv::UTF8)
    end

    $company_code       = company[1].split(',').last.to_s
    $company_name       = company[2].split(',').last.to_s
    $zip_code = company[3].split(',').last.to_s
    $select_prefecture = company[4].split(',').last.to_s
    $select_prefecture2 = company[5].split(',').last.to_s
    $address_district = company[6].split(',').last.to_s

 something like that.
 then you can use that values
 -Test case file-
 require 'import'

 some test code...
 $company_name...

 But,Maybe someone knows more simple and smart way.

 Hope it help you.
 It is work,I use it for job too.
 tknv/

 On Mon, Jul 27, 2009 at 1:39 AM, Chris
 McMahonchristopher.mcma...@gmail.com wrote:



 On Jul 25, 9:03 am, RAM rahulbhai...@gmail.com wrote:
 Hi allI am very new to Watiranybody here knows how to
 import value from  .CSV files and Export Results into an .CSV file in
 Watir.
 Please reply and provide links if similar subject is already posted.

 I wrote a toy framework that does exactly this:
 http://chrismcmahonsblog.blogspot.com/2009/04/ui-test-framework-design-using-watir.html

 Please let us know if that is useful.

 -Chris
 




 --
 tknv/




 --
 tknv/




-- 
tknv/

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to 
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---



[wtr-general] Re: Data driven test using .CSV file

2009-07-26 Thread takanobu watanabe

miscode
mhc = Array::new
|
V
company = Array::new

On Mon, Jul 27, 2009 at 2:46 PM, takanobu watanaberreedd...@gmail.com wrote:
 I use CSV like that below

 -import.rb-(csv import)-
 #! ruby -Ku
 #!/usr/bin/env ruby

 require 'csv'

 $KCODE = 'UTF8'

 #import company-data settings
    mhc = Array::new
    CSV.foreach(data/company_var.csv) do |row|
    company  Kconv.kconv(row.join(','),Kconv::UTF8)
    end

    $company_code       = company[1].split(',').last.to_s
    $company_name       = company[2].split(',').last.to_s
    $zip_code = company[3].split(',').last.to_s
    $select_prefecture = company[4].split(',').last.to_s
    $select_prefecture2 = company[5].split(',').last.to_s
    $address_district = company[6].split(',').last.to_s

 something like that.
 then you can use that values
 -Test case file-
 require 'import'

 some test code...
 $company_name...

 But,Maybe someone knows more simple and smart way.

 Hope it help you.
 It is work,I use it for job too.
 tknv/

 On Mon, Jul 27, 2009 at 1:39 AM, Chris
 McMahonchristopher.mcma...@gmail.com wrote:



 On Jul 25, 9:03 am, RAM rahulbhai...@gmail.com wrote:
 Hi allI am very new to Watiranybody here knows how to
 import value from  .CSV files and Export Results into an .CSV file in
 Watir.
 Please reply and provide links if similar subject is already posted.

 I wrote a toy framework that does exactly this:
 http://chrismcmahonsblog.blogspot.com/2009/04/ui-test-framework-design-using-watir.html

 Please let us know if that is useful.

 -Chris
 




 --
 tknv/




-- 
tknv/

--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups 
Watir General group.
To post to this group, send email to watir-general@googlegroups.com
Before posting, please read the following guidelines: 
http://wiki.openqa.org/display/WTR/Support
To unsubscribe from this group, send email to 
watir-general-unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/watir-general
-~--~~~~--~~--~--~---