Difference between WMI & FSO

-
WMI is better the FSO but FSO is easy to use as most of thee functionality that FSO has is also available with WMI. However WMI has some disadv and adv over FSO as follows:
Adv.:
1.    WMI can work over Remote computers while if we have to use FSO over multiple computers then we have to use WSH controller to allow scripting execution on remote computers.
 
2.    WMI can work over collection of folders and files like WMI can delete all the .mp3 files present in a system while FSO is designed to work only on single folder . to work with fso we need to bind each folder and check the existence of the file.
 
Disadv:
1.                  WMI is slower then fso. ( for specific designed and comples queries WMI is faster )
2.                  WMI is difficult to stop as WMI and queries run of different threads. ( benefit in case we want to delete files say if we have to delete 1000 files and first file is read only. Then fso will stop on first file while WMI will delete rest of the files) 

Comments

Post a Comment

Popular posts from this blog

Test Batch Runner - Run QTP Scripts from xls file

-
Image
To run QTP Scripts from a xls file we need to use QTP AOM. First we have to write following code in a vbs file and save it anywhere on your system. Option Explicit Dim qtp  Set qtp =CreateObject("QuickTest.Application") qtp.Launch qtp.Visible=True Dim xl,bk,s Set xl=createobject("Excel.application") Set bk=xl.Workbooks.Open("D:\QTPScripts\Test Batch Runner\TestBatchRunner.xls") Set s=xl.ActiveWorkbook.Worksheets("Sheet1") Dim RowNo RowNo=2 While trim(lcase(s.cells(RowNo,1)))<>"end" qtp.Open s.cells RowNo,1 Dim qtpTest 'Assign the data table path  qtp.Test.Settings.Resources.DataTablePath = s.cells(RowNo,2) ' Results Dim qtpResults                         Set qtpResults = CreateObject("QuickTest.RunResultsOptions")  'run the test qtp.Test.Run  qtpResults,True RowNo=RowNo+1 Wend 'Release Objects Set qtp=n...
Read more

Selenium: db and excel data into maps

-
package learning; import java.io.File; import java.io.FileInputStream; import java.io.IOException; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.SQLException; import java.sql.Statement; import java.util.ArrayList; import java.util.HashMap; import java.util.Iterator; import java.util.List; import java.util.Map; import java.util.Map.Entry; import java.util.Set; import java.util.TreeMap; import org.apache.poi.ss.usermodel.Row; import org.apache.poi.ss.usermodel.Sheet; import org.apache.poi.ss.usermodel.Workbook; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import com.codoid.products.exception.FilloException; import com.codoid.products.fillo.Connection; import com.codoid.products.fillo.Fillo; import com.codoid.products.fillo.Recordset; public class uploadFileinMap { @SuppressWarnings("resource") public static void main(String[] args) throws IOException, FilloException, ClassNotF...
Read more

Python: get entire workbook data cell by cell

-
import openpyxl book=openpyxl.load_workbook("D:\\Automation\\QEDGE\\WorkingProject\\PythonLearning\\Resources\\excel.xlsx") sName=book.sheetnames for s in sName:     sheet=book[s]     #sheet=book.get_sheet_by_name("Sheet1") #     cells=sheet['A1':'B5']     for row in sheet.__iter__(): #         print(row)         for cell in row:             print(cell.value) book.close()
Read more