Select to view content in your preferred language

Can you use CSV to fill print widget (for custom report) in Experience Builder?

187
1
Jump to solution
12-23-2024 12:59 PM
Labels (2)
kronezone
Emerging Contributor

Hello,

I have a couple-part question. The goal is to use Near Me to identify intersecting features from multiple layers with a project area and buffer to generate a report using a custom print service (similar to the process described here: https://www.esri.com/arcgis-blog/products/experience-builder/sustainable-development/recreating-the-... )

Using an ExB app, I want the user to add data via the Add Data widget, then run Near Me analysis and generate a report using a custom print/report service. I am using the newest version of Enterprise to publish the report template and am using ArcGIS Online for the ExB app.

However, what differentiates my process from Aziza's tutorial is that a subset of my webmap's data layers require additional processing of the results—specifically grouping, summarizing, and pivoting--before being included/added in the report. Initially I was exploring the possibility of using a custom geoprocessing service in the Analysis widget to handle this for this subset of data, but it appears that the resulting outputs from the Near Me analysis cannot directly provide the input data required for a custom script in the Analysis widget (at this time).

My next idea is to have users add data, run the Near Me analysis and then export the data as a csv (which outputs as a zipped folder with a separate CSV for each data layer that intersects with the data layer added), and then potentially use the analysis widget (using a custom GP service) to automate the data processing I mentioned above (but would only target the specific layers where this is needed), and then save the updated CSV. Then, I was thinking of having the user add the updated CSV to the print widget to have it print in the style of the custom report template I have created.

Is what I have proposed above possible? Can you upload a CSV to feed the report widget? Are there any other ideas that any of you would recommend? Thank you so much for your time and consideration.

0 Kudos
1 Solution

Accepted Solutions
ShengdiZhang
Esri Regular Contributor

Hi @kronezone ,

Unfortunately, we do not support selecting runtime-added data for reports.

This is because a report (with configured fields) is used only for a specific layer, and usually users do not understand the relationship between data source and reports. If no data is selected for the report, printing will fail; if the wrong data is selected, the report will be empty or filled with field names.

Therefore, it is by design that app authors are responsible for selecting the correct data for reports. 

Regards,

Shengdi

View solution in original post

1 Reply
ShengdiZhang
Esri Regular Contributor

Hi @kronezone ,

Unfortunately, we do not support selecting runtime-added data for reports.

This is because a report (with configured fields) is used only for a specific layer, and usually users do not understand the relationship between data source and reports. If no data is selected for the report, printing will fail; if the wrong data is selected, the report will be empty or filled with field names.

Therefore, it is by design that app authors are responsible for selecting the correct data for reports. 

Regards,

Shengdi