[wtr-general] Re: Export entire html table to a text document
Thank you for your reply. After re-reading what I have written and thinking about what I what to achieve... I don't believe I want to extract the table data into excel. I would like to extract it to a .txt (notepad document). The purpose of extracting the data is to check it against it against what I have in my database :-). If I can get it into .txt file (notepad document) I have the know-how to clean it and import it into sql for validation. FYI the data in the table looks like this... table border=1 cellpadding=2trth Address /thth Council tax band /thth Annual council tax /th/tr trtd 2, STONELEIGH AVENUE, COVENTRY, CV5 6BZ /tdtd align=center F /tdtd align=center pound;2125 /td/tr ... The above row is repeated many time .. /table Then the table is closed. So to re-cap my situation. I can use Watir to navigate the browser to the page containing the html table but my problem is that I am unsure of how to extract the results (everything within the table tag - including the html) to a .txt file and then save that .txt file onto my computer. I would prefer to take smaller steps with using Watir. I am knew to it therefore I would just like to learn how to extract the table and save everything that I have extracted into a .txt file. I have seen a couple of examples online using hpricot. However most of the examples seem to miss off code detailing how the array (if that is the correct approach) is outputted into a .txt file. Could you help by demonstrating how to write a simple piece of code which will extract the html table ( and everything, including the tr, td and everything in between) to a .txt notepad file? Many thanks for your time. On Dec 2, 2:36 am, bis bis...@gmail.com wrote: To me that sounds like a lot of extra work what happens once it is in an excel? Why would putting it in an excel be better than asserting it all within the test itself So I'll go ahead and ask some questions first. Will it happen more than once validating the excel? What sort of data is in the table? Would you be comparing the data in the excel vs data in a data base? If yes, why not let the test do it? Sent from my iPhone On Dec 1, 2011, at 4:43 PM, Mark Ballinger mark.j.ballin...@gmail.com wrote: Hi I am a newbie to groups and to ruby, watir, watir-webdriver etc... Basically all I would like to do is export a table from a web page which I have instructed the browser to find using Watir-webdriver. I just want to take the whole contents of the html table and place it into Excel for further analysis. I have the got the following code to work: require 'rubygems' require 'hpricot' require watir-webdriver url = http://www.mycounciltax.org.uk/results? postcode=cv35+8ausearch=Search browser = Watir::Browser.new browser.goto url All i would like to do now is save the table. How do save the html to a csv or .txt file into my C;\Temp folder? Best Regards, Mark -- Before posting, please readhttp://watir.com/support. In short: search before you ask, be nice. watir-general@googlegroups.com http://groups.google.com/group/watir-general watir-general+unsubscr...@googlegroups.com -- Before posting, please read http://watir.com/support. In short: search before you ask, be nice. watir-general@googlegroups.com http://groups.google.com/group/watir-general watir-general+unsubscr...@googlegroups.com
[wtr-general] Re: Export entire html table to a text document
Although it won't capture the HTML tags, you can dump the contents of a table like this: table_contents = browser.table(:id, 'foo').to_a For writing to .txt file, check out the ruby File class: http://www.ruby-doc.org/core-1.9.3/File.html This is an example for writing the HTML for a page to a file: browser.goto(test_site) html = browser.html f = File.new(txt.txt, w+) f.write(html) f.close Hope it helps. orde On Dec 2, 1:42 am, Mark Ballinger mark.j.ballin...@gmail.com wrote: Thank you for your reply. After re-reading what I have written and thinking about what I what to achieve... I don't believe I want to extract the table data into excel. I would like to extract it to a .txt (notepad document). The purpose of extracting the data is to check it against it against what I have in my database :-). If I can get it into .txt file (notepad document) I have the know-how to clean it and import it into sql for validation. FYI the data in the table looks like this... table border=1 cellpadding=2trth Address /thth Council tax band /thth Annual council tax /th/tr trtd 2, STONELEIGH AVENUE, COVENTRY, CV5 6BZ /tdtd align=center F /tdtd align=center pound;2125 /td/tr ... The above row is repeated many time .. /table Then the table is closed. So to re-cap my situation. I can use Watir to navigate the browser to the page containing the html table but my problem is that I am unsure of how to extract the results (everything within the table tag - including the html) to a .txt file and then save that .txt file onto my computer. I would prefer to take smaller steps with using Watir. I am knew to it therefore I would just like to learn how to extract the table and save everything that I have extracted into a .txt file. I have seen a couple of examples online using hpricot. However most of the examples seem to miss off code detailing how the array (if that is the correct approach) is outputted into a .txt file. Could you help by demonstrating how to write a simple piece of code which will extract the html table ( and everything, including the tr, td and everything in between) to a .txt notepad file? Many thanks for your time. On Dec 2, 2:36 am, bis bis...@gmail.com wrote: To me that sounds like a lot of extra work what happens once it is in an excel? Why would putting it in an excel be better than asserting it all within the test itself So I'll go ahead and ask some questions first. Will it happen more than once validating the excel? What sort of data is in the table? Would you be comparing the data in the excel vs data in a data base? If yes, why not let the test do it? Sent from my iPhone On Dec 1, 2011, at 4:43 PM, Mark Ballinger mark.j.ballin...@gmail.com wrote: Hi I am a newbie to groups and to ruby, watir, watir-webdriver etc... Basically all I would like to do is export a table from a web page which I have instructed the browser to find using Watir-webdriver. I just want to take the whole contents of the html table and place it into Excel for further analysis. I have the got the following code to work: require 'rubygems' require 'hpricot' require watir-webdriver url = http://www.mycounciltax.org.uk/results? postcode=cv35+8ausearch=Search browser = Watir::Browser.new browser.goto url All i would like to do now is save the table. How do save the html to a csv or .txt file into my C;\Temp folder? Best Regards, Mark -- Before posting, please readhttp://watir.com/support. In short: search before you ask, be nice. watir-general@googlegroups.com http://groups.google.com/group/watir-general watir-general+unsubscr...@googlegroups.com -- Before posting, please read http://watir.com/support. In short: search before you ask, be nice. watir-general@googlegroups.com http://groups.google.com/group/watir-general watir-general+unsubscr...@googlegroups.com
[wtr-general] Re: Export entire html table to a text document
I'm writing this off the cuff so it might need a bit of debugging. browser.table(:how = what).rows.each_with_index do |row, r| row.cells.each_with_index do |cell, c| puts Row:#{r} Cell:#{c} text is: #{cell.text} end end if .rows or .cells does not work in the above, try replacing with .trs and .tds respectively (not all versions of watir have the friendly aliases for those) See if that spits out what you are interested in. If so, modify to write what you want to a file instead of putting it to the screen.. Or better yet, you could put things into an array (using the index values) and then iterate over the array comparing data from particular cells with what's in the database. You could probably even create your own 'table_text_to_array' method which would accept a table object as input and return an array There are some useful ruby gems for accessing databases, so it should not be too hard (once you are clear about the format of the text in the cells vs in your database) to verify the data presented in the web UI matches the database On Dec 2, 1:42 am, Mark Ballinger mark.j.ballin...@gmail.com wrote: Thank you for your reply. After re-reading what I have written and thinking about what I what to achieve... I don't believe I want to extract the table data into excel. I would like to extract it to a .txt (notepad document). The purpose of extracting the data is to check it against it against what I have in my database :-). If I can get it into .txt file (notepad document) I have the know-how to clean it and import it into sql for validation. FYI the data in the table looks like this... table border=1 cellpadding=2trth Address /thth Council tax band /thth Annual council tax /th/tr trtd 2, STONELEIGH AVENUE, COVENTRY, CV5 6BZ /tdtd align=center F /tdtd align=center pound;2125 /td/tr ... The above row is repeated many time .. /table Then the table is closed. So to re-cap my situation. I can use Watir to navigate the browser to the page containing the html table but my problem is that I am unsure of how to extract the results (everything within the table tag - including the html) to a .txt file and then save that .txt file onto my computer. I would prefer to take smaller steps with using Watir. I am knew to it therefore I would just like to learn how to extract the table and save everything that I have extracted into a .txt file. I have seen a couple of examples online using hpricot. However most of the examples seem to miss off code detailing how the array (if that is the correct approach) is outputted into a .txt file. Could you help by demonstrating how to write a simple piece of code which will extract the html table ( and everything, including the tr, td and everything in between) to a .txt notepad file? Many thanks for your time. On Dec 2, 2:36 am, bis bis...@gmail.com wrote: To me that sounds like a lot of extra work what happens once it is in an excel? Why would putting it in an excel be better than asserting it all within the test itself So I'll go ahead and ask some questions first. Will it happen more than once validating the excel? What sort of data is in the table? Would you be comparing the data in the excel vs data in a data base? If yes, why not let the test do it? Sent from my iPhone On Dec 1, 2011, at 4:43 PM, Mark Ballinger mark.j.ballin...@gmail.com wrote: Hi I am a newbie to groups and to ruby, watir, watir-webdriver etc... Basically all I would like to do is export a table from a web page which I have instructed the browser to find using Watir-webdriver. I just want to take the whole contents of the html table and place it into Excel for further analysis. I have the got the following code to work: require 'rubygems' require 'hpricot' require watir-webdriver url = http://www.mycounciltax.org.uk/results? postcode=cv35+8ausearch=Search browser = Watir::Browser.new browser.goto url All i would like to do now is save the table. How do save the html to a csv or .txt file into my C;\Temp folder? Best Regards, Mark -- Before posting, please readhttp://watir.com/support. In short: search before you ask, be nice. watir-general@googlegroups.com http://groups.google.com/group/watir-general watir-general+unsubscr...@googlegroups.com -- Before posting, please read http://watir.com/support. In short: search before you ask, be nice. watir-general@googlegroups.com http://groups.google.com/group/watir-general watir-general+unsubscr...@googlegroups.com