Sample xml event withresult and global vars

<?xml version="1.0" encoding="utf-8"?>
<export>
  <configuration>
    <separator>;</separator>
    <textquote>"</textquote>
	<newline>\r\n</newline>
	<encoding>UTF8</encoding>
  </configuration>
  <contents>
	<!-- Usefull for export string expression functions:
		Separator() - Returns separator defined in configuration
		TextQuote() - Returns text quote defined in configuration
		NewLine() - Returns new line defined in configuration
		CsvEncode(arg1, arg2, ...) - Encode passed arguments to valid csv structure
		XmlEncode(arg) - Encode argument to valid xml text
		HtmlEncode(arg) - Encode argument to valid html text
	-->

    <variable>
      <name>Export_JobCode</name>
      <value>""</value>
    </variable>

    <const>
<![CDATA[
"<?xml version='1.0' encoding='utf-8'?>
<JobList>
"
]]>
    </const>
	

    <foreach table="woJob" datacontext="externaldataset" classname="DataBO.ProcessMngt.JobBO">

      <dbfilter>woJob.StartDate >=  DATEADD(NOW(), 'MONTH', -6) order by woJob.StartDate MAXRESULTS 5</dbfilter>

      <variable>
        <name>Export_JobCode</name>
        <value>woJob.JobCode</value>
      </variable>


      <data>
<![CDATA[
"<woJob>
	<JobCode>" +     XmlEncode(JobCode) + "</JobCode>
	<Description>" + XmlEncode(FullDescription) + "</Description>
	<JobStatus>" +   XmlEncode(syJobStatus.Code) + "</JobStatus>
	<JobType>" +     XmlEncode(syJobType.Code) + "</JobType>
	<JobPriority>" + XmlEncode(syPriority.Code) + "</JobPriority>
	<AssetCode>" +     XmlEncode(pmAsset.Code) + "</AssetCode>
	<Craft>" +       XmlEncode(emCraft.CraftCode) + "</Craft>
	<StartDate>" +   XmlEncode(StartDate) + "</StartDate>
"	
]]>
		</data>
		
		<foreach table="woJobTask">
			<data>
<![CDATA[
"	<woJobTask>
		<TaskCode>" +    XmlEncode(Code) + "</TaskCode>
		<Description>" + XmlEncode(Description) + "</Description>
		<TaskType>" +    XmlEncode(syTaskType.Code) + "</TaskType>
		<TaskStatus>" +  XmlEncode(syJobStatus.Code) + "</TaskStatus>
	</woJobTask>
"	
]]>
			</data>

		</foreach>
		
		<data>
<![CDATA[
"</woJob>
"
]]>
		</data>
    </foreach>
	
	<const>
<![CDATA[
"</JobList>
"
]]>	
	</const>
	
  </contents>
  
  <import>
  	<mappings classname="Control.GeneralInterface.XMLFileImport">	
			<table name="JobList" xpath="/JobList/woJob">
				<field name="JobCode" xpath="JobCode"></field>
				<field name="CreatedJobCode" xpath="CreatedJobCode"></field>
			</table>
	</mappings>
	
	<assign classname="Control.GeneralInterface.StandardImportProcessor">
		<businessobject classname="DataBO.ProcessMngt.JobBO">
			<table name="woJob" sourceTable="JobList">
				<identification>woJob.JobCode = #Export_JobCode</identification>
				<mode>
					<update/>
				</mode>
				
				<set>
					<field name="FullDescription">"remote job shadow code: " + #Import.CreatedJobCode</field>
				</set>
			</table>
		</businessobject>
	</assign>
  </import>
  
</export>