<?xml version="1.0" encoding="utf-8"?>
<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>
        <fileOperation xsi:type="mkDir" path="\\jgsm-sql01\FacStaffList" />

        <fileOperation xsi:type="deleteFile"
            path="\\jgsm-sql01\FacStaffList" name="*_*.json"
            regexPattern="((dyson)|(hotel)|(jcb)|(johnson)|(sha))_((staff)|(faculty))\.json$"
        />
        <parallel>
            <steps>
                <!-- staff -->
                <fileOperation xsi:type="copyFile" move="false"
                    path="https://someServer.example.com/app/human_resources/api/jcb_employees/mailing_list.json?type=hotel_staff"
                    username="someUsername" password="somePassword"
                >
                    <destination path="\\jgsm-sql01\FacStaffList" name="hotel_staff.json" />
                </fileOperation>
                <fileOperation xsi:type="copyFile" move="false"
                    path="https://someServer.example.com/app/human_resources/api/jcb_employees/mailing_list.json?type=sha_staff"
                    username="someUsername" password="somePassword"
                >
                    <destination path="\\jgsm-sql01\FacStaffList" name="sha_staff.json" />
                </fileOperation>
                <fileOperation xsi:type="copyFile" move="false"
                    path="https://someServer.example.com/app/human_resources/api/jcb_employees/mailing_list.json?type=johnson_staff"
                    username="someUsername" password="somePassword"
                >
                    <destination path="\\jgsm-sql01\FacStaffList" name="johnson_staff.json" />
                </fileOperation>
                <fileOperation xsi:type="copyFile" move="false"
                    path="https://someServer.example.com/app/human_resources/api/jcb_employees/mailing_list.json?type=jcb_staff"
                    username="someUsername" password="somePassword"
                >
                    <destination path="\\jgsm-sql01\FacStaffList" name="jcb_staff.json" />
                </fileOperation>
                <fileOperation xsi:type="copyFile" move="false"
                    path="https://someServer.example.com/app/human_resources/api/jcb_employees/mailing_list.json?type=dyson_staff"
                    username="someUsername" password="somePassword"
                >
                    <destination path="\\jgsm-sql01\FacStaffList" name="dyson_staff.json" />
                </fileOperation>

                <!-- faculty -->
                <fileOperation xsi:type="copyFile" move="false"
                    path="https://someServer.example.com/app/human_resources/api/jcb_employees/mailing_list.json?type=sha_faculty"
                    username="someUsername" password="somePassword"
                >
                    <destination path="\\jgsm-sql01\FacStaffList" name="sha_faculty.json" />
                </fileOperation>
                <fileOperation xsi:type="copyFile" move="false"
                    path="https://someServer.example.com/app/human_resources/api/jcb_employees/mailing_list.json?type=johnson_faculty"
                    username="someUsername" password="somePassword"
                >
                    <destination path="\\jgsm-sql01\FacStaffList" name="johnson_faculty.json" />
                </fileOperation>
                <fileOperation xsi:type="copyFile" move="false"
                    path="https://someServer.example.com/app/human_resources/api/jcb_employees/mailing_list.json?type=dyson_faculty"
                    username="someUsername" password="somePassword"
                >
                    <destination path="\\jgsm-sql01\FacStaffList" name="dyson_faculty.json" />
                </fileOperation>
            </steps>
        </parallel>

        <dbOperation xsi:type="command" connectionStringName="SalesForce" commandText="delete from WorkDay.FacultyStaffStaging" commandType="Text" commandTimeout="120" />
        <dbOperation xsi:type="fileImport" connectionStringName="SalesForce" updateBatchSize="200" tableName="FacultyStaffStaging" namespace="WorkDay" commandTimeout="360" >
            <columnMapping>
                <map from="%wod:FileNameWithoutExtension%" to="FileNameWithoutExtension" />
                <map from="netid" to="netid" />
                <map from="fname" to="fname" />
                <map from="lname" to="lname" />
                <map from="title_work" to="title_work" />
            </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>
        <!--<dbOperation xsi:type="command" connectionStringName="SalesForce" commandText="WorkDay.ImportFacStaffList" commandType="StoredProcedure" commandTimeout="180" />-->
    </steps>
</WorkOrder>