Forum Discussion

HaroldR's avatar
HaroldR
Contributor
7 years ago

Populate string inside Excel Data Sink fields from groovy script

Hey,  Context : Let's say that I have appended a DataSink Teststep manually which I have named "DataSink", feature which is provide naturally in the UI of ReadyAPI. Now, I would like to get thi...
  • groovyguy's avatar
    groovyguy
    7 years ago

    The first part you can handle by setting up the following groovy script:

     

    def dataSink = context.testCase.testSteps["DataSink"];
def excel = dataSink.getDataSink();

    You would use the details on the link you posted on the excel variable to adjust the file paths and settings specific to the Excel data source. Example:

     

    excel.setFileName("C:\\temp\\Book1.xlsx");

    You would use the dataSink variable to adjust the actual properties/values of the Data Sink. Example:

    dataSink.setPropertyValue("PropertyName", "This Is My Property Value");

    Hope that helps!

     

groovyguy's avatar
groovyguy
Community Hero

The first part you can handle by setting up the following groovy script:

 

def dataSink = context.testCase.testSteps["DataSink"];
def excel = dataSink.getDataSink();

You would use the details on the link you posted on the excel variable to adjust the file paths and settings specific to the Excel data source. Example:

 

excel.setFileName("C:\\temp\\Book1.xlsx");

You would use the dataSink variable to adjust the actual properties/values of the Data Sink. Example:

dataSink.setPropertyValue("PropertyName", "This Is My Property Value");

Hope that helps!

 

HaroldR's avatar
HaroldR
Contributor
7 years ago

Hello groovyguy,

That'it, thaks you. 

Here, I share my script aaccording to my need :

def dataSink = context.testCase.testSteps["ExcelDataSink"];
def excel = dataSink.getDataSink();

def environmentName = testRunner.testCase.testSuite.project.activeEnvironment.name;

if (environmentName == "Integration"){
	excel.setFileName("E:\\SoapUi_Workspaces\\ProjectsToDeliver\\fr-cevia-v2-vs\\TestCaseResult\\fr-cevia-v2-vs_GenericTable.xls");
	excel.setOutFileName("E:\\SoapUi_Workspaces\\ProjectsToDeliver\\fr-cevia-v2-vs\\TestCaseResult\\INT\\CheckSdcAuthorisationTestSuite\\CheckSdcAuthorisationTestCaseResult[INT].xls");
	excel.setWorksheet("CEVIA_V2");
	excel.setEvaluateFormulas(false);
	dataSink.setPropertyValue("CheckSdcAuthorisationTestCaseResult", '${#TestCase#Status}');
	excel.setStartCell("K2");
} else if (environmentName == "Recette"){
	excel.setFileName("E:\\SoapUi_Workspaces\\ProjectsToDeliver\\fr-cevia-v2-vs\\TestCaseResult\\fr-cevia-v2-vs_GenericTable.xls");
	excel.setOutFileName("E:\\SoapUi_Workspaces\\ProjectsToDeliver\\fr-cevia-v2-vs\\TestCaseResult\\REC\\CheckSdcAuthorisationTestSuite\\CheckSdcAuthorisationTestCaseResult[REC].xls");
	excel.setWorksheet("CEVIA_V2");
	excel.setEvaluateFormulas(false);
	dataSink.setPropertyValue("CheckSdcAuthorisationTestCaseResult", '${#TestCase#Status}');
	excel.setStartCell("K2");
} else if (environmentName == "PreProd"){
	excel.setFileName("E:\\SoapUi_Workspaces\\ProjectsToDeliver\\fr-cevia-v2-vs\\TestCaseResult\\fr-cevia-v2-vs_GenericTable.xls");
	excel.setOutFileName("E:\\SoapUi_Workspaces\\ProjectsToDeliver\\fr-cevia-v2-vs\\TestCaseResult\\PP\\CheckSdcAuthorisationTestSuite\\CheckSdcAuthorisationTestCaseResult[PP].xls");
	excel.setWorksheet("CEVIA_V2");
	excel.setEvaluateFormulas(false);
	dataSink.setPropertyValue("CheckSdcAuthorisationTestCaseResult", '${#TestCase#Status}');
	excel.setStartCell("K2");
} else if (environmentName == "Prod"){
	excel.setFileName("E:\\SoapUi_Workspaces\\ProjectsToDeliver\\fr-cevia-v2-vs\\TestCaseResult\\fr-cevia-v2-vs_GenericTable.xls");
	excel.setOutFileName("E:\\SoapUi_Workspaces\\ProjectsToDeliver\\fr-cevia-v2-vs\\TestCaseResult\\PROD\\CheckSdcAuthorisationTestSuite\\CheckSdcAuthorisationTestCaseResult[PROD].xls");
	excel.setWorksheet("CEVIA_V2");
	excel.setEvaluateFormulas(false);
	dataSink.setPropertyValue("CheckSdcAuthorisationTestCaseResult", '${#TestCase#Status}');
	excel.setStartCell("K2");
} else {
	log.info("Default Environment");
}