Global Data Source Definitions for Jenkins (soatestcli)

UrsUrs Posts: 13

Hi,

how can I import a data source (data group with several excels) defined as 'Global Data Sources' when starting SOAtest from the cli?

I was unable to find anything in the localsettings.
is there a way to do this?
maybe something similiar to the activeDataSource.xml?

regards,
urs

Comments

  • Ireneusz SzmigielIreneusz Szmigiel Posts: 139 ✭✭

    Hi Urs

    I think you should try datagroupConfig option

    and file format :

    Ireneusz Szmigiel

  • UrsUrs Posts: 13
    edited November 2017

    this will work for global data sources that are not defined locally in the tst file?
    and by creating a new workspace via cli are initially nowhere defined?

    I do have the globaldatasources.property file.

    the question would be how to pass this into the workspace, so we can then use the xml above to select the currently active one...

  • Ireneusz SzmigielIreneusz Szmigiel Posts: 139 ✭✭

    Yes, this is global data sources. By creating a new workspace you don't have it ( I mean you don't have any data source defined in the workspace).
    Global and project level data sources can be reused and shared outside of a single SOAtest project file. They are persisted in properties files that can be checked in/out of source control (if source control is used) for sharing. Global data sources are persisted in a separate properties file that you can define in the preferences panel (under Preferences> Parasoft> Global Data Sources). Project level data sources are persisted in the .parasoft file in the Eclipse project directory.
    A test suite that references a global data source can be remedied by copying and pasting the global data source into the root test suite of the SOAtest project.

    If you are doing load testing, note that global data sources are not currently supported in Load Test.

  • UrsUrs Posts: 13

    ok, i will try this and come back should i have any more issues.
    tnx as always

  • Ireneusz SzmigielIreneusz Szmigiel Posts: 139 ✭✭
    edited November 2017

    Urs,
    you can use local setting properties to define a global data source
    datasources.global.location=[local|$PATH_TO_DIR_WITH_datasources.properties_file]

  • UrsUrs Posts: 13

    prefect! that's what I was looking for.
    this way I don't have to script the entire XML and change the activeDataSourceName every time.
    thank you

  • Ireneusz SzmigielIreneusz Szmigiel Posts: 139 ✭✭
    edited November 2017

    Remeber about path format on MS Windows:

    C\:\\My_Path\\To\\Datasource_Dir

  • UrsUrs Posts: 13

    my localsettings.properties file:

    soatest.license.use_network=true
    soatest.license.network.host=###
    soatest.license.network.port=###
    soatest.license.network.edition=server_edition
    datasources.global.location=D:\workspaces\workspace\mvp.svs.soatest.smoketest.snapshot\testautomaten\soatest\config
    datasources.jdbc.classpath=D:\workspaces\workspace\mvp.svs.soatest.smoketest.snapshot\testautomaten\soatest\scripts\jar\ojdbc7.jar
    system.properties.classpath=D:\workspaces\workspace\mvp.svs.soatest.smoketest.snapshot\testautomaten\soatest\scripts\jar\datatrans.jar;D:\workspaces\workspace\mvp.svs.soatest.smoketest.snapshot\testautomaten\soatest\scripts\jar\DatatransAutorisation.jar;D:\workspaces\workspace\mvp.svs.soatest.smoketest.snapshot\testautomaten\soatest\scripts\jar\esta-basic-types.jar;D:\workspaces\workspace\mvp.svs.soatest.smoketest.snapshot\testautomaten\soatest\scripts\jar\mct-main-types.jar;D:\workspaces\workspace\mvp.svs.soatest.smoketest.snapshot\testautomaten\soatest\scripts\jar\zvs-zahlung-api-service-1.6.24.jar;D:\workspaces\workspace\mvp.svs.soatest.smoketest.snapshot\testautomaten\soatest\scripts\jar\mct-vermittler-main-types-3.0.46.jar;D:\workspaces\workspace\mvp.svs.soatest.smoketest.snapshot\testautomaten\soatest\scripts\jar\ojdbc7.jar
    scripting.jython.path=D:\workspaces\workspace\mvp.svs.soatest.smoketest.snapshot\testautomaten\soatest\scripts\jython
    scripting.jython.home=D:\workspaces\workspace\mvp.svs.soatest.smoketest.snapshot\testautomaten\soatest\scripts\jython2.5.3
    report.format=xunit|HTML

    my datasources.properties:

    Fri Nov 17 15:19:01 CET 2017

    datasources=ds_875338001_1510927677169_1164793447\nds_875338001_1510927506954_326478837\nds_875338001_1510927534505_1799917524\nds_875338001_1510927681001_1023597535\nds_875338001_1510916766133_44785364\nds_875338001_1510927625068_1745545348\nds_875338001_1510927548608_1626864998\nds_875338001_1510927582598_1162583145\nds_875338001_1510916766133_286749839\nds_875338001_1510927608724_797235659\nds_875338001_1510927693376_1218274272\nds_875338001_1510927615228_1945549063\nds_875338001_1510927605037_1430167618\nds_875338001_1510927539409_1523152672\nds_875338001_1510927729974_823232541\nds_875338001_1510927491308_1281376784\nds_875338001_1510927599405_1598827458\nds_875338001_1510927688768_1467361528\nds_875338001_1510927482005_600423879\nds_875338001_1510927701104_1746289721\nds_875338001_1510927530601_1052463236\nds_875338001_1510927591622_840930713\nds_875338001_1510917352797_1392775438\nds_875338001_1510927574359_35554990\nds_875338001_1510927741685_338796936\nds_875338001_1510927710239_336300933\nds_875338001_1510927565127_210840100\nds_875338001_1510927487084_1809226196\nds_875338001_1510927543152_1447944051\nds_875338001_1510927724526_402999039\nds_875338001_1510927495987_1880071027\nds_875338001_1510927587126_2099856303\nds_875338001_1510927672457_278736034\nds_875338001_1510927570007_1571423519\nds_875338001_1510927753516_1914096127\nds_875338001_1510927595990_1967851084\nds_875338001_1510927719703_1517106982\nds_875338001_1510927527177_23052872\nds_875338001_1510927636203_1109840669\nds_875338001_1510927511506_577585224\nds_875338001_1510927560040_609833736\nds_875338001_1510927747549_1925283911\nds_875338001_1510927736309_1366274681\nds_875338001_1510927555776_1357885395\nds_875338001_1510927515554_1074201520\nds_875338001_1510927519770_149578460\nds_875338001_1510927621100_361965209\nds_875338001_1510927578182_1842609212\nds_875338001_1510927705543_1558271079\nds_875338001_1510927664162_674379913\nds_875338001_1510927684896_380477359\nds_875338001_1510927696888_672702320\nds_875338001_1510927476943_2003719957
    ds_875338001_1510916766133_286749839.ActiveDataSourceName=401
    ds_875338001_1510916766133_286749839.DataGroupSubDataSourceName=ds_875338001_1510916766133_44785364\tds_875338001_1510917352797_1392775438\tds_875338001_1510927476943_2003719957\tds_875338001_1510927487084_1809226196\tds_875338001_1510927506954_326478837\tds_875338001_1510927511506_577585224\tds_875338001_1510927495987_1880071027\tds_875338001_1510927515554_1074201520\tds_875338001_1510927519770_149578460\tds_875338001_1510927491308_1281376784\tds_875338001_1510927534505_1799917524\tds_875338001_1510927539409_1523152672\tds_875338001_1510927530601_1052463236\tds_875338001_1510927548608_1626864998\tds_875338001_1510927555776_1357885395\tds_875338001_1510927543152_1447944051\tds_875338001_1510927565127_210840100\tds_875338001_1510927570007_1571423519\tds_875338001_1510927574359_35554990\tds_875338001_1510927578182_1842609212\tds_875338001_1510927582598_1162583145\tds_875338001_1510927587126_2099856303\tds_875338001_1510927595990_1967851084\tds_875338001_1510927482005_600423879\tds_875338001_1510927527177_23052872\tds_875338001_1510927599405_1598827458\tds_875338001_1510927605037_1430167618\tds_875338001_1510927608724_797235659\tds_875338001_1510927615228_1945549063\tds_875338001_1510927621100_361965209\tds_875338001_1510927625068_1745545348\tds_875338001_1510927636203_1109840669\tds_875338001_1510927664162_674379913\tds_875338001_1510927672457_278736034\tds_875338001_1510927677169_1164793447\tds_875338001_1510927684896_380477359\tds_875338001_1510927681001_1023597535\tds_875338001_1510927688768_1467361528\tds_875338001_1510927693376_1218274272\tds_875338001_1510927696888_672702320\tds_875338001_1510927701104_1746289721\tds_875338001_1510927710239_336300933\tds_875338001_1510927719703_1517106982\tds_875338001_1510927705543_1558271079\tds_875338001_1510927729974_823232541\tds_875338001_1510927736309_1366274681\tds_875338001_1510927741685_338796936\tds_875338001_1510927724526_402999039\tds_875338001_1510927753516_1914096127\tds_875338001_1510927747549_1925283911
    ds_875338001_1510916766133_286749839.closeconn=true
    ds_875338001_1510916766133_286749839.first_row.internal=1
    ds_875338001_1510916766133_286749839.last_row.internal=1
    ds_875338001_1510916766133_286749839.name=999_MASTER_DATA_GROUP
    ds_875338001_1510916766133_286749839.prefix=NONE
    ds_875338001_1510916766133_286749839.type=Data Group
    ds_875338001_1510916766133_286749839.use_all_rows=false
    ds_875338001_1510916766133_44785364.break_on_empty_row=true
    ds_875338001_1510916766133_44785364.closeconn=true
    ds_875338001_1510916766133_44785364.first_row.internal=1
    ds_875338001_1510916766133_44785364.last_row.internal=1
    ds_875338001_1510916766133_44785364.name=401
    ds_875338001_1510916766133_44785364.prefix=NONE
    ds_875338001_1510916766133_44785364.sheet=TestDaten
    ds_875338001_1510916766133_44785364.type=Excel
    ds_875338001_1510916766133_44785364.use_all_rows=true
    ds_875338001_1510916766133_44785364.xls_file=${workspace_loc}/../../data/testdaten/400-B2B/401_Sortimenttest_Produktbasiert_SHOP_B2B_Smoke.xlsx
    ds_875338001_1510917352797_1392775438.break_on_empty_row=true
    ds_875338001_1510917352797_1392775438.closeconn=true
    ds_875338001_1510917352797_1392775438.first_row=9
    ds_875338001_1510917352797_1392775438.first_row.internal=10
    ds_875338001_1510917352797_1392775438.last_row=10
    ds_875338001_1510917352797_1392775438.last_row.internal=11
    ds_875338001_1510917352797_1392775438.name=000
    ds_875338001_1510917352797_1392775438.prefix=NONE
    ds_875338001_1510917352797_1392775438.sheet=TestDaten
    ds_875338001_1510917352797_1392775438.type=Excel
    ds_875338001_1510917352797_1392775438.use_all_rows=true
    ds_875338001_1510917352797_1392775438.xls_file=${workspace_loc}/../../data/testdaten/000-smoketest/000 Smoketest.abS80.xlsx
    ds_875338001_1510927476943_2003719957.break_on_empty_row=true
    ds_875338001_1510927476943_2003719957.closeconn=true
    ds_875338001_1510927476943_2003719957.first_row.internal=1
    ds_875338001_1510927476943_2003719957.last_row.internal=1
    ds_875338001_1510927476943_2003719957.name=010
    ds_875338001_1510927476943_2003719957.prefix=NONE
    ds_875338001_1510927476943_2003719957.sheet=TestDaten
    ds_875338001_1510927476943_2003719957.type=Excel
    ds_875338001_1510927476943_2003719957.use_all_rows=true
    ds_875338001_1510927476943_2003719957.xls_file=${workspace_loc}/../../data/testdaten/010-einzeltickets/010_Einzeltickets_City_Destinationen_SHOP.xlsx
    ds_875338001_1510927482005_600423879.break_on_empty_row=true
    ds_875338001_1510927482005_600423879.closeconn=true
    ds_875338001_1510927482005_600423879.first_row.internal=1
    ds_875338001_1510927482005_600423879.last_row.internal=1
    ds_875338001_1510927482005_600423879.name=011
    ds_875338001_1510927482005_600423879.prefix=NONE
    ds_875338001_1510927482005_600423879.sheet=TestDaten
    ds_875338001_1510927482005_600423879.type=Excel
    ds_875338001_1510927482005_600423879.use_all_rows=true
    ds_875338001_1510927482005_600423879.xls_file=${workspace_loc}/../../data/testdaten/010-einzeltickets/011_Einzeltickets_City_Destinationen_CASA.xlsx
    ds_875338001_1510927487084_1809226196.break_on_empty_row=true
    ds_875338001_1510927487084_1809226196.closeconn=true
    ds_875338001_1510927487084_1809226196.first_row.internal=1
    ds_875338001_1510927487084_1809226196.last_row.internal=1
    ds_875338001_1510927487084_1809226196.name=012
    ds_875338001_1510927487084_1809226196.prefix=NONE
    ds_875338001_1510927487084_1809226196.sheet=TestDaten
    ds_875338001_1510927487084_1809226196.type=Excel
    ds_875338001_1510927487084_1809226196.use_all_rows=true
    ds_875338001_1510927487084_1809226196.xls_file=${workspace_loc}/../../data/testdaten/010-einzeltickets/012_Einzeltickets_City-City_SHOP.xlsx
    ds_875338001_1510927491308_1281376784.break_on_empty_row=true
    ds_875338001_1510927491308_1281376784.closeconn=true
    ds_875338001_1510927491308_1281376784.first_row.internal=1
    ds_875338001_1510927491308_1281376784.last_row.internal=1
    ds_875338001_1510927491308_1281376784.name=013
    ds_875338001_1510927491308_1281376784.prefix=NONE
    ds_875338001_1510927491308_1281376784.sheet=TestDaten
    ds_875338001_1510927491308_1281376784.type=Excel
    ds_875338001_1510927491308_1281376784.use_all_rows=true
    ds_875338001_1510927491308_1281376784.xls_file=${workspace_loc}/../../data/testdaten/010-einzeltickets/013_Einzeltickets_City-City_CASA.xlsx
    ds_875338001_1510927495987_1880071027.break_on_empty_row=true
    ds_875338001_1510927495987_1880071027.closeconn=true
    ds_875338001_1510927495987_1880071027.first_row.internal=1
    ds_875338001_1510927495987_1880071027.last_row.internal=1
    ds_875338001_1510927495987_1880071027.name=014
    ds_875338001_1510927495987_1880071027.prefix=NONE
    ds_875338001_1510927495987_1880071027.sheet=TestDaten
    ds_875338001_1510927495987_1880071027.type=Excel
    ds_875338001_1510927495987_1880071027.use_all_rows=true
    ds_875338001_1510927495987_1880071027.xls_file=${workspace_loc}/../../data/testdaten/010-einzeltickets/014_EinzelticketsTageskarten_DV_Tageskarten_SHOP.xlsx
    ds_875338001_1510927506954_326478837.break_on_empty_row=true
    ds_875338001_1510927506954_326478837.closeconn=true
    ds_875338001_1510927506954_326478837.first_row.internal=1
    ds_875338001_1510927506954_326478837.last_row.internal=1
    ds_875338001_1510927506954_326478837.name=016
    ds_875338001_1510927506954_326478837.prefix=NONE
    ds_875338001_1510927506954_326478837.sheet=TestDaten
    ds_875338001_1510927506954_326478837.type=Excel
    ds_875338001_1510927506954_326478837.use_all_rows=true
    ds_875338001_1510927506954_326478837.xls_file=${workspace_loc}/../../data/testdaten/010-einzeltickets/016_Einzeltickets_125_SHOP.xlsx
    ds_875338001_1510927511506_577585224.break_on_empty_row=true
    ds_875338001_1510927511506_577585224.closeconn=true
    ds_875338001_1510927511506_577585224.first_row.internal=1
    ds_875338001_1510927511506_577585224.last_row.internal=1
    ds_875338001_1510927511506_577585224.name=018
    ds_875338001_1510927511506_577585224.prefix=NONE
    ds_875338001_1510927511506_577585224.sheet=TestDaten
    ds_875338001_1510927511506_577585224.type=Excel
    ds_875338001_1510927511506_577585224.use_all_rows=true
    ds_875338001_1510927511506_577585224.xls_file=${workspace_loc}/../../data/testdaten/010-einzeltickets/018_Einzeltickets_Sparbillett_Shop.xlsx
    ds_875338001_1510927515554_1074201520.break_on_empty_row=true
    ds_875338001_1510927515554_1074201520.closeconn=true
    ds_875338001_1510927515554_1074201520.first_row.internal=1
    ds_875338001_1510927515554_1074201520.last_row.internal=1
    ds_875338001_1510927515554_1074201520.name=020
    ds_875338001_1510927515554_1074201520.prefix=NONE
    ds_875338001_1510927515554_1074201520.sheet=TestDaten
    ds_875338001_1510927515554_1074201520.type=Excel
    ds_875338001_1510927515554_1074201520.use_all_rows=true
    ds_875338001_1510927515554_1074201520.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/020_Shop_Verbund_Libero_Fahrplanbasiert.xlsx
    ds_875338001_1510927519770_149578460.break_on_empty_row=true
    ds_875338001_1510927519770_149578460.closeconn=true
    ds_875338001_1510927519770_149578460.first_row.internal=1
    ds_875338001_1510927519770_149578460.last_row.internal=1
    ds_875338001_1510927519770_149578460.name=021
    ds_875338001_1510927519770_149578460.prefix=NONE
    ds_875338001_1510927519770_149578460.sheet=TestDaten
    ds_875338001_1510927519770_149578460.type=Excel
    ds_875338001_1510927519770_149578460.use_all_rows=true
    ds_875338001_1510927519770_149578460.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/021_Shop_Verbund_ZVV_Fahrplanbasiert.xlsx
    ds_875338001_1510927527177_23052872.break_on_empty_row=true
    ds_875338001_1510927527177_23052872.closeconn=true
    ds_875338001_1510927527177_23052872.first_row.internal=1
    ds_875338001_1510927527177_23052872.last_row.internal=1
    ds_875338001_1510927527177_23052872.name=022
    ds_875338001_1510927527177_23052872.prefix=NONE
    ds_875338001_1510927527177_23052872.sheet=TestDaten
    ds_875338001_1510927527177_23052872.type=Excel
    ds_875338001_1510927527177_23052872.use_all_rows=true
    ds_875338001_1510927527177_23052872.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/022_Shop_Verbund_Frimobil_Fahrplanbasiert.xlsx
    ds_875338001_1510927530601_1052463236.break_on_empty_row=true
    ds_875338001_1510927530601_1052463236.closeconn=true
    ds_875338001_1510927530601_1052463236.first_row.internal=1
    ds_875338001_1510927530601_1052463236.last_row.internal=1
    ds_875338001_1510927530601_1052463236.name=023
    ds_875338001_1510927530601_1052463236.prefix=NONE
    ds_875338001_1510927530601_1052463236.sheet=TestDaten
    ds_875338001_1510927530601_1052463236.type=Excel
    ds_875338001_1510927530601_1052463236.use_all_rows=true
    ds_875338001_1510927530601_1052463236.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/023_Shop_Verbund_OndeVerte_Fahrplanbasiert.xlsx
    ds_875338001_1510927534505_1799917524.break_on_empty_row=true
    ds_875338001_1510927534505_1799917524.closeconn=true
    ds_875338001_1510927534505_1799917524.first_row.internal=1
    ds_875338001_1510927534505_1799917524.last_row.internal=1
    ds_875338001_1510927534505_1799917524.name=024
    ds_875338001_1510927534505_1799917524.prefix=NONE
    ds_875338001_1510927534505_1799917524.sheet=TestDaten
    ds_875338001_1510927534505_1799917524.type=Excel
    ds_875338001_1510927534505_1799917524.use_all_rows=true
    ds_875338001_1510927534505_1799917524.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/024_Shop_Verbund_Passepartout_Fahrplanbasiert.xlsx
    ds_875338001_1510927539409_1523152672.break_on_empty_row=true
    ds_875338001_1510927539409_1523152672.closeconn=true
    ds_875338001_1510927539409_1523152672.first_row.internal=1
    ds_875338001_1510927539409_1523152672.last_row.internal=1
    ds_875338001_1510927539409_1523152672.name=025
    ds_875338001_1510927539409_1523152672.prefix=NONE
    ds_875338001_1510927539409_1523152672.sheet=TestDaten
    ds_875338001_1510927539409_1523152672.type=Excel
    ds_875338001_1510927539409_1523152672.use_all_rows=true
    ds_875338001_1510927539409_1523152672.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/025_Shop_Verbund_Z-PassSchwyzZug_Fahrplanbasiert.xlsx
    ds_875338001_1510927543152_1447944051.break_on_empty_row=true
    ds_875338001_1510927543152_1447944051.closeconn=true
    ds_875338001_1510927543152_1447944051.first_row.internal=1
    ds_875338001_1510927543152_1447944051.last_row.internal=1
    ds_875338001_1510927543152_1447944051.name=027
    ds_875338001_1510927543152_1447944051.prefix=NONE
    ds_875338001_1510927543152_1447944051.sheet=TestDaten
    ds_875338001_1510927543152_1447944051.type=Excel
    ds_875338001_1510927543152_1447944051.use_all_rows=true
    ds_875338001_1510927543152_1447944051.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/027_Shop_Verbund_Z-PassFlextax_Fahrplanbasiert.xlsx
    ds_875338001_1510927548608_1626864998.break_on_empty_row=true
    ds_875338001_1510927548608_1626864998.closeconn=true
    ds_875338001_1510927548608_1626864998.first_row.internal=1
    ds_875338001_1510927548608_1626864998.last_row.internal=1
    ds_875338001_1510927548608_1626864998.name=028
    ds_875338001_1510927548608_1626864998.prefix=NONE
    ds_875338001_1510927548608_1626864998.sheet=TestDaten
    ds_875338001_1510927548608_1626864998.type=Excel
    ds_875338001_1510927548608_1626864998.use_all_rows=true
    ds_875338001_1510927548608_1626864998.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/028_Shop_Verbund_Z-PassA-Welle_Fahrplanbasiert.xlsx
    ds_875338001_1510927555776_1357885395.break_on_empty_row=true
    ds_875338001_1510927555776_1357885395.closeconn=true
    ds_875338001_1510927555776_1357885395.first_row.internal=1
    ds_875338001_1510927555776_1357885395.last_row.internal=1
    ds_875338001_1510927555776_1357885395.name=029
    ds_875338001_1510927555776_1357885395.prefix=NONE
    ds_875338001_1510927555776_1357885395.sheet=TestDaten
    ds_875338001_1510927555776_1357885395.type=Excel
    ds_875338001_1510927555776_1357885395.use_all_rows=true
    ds_875338001_1510927555776_1357885395.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/029_Shop_Verbund_Z-PassOstwind_Fahrplanbasiert.xlsx
    ds_875338001_1510927560040_609833736.break_on_empty_row=true
    ds_875338001_1510927560040_609833736.closeconn=true
    ds_875338001_1510927560040_609833736.first_row.internal=1
    ds_875338001_1510927560040_609833736.last_row.internal=1
    ds_875338001_1510927560040_609833736.name=030
    ds_875338001_1510927560040_609833736.prefix=NONE
    ds_875338001_1510927560040_609833736.sheet=TestDaten
    ds_875338001_1510927560040_609833736.type=Excel
    ds_875338001_1510927560040_609833736.use_all_rows=true
    ds_875338001_1510927560040_609833736.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/030_Shop_Verbund_Libero_Produktbasiert.xlsx
    ds_875338001_1510927565127_210840100.break_on_empty_row=true
    ds_875338001_1510927565127_210840100.closeconn=true
    ds_875338001_1510927565127_210840100.first_row.internal=1
    ds_875338001_1510927565127_210840100.last_row.internal=1
    ds_875338001_1510927565127_210840100.name=031
    ds_875338001_1510927565127_210840100.prefix=NONE
    ds_875338001_1510927565127_210840100.sheet=TestDaten
    ds_875338001_1510927565127_210840100.type=Excel
    ds_875338001_1510927565127_210840100.use_all_rows=true
    ds_875338001_1510927565127_210840100.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/031_Shop_Verbund_ZVV_Produktbasiert.xlsx
    ds_875338001_1510927570007_1571423519.break_on_empty_row=true
    ds_875338001_1510927570007_1571423519.closeconn=true
    ds_875338001_1510927570007_1571423519.first_row.internal=1
    ds_875338001_1510927570007_1571423519.last_row.internal=1
    ds_875338001_1510927570007_1571423519.name=032
    ds_875338001_1510927570007_1571423519.prefix=NONE
    ds_875338001_1510927570007_1571423519.sheet=TestDaten
    ds_875338001_1510927570007_1571423519.type=Excel
    ds_875338001_1510927570007_1571423519.use_all_rows=true
    ds_875338001_1510927570007_1571423519.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/032_Shop_Verbund_Frimobil_Produktbasiert.xlsx
    ds_875338001_1510927574359_35554990.break_on_empty_row=true
    ds_875338001_1510927574359_35554990.closeconn=true
    ds_875338001_1510927574359_35554990.first_row.internal=1
    ds_875338001_1510927574359_35554990.last_row.internal=1
    ds_875338001_1510927574359_35554990.name=033
    ds_875338001_1510927574359_35554990.prefix=NONE
    ds_875338001_1510927574359_35554990.sheet=TestDaten
    ds_875338001_1510927574359_35554990.type=Excel
    ds_875338001_1510927574359_35554990.use_all_rows=true
    ds_875338001_1510927574359_35554990.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/033_Shop_Verbund_OndeVerte_Produktbasiert.xlsx
    ds_875338001_1510927578182_1842609212.break_on_empty_row=true
    ds_875338001_1510927578182_1842609212.closeconn=true
    ds_875338001_1510927578182_1842609212.first_row.internal=1
    ds_875338001_1510927578182_1842609212.last_row.internal=1
    ds_875338001_1510927578182_1842609212.name=034
    ds_875338001_1510927578182_1842609212.prefix=NONE
    ds_875338001_1510927578182_1842609212.sheet=TestDaten
    ds_875338001_1510927578182_1842609212.type=Excel
    ds_875338001_1510927578182_1842609212.use_all_rows=true
    ds_875338001_1510927578182_1842609212.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/034_Shop_Verbund_Passepartout_Produktbasiert.xlsx
    ds_875338001_1510927582598_1162583145.break_on_empty_row=true
    ds_875338001_1510927582598_1162583145.closeconn=true
    ds_875338001_1510927582598_1162583145.first_row.internal=1
    ds_875338001_1510927582598_1162583145.last_row.internal=1
    ds_875338001_1510927582598_1162583145.name=035
    ds_875338001_1510927582598_1162583145.prefix=NONE
    ds_875338001_1510927582598_1162583145.sheet=TestDaten
    ds_875338001_1510927582598_1162583145.type=Excel
    ds_875338001_1510927582598_1162583145.use_all_rows=true
    ds_875338001_1510927582598_1162583145.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/035_Shop_Verbund_Arcobaleo_Fahrplanbasiert.xlsx
    ds_875338001_1510927587126_2099856303.break_on_empty_row=true
    ds_875338001_1510927587126_2099856303.closeconn=true
    ds_875338001_1510927587126_2099856303.first_row.internal=1
    ds_875338001_1510927587126_2099856303.last_row.internal=1
    ds_875338001_1510927587126_2099856303.name=036
    ds_875338001_1510927587126_2099856303.prefix=NONE
    ds_875338001_1510927587126_2099856303.sheet=TestDaten
    ds_875338001_1510927587126_2099856303.type=Excel
    ds_875338001_1510927587126_2099856303.use_all_rows=true
    ds_875338001_1510927587126_2099856303.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/036_Shop_Verbund_Passepartout_Fahrplanbasiert.xlsx
    ds_875338001_1510927591622_840930713.break_on_empty_row=true
    ds_875338001_1510927591622_840930713.closeconn=true
    ds_875338001_1510927591622_840930713.first_row.internal=1
    ds_875338001_1510927591622_840930713.last_row.internal=1
    ds_875338001_1510927591622_840930713.name=037
    ds_875338001_1510927591622_840930713.prefix=NONE
    ds_875338001_1510927591622_840930713.sheet=TestDaten
    ds_875338001_1510927591622_840930713.type=Excel
    ds_875338001_1510927591622_840930713.use_all_rows=true
    ds_875338001_1510927591622_840930713.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/037_Shop_Verbund_A-Welle_Fahrplanbasiert.xlsx
    ds_875338001_1510927595990_1967851084.break_on_empty_row=true
    ds_875338001_1510927595990_1967851084.closeconn=true
    ds_875338001_1510927595990_1967851084.first_row.internal=1
    ds_875338001_1510927595990_1967851084.last_row.internal=1
    ds_875338001_1510927595990_1967851084.name=039
    ds_875338001_1510927595990_1967851084.prefix=NONE
    ds_875338001_1510927595990_1967851084.sheet=TestDaten
    ds_875338001_1510927595990_1967851084.type=Excel
    ds_875338001_1510927595990_1967851084.use_all_rows=true
    ds_875338001_1510927595990_1967851084.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/039_Shop_Verbund_Mobilis_Fahrplanbasiert.xlsx
    ds_875338001_1510927599405_1598827458.break_on_empty_row=true
    ds_875338001_1510927599405_1598827458.closeconn=true
    ds_875338001_1510927599405_1598827458.first_row.internal=1
    ds_875338001_1510927599405_1598827458.last_row.internal=1
    ds_875338001_1510927599405_1598827458.name=040
    ds_875338001_1510927599405_1598827458.prefix=NONE
    ds_875338001_1510927599405_1598827458.sheet=TestDaten
    ds_875338001_1510927599405_1598827458.type=Excel
    ds_875338001_1510927599405_1598827458.use_all_rows=true
    ds_875338001_1510927599405_1598827458.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/040_Shop_Verbund_Unireso_Fahrplanbasiert.xlsx
    ds_875338001_1510927605037_1430167618.break_on_empty_row=true
    ds_875338001_1510927605037_1430167618.closeconn=true
    ds_875338001_1510927605037_1430167618.first_row.internal=1
    ds_875338001_1510927605037_1430167618.last_row.internal=1
    ds_875338001_1510927605037_1430167618.name=041
    ds_875338001_1510927605037_1430167618.prefix=NONE
    ds_875338001_1510927605037_1430167618.sheet=TestDaten
    ds_875338001_1510927605037_1430167618.type=Excel
    ds_875338001_1510927605037_1430167618.use_all_rows=true
    ds_875338001_1510927605037_1430167618.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/041_Shop_Verbund_Ostwind_Fahrplanbasiert.xlsx
    ds_875338001_1510927608724_797235659.break_on_empty_row=true
    ds_875338001_1510927608724_797235659.closeconn=true
    ds_875338001_1510927608724_797235659.first_row.internal=1
    ds_875338001_1510927608724_797235659.last_row.internal=1
    ds_875338001_1510927608724_797235659.name=060
    ds_875338001_1510927608724_797235659.prefix=NONE
    ds_875338001_1510927608724_797235659.sheet=TestDaten
    ds_875338001_1510927608724_797235659.type=Excel
    ds_875338001_1510927608724_797235659.use_all_rows=true
    ds_875338001_1510927608724_797235659.xls_file=${workspace_loc}/../../data/testdaten/020-Verbund/060_CASA_Verbund_ModulAbo.xlsx
    ds_875338001_1510927615228_1945549063.break_on_empty_row=true
    ds_875338001_1510927615228_1945549063.closeconn=true
    ds_875338001_1510927615228_1945549063.first_row=1070
    ds_875338001_1510927615228_1945549063.first_row.internal=1071
    ds_875338001_1510927615228_1945549063.last_row=1070
    ds_875338001_1510927615228_1945549063.last_row.internal=1071
    ds_875338001_1510927615228_1945549063.name=301
    ds_875338001_1510927615228_1945549063.prefix=NONE
    ds_875338001_1510927615228_1945549063.sheet=TestDaten
    ds_875338001_1510927615228_1945549063.type=Excel
    ds_875338001_1510927615228_1945549063.use_all_rows=true
    ds_875338001_1510927615228_1945549063.xls_file=${workspace_loc}/../../data/testdaten/300-tollgates/301_Sortimenttest_Produktbasiert_CASA.xlsx
    ds_875338001_1510927621100_361965209.break_on_empty_row=true
    ds_875338001_1510927621100_361965209.closeconn=true
    ds_875338001_1510927621100_361965209.first_row=1070
    ds_875338001_1510927621100_361965209.first_row.internal=1071
    ds_875338001_1510927621100_361965209.last_row=1070
    ds_875338001_1510927621100_361965209.last_row.internal=1071
    ds_875338001_1510927621100_361965209.name=302
    ds_875338001_1510927621100_361965209.prefix=NONE
    ds_875338001_1510927621100_361965209.sheet=TestDaten
    ds_875338001_1510927621100_361965209.type=Excel
    ds_875338001_1510927621100_361965209.use_all_rows=true
    ds_875338001_1510927621100_361965209.xls_file=${workspace_loc}/../../data/testdaten/300-tollgates/302_Sortimenttest_Produktbasiert_SHOP.xlsx
    ds_875338001_1510927625068_1745545348.break_on_empty_row=true
    ds_875338001_1510927625068_1745545348.closeconn=true
    ds_875338001_1510927625068_1745545348.first_row.internal=1
    ds_875338001_1510927625068_1745545348.last_row.internal=1
    ds_875338001_1510927625068_1745545348.name=303
    ds_875338001_1510927625068_1745545348.prefix=NONE
    ds_875338001_1510927625068_1745545348.sheet=TestDaten
    ds_875338001_1510927625068_1745545348.type=Excel
    ds_875338001_1510927625068_1745545348.use_all_rows=true
    ds_875338001_1510927625068_1745545348.xls_file=${workspace_loc}/../../data/testdaten/300-tollgates/303_Sortimenttest_Fahrplanbasiert_CASA.xlsx
    ds_875338001_1510927636203_1109840669.break_on_empty_row=true
    ds_875338001_1510927636203_1109840669.closeconn=true
    ds_875338001_1510927636203_1109840669.first_row.internal=1
    ds_875338001_1510927636203_1109840669.last_row.internal=1
    ds_875338001_1510927636203_1109840669.name=304
    ds_875338001_1510927636203_1109840669.prefix=NONE
    ds_875338001_1510927636203_1109840669.sheet=TestDaten
    ds_875338001_1510927636203_1109840669.type=Excel
    ds_875338001_1510927636203_1109840669.use_all_rows=true
    ds_875338001_1510927636203_1109840669.xls_file=${workspace_loc}/../../data/testdaten/300-tollgates/304_Sortimenttest_Fahrplanbasiert_SHOP.xlsx
    ds_875338001_1510927648027_1704957780.closeconn=true
    ds_875338001_1510927648027_1704957780.first_row.internal=1
    ds_875338001_1510927648027_1704957780.last_row.internal=1
    ds_875338001_1510927664162_674379913.break_on_empty_row=true
    ds_875338001_1510927664162_674379913.closeconn=true
    ds_875338001_1510927664162_674379913.first_row=1070
    ds_875338001_1510927664162_674379913.first_row.internal=1071
    ds_875338001_1510927664162_674379913.last_row=1070
    ds_875338001_1510927664162_674379913.last_row.internal=1071
    ds_875338001_1510927664162_674379913.name=311
    ds_875338001_1510927664162_674379913.prefix=NONE
    ds_875338001_1510927664162_674379913.sheet=TestDaten
    ds_875338001_1510927664162_674379913.type=Excel
    ds_875338001_1510927664162_674379913.use_all_rows=true
    ds_875338001_1510927664162_674379913.xls_file=${workspace_loc}/../../data/testdaten/300-tollgates/311_WhiteListTest.xlsx
    ds_875338001_1510927672457_278736034.break_on_empty_row=true
    ds_875338001_1510927672457_278736034.closeconn=true
    ds_875338001_1510927672457_278736034.first_row.internal=1
    ds_875338001_1510927672457_278736034.last_row.internal=1
    ds_875338001_1510927672457_278736034.name=402
    ds_875338001_1510927672457_278736034.prefix=NONE
    ds_875338001_1510927672457_278736034.sheet=TestDaten
    ds_875338001_1510927672457_278736034.type=Excel
    ds_875338001_1510927672457_278736034.use_all_rows=true
    ds_875338001_1510927672457_278736034.xls_file=${workspace_loc}/../../data/testdaten/400-B2B/402_Sortimenttest_Produktbasiert_SHOP_B2B_Reduziert.xlsx
    ds_875338001_1510927677169_1164793447.break_on_empty_row=true
    ds_875338001_1510927677169_1164793447.closeconn=true
    ds_875338001_1510927677169_1164793447.first_row.internal=1
    ds_875338001_1510927677169_1164793447.last_row.internal=1
    ds_875338001_1510927677169_1164793447.name=403
    ds_875338001_1510927677169_1164793447.prefix=NONE
    ds_875338001_1510927677169_1164793447.sheet=TestDaten
    ds_875338001_1510927677169_1164793447.type=Excel
    ds_875338001_1510927677169_1164793447.use_all_rows=true
    ds_875338001_1510927677169_1164793447.xls_file=${workspace_loc}/../../data/testdaten/400-B2B/403_Sortimenttest_Produktbasiert_SHOP_B2B_Erweitert_1.xlsx
    ds_875338001_1510927681001_1023597535.break_on_empty_row=true
    ds_875338001_1510927681001_1023597535.closeconn=true
    ds_875338001_1510927681001_1023597535.first_row.internal=1
    ds_875338001_1510927681001_1023597535.last_row.internal=1
    ds_875338001_1510927681001_1023597535.name=404
    ds_875338001_1510927681001_1023597535.prefix=NONE
    ds_875338001_1510927681001_1023597535.sheet=TestDaten
    ds_875338001_1510927681001_1023597535.type=Excel
    ds_875338001_1510927681001_1023597535.use_all_rows=true
    ds_875338001_1510927681001_1023597535.xls_file=${workspace_loc}/../../data/testdaten/400-B2B/404_Sortimenttest_Produktbasiert_SHOP_B2B_Erweitert_2.xlsx
    ds_875338001_1510927684896_380477359.break_on_empty_row=true
    ds_875338001_1510927684896_380477359.closeconn=true
    ds_875338001_1510927684896_380477359.first_row.internal=1
    ds_875338001_1510927684896_380477359.last_row.internal=1
    ds_875338001_1510927684896_380477359.name=405
    ds_875338001_1510927684896_380477359.prefix=NONE
    ds_875338001_1510927684896_380477359.sheet=TestDaten
    ds_875338001_1510927684896_380477359.type=Excel
    ds_875338001_1510927684896_380477359.use_all_rows=true
    ds_875338001_1510927684896_380477359.xls_file=${workspace_loc}/../../data/testdaten/400-B2B/405_Sortimenttest_Produktbasiert_SHOP_B2B_Erweitert_3.xlsx
    ds_875338001_1510927688768_1467361528.break_on_empty_row=true
    ds_875338001_1510927688768_1467361528.closeconn=true
    ds_875338001_1510927688768_1467361528.first_row.internal=1
    ds_875338001_1510927688768_1467361528.last_row.internal=1
    ds_875338001_1510927688768_1467361528.name=406
    ds_875338001_1510927688768_1467361528.prefix=NONE
    ds_875338001_1510927688768_1467361528.sheet=TestDaten
    ds_875338001_1510927688768_1467361528.type=Excel
    ds_875338001_1510927688768_1467361528.use_all_rows=true
    ds_875338001_1510927688768_1467361528.xls_file=${workspace_loc}/../../data/testdaten/400-B2B/406_Zahlung_B2B.xlsx
    ds_875338001_1510927693376_1218274272.break_on_empty_row=true
    ds_875338001_1510927693376_1218274272.closeconn=true
    ds_875338001_1510927693376_1218274272.first_row.internal=1
    ds_875338001_1510927693376_1218274272.last_row.internal=1
    ds_875338001_1510927693376_1218274272.name=411
    ds_875338001_1510927693376_1218274272.prefix=NONE
    ds_875338001_1510927693376_1218274272.sheet=TestDaten
    ds_875338001_1510927693376_1218274272.type=Excel
    ds_875338001_1510927693376_1218274272.use_all_rows=true
    ds_875338001_1510927693376_1218274272.xls_file=${workspace_loc}/../../data/testdaten/400-B2B/411_Sortimenttest_Fahrplanbasiert_SHOP_B2B_Smoke.xlsx
    ds_875338001_1510927696888_672702320.break_on_empty_row=true
    ds_875338001_1510927696888_672702320.closeconn=true
    ds_875338001_1510927696888_672702320.first_row.internal=1
    ds_875338001_1510927696888_672702320.last_row.internal=1
    ds_875338001_1510927696888_672702320.name=412
    ds_875338001_1510927696888_672702320.prefix=NONE
    ds_875338001_1510927696888_672702320.sheet=TestDaten
    ds_875338001_1510927696888_672702320.type=Excel
    ds_875338001_1510927696888_672702320.use_all_rows=true
    ds_875338001_1510927696888_672702320.xls_file=${workspace_loc}/../../data/testdaten/400-B2B/412_Sortimenttest_Fahrplanbasiert_SHOP_B2B_Reduziert.xlsx
    ds_875338001_1510927701104_1746289721.break_on_empty_row=true
    ds_875338001_1510927701104_1746289721.closeconn=true
    ds_875338001_1510927701104_1746289721.first_row.internal=1
    ds_875338001_1510927701104_1746289721.last_row.internal=1
    ds_875338001_1510927701104_1746289721.name=413
    ds_875338001_1510927701104_1746289721.prefix=NONE
    ds_875338001_1510927701104_1746289721.sheet=TestDaten
    ds_875338001_1510927701104_1746289721.type=Excel
    ds_875338001_1510927701104_1746289721.use_all_rows=true
    ds_875338001_1510927701104_1746289721.xls_file=${workspace_loc}/../../data/testdaten/400-B2B/413_Sortimenttest_Fahrplanbasiert_SHOP_B2B_Erweitert_1.xlsx
    ds_875338001_1510927705543_1558271079.break_on_empty_row=true
    ds_875338001_1510927705543_1558271079.closeconn=true
    ds_875338001_1510927705543_1558271079.first_row.internal=1
    ds_875338001_1510927705543_1558271079.last_row.internal=1
    ds_875338001_1510927705543_1558271079.name=414
    ds_875338001_1510927705543_1558271079.prefix=NONE
    ds_875338001_1510927705543_1558271079.sheet=TestDaten
    ds_875338001_1510927705543_1558271079.type=Excel
    ds_875338001_1510927705543_1558271079.use_all_rows=true
    ds_875338001_1510927705543_1558271079.xls_file=${workspace_loc}/../../data/testdaten/400-B2B/414_Sortimenttest_Fahrplanbasiert_SHOP_B2B_Erweitert_2.xlsx
    ds_875338001_1510927710239_336300933.break_on_empty_row=true
    ds_875338001_1510927710239_336300933.closeconn=true
    ds_875338001_1510927710239_336300933.first_row.internal=1
    ds_875338001_1510927710239_336300933.last_row.internal=1
    ds_875338001_1510927710239_336300933.name=421
    ds_875338001_1510927710239_336300933.prefix=NONE
    ds_875338001_1510927710239_336300933.sheet=TestDaten
    ds_875338001_1510927710239_336300933.type=Excel
    ds_875338001_1510927710239_336300933.use_all_rows=true
    ds_875338001_1510927710239_336300933.xls_file=${workspace_loc}/../../data/testdaten/400-B2B/421_Zahlung_B2B_Smoke.xlsx
    ds_875338001_1510927719703_1517106982.break_on_empty_row=true
    ds_875338001_1510927719703_1517106982.closeconn=true
    ds_875338001_1510927719703_1517106982.first_row.internal=1
    ds_875338001_1510927719703_1517106982.last_row.internal=1
    ds_875338001_1510927719703_1517106982.name=423
    ds_875338001_1510927719703_1517106982.prefix=NONE
    ds_875338001_1510927719703_1517106982.sheet=TestDaten
    ds_875338001_1510927719703_1517106982.type=Excel
    ds_875338001_1510927719703_1517106982.use_all_rows=true
    ds_875338001_1510927719703_1517106982.xls_file=${workspace_loc}/../../data/testdaten/400-B2B/423_Zahlung_B2B_Reduziert_Erweitert_1.xlsx
    ds_875338001_1510927724526_402999039.break_on_empty_row=true
    ds_875338001_1510927724526_402999039.closeconn=true
    ds_875338001_1510927724526_402999039.first_row.internal=1
    ds_875338001_1510927724526_402999039.last_row.internal=1
    ds_875338001_1510927724526_402999039.name=501
    ds_875338001_1510927724526_402999039.prefix=NONE
    ds_875338001_1510927724526_402999039.sheet=TestDaten
    ds_875338001_1510927724526_402999039.type=Excel
    ds_875338001_1510927724526_402999039.use_all_rows=true
    ds_875338001_1510927724526_402999039.xls_file=${workspace_loc}/../../data/testdaten/500-FinanzCluster/501_FinanzCluster_SHOP.xlsx
    ds_875338001_1510927729974_823232541.break_on_empty_row=true
    ds_875338001_1510927729974_823232541.closeconn=true
    ds_875338001_1510927729974_823232541.first_row.internal=1
    ds_875338001_1510927729974_823232541.last_row.internal=1
    ds_875338001_1510927729974_823232541.name=502
    ds_875338001_1510927729974_823232541.prefix=NONE
    ds_875338001_1510927729974_823232541.sheet=TestDaten
    ds_875338001_1510927729974_823232541.type=Excel
    ds_875338001_1510927729974_823232541.use_all_rows=true
    ds_875338001_1510927729974_823232541.xls_file=${workspace_loc}/../../data/testdaten/500-FinanzCluster/502_FinanzCluster_CASA.xlsx
    ds_875338001_1510927736309_1366274681.break_on_empty_row=true
    ds_875338001_1510927736309_1366274681.closeconn=true
    ds_875338001_1510927736309_1366274681.first_row.internal=1
    ds_875338001_1510927736309_1366274681.last_row.internal=1
    ds_875338001_1510927736309_1366274681.name=509
    ds_875338001_1510927736309_1366274681.prefix=NONE
    ds_875338001_1510927736309_1366274681.sheet=TestDaten
    ds_875338001_1510927736309_1366274681.type=Excel
    ds_875338001_1510927736309_1366274681.use_all_rows=true
    ds_875338001_1510927736309_1366274681.xls_file=${workspace_loc}/../../data/testdaten/500-FinanzCluster/509_Finanzcluster_WorkInProgress.xlsx
    ds_875338001_1510927741685_338796936.break_on_empty_row=true
    ds_875338001_1510927741685_338796936.closeconn=true
    ds_875338001_1510927741685_338796936.first_row.internal=1
    ds_875338001_1510927741685_338796936.last_row.internal=1
    ds_875338001_1510927741685_338796936.name=602
    ds_875338001_1510927741685_338796936.prefix=NONE
    ds_875338001_1510927741685_338796936.sheet=TestDaten
    ds_875338001_1510927741685_338796936.type=Excel
    ds_875338001_1510927741685_338796936.use_all_rows=true
    ds_875338001_1510927741685_338796936.xls_file=${workspace_loc}/../../data/testdaten/600-ReadinessTests/602_Readiness_SHOP_KaR.xlsx
    ds_875338001_1510927747549_1925283911.break_on_empty_row=true
    ds_875338001_1510927747549_1925283911.closeconn=true
    ds_875338001_1510927747549_1925283911.first_row=2
    ds_875338001_1510927747549_1925283911.first_row.internal=3
    ds_875338001_1510927747549_1925283911.last_row=3
    ds_875338001_1510927747549_1925283911.last_row.internal=4
    ds_875338001_1510927747549_1925283911.name=603
    ds_875338001_1510927747549_1925283911.prefix=NONE
    ds_875338001_1510927747549_1925283911.sheet=TestDaten
    ds_875338001_1510927747549_1925283911.type=Excel
    ds_875338001_1510927747549_1925283911.use_all_rows=false
    ds_875338001_1510927747549_1925283911.xls_file=${workspace_loc}/../../data/testdaten/600-ReadinessTests/603_Readiness_Hydra.xlsx
    ds_875338001_1510927753516_1914096127.break_on_empty_row=true
    ds_875338001_1510927753516_1914096127.closeconn=true
    ds_875338001_1510927753516_1914096127.first_row.internal=1
    ds_875338001_1510927753516_1914096127.last_row.internal=1
    ds_875338001_1510927753516_1914096127.name=604
    ds_875338001_1510927753516_1914096127.prefix=NONE
    ds_875338001_1510927753516_1914096127.sheet=TestDaten
    ds_875338001_1510927753516_1914096127.type=Excel
    ds_875338001_1510927753516_1914096127.use_all_rows=true
    ds_875338001_1510927753516_1914096127.xls_file=${workspace_loc}/../../data/testdaten/600-ReadinessTests/604_Readiness_Avengers.xlsx

    my activeDataSource.xml:

    [INFO]
    [INFO] ------------------------------------------------------------------------
    [INFO] Create activeDataSource Settings:
    [INFO] ------------------------------------------------------------------------
    [INFO] ACTIVE_DS_SETTINGS D:\workspaces\workspace\mvp.svs.soatest.smoketest.s
    napshot\REPORT\activeDataSource.xml
    [INFO] DONE. TYPE D:\workspaces\workspace\mvp.svs.soatest.smoketest.snapshot\REP
    ORT\activeDataSource.xml


    svs-regression-neu/regression.tst


    999_MASTER_DATA_GROUP
    401




    [INFO]`

    (it is also set to the 'selected' group in the data group 999)

    here the log for import and run steps:
    `[INFO]
    [INFO] ------------------------------------------------------------------------
    [INFO] TEST-STEP: IMPORT
    [INFO] ------------------------------------------------------------------------
    [INFO] import test file: svs-regression-neu
    "C:\Program Files\Parasoft\SOAtest\9.10\soatestcli.exe" -J-Dosgi.module.lock.tim
    eout=10 -J-Xmx4096m -data "D:\workspaces\workspace\mvp.svs.soatest.smoketest.sna
    pshot\testautomaten\soatest" -localsettings "REPORT\localSettings.properties" -i
    mport "D:\workspaces\workspace\mvp.svs.soatest.smoketest.snapshot\testautomaten\
    soatest\projects\svs-regression-neu"
    soatestcli: Version 9.10.0.20161130 -- Copyright (C) 2016 Parasoft Corporation
    Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; sup
    port was removed in 8.0
    [INFO] ERRORLEVEL: 0
    [INFO] MAXERRLVL: 0
    [INFO]
    [INFO] ------------------------------------------------------------------------
    [INFO] TEST-STEP: RUN
    [INFO] ------------------------------------------------------------------------
    [INFO] A "parmDataSourceGroupConfig" paramter was passed to Jenkins build. A -da
    taGroupConfig parameter will be passed to SOAtest...
    "C:\Program Files\Parasoft\SOAtest\9.10\soatestcli.exe" -J-Dosgi.module.lock.tim
    eout=10 -J-Xmx4096m -config user://"Example Configuration" -data "D:\workspaces\
    workspace\mvp.svs.soatest.smoketest.snapshot\testautomaten\soatest" -resource "s
    vs-regression-neu\regression.tst" -environment "zvs-snapshot" -localsettings "RE
    PORT\localSettings.properties" -dataSourceRow "1" -dataSourceName "999_MASTER_DA
    TA_GROUP" -report "REPORT" -dataGroupConfig "D:\workspaces\workspace\mvp.svs.soa
    test.smoketest.snapshot\REPORT\activeDataSource.xml"
    soatestcli: Version 9.10.0.20161130 -- Copyright (C) 2016 Parasoft Corporation
    Java HotSpot(TM) 64-Bit Server VM warning: ignoring option MaxPermSize=256m; sup
    port was removed in 8.0

    [0%] Running: Scope

    `

    But nothing executes:

    [40%] Computing unit tests

    [40%] Execution: launching tests
    [40%] Running regression.tst

    [40%] Running Tear-Down 1: Tear-Down Script, id=wk:///svs-regression-neu/r

    egression.tst#0000000000#0000006448, Seconds elapsed: less than 1s

    [58%] Finished running tests
    [61%] Performing post-testing tasks...

    Executed Test Cases: 0
    Passed: 0 Failed: 0 Skipped: 1
    Functional Failures: 0
    XML Validation Errors: 0
    Miscellaneous Errors: 0
    Change Impact: 0

    when I run it locally in my normal workspace everything seems okay...

  • benken_parasoftbenken_parasoft Posts: 462 ✭✭✭
    edited November 2017

    my localsettings.properties file:

    Backslash is a special character in java property files. It is used to escape other characters. If you need a literal backslash then you need to escape it with another backslash. I see single backslashes in the various parts of your localsettings property file. So, the paths in your java properties file are not correct. This is what Irek was referring to earlier.

  • UrsUrs Posts: 13

    hi benken,
    that's just from the forums markdown.

    the single line code blocks still reformat the conained text.

    trust me, it's all double slashes except for the colon escape slash...
    i'll try to attach the file itself.

  • benken_parasoftbenken_parasoft Posts: 462 ✭✭✭
    edited November 2017

    you can use local setting properties to define a global data source
    datasources.global.location=[local|$PATH_TO_DIR_WITH_datasources.properties_file]

    I'm having trouble finding documentation for this. However, I've had success with something like the following:

    datasources.global.file=replace_me_with_path_to_dir_having_datasources_dot_properties_file
    datasources.global.location=shared
    

    I think datasources.properties is correct. Please verify you have the correct location and your tests are configured to use the data source described there.

  • Ireneusz SzmigielIreneusz Szmigiel Posts: 139 ✭✭
    edited November 2017

    Hi Urs,
    yes, I made a typo.
    @benken_parasoft is right you should use:

    datasources.global.file= path_to_dir
    datasources.global.location=shared

    Somehow during copy&past, I lost the first property.

    You can, however, get those option directly from SOAtest GUI:
    create workspace

    • go to Parasoft>Preferences> Global Data Sources
    • select "Shared File" and provide directory location
    • go back to workspace and configure required datasources
    • go back to Parasoft and select option share (select global data sources)

    It will create for you part of localsettings file

    Ireneusz Szmigiel

  • UrsUrs Posts: 13

    tnx @benken_parasoft and @Ireneusz Szmigiel
    I will try this today.

    but I had to delete the global data sources yesterday as the .tst files opened really slowly with so many (72!) excel data sources configured as global.
    is that your experience as well?

    that was the reason why I changed from having one tst file with all regression data sources to many tst files with single excels defined in each.

    if I make a step backwards with globals i might not change the current setup.

    but i intend to complete this test with globals this sprint to document the setup in our confluence how-to pages for SOAtest. maybe another project can use it.

  • Ireneusz SzmigielIreneusz Szmigiel Posts: 139 ✭✭
    edited November 2017

    Hi Urs,

    did you try to use Data Repository Server?
    Maybe you should go in that direction?

    Ireneusz Szmigiel

  • UrsUrs Posts: 13

    that will be the next step. but nicole had some trouble using globals on jenkins so I wanted to figure that step out first.

  • benken_parasoftbenken_parasoft Posts: 462 ✭✭✭
    edited November 2017

    .tst files opened really slowly with so many (72!) excel data sources configured as global.

    Do all your tst files use all 72 Excel files? If not, then this may not be a good approach. All 72 Excel files would be getting loaded into memory all at once. This takes time and may consume a lot of memory, negatively affecting performance.

    Additionally, some actions in SOAtest can trigger datasources to be refreshed (reloaded all over again) to make sure the column data in memory is current. SOAtest may do this after opening a tst or just prior to executing a test suite.

    that was the reason why I changed from having one tst file with all regression data sources to many tst files with single excels defined in each.

    If let's say you now have 72 tst files where each one really only uses one of the 72 Excel files then you should probably define a separate Excel data source in each tst instead of defining all data sources globally.

    However, global test data management does have benefits. As mentioned, Parasoft's Data Repository server is intended for this combined with Parasoft's new Test Data Assistant (TDA) which " enables you to manage all of the Parasoft data repositories your team or organization uses for testing and service virtualization". I highly recommend checking out TDA!

  • UrsUrs Posts: 13

    thank you for that explanation.
    That's about what I had figured and sort of "proven by experience" by separating them into tst to excel pairs.

    but as you pointed out, changing to data repository instead of excels will be our next iteration.
    it will also save us tons of space on git, we now waste due to the excels being binary data.

    thanks again for all your help.

Sign In or Register to comment.