<?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 Exporting .csv from query widget results doubles columns? in ArcGIS Web AppBuilder Questions</title>
    <link>https://community.esri.com/t5/arcgis-web-appbuilder-questions/exporting-csv-from-query-widget-results-doubles/m-p/14988#M369</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Greetings,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;New to WAB. I'm using the default query widget to export query results to a .csv file. The query widget passes a number of filter expressions, including a date filter, an area filter (on numeric field), and a filter on a binary flag (also numeric).&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I am able to export the results, but the output .csv repeats each column once, doubling the number of columns. The only difference I spot in the initial versus repeated columns is in the date field. Note that the first listing of "DATE" is DD-MMM-YY, and the second is not.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/355381_pastedImage_3.png" style="width: 620px; height: 144px;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;- I have experimented with pop-up configuration (on/off, different names, etc.) thinking that could be the source or the repetition.&amp;nbsp;&lt;/P&gt;&lt;P&gt;- I have tried various combinations of export permission settings, both within the widget and in the item details.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Interestingly, if I access the table from the item details window in 'my contents' (without running a query), and download as a .csv, there is no repetition. Evidence that the problem is something with the query widget?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Again, new to WAB, so this is likely something simple. Thanks for having a look.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;WebApp is here:&amp;nbsp;&lt;A class="link-titled" href="http://u-of-l.maps.arcgis.com/apps/webappviewer/index.html?id=52ec01573a3e48cf96ec1f41abf957ae" title="http://u-of-l.maps.arcgis.com/apps/webappviewer/index.html?id=52ec01573a3e48cf96ec1f41abf957ae"&gt;ArcGIS Web Application&lt;/A&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Cheers,&lt;/P&gt;&lt;P&gt;-Dave&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 02 Jun 2017 17:28:14 GMT</pubDate>
    <dc:creator>DaveMcCaffrey</dc:creator>
    <dc:date>2017-06-02T17:28:14Z</dc:date>
    <item>
      <title>Exporting .csv from query widget results doubles columns?</title>
      <link>https://community.esri.com/t5/arcgis-web-appbuilder-questions/exporting-csv-from-query-widget-results-doubles/m-p/14988#M369</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Greetings,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;New to WAB. I'm using the default query widget to export query results to a .csv file. The query widget passes a number of filter expressions, including a date filter, an area filter (on numeric field), and a filter on a binary flag (also numeric).&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I am able to export the results, but the output .csv repeats each column once, doubling the number of columns. The only difference I spot in the initial versus repeated columns is in the date field. Note that the first listing of "DATE" is DD-MMM-YY, and the second is not.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;IMG class="image-1 jive-image" src="https://community.esri.com/legacyfs/online/355381_pastedImage_3.png" style="width: 620px; height: 144px;" /&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;- I have experimented with pop-up configuration (on/off, different names, etc.) thinking that could be the source or the repetition.&amp;nbsp;&lt;/P&gt;&lt;P&gt;- I have tried various combinations of export permission settings, both within the widget and in the item details.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Interestingly, if I access the table from the item details window in 'my contents' (without running a query), and download as a .csv, there is no repetition. Evidence that the problem is something with the query widget?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Again, new to WAB, so this is likely something simple. Thanks for having a look.&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;WebApp is here:&amp;nbsp;&lt;A class="link-titled" href="http://u-of-l.maps.arcgis.com/apps/webappviewer/index.html?id=52ec01573a3e48cf96ec1f41abf957ae" title="http://u-of-l.maps.arcgis.com/apps/webappviewer/index.html?id=52ec01573a3e48cf96ec1f41abf957ae"&gt;ArcGIS Web Application&lt;/A&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Cheers,&lt;/P&gt;&lt;P&gt;-Dave&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 02 Jun 2017 17:28:14 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-web-appbuilder-questions/exporting-csv-from-query-widget-results-doubles/m-p/14988#M369</guid>
      <dc:creator>DaveMcCaffrey</dc:creator>
      <dc:date>2017-06-02T17:28:14Z</dc:date>
    </item>
    <item>
      <title>Re: Exporting .csv from query widget results doubles columns?</title>
      <link>https://community.esri.com/t5/arcgis-web-appbuilder-questions/exporting-csv-from-query-widget-results-doubles/m-p/14989#M370</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Dave,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp; &amp;nbsp;I would suggest that you contact tech support on this issue if you have not already, Since this is WAB on AGOL there is little the community can do to help you with this.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 08 Jun 2017 13:02:01 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-web-appbuilder-questions/exporting-csv-from-query-widget-results-doubles/m-p/14989#M370</guid>
      <dc:creator>RobertScheitlin__GISP</dc:creator>
      <dc:date>2017-06-08T13:02:01Z</dc:date>
    </item>
    <item>
      <title>Re: Exporting .csv from query widget results doubles columns?</title>
      <link>https://community.esri.com/t5/arcgis-web-appbuilder-questions/exporting-csv-from-query-widget-results-doubles/m-p/14990#M371</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Same issue here.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 08 Jun 2017 21:30:04 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-web-appbuilder-questions/exporting-csv-from-query-widget-results-doubles/m-p/14990#M371</guid>
      <dc:creator>BL</dc:creator>
      <dc:date>2017-06-08T21:30:04Z</dc:date>
    </item>
    <item>
      <title>Re: Exporting .csv from query widget results doubles columns?</title>
      <link>https://community.esri.com/t5/arcgis-web-appbuilder-questions/exporting-csv-from-query-widget-results-doubles/m-p/14991#M372</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;I have the same issue. Esri support indicated that the issue has been logged as "BUG-000103768: The Query widget in Web AppBuilder creates duplicate fields when exporting the result as a csv file".&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;A href="http://support.esri.com/bugs/nimbus/QlVHLTAwMDEwMzc2OA=="&gt;http://support.esri.com/bugs/nimbus/QlVHLTAwMDEwMzc2OA==&lt;/A&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 26 Jun 2017 17:15:06 GMT</pubDate>
      <guid>https://community.esri.com/t5/arcgis-web-appbuilder-questions/exporting-csv-from-query-widget-results-doubles/m-p/14991#M372</guid>
      <dc:creator>ToddBurciaga</dc:creator>
      <dc:date>2017-06-26T17:15:06Z</dc:date>
    </item>
  </channel>
</rss>

