topic Re: Export CSV file within ArcGIS Dashboard based on HFS View Layer in ArcGIS Dashboards Questions

Export CSV file within ArcGIS Dashboard based on HFS View Layer

MichaelBruening — Thu, 20 Jan 2022 21:35:42 GMT

Hello, I have constructed an ArcGIS Dashboard that utilizes the "table" module within the dashboard. I want to allow my users to "export" the table directly into a csv file. Within the ArcGIS Dashboard Online help; there is mention of being able to perform this.

However, it is a little confusing/contradictory when looking at the online help though. Within the "download source data" section of this resource - https://doc.arcgis.com/en/dashboards/create-and-share/download-data.htm, there are the following statements made:

"Tip: You can limit fields that are downloaded by using a feature layer view."

However, in the very next paragraph we have this stated: "When downloaded, the data includes "all" fields in the layer or view, including any fields that are not visualized."

So the export function will export "all fields" regardless if you have a "feature layer view" being utilized within the module.

There are other means of achieving the export, but this would be a great feature if it worked. Could this be a bug that has not been reported?

Re: Export CSV file within ArcGIS Dashboard based on HFS View Layer

DebHSF — Fri, 21 Jan 2022 15:08:16 GMT

That second sentence means the same as the first. "All fields in the view" means all fields you have chosen to be in the view layer will be included in the download. Fields (and any features) that you have hidden in the view layer will not be downloaded.

Re: Export CSV file within ArcGIS Dashboard based on HFS View Layer

MichaelBruening — Fri, 21 Jan 2022 15:23:56 GMT

I understand what the help support states. However, I am having the opposite occur within my setup while using the feature layer view. Meaning, "ALL" data fields are being exported, instead of just the data fields specified within my "view".

Re: Export CSV file within ArcGIS Dashboard based on HFS View Layer

DebHSF — Fri, 21 Jan 2022 15:31:06 GMT

Ah ok. My data is working the way the documentation describes - I've created a View Layer that only includes some of the fields and am using that in my dashboard. When I export the table, it just includes those fields.

Re: Export CSV file within ArcGIS Dashboard based on HFS View Layer

MichaelBruening — Fri, 21 Jan 2022 15:36:47 GMT

I guess I have found a bug? I am going to start over from scratch to see if there is just something not working correctly. Just seems odd to me. Thank you for confirming this does indeed work. I appreciate your responses and i will post back with my results.

Re: Export CSV file within ArcGIS Dashboard based on HFS View Layer

MichaelBruening — Fri, 21 Jan 2022 15:58:18 GMT

Yup, doesn't matter what I do, I still have the data being exported from the table module with "all" data fields being included. I am going to start a support ticket as I think this could be an undiscovered bug.

Re: Export CSV file within ArcGIS Dashboard based on HFS View Layer

DavidNyenhuis1 — Sat, 22 Jan 2022 00:39:43 GMT

Hi @MichaelBruening,

Thanks for the details. The issue is that the owner (or admin) of the data has special privileges that (at present) allow them to download all the fields, despite what the view defines as accessible/available fields. We suggest you only use the data download capability in dashboards when signed in with a different (non-owner, non-admin) account. This will ensure you get only the fields you expect.

We are working to update this behavior for the next release (planned for March).

We will also work to clarify this part of the documentation. When it said, "... including any fields that are not visualized." it is referring to the visualization (e.g., a list, chart, or table). So, although a list might not display/visualize every field, all of them (within the limits of the view layer) will be downloaded.

Thanks,
- Dave

Re: Export CSV file within ArcGIS Dashboard based on HFS View Layer

MichaelBruening — Mon, 24 Jan 2022 13:00:00 GMT

Hello @DavidNyenhuis1,

Thank you for the explanation behind the behavior of this process and what is occurring. I am an Admin within our Organization and this explains why I continue to see all of the data being exported. It would be helpful if we could have these types of exceptions be explained for all tools/processes within the online support. I spent quite a bit of time attempting to recreate the views, dashboards, and find other means of achieving the exported csv file. However, lesson learned and I will have to employ someone with a lower license level to test out my creations.

Thank you,

Mike

Re: Export CSV file within ArcGIS Dashboard based on HFS View Layer

MichaelBruening — Mon, 24 Jan 2022 14:59:54 GMT

It also appears as though this method only works with the newest map viewer and no longer with the Map Viewer Classic. This is good to know also, because it will require some updating of our older maps and hosted layer views. Thank you again for the information.

Re: Export CSV file within ArcGIS Dashboard based on HFS View Layer

AdminNCCMA — Thu, 17 Feb 2022 02:00:46 GMT

Hi @DavidNyenhuis1

Are there plans to make the "Download data" in ArcGIS Online - ArcGIS Dashboards compatible with Feature Services coming from ArcGIS Enterprise (Portal/Server)? (not just Hosted Feature Layers as current Download data—ArcGIS Dashboards | Documentation)

Thanks

Pat

Re: Export CSV file within ArcGIS Dashboard based on HFS View Layer

AaronKoelker — Tue, 01 Nov 2022 20:39:07 GMT

Would really like this functionality as well. Quite unfortunate for organizations utilizing both Enterprise Portal and ArcGIS Online together.

Re: Export CSV file within ArcGIS Dashboard based on HFS View Layer

Blevins_Mark — Mon, 02 Dec 2024 18:32:38 GMT

we are having this issue in our hub site application, even when not signed in to the organization, as an anonymous public user...the csv download ignores the view query and includes all fields, but is gives a value of zero for the fields that have been hidden...so it passes the hidden fields, but not the values.