Legacy App Data Entry Loop
The core RPA pattern: reads a DataTable of records from Excel, then loops through each row entering data into a legacy desktop application form using keystrokes.
Sign in or create a free account to copy this script.
Provided as-is, without warranty of any kind. Review and test each pattern in a non-production environment before deploying it to live automations. See our Terms.
Problem this solves
The core RPA value proposition: eliminating manual data entry from Excel into systems that lack APIs or import tools.
Usage Notes
- 1.Pattern composition: Load data (1) → Initialize (2) → Focus app (3) → Loop & enter (4) → Write results (5).
- 2.Field entry customization required — replace placeholder column names with your actual DataTable columns.
- 3.DataRow column access uses dot notation: TransactionItem.ColumnName.
- 4.Validation via OCR checks for confirmation and error text — adjust strings to match your app.
- 5.Error recovery: dismisses popup, cancels form, screenshots, logs failure, continues to next record.
- 6.Safe stop allows graceful termination between records.
Dependencies
- Terminal/Mainframe Emulator Driver
- Window Focus Manager
- Legacy App Login