<?xml version="1.0" encoding="utf-8"?>
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
	<channel>
		<atom:link href="https://www.xlayer.co.za/forum/extern.php?action=feed&amp;tid=39&amp;type=rss" rel="self" type="application/rss+xml" />
		<title><![CDATA[SXI Forum / CSV Field names]]></title>
		<link>https://www.xlayer.co.za/forum/viewtopic.php?id=39</link>
		<description><![CDATA[The most recent posts in CSV Field names.]]></description>
		<lastBuildDate>Sun, 16 Aug 2020 16:54:21 +0000</lastBuildDate>
		<generator>FluxBB</generator>
		<item>
			<title><![CDATA[Re: CSV Field names]]></title>
			<link>https://www.xlayer.co.za/forum/viewtopic.php?pid=184#p184</link>
			<description><![CDATA[<p>This is how, I have it working to collecting data from a CSV file.</p><br /><div class="codebox"><pre><code>&lt;Connector id=&quot;Input_File&quot; type=&quot;CSV&quot;&gt;
     &lt;Connection xsi:type=&quot;sxi:CSV&quot;&gt;
       &lt;sxi:OutputFileName/&gt;
       &lt;sxi:Delimiter&gt;,&lt;/sxi:Delimiter&gt;
       &lt;sxi:RetryDelay&gt;30&lt;/sxi:RetryDelay&gt;
     &lt;/Connection&gt;
     &lt;sxi:ReturnCodes&gt;
       &lt;sxi:Success&gt;
         &lt;sxi:Code&gt;Success Code&lt;/sxi:Code&gt;
       &lt;/sxi:Success&gt;
       &lt;sxi:RecoverableError&gt;
         &lt;sxi:Code&gt;Error Code&lt;/sxi:Code&gt;
         &lt;sxi:Code&gt;^.*No data collected for field.*$&lt;/sxi:Code&gt;
       &lt;/sxi:RecoverableError&gt;
     &lt;/sxi:ReturnCodes&gt;
&lt;/Connector&gt;</code></pre></div><div class="codebox"><pre><code>&lt;SignalRegistry xsi:type=&quot;sxi:SigReg.CSV&quot;&gt;
    &lt;sxi:ConnectorID&gt;Input_File&lt;/sxi:ConnectorID&gt;
    &lt;sxi:FolderPath&gt;C:\CSVFILES\&lt;/sxi:FolderPath&gt;
    &lt;sxi:ActionElement&gt;ProcessCSV&lt;/sxi:ActionElement&gt;
    &lt;sxi:FileName&gt;^TestCSV_.*\.csv$&lt;/sxi:FileName&gt;
    &lt;sxi:PollingDelay&gt;10&lt;/sxi:PollingDelay&gt;
    &lt;sxi:DeleteProcessed&gt;yes&lt;/sxi:DeleteProcessed&gt;
    &lt;sxi:ReadHeaders&gt;no&lt;/sxi:ReadHeaders&gt;
&lt;/SignalRegistry&gt;</code></pre></div><div class="codebox"><pre><code>&lt;Action name=&quot;ProcessCSV&quot;&gt;
      &lt;Mappings&gt;
        &lt;Collect dataDefinition=&quot;Read_Input_csv&quot; connectorId=&quot;Input_File&quot; source=&quot;C:\CSVFILES\&quot; lookupField=&quot;na&quot; lookupValue=&quot;na&quot; /&gt;
      &lt;/Mappings&gt;
&lt;/Action&gt;</code></pre></div><div class="codebox"><pre><code>&lt;sxi:DataDefinition name=&quot;Read_Input_csv&quot;&gt;
      &lt;sxi:Fields&gt;

        &lt;sxi:Field name=&quot;0&quot;&gt;
          &lt;sxi:OutputField datatype=&quot;string&quot;&gt;TabelName1&lt;/sxi:OutputField&gt;
        &lt;/sxi:Field&gt;

        &lt;sxi:Field name=&quot;2&quot;&gt;
          &lt;sxi:OutputField datatype=&quot;string&quot;&gt;TabelName2&lt;/sxi:OutputField&gt;
        &lt;/sxi:Field&gt;

        &lt;sxi:Field name=&quot;3&quot;&gt;
          &lt;sxi:OutputField datatype=&quot;string&quot;&gt;TabelName3&lt;/sxi:OutputField&gt;
        &lt;/sxi:Field&gt;

         ........
 
      &lt;/sxi:Fields&gt;
&lt;/sxi:DataDefinition&gt;</code></pre></div>]]></description>
			<author><![CDATA[dummy@example.com (StephanB)]]></author>
			<pubDate>Sun, 16 Aug 2020 16:54:21 +0000</pubDate>
			<guid>https://www.xlayer.co.za/forum/viewtopic.php?pid=184#p184</guid>
		</item>
		<item>
			<title><![CDATA[CSV Field names]]></title>
			<link>https://www.xlayer.co.za/forum/viewtopic.php?pid=59#p59</link>
			<description><![CDATA[<p>How do you specify the field names in the DataDefinition when collecting data from a row in a CSV file?</p>]]></description>
			<author><![CDATA[dummy@example.com (SeanR)]]></author>
			<pubDate>Thu, 22 Nov 2018 05:09:40 +0000</pubDate>
			<guid>https://www.xlayer.co.za/forum/viewtopic.php?pid=59#p59</guid>
		</item>
	</channel>
</rss>
