Search found 12 matches

by korrowan
Mon Feb 14, 2011 6:51 pm
Forum: Technical / Scripting
Topic: Couple questions
Replies: 22
Views: 19017

Yes, I think you should download the eval version of WebRecorder and try it. There are examples (I think) inside the help after you install it. Getting the data back can be done several ways. Many times you will know the particular "tag" by name or it's ID (tag is another way to say data field in t...
by korrowan
Mon Feb 14, 2011 4:28 pm
Forum: Technical / Scripting
Topic: Couple questions
Replies: 22
Views: 19017

Another question. I have another way to access the mainframe using IE for some of the data and from this website http://www.phila.gov/revenue/RealEstateTax/. Would using web recorder be a better option to screen scrape that data?? If so how does one pull the data from the correct spot? For instance ...
by korrowan
Thu Feb 10, 2011 7:00 pm
Forum: Technical / Scripting
Topic: Couple questions
Replies: 22
Views: 19017

Thanks for that link! It looks like that little piece of software is much more robust than I expected. In the past I was a user and had no time to deal with it but with our downtime I am sure I can get it to do what I need! I guess the only thing that I will have to decide is the best way to read/wr...
by korrowan
Thu Feb 10, 2011 6:51 pm
Forum: Technical / Scripting
Topic: Couple questions
Replies: 22
Views: 19017

On-line help then? I will scour the web for a help file or a manual but I am sure the city would be annoyed that I am trying to screen scrape their mainframe lol and would likely not be much help. On March 1st I may be able to get that help from them as that is when our bid will either be rejected ...
by korrowan
Thu Feb 10, 2011 6:45 pm
Forum: Technical / Scripting
Topic: Couple questions
Replies: 22
Views: 19017

Looking at the web page for QWS3270 http://www.jollygiant.com/products/qws3270-windows-features.php I see the following listed as a windows "feature": Dynamic Data Exchange Support to allow other Windows applications to send data to the 3270 session and receive data from the 3270 session. If you ha...
by korrowan
Thu Feb 10, 2011 6:30 pm
Forum: Technical / Scripting
Topic: Couple questions
Replies: 22
Views: 19017

1.) Is the VM hosted on a machine you control? It is currently hosted on my laptop. 2.) How do you interact with that VM? I am running Windows 7 XP Mode which I can access directly. 3.) If you control the VM, can you install software inside the VM? I can if needed if it would make things less compl...
by korrowan
Thu Feb 10, 2011 4:13 pm
Forum: Technical / Scripting
Topic: Couple questions
Replies: 22
Views: 19017

The data can be copied and shared between the VM and the PC it is housed on. What I want to do is be able to take data from a dataset and loop through and put in the necessary data into QWS3270 and have it search for the correct record and return the postmark date to me. If it does not find what I n...
by korrowan
Thu Feb 10, 2011 3:58 pm
Forum: Technical / Scripting
Topic: Couple questions
Replies: 22
Views: 19017

If Macro Scheduler is on the host and the app is in the VM then no. The VM is an entirely separate machine sandboxed from the host. No process in one will have any kind of access to the other. Only thing that Macro Scheduler can do is send keystrokes/mouse events in and see the screen being project...
by korrowan
Thu Feb 10, 2011 3:47 pm
Forum: Technical / Scripting
Topic: Couple questions
Replies: 22
Views: 19017

Quote: I then need to pass the value ( a date) back to my database Either //use getcontroltext to interface directly to the text in the exe GetControlText> Is it possible to use getcontroltext if it is accessing a program that is in a VM? We use a VM to access a VPN that locks out our internet so w...
by korrowan
Wed Feb 09, 2011 2:28 pm
Forum: Technical / Scripting
Topic: Couple questions
Replies: 22
Views: 19017

Thanks guys that information will help a ton..it is much appreciated!
by korrowan
Fri Feb 04, 2011 6:36 pm
Forum: Technical / Scripting
Topic: Couple questions
Replies: 22
Views: 19017

Another question.... how can I pass a user input parameter to a query? The normal vb strUserInputer = InputBox("","") does not seem to work. It steps through but never actually prompts...

Thanks
by korrowan
Fri Feb 04, 2011 5:42 pm
Forum: Technical / Scripting
Topic: Couple questions
Replies: 22
Views: 19017

Couple questions

Hello I am trying to automate a process that takes data from an Access Table and inputs into a application on a VPN and then search for the value I need based on two values it can read from my table. I am a DBA by trade but have little experience in programming anything that is not SQL or VBscript a...
Sign up to our newsletter for free automation tips, tricks & discounts