{"id":2945,"date":"2019-03-25T17:41:57","date_gmt":"2019-03-25T20:41:57","guid":{"rendered":"http:\/\/xexeu.elipse.com.br\/pt\/accessing-text-files-via-e3\/"},"modified":"2019-10-03T13:10:36","modified_gmt":"2019-10-03T16:10:36","slug":"accessing-text-files-via-e3","status":"publish","type":"post","link":"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/","title":{"rendered":"Accessing text files via E3."},"content":{"rendered":"
\n

1) Introduction<\/span><\/p>\n

Sometimes, you will need to follow the details of the values of an application’s data: to check whether the data already has the expected value or when a script’s excerpt is not acceptable, to know how far the script has gone or where the error is, to verify the return value of a certain function, etc. By generating our own logs, we can easily monitor these items. To create these logs, the best tools are the functions for creating and accessing text files, which are supported by VBScript, available at E3.<\/p>\n

To illustrate how this item works, we will show you how to generate the log of an OPC communication, where E3 will work as both the server and the client at the same time.<\/p>\n

2) Development<\/span><\/p>\n

Creating the Project<\/span><\/p>\n

When you start E3 Studio, choose the option Create new project<\/span>, and then Standard Application<\/span>. Name your project TrainingTXT <\/span>and choose a folder to save the application. Create a new domain with the same name as the project. Answer No <\/span>to the next three questions on screen.<\/p>\n

At Data <\/span>folder, create an internal tag and a demo tag, which will work as the data to be transferred via OPC. Increase the demo tag’s Scan <\/span>to\u00a0 10000. Star the domain to initialize the OPC Server.<\/p>\n

To set up the application as OPC Client, insert an OPC driver into the project. At the driver’s properties, access OPC Driver<\/span> tab and search, via Select <\/span>button, for E3 OPC Server (Elipse.OPCSvr.1)<\/span> in Local Servers<\/span>.\u00a0 To enable the import of tags created in the project, activate the communication.<\/p>\n

\"\"
\nFigure 1<\/span>: Select OPC Server <\/span><\/div>\n

Return to the Organizer<\/span>, right-click OPCDriver<\/span>, and choose the option Import Tags<\/span>. E3 will ask you if you want to create a group to continue the import process, and then if you would like to detect the available OPC tags; click Yes <\/span>on both questions.<\/p>\n

The OPC Tags Import<\/span> window will be opened. On the right side, inside Data <\/span>folder, select DemoTag1 <\/span>and drag it to OPCGroup1 <\/span>to the left. Do the same with InternalTag1<\/span>. The result is illustrated in the figure below.<\/p>\n

\"\"
\nFigure 2<\/span>: Tags import<\/span><\/div>\n

Set up the InitialScreen <\/span>similarly to what is on Figure 3. Link the two displays to the left to the OPC tags’ Value <\/span>property, and the setpoint to the right to the InternalTag’s Value <\/span>property. Enable MultiBox’s MultiLine <\/span>property (TRUE).<\/p>\n

\"\"
\nFigure 3<\/span>: Initial Screen<\/span><\/div>\n

To check whether the application is working, execute the project before the scripts for writing in the file are implemented. On InitialScreen<\/span>, the values of the internal tag and the OPC tags must be the same. Change these values in a setpoint, and then repeat them in another setpoint.<\/p>\n

Scripts<\/span><\/p>\n

Once it has been confirmed that the data are correctly being sent and received via OPC protocol, the scripts for reading and writing in text files will be implemented.<\/p>\n

The first item to be logged to files is the OPC server identification, as soon as it is initialized. This will happen after the domain has been executed. The server’s ID <\/span>and Name <\/span>properties, as well as the name of the OPCDriver object in E3, will be at the beginning of the file.<\/p>\n

To do so, add the following script to the OPCDriver’s OnStartRunning <\/span>event:<\/p>\n

Const ForReading = 1, ForWriting = 2, ForAppending = 8<\/span>

