topic Re: Geoprocessing service that uses Field Calculator in Developers Questions

Geoprocessing service that uses Field Calculator

StephenSchmidt2 — Wed, 14 Sep 2016 16:59:31 GMT

Hello!! I'm looking to create a Geoprocessing Service that uses the field calculator tool to concatenate fields. The original feature service is the output.

Re: Geoprocessing service that uses Field Calculator

XanderBakker — Wed, 14 Sep 2016 17:14:33 GMT

So you intent with this GP service to update the schema of the service, adding a new field? Why do you want to do this with a GP service (and how often are you planning to run the GP service, just a single time)?

Re: Geoprocessing service that uses Field Calculator

StephenSchmidt2 — Wed, 14 Sep 2016 17:33:54 GMT

Xander! Thanks for the reply! The Feature Service actually already has the field that I'd like to populate with the concatenation of three other fields. What we're doing is building a URL in that field from a point ID (one field), and two auto populated URL pieces (fields two and three). The final product is a functional URL. The point ID is specified by a user with the editor widget when they add a location to the map. When the new location is created, the two parts to the URL are auto populated in their fields. The next final step would be to run the geoprocessing widget to populate the final field with the combined three pieces. When I run the model that I'm publishing as a Geoprocessing Service locally, it works great at generating the correct URL. What's confusing me is that in the Geoprocessing Widget, the input and the output are the same feature service. When I publish the model as a GP, it runs in the Geoprocessing Widget, but does not concatenate. Below is a screen grab of the field calculator. Thanks!!!

Re: Geoprocessing service that uses Field Calculator

XanderBakker — Wed, 14 Sep 2016 19:13:57 GMT

I see you have ArcGIS Server installed on your local machine. You could also consider using a scheduled task with a python script that will update the field at a predefined moment. If the FieldCalculator does not work for using a different input and output variable, you could consider writing a simple script that will update the field. I would prefer using the UpdateCursor—Help | ArcGIS for Desktop over using the FieldCalculator. Important to configure your service in such a way that it does not lock the schema (see Disabling schema locking on a map service—Documentation (10.4) | ArcGIS for Server )

Re: Geoprocessing service that uses Field Calculator

StephenSchmidt2 — Fri, 16 Sep 2016 14:46:34 GMT

Hi Xander! The scheduled task with a python script is working like I hoped! Thank you for the suggestion!

Re: Geoprocessing service that uses Field Calculator

XanderBakker — Fri, 16 Sep 2016 15:03:28 GMT

Great to hear that. Congratulations!