<?xml version='1.0' encoding='UTF-8'?><?xml-stylesheet href="http://www.blogger.com/styles/atom.css" type="text/css"?><feed xmlns='http://www.w3.org/2005/Atom' xmlns:openSearch='http://a9.com/-/spec/opensearchrss/1.0/' xmlns:blogger='http://schemas.google.com/blogger/2008' xmlns:georss='http://www.georss.org/georss' xmlns:gd="http://schemas.google.com/g/2005" xmlns:thr='http://purl.org/syndication/thread/1.0'><id>tag:blogger.com,1999:blog-5486583048777389584</id><updated>2024-09-04T18:33:27.694+05:30</updated><category term="TestComplete Coding"/><category term="Testcomplete integration with Technologies"/><category term="Data Driven Testing"/><category term="Test Automation Basics"/><category term="TestComplete Test Execution"/><category term="TestComplete 8"/><category term="TestComplete Test Methodology"/><title type='text'>Success with TestComplete Test Automation</title><subtitle type='html'></subtitle><link rel='http://schemas.google.com/g/2005#feed' type='application/atom+xml' href='http://darshikaj.blogspot.com/feeds/posts/default'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default?redirect=false'/><link rel='alternate' type='text/html' href='http://darshikaj.blogspot.com/'/><link rel='hub' href='http://pubsubhubbub.appspot.com/'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><generator version='7.00' uri='http://www.blogger.com'>Blogger</generator><openSearch:totalResults>12</openSearch:totalResults><openSearch:startIndex>1</openSearch:startIndex><openSearch:itemsPerPage>25</openSearch:itemsPerPage><entry><id>tag:blogger.com,1999:blog-5486583048777389584.post-5236600840489097028</id><published>2011-01-25T15:04:00.003+05:30</published><updated>2011-01-25T15:12:29.397+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="TestComplete 8"/><category scheme="http://www.blogger.com/atom/ns#" term="TestComplete Coding"/><category scheme="http://www.blogger.com/atom/ns#" term="Testcomplete integration with Technologies"/><title type='text'>How to test Silverlight 4 Applications using TestComplete 8</title><content type='html'>&lt;strong&gt;TestComplete 8&lt;/strong&gt; provides greater support to verify &lt;strong&gt;&lt;em&gt;Microsoft Silverlight 4 &lt;/em&gt;&lt;/strong&gt;application components by using any functional test methodology such as black-box and white-box test mechanisms. In this version of test complete engine can access Silverlight internal objects, methods, properties and fields in order to automate applications. &lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
In order to track Silverlight components by testcomplete engine, first you require to check following “Extend Silverlight Object Tree” checkbox option by navigating to Tools -&amp;gt; Default Project Properties -&amp;gt; Projects -&amp;gt; Open Application -&amp;gt; Silverlight. Subsequent that, the test complete engine will have access to Silverlight objects and their methods, properties and fields and you can employ those elements in your automated tests. (Pls. refer the following screen cap) &lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZR57anT72cw3rrz1PbbB9SFZiETd9AjDpBUk-08bbBoZuEYFmBbtZfPbfxcDe3-Dj9ndCNbGPW0ONI1NhsZJTOMQSPNkWutrvEcWv_9pHlS_NJRLcnqfQs1F1KupQ04HTdfUEEC7Fwsoe/s1600/1.JPG&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; height=&quot;265&quot; s5=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZR57anT72cw3rrz1PbbB9SFZiETd9AjDpBUk-08bbBoZuEYFmBbtZfPbfxcDe3-Dj9ndCNbGPW0ONI1NhsZJTOMQSPNkWutrvEcWv_9pHlS_NJRLcnqfQs1F1KupQ04HTdfUEEC7Fwsoe/s400/1.JPG&quot; width=&quot;400&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Further, you can notice all Silverlight objects and their available methods and properties in the hierarchy of object tree model subsequent to explore browsers such as IE, Firefox.&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgc7ADbVUEZeEXgkILbmI2DIwVgGeWCSL5fAlcTk7N-6OirSwkjteDSUeFkefMbczEzIJZ26jCvFLvVeaM77WQGO5uqmwE-2H7j0shzEV93_VHLcn7sy1h6mBlfPR3rLDy6Ebmlqte2wLlR/s1600/2.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; s5=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgc7ADbVUEZeEXgkILbmI2DIwVgGeWCSL5fAlcTk7N-6OirSwkjteDSUeFkefMbczEzIJZ26jCvFLvVeaM77WQGO5uqmwE-2H7j0shzEV93_VHLcn7sy1h6mBlfPR3rLDy6Ebmlqte2wLlR/s1600/2.jpg&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Now TestComplete introduce a new SlObject method in order to automate applications with Silverlight components. Using this method, users allow obtaining a Silverlight component by its name, which was stated in the application’s source code.&lt;br /&gt;
&lt;br /&gt;
Moreover, TestComplete also offers a SlApplication scripting object that is a wrapper to a Silverlight application’s main class that sum up application defined functionality and inherit methods and properties of the System.Windows.Application class. &lt;br /&gt;
&lt;br /&gt;
As well as the members of this System.Windows.Application class contains the SlClasses property. This property assist you for scripting interface to namespaces and assemblies classes included in your Silverlight application package in the.xap file.&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFLmIzJHO3SKi9xiSLivv7zUEiTxE6hdCUyvlidVpRu1hL0kfUw8_LtrV4qoVmF1CGVn4PpmPZhfyn0-zhcJeKfEDTlhdMOg7c-YVvtmo02aorkR3DVjUlz8uRzpuraLy6bpgyga1cU6ub/s1600/3.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; s5=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhFLmIzJHO3SKi9xiSLivv7zUEiTxE6hdCUyvlidVpRu1hL0kfUw8_LtrV4qoVmF1CGVn4PpmPZhfyn0-zhcJeKfEDTlhdMOg7c-YVvtmo02aorkR3DVjUlz8uRzpuraLy6bpgyga1cU6ub/s1600/3.jpg&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Now Testcomplete provide great opportunity to access static non visual objects and their public members by using SlClasses property. In addition to functional testing, this special feature allows you to perform unit/web component performance testing by using application’s internal classes and their associates.&lt;br /&gt;
&lt;br /&gt;
Hope that the above mentioned features will facilitate you easily creates more powerful automated tests for your Silverlight applications. &lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;http://smartbear.com/products/qa-tools/automated-testing/sign-up/&quot;&gt;&lt;strong&gt;To download TestComplete 8 Trial&lt;/strong&gt;&lt;/a&gt;</content><link rel='replies' type='application/atom+xml' href='http://darshikaj.blogspot.com/feeds/5236600840489097028/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://darshikaj.blogspot.com/2011/01/how-to-test-silverlight-4-applications.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/5236600840489097028'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/5236600840489097028'/><link rel='alternate' type='text/html' href='http://darshikaj.blogspot.com/2011/01/how-to-test-silverlight-4-applications.html' title='How to test Silverlight 4 Applications using TestComplete 8'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiZR57anT72cw3rrz1PbbB9SFZiETd9AjDpBUk-08bbBoZuEYFmBbtZfPbfxcDe3-Dj9ndCNbGPW0ONI1NhsZJTOMQSPNkWutrvEcWv_9pHlS_NJRLcnqfQs1F1KupQ04HTdfUEEC7Fwsoe/s72-c/1.JPG" height="72" width="72"/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5486583048777389584.post-6518858962445997072</id><published>2011-01-12T14:51:00.006+05:30</published><updated>2011-01-12T14:59:27.995+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Test Automation Basics"/><category scheme="http://www.blogger.com/atom/ns#" term="TestComplete 8"/><title type='text'>How to create your first Test with TestComplete 8</title><content type='html'>This article explains how to use testcomplete to record your actions over the application you required to test and replay the reordered actions as your expectation. &lt;br /&gt;
&lt;br /&gt;
Steps:&lt;br /&gt;
&lt;br /&gt;
1. Create New Project Suite by providing project suite name and location.&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiERhFAcN3FQXHnmh6SJbZIMYhaEKwzeGeoo5TRZh53PNB04JvIGDx8LZmFZrScM1Dr84IG0Y6d6M3eKY5doiZ5GG427RSncpgEhGb487QqFgRYB3oGBiNXV2f58TnwBdDQYEQmm2hst0Ay/s1600/1.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiERhFAcN3FQXHnmh6SJbZIMYhaEKwzeGeoo5TRZh53PNB04JvIGDx8LZmFZrScM1Dr84IG0Y6d6M3eKY5doiZ5GG427RSncpgEhGb487QqFgRYB3oGBiNXV2f58TnwBdDQYEQmm2hst0Ay/s1600/1.jpg&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
2. Create new project under above project suite by specifying the name, location and other attribute of a new project and press next button.&lt;br /&gt;
&lt;br /&gt;
&lt;div style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggGTE3Arxx3x-Qjd_RhyW7VYSy0l4gohnmBarLO07e7t_vUz29tnq-XM3RCZNmqiy4CrWrhLpxyrxyQ6HI2uaMkir4dmUIuqMaZV34ibh0w6sQ_8gjoIIWjNJHvf4MAIo9hjPmRcpWxzpI/s1600/2.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEggGTE3Arxx3x-Qjd_RhyW7VYSy0l4gohnmBarLO07e7t_vUz29tnq-XM3RCZNmqiy4CrWrhLpxyrxyQ6HI2uaMkir4dmUIuqMaZV34ibh0w6sQ_8gjoIIWjNJHvf4MAIo9hjPmRcpWxzpI/s1600/2.jpg&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
3. From this wizard window you allow to specify the type of the application under test. (For this example I opt for web application type).&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
4. Press Next to move for selecting testing methodology.&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNxQALba2CoSzZxhhwD1QYHsQ8CDdmIKt2lA5UrLT6bXbUsq5Tm38w_5SZOFii-Y3L5mbM1XHMBYwEmTHF2zr9I9tpAXpYY-Ec8_o05N6Pxjh6X4k0qBmHZKOclhgj29TDF6YpVM04sihs/s1600/3.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiNxQALba2CoSzZxhhwD1QYHsQ8CDdmIKt2lA5UrLT6bXbUsq5Tm38w_5SZOFii-Y3L5mbM1XHMBYwEmTHF2zr9I9tpAXpYY-Ec8_o05N6Pxjh6X4k0qBmHZKOclhgj29TDF6YpVM04sihs/s1600/3.jpg&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
5. Now, this wizard window allows you to select the type of your web tests and web application. &lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5VFpbnxR1uVk5IB6Hgo9R43EHJ9ygkggxMAmJlQrdujtcMWVr7UssCVSQIogTTsITjzTX8P_zYHz1kgsgr-Znj4Imr1unIe4zbwS_-m1U92FBh2wyvMaKgb0p8YUc3TiraFoApun-USbf/s1600/4.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi5VFpbnxR1uVk5IB6Hgo9R43EHJ9ygkggxMAmJlQrdujtcMWVr7UssCVSQIogTTsITjzTX8P_zYHz1kgsgr-Znj4Imr1unIe4zbwS_-m1U92FBh2wyvMaKgb0p8YUc3TiraFoApun-USbf/s1600/4.jpg&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
6. Test complete allows you to add the tested web pages to your test project if you based on below scripting approach. &lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGuHex-2I1AGCbPQXiaSkA6qtZ2oQ5CibzQmrD14QZHg1cgbM9wDX3Rj8SJXMyly_0nGfYkuvef_860z5Gb-glF6nNqUMyX5fxNnIasoLfoQ9tE2BB_wIZ_5zDSb_CYCcc5Pj7fbHoA6sH/s1600/5.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjGuHex-2I1AGCbPQXiaSkA6qtZ2oQ5CibzQmrD14QZHg1cgbM9wDX3Rj8SJXMyly_0nGfYkuvef_860z5Gb-glF6nNqUMyX5fxNnIasoLfoQ9tE2BB_wIZ_5zDSb_CYCcc5Pj7fbHoA6sH/s1600/5.jpg&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
7. Now specify scripting language in this wizard window and press Finish button.&lt;br /&gt;
&lt;br /&gt;
&lt;div style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMqtWBuGUvERGWhnnAkPEsmwi4BCdToDbBX1zt1iMIzXdwrIGIaX8UQrjt9zyqL9b28Pi2b3fpyfE5jupZY5oRChk3alLodCI6YNi5GvQ9lJjtMzv1DHPSlTScO3cGrYFuKQGBqDb_DRUH/s1600/6.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgMqtWBuGUvERGWhnnAkPEsmwi4BCdToDbBX1zt1iMIzXdwrIGIaX8UQrjt9zyqL9b28Pi2b3fpyfE5jupZY5oRChk3alLodCI6YNi5GvQ9lJjtMzv1DHPSlTScO3cGrYFuKQGBqDb_DRUH/s1600/6.jpg&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
8. Now Click “Record New Test” button in order to record test. After this point, every action you perform is being recorded by Testcomplete. E.g. application launch, Every button click, etc.&lt;br /&gt;
&lt;br /&gt;
9. After Recording, you can see all the recorded steps in Test complete workspace – keyword test panel as below “Google search” recording example. &lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimFvNZVS3KAfv54Er8_Nlpk1G-m6UuiJLtEC1PPNu3TcTKgx9IxX2YsjiC9EsHpHHgqC1T-Xb9GXRiB6jUJVh1GLYhDq4d7FDYXu_3hNacnanZShk8gMz3W3I6T3auiUIK8O4mPWVBV-s_/s1600/7.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimFvNZVS3KAfv54Er8_Nlpk1G-m6UuiJLtEC1PPNu3TcTKgx9IxX2YsjiC9EsHpHHgqC1T-Xb9GXRiB6jUJVh1GLYhDq4d7FDYXu_3hNacnanZShk8gMz3W3I6T3auiUIK8O4mPWVBV-s_/s1600/7.jpg&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
Moreover, now you can notice each action you performed the corresponding screenshot in visualize panel as below.&lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCSXviVUwhGQToRmDT04TwqHSDM6honxN-JRtoqoT-wlnSYcIaTf3h-loM4DEkFSEOJ7yBNd-iZ0HwmC8VmmBC3YdPx7GGX2GlqtbQcMSGC-p2d-7RfW4ZmGVGUsCQXhMXjwQjnINK4yVs/s1600/8.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCSXviVUwhGQToRmDT04TwqHSDM6honxN-JRtoqoT-wlnSYcIaTf3h-loM4DEkFSEOJ7yBNd-iZ0HwmC8VmmBC3YdPx7GGX2GlqtbQcMSGC-p2d-7RfW4ZmGVGUsCQXhMXjwQjnINK4yVs/s1600/8.jpg&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
10. Now, automated test has been created, and you allow running the test by clicking on&amp;nbsp;&quot;Run test&quot; Button. &lt;br /&gt;
&lt;br /&gt;
Now test complete going to drive the system and performed the same sequence of actions that you recorded.&lt;br /&gt;
&lt;br /&gt;
After execution test complete will display test results in test log as follows. This result contains detail information about every action performed during the cause of the run. &lt;br /&gt;
&lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;&quot;&gt;&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhn1t9TrKcjTT5pcOIgyzJjpL_PsmyLdl-lNNXQN4FP9Cgi6bbjepHSXq6Q0o7HnwLr7lUugTy8LWh5cql9d47g1-bZ2IBlwi0U7TRvuK90A1fDFJO35mDz8pS0s6w_VNuJYBFu1EehwFRD/s1600/9.jpg&quot; imageanchor=&quot;1&quot; style=&quot;clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;&quot;&gt;&lt;img border=&quot;0&quot; n4=&quot;true&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhn1t9TrKcjTT5pcOIgyzJjpL_PsmyLdl-lNNXQN4FP9Cgi6bbjepHSXq6Q0o7HnwLr7lUugTy8LWh5cql9d47g1-bZ2IBlwi0U7TRvuK90A1fDFJO35mDz8pS0s6w_VNuJYBFu1EehwFRD/s1600/9.jpg&quot; /&gt;&lt;/a&gt;&lt;/div&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&amp;nbsp; &lt;br /&gt;
&amp;nbsp; &lt;br /&gt;
&amp;nbsp; &lt;br /&gt;
&amp;nbsp; &lt;br /&gt;
To learn quick recording method view below video, &lt;br /&gt;
&amp;nbsp; &lt;br /&gt;
&amp;nbsp; &lt;br /&gt;
&lt;div class=&quot;separator&quot; style=&quot;border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: center;&quot;&gt;&lt;iframe allowfullscreen=&#39;allowfullscreen&#39; webkitallowfullscreen=&#39;webkitallowfullscreen&#39; mozallowfullscreen=&#39;mozallowfullscreen&#39; width=&#39;320&#39; height=&#39;266&#39; src=&#39;https://www.youtube.com/embed/JzAvIrk6uVI?feature=player_embedded&#39; frameborder=&#39;0&#39;&gt;&lt;/iframe&gt;&lt;/div&gt;</content><link rel='replies' type='application/atom+xml' href='http://darshikaj.blogspot.com/feeds/6518858962445997072/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://darshikaj.blogspot.com/2011/01/how-to-create-your-first-test-with.html#comment-form' title='2 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/6518858962445997072'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/6518858962445997072'/><link rel='alternate' type='text/html' href='http://darshikaj.blogspot.com/2011/01/how-to-create-your-first-test-with.html' title='How to create your first Test with TestComplete 8'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiERhFAcN3FQXHnmh6SJbZIMYhaEKwzeGeoo5TRZh53PNB04JvIGDx8LZmFZrScM1Dr84IG0Y6d6M3eKY5doiZ5GG427RSncpgEhGb487QqFgRYB3oGBiNXV2f58TnwBdDQYEQmm2hst0Ay/s72-c/1.jpg" height="72" width="72"/><thr:total>2</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5486583048777389584.post-7799940648502218528</id><published>2011-01-03T16:31:00.001+05:30</published><updated>2011-01-03T16:36:37.780+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Data Driven Testing"/><category scheme="http://www.blogger.com/atom/ns#" term="TestComplete Coding"/><title type='text'>TestComplete Data Driven Automated Testing – Write CSV file data.</title><content type='html'>The below function write array of row values to csv file by creating file object.  &lt;br /&gt;
&lt;br /&gt;
Sample:&lt;br /&gt;
&lt;br /&gt;
Sub Utill_WriteCSV(FILENAMEW,WriteFileArray)&lt;br /&gt;
&lt;br /&gt;
Dim objStream &lt;br /&gt;
Dim objFSO&lt;br /&gt;
Dim innerIndexW       &lt;br /&gt;
&lt;br /&gt;
Set objFSO = CreateObject(&quot;Scripting.FileSystemObject&quot;) &lt;br /&gt;
&lt;br /&gt;
If not objFSO.FileExists(FILENAMEW) Then &lt;br /&gt;
&lt;br /&gt;
Call Log.Error(&quot;The File Path &quot; &amp; FILENAMEW &amp; &quot; cannot be found.&quot;, HIGHEST_PRIORITY) &lt;br /&gt;
&lt;br /&gt;
Else&lt;br /&gt;
Set objStream = objFSO.OpenTextFile (FILENAMEW,8, True)&lt;br /&gt;
Call Log.Message(&quot;The File Path &quot; &amp; FILENAMEW &amp; &quot; was Found.&quot;)   &lt;br /&gt;
&lt;br /&gt;
For innerIndexW = 1 to UBound(WriteFileArray)   &lt;br /&gt;
objStream.WriteLine(WriteFileArray(innerIndexW))&lt;br /&gt;
next &lt;br /&gt;
&lt;br /&gt;
End If&lt;br /&gt;
&lt;br /&gt;
objStream.Close()      &lt;br /&gt;
&lt;br /&gt;
End Sub (Note: this code based on VB scripts)&lt;br /&gt;
&lt;br /&gt;
Function Steps:&lt;br /&gt;
&lt;br /&gt;
1. Save file path as constant in main function and pass to above &lt; Utill_WriteCSV(FILENAMEW,WriteFileArray)&gt; function. &lt;br /&gt;
&lt;br /&gt;
2. Create a file object for write Functionality.&lt;br /&gt;
E.g. Set objFSO = CreateObject(&quot;Scripting.FileSystemObject&quot;)&lt;br /&gt;
&lt;br /&gt;
3. Verify file object exist for write Functionality.&lt;br /&gt;
e.g.&lt;br /&gt;
&lt;br /&gt;
If not objFSO.FileExists(FILENAMEW) Then &lt;br /&gt;
Call Log.Error(&quot;The File Path &quot; &amp; FILENAMEW &amp; &quot; cannot be found.&quot;, HIGHEST_PRIORITY) &lt;br /&gt;
&lt;br /&gt;
Else&lt;br /&gt;
&lt;br /&gt;
4. Open file object and write file values starting from second line (since first line considered as “Field title” row).&lt;br /&gt;
&lt;br /&gt;
e.g. objStream.WriteLine(WriteFileArray(innerIndexW))</content><link rel='replies' type='application/atom+xml' href='http://darshikaj.blogspot.com/feeds/7799940648502218528/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://darshikaj.blogspot.com/2011/01/testcomplete-data-driven-automated.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/7799940648502218528'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/7799940648502218528'/><link rel='alternate' type='text/html' href='http://darshikaj.blogspot.com/2011/01/testcomplete-data-driven-automated.html' title='TestComplete Data Driven Automated Testing – Write CSV file data.'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5486583048777389584.post-1714946050124987242</id><published>2010-12-27T15:26:00.003+05:30</published><updated>2011-01-03T16:35:39.874+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Data Driven Testing"/><category scheme="http://www.blogger.com/atom/ns#" term="TestComplete Coding"/><title type='text'>TestComplete Data Driven Automated Testing – Read CSV file data.</title><content type='html'>&lt;span style=&quot;font-family: &amp;quot;Calibri&amp;quot;, &amp;quot;sans-serif&amp;quot;; mso-ansi-language: EN-US; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: &amp;quot;Times New Roman&amp;quot;; mso-bidi-language: AR-SA; mso-bidi-theme-font: minor-bidi; mso-fareast-font-family: &amp;quot;Times New Roman&amp;quot;; mso-fareast-language: EN-US; mso-fareast-theme-font: minor-fareast; mso-hansi-theme-font: minor-latin;&quot;&gt;&lt;/span&gt;&lt;br /&gt;
&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;The below function reads data from any csv file and pass array of row values to another splitting function for decomposition. &lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;Sample:&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;Function Util_Readcsv(StrFilename)&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;Dim innerIndex &lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;Dim objFSO&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;Dim objTextFile &lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;Dim strnextLine &lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;Dim fileArray()&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;Set objFSO = CreateObject(&quot;Scripting.FileSystemObject&quot;) &lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;If not objFSO.FileExists(StrFilename) Then &lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;Call Log&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;.Error(&quot;The File Path &quot; &amp;amp; StrFilename &amp;amp; &quot; cannot be found.&quot;)&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;Else &lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;Set objTextFile= objFSO.OpenTextFile(StrFilename, 1)&lt;/span&gt;&lt;i&gt;&lt;span style=&quot;background: white; color: green; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt; &lt;/span&gt;&lt;/i&gt;&lt;i&gt;&lt;span style=&quot;color: green; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/i&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;innerIndex = 0&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;Call Log&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;.Message(&quot;The File Path &quot; &amp;amp; StrFilename &amp;amp; &quot; was Found.&quot;)&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;Do Until objTextFile.AtEndOfStream&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;Redim Preserve fileArray(innerIndex)&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;strnextLine = objTextFile.Readline&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;i&gt;&lt;span style=&quot;background: white; color: green; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;/span&gt;&lt;/i&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;fileArray(innerIndex)=strnextLine&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;innerIndex = innerIndex + 1&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none; text-indent: 0.5in;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;Loop&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;Util_Readcsv = fileArray&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;i&gt;&lt;span style=&quot;color: green; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/i&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;End If&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;margin: 0in 0in 10pt;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;End Function&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;margin: 0in 0in 10pt;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;(Note: this code based on VB scripts)&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;margin: 0in 0in 10pt;&quot;&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;; line-height: 115%;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;Function Steps:&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none; mso-list: l0 level1 lfo1; text-indent: -0.25in;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-list: Ignore;&quot;&gt;1.&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;Save file path as constant in main function and pass to above &amp;lt; Util_Readcsv(StrFilename)&amp;gt; function. &lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none; mso-list: l0 level1 lfo1; text-indent: -0.25in;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-list: Ignore;&quot;&gt;2.&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;Create a file object for Read Functionality.&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;E.g. &lt;span style=&quot;background: white; mso-highlight: white;&quot;&gt;Set&lt;/span&gt; objFSO = CreateObject(&quot;Scripting.FileSystemObject&quot;)&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none; mso-list: l0 level1 lfo1; text-indent: -0.25in;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-list: Ignore;&quot;&gt;3.&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;Verify file object exist for Read Functionality.&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;e.g.&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none; text-indent: 0.5in;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;If not objFSO.FileExists(StrFilename) Then &lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;Call Log&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;.Error(&quot;The File Path &quot; &amp;amp; StrFilename &amp;amp; &quot; cannot be found.&quot;)&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;Else &lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none; mso-list: l0 level1 lfo1; text-indent: -0.25in;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-list: Ignore;&quot;&gt;4.&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;Open file object and read file values starting from second line (since first line considered as “Field title” row) and split in to rows and assign to array.&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none; mso-list: l0 level1 lfo1; text-indent: -0.25in;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-list: Ignore;&quot;&gt;5.&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;Now, pass all splitted row values to decomposition.&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;margin: 0in 0in 0pt 0.5in;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;E.g. Util_Readcsv = fileArray&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpMiddle&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none; mso-list: l0 level1 lfo1; text-indent: -0.25in;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-list: Ignore;&quot;&gt;6.&lt;span style=&quot;font-family: &amp;quot;Times New Roman&amp;quot;; font-style: normal; font-variant: normal; font-weight: normal; line-height: normal;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;All row values can be decomposed to field values by using following code sample.&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none; text-indent: 0.5in;&quot;&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;Sample:&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none; text-indent: 0.5in;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;span style=&quot;mso-tab-count: 1;&quot;&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;i&gt;&lt;span style=&quot;background: white; color: green; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&#39;Call Util_Readcsv function for read values from CSV file &lt;/span&gt;&lt;/i&gt;&lt;i&gt;&lt;span style=&quot;color: green; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/i&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;span style=&quot;mso-tab-count: 1;&quot;&gt;&amp;nbsp; &lt;/span&gt;FileArray = Util_Readcsv(FILENAME)&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;span style=&quot;mso-tab-count: 1;&quot;&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;i&gt;&lt;span style=&quot;background: white; color: green; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&#39;Read Array Raw Values &lt;/span&gt;&lt;/i&gt;&lt;i&gt;&lt;span style=&quot;color: green; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/i&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;br /&gt;
&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;span style=&quot;mso-tab-count: 1;&quot;&gt;&amp;nbsp; &lt;/span&gt;For outerIndex = 1 to UBound(FileArray)&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;Call Util_LogFolderstack(outerIndex) &lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;strnextLine = FileArray(outerIndex)&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;splitString = Split(strnextLine, &quot;,&quot;)&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;i&gt;&lt;span style=&quot;background: white; color: green; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&#39;new line as the delimiter, &lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&lt;/span&gt;Split returns an array&lt;/span&gt;&lt;/i&gt;&lt;i&gt;&lt;span style=&quot;color: green; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/i&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;i&gt;&lt;span style=&quot;background: white; color: green; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&#39;Assigning field values each row in CSV file to array&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;/span&gt;&lt;/i&gt;&lt;i&gt;&lt;span style=&quot;color: green; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/i&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;for innerIndex = 0&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;to UBound(splitString) &lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;Redim Preserve arrArray(innerIndex)&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;strText&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp; &lt;/span&gt;= splitString(innerIndex)&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoNormal&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;background: white; color: black; font-family: &amp;quot;Courier New&amp;quot;; mso-highlight: white;&quot;&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;arrArray(innerIndex) = strText&lt;/span&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpFirst&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;next&lt;/strong&gt;&lt;/span&gt;&lt;/div&gt;&lt;div class=&quot;MsoListParagraphCxSpLast&quot; style=&quot;line-height: normal; margin: 0in 0in 0pt 0.5in; mso-add-space: auto; mso-layout-grid-align: none;&quot;&gt;&lt;span style=&quot;color: black; font-family: &amp;quot;Courier New&amp;quot;;&quot;&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&amp;nbsp;&amp;nbsp; &lt;/span&gt;&lt;span style=&quot;mso-spacerun: yes;&quot;&gt;&amp;nbsp;&amp;nbsp;&lt;/span&gt;&lt;/strong&gt;&lt;/span&gt;&lt;/span&gt;&lt;/div&gt;&lt;span style=&quot;font-family: Arial, Helvetica, sans-serif;&quot;&gt;&lt;strong&gt;&lt;/strong&gt;&lt;/span&gt;</content><link rel='replies' type='application/atom+xml' href='http://darshikaj.blogspot.com/feeds/1714946050124987242/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://darshikaj.blogspot.com/2010/12/testcomplete-data-driven-automated.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/1714946050124987242'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/1714946050124987242'/><link rel='alternate' type='text/html' href='http://darshikaj.blogspot.com/2010/12/testcomplete-data-driven-automated.html' title='TestComplete Data Driven Automated Testing – Read CSV file data.'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5486583048777389584.post-4049610546865831968</id><published>2010-12-22T16:46:00.001+05:30</published><updated>2011-01-03T16:37:25.659+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Test Automation Basics"/><title type='text'>Decide What Test Cases to Automate</title><content type='html'>It is impossible to automate all test scenarios or test cases in given application testing scope, so it is important to determine what test cases should be automated in order to reduce manual testing effort, cost and improve application quality.&lt;br /&gt;
&lt;br /&gt;
&lt;div&gt;&amp;nbsp;&lt;/div&gt;The benefit of automated testing is related to how many times a given test can be repeated. Test scenarios that are only executed a few times are better left for manual testing. Good test cases for automation are ones that are run frequently and require large amounts of data to perform the same action. &lt;br /&gt;
&lt;br /&gt;
&lt;div&gt;&amp;nbsp;&lt;/div&gt;We can get the most benefit out of our automated testing efforts by automating:&lt;br /&gt;
&lt;br /&gt;
&lt;div&gt;&amp;nbsp;&lt;/div&gt;&lt;ul&gt;&lt;li&gt;Repetitive tests that run for multiple builds. &lt;/li&gt;
&lt;li&gt;Tests that require multiple data sets. E.g. All Data Driven Test scenarios &lt;/li&gt;
&lt;li&gt;Tests that run on several different hardware or software platforms and configurations. E.g. Browser compatibility&lt;/li&gt;
&lt;li&gt;Frequently used functionality that introduces high risk conditions.&lt;/li&gt;
&lt;li&gt;Tests that is impossible to perform manually.&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Tests that tend to cause human error.&amp;nbsp;&lt;/li&gt;
&lt;li&gt;Tests that take a lot of effort and time when manual testing. &lt;/li&gt;
&lt;/ul&gt;Success in test automation requires careful planning and design robust framework for given test scope. Therefore, automation team needs to create an automation plan for given project by analyzing application scope and determining all functional test areas that need to be automated with project qa team members.&lt;br /&gt;
&lt;br /&gt;
First, we should define our project testing goal for automated testing and determine which types of tests to automate. Currently we are employing nuemorous types of testing in navantis test practice , and each has its place in the our organization process. &lt;br /&gt;
&lt;br /&gt;
For instance, &lt;br /&gt;
&lt;br /&gt;
 Unit Testing : Is use to test a small part of the intended application. &lt;br /&gt;
 Load Testing : Is performe when we need to know how a web service responds under a heavy workload. &lt;br /&gt;
 GUI Testing: Is use to test a certain piece of the application’s UI&lt;br /&gt;
