KB-47758: Exporting data from SQL Server to Excel.
Question: How can a table be exported from SQL Server to Excel? Solution: To do so, follow these procedures: 1. Create a spreadsheet whose first row works as a column…
Category: Scripts
Reading data from an XML file in E3.
1) Introduction This article shows you how to collect data from an XML file. 2) XML file XML (EXtensible Markup Language) is a format for creating documents where data is…
KB-56685: When executing a .WAV file for each active alarm, wmplayer.exe is displayed in the task manager.
Question: I have a script that executes a .WAV file via ExecuteExternalApp method. For each active alarm, the executable command wmplayer.exe is displayed in the task manager, consuming more memory…
When executing a command via scripts, “Error creating VBScript object” is displayed in the log.
Question: When executing a command via scripts, “Error creating VBScript object” is displayed in the log. How can I fix this? Solution: Elipse E3 uses Visual Basic 32 bits as…
Automation in code generation: Lesson 4 – Scanning specific objects in a location.
Another possibility is to use the technique of scanning a certain location (such as a data folder or a substation) to look for specific types of objects (internal tags, switchers,…
Automation in code generation: Lesson 5 – Adding objects via scripts.
Most Elipse E3’s and Elipse Power’s objects can be inserted via scripts with AddObject method: AddObject(ClassName[[, Activate], ObjectName]) This method’s parameters are: ClassName: indicates the type of object to be…
Automation in code generation: Lesson 6 – Checking for pre-existing objects.
In scripts that create objects automatically, it is important to check whether such objects have already been created in the application, in order to avoid duplicated objects or even script…
Automation in code generation: Lesson 1 – Working with vectors.
A vector is a one-dimensional matrix with n positions. Each position can store a value of any type. Vectors are commonly used in automated scripts, because they allow multiple values…
Automation in code generation: Lesson 3 – Changing a string into a vector.
For the purposes of this article, we will consider option 1 from Lesson 2 is being used. After the .csv file has been read, we are left with a string…
KB-56005: Checking whether the program is being executed.
Question: Can I check, via scripts, if a program is being executed? Solution: Yes. By using winmgmts object and accessing the Win32_process instances, you can scan the name of all…