Modify a basic bot to process dynamic data
- Zuletzt aktualisiert2020/05/18
Modify a basic bot to process dynamic data
You can modify a Task Bot so it can dynamically process data from a CSV file to complete a web page automation. Reading a CSV file is an example of processing dynamic data. Bots can read files from CSV, text, Microsoft Excel, PDF, SQL database, web pages, and more.
Prerequisites
Open Notepad and enter at least three names with comma-separating values and save it
as a .CSV file. Save the file as
names.csv.
John,Doe,Example LLC,john.doe@example.com,123-123-1234,john.doe,sample0domain
Karen,Smith,Example LLC,ksmith@example.com,123-321-7654,ksmith,domain123
Mike,Lee,Example LLC,mike-lee@example.com,123-456-7890,mike-lee,domainsample
This task is to understanding the basic bot design. Regardless of which recorder was used, a recorded task is not a complete process. Recorders are a great first step, but bot developers must add business logic and edit recorded commands to ensure proper playback by the Bot Runner.
Complete these tasks to make this Task Bot read data from a file and
save the data in a web form. In this task, bot developers perform the
following:
- Create a loop for processing each row in a CSV file.
- Make each step accept input from a CSV file and write output to the web form.
Procedure
To make the basic Task Bot accept data from a CSV file, perform these steps: