13lack13lade

nevermind found my issue!!! $var5 = WinWait("blahblah " & _NowDate() & " " & _NowTime(),40) should be $var5 = WinWait("blahblah " & _NowDate() & " " & _NowTime(),"",40) lol... attention to detail people!

Hi, I have a title that contains date and time for example: blahblah 28/09/2017 11:45:35 AM and I have a script that needs to wait till that window is active, then continue else exit 'cannot find window' So wrote this: $var5 = WinWait("blahblah " & _NowDate() & " " & _NowTime(),40) if $var5 = 0 then msgbox(0,"Window did not appear", "blahblah main window did not appear in time, exiting macro") Exit EndIf Now i know that "blahblah " + _NowDate() + _NowTime() = should give me the correct result if i am right in thinking that winwait runs the window check every 250ms, however my query just pauses and does nothing, even after 40 seconds it does not time out... ? Does WinWait re-run the title check and thus updating the NowTime every 250ms? or what is the best way to solve this problem so it will activate the window and also why is the statement not timing out? I cant use class as : WindowsForms10.Window.8.app.0.30495d1_r32_ad1 sometimes the end bit changes R32 might be R6 etc.

Slacker, unfortunately that does not work as i cannot control the object using usual methods for some reason that is the whole dilemma. Fortunately InnI has provided a solution for me! - Thank you !!!! will be using this IUIAutomation in the future !!!!!!

Hi Innl Thanks for your help! The only one that works is : ControlSend("Personal Options", "", "[NAME:chkShortPortfolios]", "{space}") and that is not viable as the checkbox might already be ticked in which case that would uncheck it.

Hi All! Feel like a noob here but im trying to get the status of a check box or just simply set it to checked. I have tried controlclick, controlcommand, without luck... i think it is due to only being able to select the checkbox by name... Here is the autoit window info:

You will need to activate the window, or controlsend to that window. However, that's all the help your going to get considering this is definitely a gaming script.....

lol decompiled gaming pixelbot folder next to trash can at the top, followed by a pls fix my instagram keybot program............................................. makes me giggle.

Its okay, i found a workaround solution... i simply spread the data across the spreadsheet rather than down. that way it will send the first data before the second, thus removing any conflict. Heres what i mean: controlsend($wt,"","","{ENTER}") controlsend($wt2,"","","{ENTER}") controlsend($wt3,"","","{ENTER}") controlsend($wt4,"","","{ENTER}")

That is how i am doing it, but they seem to be interfering with each other... This is the script, and i simply created another one with the window name being different for the otherscript $wt = 'cal2' Can you controlsend different keystrokes to different windows simultaneously ? e.g send key a to window a and key b to window b at the same time? #include <Excel.au3> ; open a page $oExcel = _Excel_Open() $wkbk = _Excel_BookOpen($oExcel,"servereditedout\OMNI FIX 011116.xlsx") sleep(5000) For $i = 2 To 3 ;Loop $a = _Excel_RangeRead($wkbk, default,"a"&$i, 1) $b = _Excel_RangeRead($wkbk, default,"b"&$i,1) $c = _Excel_RangeRead($wkbk, default,"c"&$i,1) ;need to update $d = _Excel_RangeRead($wkbk, default,"d"&$i,1) $e = _Excel_RangeRead($wkbk, default,"e"&$i,1) $f = _Excel_RangeRead($wkbk, default,"f"&$i,1) $g = _Excel_RangeRead($wkbk, default,"g"&$i,1) $h = _Excel_RangeRead($wkbk, default,"H"&$i,1) $j = _Excel_RangeRead($wkbk, default,"j"&$i,1) $k = _Excel_RangeRead($wkbk, default,"k"&$i,1) $l = _Excel_RangeRead($wkbk, default,"l"&$i,1) $m = _Excel_RangeRead($wkbk, default,"m"&$i,1) $n = _Excel_RangeRead($wkbk, default,"n"&$i,1) $o = _Excel_RangeRead($wkbk, default,"o"&$i,1) $p = _Excel_RangeRead($wkbk, default,"p"&$i,1) $q = _Excel_RangeRead($wkbk, default,"q"&$i,1) $wt = "cal1" sleep(5000) controlsend($wt,"","",$a) sleep(250) controlsend($wt,"","","{F3}") sleep(250) controlsend($wt,"","",$c) sleep(250) controlsend($wt,"","",$d) sleep(250) controlsend($wt,"","","{TAB}") sleep(250) controlsend($wt,"","",$f) sleep(250) controlsend($wt,"","",$g) sleep(250) controlsend($wt,"","",$h) sleep(250) controlsend($wt,"","","{ENTER}") sleep(2000) controlsend($wt,"","",$j) sleep(250) controlsend($wt,"","",$k) sleep(250) controlsend($wt,"","","{TAB 3}") sleep(250) controlsend($wt,"","",$m) sleep(250) controlsend($wt,"","","{TAB}") sleep(250) controlsend($wt,"","",$o) sleep(50) controlsend($wt,"","","{F7}") sleep(50) controlsend($wt,"","","{F1}") Next

