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.