Jump to content

smellyfingers

Active Members
  • Posts

    80
  • Joined

  • Last visited

Recent Profile Visitors

203 profile views

smellyfingers's Achievements

Wayfarer

Wayfarer (2/7)

0

Reputation

  1. Time i guess and not sure about what best practice would be, i also just discovered Sikuli with their newest release a few days ago so the idea came recent, but i will start digging when i get som free time!
  2. Would this be possible to build like a udf/wrapper for autoit with Sikuli functions, just a thought
  3. I would try a complete uninstall of autoit and scite and then just install 3.3.12.0 and scite 3.4.4 again just to make sure that there isn't any version conflict going on in windows and see if that works
  4. Ah, your using 3.3.14 on this computer?
  5. SciTE Version 3.4.4 Autoit version 3.3.12.0 Windows 10 Home Runs without errors, i have had similar issues if i have some instance opened elsewhere or not saved and reopened the script
  6. Hi, thanx for the reply, yes it looks that way using the window info tool, but i agree it looks more like a treeview, i found another problem with this app itself when trying to automate it, it constantly changing the classnn names for the controls, is there a way to get the classnn names from it's id?, i think the id is the only thing that is permanent in this application...
  7. Here is the result of _GUICtrlListBox_GetSelItemsText #include <WinAPI.au3> #include <GUIConstantsEx.au3> #include <GuilistBox.au3> #include <Misc.au3> #include <File.au3> #include <Array.au3> #include <String.au3> #include <Excel.au3> #include <MsgBoxConstants.au3> #include <WinAPIEx.au3> Opt("WinDetectHiddenText", 1) ;0=don't detect, 1=do detect Opt("WinSearchChildren", 1) ;0=no, 1=search children also $ttlWindow = "Front Office" $hdlWindow = WinGetHandle($ttlWindow) $hdlList = ControlGetHandle($hdlWindow, "", 8197) $count = _GUICtrlListBox_GetCount($hdlList) ;MsgBox(0,"",$count) Global $item,$sItems Dim $textArr[0] For $item = 0 To ($count - 1) Step 1 _GUICtrlListBox_ClickItem($hdlList, $item, "left") $aItems = _GUICtrlListBox_GetSelItemsText($hdlList) For $iI = 1 To $aItems[0] If $iI > 1 Then $sItems &= ", " $sItems &= $aItems[$iI] Next MsgBox($MB_SYSTEMMODAL, "Information", "Items Selected: " & $sItems) Next I get a blank response
  8. Hi, yes i did try that also, no luck, just seems odd it can give just the 2 first letters and ignore and leave out the rest, it's my work computer by the way forgot to mention It's a Windows 7 64 bit version, could that be it perhaps? I'll get a coworker to try the script on their 32 bit Windows tomorrow when I'm back at the office.
  9. #include <WinAPI.au3> #include <GUIConstantsEx.au3> #include <GuilistBox.au3> #include <Misc.au3> #include <File.au3> #include <Array.au3> #include <String.au3> #include <Excel.au3> #include <MsgBoxConstants.au3> #include <WinAPIEx.au3> Opt("WinDetectHiddenText", 1) ;0=don't detect, 1=do detect Opt("WinSearchChildren", 1) ;0=no, 1=search children also $ttlWindow = "Kundinformation" $hdlWindow = WinGetHandle($ttlWindow) ;$id = _WinAPI_GetDlgCtrlID($hdlWindow) $hdlList = ControlGetHandle($hdlWindow, "", 8197) ;MsgBox(0,"",$hdlList) _GUICtrlListBox_ClickItem($hdlList, 3, "left") $count = _GUICtrlListBox_GetCount($hdlList) ;MsgBox(0,"",$count) Global $item Dim $textArr[0] For $item = 0 To ($count - 1) Step 1 _GUICtrlListBox_ClickItem($hdlList, $item, "left") $tlength = _GUICtrlListBox_GetTextLen($hdlList, $item) $iIndex = _GUICtrlListBox_GetText($hdlList, $item) MsgBox(64,"",$tlength & " | " & $iIndex) Next Hi, I'm trying to get the text from ListBox (selected item) or item looped as the code above, as you can see from the attached file I only get 2 characters for each item, is this a bug or is there something else making it return those 2, GetTextLen seems to be working ok and reads the length.
  10. Thanx, sorry been away a while, solved it with a simple formsubmit instead after looking for some credentials in the form.
  11. Hey, i hope someone can point me in the right direction, i have a page with tables, inside i have TD,TR,INPUT tags, the input tags is buttons and i need to click on one of theese buttons but they have the same value and type so the only way that i am going to know that it's the correct button is to find out the name of the innerhtml of the TD before (the parent node) because the input comes after, like this <TABLE> <TR> <TD> Name of the td </TD> <TR> <TD colSpan=3<INPUT> value=my button type=button</INPUT></TD> <TR> <TD> Other name of a td </TD> <TR> <TD colSpan=3<INPUT> value=my button type=button</INPUT></TD> <TR> I know how to find all td's and inputs but not (in a loop) look for the td's and once it has found it click on the corresponding or "closest" input, maybe a nested loop? I made a for loop using _IETagnameGetCollection($ie,"TD") and after it found the TD i tried looking for nextSibling but that might be impossible with INPUT perhaps?
  12. select top 0 * into #tmpdatabase from ABTABLE; select * from #tmpdatabase; BULK INSERT #tmpdatabase FROM $fileupload WITH (FIELDTERMINATOR =';',ROWTERMINATOR ='\n' ,FIRSTROW = 2); MERGE ABTABLE AS T USING #tmpdatabase AS S ON (T.A = S.A) WHEN NOT MATCHED BY TARGET THEN INSERT( [A] ,[K] ) VALUES( S.[A] ,S.[K] ) WHEN MATCHED THEN UPDATE SET T.[A] = S.[A] ,T.[K] = S.[K]; drop table #tmpdatabase; Hi, I'm trying to convert this query that I make from Toad that loads a file into a tempdatabase from .csv file based on an existing table on the sql server into autoit friendly code but don't know how to do it, been rubbing my head on this one :P, maybe need a different approach? I'm using AutoIt Version: 3.3.10.2 This doesn't seem to do anything: Local $obj_SQL_DB = _SQLConnect("db.u\SQl1", "data", 1, "At", "Pass") If @error Then Return SetError(50, @error, -1) Local $strSQL = "select top 0 * into #tmpdatabase from ABTABLE;" $obj_SQL_DB.Execute($strSQL) Any suggestions would be fantastic Nevermind i managed to do this like this instead :), mark as solved! Local $file = FileOpen("\TEST\SQL_UPD.txt",0) Local $strSQL = FileRead($file) $obj_SQL_DB.Execute($strSQL)
  13. I have tried that but the program doesn't trigger that a change is made that way it only responds to send and tab , i just wonder how it can fail to make a CTRL + V and only send a simple character? I'm thinking that maybe it does the CTRLDOWN and CTRLUP before the v ? Maybe a workaround would be while Controlgettext <> myInfo, controlsettext "", Paste or send, Controlgettext ?
  14. Hi all, I just have 1 simple question, i use ControlSend to fill info into a programs controlinputs, however sometimes it sends a character instead, Example winwaitactive("myWin") clipput("myInfo") sleep(100) controlfocus("myWin","","[CLASSNN:Ahx:233223]") ControlSend("","","","^v") This sends the v instead of pasting from clipboard (sometimes), would it be safer to have it send as a variable instead? Many thanx!
  15. Ok, ill need to look into that, thanx
×
×
  • Create New...