<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Why is CSV generated from report via trigger action inserting alternating blank rows? in Reporting</title>
    <link>https://community.splunk.com/t5/Reporting/Why-is-CSV-generated-from-report-via-trigger-action-inserting/m-p/531365#M8601</link>
    <description>&lt;P&gt;Hi All,&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I'm experiencing a funny issue with a Report I've setup within the "Search" module of Splunk.&amp;nbsp; The report is&amp;nbsp; generating a straight-forward table, example below:&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lshoreSPLUNK_0-1606755081153.png" style="width: 400px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/12112iE38575498D2DB0E9/image-size/medium?v=v2&amp;amp;px=400" role="button" title="lshoreSPLUNK_0-1606755081153.png" alt="lshoreSPLUNK_0-1606755081153.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;I've it configured for the search runs once per day, with a trigger action to send an email with the search results in a .csv file.&amp;nbsp; I've had this alert up and running for months without issue, however in recent days when I open the attached .CSV file for this daily email, there are alternative blank rows being included in the CSV file:&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lshoreSPLUNK_0-1606755436084.png" style="width: 400px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/12113i7D542A09D7E7B884/image-size/medium?v=v2&amp;amp;px=400" role="button" title="lshoreSPLUNK_0-1606755436084.png" alt="lshoreSPLUNK_0-1606755436084.png" /&gt;&lt;/span&gt;&lt;BR /&gt;&lt;BR /&gt;If I run this search and download the .csv manually, the report doesn't have any alternating blank rows included in the report.&amp;nbsp; Similarly, if I update this daily report to instead attach a PDF of the search results, the PDF does not include any alternating blank rows.&amp;nbsp; So, I think the issue lies with something to do with the Trigger Action 'send email' however I can't seem to figure out what's causing this.&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;Is anyone aware of this being a known issue, or is there somewhere obvious that I'm overlooking here?&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;Thanks&lt;/P&gt;</description>
    <pubDate>Tue, 22 Mar 2022 17:56:50 GMT</pubDate>
    <dc:creator>lshoreSPLUNK</dc:creator>
    <dc:date>2022-03-22T17:56:50Z</dc:date>
    <item>
      <title>Why is CSV generated from report via trigger action inserting alternating blank rows?</title>
      <link>https://community.splunk.com/t5/Reporting/Why-is-CSV-generated-from-report-via-trigger-action-inserting/m-p/531365#M8601</link>
      <description>&lt;P&gt;Hi All,&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I'm experiencing a funny issue with a Report I've setup within the "Search" module of Splunk.&amp;nbsp; The report is&amp;nbsp; generating a straight-forward table, example below:&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lshoreSPLUNK_0-1606755081153.png" style="width: 400px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/12112iE38575498D2DB0E9/image-size/medium?v=v2&amp;amp;px=400" role="button" title="lshoreSPLUNK_0-1606755081153.png" alt="lshoreSPLUNK_0-1606755081153.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;I've it configured for the search runs once per day, with a trigger action to send an email with the search results in a .csv file.&amp;nbsp; I've had this alert up and running for months without issue, however in recent days when I open the attached .CSV file for this daily email, there are alternative blank rows being included in the CSV file:&lt;BR /&gt;&lt;BR /&gt;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="lshoreSPLUNK_0-1606755436084.png" style="width: 400px;"&gt;&lt;img src="https://community.splunk.com/t5/image/serverpage/image-id/12113i7D542A09D7E7B884/image-size/medium?v=v2&amp;amp;px=400" role="button" title="lshoreSPLUNK_0-1606755436084.png" alt="lshoreSPLUNK_0-1606755436084.png" /&gt;&lt;/span&gt;&lt;BR /&gt;&lt;BR /&gt;If I run this search and download the .csv manually, the report doesn't have any alternating blank rows included in the report.&amp;nbsp; Similarly, if I update this daily report to instead attach a PDF of the search results, the PDF does not include any alternating blank rows.&amp;nbsp; So, I think the issue lies with something to do with the Trigger Action 'send email' however I can't seem to figure out what's causing this.&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;Is anyone aware of this being a known issue, or is there somewhere obvious that I'm overlooking here?&amp;nbsp;&lt;BR /&gt;&lt;BR /&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Tue, 22 Mar 2022 17:56:50 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Reporting/Why-is-CSV-generated-from-report-via-trigger-action-inserting/m-p/531365#M8601</guid>
      <dc:creator>lshoreSPLUNK</dc:creator>
      <dc:date>2022-03-22T17:56:50Z</dc:date>
    </item>
    <item>
      <title>Re: CSV generated from report via Trigger Action inserting alternating blank rows?</title>
      <link>https://community.splunk.com/t5/Reporting/Why-is-CSV-generated-from-report-via-trigger-action-inserting/m-p/590231#M11289</link>
      <description>&lt;P&gt;I am also experiencing this issue -- it was working at one point w/o the additional line.&amp;nbsp; I've looked over the fields we're using and the extra&amp;nbsp;&lt;SPAN&gt;LF doesn't appear to be coming from a field.&lt;/SPAN&gt;&lt;/P&gt;</description>
      <pubDate>Tue, 22 Mar 2022 14:58:01 GMT</pubDate>
      <guid>https://community.splunk.com/t5/Reporting/Why-is-CSV-generated-from-report-via-trigger-action-inserting/m-p/590231#M11289</guid>
      <dc:creator>Saeryn</dc:creator>
      <dc:date>2022-03-22T14:58:01Z</dc:date>
    </item>
  </channel>
</rss>

