topic Re: Table widget: only export fields shown in the table, not the entire dataset in ArcGIS Experience Builder Questions

Table widget: only export fields shown in the table, not the entire dataset

Hayley — Thu, 10 Feb 2022 03:40:10 GMT

Is it possible to for the table widget to only export the shown fields in the table rather than all the fields in the layer? I know this is possible for Dashboard widgets so some similar functionality would be super useful.

For example, I only have a few fields selected for this table:

However when I export the table, it gives me the entire spreadsheet with the raw data and even fields I had hidden in ArcPro.

Is there a way to configure this in ExB without having to reconfigure all my layers?

Thanks!

Re: Table widget: only export fields shown in the table, not the entire dataset

JodiWalters — Thu, 09 Jun 2022 20:34:13 GMT

Hey Haley - just wanted to let you know I was having the same problem and opened a case. It has now been determined to be a defect and filed as a bug (see number below). I had to escalate it because it is affecting productivity. ESRI did say that the developers are looking into it and it will be fixed in the next release. I asked and the analyst said that will be at the end of June.

BUG-000149879

Re: Table widget: only export fields shown in the table, not the entire dataset

Hayley — Thu, 09 Jun 2022 20:45:18 GMT

Thanks for the update!

Re: Table widget: only export fields shown in the table, not the entire dataset

EBaker — Thu, 23 Jun 2022 19:39:14 GMT

Same problem here, thanks for the info!

Re: Table widget: only export fields shown in the table, not the entire dataset

Hayley — Tue, 28 Jun 2022 21:54:34 GMT

Unfortunately this has not been introduced in the latest update 😞

Re: Table widget: only export fields shown in the table, not the entire dataset

NeohLiMay — Mon, 04 Jul 2022 02:58:21 GMT

@Hayley @EBaker @JodiWalters

Hey guys, it seems like the issue has been fixed. This is what I saw from my experience.

Re: Table widget: only export fields shown in the table, not the entire dataset

Hayley — Mon, 04 Jul 2022 03:09:01 GMT

Hi Neoh,

Thanks for the update! I just had a play around but found that hidden fields still get exported. It is a good starting point that you can export selected features now, but the real fix would be to only export the fields used in the table.

Exporting selected features:

The fields in the table (only 8):

The export (shows all other fields in the layer):

Re: Table widget: only export fields shown in the table, not the entire dataset

AaronKoelker — Mon, 26 Sep 2022 14:10:44 GMT

This issue is still present as of September 2022. We're using Experience Builder for some emergency response applications, and letting users download certain tables that have been trimmed down to only the fields from the table view would save staff a lot of time in having to trim and format them afterward to meet their needs.

Re: Table widget: only export fields shown in the table, not the entire dataset

Hayley — Mon, 26 Sep 2022 19:37:43 GMT

Yes frustrating.....any updates on this Esri?

We are having to create a large amount of layer views just for this table export functionality

Re: Table widget: only export fields shown in the table, not the entire dataset

Jianxia — Wed, 19 Oct 2022 23:14:46 GMT

The exporting capability in Table will honor the display fields configured in the sheet in the upcoming November release. Thank you for your patience.

Re: Table widget: only export fields shown in the table, not the entire dataset

Hayley — Mon, 14 Nov 2022 20:53:46 GMT

Hi @Jianxia, I have tried exporting from the tables however the issue with all fields appearing in the export still persist. Am I missing something here?

Re: Table widget: only export fields shown in the table, not the entire dataset

Jianxia — Mon, 14 Nov 2022 21:28:04 GMT

Currently, there is a limitation. When the feature service supports Create Replica operation as shown below, all fields from the layer will be exported regardless the setting in Table.

Re: Table widget: only export fields shown in the table, not the entire dataset

Hayley — Mon, 14 Nov 2022 21:36:13 GMT

Hi @Jianxia, how can we disable this?

Re: Table widget: only export fields shown in the table, not the entire dataset

Jianxia — Tue, 15 Nov 2022 22:49:28 GMT

Hi @Hayley , it turns out when you export all records from a table with hosted feature layers, all fields from the layer will be exported regardless the setting in Table. This is a known limitation. Currently, there are no workarounds. For ArcGIS Server services, make sure to turn off Create Replica when publishing the services. If you choose to export selected records, the fields configured in the table will be honored.

We will document the limitation.

Re: Table widget: only export fields shown in the table, not the entire dataset

Hayley — Wed, 16 Nov 2022 01:14:02 GMT

Hi @Jianxia, do you know if future updates will fix this? Unfortunately republishing our layers in order to turn off Create Replica is not an option. We will have to stick to creating layer views for now

Re: Table widget: only export fields shown in the table, not the entire dataset

Jianxia — Wed, 16 Nov 2022 01:27:27 GMT

Thanks, Hayley. Using Layer View to select fields is the option we can think of right now. Sorry for that. We are working with the team that supports exporting capabilities in the backend though no time line yet.

Re: Table widget: only export fields shown in the table, not the entire dataset

BrantCarman — Wed, 28 Dec 2022 21:42:16 GMT

I just stumbled upon this bug as well, and looking for a work around. You guys mentioned using a Layer View, but I don't see how that fixes the issue. Could you elaborate?

I attempted to create a layer view and added that as a sheet in my table, but exporting all still includes all fields from the hosted feature layer.

Thanks for your help!

Re: Table widget: only export fields shown in the table, not the entire dataset

Jianxia — Tue, 03 Jan 2023 19:05:58 GMT

@BrantCarman , by default, if you are the owner of the layer view, you will see all the fields from the layer when exporting. As a test, could you please log in as a different user and see if that works?

Re: Table widget: only export fields shown in the table, not the entire dataset

DavidRasner1 — Tue, 17 Jan 2023 17:52:13 GMT

The layer view workaround works. Owners will export all attributes (for some reason), everyone else will get only what you see in the table.

The problem is that it also exports auto generated geometry attributes like coordinates for points, or area and length for polygons, which created some confusion for our users.

So currently i gave up on this and made a small microservice that exports clean spreadsheets with a button. Hope you can improve on this in the future. 🙏

Re: Table widget: only export fields shown in the table, not the entire dataset

KrisKarki — Fri, 10 Mar 2023 23:21:16 GMT

Hi Jianxia, I like to prohibit exporting, I could not see any where to set up this in data view. Any help appreciated.