Hi Inflectra, I have a conundrum. I have successfully been able to parameterize Rapise tests using Excel as mentioned in the Rapise documentation. However, now I'm wanting to integrate this with SpiraTeam, the ST documentation tells me that I parameterise my tests per test instance within ST. It defines some code for identifying a default value for variables that receive no input from ST but not how or where I place this inside my script. So we have two methods. One - read from excel. Two - read from ST. Which method should I implement for integration with ST and if the second, then how do I change my excel parameterized script into an ST parameterized script? Thanks again, ROAMES. en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/issues-questions/199.aspxthreadId=199Nick v (nick.vandernet@roames.com.au) Hi Inflectra, I have a conundrum. I have successfully been able to parameterize Rapise tests using Excel as mentioned in the Rapise documentation. However, now I'm wanting to integrate this with SpiraTeam, the ST documentation tells me that I parameterise my tests per test instance within ST. It defines some code for identifying a default value for variables that receive no input from ST but not how or where I place this inside my script. So we have two methods. One - read from excel. Two - read from ST. Which method should I implement for integration with ST and if the second, then how do I change my excel parameterized script into an ST parameterized script? Thanks again, ROAMES. Thu, 17 Nov 2011 05:54:08 -05002011-11-23T23:38:51-05:00/Support/Forum/spirateam/issues-questions/199.aspxmessageId=384David J (adam.sandman+support@inflectra.com) Hi Nick Any global variable inside Rapise can be passed a value from SpiraTest (in the test set). The Library Information System sample project in Rapise shows an illustration of this. Since SpiraTest only supports lower-case parameters, make sure the Javascript variable names in Rapise are all lower case. The choice whether to use SpiraTest or Excel to parameterize your tests is up to you. The advantage of Excel is that it's easier to manage large tables of test data (at least currently). SpiraTest allows you to write a generic test in Rapise and have less technical users pass different values to that test using the web interface of SpiraTest. So on balance: Excel - better for large data tables SpiraTest - easier to split work between test script coder and QA designers If you have code written using Excel: Spreadsheet.DoAttach('searchterms.xls', 'Sheet1'); // Go through all rows while(Spreadsheet.DoSequential()) { // Read cell value from column 0 var term = Spreadsheet.GetCell(0); // Pass it into Logic function Logic(term); } Then to switch over to SpiraTest you'd create a Test Set and add the same Test Case for each specific instance of the test (i.e. each row in Excel) and set the parameter values of the test. Then inside Rapise you'd use simple variables such as: if ('undefined' == typeof(g_term)) { g_term = 'value if not called from SpiraTest'; } Logic (g_term); Since the looping is done by RapiseLauncher and SpiraTest (based on the Test Set) not by Rapise itself. Wed, 23 Nov 2011 17:28:57 -05002011-11-23T17:28:57-05:00/Support/Forum/spirateam/issues-questions/199.aspx#reply384messageId=388Nick v (nick.vandernet@roames.com.au) Awesome explanation. Very clear now. Thank you so much :) Wed, 23 Nov 2011 23:38:51 -05002011-11-23T23:38:51-05:00/Support/Forum/spirateam/issues-questions/199.aspx#reply388