Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?xml version="1.0" encoding="utf-8"?>
- <!-- Copyright 2022, Timothy J. Bruce -->
- <WorkOrder xmlns="http://Icod.Wod" xsi:schemaLocation="http://Icod.Wod https://raw.githubusercontent.com/uniblab/Icod.Wod/master/schema0.xsd"
- xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
- jobName="Daily ExecEd Download process"
- emailTo="none@example.com"
- >
- <steps>
- <dbCommand connectionStringName="SalesForce" commandType="Text" commandText="delete from dbo.Academic_Term__c" />
- <sfRestSelect instanceName="Johnson"
- soql="select Id, Name, Academic_Planning_Year__c, Class_Review_End__c, Class_Review_Start__c, PeopleSoft_Academic_Term_External_ID__c, Peoplesoft_Term_Academic_Year__c, Semester__c, Semester_Code__c, Semester_Year__c, Term_Begin_Date__c, Term_Career__c, Term_Code__c, Term_End_Date__c, Term_Short_Name__c from Academic_Term__c"
- >
- <destination connectionStringName="SalesForce" updateBatchSize="2000"
- missingMappingAction="Error" missingSchemaAction="Error"
- namespace="dbo" tableName="Academic_Term__c"
- schemaQuery="set fmtonly on;SELECT top 0 Id, Name, Academic_Planning_Year__c, Class_Review_End__c, Class_Review_Start__c, PeopleSoft_Academic_Term_External_ID__c, Peoplesoft_Term_Academic_Year__c, Semester__c, Semester_Code__c, Semester_Year__c, Term_Begin_Date__c, Term_Career__c, Term_Code__c, Term_End_Date__c, Term_Short_Name__c from dbo.Academic_Term__c;set fmtonly off;"
- />
- </sfRestSelect>
- <dbCommand connectionStringName="SalesForce" commandType="Text" commandText="delete from dbo.EXECED_Event_Class__c" />
- <sfRestSelect instanceName="Johnson"
- soql="SELECT Id, Academic_Career_LDescr__c, Academic_Career__c, Academic_Group_LDescr__c, Academic_Group__c, Academic_Term_Begin_Date__c, Academic_Term_Code__c, Academic_Term_SDescr__c, Academic_Term__c, Academic_Year__c, AC_Approved__c, Adjusted_Class_Teaching_Units__c, Airport_Pick_up_Driver__c, AP_Status__c, Campus_Ldescr__c, Campus__c, Capacity__c, Catalog_Nbr__c, CDAA_Reviewed__c, Chatter_Group_ID__c, Chatter_Group_URL__c, Classroom__c, Class_Currnt_Flg__c, Class_Description__c, Class_DM_Location_LDescr__c, Class_DM_Location__c, Class_Evaluation__c, Class_Instructors__c, Class_Key__c, Class_Number__c, Class_Restrictions__c, Class_Section__c, Class_Status__c, Class_Teaching_Units__c, Contact_Hours__c, Course_Area__c, Course_Confirmation_by__c, Course_Contact_Hrs__c, Course_Fee__c, Course_ID__c, Course_Title_Long__c, Course__c, Co_listings__c, Credit_Hours__c, Dean_Decision__c, End__c, Enrollment_Cap_Graduate__c, Enrollment_Cap_Undergraduate__c, Enrollment_Grad__c, Enrollment_Other__c, Enrollment_Undergrad__c, Enrollment__c, Enroll_Cap__c, Event_Class_Fee__c, Ground_Transportation__c, Hotel_City__c, Hotel_Country__c, Hotel_Name__c, Hotel_State__c, Hotel_Street__c, Hotel_Website__c, Hotel_Zip__c, Instructor_Hotel_Accommodations__c, Interpreter_Details__c, Letter_Returned_and_Signed_by__c, Location__c, Name, Nearest_Airport__c, New_Plan_Year_Class_Key__c, OwnerId, Participant_Count__c, Program__c, Registrar__c, Schedule__c, Session_Code__c, Session_SDescr__c, SSR_Component__c, Start__c, Status__c, Subject_LDescr__c, Subject__c, Submit_Binder_Materials_Handouts_FN_by__c, Submit_Book_Order_By__c, Submit_Pre_Course_Assignment_CM_by__c, Teaching_Units_Amplifier__c, Total_Expenses__c, Units_Max__c, Units_Min__c, Vaccination_Requirements__c, Visa_Requirements__c, Associated_Class__c, Grading_Basis__c, Meeting_Dates_and_Times__c FROM EXECED_Event_Class__c"
- >
- <destination connectionStringName="SalesForce" updateBatchSize="2000"
- missingMappingAction="Error" missingSchemaAction="Error"
- namespace="dbo" tableName="EXECED_Event_Class__c"
- schemaQuery="set fmtonly on;SELECT top 0 Id, Academic_Career_LDescr__c, Academic_Career__c, Academic_Group_LDescr__c, Academic_Group__c, Academic_Term_Begin_Date__c, Academic_Term_Code__c, Academic_Term_SDescr__c, Academic_Term__c, Academic_Year__c, AC_Approved__c, Adjusted_Class_Teaching_Units__c, Airport_Pick_up_Driver__c, AP_Status__c, Campus_Ldescr__c, Campus__c, Capacity__c, Catalog_Nbr__c, CDAA_Reviewed__c, Chatter_Group_ID__c, Chatter_Group_URL__c, Classroom__c, Class_Currnt_Flg__c, Class_Description__c, Class_DM_Location_LDescr__c, Class_DM_Location__c, Class_Evaluation__c, Class_Instructors__c, Class_Key__c, Class_Number__c, Class_Restrictions__c, Class_Section__c, Class_Status__c, Class_Teaching_Units__c, Contact_Hours__c, Course_Area__c, Course_Confirmation_by__c, Course_Contact_Hrs__c, Course_Fee__c, Course_ID__c, Course_Title_Long__c, Course__c, Co_listings__c, Credit_Hours__c, Dean_Decision__c, End__c, Enrollment_Cap_Graduate__c, Enrollment_Cap_Undergraduate__c, Enrollment_Grad__c, Enrollment_Other__c, Enrollment_Undergrad__c, Enrollment__c, Enroll_Cap__c, Event_Class_Fee__c, Ground_Transportation__c, Hotel_City__c, Hotel_Country__c, Hotel_Name__c, Hotel_State__c, Hotel_Street__c, Hotel_Website__c, Hotel_Zip__c, Instructor_Hotel_Accommodations__c, Interpreter_Details__c, Letter_Returned_and_Signed_by__c, Location__c, Name, Nearest_Airport__c, New_Plan_Year_Class_Key__c, OwnerId, Participant_Count__c, Program__c, Registrar__c, Schedule__c, Session_Code__c, Session_SDescr__c, SSR_Component__c, Start__c, Status__c, Subject_LDescr__c, Subject__c, Submit_Binder_Materials_Handouts_FN_by__c, Submit_Book_Order_By__c, Submit_Pre_Course_Assignment_CM_by__c, Teaching_Units_Amplifier__c, Total_Expenses__c, Units_Max__c, Units_Min__c, Vaccination_Requirements__c, Visa_Requirements__c, Associated_Class__c, Grading_Basis__c, Meeting_DateTime FROM EXECED_Event_Class__c;set fmtonly off;"
- >
- <columnMapping>
- <map from="Meeting_Dates_and_Times__c" to="Meeting_DateTime" />
- </columnMapping>
- </destination>
- </sfRestSelect>
- </steps>
- </WorkOrder>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement