<WorkOrder xmlns="http://Icod.Wod" xsi:schemaLocation="http://Icod.Wod \\jgsm-sql01\Icod.Wod\schema0.xsd"
    xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    jobName="wget Faculty and Staff process"
    emailTo="foo@example.com"
>
    <steps>
        <dbOperation xsi:type="fileImport" connectionStringName="SalesForce" updateBatchSize="200" tableName="FacultyStaffStaging" namespace="WorkDay" commandTimeout="360" >
            <columnMapping>
                <map from="%wod:FileNameWithoutExtension%" to="FileNameWithoutExtension" />
                <map from="fname" to="FirstName" />
                <map from="mname" to="Middle_Name__c" />
                <map from="lname" to="LastName" />
                <map from="title_work" to="Title" />
                <map from="suffix" to="suffix__c" />
            </columnMapping>
            <source xsi:type="jsonFile"
                typeName="Johnson.FacStaffList.Person[]" mapWith="Johnson.FacStaffList.PersonToRecord"
                path="\\jgsm-sql01\FacStaffList" name="*_*.json"
                regexPattern="((dyson)|(hotel)|(jcb)|(johnson)|(sha))_((staff)|(faculty))\.json$"
            >
                <assemblies>
                    <assembly path="\\jgsm-sql01\FacStaffList" name="gm_FacStaffList.dll" />
                </assemblies>
            </source>
        </dbOperation>
    </steps>
</WorkOrder>