Dutch

I just logged in specifically looking for how to use Python with Ubot. Thanks for offering the training!

I just logged in specifically looking for how to use Python with Ubot. Thanks for offering the training!

Here's a Multi Threading Example that TJ helped me with that processes a list with 3 elements per row. I originally tried to use TJ's Advanced example using Tables but found that the multi threading was either missing rows entirely or doubling up on rows. This was primarily due to the fact that the table row value was incremented at the end of each cycle and is a global setting not a local setting. This allowed multiple threads to attempt to increment the table row value at the same time and resulted in almost certain misses in the processing. Following is a complete example for Multi Threa

Hi All, I have two csv files - YesterTest.csv and TodayTest.csv.. I want to start at row 0, col 0 of, TodayTest and then search for that value in col 0 of YesterTest.. Once I find that match I want to compare the values in row 0, col 1 of TodayTest to the row and col 1 of YesterTest. If they do not match, I want to write out the row 0, col 0 and 1 value of TodayTest to the ToDo file. Finally, I want to do the same thing for all the rest of the rows in TodayTest. Right now the code almost works but it's grabbing additional values that have not changed. Any ideas on how to fix this code?

I don't like bank either. How about bot library? :

Hi, I'm looking for a cloud storage solution that will allow me to create multiple levels of folders and files as the output from a bot. From there I want multiple users in multiple locations to be able to access and work with the files and folders. I know about dropbox but that requires users to download an app to their pc to get the best access. Do you folks have any cloud solutions and recommendations for this purpose? Thanks, Ken

Sweet! That works great! Thanks for your help! Ken

I have users that are running a bot on different PCs that have different paths to Excel 2010. Does anyone know how to format the shell command so that it will look in either one location or the other? I've not been successful with using variables or functions within the shell statement. I've tried running: shell("C:\\Program Files\\Microsoft Office\\Office14\\EXCEL.EXE") shell("C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE") but if the first one fails the bot stops and errors out. Thanks, Ken

Doesn't one of your "name" values need to be variable?

I appreciate your trying to help. I am trying to scrape those specific tags. The problem is that I am converting the XML page results from the YouTube results page that Ubot won't read to the xmlgrid format that can be read by Ubot. I'd love to grab the actual tag names above but in the xmlgrid they are aliased to a new id value that changes every time a new file is loaded. If I determine that the xlmgrid id for the totalResults = 674 when I'm setting up the scrape and then run the bot with a new search term, the id is different and the scrape fails.

I'm trying to $page scrape the value that's between the xml tags on the following youtube results page. Any idea on how to accomplish this? ui text box("Keyword", #Keyword) set(#Keyword, $replace(#Keyword, " ", "+"), "Global") navigate("https://gdata.youtube.com/feeds/api/videos?q={#Keyword}", "Wait") set(#StartIndex, $page scrape("<openSearch:startIndex>", "</openSearch:startIndex>"), "Global") set(#ItemsPerPage, $page scrape("<openSearch:itemsPerPage>", "</openSearch:itemsPerPage>"), "Global") set(#TotalSearchResults, $page scrape("<openSearch:totalResults>",

Caribou Coffee locations are scattered around the USA (http://www.cariboucoffee.com/). They, like other coffee shops, have an annoying survey that if you fill it out will let you save $1.00 on your order. I know, it's not much, but every little bit helps The employees - barristas or whatever they are called - get extra credit and who knows what else when people actually fill out the surveys and turn them back in. So, I created a bot to automatically fill in the survey. I'm sure there are lots of improvements botters here could make to improve this bot but the bottom line is that it works as

please add me too - ken.vermeer

Or, if you're really trying to spin the results without duplicating the words in the phrase you might want to try something like this (v4.x): ui text box("Word 1", #w1) ui text box("Word 2", #w2) ui text box("Word 3", #w3) set(#Result, $spin("\{{#w1} {#w2} {#w3}|{#w1} {#w3} {#w2}|{#w2} {#w1} {#w3}|{#w2} {#w3} {#w1}|{#w3} {#w1} {#w2}|{#w3} {#w2} {#w1}\}"), "Global") load html(#Result) Dutch

I'm trying to use $scrape table to scrape a table that extends over many pages. How do you scrape a table on one page and then go to the next page, scrape the table on that page and add it to the end of the previously scraped page. I really don't want to have a file for each page/table that it scrapes. Any suggestions? Dutch

Or, you can paste this code in the code view in v4 and it will display whatever you put in the search bot on a blank browser results page. ui text box("Search Term", #SearchTerm) navigate("http://www.google.com/", "Wait") type text(<name="q">, #SearchTerm, "Standard") wait(2) add list to list(%listresultsinnertext, $scrape attribute(<class="gsq_a">, "innertext"), "Delete", "Global") load html(%listresultsinnertext)

Is there a way to get a list of the folders in another folder? I know we have $Get Files but how do I $Get Folders?

I took a stab at checking email addresses with the following code (v4) but it's currently not grabbing all of the emails I'm sending it. I'm sure I messed up on something in the script. Please take a look and let me know what I've messed up. Thanks! ui open file("Email List", #emailist) ui save file("Save File To?", #savefile) clear list(%email2test) clear list(%emailverified) add list to list(%email2test, $list from file(#emailist), "Delete", "Global") loop($list total(%email2test)) { navigate("http://www.ip-address.org/verify/email-checker.php", "Wait") set(#emailAddress, $next lis

Hi Admin - Any updates on this issue? I'm using 4.0.69. This is happening (I think) fewer times but it really messes me up when I'm searching 20+ keywords and various keywords don't scrape all of the results. Here's the command I'm using: add list to list(%Title2, $scrape attribute(<class="l">, "innertext"), "Don\'t Delete", "Global") add list to list(%urls, $scrape attribute(<class="l">, "href"), "Don\'t Delete", "Global") Thanks!

That now works - does it also work with tables (multi-column lists)?

I'm using 4.0.66 and can't get list values to populate either UI List box ro UI Dropdown. I thought this had been corrected in an earlier release. Here's an example: clear table(&DealerVehicles) clear list(%VehicleYear) clear list(%VehicleYear2) create table from file("{$special folder("Desktop")}\\Vehicles.csv", &DealerVehicles) set(#rowDealerVehicles, 1, "Global") loop($table total rows(&DealerVehicles)) { add item to list(%VehicleYear2, $table cell(&DealerVehicles, #rowDealerVehicles, 1), "Don\'t Delete", "Global") increment(#rowDealerVehicles) } add list to list

What's the difference between the 2, and how do you select both in a single scrape? When I try to use the Advanced Element Editor in v4 to select <A class=l onmousedown=* I get an invalid element error msg. Please post an example of the method you're proposing. Here's what I'm currently using: add list to list(%Title2, $scrape attribute(<class="l">, "innertext"), "Don\'t Delete", "Global")

I scraping the first page of Google search results for multiple keywords. In the scrape I'm using <a class="l" for the element. Some keywords return all 10 page results. Others, seemingly at random, do not. The ones that don't get them all have the element in the html. It appears to be the first link that's missing. The ones that fail show 9 links. I've tried increasing the wait time between the search and the scrape but this doesn't seem to make any difference. Any ideas?

I'm trying to create a bot that scrapes Google search results for multiple keywords and then outputs the results into a csv file that shows the search keyword in column 0 the search results page location in column 1, the search results title in column 2 and the url in column 3. for instance: I can fill in a single row with the keyword but not multiple rows. I also don't know how to count and increment the search results. Does anyone have a v4.x example that accomplishes this? Thanks, Dutch