Program

Program Values

 

Program Version Values

 

XML

 

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

<!--

 *

 * CampusVueProgramImport.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 Program Import.]]>

 </Summary>

 <JobParameters>

   <JobParameterGroup caption="CampusVue Database Settings">

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

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

   </JobParameterGroup>

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

 

     <JobParameter name="DoImportPrograVersions" caption="Import Program Versions? (Y/N)"   validationExpression="[NYny]" maxLength="1" required="true" />

     <JobParameter name="IncludeActiveOnly" caption="Include Active Programs Only? (Y/N)" validationExpression="[NYny]" maxLength="1" required="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 (Program) Data -->

       <Source name="Programs" endPoint="PrimarySIS" xsd="file:\\SIS\ProgramSpokeData.xsd">

 

           <Sql>

               <![CDATA[

SELECT

   AdProgramID AS ProgramSisKey,

   rtrim(Code) AS ProgramName,

   rtrim(Descrip) AS ProgramDescription,

   Active AS ProgramIsActive

FROM        AdProgram

                                 ]]>

           </Sql>

           <Sql if="IncludeActiveOnly">

               <![CDATA[

WHERE Active=1

         ]]>

           </Sql>

           <Schema entityName="Program" groupName="Programs"/>

       </Source>

 

       <!-- Program Version Data -->

       <Source name="ProgramVersions" endPoint="PrimarySIS" xsd="file:\\SIS\ProgramSpokeData.xsd">

 

           <Sql>

               <![CDATA[

Select

   pv.AdProgramID as ProgramSisKey,

   pv.AdProgramVersionID as SisKey,

   rtrim(p.Code) as Program,

   rtrim(pv.Code) as CatalogVersion,

   1 as IsCaptive,

   'F' as MinGrade,

   0 as SingleEntityReuse,

   pv.Active as IsActive

From AdProgramVersion pv

inner join AdProgram p on pv.AdProgramID = p.AdProgramID

               ]]>

           </Sql>

           <Sql if="IncludeActiveOnly">

               <![CDATA[

and p.Active=1

where pv.Active=1

               ]]>

           </Sql>

           <Schema entityName="ProgramVersion" groupName="ProgramVersions"/>

       </Source>

 

 

   </Sources>

 

   <Phases>

       <Phase name="ImportPrograms">

 

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

           <Fetch ref="Programs"/>

 

           <Target endPoint="Astra">

               <AstraEnvironment>

                   <Hub className="ProgramHub">

                       <Reader ref="Programs"/>

                   </Hub>

               </AstraEnvironment>

           </Target>

 

       </Phase>

       <Phase name="ImportProgramVersions" if="'y' == DoImportPrograVersions.ToLower()">

 

           <!-- ProgramVersion Source -->

           <Fetch ref="ProgramVersions"/>

 

           <Target endPoint="Astra">

               <AstraEnvironment>

                   <Hub className="ProgramVersionImportHub">

                       <Reader ref="ProgramVersions"/>

                   </Hub>

               </AstraEnvironment>

           </Target>

 

       </Phase>

 

   </Phases>

 

 </Pipeline>

</ATE>

 

Page url: ?program.htm