<?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 Re: Export csv to SFTP with headers only in Adobe Campaign Classic Questions</title>
    <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/461866#M15738</link>
    <description>&lt;P&gt;Achieved using Javascript activity.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;var f = new File(vars.filename)&lt;BR /&gt;f.open("a"); //append mode&lt;BR /&gt;f.writeln("column_name1,column_name2,column_name3");&lt;BR /&gt;f.close()&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 20 Jul 2022 09:45:15 GMT</pubDate>
    <dc:creator>parmeshwarr3905</dc:creator>
    <dc:date>2022-07-20T09:45:15Z</dc:date>
    <item>
      <title>Export csv to SFTP with headers only</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/449399#M15031</link>
      <description>&lt;P&gt;I have created a workflow where I'm extracting data and exporting the required column in csv format to SFTP location. But in case there are 0 records I have to export blank csv file to SFTP with headers only.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Can you please guide how this can be achieved. Currently it creates blank file without headers.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks in advance.&lt;/P&gt;</description>
      <pubDate>Fri, 22 Apr 2022 16:28:58 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/449399#M15031</guid>
      <dc:creator>parmeshwarr3905</dc:creator>
      <dc:date>2022-04-22T16:28:58Z</dc:date>
    </item>
    <item>
      <title>Re: Export csv to SFTP with headers only</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/449481#M15034</link>
      <description>&lt;P&gt;Hello&amp;nbsp;&lt;LI-USER uid="15033507"&gt;&lt;/LI-USER&gt;&amp;nbsp;,&lt;/P&gt;&lt;P&gt;you can create file with and write headers in to it when there is no records from JS activity. Or you can create one dummy file with headers save it to the server file storage and send that instead when there is no data.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Marcel&lt;/P&gt;</description>
      <pubDate>Sat, 23 Apr 2022 17:39:56 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/449481#M15034</guid>
      <dc:creator>Marcel_Szimonisz</dc:creator>
      <dc:date>2022-04-23T17:39:56Z</dc:date>
    </item>
    <item>
      <title>Re: Export csv to SFTP with headers only</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/449614#M15038</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="6970553"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I have used test activity to check if there are zero records then next is JS activity where i'm writing a code to create a file with headers but i'm getting an error "Access to file '&amp;lt;path&amp;gt;' is forbidden "&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="parmeshwarr3905_1-1650888032432.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/40455i0471FF07621E71BF/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="parmeshwarr3905_1-1650888032432.png" alt="parmeshwarr3905_1-1650888032432.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;please let me know the error reason or alternate way.&lt;/P&gt;&lt;P&gt;I can create a dummy file as you suggested but if someone deletes that by mistake it could be a problem.&lt;/P&gt;</description>
      <pubDate>Mon, 25 Apr 2022 12:00:44 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/449614#M15038</guid>
      <dc:creator>parmeshwarr3905</dc:creator>
      <dc:date>2022-04-25T12:00:44Z</dc:date>
    </item>
    <item>
      <title>Re: Export csv to SFTP with headers only</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/450109#M15059</link>
      <description>&lt;P&gt;&lt;LI-USER uid="6970553"&gt;&lt;/LI-USER&gt;&amp;nbsp;if there is already a solution based on javascript code could you please point me to that? I'm not able to troubleshoot this further&lt;/P&gt;</description>
      <pubDate>Thu, 28 Apr 2022 09:42:04 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/450109#M15059</guid>
      <dc:creator>parmeshwarr3905</dc:creator>
      <dc:date>2022-04-28T09:42:04Z</dc:date>
    </item>
    <item>
      <title>Re: Export csv to SFTP with headers only</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/450128#M15060</link>
      <description>&lt;P&gt;where did you put the blank file? add it where all files are exported so you can access it..&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;nl6/var/[YOUR_INSTANCE_NAME]/export&lt;/PRE&gt;&lt;P&gt;Marcel&lt;/P&gt;</description>
      <pubDate>Thu, 28 Apr 2022 11:06:48 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/450128#M15060</guid>
      <dc:creator>Marcel_Szimonisz</dc:creator>
      <dc:date>2022-04-28T11:06:48Z</dc:date>
    </item>
    <item>
      <title>Re: Export csv to SFTP with headers only</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/450137#M15061</link>
      <description>&lt;P&gt;I have placed my file on sftp location&lt;/P&gt;&lt;P&gt;sftp://&amp;lt;instance&amp;gt;/incoming/export/&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Can I move it to different folder from that location say&amp;nbsp;&lt;/P&gt;&lt;P&gt;sftp://&amp;lt;instance&amp;gt;/incoming/export/integration/&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;Parmeshwar&lt;/P&gt;</description>
      <pubDate>Thu, 28 Apr 2022 12:28:46 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/450137#M15061</guid>
      <dc:creator>parmeshwarr3905</dc:creator>
      <dc:date>2022-04-28T12:28:46Z</dc:date>
    </item>
    <item>
      <title>Re: Export csv to SFTP with headers only</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/450157#M15062</link>
      <description>&lt;P&gt;HI there,&lt;/P&gt;&lt;P&gt;Why use a Java Script when the Data Extract activity is already proposing the capability&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Denis_Bozonnet_0-1651155418937.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/40561i0136B2A3AD973EEA/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Denis_Bozonnet_0-1651155418937.png" alt="Denis_Bozonnet_0-1651155418937.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;If there is no record, a file with just the header will be created, no need to JavaScript.&lt;/P&gt;&lt;P&gt;Let me know if it solves your topic,&lt;/P&gt;&lt;P&gt;Thanks&lt;BR /&gt;Denis&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Thu, 28 Apr 2022 14:17:43 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/450157#M15062</guid>
      <dc:creator>Denis_Bozonnet</dc:creator>
      <dc:date>2022-04-28T14:17:43Z</dc:date>
    </item>
    <item>
      <title>Re: Export csv to SFTP with headers only</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/450163#M15064</link>
      <description>&lt;P&gt;&lt;LI-USER uid="15740006"&gt;&lt;/LI-USER&gt;&amp;nbsp; I had that option selected but it is creating a file without headers. correct me if I'm missing any other settings&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="parmeshwarr3905_0-1651156313480.png" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/40563iC19B8894F1E46FB6/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="parmeshwarr3905_0-1651156313480.png" alt="parmeshwarr3905_0-1651156313480.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;</description>
      <pubDate>Thu, 28 Apr 2022 14:33:29 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/450163#M15064</guid>
      <dc:creator>parmeshwarr3905</dc:creator>
      <dc:date>2022-04-28T14:33:29Z</dc:date>
    </item>
    <item>
      <title>Re: Export csv to SFTP with headers only</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/450171#M15067</link>
      <description>&lt;P&gt;Hi, this is new then because it has worked in the past for sure....sorry to hear it doesn't anymore... back to the JS which isn't great really....&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Denis&lt;/P&gt;</description>
      <pubDate>Thu, 28 Apr 2022 14:58:57 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/450171#M15067</guid>
      <dc:creator>Denis_Bozonnet</dc:creator>
      <dc:date>2022-04-28T14:58:57Z</dc:date>
    </item>
    <item>
      <title>Re: Export csv to SFTP with headers only</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/450177#M15069</link>
      <description>&lt;P&gt;Hi&amp;nbsp;&lt;LI-USER uid="15740006"&gt;&lt;/LI-USER&gt;&amp;nbsp;Yes right, could you help me out on setting up JS activity?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;Parmeshwar&lt;/P&gt;</description>
      <pubDate>Thu, 28 Apr 2022 15:11:56 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/450177#M15069</guid>
      <dc:creator>parmeshwarr3905</dc:creator>
      <dc:date>2022-04-28T15:11:56Z</dc:date>
    </item>
    <item>
      <title>Re: Export csv to SFTP with headers only</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/452841#M15217</link>
      <description>&lt;P&gt;Hello&amp;nbsp;&lt;LI-USER uid="15033507"&gt;&lt;/LI-USER&gt;&amp;nbsp;&lt;BR /&gt;Please see below setup&lt;BR /&gt;Test activity -&amp;gt; To check for 0 Records&lt;BR /&gt;Query activity -&amp;gt; To fetch 1 record from any schema. Maybe use a Primary Key filter from nms:recipient or any other schema.&lt;BR /&gt;Data extraction activity -&amp;gt;&amp;nbsp;&lt;BR /&gt;- uncheck &lt;U&gt;Use first line as column header&lt;BR /&gt;&lt;/U&gt;- Data formatting step, provide the number of header columns with&lt;BR /&gt;Create new of Type &lt;U&gt;Fixed String&lt;/U&gt;&lt;/P&gt;&lt;P&gt;Provide your header string in the &lt;U&gt;edit box&lt;/U&gt; without any single/double quotes&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Kishore_Padamata_0-1653051797608.gif" style="width: 400px;"&gt;&lt;img src="https://experienceleaguecommunities.adobe.com/t5/image/serverpage/image-id/41166i833BFC343DFF3042/image-size/medium/is-moderation-mode/true?v=v2&amp;amp;px=400" role="button" title="Kishore_Padamata_0-1653051797608.gif" alt="Kishore_Padamata_0-1653051797608.gif" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;Hope this helps!&lt;/P&gt;</description>
      <pubDate>Fri, 20 May 2022 13:09:56 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/452841#M15217</guid>
      <dc:creator>Kishore_Padamata</dc:creator>
      <dc:date>2022-05-20T13:09:56Z</dc:date>
    </item>
    <item>
      <title>Re: Export csv to SFTP with headers only</title>
      <link>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/461866#M15738</link>
      <description>&lt;P&gt;Achieved using Javascript activity.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;var f = new File(vars.filename)&lt;BR /&gt;f.open("a"); //append mode&lt;BR /&gt;f.writeln("column_name1,column_name2,column_name3");&lt;BR /&gt;f.close()&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 20 Jul 2022 09:45:15 GMT</pubDate>
      <guid>https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/export-csv-to-sftp-with-headers-only/m-p/461866#M15738</guid>
      <dc:creator>parmeshwarr3905</dc:creator>
      <dc:date>2022-07-20T09:45:15Z</dc:date>
    </item>
  </channel>
</rss>

