Using Remote Agents to conduct a data-driven Test

Ask general questions here.
Fsis
Posts: 11
Joined: Wed Jun 12, 2019 8:27 am

Using Remote Agents to conduct a data-driven Test

Post by Fsis » Wed Jun 12, 2019 8:39 am

Hello,

I am currently trying to figure out how to use remote agents to conduct a data-driven test. The basis for the test is an excel sheet which is stored on a shared drive.

I can run other tests on remote agents without problems but with the data-driven one I always receive the following error message:

Failed to get rows from data source: The Excel file with name 'filename and path' could not be found.

It works fine when I run the script on my machine.

Thanks in advance for the help.

User avatar
qwertzu
Posts: 265
Joined: Wed Jan 25, 2017 11:08 am

Re: Using Remote Agents to conduct a data-driven Test

Post by qwertzu » Thu Jun 13, 2019 1:46 pm

hi,

you need to make sure that your excel file also gets copied to the remote machine.
You could choose "Copy file to project" for your excel data connector:
CopyFileToProject.png
CopyFileToProject.png (12.93 KiB) Viewed 95 times
regards, qwertzu

User avatar
odklizec
Ranorex Guru
Ranorex Guru
Posts: 5071
Joined: Mon Aug 13, 2012 9:54 am
Location: Zilina, Slovakia

Re: Using Remote Agents to conduct a data-driven Test

Post by odklizec » Thu Jun 13, 2019 1:53 pm

Hi,

Loading Excel file from shared drive is definitely bad idea! You should definitely store the file in your project and load it locally, not from shared/network drive. Also, you should keep the data connector file in source control of your choice!
Pavel Kudrys
Ranorex explorer at Descartes Systems

Please add these details to your questions:
  • Ranorex Snapshot. Learn how to create one >here<
  • Ranorex xPath of problematic element(s)
  • Ranorex version
  • OS version
  • HW configuration

Fsis
Posts: 11
Joined: Wed Jun 12, 2019 8:27 am

Re: Using Remote Agents to conduct a data-driven Test

Post by Fsis » Thu Jun 13, 2019 3:52 pm

qwertzu wrote:
Thu Jun 13, 2019 1:46 pm
hi,

you need to make sure that your excel file also gets copied to the remote machine.
You could choose "Copy file to project" for your excel data connector:

CopyFileToProject.png

regards, qwertzu
Hey there,

Thank you very much, it worked!

have a nice day

Fsis
Posts: 11
Joined: Wed Jun 12, 2019 8:27 am

Re: Using Remote Agents to conduct a data-driven Test

Post by Fsis » Thu Jun 13, 2019 3:54 pm

odklizec wrote:
Thu Jun 13, 2019 1:53 pm
Hi,

Loading Excel file from shared drive is definitely bad idea! You should definitely store the file in your project and load it locally, not from shared/network drive. Also, you should keep the data connector file in source control of your choice!
Hi,

Hmm I understand, do you mind telling me why it is a bad idea? I'm sorry if this is rather stupid question, but I'm fairly new to Ranorex and have never worked with it before.

Thanks in advance!

User avatar
qwertzu
Posts: 265
Joined: Wed Jan 25, 2017 11:08 am

Re: Using Remote Agents to conduct a data-driven Test

Post by qwertzu » Fri Jun 14, 2019 9:40 am

Fsis wrote:
Thu Jun 13, 2019 3:52 pm
qwertzu wrote:
Thu Jun 13, 2019 1:46 pm
hi,

you need to make sure that your excel file also gets copied to the remote machine.
You could choose "Copy file to project" for your excel data connector:

CopyFileToProject.png

regards, qwertzu
Hey there,

Thank you very much, it worked!

have a nice day
Great! You're welcome.