Forum Discussion

Tris's avatar
Tris
Contributor
6 years ago

Possible to use csv file for variables in script?

Hi all,   I'm attempting to use a csv file containing variables in a scripted function in order to use the variables within the csv file to generate a connection string.   I've had a good look ar...
Tris's avatar
Tris
Contributor

Thanks tristaanogre,

 

I've taken your advice and implemented a .ini file instead, this way seems more efficiant as you can just declare the variable from the file. 

 

I can then use the declared variable to build the connection string.

 

Many thanks again!

Tris

Tris's avatar
Tris
Contributor
6 years ago

Incase anyone else is looking for how to implement this, I scripted a simple funciton to read the ini file and take the vaIue I want from it, I then use this to define my variables, see below.

 

    function DatabaseVariables(){
        var ini = Storages.INI("C:\\Automation\\DatabaseVariables.ini");
        SQLServerName = ini.GetSubSection("DatabaseVariables").GetOption("SQLServerName", "");
        DatabaseName = ini.GetSubSection("DatabaseVariables").GetOption("DatabaseName", "");
        DatabaseUserName = ini.GetSubSection("DatabaseVariables").GetOption("DatabaseUserName", "");
        DatabasePassword = ini.GetSubSection("DatabaseVariables").GetOption("DatabasePassword", "");
        DatabaseMasterName = ini.GetSubSection("DatabaseVariables").GetOption("DatabaseMasterName", "");
        SQLServerInstance = ini.GetSubSection("DatabaseVariables").GetOption("SQLServerInstance", "");        
}

 

The above reads the ini file which looks like the below example

 

; IMPORTANT: The Root section is required
[Root]

[Settings]
Access=ReadWrite
Type=1

[DatabaseVariables]
SQLServerName=VALUE
DatabaseName=VALUE
DatabaseUserName=VALUE
DatabasePassword=VALUE
DatabaseMasterName=VALUE
SQLServerInstance=VALUE

So, given the above, all values defined in the ini would come back as VALUE (no formatting around the string, just the plain string). 

 

Note you can just create a plain text file and change the extension to .ini and this will become an ini file.

 

Hope this helps someone in the future, thanks again to Tristaanogre!