spa3212 1 Posted May 15, 2016 Report Share Posted May 15, 2016 I wants to create a bot..which is very simple just involve few steps hope you can help.. 1. bot will open list of urls from a url.csv file2. search for a text on page if found will say yes and "yes will be saved to 1.csv file" and if not found will type "No" in the same 1.csv in next row..3 this will go in loop using all urls of url.csv Thats all.. But if possible...if we can add yes or no in next column of url.csv file instead of created new csv file. please help..I tried a lot but everytime bot is not able to add yes or no..items in new csv.. Thanks in advance. Quote Link to post Share on other sites
Bot-Factory 602 Posted May 15, 2016 Report Share Posted May 15, 2016 I wants to create a bot..which is very simple just involve few steps hope you can help.. 1. bot will open list of urls from a url.csv file2. search for a text on page if found will say yes and "yes will be saved to 1.csv file" and if not found will type "No" in the same 1.csv in next row..3 this will go in loop using all urls of url.csv Thats all.. But if possible...if we can add yes or no in next column of url.csv file instead of created new csv file. please help..I tried a lot but everytime bot is not able to add yes or no..items in new csv.. Thanks in advance.Hello. Please share your code and show us where you struggle exactly. Kindest regardsDan Quote Link to post Share on other sites
spa3212 1 Posted May 16, 2016 Author Report Share Posted May 16, 2016 I don't know if this help..coz I am new to ubot.. ui open file("Get CSV", #CSVfile)ui text box("keyword number", #picknumber)set(#row, #picknumber, "Global")create table from file(#CSVfile, &keywordcsv)define checkvideo { navigate("https://google.com/ncr","Wait") wait(5) type text(<name="q">, $table cell(&keywordcsv, #row, 0), "Standard") wait(5) click(<login button>, "Left Click", "No") if($search page("youtube.com")) { then { } else { } }} I stuck under if command.. Now I want if youtube.com found on search page then bot should create a csv file and type yes else no..for all keyword and then move to next keyword do the same.. please help.. Quote Link to post Share on other sites
pash 504 Posted May 16, 2016 Report Share Posted May 16, 2016 not test. ui open file("Get CSV",#CSVfile) ui text box("keyword number",#picknumber) set(#row,#picknumber,"Global") create table from file(#CSVfile,&keywordcsv) save to file("{$special folder("Desktop")}\\report.csv","Keyword,Found") define checkvideo { navigate("https://google.com/ncr","Wait") wait(5) set(#keyword,$table cell(&keywordcsv,#row,0),"Global") type text(<name="q">,#keyword,"Standard") wait(5) click(<login button>,"Left Click","No") if($search page("youtube.com")) { then { append to file("{$special folder("Desktop")}\\report.csv","{$new line}{#keyword},yes","End") } else { append to file("{$special folder("Desktop")}\\report.csv","{$new line}{#keyword},no","End") } } } Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.