Sign in to follow this  
Followers 0
Kurto2021

send("^v") vs send("HELP")

11 posts in this topic

#1 ·  Posted (edited)

I have recently just set up some automation with emails that come in that need to be keyed into the computer.  Currently I am doing a lot of send("enter text here") but I was wondering is there any disadvantage to doing this clipput("enter text here") send ("^v") on the cell.

In a quick experiment with notepad I found the pasting to be faster but was curious if I might experience any issues doing it this way and if so what would they be?

Also as a side I think I would probably leave it as tabs but I was wondering if sending the mouse the coordinates would be faster as well instead of tabbing.....this is a dedicated machine that does nothing but process web requests.

We process approximately 1,500 web requests per week during the slow time with 2000 to 3500 during peak season.  I was looking to see if I could speed up this process in any way before that time comes.

Edited by Kurto2021

Share this post


Link to post
Share on other sites



Which email client do you use (Outlook ...) and which browser do you use (Internet Explorer, Firefox ...)?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

not using any browser the emails come in and they are keyed into the mainframe.  I would prefer to make a flat file or xml and have it imported but was told that is not an option so we have to open the window and key it in.  That being said I was using send ("12342345") but found it faster to load the value to the clipboard and paste it.  Just wondering if there was a negative impact in doing this.

Share this post


Link to post
Share on other sites

Which program do you use to read you mails? If it is Outlook you can at least automate the Outlook side.

How do you access the mainframe (PC3270 ...)?


My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2017-04-18 - Version 1.4.8.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2017-02-27 - Version 1.3.1.0) - Download - General Help & Support - Example Scripts - Wiki
ExcelChart (2015-04-01 - Version 0.4.0.0) - Download - General Help & Support - Example Scripts
Excel - Example Scripts - Wiki
Word - Wiki
PowerPoint (2015-06-06 - Version 0.0.5.0) - Download - General Help & Support

Tutorials:
ADO - Wiki

 

Share this post


Link to post
Share on other sites

Using your outlook ex udf then loading the data to an array

Share this post


Link to post
Share on other sites

#6 ·  Posted (edited)

Mainframe is executed through some qws3270.exe (something like that).

Edited by Kurto2021

Share this post


Link to post
Share on other sites

Yes

Share this post


Link to post
Share on other sites

I'm not sure I'd want to do that. Right now we set up a rule where all the requests come in then the UDF code picks up the email in the folder parses it to the array then launches mainframe window and keys it in. I found it a bit slower then I wanted so I began loading to clipboard and pasting. Friday was my first day running it full bore and it was pretty fast. Just worried loading to clipboard my be an issue.

I have never used the mainframe before so I'd have to ask the users for more details. I wanted to load the array to a SQL statement then insert it into the mf database but they said no to that too.

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0