Browser Automation: Take Data from Excel and put it on a special form - 21/11/2017 04:37 EST - Repost - 06/12/2017 05:16 EST

Hi, we have an excel file with around 5000 rows (material prices). We need to update our material prices in our web application (ERP System). So we need a bot to automate this process. Process: 1. Take Material Number from excel 2. Execute a search for the Material Number 3. Click on a link e.g. "update material prices" 4. Enter further data from excel in new popup 4.1. Submit 4.2. Click on some drop downs some fixed conditions. Drop Downs are javascript based so you need also to make click on checkboxes within the drop downs 5. On the new page add again data from excel to specific fields.