[wtr-general] Re: Data driven test using .CSV file
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
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
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
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
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 -~--~~~~--~~--~--~---