Grown up way of handling keyword tests/projects and all their variables.

Hi lowres,

There are a few options, AI Test Data Generation may allow you to reduce your dependency on spreadsheets.  I am not sure this would work if you need known custom data. The use of a database would be another good option if you need to store larger sets of custom data.    Managing a lot of spreadsheets sounds like it would quickly become a burden if you go out to several hundred tests.  You could contain your test data in several sheets within the same Excel file to relieve some of the file management burden.  However you may hit data access issues if multiple testers are working from the same data file.  The separate Excel file method will hit this wall even with separate files.   Databases don't have this issue. 

• AI Test Data Generation:
  • https://support.smartbear.com/testcomplete/docs/testing-with/data-driven/generators/ai-wizard.html
• All the data driven test options:
  • https://support.smartbear.com/testcomplete/docs/testing-with/data-driven/index.html

If you learned SQL and a scripting language you could supplement your KWTs and they would scale much better.  This would allow those less skilled to continue using KWT and call the functions that are created in script.  There are many nice options available.  JavaScript and Python are very popular and the learning curve isn't too bad.  SQL isn't too bad for the simple things you will likely need.  There are free SQL options out there and learning to script costs you nothing but your time.

Microsoft® SQL Server® 2022 Express:

• https://www.microsoft.com/en-us/download/details.aspx?id=104781#:~:text=Microsoft%C2%AE%20SQL%20Server%C2%AE%202022%20Express%20is%20a%20powerful,Web%20Sites%20and%20desktop%20applications.

There are limits here but you can expand to a paid version as you needs expand.


... If you find my posts helpful drop me a like! 👍 Be sure to mark or post the solution to help others out and/or to credit the one who helped you. 😎