Use Liberty RPA Wand to move data from a data dump in the form of a text file to an old registration form without any formal integration methods.

RPA is often used to integrate and exchange data when API endpoints are not available. In this scenario we start from an unstructured data dump with the goal being to parse the data and structurally enter it into a registration form app.

The robot begins by parsing the data dump, in this case a raw .txt file. The names and e-mails it contains are separated by an arbitrarily chosen ‘+’ separator. By using Liberty RPA’s text activities, each item is added to a ‘list’ which is then processed in a loop.

For each item in the data dump, Wand is used to fill in the data in the registration form. Wand uses Computer Vision algorithms to detect elements on the screen to help fill in the correct fields in the registration form – just by looking at it! Wand is a powerful tool that allows on-screen elements to be quickly found and manipulated in any application.

Once the form is filled in with all the data from the dump the application will be closed.