topic Re: Problem with Export to CSV from web map app. in ArcGIS Web AppBuilder Questions

Problem with Export to CSV from web map app.

ValerieJohnson — Wed, 18 Apr 2018 22:57:49 GMT

I have two web map apps that let a user select features on the map, view the selected features in the attribute table, and export the selected features to a CSV file. These apps were created in the Web App Builder and have been working fine for over a year without any problems.

Today (April 18, 2018) a user reported that they no longer are being prompted to save the CSV file. They view the attribute table, can see all the info they want to export, click the Options dropdown, choose "Export to CSV", the window saying "Export to CSV" appears, but that's where it stops. A prompt to save the file doesn't appear. And it's not hiding behind any open windows.

Tried the web apps on multiple computers, in Chrome and IE. Also had an external user try it and they had the same problem. The app uses ArcGIS Server 10.2.2 map services. Software hasn't been updated. The data hasn't been changed recently (not edited, not updated, service hasn't been republished). Data draws fine in the web map and info shows up in the attribute table. It's just the Saving to a CSV file part that never happens.

Is anyone else experiencing this problem?

Re: Problem with Export to CSV from web map app.

RobertScheitlin__GISP — Thu, 19 Apr 2018 12:40:07 GMT

Valerie,

Are the WAB Apps hosted on AGOL (meaning they are using the AGOL version of WAB) or are they apps that you created using WAB Developer?

Re: Problem with Export to CSV from web map app.

MichaelRock1 — Tue, 24 Apr 2018 20:38:55 GMT

Hey Robert,

I am having the same issue, and for me the apps are hosted on AGOL. We suspect it might have something to do with some recent security changes by our organization regarding browser settings. Maybe.

Re: Problem with Export to CSV from web map app.

RobertScheitlin__GISP — Tue, 24 Apr 2018 21:28:19 GMT

Michael,

That is very possible. The downloading of a file from a link is something that can be block by security settings.

Re: Problem with Export to CSV from web map app.

ValerieJohnson — Mon, 30 Apr 2018 20:27:11 GMT

Esri has verified (April 30, 2018) that this is a bug (BUG-000113626) for the Query Widget in the AGOL-hosted Web App Builder. The problem started probably in late March or early April.

Until the bug is fixed, there is a work-around so users will be able to download the selected records to a CSV file. (Users can still click on View in Attribute Table and see the selected records, they just won't be able to export from there until the bug is fixed.)

HERE'S WHAT THE PERSON CREATING THE APP USING AGOL'S WEB APP BUILDER NEEDS TO DO:

1. In AGOL, edit the application.

2. Edit the settings for the Query Widget. On the "Options" tab, put a checkmark by "Allow to export results" and click the OK button.

3. Save the changes to the app.

4. This will now make four new choices appear to the user when they click the three dots (ellipsis) on the Results pane after they have selected features on the map. The four choices are:

--Export to CSV file

--Export to feature collection

--Export to GeoJSON

--Save to My Content

5. Tell users to click on Export to CSV file and save the file to their computer.

Re: Problem with Export to CSV from web map app.

ValerieJohnson — Mon, 30 Apr 2018 20:28:30 GMT

Michael - It's not your security settings. Esri has verified it's a Bug. See work-around I posted below.

Re: Problem with Export to CSV from web map app.

WalidAlmasri1 — Wed, 19 Sep 2018 17:46:23 GMT

I also have this issue using WAB 2.9 and the latest Enhanced Search Widget. You can export a layer's attributes in the attribute table only if you aren't using a custom selection. Once you use a custom selection though the Enhanced Search, you must use the ellipsis. I think this may be a problem with the custom widget? It worked with earlier WAB version and earlier Enhanced Search version.

Re: Problem with Export to CSV from web map app.

RobertScheitlin__GISP — Wed, 19 Sep 2018 18:32:40 GMT

Walid,

What do you mean by custom selection? The eSearch widget allows for exporting the search results for the eSearch menu (...) like you said. Has been that way for a while...

Re: Problem with Export to CSV from web map app.

WalidAlmasri1 — Wed, 19 Sep 2018 18:37:33 GMT

We have it set to open the attribute table when you do a custom selection (by shape for instance) in the enhanced search widget. The issue that we have is when the attribute table opens, and you click options > Export all to CSV > you are prompted about the export, and when you press OK, nothing happens...

Works fine using the ellipses though.

Re: Problem with Export to CSV from web map app.

RobertScheitlin__GISP — Wed, 19 Sep 2018 19:23:47 GMT

Walid,

OK, so that is the WAB bug that is referenced above and is not a bug to do with my widget then.

Re: Problem with Export to CSV from web map app.

WalidAlmasri1 — Wed, 19 Sep 2018 20:01:40 GMT

Robert,

Okay, thanks for the clarification. I just wanted to be sure. Hopefully this gets fixed quickly.

Walid

Re: Problem with Export to CSV from web map app.

ShitalDhakal__GISP — Fri, 02 Nov 2018 20:44:35 GMT

I am having the same problem in WAB 2.9 Developer Edition. As Walid said, the enhanced search provides me with the result that I can see in the attribute table. But then I can't export it to csv. However, the attribute table can export feature that didn't come from enhanced search.

Also, I can't find the ellipses to export into csv in the enhanced search result.

Valerie Johnson‌ Robert Scheitlin, GISP‌

Re: Problem with Export to CSV from web map app.

RobertScheitlin__GISP — Mon, 05 Nov 2018 19:28:32 GMT

Shital,

The eSearch menu button in the upper right hand corner of the results tab has the export to CSV option (assuming you have enable the export to CSV for that layer in the eSearch settings for that layer).

Re: Problem with Export to CSV from web map app.

ShitalDhakal__GISP — Mon, 05 Nov 2018 22:18:33 GMT

Thanks Robert. I am trying to enable the export to CSV but for some reason, it's not an option in the configuration dialog box:

I tried the latest version available in GNet (v 2.7), refreshed the WAB and added the esearch as a new widget and yet got the same result.

Re: Problem with Export to CSV from web map app.

RobertScheitlin__GISP — Mon, 05 Nov 2018 22:25:54 GMT

Shital,

This is what the 2.7 eSearch settings dialog is suppose to look like. Some how you are still using an old version.

Re: Problem with Export to CSV from web map app.

ShitalDhakal__GISP — Mon, 05 Nov 2018 22:43:04 GMT

Yeah, that is what I figured out by looking your help guide. Is there anything else I am supposed to do to update the widget other than deleting the older version and replacing it with the newer version in C:\arcgis-web-appbuilder-2.9\WebAppBuilderForArcGIS\client\stemapp\widgets ?

Also, where would I go to find the latest version of this awesome widget?

Greatly Appreciated,

Shital

Re: Problem with Export to CSV from web map app.

RobertScheitlin__GISP — Tue, 06 Nov 2018 14:12:55 GMT

Shital,

If you update the C:\arcgis-web-appbuilder-2.9\WebAppBuilderForArcGIS\client\stemapp\widgets then this will give you the new widget when creating a NEW app. If you want to update an existing app you have to update that specific apps widgets folder.

You get the latest widget from the widget download page: https://community.esri.com/docs/DOC-1731-enhanced-search-widget-version-211-080116

Re: Problem with Export to CSV from web map app.

ShitalDhakal__GISP — Wed, 07 Nov 2018 23:43:10 GMT

Thanks Robert. My WAB is behaving weirdly: Provides me with an updated interface to esearch as times, and old interface at others. However, I was able to configure with the new interface by refreshing the browser. Must be a cache issue.

I can now export the result into csv using the esearch's ellipses. However, 'Export to CSV' from Attribute table is still not working, must be a bug!

Thanks once again for the awesome app and your help in configuring it

Re: Problem with Export to CSV from web map app.

ClaudiaGIS — Tue, 26 Oct 2021 19:00:55 GMT

Hello, I am having a similar problem but the export works if it is launched from Web App Builder but I have the Web App embedded in a dashboard and it is not working. I can see the Export to CSV window, I click ok and nothing is happening. Anyone else having this issue in 2021?

Re: Problem with Export to CSV from web map app.

Ramon_de_Leon — Tue, 03 May 2022 14:15:12 GMT

I've also had this problem since 2021. I just checked now on my app (embedded on a dashboard also) and it is still the same issue (even if not embedded it also just get stuck on progress downloading part)... hoping it was fixed already as it is an important feature being able to export the data...