Sample csv

From Agility
Jump to: navigation, search
<?xml version="1.0" encoding="utf-8"?>
<export>
  <configuration>
    <separator>;</separator>
    <textquote>"</textquote>
	<newline>\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>
		"JobCode" + Separator() + "Desc" + Separator() + "StartDate"+ Separator() + "Due" + NewLine()
    </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>
		<data>
		CsvEncode( JobCode, FullDescription, StartDate, DueDate ) + NewLine()
		</data>
    </foreach>
  </contents>
</export>