var Component=(()=>{var h=Object.create;var t=Object.defineProperty;var p=Object.getOwnPropertyDescriptor;var S=Object.getOwnPropertyNames;var u=Object.getPrototypeOf,f=Object.prototype.hasOwnProperty;var m=(a,n)=>()=>(n||a((n={exports:{}}).exports,n),n.exports),D=(a,n)=>{for(var i in n)t(a,i,{get:n[i],enumerable:!0})},s=(a,n,i,r)=>{if(n&&typeof n=="object"||typeof n=="function")for(let l of S(n))!f.call(a,l)&&l!==i&&t(a,l,{get:()=>n[l],enumerable:!(r=p(n,l))||r.enumerable});return a};var b=(a,n,i)=>(i=a!=null?h(u(a)):{},s(n||!a||!a.__esModule?t(i,"default",{value:a,enumerable:!0}):i,a)),g=a=>s(t({},"__esModule",{value:!0}),a);var d=m((C,c)=>{c.exports=_jsx_runtime});var F={};D(F,{default:()=>v,frontmatter:()=>_});var e=b(d()),_={title:"WSF | Executing Processing by Combining and Loading Multiple VBS Scripts (Batch, WSF, VBS Integration)",description:"I will explain how to use it as a package to call multiple VBS files together using WSF.",date:new Date(15831936e5),emoji:"\u{1F5A5}\uFE0F",tags:["wsf","vbs"],published:!0};function o(a){let n=Object.assign({p:"p",a:"a",strong:"strong",h2:"h2",span:"span",img:"img",code:"code",figure:"figure",pre:"pre",h3:"h3"},a.components);return(0,e.jsxs)(e.Fragment,{children:[(0,e.jsx)(n.p,{children:"WSF is an XML file that allows you to consolidate multiple scripts. This enables the reusability of VBS scripts created for various functions, making it extremely convenient. (Additionally, it allows coexistence of JScript and VBS.)"}),(0,e.jsx)(n.p,{children:"This time, I will explain how to use it as a package to call multiple VBS files together."}),(0,e.jsx)(n.p,{children:(0,e.jsx)(n.a,{href:"https://github.com/atman-33/template-vbs/tree/master/ExportCsvOracleWsf",children:(0,e.jsx)(n.strong,{children:"Source Code is here"})})}),(0,e.jsxs)(n.h2,{id:"package-structure",children:[(0,e.jsx)(n.a,{href:"#package-structure","aria-label":"Link to section",className:"subheading-anchor",children:(0,e.jsx)(n.span,{className:"icon icon-link"})}),"Package Structure"]}),(0,e.jsxs)(n.p,{children:["Similar to the functionality previously covered in the article ",(0,e.jsx)(n.a,{href:"/blog/5-oracle-db-to-csv-vbs",children:(0,e.jsx)(n.strong,{children:"\u3010VBS\u3011Saving SELECT Results from Oracle DB to CSV"})})," but using a combination of batch, WSF, and VBS, we will achieve the same functionality."]}),(0,e.jsx)(n.p,{children:"First, let's look at the package structure."}),(0,e.jsx)(n.p,{children:(0,e.jsx)(n.img,{alt:"image",src:"/blog/8/package.png"})}),(0,e.jsxs)(n.p,{children:["\u25BC ",(0,e.jsx)(n.code,{__isInlineCode__:"true",children:"wsf_oracledb_to_csv"})," Folder"]}),(0,e.jsx)(n.figure,{"data-rehype-pretty-code-figure":"",children:(0,e.jsx)(n.pre,{__rawString__:`Main.bat Main execution file OraclToCsv.wsf File for loading various VBS Config.ini File containing various configuration information sql SQL statements to extract data from the DB csv Folder to store CSV files extracted from the DB vbs Folder to store VBS classes and modules \u2514 common Folder for common classes and modules \u251C DatabaseOracle.vbs Oracle DB operation-related class \u251C fso.vbs Functions to manipulate files and folders \u2514 ini.vbs Functions to manipulate ini files `,"data-language":"text","data-theme":"github-dark-dimmed",style:{backgroundColor:"#22272e",color:"#adbac7"},tabIndex:"0",children:(0,e.jsxs)(n.code,{"data-language":"text","data-theme":"github-dark-dimmed",style:{display:"grid"},children:[(0,e.jsx)(n.span,{"data-line":"",children:(0,e.jsx)(n.span,{children:"Main.bat Main execution file"})}),` `,(0,e.jsx)(n.span,{"data-line":"",children:(0,e.jsx)(n.span,{children:"OraclToCsv.wsf File for loading various VBS"})}),` `,(0,e.jsx)(n.span,{"data-line":"",children:(0,e.jsx)(n.span,{children:"Config.ini File containing various configuration information"})}),` `,(0,e.jsx)(n.span,{"data-line":"",children:(0,e.jsx)(n.span,{children:"sql SQL statements to extract data from the DB"})}),` `,(0,e.jsx)(n.span,{"data-line":"",children:(0,e.jsx)(n.span,{children:"csv Folder to store CSV files extracted from the DB"})}),` `,(0,e.jsx)(n.span,{"data-line":"",children:(0,e.jsx)(n.span,{children:"vbs Folder to store VBS classes and modules"})}),` `,(0,e.jsx)(n.span,{"data-line":"",children:(0,e.jsx)(n.span,{children:"\u2514 common Folder for common classes and modules"})}),` `,(0,e.jsx)(n.span,{"data-line":"",children:(0,e.jsx)(n.span,{children:" \u251C DatabaseOracle.vbs Oracle DB operation-related class"})}),` `,(0,e.jsx)(n.span,{"data-line":"",children:(0,e.jsx)(n.span,{children:" \u251C fso.vbs Functions to manipulate files and folders"})}),` `,(0,e.jsx)(n.span,{"data-line":"",children:(0,e.jsx)(n.span,{children:" \u2514 ini.vbs Functions to manipulate ini files"})})]})})}),(0,e.jsx)(n.p,{children:"The WSF file is where VBS scripts are loaded together, allowing you to work with individual functions and classes."}),(0,e.jsxs)(n.h2,{id:"source-code-explanation",children:[(0,e.jsx)(n.a,{href:"#source-code-explanation","aria-label":"Link to section",className:"subheading-anchor",children:(0,e.jsx)(n.span,{className:"icon icon-link"})}),"Source Code Explanation"]}),(0,e.jsx)(n.p,{children:"Now, let's explain the code for the WSF and BAT files (we'll skip the VBS files as they have already been explained in a separate article)."}),(0,e.jsxs)(n.h3,{id:"wsf-file",children:[(0,e.jsx)(n.a,{href:"#wsf-file","aria-label":"Link to section",className:"subheading-anchor",children:(0,e.jsx)(n.span,{className:"icon icon-link"})}),"WSF File"]}),(0,e.jsx)(n.p,{children:"WSF files are written in XML format."}),(0,e.jsx)(n.p,{children:"In this example, we've referenced classes and functions from various VBS files required for DB connection and CSV output."}),(0,e.jsxs)(n.p,{children:["\u25BC ",(0,e.jsx)(n.code,{__isInlineCode__:"true",children:"oracledb_to_csv.wsf"})]}),(0,e.jsx)(n.figure,{"data-rehype-pretty-code-figure":"",children:(0,e.jsx)(n.pre,{__rawString__:`