Jump to content
Macro Express Forums

Yehnfikm8Gq

Members
  • Posts

    397
  • Joined

  • Last visited

Everything posted by Yehnfikm8Gq

  1. I just installed it and the Menu Bar is completely blank. That must be change #56! Perhaps it's just me.
  2. If the applications are being stretched to full screen in both res, you could proportion the X and Y. A very tedious macro could be written to go through all Mouse Moves in a file and proportion them. I won't bother to detail. Unless you have a huge number I think Cory's "Output Macro Information"/manual editing may be quicker in the long run. If you don't want to convert from mouse moves to keystrokes, you can ease the manual exercise by writing a macro to do the proportioning for you. Saves messing with a calculator. For the figure you quoted, X*0.795, Y*0.987 (round result to integer). Manually select line with Mouse Move Run macro with hotkey: Type Enter Type TAB TAB TAB (only 2 Tabs for ME Pro) Copy X (to variable) X=X*0.795 Paste new X Type TAB TAB Copy Y (to variable) Y=Y*0.987 Paste new Y Enter This will not work if you are using variables to position the mouse. That would need proportioning of variable.
  3. As it was late I didn't explore all the possibilities. Here's a few more ideas: Ctrl+G opens the "Go To" dialog. You could construct the text string of the cell address to write the date into eg A3 and type that into the dialog. Instead of remembering the daily incremented integer you could write it into a cell say C3. Read it next day for number of down arrow repeats, add one and write the incremented integer back into C3 for tomorrow. Avoids external variable storage. To find the next available row you could run down the A column, reading each cell. When you get to one that is empty (retrieved text string is blank ""), put today's data on that row. This method needs no storing of variable.
  4. Hey rberg, isn't that your post for the random click every hour thread! Save your spreadsheet in advance. Outline example below uses A1, B1 on day 1 and fills in downwards Each day schedule macro to run, to: Open spreadsheet Type Ctrl+Home to get to A1 Type Ctrl+; to put date in A1 Type Right arrow Type Ctrl+Shift+; to put time in B1 Type Enter Type Ctrl+S to save the file Close spreadsheet On day 2, after "Type Ctrl+Home" Type (1) Down arrow Type Ctrl+; to put date in A2 etc Each day increment number of down arrows by 1 (Increment an integer and use integer to repeat down arrow). If the scheduling of the operations is done within the macro (the macro runs continuously for 5 days) the value of the integer will be remembered. If it is desired to run the macro briefly each day or to cope with reboots etc, the integer will have to be saved before exiting the macro. There are several ways to do that (registry, save to file, save variable). The cell navigation, including first cell selection, can be done in a number of different ways. You can test in advance by running every 2 minutes (date will be same but time will increment)
  5. I'm using a setup as noted by Brain Virus, using RealVNC. It's only on my home network - I have 2 PCs and usually run one monitor to save power. I've never noticed any changes on the "remote" pc display. If you use something like (free) ZoneAlarm you may have problems at the remote PC. You can only operate its controls from direct-connected devices (in my experience anyway). It will not respond over VNC (to allow new connections for example).
  6. I don't know what TsunamiZ intended to do. I looked at editing .mex files when I upgraded to MEPro. I use a lot of small text files for memory when running macros. I kept them in the Macro Express 3 root folder. When I installed MEPro I now had hundreds of macros referring to the old file path. I did not want manually change them as I had no idea which macros were affected. I took a look at the .mex files with the idea of changing paths in bulk. They have a lot of plain text; file paths and comments in particular. However, much of it is truncated so apart from any other considerations, it could not be done. I ended up writing a macro to automatically go through a macro file and change the affected file paths to Macro Express Pro, using Macro Explorer and Script Editor. Slow but no effort required!
  7. The first exercise is to determine how to measure progress. Macros are not necessarily linear according to lines/tasks completed. At various points in the macro you would update the progress number/string and display it, say with a Text Box. File manipulations can show standard Windows progress if you check the box in the dialog. I've never bothered but you could: Update an Integer and display as percent eg 15% You could sequentially add a character to a text string and display eg XXXXX (choosing the text box width to equal say 10 Xs) I'm sure there are more sophisticated possibilities with the new Text Box capabilities of MEPro If you look solely at line numbers, in most cases the indicated progress would be meaningless. For example, a repeat may only cover 5 lines but represent 2000 steps. To know where you are in a macro you can display/update a text box at completion of certain tasks eg "Web Pages Downloaded", "File List Complete", "Printing Started". If I'm searching for files or strings through my PC I indicate current folder or file being searched in a Text Box. If I'm extracting information from a long search in progress, I usually append to a text file. You can open it any time and get not only an idea of progress, but quality of what you have so far.
  8. Here is the entire paragraph from the ISS website: Macro Files Macro Express allows you to create multiple files of macros. When first installing the program, two macro files, samples.mex and macex.mex, are installed. The samples.mex file contains a number of sample macros that may be used for reference. The other file, macex.mex, is the default file that may be used for creating macros. Or create a new file for this purpose. The thread refers to a specific file, not the .mex or .mxe file types. Edit: I found reference to the file in the Help, Program Overview: "The macex.mex file is an empty file that can be used to store the macros as they are created. This file is installed in the My Documents folder." I can't find any other info but I'm guessing that if you want every new macro file to contain some specific macros, you add them to macex.mex which is called every time you do File/New file. Anybody?
  9. I was a bit puzzled by the filename. I search my PC and found none. I also thought it referred to .mxe. I googled "macex.mex" and found it did apparently exist: Macro Express Features When first installing the program, two macro files, samples.mex and macex.mex, are installed. The samples.mex file contains a number of sample macros that ... www.macroexpress.com/features.htm So what's the story?
  10. Alan, I think if you go to the company info page that is being interrogated you will find that Tab only finds one of the 5 lines of text (the web address). It's one of "those" pages. The page doesn't even have a menu bar (assumed javascript invoked). Having said this task could not be done with keystrokes and mouse I found that I could get reasonable results from copying the entire text on the browser page and processing. All the pages I viewed have the first 4 items of information. It is the website that is sometimes missing. That can be handled with some logic. Using this method works as long as there is no word wrap in the box due to long addresses and that all the first 4 items are present. I have both methods working. The copy text method is simpler to code. The source code method is more reliable in all circumstances. I also use Firefox but it was easy to make versions for IE too. The shortcuts are different.
  11. After posting my last comments and reading Alan's, it struck me that the codes posted by the "amerifax consortium" almost look like they have been recorded, although that may not be the case. This task is impossible to execute reliably with basic key and mouse actions. Logic and manipulating variables are needed to extract the 5 items of information from the web page in the most reliable fashion. It's not very difficult and I outlined how to do it. However I was assuming a basic understanding of both logic (IF etc) and variables (finding position of text in a string). Additionally, Ultra Edit is mentioned and I don't see why that would come into the picture. There could be a good reason I'm unaware of (such as an existing Ultra Edit script). If the extracted company information is needed somewhere else (say Excel or a database) it should be possible to enter using the ME macro. Ultra Edit itself can do many things that ME can do (keystrokes and scripting). I would have thought one or the other could do the entire job. Selecting information on a web page with a mouse is certain to give problems, particularly in a multi-user environment. When you position the mouse on a page (using Mouse Move) it goes to a specific location. That location may become completely incorrect if the user has: A different aspect monitor The screen resolution is different The text size is varied (user with poor eyesight) The toolbar setup is different No tabs versus tabs This is why you try to use keystrokes. In this case, also employ logic and variables with the page source. I don't want to be the fly in the ointment but I would hate to see a lot of time wasted going down a dead end. Hopefully Bob's review will shed some light. Edit: As a final thought Bob, if I can convince you that you are going in the wrong direction, how about starting a new thread entitled something like "Extracting data from a web page" in which you would describe what you are really trying to do. That seems to be to extract the 5 pieces of company information from the web page (not the involved procedure that arises from your method of programming). You could add what the true end use is so that Ultra Edit can be bypassed if possible. If you put each item of data into its own variable, the possibilities what you can do with the information are unlimited. A thread with that sort of title would be more useful to someone else browsing for ideas to do same. Lemming posted a similar thread in the Third Party Tools forum (first article "Extract all links...). Coincidentally I have a similar macro for commercial web pages except there is so much garbage to be removed that I use a text file with the list!
  12. Most of the problems I've had in the past were due to other applications running and/or updating. That should be way less of a problem with current PCs. You aren't using any windows in the macros so it's not a window interference issue. First thing I would try is to move the scheduled time at least an hour and not near the hour/half hour (when other apps may be updating). One thing I've done in the past is to put in a "backstop" macro until the problem is resolved. The first macro stores a text string (registry, text file etc) when it runs "I RAN". The second (scheduled) macro runs later and checks the string. If it sees the string it aborts and blanks the string in storage. If it does not, it runs the macro and stores an error message somewhere.
  13. If the 5 macros are referring to one for name, one for street address etc, I covered that in my 2nd suggestion Dec 7th. You can get the lot (for one company) with one macro and one press of the "More Details" button. Have you thought of emailing MBAonline to get the info straight from their database? Could I suggest that you run through the two macros I detailed manually (ie no code, just doing it with keyboard and mouse). That will illustrate how the macros work before you try any code. For the second macro, don't try manipulating the page source with Text Variables, just edit the page source text directly, deleting text as I indicated so you can see the result. In reality you would write the first macro "Get to details buttons" minus the mouse copy commands at the end. You would write the second macro "Copy company info" as a separate macro called by the first, once the company info page loads - saves repeating the code if you opt for variations of the first macro (see below). To choose the search subject, you would either have a separate macro for each item, Account Management etc, the only difference being the number of down arrows needed. Alternatively you could use radio buttons in a selection at the start of the macro, or stop the "Get to details buttons" macro at the subject list box so you can choose.
  14. I read the required procedure in the first post, Erratic Copy Command, Dec 3rd. Ignoring the code, the description underneath seems to be perfectly clear what is required. I followed the steps at the web site and it seemed straightforward. I outlined the steps (full details omitted) that would do what was required. I also outlined the steps to take it even further (not asked for), to put each piece of information in it's own variable, to be used for whatever purpose. Each variable was specific to name, street address, city etc, not a blanket copy command. All you would have to do is run the macro, wait for a beep or ding, click the "More Details" button and it would copy each line of the company info to a specific variable. THIS thread is very confusing and it does not seem to me that you fully examined what I and others had written. I can't speak for anyone else but I spent a great deal of time on your problem.
  15. I suggested a "Wait for Right Context Menu" feature to Insight some time ago and I don't think there is a current capability. I made my own which works OK for my use although it's a bit cumbersome (it's such a pain waiting milliseconds!). However, the sequence in which it is called sometimes ends up hanging at that point. I'm not sure whether that is a function of saving off the WWW, my incompetent programming or right context menu issue. I wrote my macro because the context menu time can be so variable - more likely to be a function of my old pc with too many applications. If you google it I think you will find it has been quite a common issue with no easy solution. Terry seems to have a more specific issue.
  16. Are replying to my comments? I am referring to TV listings (times, programs, cast etc) not the actual shows. As it happens I do use EZTV.it's "Air's Today" list as a reminder for shows appearing that day. I have to go to my saved listings for actual air times and whether the show airs on my service.
  17. If you followed the steps that I showed for automating and have not had enough fun yet, you can complete the exercise! I don't suppose you want to bother but I include for info. If you wanted to input the data directly into a particular format or variables (and also avoid using the mouse) you could extract the data. It helps in these situations to have a basic knowledge of HTML but not essential. I only show the principles, not every step: Company details page loads Type Alt+V (IE only) Type C opens page source (IE only) Edit: Note: If you find the details page has no menu bar, you will have to use mouse right click, type "v" to show source Type Ctrl+A Type Ctrl+C copy page source Set text variable, say T50, to clipboard content Close page source window Extract data: To extract company name: Copy T50 to T51 so you can re-use T50 Find position of <td id="val_CompanyName" align="center" valign="middle"> in T51 Delete T51 up to and including <td id="val_CompanyName" align="center" valign="middle"> Find position of next < in T51 Delete all of T51, past, and including the < Copy T51 to T60, this is the company name To extract street address Copy T50 to T51 so you can re-use T50 Find position of <td id="val_Address" align="center" valign="middle"> etc etc Copy T51 to T61, the street address etc Use the extracted variables however you want. Depending on how the HTML was written it may be an idea to Trim the final strings to remove any unwanted spaces Using all the steps I've detailed, the only manual action would be to start the macro and to select the company you want details of.
  18. I would check the complete filepath (not just %T2%) with a Text Box immediately prior to renaming. I always do that with file renaming until I'm sure it works OK, to avoid potential disaster. I think I normally would make the full filepath a new variable, say %T3% which I would use in the renaming. It would show all errors during the Text Box check. A fave mistake is to miss off the file extension of the fabricated filename. The file will be renamed but appear in an unexpected place in Explorer's listing.
  19. I'm not sure what the 2 Mouse Left clicks are! If you don't use Mouse Move first, the mouse can be anywhere. I can see that you cannot directly access the page due to the scripting. The URLs do not change very much. If page design is consistent over time you can use a mouse. Keystrokes like Tab, Shift+Tab, arrows, Enter cope better with minor changes in page layout. If results are inconsistent, do not underestimate times for selecting, copying, pasting large amounts of data. If problems, make 2-3 secs and work down. Sometimes you can save a lot of work by running through the process manually and observing URLs in the location bar of the browser. You can fabricate the URL with MEP. For example, my TV listings are typically: xxxx://affiliate.zap2it.com/tvlistings/ZCSGrid.do?stnNum=17609&channel=&fromTimeInMillis=0 Note that I have subbed xxxx for http so they don't appear as links in the forum! I would construct for different stations. variable xxxx://affiliate.zap2it.com/tvlistings/ZCSGrid.do?stnNum= add station ID 17609 add variable &channel=&fromTimeInMillis=0 xxxx://affiliate.zap2it.com/tvlistings/ZCSGrid.do?stnNum=17609&channel=&fromTimeInMillis=0 is typed in the location bar I have a list of all the station IDs in a text file and call them up one by one (Text File Process) This is what I would do for your listings. I would make a set of macros, one for each frequently accessed item eg Accounts, Apartments. Same macro, different URLs and arrow navigation. No timings included but illustrates many techniques MBA Home Page loads Type 4 Tabs + Enter loads disclaimer Page Down (once or twice, too many better than too few times) Mouse move over I agree button, mouse left click Type Alt+D IE location bar TypeURL xxxx://www.mbaonline.org/MBAGeoLocator/ConstructionServicesMaterials.aspx (will be in location bar) Edit: I found that if you load this link (with the http of course) you can omit all the previous steps, disclaimer etc. It may be that cookies have been set in my browser from previous accesses but if it works it saves a few steps. Page loads Move mouse near centre of listbox, mouse left click Type 4 arrows up (too many better than too few) to get to top of list Type Down arrows as required (eg 7 down arrows will give you Apartment Management) Type 2 Tabs + Enter to hit Search Page loads Type one or two Page Downs (depends how big the list is, one probably will do) Sound a Ding (to get your attention cos you've been twiddling your thumbs up to now) Wait for mouse left click (You manually click More Details of desired entry) Page loads Copy data similar to what you were doing etc etc End with more emphatic sound file It all sounds complicated but once you have done it you will find others easier. My TV listings were very complex because I do Stations and Actor/Show Searches and pages can take 5-90 secs to load. It took 8 hours to get the macro working consistently but since it runs 2 hours every night, the savings have been astronomical.
  20. Commenting on Directory Opus, I have it running most of the time and have never had conflicts with ME3 or MEP. Have you checked your keyboard for sticky keys, especially the Ctrl, Alt etc that go with every hotkey combo and also get the greatest usage outside of ME eg Ctrl+C?
  21. There could be two ways of tackling the problem. One is to activate the macro when needed. The other is to have a macro already running and monitoring for a specific mouse click on the button to proceed. Instead of using controls you could alternatively use a mouse event (eg click) in either of these scenarios, with suitable logic to identify that the button area in the correct window has been pressed. A solution will have to take into account what else you are doing with the windows/pc and what effect pressing the button may have. Yet another method would be to have a hotkey that starts the macro, giving a mouse left click on the button followed by the rest of the macro main action. I don't use controls very much so I'll leave that area to someone more experienced. edit: mouse right changed to mouse left
  22. I'm sure you are aware of it, but for the benefit of others, an alternative method using colour detection is to make a custom throbber (top right of FF page). This requires some knowledge of Firefox, easily found by googling, and some basic graphic editing to create the throbber/s. The advantage is that you can make a large area of uniform colour for the "page loaded" condition. The larger target is less susceptible to variations in page geometry since the throbber is always at the right end of the menu bar and the colour is always what you made it.
×
×
  • Create New...