Dim fso, f<\/span>
Set fso = CreateObject(“Scripting.FileSystemObject”)<\/span>
Set f = fso.OpenTextFile(“C:\\LogOPC.txt”, ForWriting, True)<\/span>

f.WriteLine Name<\/span>
f.WriteLine CStr( “ServerID: ” & ServerId )<\/span>
f.WriteLine CStr( “ServerName: ” & ServerName )<\/span>
f.WriteLine<\/span>

f.Close<\/span><\/div>\n

To have a new line added to the log file at every variation in value of the OPC tags, create a new event called Change <\/span>in each OPC tag and link it to Value<\/span> property. Figure 4 illustrates how to implement these events.<\/p>\n

\"\"
\nFigure 4<\/span>: Creating new events <\/span><\/div>\n

After these new events have been created, insert the code below in each one of them. Since this is a developed script, you can only copy the code from one event to another, with no need to change it.<\/p>\n

set Valor = Item(1) ‘Points to tag’s Value property <\/span>
DateTime = Valor.TimeStamp<\/span>
Grupo = Parent.Name<\/span>

‘ Adds new lines in the log file <\/span>
Const ForReading = 1, ForWriting = 2, ForAppending = 8<\/span>
Dim fso, f<\/span>

Set fso = CreateObject(“Scripting.FileSystemObject”)<\/span>
Set f = fso.OpenTextFile(“C:\\LogOPC.txt”, ForAppending, False)<\/span>

‘ Event Time Group Variable name Value <\/span>
f.WriteLine DateTime & ” ” & Group & ” ” & Name & ” ” & Value<\/span>
f.Close<\/span><\/div>\n

To allow visualizing the generated file, a script will be created for reading it. To do so, insert the code below into InitialScreen<\/span>‘s button’s Click <\/span>event:<\/p>\n

Const ForReading = 1, ForWriting = 2<\/span>

Dim fso, f<\/span>
Set fso = CreateObject(“Scripting.FileSystemObject”)<\/span>
Set f = fso.OpenTextFile(“C:\\LogOPC.txt”, ForReading)<\/span>

Screen.Item(“TextBox1”).Value = f.ReadAll<\/span>
f.Close<\/span><\/div>\n

Execute the application and check the result of these implementations.<\/p>\n

3) Final Remarks<\/span><\/p>\n

Usually, the use of log files helps locating errors in developed applications, especially when it comes to objects that are executed in the server, such as tags, historics, etc. For such purposes, an interesting tool available in VBScript language is the access to these files via FileSystemObjects<\/span>, which have a powerful set of methods for reading and writing in files. The complete documentation of these objects, as well as other examples of their usage, is in the VBScript tutorial that comes along with E3’s installation.<\/p>\n<\/div>\n

 <\/p>\n

Attachments:<\/h3>\n

