Build a Macro Load Template Manually


It's recommended to use Macro Recording feature rather than building loads manually. For Macro Recording feature please click here

Before you start building load template, please study the target form carefully and identify how many fields are there and how do you navigate between fields and most importantly the fields navigation order.  Also ascertain the key combinations used to save the data in target form.

As an Example suppose we want to build a template to enter new customers  in a windows form as shown below


customers form


By closely studying the form we have learned that to add new record we have to press "Alt-A" when we press "ALT-A Key the buttons change like this


customers form save

and then we have to press {TAB} twice to go the first field. And, then to move between the fields we have to use {TAB} key and then finally to save the record we have to press "ALT-S" and then again we have to press "ALT-A" to enter a new record and then so on..


In Data Loader you can send a keystroke by entering the keystroke preceded by a backslash "\"  for Example: "\{TAB}" will send a TAB keystroke to the target application. For a list of Keystrokes please read the help file which comes with Data Loader.


You can send data to the target application by just typing the data as it is in the cell. Data Loader uses the copy and paste mechanism to send the data to the target application.


To build the load for above form we have to build the spreadsheet like this.


data loader macro load template




dataloader macroload template contd


Continued ....



Please note the last column with "Delay" heading. in the last column we are telling Data Loader to wait for 50 millisecond before starting to enter new record.


Delay fields are very useful in situation where the target application takes time to process data entered before processing the next keystrokes. You can adjust the delay time by editing the delay column.



After you have prepared the spreadsheet press "Start Loading" Start Load button on toolbar. When you press this button you will get a window as shown below.


load options


Here you can specify the following Loading Options.



After selecting the desired options click "Start" button to start loading. When the Loading Start you will see a small on Top Right Hand side of your screen which will show you the progress.


For More Information about Keystrokes you can  Please click here


Contact Us


© Interface Computers  All Rights Reserved