need to automate data entry

[nriddock]

hello

i have a desktop app (non web/browser based) that allows me to register patients.

the patient data is in tab delimited txt file

ex:

lastname|firstname|MI|age|***|doctor

ive tried using the "Transfer data from excel" task and it picks up the data from A1 and puts it into the first data entry field. what i cant figure out how todo is do it for more than one field

ie:

data from A1 goes to field 1
data from A2 goes to field 3
data from A3 goes to field 4

i guess i can use tabs to enter keystrokes ... $data1{tab}{tab}$data2

any suggestions?

[forumsupport]

Hello,

You can use, 'Read from 'CSV' file' option of Database command to get the data from tab delimited text file. After you connect to text file, the result set is stored in the System Variable $Dataset Column$. Use Loop for Each row in a SQL query dataset option to loop through all the rows of the result set. To access each column use $Dataset Column(index)$ for e.g. to get the first column use $Dataset Column(1)$. Inside loop, you can insert Keystrokes commands to enter the data into your desktop app. You can use Tab(s) to move the cursor at required location.

For your reference, we have attached a sample task. Please copy it under location, 'C:\...\My Documents\Automation Anywhere\Automation Anywhere\My Tasks' folder. You need to edit this task as per your requirement for e.g., change the text file location and name, change the window title of Keystrokes command and so.

Hope that helps.