MikeSchmid
Occasional Contributor
Joined 14 years ago
User Profile
User Widgets
Contributions
Having an odd problem with Excel
I read my data from an excel spreadsheet to populate my test fields. Today I ran across an odd problem and was wondering if anyone has any suggestions. I modified one of my excel spreadsheets today, but when I execute my test it is using the prior revision of the spreadsheet somehow. I tried rebooting in case it was a cache problem, but had no luck with that.1.3KViews0likes1CommentRe: Reading variables for Testcomplete project from excel or csv files
You can use the DDT excel driver to open a spreadsheet and read through the row and set your variables to the contents of what is in the spreadsheet for your initial variables. Look up DDTDriver Object in the help and it explains how to use it.1.1KViews0likes0CommentsRe: TestExecute with remote desktop VS distributed tests
I run multiple Remote Desktops to use Test Execute. I did have some issues at first due to minimizing the RD. Once it is minimized it no longer recognizes it as a gui interface and my test would stop working. I made an easy registry entry to solve it. Hope this helps you. Log in to the computer from which you connect to remote computers (if you are not logged in yet). Close all open Remote Desktop sessions. Click Start and select Run. In the Run dialog box, type regedit and press Enter . The Registry Editor starts. Navigate to one of the following Registry keys, depending on whether you wish to modify the Remote Desktop settings only for the current user or for all users on the computer: HKEY_CURRENT_USER\Software\Microsoft\Terminal Server Client HKEY_LOCAL_MACHINE\Software\Microsoft\Terminal Server Client Create a DWORD value named RemoteDesktop_SuppressWhenMinimized and set it to 2. Close the Registry Editor.1.5KViews0likes0CommentsRe: Can I make a Project wide Variable for Username and Password ?
Alternately you can set up a project variable or project suite variable. Open the project item and click the variables tab. Set up your temporary variable variables. Since you want them hidden leave the default values blank. Then when you want to populate them all you have to do is set Project.Variables.variable name=value or ProjectSuite.Variables.variable name=value And clear them at the end of the run.975Views1like0CommentsExporting DBTables to excel
Since TestComplete does not provide a way to export the contents of DBTables I wrote my own script to export it to excel. I have one problem however. There is currently no way to retrieve the column names from DBTables. I can get the column index by passing in the column name if I already know it, but I do not want that, I want to pass in the column index and be returned the column name associated with it. Obviously it knows what to do with the column names since it can pass back an index. It needs another method to pass back the column name.2.1KViews0likes2CommentsRe: Unable to open DDT driver suddenly
I also had a problem where all of a sudden any script I had that used an excel driver stopped working. Unable to even open the first time on a new boot. I have narrowed it down to the fact that a recent windows update changed how the excel drivers work. If the spreadsheets are read only, as they would be if you are using source code control correctly, then it will not work. If I made the spreadsheets writable then it all worked fine again. this is a huge problem for people using excel for Data Driven Testing.948Views0likes0Comments