Skip to main content

Im studing and the course name: Building Your First Automation Bot, After created the loop in the capture i placed everything rigth like the video say, but when i run the bot, after de line 12 appear a error and say this: 

This may be due to the following reason: Key 'First Name' not found in record. Location: ITBricks (line 13)

To continue, edit the bot and fix the error. Then, try again. If you continue to see this message, please contact your system administrator.

Code: bot.execution.error

 

And in that line there isnt a error

I don’t have the steps to create that automation in front of me, but that error is common when someone is opening a file (e.g., a CSV file) and forgot to click the box that says “Contains header”.

 


works now but in another one loop apear the same thing.

This may be due to the following reason: Key 'Company Name' not found in record. Location: ITBricks (line 15)

To continue, edit the bot and fix the error. Then, try again. If you continue to see this message, please contact your system administrator.

Code: bot.execution.error


Check line 11 for the “Contains headers” check box. It’s a common mistake and prevents named keys from being created. Indexes, however, are still there.


Where?

 


Sorry, step 7. I misread the screen shot. This needs to be checked if you want the record variable to have text indices (e.g., an associative array).

 


There are other restrictions too:

  • The header must be the first row of the sheet
  • The header must be only one row -- multiple row headers are not supported
  • Each column in the header must have a unique name
  • Each column in the header must have a name -- blank values are not supported

For all those restrictions, you gain the ability to address the columns by their names and, if the columns are moved around, your automation will continue to work properly. If you’re using numeric indices to address the columns, that is not the case.


I got the header active, but i tried desible that line and plany, work but the error apear agoin on line 17, i desible that line too an work, so i got the problem in the step 15 and 17 only.

 


Make sure the headings you specify match the FILE not the field on the web page.

If the file says “Phone” for its heading but the web page field is named “Phone Number”, you must use “Phone” from the file.


Reply