Can anyone tell me if this program will do what I need it to?

[Jholt]

Hey there everyone. I stumbled on to this site just looking around on the web and I hope that it will be able to solve the issues I'm having with some software used at work.
I'm a police officer at a moderate sized department. We have a couple of programs in our cars that we use to do things like looking up NCIC records of people, normally by the drivers license number or by name and DOB, and also programs to enter that information for the reports we have to write. Now most of the information is the same. Name, addresses, ht, wt, - that sort of thing. I've noticed I have to type all that stuff in even though it's all available by running them through the system - but it not feasible to cut and paste to transfer all the information.

Now here is my question. Is it possible to program a hotkey or something so that when I hit it, a box pops up that I can type in a number or name and DOB and your software will take that information, enter it in to a certain field in one program, wait for the return, and then cut and paste certain parts of it in to certain fields in a whole different program? the process needs to be as streamlined as possible because sometimes this is done while driving or at a traffic stop to fill in a ticket and its very important for the process to be as simple as possible so we don't have to sit staring at the screen for any longer than we have to.

Ok thanks for any input any of you have.

Joel Holt

[forumsupport]

Hello,

Looking at your requirement, we would suggest trying advanced automation product, Automation Anywhere 4.0, which provides you with more than 180 commands to perform variety of actions.
Using Automation Anywhere 4.0, you can automate data transfer, data Import/Export, etc. Transferring data between two applications or importing data into any application is one of the popular usages of Automation Anywhere. Automation Anywhere provides data consistency across processes.
It offers prompt command, which prompts you for a value at run time and you can assign value to a variable so that you can use this variable further in task. You an search for the data based on variable value and then copy the relevant data from one application to another.

You can download Free Trial version of Automation Anywhere 4.0 from,
http://www.tethyssolutions.com/automation-software.htm

Please click on the demo link below to understand how to use the software:
http://www.tethyssolutions.com/automation-tutorials.htm

You can refer to our online samples that explain how to Automate Data Transfer, Data Import / Export, CSV Files, from below given link.
http://www.tethyssolutions.com/autom...mples.htm#data

You can use 'Excel’ commands that works tightly with excel to perform routine functions like Go To cell, get cells, run excel macro etc. You can use ‘Excel-Open Spreadsheet’ command to open the excel spreadsheet in which want to entered the data, ‘Excel-Go to Cell’ command to go to the particular cell in the spreadsheet and use the ‘Excel-Set Cells’ feature to insert the data or formula in spreadsheet.

You can view demo on Excel commands usage from, http://www.tethyssolutions.com/AAExcelIntegration.html

In addition, you can also refer to following online sample task that transfers product data from Access to Excel using Excel Integration.

http://www.tethyssolutions.com/T82.htm

Regarding hotkey, using Automation Anywhere 4.0 you can assign hotkeys very easily. What you can do is select your task, click on Hotkey tab at the bottom of main screen of Automation Anywhere and assign the keyboard shortcuts of your choice from list. Now, to run this task, you just have to press those assigned hotkeys.

Hope that helps. If not, please tell us more about your case to help us serve you better.