GlennRogers Posted September 21, 2013 Share Posted September 21, 2013 Hi everyone. Was just wondering if i could get pointed in the right direction for a solution to my problem. I have read alot in the _IE function library but still not really sure the best way to do it. My work uses a web based management system and on a certain page there is a table. I want a script to copy to the clipboard a certain item number that I input, either via a GU input field or just by using CRTL + F. That part I can manage but then I want the script to select the value in the adjacent row which is the number of units. Not sure if i need to somehow move my mouse to the selected item number then move it right a certain distance or if there is some other handy trick to do it easily. also the column with the units is displayed like " 12 units " However all i want to copy from that cell is the numeric value " 12 " . Any help would be greatly appreicated. Thankyou. Link to comment Share on other sites More sharing options...
Moderators JLogan3o13 Posted September 22, 2013 Moderators Share Posted September 22, 2013 My work uses a web based management system and on a certain page there is a table. I want a script to copy to the clipboard a certain item number that I input, either via a GU input field or just by using CRTL + F. That part I can manage but Let's start with this part. You say you can manage copying a certain item number from the table to the clipboard. How about posting what you have, so we can see what you're doing. If you're already able to get the data out of one range in the table, why can't you obtain the data from the adjacent range? "Profanity is the last vestige of the feeble mind. For the man who cannot express himself forcibly through intellect must do so through shock and awe" - Spencer W. Kimball How to get your question answered on this forum! Link to comment Share on other sites More sharing options...
GlennRogers Posted September 23, 2013 Author Share Posted September 23, 2013 Hi Jlogan. Im using the AU3 record program to simply send the keystrokes for CRTL+F and find the item number. Haven't figured out how to do it by inputing that item number via a GUI. I've looked into ControlClick() , _IEpropertyget and a few others but not sure which is the right one to use. Link to comment Share on other sites More sharing options...
GlennRogers Posted September 23, 2013 Author Share Posted September 23, 2013 i really need help lol Link to comment Share on other sites More sharing options...
GlennRogers Posted September 23, 2013 Author Share Posted September 23, 2013 #include <INet.au3>#include <IE.au3> Local $oIE = _IECreate("www.yahoo.com", 1) _IELoadWait($oIE) $page = _INetGetSource("http://au.yahoo.com/?p=us") WinSetState("[CLASS:IEFrame]", "", @SW_MAXIMIZE) $pageArray = StringSplit($page, @CRLF) For $i = 1 To $pageArray[0] If StringInStr($pageArray[$i], "party") Then _IEAction($pageArray[$i], "click") Next Here I'm trying to get it to open up yahoo.com then find the text word "party" in the html then click it or ideally move the mouse there. Link to comment Share on other sites More sharing options...
GlennRogers Posted September 23, 2013 Author Share Posted September 23, 2013 Hi everyone. Was just wondering if i could get pointed in the right direction for a solution to my problem. I have read alot in the _IE function library but still not really sure the best way to do it. My work uses a web based management system and on a certain page there is a table. I want a script to copy to the clipboard a certain item number that I input via CRTL + F. That part I can manage but then I want the script to select the value in the adjacent row which is the number of units. Not sure if i need to somehow move my mouse to the selected item number then move it right a certain distance or if there is some other handy trick to do it easily. also the column with the units is displayed like " 12 units " However all i want to copy from that cell is the numeric value " 12 " . Any help would be greatly appreicated. Thankyou. below is the piece of html im trying to get to. 130009 being the item number <td class="odd" primarykey=" " align="left" id="000428491" ><a name="CARTON_DTL__SKU_ID" original_value="130009 " >130009 </a></td> Link to comment Share on other sites More sharing options...
Kidney Posted September 23, 2013 Share Posted September 23, 2013 i wouldnt do anything with mouse clicks. you can do it all through the page source. thats what i would do. it will also be very easy to get the adjacent item number since it looks like it could be set up as a data table. if you get the page source, you can do a stringinstr for original_value=" or do a StringRegExp like this: StringRegExp($sHTMLSource, "original_value="\d\d\d\d\d\d", 1) as long as the item numbers r always 6 digits, this will give you all of the item numbers in the table. Link to comment Share on other sites More sharing options...
Moderators Melba23 Posted September 24, 2013 Moderators Share Posted September 24, 2013 GlennRogers,How about sticking to just the one topic at a time. Threads merged. M23 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
nitekram Posted November 8, 2013 Share Posted November 8, 2013 Did this work for your issue? I am looking to see if my web based form has a table, and will like to see your finished product. 2¢ All by me:"Sometimes you have to go back to where you started, to get to where you want to go." "Everybody catches up with everyone, eventually" "As you teach others, you are really teaching yourself." From my dad "Do not worry about yesterday, as the only thing that you can control is tomorrow." WIKI | Tabs; | Arrays; | Strings | Wiki Arrays | How to ask a Question | Forum Search | FAQ | Tutorials | Original FAQ | ONLINE HELP | UDF's Wiki | AutoIt PDF AutoIt Snippets | Multple Guis | Interrupting a running function | Another Send StringRegExp | StringRegExp Help | RegEXTester | REG TUTOR | Reg TUTOT 2 AutoItSetOption | Macros | AutoIt Snippets | Wrapper | Autoit Docs SCITE | SciteJump | BB | MyTopics | Programming | UDFs | AutoIt 123 | UDFs Form | UDF Learning to script | Tutorials | Documentation | IE.AU3 | Games? | FreeSoftware | Path_Online | Core Language Programming Tips Excel Changes ControlHover.UDF GDI_Plus Draw_On_Screen GDI Basics GDI_More_Basics GDI Rotate GDI Graph GDI CheckExistingItems GDI Trajectory Replace $ghGDIPDll with $__g_hGDIPDll DLL 101? Array via Object GDI Swimlane GDI Plus French 101 Site GDI Examples UEZ GDI Basic Clock GDI Detection Ternary operator Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now