The ATE20.xsd will help a lot when using an XML Schema savvy editor (like Visual Studio, Eclipse, NetBeans, etc.). The general idea is that you would define an EndPoint for the output file and use a FileWriter in the Target of a Phase. Below are some snippets from our Event signage export file and Banner section room assignment export. The spoke we will create will be a combination of these building blocks. The following is not a valid spoke, but rather the highlights of the three most important parts.
<EndPoints>
<FileEndPoint name="ftpSignFile">
<Parameters>
<Parameter name="FileName" ref="ExportFileName" />
<Parameter name="Host" ref="FTPHost" />
<Parameter name="User" ref="FTPUser" />
<Parameter name="Pwd" ref="FTPPass" />
</Parameters>
<FileResource href="ftp://${User}:${Pwd}@${Host}/${FileName}" />
</FileEndPoint>
</EndPoints>
<Pipeline>
<Sources>
<!-- The fields and associations again match what is described in the
entity definition files. -->
<Source name="Astra">
<Astra from="SectionMeeting" rootElement="SectionMeetings">
<Select column="SisKey" />
<Select column="RoomConfiguration.Room.SisKey" as="RoomSisKey" />
</Astra>
</Source>
</Sources>
<Phases>
<Phase name="ExportEvents">
<Fetch ref="Astra"/>
<Target endPoint="ftpSignFile">
<FileWriter verb="write" sourceReader="Astra">
<XmlFile/>
</FileWriter>
</Target>
</Phase>
</Phases>
</Pipeline>
Comments
Please sign in to leave a comment.