Sample.zip<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Autor
\nPaula Pereira En\u00e9as<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"_exactmetrics_sitenote_active":false,"_exactmetrics_sitenote_note":"","_exactmetrics_sitenote_category":0},"categories":[763],"tags":[],"yoast_head":"\nAccessing text files via E3. - Elipse Knowledgebase<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Accessing text files via E3.\" \/>\n<meta property=\"og:description\" content=\"Autor Paula Pereira En\u00e9as\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/\" \/>\n<meta property=\"og:site_name\" content=\"Elipse Knowledgebase\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/elipsesoftware\" \/>\n<meta property=\"article:published_time\" content=\"2019-03-25T20:41:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2019-10-03T16:10:36+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4618\/Figura1.png\" \/>\n<meta name=\"author\" content=\"Elipse Software\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Elipse Software\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/\"},\"author\":{\"name\":\"Elipse Software\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\"},\"headline\":\"Accessing text files via E3.\",\"datePublished\":\"2019-03-25T20:41:57+00:00\",\"dateModified\":\"2019-10-03T16:10:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/\"},\"wordCount\":881,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"articleSection\":[\"Scripts\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/\",\"url\":\"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/\",\"name\":\"[:pt]Accessing text files via E3.[:] - Elipse Knowledgebase\",\"isPartOf\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#website\"},\"datePublished\":\"2019-03-25T20:41:57+00:00\",\"dateModified\":\"2019-10-03T16:10:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/kb.elipse.com.br\/en\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Accessing text files via E3.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/kb.elipse.com.br\/#website\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"name\":\"Elipse Knowledgebase\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/kb.elipse.com.br\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/kb.elipse.com.br\/#organization\",\"name\":\"Elipse Software\",\"url\":\"https:\/\/kb.elipse.com.br\/\",\"sameAs\":[\"http:\/\/www.facebook.com\/elipsesoftware\"],\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"contentUrl\":\"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png\",\"width\":161,\"height\":58,\"caption\":\"Elipse Software\"},\"image\":{\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87\",\"name\":\"Elipse Software\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g\",\"caption\":\"Elipse Software\"},\"url\":\"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Accessing text files via E3. - Elipse Knowledgebase","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/","og_locale":"en_US","og_type":"article","og_title":"[:pt]Accessing text files via E3.[:] - Elipse Knowledgebase","og_description":"[:pt]Autor Paula Pereira En\u00e9as[:]","og_url":"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/","og_site_name":"Elipse Knowledgebase","article_publisher":"http:\/\/www.facebook.com\/elipsesoftware","article_published_time":"2019-03-25T20:41:57+00:00","article_modified_time":"2019-10-03T16:10:36+00:00","og_image":[{"url":"http:\/\/kb.elipse.com.br\/pt-br\/images\/ID4618\/Figura1.png"}],"author":"Elipse Software","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Elipse Software","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/#article","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/"},"author":{"name":"Elipse Software","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87"},"headline":"Accessing text files via E3.","datePublished":"2019-03-25T20:41:57+00:00","dateModified":"2019-10-03T16:10:36+00:00","mainEntityOfPage":{"@id":"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/"},"wordCount":881,"commentCount":0,"publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"articleSection":["Scripts"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/","url":"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/","name":"[:pt]Accessing text files via E3.[:] - Elipse Knowledgebase","isPartOf":{"@id":"https:\/\/kb.elipse.com.br\/#website"},"datePublished":"2019-03-25T20:41:57+00:00","dateModified":"2019-10-03T16:10:36+00:00","breadcrumb":{"@id":"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kb.elipse.com.br\/en\/accessing-text-files-via-e3\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/kb.elipse.com.br\/en\/"},{"@type":"ListItem","position":2,"name":"Accessing text files via E3."}]},{"@type":"WebSite","@id":"https:\/\/kb.elipse.com.br\/#website","url":"https:\/\/kb.elipse.com.br\/","name":"Elipse Knowledgebase","description":"","publisher":{"@id":"https:\/\/kb.elipse.com.br\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kb.elipse.com.br\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/kb.elipse.com.br\/#organization","name":"Elipse Software","url":"https:\/\/kb.elipse.com.br\/","sameAs":["http:\/\/www.facebook.com\/elipsesoftware"],"logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/","url":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","contentUrl":"https:\/\/kb.elipse.com.br\/wp-content\/uploads\/2019\/05\/schererelipse-com-br\/logoElipse.png","width":161,"height":58,"caption":"Elipse Software"},"image":{"@id":"https:\/\/kb.elipse.com.br\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/def69ea453ea60b250497b89225a9f87","name":"Elipse Software","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/kb.elipse.com.br\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ff1f7ec38f4687b06f6851d97b3cd2d0?s=96&d=mm&r=g","caption":"Elipse Software"},"url":"https:\/\/kb.elipse.com.br\/en\/author\/webmasterelipse-com-br\/"}]}},"_links":{"self":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2945"}],"collection":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/comments?post=2945"}],"version-history":[{"count":1,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2945\/revisions"}],"predecessor-version":[{"id":5513,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/posts\/2945\/revisions\/5513"}],"wp:attachment":[{"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/media?parent=2945"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/categories?post=2945"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kb.elipse.com.br\/en\/wp-json\/wp\/v2\/tags?post=2945"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}