[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now


Input into web page via clipboard

Posted on 2012-03-15
Medium Priority
Last Modified: 2013-11-19
A customer has a website that we need to enter data into.  It is very time consuming and has a high possibility of human keystroke error.

What I would like to do is input the 6 fields of data into the clipboard, (I can program this automatically) and have the user click on the first field of the web form and hit CTRL V to paste the data.  However, I need to have the clipboard have a TAB command to move from one field to the next.   Example:

123 <TAB> ABC <TAB> 789 <TAB> XYZ

The user would scan a barcode which loads the clipboard with the appropriate data string and click on the first field in the web form, then hit CTRL V.  123 would be pasted in to that field, the tab execute and move the cursor to the second field, ABC would be inserted, another tab to the third field, 789 entered and so on.

I have done the above but the problem is that the (CHAR(009)) command tabs the cursor over in the first field and all characters are typed into the first field.  The the embedded tab does not move the focus to the next field.  However hitting the keyboard tab does move focus to the next field.   I have tried ASCII codes 9,10,11,12.   Oddly enough, 13 does execute a carriage return that works outside the current text box, while 9 does not.

I have no control nor can I modify the customer's web page.  I am fairly proficient at database programming (SQL etc.) but not webpages.   If I can succeed at this, it will have a major savings in both labor time and error reduction.

Any assistance greatly appreciated.   Thanks,
Question by:HouseofFara
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 84

Expert Comment

by:Dave Baldwin
ID: 37728057
The 'automated' methods of sending data to a web site don't use the manual forms at all.  With most sites, you can use a program to directly submit the data.  cURL is a popular and all web programming languages like ASP and PHP can be used.

Author Comment

ID: 37729249
Thank you for the reply.
As mentioned, I am not a web programmer so am not versed in any of the normal web languages such as PHP.   Also, this customer's web site requires some buttons to be pushed after text entry and confirmationn numbers are returned, which the user needs to record.

If I have to go to much programming length, I would set up EDI via AS2, but then they charge a fairly steep price for that option.   We are in between the volume that really justifies EDI costs but is becoming a man power issue as well.

The current ideal situation would be if I could get the clip board paste to work.  The user has to enter 3 files that are not too bad to type such as ship date, Invoice number etc., but they then have to type in upto 6 UPS tracking numbers, which are quite long.   I can load the clip board with this data fine programatically, if I could just get the TAB to work like I need that would be the best solution at this time.
LVL 84

Accepted Solution

Dave Baldwin earned 750 total points
ID: 37730214
I honestly don't think you will get that to work as a manual procedure.
LVL 38

Assisted Solution

BillDL earned 750 total points
ID: 37731021
It's an interesting idea, and would have been a real bonus in the 5 years spent sitting for hours in a dull room alone tabbing and entering invoice data into multiple fields.

The following are just some ideas as they pop into my head.  Bear in mind that I am not a "programmer", but know some aspects, and neither am I a web designer, but know a reasonable amount.  These are just ideas that might lead to a working method, but I have a feeling that none of the ideas would be viable solutions in terms of ease of use and time saving.

You could probably fully automate the actions of tabbing between fields and entering data  using a program like AutoIT or similar that builds "macro" type scripts and compiles a single EXE file.  That, of course, depends on several things remaining constant eg: the browser name and page loaded (usually identified by what's in the Title Bar) always remaining exactly the same, the tab steps to the button clicks and jumps to next field always being the same, and the data being entered into each field being perpetually unchanged.  Of greater importance, it would take you some time to learn how to use something like AutoIT.

I guess it might be possible, although I haven't tested it, for such a compiled automation executable to use variables or arrays for each or all of the data fields and have them populated for that session by first reading in each from a text file that you prepare daily.  AutoIT can use clipboard functions, which may also prove useful.

In a similar vein, I would probably be able to write batch file that reads a text file and creates a VBScript (*.vbs) on the fly that is already populated with the data values, and then runs that VBS file.  A VBScript can use the clunky "SendKeys" function to simulate keystrokes and would be able to automate the completion of a web form, but to work the target application and "Window Title" (browser and Title Bar text) would have to remain the same throughout.  Keeping the target window in focus is usually the hit and miss thing with the SendKeys method.  It can be quite flakey.

There are already applications that automate webform completion.  I see that This One allows you to import a CSV file with the data, and that is something that you could create on a daily basis.  That's not a recommendation, just the first significant and relevant hit in a google search for "automate webform filling".

Anyway, that's all I can think of just off the top of my head, but perhaps it might give you some ideas.

Author Closing Comment

ID: 37766510
I did not find the solution I was hoping for, but perhaps one was not available!
Thanks to those who made suggestions.

Featured Post

Understanding Web Applications

Without even knowing it, most of us are using web applications on a daily basis. Gmail and Yahoo email, Twitter, Facebook, and eBay are used by most of us daily—and they are web applications. We often confuse these web applications tools for websites.  So, what is the difference?

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When it comes to security, close monitoring is a must. According to WhiteHat Security annual report, a substantial number of all web applications are vulnerable always. Monitis offers a new product - fully-featured Website security monitoring and pr…
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
This Micro Tutorial will demonstrate how nuggets on the Web are formatted by using Chrome Developer Tools. These tools would not only view the site's CSS but it can also modify it and save the CSS to use on your own site.
How to create a custom search shortcut to site-search Experts Exchange using Google in the Firefox browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch your Bookmark Menu: Press 'Ctrl +…

650 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question