&lt;br /&gt;
Hope the above points will help you make a decision whether to use test automation on future Navantis projects. Whether you are beginning to think of exploring test automation or already have an automation suite in place and are considering expansion, it always helps to continue to evaluate how our test automation will help accomplish our testing goals. By choosing carefully those things that we will automate, and building with maintainability in mind, definitly we will obtain the most out of our test automation effort in our future projects.</content><link rel='replies' type='application/atom+xml' href='http://darshikaj.blogspot.com/feeds/4049610546865831968/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://darshikaj.blogspot.com/2010/12/decide-what-test-cases-to-automate.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/4049610546865831968'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/4049610546865831968'/><link rel='alternate' type='text/html' href='http://darshikaj.blogspot.com/2010/12/decide-what-test-cases-to-automate.html' title='Decide What Test Cases to Automate'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5486583048777389584.post-8007490845374479344</id><published>2009-06-29T14:45:00.004+05:30</published><updated>2011-01-03T16:39:33.056+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Testcomplete integration with Technologies"/><title type='text'>Configure TestComplete project to access the InfoPath form’s</title><content type='html'>The following sections will explain how to configure TestComplete automation project and access the InfoPath form’s fields in TestComplete scripts.&lt;br /&gt;
Configuring TestComplete Project&lt;br /&gt;
Before scripting &amp; testing our InfoPath forms we have to configure the TestComplete project -&lt;br /&gt;
• Launch TestComplete and create a new test project suite and project.  &lt;br /&gt;
• Right-click the TestComplete project node in the TestComplete Project Explorer panel and select Edit - Properties from the context menu. This will open the TestComplete project editor in the Workspace panel and display the Properties page. &lt;br /&gt;
• Select the “Open Applications – MSAA” group on the left of the page. Then TestComplete will display a list of MSAA properties on the right. Note, this list contains windows class names and their properties that will be exposed by the use of TestComplete’s MSAA engine. &lt;br /&gt;
• Choose the check box related to the asterisk (*) class name:&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6L1_4HYeOztbDGrW0YObU0f0fEFyLeuZgLhliZjacr8g50Psmmva0H2qY_WmwWNXT3dtVKS3qcp7Vi-iVWtmZpO_RU5bJR_0OP9dL5FbZdSrtHiYUCPwmpJBtNSeM0OSbCa_L5lBfTvFG/s1600-h/Infor_blo.JPG&quot;&gt;&lt;img style=&quot;display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 175px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEi6L1_4HYeOztbDGrW0YObU0f0fEFyLeuZgLhliZjacr8g50Psmmva0H2qY_WmwWNXT3dtVKS3qcp7Vi-iVWtmZpO_RU5bJR_0OP9dL5FbZdSrtHiYUCPwmpJBtNSeM0OSbCa_L5lBfTvFG/s320/Infor_blo.JPG&quot; border=&quot;0&quot; alt=&quot;&quot;id=&quot;BLOGGER_PHOTO_ID_5352677387943043650&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
This allows TestComplete to use the MSAA engine to expose methods and properties of any existing window.&lt;br /&gt;
Subsequent to configure the MSAA engine so that it exposes any window, the form is displayed in the objects tree as the object named “pane”. You can script required InfoPath test scenario by exploring the needed form controls and its properties.</content><link rel='replies' type='application/atom+xml' href='http://darshikaj.blogspot.com/feeds/8007490845374479344/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://darshikaj.blogspot.com/2009/06/configure-testcomplete-project-to.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/8007490845374479344'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/8007490845374479344'/><link rel='alternate' type='text/html' href='http://darshikaj.blogspot.com/2009/06/configure-testcomplete-project-to.html' title='Configure TestComplete project to access the InfoPath form’s'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5486583048777389584.post-3871666389346867989</id><published>2009-06-02T15:03:00.006+05:30</published><updated>2011-01-03T16:40:45.962+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="TestComplete Test Execution"/><title type='text'>Scheduling TestComplete Runs</title><content type='html'>&lt;em&gt;&lt;strong&gt;To Scheduling TestComplete runs&lt;/strong&gt;&lt;/em&gt;, we can run TestComplete using any scheduling program and pass the appropriate command-line arguments to it. E.g. we can run TestComplete using the Windows Task Scheduler.&lt;br /&gt;
&lt;br /&gt;
Steps:&lt;br /&gt;
&lt;br /&gt;
• Select Scheduling Tasks in the Control Panel.&lt;br /&gt;
• Select  “Add Scheduled Task”. &lt;br /&gt;
• Select “TestComplete” as the application to be run.&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghTmE5DJMWEdxfcuiZ0pl1R1YI0d56BjVFcB5OX-jEaDdxGA2pFl3cNnSpyU-CPAdwpPbboT6W3Yf0bj1HyTfC_3N0n9vFWQuq73L39MkhEDlbu5p2Dn6j9iIEy7hRfGAQQJMTjF5heBws/s1600-h/Wizard1.JPG&quot;&gt;&lt;img style=&quot;display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 230px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghTmE5DJMWEdxfcuiZ0pl1R1YI0d56BjVFcB5OX-jEaDdxGA2pFl3cNnSpyU-CPAdwpPbboT6W3Yf0bj1HyTfC_3N0n9vFWQuq73L39MkhEDlbu5p2Dn6j9iIEy7hRfGAQQJMTjF5heBws/s320/Wizard1.JPG&quot; border=&quot;0&quot; alt=&quot;&quot;id=&quot;BLOGGER_PHOTO_ID_5342661455497798306&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
• On the last page of the Wizard, select the Open advanced properties for task check box and press Finish. &lt;br /&gt;
• In appeared dialog, open the Tasks tabbed page and specify the following command-line arguments in the Run edit box.&lt;br /&gt;
&lt;br /&gt;
TestComplete_Installation_Path\Bin\TestComplete.exe full_path_to_project_file  /r /e&lt;br /&gt;
&lt;br /&gt;
or &lt;br /&gt;
&lt;br /&gt;
TestComplete_Installation_Path\Bin\TestComplete.exe full_path_to_project_suite_file  /r /e&lt;br /&gt;
&lt;br /&gt;
E.g.:&lt;br /&gt;
&lt;br /&gt;
&quot;C:\ProgramFiles\AutomatedQA\TestComplete5Bin\TestComplete.exe&quot; &quot;C:\Work\TestComplete Projects\Darshika_Project\MyProject.pjs&quot; /r /e</content><link rel='replies' type='application/atom+xml' href='http://darshikaj.blogspot.com/feeds/3871666389346867989/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://darshikaj.blogspot.com/2009/06/scheduling-testcomplete-runs.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/3871666389346867989'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/3871666389346867989'/><link rel='alternate' type='text/html' href='http://darshikaj.blogspot.com/2009/06/scheduling-testcomplete-runs.html' title='Scheduling TestComplete Runs'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghTmE5DJMWEdxfcuiZ0pl1R1YI0d56BjVFcB5OX-jEaDdxGA2pFl3cNnSpyU-CPAdwpPbboT6W3Yf0bj1HyTfC_3N0n9vFWQuq73L39MkhEDlbu5p2Dn6j9iIEy7hRfGAQQJMTjF5heBws/s72-c/Wizard1.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5486583048777389584.post-1647283387674791577</id><published>2009-05-26T16:41:00.004+05:30</published><updated>2011-01-03T16:41:19.633+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Testcomplete integration with Technologies"/><category scheme="http://www.blogger.com/atom/ns#" term="TestComplete Test Execution"/><title type='text'>Integration of Test Complete with visual studio &quot;Team Foundation Server&quot;</title><content type='html'>The following illustration shows the process through which Testcomplete test results are generated, published, and eventually moved into the operational data stores and data warehouse of Team Foundation Server.&lt;br /&gt;
&lt;br /&gt;
Following are the prerequisites to publish TC test results,&lt;br /&gt;
&lt;br /&gt;
1. Get permission to TFS Server for Publishing results (In my experiment, I granted permission as Root Admin). &lt;br /&gt;
2. Get full access permissions for accessing Build Server and relevant project folder to access relevant builds. E.g. \\testtfs08\&lt;proj_name&gt;\&lt;br /&gt;
3. Get TestComplete installed on TFS server.&lt;br /&gt;
&lt;br /&gt;
Steps:&lt;br /&gt;
&lt;br /&gt;
&lt;em&gt;&lt;strong&gt;A. Extending Visual Studio Tests with TestComplete Test Projects&lt;/strong&gt;&lt;/em&gt;&lt;br /&gt;
&lt;br /&gt;
Please See the below article &lt;br /&gt;
http://darshikaj.blogspot.com/2009/05/intergrate-testcomplete-test-with.html&lt;br /&gt;
&lt;br /&gt;
&lt;em&gt;&lt;strong&gt;B. Publish TestComplete Test Results to TFS Server&lt;/strong&gt;&lt;/em&gt;&lt;br /&gt;
&lt;br /&gt;
1. The first thing we will require to do is create a new build agent on the server. To do this you should right click on the ‘Builds’ node for your team project, then click ‘Manage Build Agents’. Once dialog comes up, click the ‘Add’ button which will bring us to the dialog below.&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjMBhjx3PM3Ncer94M3t1F7lZpnn_mCyEk5arH0LPJxg1oATSxkUZir32nqGaVLs9dp01dXjHVxbqpqeKcz_hh482qaz3KRe_KqUWKsO4NDJQMRT6qsoHU4gvp-q1kxm7ms3W5nbEB4ZSl/s1600-h/TFS_BuildAgent.JPG&quot;&gt;&lt;img style=&quot;display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 302px; height: 279px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjMBhjx3PM3Ncer94M3t1F7lZpnn_mCyEk5arH0LPJxg1oATSxkUZir32nqGaVLs9dp01dXjHVxbqpqeKcz_hh482qaz3KRe_KqUWKsO4NDJQMRT6qsoHU4gvp-q1kxm7ms3W5nbEB4ZSl/s320/TFS_BuildAgent.JPG&quot; border=&quot;0&quot; alt=&quot;&quot;id=&quot;BLOGGER_PHOTO_ID_5340090095082539042&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
2. Share and grant full access permission to the project build repository defined below. (Minimum of Build Services group membership is required).</content><link rel='replies' type='application/atom+xml' href='http://darshikaj.blogspot.com/feeds/1647283387674791577/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://darshikaj.blogspot.com/2009/05/integration-of-test-complete-with.html#comment-form' title='1 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/1647283387674791577'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/1647283387674791577'/><link rel='alternate' type='text/html' href='http://darshikaj.blogspot.com/2009/05/integration-of-test-complete-with.html' title='Integration of Test Complete with visual studio &quot;Team Foundation Server&quot;'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjjMBhjx3PM3Ncer94M3t1F7lZpnn_mCyEk5arH0LPJxg1oATSxkUZir32nqGaVLs9dp01dXjHVxbqpqeKcz_hh482qaz3KRe_KqUWKsO4NDJQMRT6qsoHU4gvp-q1kxm7ms3W5nbEB4ZSl/s72-c/TFS_BuildAgent.JPG" height="72" width="72"/><thr:total>1</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5486583048777389584.post-2317489239862756184</id><published>2009-05-26T16:22:00.007+05:30</published><updated>2011-01-03T16:42:07.518+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Testcomplete integration with Technologies"/><category scheme="http://www.blogger.com/atom/ns#" term="TestComplete Test Execution"/><title type='text'>Intergrate TestComplete test with Microsoft Visual Studio Team system (Test Edition)</title><content type='html'>The following illustration shows the process through which Testcomplete test results are generated, published, and eventually moved into the operational data stores and data warehouse of Team Foundation Server.&lt;br /&gt;
&lt;br /&gt;
A. Extending Visual Studio Tests with TestComplete Test Projects&lt;br /&gt;
&lt;br /&gt;
1. Create a Test Script in TestComplete6.&lt;br /&gt;
&lt;br /&gt;
2. Create a Test Project in Visual Studio 2008.&lt;br /&gt;
&lt;br /&gt;
3. TestComplete includes a Visual Studio Team System integration package that adds a new test type “TestComplete6 test” to Visual Studio.&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7sb6IHGbrUs0xTOQ4zNq7M9l-ntTKaF-FOISKFrucMEQA_O9hD6gcpnOlnbz8No1QqsSWRdhdVqY4h5cG_36x9xMjzvm_hieIIKiwr38qAqUKQecs7z23qWCNlI3hhMri0VsVk7mjzsRE/s1600-h/TC_type.JPG&quot;&gt;&lt;img style=&quot;display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 271px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7sb6IHGbrUs0xTOQ4zNq7M9l-ntTKaF-FOISKFrucMEQA_O9hD6gcpnOlnbz8No1QqsSWRdhdVqY4h5cG_36x9xMjzvm_hieIIKiwr38qAqUKQecs7z23qWCNlI3hhMri0VsVk7mjzsRE/s320/TC_type.JPG&quot; border=&quot;0&quot; alt=&quot;&quot;id=&quot;BLOGGER_PHOTO_ID_5340086192611669186&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
4. Add the TestComplete Test suite to the VS Test Project.&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0GLmOn0nYCfX3-IqxLuDgMw2Tnd543gQqtfk4PL8gBThyphenhypheng2TUBMr2_bRj7N4I60CBxkI8OaY8Fues6pMua_ubB8EsDdAvzY1-BUyQX8NlbbkSYABOAFALodeswqt3U2IONK1Q37XywrQK/s1600-h/TC_AddEditor.JPG&quot;&gt;&lt;img style=&quot;display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 86px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh0GLmOn0nYCfX3-IqxLuDgMw2Tnd543gQqtfk4PL8gBThyphenhypheng2TUBMr2_bRj7N4I60CBxkI8OaY8Fues6pMua_ubB8EsDdAvzY1-BUyQX8NlbbkSYABOAFALodeswqt3U2IONK1Q37XywrQK/s320/TC_AddEditor.JPG&quot; border=&quot;0&quot; alt=&quot;&quot;id=&quot;BLOGGER_PHOTO_ID_5340086544422129282&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
In this Visual Studio editor, we can specify the TestComplete project suite with the desired tests and select the specific test items to be executed.&lt;br /&gt;
&lt;br /&gt;
5. Now switch to the Test List Editor panel in VS and select the TestComplete test for execution.&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGapgf4wiVk1fliUD6csss7T9OHAjxQec5UsjryWPsVZi3SLcba7X4kbGiZT3g9q2JhHl7rzXyyxcZ__GzGnSVJOFFbXKaFQDDeqAiQ7u18H6FP4Z3glPJBNGOgJNSEZ0_e2fxVHTB2QYC/s1600-h/TC_ListEditor_Panel.JPG&quot;&gt;&lt;img style=&quot;display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 140px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhGapgf4wiVk1fliUD6csss7T9OHAjxQec5UsjryWPsVZi3SLcba7X4kbGiZT3g9q2JhHl7rzXyyxcZ__GzGnSVJOFFbXKaFQDDeqAiQ7u18H6FP4Z3glPJBNGOgJNSEZ0_e2fxVHTB2QYC/s320/TC_ListEditor_Panel.JPG&quot; border=&quot;0&quot; alt=&quot;&quot;id=&quot;BLOGGER_PHOTO_ID_5340087064875017538&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
6. After Visual Studio finishes running the tests, we can view the results of the TestComplete test execution  directly within Visual Studio,</content><link rel='replies' type='application/atom+xml' href='http://darshikaj.blogspot.com/feeds/2317489239862756184/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://darshikaj.blogspot.com/2009/05/intergrate-testcomplete-test-with.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/2317489239862756184'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/2317489239862756184'/><link rel='alternate' type='text/html' href='http://darshikaj.blogspot.com/2009/05/intergrate-testcomplete-test-with.html' title='Intergrate TestComplete test with Microsoft Visual Studio Team system (Test Edition)'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj7sb6IHGbrUs0xTOQ4zNq7M9l-ntTKaF-FOISKFrucMEQA_O9hD6gcpnOlnbz8No1QqsSWRdhdVqY4h5cG_36x9xMjzvm_hieIIKiwr38qAqUKQecs7z23qWCNlI3hhMri0VsVk7mjzsRE/s72-c/TC_type.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5486583048777389584.post-3188792959050249219</id><published>2009-05-21T16:55:00.007+05:30</published><updated>2011-01-03T16:43:39.270+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="TestComplete Test Methodology"/><title type='text'>Testing Web Services with TestComplete</title><content type='html'>&lt;em&gt;&lt;strong&gt;Web Services &lt;/strong&gt;&lt;/em&gt;are specific applications that use XML-based standards and protocols to exchange information. Unlike web server applications, web services do not have the graphical interface because they are not intended for human interaction. Moreover, web service provides definition of the methods and interfaces available for a call. This information is published in a WSDL (Web Service Definition Language) format.&lt;br /&gt;
&lt;br /&gt;
As all we know, Testcomplete provide robust features to perform functional testing of web services. This includes the following steps:&lt;br /&gt;
&lt;br /&gt;
• Analyzing and Planning the test.&lt;br /&gt;
• Exploring methods and objects provided by the tested web service in TestComplete.&lt;br /&gt;
• Creating script code for calling object methods and verifying the returned values.&lt;br /&gt;
&lt;br /&gt;
Steps :&lt;br /&gt;
&lt;br /&gt;
a) Create or Load your project in TestComplete.&lt;br /&gt;
&lt;br /&gt;
b) Right-click the project’s node in the Project Explorer panel and select Add New Item from the context menu. This will open the Create Project Item dialog.&lt;br /&gt;
&lt;br /&gt;
c) Use this dialog to add the Web Services item to your project. The added item will be displayed in the Project Explorer. To perform TC functional testing of web services, use the Web Services project item. It lets us explore the web service’s methods and objects and call them from scripts.&lt;br /&gt;
&lt;br /&gt;
(Note : This functionality is available only if the Web Services and Web Services Editor plug-ins are installed in TestComplete.)&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEht_LGxpnrw6hY_QsJOzIrnD03K7Ge3L2vM6hsKiSGiSAJWDyGVpHsVjF1ytFnYjw7uav8_Q2LiJLHdQnzuVDi4e2yWNudxvv0GAKPf-MVSDbe-Ivkju6LRbsVQoSDFibSyhTCzs6lsAenk/s1600-h/Web+Service+Project+Item.JPG&quot;&gt;&lt;img style=&quot;display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 222px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEht_LGxpnrw6hY_QsJOzIrnD03K7Ge3L2vM6hsKiSGiSAJWDyGVpHsVjF1ytFnYjw7uav8_Q2LiJLHdQnzuVDi4e2yWNudxvv0GAKPf-MVSDbe-Ivkju6LRbsVQoSDFibSyhTCzs6lsAenk/s320/Web+Service+Project+Item.JPG&quot; border=&quot;0&quot; alt=&quot;&quot;id=&quot;BLOGGER_PHOTO_ID_5338241222807186402&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
d) Now, Right-click the Web Services node in the Project Explorer and choose Add New Item from the context menu. After adding the Web Service element to our project, we can specify its properties.&lt;br /&gt;
&lt;br /&gt;
e) This Web Service test editor displays information on methods of a Web Service and on the objects that are used by these methods as parameters. Please see the underneath Project example for comprehending web service and on the objects that are used by these methods as parameters.&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDoDQhd1hD0YYXfJieJguKBUBPl3qp8ZXvbM8FaKDBamS5rt39_sKAjtgRMBLbKp1FMXRUh_XRWBxNHmKX0yEKfbiqyGBtk2QI_kLnt-yOKJrD9d45A3VuWwYIJecwx8BBe2C3CFiTTKvz/s1600-h/Web+Service+Explorer.JPG&quot;&gt;&lt;img style=&quot;display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 198px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjDoDQhd1hD0YYXfJieJguKBUBPl3qp8ZXvbM8FaKDBamS5rt39_sKAjtgRMBLbKp1FMXRUh_XRWBxNHmKX0yEKfbiqyGBtk2QI_kLnt-yOKJrD9d45A3VuWwYIJecwx8BBe2C3CFiTTKvz/s320/Web+Service+Explorer.JPG&quot; border=&quot;0&quot; alt=&quot;&quot;id=&quot;BLOGGER_PHOTO_ID_5338240167159798930&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
To specify web service, whose data will be displayed in the editor, do the following:&lt;br /&gt;
&lt;br /&gt;
• Press Select button. This will call the Select Web Service dialog.&lt;br /&gt;
• In the dialog, specify the location of the WSDL document, select the desired web service and the version of the SOAP protocol that will be used for testing.&lt;br /&gt;
&lt;br /&gt;
&lt;a href=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLlyZHXfWILN1WLcX7FBVMnnBTeasWqsYNZAj8FF9v8GjK785RzTv2zPGPuq94qfYnWlzAOcW5Y-H4doPeaKHHkot2p17JR0-8VhuSH8Ob-IUHhzMlefsUimEoj-Nw0HDLlkjt3cQCbhWg/s1600-h/Select+Web+Service.JPG&quot;&gt;&lt;img style=&quot;display:block; margin:0px auto 10px; text-align:center;cursor:pointer; cursor:hand;width: 320px; height: 185px;&quot; src=&quot;https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgLlyZHXfWILN1WLcX7FBVMnnBTeasWqsYNZAj8FF9v8GjK785RzTv2zPGPuq94qfYnWlzAOcW5Y-H4doPeaKHHkot2p17JR0-8VhuSH8Ob-IUHhzMlefsUimEoj-Nw0HDLlkjt3cQCbhWg/s320/Select+Web+Service.JPG&quot; border=&quot;0&quot; alt=&quot;&quot;id=&quot;BLOGGER_PHOTO_ID_5338240513621662834&quot; /&gt;&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
f) The web service’s methods are displayed under the Methods node in the type and methods tree. Web service methods can use parameters of an object or array types. To call these methods from script, we need to create the appropriate object and assign values to its properties. &lt;br /&gt;
&lt;br /&gt;
g) Sub sequent to create Script suite, we can execute this Web Service verification scripts by calling object methods and verifying the returned values.</content><link rel='replies' type='application/atom+xml' href='http://darshikaj.blogspot.com/feeds/3188792959050249219/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://darshikaj.blogspot.com/2009/05/testing-web-services-with-testcomplete.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/3188792959050249219'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/3188792959050249219'/><link rel='alternate' type='text/html' href='http://darshikaj.blogspot.com/2009/05/testing-web-services-with-testcomplete.html' title='Testing Web Services with TestComplete'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><media:thumbnail xmlns:media="http://search.yahoo.com/mrss/" url="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEht_LGxpnrw6hY_QsJOzIrnD03K7Ge3L2vM6hsKiSGiSAJWDyGVpHsVjF1ytFnYjw7uav8_Q2LiJLHdQnzuVDi4e2yWNudxvv0GAKPf-MVSDbe-Ivkju6LRbsVQoSDFibSyhTCzs6lsAenk/s72-c/Web+Service+Project+Item.JPG" height="72" width="72"/><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5486583048777389584.post-6867881705709917122</id><published>2009-05-21T11:23:00.003+05:30</published><updated>2011-01-03T16:45:45.000+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Data Driven Testing"/><category scheme="http://www.blogger.com/atom/ns#" term="TestComplete Coding"/><title type='text'>Data-Driven Testing With TestComplete V6.0</title><content type='html'>&lt;em&gt;&lt;strong&gt;Data-driven testing&lt;/strong&gt;&lt;/em&gt; is a very important aspect of test automation. In short, the goal is to run a given test or set of tests multiple times with different sets of input data and expected results.&lt;br /&gt;
This means using a single test to verify many different test cases by driving the test with input and expected values from an external data source instead of using the same hard-coded values each time the test runs. This way, we can test how the application handles various inputs without having a numerous similar tests that only have different data sets.&lt;br /&gt;
By considering these aspects, Testcomplete includes special program objects that let us easily access data stored in an Excel sheet, CSV file or in a ADO database table. These objects are called drivers. They are typically needed to perform data-driven tests, however, we can also use them to retrieve data from the mentioned storages.&lt;br /&gt;
The DDT object is used to create drivers for ADO database tables, Excel sheets and files holding comma-separated data (CSV file). Its methods return special “driver” objects that have access to values stored in the mentioned data storages.&lt;br /&gt;
&lt;br /&gt;
&lt;em&gt;&lt;strong&gt;CSV Driver&lt;/strong&gt;&lt;/em&gt; – Is used to read text file such as comma delimited (default) or tab delimited (using a&lt;br /&gt;
Schema.ini file). &lt;br /&gt;
[Note]  By default the first row is the header information (or column names) for the driver.&lt;br /&gt;
&lt;em&gt;&lt;strong&gt;Excel Driver&lt;/strong&gt;&lt;/em&gt; – Is used to read an Excel spreadsheet. The first row of the sheet is the header&lt;br /&gt;
information for the driver.&lt;br /&gt;
&lt;em&gt;&lt;strong&gt;ADO Driver&lt;/strong&gt;&lt;/em&gt; – Is a generic driver for a database table or record set that can be accessed via Microsoft&#39;s ADO DB.&lt;br /&gt;
&lt;br /&gt;
In the example below creates a DDT driver for an ADO DB, runs through records of the driver’s table and retrieve &amp; write values stored in record data source to the Notepad.&lt;br /&gt;
&lt;br /&gt;
Dim MyDriver&lt;br /&gt;
&lt;br /&gt;
Sub Main&lt;br /&gt;
&lt;br /&gt;
&#39;Global Variables&lt;br /&gt;
&lt;br /&gt;
Dim SQLStatement&lt;br /&gt;
Dim ConnectionString&lt;br /&gt;
&lt;br /&gt;
&#39; Start Notepad&lt;br /&gt;
TestedApps.Notepad.Run&lt;br /&gt;
&lt;br /&gt;
&#39;Assign SQL Statement to Variable&lt;br /&gt;
SQLStatement = &quot;SELECT TL_Id, TL_Name From Personnel&quot;&lt;br /&gt;
&lt;br /&gt;
&#39;Set Connection String&lt;br /&gt;
ConnectionString = &quot;Provider=SQLOLEDB.1;Integrated Security=SSPI;&quot; &amp; _&lt;br /&gt;
&quot;Persist Security Info=False;&quot; &amp; _&lt;br /&gt;
&quot;Initial Catalog=Darshika_TestDB1;Data Source=.\SQLExpress&quot;&lt;br /&gt;
&lt;br /&gt;
&#39;Create Driver&lt;br /&gt;
Set MyDriver = DDT.ADODriver(ConnectionString,SQLStatement)&lt;br /&gt;
&lt;br /&gt;
&#39;Call Method&lt;br /&gt;
MyDriver.DriveMethod(&quot;Main.DDTest1&quot;)&lt;br /&gt;
&lt;br /&gt;
End Sub&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
Sub DDTest1&lt;br /&gt;
&lt;br /&gt;
&#39;Global Variables&lt;br /&gt;
Dim p1&lt;br /&gt;
Dim w1&lt;br /&gt;
Dim w2&lt;br /&gt;
Dim KeyStr&lt;br /&gt;
&lt;br /&gt;
&#39;Start &amp; Open Notepad&lt;br /&gt;
Set p1 = Sys.Process(&quot;Notepad&quot;)&lt;br /&gt;
Set w1 = p1.Window(&quot;Notepad&quot;, &quot;*&quot;)&lt;br /&gt;
Set w2 = w1.Window(&quot;Edit&quot;)&lt;br /&gt;
w2.VScroll.Pos = 0&lt;br /&gt;
&lt;br /&gt;
&#39; Create String with Customer Information&lt;br /&gt;
KeyStr = MyDriver.Value(&quot;TL_Id&quot;)&amp; &quot;,&quot; &amp; _&lt;br /&gt;
MyDriver.Value(&quot;TL_Name&quot;)&amp; &quot;,&quot; &amp; &quot;[Enter]&quot;&lt;br /&gt;
Call w2.Keys( KeyStr)&lt;br /&gt;
End Sub</content><link rel='replies' type='application/atom+xml' href='http://darshikaj.blogspot.com/feeds/6867881705709917122/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://darshikaj.blogspot.com/2009/05/data-driven-testing-with-testcomplete.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/6867881705709917122'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/6867881705709917122'/><link rel='alternate' type='text/html' href='http://darshikaj.blogspot.com/2009/05/data-driven-testing-with-testcomplete.html' title='Data-Driven Testing With TestComplete V6.0'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry><entry><id>tag:blogger.com,1999:blog-5486583048777389584.post-4191398705519684706</id><published>2009-05-18T10:18:00.002+05:30</published><updated>2011-01-03T16:46:24.515+05:30</updated><category scheme="http://www.blogger.com/atom/ns#" term="Test Automation Basics"/><title type='text'>Manual testing Vs Test automation</title><content type='html'>First it is very important to notice that &lt;strong&gt;Manual testing &lt;/strong&gt;is not just random clicks on the user interface of a software application. For efficient testing of the software product you should have test plan and strongly defined test cases.  Manual testing is the process of executing trough these test cases manually.&lt;br /&gt;
&lt;br /&gt;
&lt;strong&gt;Test automation&lt;/strong&gt; is a software code that is executing the same test cases or test scenarios but automatically using some kind of test automation tools or frameworks.&lt;br /&gt;
The development time of test automation can take a lot of time. Usually is a huge investment of time and resources. Some software companies prefer to use offshore outsourcing companies for doing their test automation, which cuts the costs.&lt;br /&gt;
It is common believe that once the test automation is created it is working forever. That is completely wrong. You can expect some expenses for fixing the test automation. But at the end test automation is much faster than the manual testing and is the only way you can do a fast regression testing.  Test automation is recommended especially for very big software products.&lt;br /&gt;
My personal advice on whether you should use manual testing or test automation for your project is: Always have a small set of the most important tests automated, so when a bug fix is introduced at late stage of the project you will be able to run very quickly the most important test and after the bug fix is applied you will be able to do a full test pass.</content><link rel='replies' type='application/atom+xml' href='http://darshikaj.blogspot.com/feeds/4191398705519684706/comments/default' title='Post Comments'/><link rel='replies' type='text/html' href='http://darshikaj.blogspot.com/2009/05/manual-testing-vs-test-automation.html#comment-form' title='0 Comments'/><link rel='edit' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/4191398705519684706'/><link rel='self' type='application/atom+xml' href='http://www.blogger.com/feeds/5486583048777389584/posts/default/4191398705519684706'/><link rel='alternate' type='text/html' href='http://darshikaj.blogspot.com/2009/05/manual-testing-vs-test-automation.html' title='Manual testing Vs Test automation'/><author><name>Unknown</name><email>noreply@blogger.com</email><gd:image rel='http://schemas.google.com/g/2005#thumbnail' width='16' height='16' src='https://img1.blogblog.com/img/b16-rounded.gif'/></author><thr:total>0</thr:total></entry></feed>