Term

Term Values

 

XML

 

<?xml version="1.0" encoding="utf-8" ?>

<!--

 *

 * CampusVueTermImport.xml

 * Copyright (C) 2006-2009, Ad Astra Information Systems, LLC.

 * All Rights Reserved

 *

 * Note: This spoke file requires an entry in the SystemSetting table with KeyName=PrimarySisConnectionString

-->

<ATE xmlns="http://aais.com/schema/7.4.0/ATE/ATE"

    xmlns:xsl="http://www.w3.org/1999/XSL/Transform"

    xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"

    xmlns:soap12="http://www.w3.org/2003/05/soap-envelope"

    version="2.0" jobType="Import" validMode="Batch">

 

 <Summary>

   <![CDATA[Generic CampusVue MsSql Term Import.]]>

 </Summary>

 <JobParameters>

   <JobParameterGroup caption="CampusVue Database Settings">

     <JobParameter name="SISUser" caption="User Id"/>

     <JobParameter name="SISPass" caption="Password" password="true"/>

   </JobParameterGroup>

   <SystemParameter name="SisConnectString" settingKey="PrimarySisConnectionString"/>

 

   <ListParameter name="CampusId" caption="Campus" listSourceEntity="Campus" listSourceKeyProperty="SisKey" allowMultiple="true"/>

 

 </JobParameters>

 

 <EndPoints>  

   <DbmsEndPoint name="PrimarySIS" adapterType="MsSql">

     <Parameters>

         <Parameter name="SisConnectString" ref="SisConnectString"/>

       <Parameter name="SISUID" ref="SISUser"/>

       <Parameter name="SISPwd" ref="SISPass"/>

     </Parameters>

     <ConnectionString>

       <![CDATA[${SisConnectString};User Id=${SISUID};Password=${SISPwd};]]>

     </ConnectionString>

   </DbmsEndPoint>

 </EndPoints>

 

 <Pipeline>

 <Sources>

 

                 <!-- Top Level (Term) Data -->                        

                 <Source name="Terms" endPoint="PrimarySIS">

       <SqlParameters>

         <SqlParameter sqlBind="@CampusId" name="CampusId" ref="CampusId"/>

       </SqlParameters>

       <Sql>

                                 <![CDATA[

SELECT

                 AdTerm.AdTermId AS TermSisKey,

                 AdTerm.Code AS TermName,

                 AdTerm.Descrip AS TermDescription,

                 AdTerm.StartDate AS TermStartDate,

                 AdTerm.EndDate AS TermEndDate,

                 'Standard' AS TermTypeSisKey,

                 'Standard' AS TermTypeName,

                 AdTerm.Active AS TermIsActive

FROM        AdTerm

INNER JOIN SyCampusGrp ON AdTerm.SyCampusGrpID = SyCampusGrp.SyCampusGrpID

INNER JOIN SyCampusList ON SyCampusGrp.SyCampusGrpID = SyCampusList.SyCampusGrpID

WHERE SyCampusList.SyCampusID = @CampusId

                                 ]]>

                         </Sql>

                         <Schema entityName="Term" groupName="Terms"/>

                 </Source>

 

   </Sources>

 

   <Phases>

         <Phase name="ImportTerms">

 

     <!-- Top Level (Term) Source -->

     <Fetch ref="Terms"/>

 

     <Target endPoint="Astra">

       <AstraEnvironment>

         <Hub className="TermHub">

           <Reader ref="Terms"/>

           <AlternateHubs>

             <Hub className="TermTypeHub"/>

           </AlternateHubs>

         </Hub>

       </AstraEnvironment>

     </Target>

                 

           </Phase>

         

   </Phases>

 

 </Pipeline>

</ATE>

 

Page url: ?term.htm