Forum Discussion

TanyaYatskovska's avatar
TanyaYatskovska
Icon for Alumni rankAlumni
9 years ago
Solved

Code Contest: Export/Importing Project Variables

Hello Community,   We are announcing the first Code Contest in our TestComplete Community. All of you can take part in the contest to check/improve your skills and win the main prize. I hope for ...
  • TanyaYatskovska's avatar
    TanyaYatskovska
    9 years ago

    Hello Community,

     

    At the beginning of my speech, I want to say big thanks to everyone who took part in our first Code Contest!

    It was difficult for us to choose the winner as all of your works are great and worth using in TestComplete. To make the ultimate decision, we took into account these three criteria: functionality, extension’s GUI and usability.

     

    Here are the extensions that made it to the final posted by:

    cunderw

    StevenN

    baxatob

     

     

    And, the Oscar goes to… oops, sorry… and, the winner is StevenN!

     

    Congrats, Steven!

    I will contact you shortly to describe how you can get the main prize – a $50 gift card.

     

    Please join me in saying thank you to all the participants and congratulating Steven.

     

     

    And, be ready for the next contest…

baxatob's avatar
baxatob
Community Hero
9 years ago

Hi guys!

 

Please meet my beta :)

 

Code to export variables:

 

function export_variables()
{
    var var_count = Project.Variables.VariableCount;
    var name, type, value;
    var path, fso, file;
    
    UserForms.ctcForm.SaveDialog1.Execute();
    path = UserForms.ctcForm.SaveDialog1.FileName;
    
    fso = new ActiveXObject("Scripting.FileSystemObject");
    file = fso.OpenTextFile(path, 2, true);    
    
    for (var i=0; i<var_count; i++)
    {
        name = Project.Variables.GetVariableName(i);
        value = Project.Variables.VariableByName(name);
        type = Project.Variables.GetVariableType(i);
        var record = new Array(name, value, type);
        file.WriteLine(record);
    }
    
    file.Close();
}

Code to import variables:

 

function import_variables()
{
    var dialog = UserForms.dialog
    var path, fso, file, set;
    
    UserForms.ctcForm.OpenDialog1.Execute();
    path = UserForms.ctcForm.OpenDialog1.FileName;
    
    if (path)
    {
        fso = new ActiveXObject("Scripting.FileSystemObject");
        file = fso.OpenTextFile(path, 1); 
    
        while (!file.AtEndOfStream)
        {
            record = file.ReadLine().split(",");
            try
            {
                Project.Variables.AddVariable(record[0], record[2]);
            }
            catch(exception)
            {
                gui_dialog("Unable to import variable: "+record[0], exception);
            }
        }
    
        file.Close(); 
    } 
    else
    {
        gui_dialog("You have not selected the file for import!", "");
    } 
}

 

Code to provide gui dialogues:

 

function gui_dialog(label1, label2)
{
    var dialog = UserForms.dialog
    dialog.Caption = "Import variables";
    dialog.cxLabel1.Caption = label1;
    dialog.cxLabel2.Caption = label2;
    dialog.ShowModal();    
}

 

.tcx file to install the script extension you can find in the attachment.

 

It should looks like:

 

 

Waiting for your feedback and good luck for others!

 

P.S. Feature request to TC developers - it's better to have all custom buttons in the separate toolbar section.

 

P.P.S. Updated to v.1.1