Forum Discussion

SaraCavelind's avatar
SaraCavelind
Contributor
13 years ago

Testrunner and excel datasources

Hi!
I have a soaui project with excel datasources that I use to store the test data (I load the database using JDBC later on).
It works very well. Now I'm about to port the project to our CI server (jenkins). The problem I face is that either the testdata isn't found or the testrunner can't use excel datasources.
When I try to insert the data read from the excelfile I always get empty fields!
I have tried to hardcode the path to the excel files and also to use projectDir, but neither gives me any luck.

Is there some external library or other things that I need to do in order to get this to work?
  • SmartBear_Suppo's avatar
    SmartBear_Suppo
    Icon for Alumni rankAlumni
    13 years ago
    Hi!

    No there should be no need for some additional depencencies.

    This is a simple pom.xml I used to run a soapUI project using a simple *.xls file as a datasource:

    <?xml version="1.0"?>
    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.smartbear.soapui.plugintest</groupId>
    <artifactId>plugintest</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>jar</packaging>
    <name>plugintest</name>
    <url>http://maven.apache.org</url>
    <pluginRepositories>
      <pluginRepository>
        <id>eviwarePluginRepository</id>
        <url>http://www.soapui.org/repository/maven2/</url>
      </pluginRepository>
    </pluginRepositories>
    <properties>
      <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    </properties>
    <dependencies>
      <dependency>
        <groupId>junit</groupId>
        <artifactId>junit</artifactId>
        <version>3.8.1</version>
        <scope>test</scope>
      </dependency>
    </dependencies>
    <build>
      <plugins>
        <plugin>
          <groupId>eviware</groupId>
          <artifactId>maven-soapui-pro-plugin</artifactId>
          <version>4.5.1</version>
         <executions>
            <execution>
              <phase>test</phase>
              <goals>
                <goal>test</goal>
              </goals>
              <configuration>
                <projectFile>/home/erik/Testrunner-and-excel-datasources-soapui-project.xml</projectFile>
              </configuration>
            </execution>
          </executions>
        </plugin>
      </plugins>
    </build>
    </project>


    If you need further assistance please submit your soapUI project file, Excel document and pom.xml in our support form: http://soapui.org/Support/support-overview.html

    ---

    Regards

    Erik, SmartBear Support