Forum Discussion

hallojatin's avatar
hallojatin
Occasional Contributor
13 years ago

How excel data work in Load UI agent (Linux)

Hi,

I have created a simple XML request in SOAP UI Pro. There is Excel data source attached to that script.

Path of project: C:\ABC\XYZ\project.xml
Path of Excenl Data: C:\Test Data\book1.xls

I wanted to execute a performance test in Load UI Pro for script which I have mentioned above. Here is an architecture

Load UI Pro: Install on my Windows machine from where I will execute the test.
Load UI Agent (Linux): Install on Linux machine.

Now here is my problem. I want to execute this script over Linux agent machine. I want the script to be executed with excel data source. I import the script in Load UI and create a scenario and place that scenario over Linux agent, will it pick up the excel data source automatically when I import my script in Load UI or do I need to create some setting so that my script will work with that data.

or Do I need to create the same path in Linux Agent machine.

Please help.

4 Replies

  • nmrao's avatar
    nmrao
    Community Hero
    13 years ago
    Neither used loadui, nor in a position to advise you.
    Just, think the reverse way what would it be need if load UI Pro running on linux machine and windows is running an agent. If all it some script is required to be run, and data is in the. So, the file(resource) must be available locally which is what I believe.
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    13 years ago
    You need the same path on both (all) machines. Keep in mind that you can use relative paths, which is really what you want when mixing Operating Systems.

    Regards

    Henrik
    LoadUI team
  • hallojatin's avatar
    hallojatin
    Occasional Contributor
    13 years ago
    Hi Henrik,

    OK, I am using relative path in SOAP UI project and also in Load UI project which I have created using the SOAP UI project. My question is when I will run the test in Load UI, will the excel data file automatically moved to load UI agent machine or do I need to first copy those data file to Load UI agent machines? If I need to copy data file to Agent machine than what should be the location ate Load UI agent machine?

    Everywhere I am using relative paths only. Locally my Soap UI project along with data file and Load UI project are placed at

    Windows Machine. Again, I am using relative path settings everywhere i.e. ${projectDir}
    C:\Project\SOAP_UI_Project.xml
    C:\Project\data.xls
    C:\Project\LOAD_UI_Project.xml

    Now I want to run a test in Load UI. I am using Load UI agent at Machine X (Linux). Now do I need to copy my data file to linux machine and where? Or does Load UI agent automatically moves the data file to Load UI agent.

    Please suggest as I am just few days away to start the first execution.
  • nmrao's avatar
    nmrao
    Community Hero
    12 years ago
    Could you please try this and see if you can proceed?

    Define property at project level which is variable path for each (data source file, etc whatever you need) and update the property on the local machine with absolute path?
    And where actually file path is referred in project, replace with ${#Project#PropertyName}.