Hi All, I have a problem at work where i am wanting to read of one excel spreadsheet, and have the same script starting at different points, sending to two separate windows (two separate netterm.exe clients) The problem I seem to be having is sending DIFFERENT keystrokes simultaneously via ControlSend to two separately named windows 'cal1' 'cal2' which each script specifically refers to however the controlsends seem to interact with each other.. Is there a way to get around this?

Hi All, So i have a cached table and i have some text boxes to search and im a little stuck, i know how to set it up so that if your running the search vs a live sql connection against stored procedures however when it comes to cached tables im not sure how to do it. Basically i have set it so the table will load and cache, then i want to make the applciation search that cached table so that the person can always search on the data weather or not there is a connection to the database (so always searching against the cached table) There are only three search parameters which are two date fields (to give a date between) and 1 field is a 3 letter Code. the code i want to equal to whatever they say + '%' so that they do not need to enter it but they do need to enter the dates. How can i do this? Front page image attached and this is the Current Code with attempted filtering: using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Data; namespace WebApplication5 { public partial class WebForm1 : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (Cache["Data"] == null) { using (SqlConnection con = new SqlConnection("server=TOMSKEEZ-PC;database=MoneyBMine;integrated security=SSPI")) { SqlDataAdapter da = new SqlDataAdapter("select * from NYSE_daily_price", con); if (Cache["Data"] != null) { Cache.Remove("Data"); } //set results to table DataSet ds = new DataSet(); da.Fill(ds, "Data"); Cache.Insert("Data", ds); GridView1.DataSource = ds; GridView1.DataBind(); con.Close(); } } else { DataSet ds = (DataSet)Cache["Data"]; GridView1.DataSource = ds; GridView1.DataBind(); if (Cache["Data"] == null) { Label1.Text = "No data available, please wait until connection to database is available and try again."; } } } protected void Button1_Click(object sender, EventArgs e) { DataSet ds = (DataSet)Cache["Data"]; DataRow[] foundRows; foundRows = ds.Tables["NYSE_daily_price"].Select("stock_symbol Like " + TxtStockSym.Text + "'%' and date between " + TxtDateFrom.Text + " and " + TxtDateTo.Text); GridView1.DataSource = foundRows; GridView1.DataBind(); } } }

might just get them to keep using chrome screen scraper.. unless anyone has any other suggestions?

Hi Guys, I am wondering if there is a way to do data/screen scraping more effectively or even just automate some of processes. We currently are outsourcing this by having a bunch of people troll through certain websites to obtain prices for price comparision.. and i believe they use chrome scraper extension to get the data and put it into an excel spreadsheet. Just wondering if there is any awesome autoit script that someone has created or if i should look into creating one and how hard would that be? Has anyone done anything like this before and could help point me in the right direction?

No problems at all, it was doing my head in however the problem was not my code it was with the way i was calling the issue type, it was documented wrong in Jira documentation -.- .... sorted now, thanks for your help guinness <!-- @@Formula: if (issue.get("issuetype") == "Specials") { if (issue.get("resolutiondate") == null || issue.get("customfield_10007")==null) return null; else if ((issue.get("resolutiondate").getTime() - issue.get("customfield_10007").getTime()) / (1000*60*60*24) <1) return 0; else return (issue.get("resolutiondate").getTime() - issue.get("customfield_10007").getTime()) / (1000*60*60*24); } else { if (issue.get("resolutiondate") == null || issue.get("customfield_10002")==null) return null; else if ((issue.get("resolutiondate").getTime() - issue.get("customfield_10002").getTime()) / (1000*60*60*24) <1) return 0; else return (issue.get("resolutiondate").getTime() - issue.get("customfield_10002").getTime()) / (1000*60*60*24); } -->

How do you edit the title? lol moderation just comes up with delete.. soz for the noob:(

Yep, thought it was java originally however its actually javascript. If you could edit the title to be javascript instead of java that would be good.

hmm so i got everything working but now im having abit of trouble with nested if statements.. i thought this was correct but its not working, i even put it into JSLint and it didnt manage to show me any errors -.- Its always the friggin if statements that get me, What have i done wrong here? happy to fix the code myself if anyone can help hint me in the right direction.. i looked on dotnetperls at if statements and a few other places but to me it seems right but then again, im no expert <!-- @@Formula: If (issue.issueTypeObject.name == "Specials") { if (issue.get("resolutiondate") == null || issue.get("customfield_10007")==null){ return null; } else if ((issue.get("resolutiondate").getTime() - issue.get("customfield_10007").getTime()) / (1000*60*60*24) <1){ return 0; } else { return (issue.get("resolutiondate").getTime() - issue.get("customfield_10007").getTime()) / (1000*60*60*24) } } Else { if (issue.get("resolutiondate") == null || issue.get("customfield_10002")==null){ return null; } else if ((issue.get("resolutiondate").getTime() - issue.get("customfield_10002").getTime()) / (1000*60*60*24) <1){ return 0; } Else { return (issue.get("resolutiondate").getTime() - issue.get("customfield_10002").getTime()) / (1000*60*60*24); } } --> What im trying to do is join two bits of code together with the condition : If (issue.issueTypeObject.name == "Specials") if so do this: <!-- @@Formula: if (issue.get("resolutiondate") == null || issue.get("customfield_10007")==null) return null; else if ((issue.get("resolutiondate").getTime() - issue.get("customfield_10007").getTime()) / (1000*60*60*24) <1) return 0; else return (issue.get("resolutiondate").getTime() - issue.get("customfield_10007").getTime()) / (1000*60*60*24); --> otherwise do this: <!-- @@Formula: if (issue.get("resolutiondate") == null || issue.get("customfield_10002")==null) return null; else if ((issue.get("resolutiondate").getTime() - issue.get("customfield_10002").getTime()) / (1000*60*60*24) <1) return 0; Else return (issue.get("resolutiondate").getTime() - issue.get("customfield_10002").getTime()) / (1000*60*60*24) --> Does javascript work the same way as autoit with functions? e.g could i just put these into a function and then use the if statement to return/call the function? **EDIT** Tried using functions, didnt work either, this was the code i used <!-- @@Formula: If (issue.issueTypeObject.name == "Specials"){ return Specials() } Else { return Updates() } function Specials(){ if (issue.get("resolutiondate") == null || issue.get("customfield_10007")==null) return null; else if ((issue.get("resolutiondate").getTime() - issue.get("customfield_10007").getTime()) / (1000*60*60*24) <1) return 0; else return (issue.get("resolutiondate").getTime() - issue.get("customfield_10007").getTime()) / (1000*60*60*24); } function Updates(){ if (issue.get("resolutiondate") == null || issue.get("customfield_10002")==null) return null; else if ((issue.get("resolutiondate").getTime() - issue.get("customfield_10002").getTime()) / (1000*60*60*24) <1) return 0; Else return (issue.get("resolutiondate").getTime() - issue.get("customfield_10002").getTime()) / (1000*60*60*24) } -->

There is not a large amount of java needed at all for the set up of jira.. i have managed to set the entire thing up from scratch and they are aware of my abilities. The only things java is required for are ideas that are out of the business scope of the project that iv'e thought of to make a bigger impact on roll out. This is my first java question ? and i am a script writer advanced in VBA and am now quite familiar with autoit and have used it on a few projects at my work. They would rather i set up Jira and ask for help because im good at researching rather than paying the company $250-500 per hour which is what service rocket charge to setup etc. This project is only with me until roll out then will be handed over to systems support i have a software development diploma in C#, SQL etc.. i just get intimidated by new languages they always seem harder than they actually are to wrap your head around. Normally i am more of a database administrator this is my first attempt at a project like this, i am moving towards project management / system development... career path has to start somewhere i just decided to start in the deep end so far so good! i do appreciate your help though guinness as well as your concern, this is not my role infact the entire project was handed to me as an opportunity to act as a Business Analyst, i am a data analyst / automation specialist by trade.

Hey Guys, So i've just implemented Jira at my work and was given the task of being system administrator and configuring everything which is good experience for me for coding somethign other than autoit/basic however i know nothing about java. Would anyone be able to help me by adding that if the custom_field in this code is less than 0 , so a minus number to then change the value to 0? i also have more code to exclude weekends and only account for workdays but im not sure how to incorporate that either, if i paste that code too can anyone help me with that also if its not too much trouble. <!-- @@Formula: if (issue.get("resolutiondate") == null || issue.get("customfield_10007")==null) return null; return (issue.get("resolutiondate").getTime() - issue.get("customfield_10007").getTime()) / (1000*60*60*24); --> Also would anyone happen to have some good sites to help me learn some very basic java... i know theres nothing like this forum for any other language but any sort of materials to help me would be great, i am a complete noobie too it and i cant seem to get it right

game botting is not allowed on this forum, you're welcome to read through the help files and other examples on the forum of how certain things are done and then use that knowledge to create things for your own needs. what you are after is not too difficult to create, keep trying and researching and you will figure it out.

i think that your code could be wrong, water can confirm but shouldn't it be like this: Local $oAppl = _Excel_Open() Local $sWorkbook = "C:\Example.xlsm" Local $oWorkbook = _Excel_BookOpen($oAppl, $sWorkbook) $oAppl.Run("DEFAULT_MACRO"); if your macro name is default_macro you do not need to include the sheet name, also you need to run the macro on the application not the workbook i also never had any luck in running VBA with excel hidden.. easier just to let it open run the macro then close imo.. but i could be wrong

I tried it without the trailing backslash and still no dice. i had to manually od it like this (snippet below): which was easy enough to do using excel but yeah just scratching my head as to why it didnt work.. dircreate("\\fbnecl3\inzb\documents\hgif\Fiji\The Pearl South Pacific\") dircreate("\\fbnecl3\inzb\documents\hgif\Fiji\Tropica Island Resort\") dircreate("\\fbnecl3\inzb\documents\hgif\Fiji\Uprising Beach Resort\") dircreate("\\fbnecl3\inzb\documents\hgif\Fiji\Viwa Island Resort\") dircreate("\\fbnecl3\inzb\documents\hgif\Fiji\Volivoli Beach\") dircreate("\\fbnecl3\inzb\documents\hgif\Fiji\Vomo Island Resort\") dircreate("\\fbnecl3\inzb\documents\hgif\Fiji\Yasawa Island Resort & Spa\") I didnt miss anything did i? lol theoretically it should of worked? if so maybe something to look into..

meh just manipulated excel so that i could just get "dircreate("&cells in excel to give file path") in a massive list so i could copy and paste into autoit then just run it like that.. Curious as to why the above didnt work though..

Hey Guys, has been a little while since using autoit, just wanting to check im not missing something here? Or can i not use dircreate in a way like this... have a list of names, wanting to create folders from said list. Also tried using serverpaths didnt work error: (11) : ==> Error parsing function call.: ;;creating lots o folders! #include <Excel.au3> $oExcel = _Excel_Open() $wkbk = _Excel_BookOpen($oExcel,"\\fbnecl3\inzb\Documents\Content Support\Tom\Automation\Autoit Test Scripts\foldernames.xlsx") For $i = 1 To 490 ;Loop $location = _Excel_RangeRead($wkbk, default,"a"&$i, 1) $name = _Excel_RangeRead($wkbk, default,"b"&$i, 1) dircreate("q:\Documents\HGIF\South Pac\"&$location&"\"&$name&"\" Next _Excel_Close($oExcel)

any reasons why it does not download? it doesnt appear to error at all it just simply finishes without downloading the file.