Sample xml

From Agility
Revision as of 14:25, 4 July 2017 by Sosenka (Talk | contribs) (Created page with "<source> <?xml version="1.0" encoding="utf-8"?> <export> <configuration> <separator>;</separator> <textquote>"</textquote> <newline>\r\n</newline> <encoding>UTF8</...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
<?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
	-->
	
    <const>
<![CDATA[
"<?xml version='1.0' encoding='utf-8'?>
<JobList>
"
]]>
    </const>
	
    <!-- datacontext = dataset | database | query - (default - dataset) -->
    <foreach table="woJob" datacontext="database" classname="DataBO.ProcessMngt.JobBO">
      <!-- dbfilter is optional and valid for database-related export table only-->
      <dbfilter>woJob.StartDate >=  DATEADD(NOW(), 'MONTH', -6) order by woJob.StartDate</dbfilter>
		<variable>
			<name>JobID</name>
			<value>woJob.JobID</value>
		</variable>
			
		<data>
<![CDATA[
"<woJob>
	<JobCode>" +     XmlEncode(JobCode) + "</JobCode>
	<Description>" + XmlEncode(FullDescription) + "</Description>
	<JobStatus>" +   XmlEncode(syJobStatus.Description) + "</JobStatus>
	<JobType>" +     XmlEncode(syJobType.Description) + "</JobType>
	<StartDate>" +   XmlEncode(StartDate) + "</StartDate>
	<DueDate>" +     XmlEncode(DueDate) +   "</DueDate>
"	
]]>
		</data>
		
		<foreach table="woJobTask" datacontext="database">
			<dbfilter>woJobTask.JobID = #JobID</dbfilter>

			<data>
<![CDATA[
"	<woJobTask>
		<TaskCode>" +    XmlEncode(Code) + "</TaskCode>
		<Description>" + XmlEncode(Description) + "</Description>
		<TaskType>" +    XmlEncode(syTaskType.Code) + "</TaskType>
		<TaskStatus>" +  XmlEncode(syJobStatus.Description) + "</TaskStatus>
	</woJobTask>
"	
]]>
			</data>

		</foreach>
		
		<data>
<![CDATA[
"</woJob>
"
]]>
		</data>
    </foreach>
	
	<const>
<![CDATA[
"</JobList>
"
]]>	
	</const>
	
  </contents>
</export>