Delimited File Data Source XML Example

<BatchDataSyncConfig name="Contact Import" version="1.0.0" xmlns="http://www.cinchy.co">
  <Parameters>
	  <Parameter name="filepath" />
  </Parameters>
  <DelimitedDataSource 
    delimiter="," 
    textQualifier="&quot;" 
    headerRowsToIgnore="1"
    path="@filepath" encoding="UTF8">
    <Schema>
    <Column name="First Name" dataType="Text" />
    <Column name="Last Name" dataType="Text" />
    <Column name="Email Address" dataType="Text"/>
    <Column name="Title" dataType="Text"/>
    <Column name="Company" dataType="Text"/>
    <CalculatedColumn name="Full Name" formula="CONCAT(First Name,' ',Last Name)" dataType="Text" />
  </Schema>
  <Filter/>
</DelimitedDataSource>
  <CinchyTableTarget model="" domain="Sandbox" table="People" suppressDuplicateErrors="false">
<ColumnMappings>
	<ColumnMapping sourceColumn="Full Name" targetColumn="Name" />
	<ColumnMapping sourceColumn="Title" targetColumn="Title" />
	<ColumnMapping sourceColumn="Company" targetColumn="Company" />
</ColumnMappings>
<SyncKey>
        <SyncKeyColumnReference name="Name" />
</SyncKey>		
		<NewRecordBehaviour type="INSERT" />
        <ChangedRecordBehavior type="UPDATE" />
		<DroppedRecordBehaviour type="DELETE"/>
</CinchyTableTarget>
</BatchDataSyncConfig>