topic Re: Make XY Event Layer available in WebApp Builder in Geoprocessing Questions

Make XY Event Layer available in WebApp Builder

OmolaraKareem — Fri, 25 Aug 2017 13:00:29 GMT

I am trying to provide my users with a tool that will let them upload .xls and/or .csv files containing xy coordinate data from their systems (desktop, network drive, thumb drive, etc), perform a process and map the result as a point layer. Please view the attached pdf which illustrates what I have tried and failed at (i.e. creating a geoprocessing tool and publishing as a service). I am definitely doing something wrong. Can someone please point me in the right direction.

Note: This tool will be incorporated into Portal for ArcGIS WebApp Builder. I am aware that coordinates can be mapped in Portal for ArcGIS, however it only accepts lat/long. We work with UTM and I will not want to pass the headache of always converting to lat/long before mapping to my users or take on the burden myself.

I look forward to any help.

Lara

Re: Make XY Event Layer available in WebApp Builder

JakeSkinner — Fri, 25 Aug 2017 16:29:51 GMT

Hi Omolara,

If you are working with CSV files, take a look at the Add Data widget:

Add Data widget—Web AppBuilder for ArcGIS | ArcGIS

Re: Make XY Event Layer available in WebApp Builder

OmolaraKareem — Fri, 25 Aug 2017 17:04:33 GMT

Thanks for your reply Jake. I have looked into the Add Data Widget. It has the limitation of accepting only lat/long. I need something that will accept UTM.

Sent from my Samsung Galaxy smartphone.

Re: Make XY Event Layer available in WebApp Builder

JakeSkinner — Fri, 25 Aug 2017 17:41:24 GMT

Here is a modelI was able to get to work with a CSV file. I simply added the Make XY Event Layer tool to model builder and set parameters for input, X & Y fields, and output. I set the spatial reference to the coordinate system of my choice.

I then published this to ArcGIS Server as a Geoprocessing service. I made sure to check 'Uploads' for the Capabilities so that the end user can upload a CSV file:

I could then successfully configure and execute this in Portal:

Re: Make XY Event Layer available in WebApp Builder

OmolaraKareem — Mon, 28 Aug 2017 11:29:54 GMT

I did it!!!

Thanks so much Jake. Much appreciated.

I have another problem now. Everything worked as it should but in a list of 23 xy coordinates, only the first one was plotted. Can you tell where I missed it? I've checked over and over, don't know what I've done wrong.

Save

Re: Make XY Event Layer available in WebApp Builder

JakeSkinner — Mon, 28 Aug 2017 11:47:35 GMT

Can you upload the CSV file you are using to GeoNET for me to take a look?

Re: Make XY Event Layer available in WebApp Builder

OmolaraKareem — Mon, 28 Aug 2017 11:55:00 GMT

Ok.

Re: Make XY Event Layer available in WebApp Builder

JakeSkinner — Tue, 29 Aug 2017 11:38:29 GMT

LAMATAEnterpriseGIS‌ what coordinate system are you using?

Re: Make XY Event Layer available in WebApp Builder

OmolaraKareem — Tue, 29 Aug 2017 12:10:18 GMT

Projected Coordinate System: WGS_1984_UTM_Zone_31N

Re: Make XY Event Layer available in WebApp Builder

JakeSkinner — Tue, 05 Sep 2017 12:07:29 GMT

Omolara, I would recommend logging a case with support. I tried plotting this CSV file you sent and it displays all the points in correctly within the Web AppBuilder Application (Portal 10.5.1):

What's strange is that the GP tool is working correctly in ArcGIS Desktop 10.5.1.

Re: Make XY Event Layer available in WebApp Builder

AlecMarshall1 — Wed, 06 Sep 2017 19:11:00 GMT

Jake, I've created a model that mimics yours as well as publishing it as a service with "Uploads" enabled. However, when I go to use the service in a WAB application the Upload button does not appear, any thoughts? Is this feature allowed via AGOL-hosted Web Apps or is it limited to Portal?

Thanks, this thread has been extremely helpful!

Re: Make XY Event Layer available in WebApp Builder

JakeSkinner — Wed, 06 Sep 2017 19:17:05 GMT

Hi Alec,

When you were configuring the widget did you specify the 'Upload file' option for the input?

Re: Make XY Event Layer available in WebApp Builder

AlecMarshall1 — Wed, 06 Sep 2017 19:39:34 GMT

Oddly enough the "Upload file" option does not appear for me. Perhaps an issue with my model? I notice that my "Type" field under the Input is listed as "GPRecordSet" while yours is "GPDataFile".

Re: Make XY Event Layer available in WebApp Builder

JakeSkinner — Wed, 06 Sep 2017 19:42:25 GMT

Can you send a screen shot of your model?

Re: Make XY Event Layer available in WebApp Builder

AlecMarshall1 — Wed, 06 Sep 2017 19:48:35 GMT

Additionally, the data type for my XY Table parameter is set as "Table" \

Re: Make XY Event Layer available in WebApp Builder

JakeSkinner — Wed, 06 Sep 2017 20:02:26 GMT

I would try starting over by re-running your model, and then re-publishing the GP service. It's strange that it's stating a GPRecordSet rather than a GPDataTable.