Page 1 of 1

Using Remote Agents to conduct a data-driven Test

Posted: Wed Jun 12, 2019 8:39 am
by Fsis
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.

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

Posted: Thu Jun 13, 2019 1:46 pm
by qwertzu
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

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

Posted: Thu Jun 13, 2019 1:53 pm
by odklizec
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!

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

Posted: Thu Jun 13, 2019 3:52 pm
by Fsis
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

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

Posted: Thu Jun 13, 2019 3:54 pm
by Fsis
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!

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

Posted: Fri Jun 14, 2019 9:40 am
by qwertzu
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.