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.

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. 1.Pattern composition: Load data (1) → Initialize (2) → Focus app (3) → Loop & enter (4) → Write results (5).
  2. 2.Field entry customization required — replace placeholder column names with your actual DataTable columns.
  3. 3.DataRow column access uses dot notation: TransactionItem.ColumnName.
  4. 4.Validation via OCR checks for confirmation and error text — adjust strings to match your app.
  5. 5.Error recovery: dismisses popup, cancels form, screenshots, logs failure, continues to next record.
  6. 6.Safe stop allows graceful termination between records.

Dependencies

  • Terminal/Mainframe Emulator Driver
  • Window Focus Manager
  • Legacy App Login