Database Typer

The Database Typer Action of Auto Mouse Click Software allows you to read Text from a Database and Type it onto Active Application Window. This Action Reads data from Database on a Field by Field basis and then Types it onto Active Application Window. You can Watch Database Typer Video Tutorial or read below and find out how you can use Database Typer Action to Automated Text Typing from Database.

Type from Excel

You can Alternatively use Type from Excel Action and Type Data onto Active Application Window. Watch Type from Excel Video Tutorial which displays how to read from Excel File and Type onto Active Application Window.

What is a Database ?

A Database stores information / data in an organised manner. A Database Holds Records of Related Data in terms of Rows and Columns.

Example of Database ?

An Excel or Microsoft Access File is a Good Example of Database which holds information in Rows and Columns. Yes there are many other Databases like CSV Files, SQL Server, Text Files, Oracle Database, etc.

What do i need to know to use Database Typer ?

You need to know 2 Database related things as mentioned below to use Database Typer. Yes you do also need to know how to add Action(s) to the Auto Mouse Click Script and Execute them.

  1. DSN : DSN is a Link to a Database and is identified by a Name.
  2. SQL Query : SQL Query allows you to Identify what Data you need to extract from the Database.

How to use Database Typer ?

There are few steps required to use the Database Typer. The given below steps outline how to use Database Typer.

  1. Prepare a Database of any suitable Type and Store information in it in the format of Rows and Columns.
  2. Click on the ODBC button and Create a DSN and Configure / Connect it to your Database.
  3. Specify SQL Query to Read Data from the Selected Database.
  4. Use the Test button to ensure that you can connect to your Database and Extract Information.
  5. Your Database Type Script Action is ready to be used in the Auto Mouse Click Software. When Executed, each Execution of the Action will type Text of Next Field value onto Activate Application Window.

What Databases can be Read with Database Typer?

The Database Typer uses ODB Connection to communicate with the Database. Depending on Database you have and availability of ODB Drivers, you can read any or more of given below Databases.

In what Order, the Data is read by Database Typer from Database ?

When you add a Database Typer Action to a Script and Execute it, the Next Field value identified by SQL Query is read by Database Typer and typed onto Active Application Window. When you execute a Database Typer Action in a Script 2 times, the Row 1 Column 1 value will be read and then Row 1 Column 2 value will be read by Database Typer. Given below are few more examples on using Database Typer to Auto Type Text onto Active Application Window.

Navigate to Auto Mouse Click Video Tutorials or visit Auto Mouse Click Software Home Page to find out more about this Windows Automation Software.