Skip to main content
Question

unable to fetch record from csv file

  • Feb 14, 2024 5:38 PM UTC
  • 19 replies
  • 322 views

when capture record for insertion in web textbox so below error is appear

key “reference” not found  in record

19 replies

Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+9
  • Navigator | Tier 3
  • Feb 15, 2024 4:05 AM UTC

when capture record for insertion in web textbox so below error is appear

key “reference” not found  in record

As the error shows, you are trying to add some data in textbox using a variable with key: “reference” which is not found.

Request you to please check with index instead of name or else please check with “reference” spelling. 


  • Author
  • Navigator | Tier 3
  • Feb 15, 2024 6:09 AM UTC

Reference is column name in csv file and in capture string is same no spelling mistake.

 

below error is appear

This may be due to the following reason: Key 'Reference' not found in record. Location: mepco (line 5)

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


Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+9
  • Navigator | Tier 3
  • Feb 15, 2024 6:17 AM UTC

@saqib6197 , can you please share the screenshot of the .csv file as well as the action where you are using the key “Reference”


  • Author
  • Navigator | Tier 3
  • Feb 15, 2024 6:37 AM UTC

 


Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+9
  • Navigator | Tier 3
  • Feb 15, 2024 6:42 AM UTC

Is there any space present in the header ?


  • Author
  • Navigator | Tier 3
  • Feb 15, 2024 6:45 AM UTC

no space  I checked  spaces too many time.

 


Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+9
  • Navigator | Tier 3
  • Feb 15, 2024 8:11 AM UTC

Can you please check with index, whether it is working or not.


  • Author
  • Navigator | Tier 3
  • Feb 15, 2024 8:18 AM UTC

how to go with index please sir provide  little guide on it 


Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+9
  • Navigator | Tier 3
  • Feb 15, 2024 8:26 AM UTC

As per above screenshot you have entered : mepcoRow{Reference}, instead select on By Index and then enter value as 4 (because Reference Position is at fifth and indexing starts from 0)


  • Author
  • Navigator | Tier 3
  • Feb 15, 2024 8:32 AM UTC

 


Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+9
  • Navigator | Tier 3
  • Feb 15, 2024 8:38 AM UTC

Can you please share the loop logic which you have used, where you have created the record variable


  • Author
  • Navigator | Tier 3
  • Feb 15, 2024 8:39 AM UTC

can we set zoom session ?


  • Author
  • Navigator | Tier 3
  • Feb 15, 2024 8:40 AM UTC

 


Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+9
  • Navigator | Tier 3
  • Feb 15, 2024 8:42 AM UTC

 

Is your logic the same as above?


  • Author
  • Navigator | Tier 3
  • Feb 15, 2024 8:44 AM UTC

 


Zaid Chougle
Navigator | Tier 3
Forum|alt.badge.img+9
  • Navigator | Tier 3
  • Feb 15, 2024 8:48 AM UTC

Request you to please move the get multiple cells to above the loop, as I believe the DataTable you are looping is defined inside the loop which in turns is giving an error.


  • Author
  • Navigator | Tier 3
  • Feb 15, 2024 8:58 AM UTC

Okay let me try this.

But please share your watsup number.

Thanks


  • Author
  • Navigator | Tier 3
  • Feb 15, 2024 9:47 AM UTC
still same error

 


  • Author
  • Navigator | Tier 3
  • Feb 15, 2024 1:00 PM UTC

now file fetching record but I am again stuck in other step 
step download file through print screen button and file is pdf form after click print screen than print popup is appear.

i am stuck how to click on popup print button.