Advertisement
uniblab

sample download from SalesForce

Sep 15th, 2019 (edited)
402
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
XML 5.73 KB | None | 0 0
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <!-- Copyright 2022, Timothy J. Bruce -->
  3. <WorkOrder xmlns="http://Icod.Wod" xsi:schemaLocation="http://Icod.Wod https://raw.githubusercontent.com/uniblab/Icod.Wod/master/schema0.xsd"
  4.    xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  5.    jobName="Daily ExecEd Download process"
  6.    emailTo="none@example.com"
  7. >
  8.  
  9.     <steps>
  10.         <dbCommand connectionStringName="SalesForce" commandType="Text" commandText="delete from dbo.Academic_Term__c" />
  11.         <sfRestSelect instanceName="Johnson"
  12.             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"
  13.         >
  14.             <destination connectionStringName="SalesForce" updateBatchSize="2000"
  15.                 missingMappingAction="Error" missingSchemaAction="Error"
  16.                 namespace="dbo" tableName="Academic_Term__c"
  17.                 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;"
  18.             />
  19.         </sfRestSelect>
  20.  
  21.         <dbCommand connectionStringName="SalesForce" commandType="Text" commandText="delete from dbo.EXECED_Event_Class__c" />
  22.         <sfRestSelect instanceName="Johnson"
  23.             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"
  24.         >
  25.             <destination connectionStringName="SalesForce" updateBatchSize="2000"
  26.                 missingMappingAction="Error" missingSchemaAction="Error"
  27.                 namespace="dbo" tableName="EXECED_Event_Class__c"
  28.                 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;"
  29.             >
  30.                 <columnMapping>
  31.                     <map from="Meeting_Dates_and_Times__c" to="Meeting_DateTime" />
  32.                 </columnMapping>
  33.             </destination>
  34.         </sfRestSelect>
  35.  
  36.     </steps>
  37.  
  38. </WorkOrder>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement