Using Remote Agents to conduct a data-driven Test

[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.

[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

[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!

[Fsis]

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]

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!

[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

Hey there,

Thank you very much, it worked!

have a nice day

Great! You're welcome.