Attribute Code

Attribute Code Values

 

XML

 

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

<!--

 *

 * CampusVueAttributeCodeImport.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 Attribute Code 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"/>

 

 </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>

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

                         

                         <Sql>

                                 <![CDATA[

SELECT

                 AdAttributeId AS AttributeCodeSisKey,

                 Code AS AttributeCode,

                 Descrip AS AttributeCodeDescription,

                 Active AS AttributeCodeIsActive

FROM        AdAttribute

                                 ]]>

                         </Sql>

                         <Schema entityName="AttributeCode" groupName="AttributeCodes"/>

                 </Source>

 

 

   </Sources>

 

   <Phases>

         <Phase name="ImportAttributeCodes">

                 <Fetch ref="AttributeCodes"/>

 

                 <Target endPoint="Astra">

                   <AstraEnvironment>

         <Hub className="AttributeCodeHub">

           <Reader ref="AttributeCodes"/>

         </Hub>

                   </AstraEnvironment>

                 </Target>

                 

           </Phase>

         

   </Phases>

 

 </Pipeline>

</ATE>

 

Page url: ?campusvue_attributecode.htm