Batch Create Inspections

Josh Vigness

October 23, 2017 19:33

I am looking for some direction for a workflow that I would like to do but am unsure of the necessary activities to accomplish it. I would like users to be able to select multiple features from a layer and fill out a simple inspection form that would populate a related non-spatial sde table. Any insight or direction is much appreciated.

0

• 

  Permanently deleted user

  October 24, 2017 08:04

  Hi Josh,

   

  Not sure if I’m getting this right but I start with a couple of ideas …

   

  To select multiple features you could use a “Display capture geometry” activity with selection type Multipoint or polygon. You can use a “query task” activity to query the layer and in “Geometry” field pass geometry output of the “Display capture geometry” activity. In this way “query task” would return intersecting geometry so you should now have the selected features available in you workflow.

   

  You can then use “display form” to get “inspection form” info

   

  To save information you could create a store procedure that you call from a SQL query activity or publish your non-spatial sde table in one mapservice as table.

   

  I hope this helps

   

   

  0
• 

  Josh Vigness

  October 24, 2017 13:16

  Francesca,

   

  Thanks for the ideas. I had gotten the initial portion figured out of collecting the data after I posted this, now I just need to work on getting the data into my table. I will look at your suggestions.

   

   

  0
• 

  Josh Vigness

  October 24, 2017 19:38

  I am having an issue assigning the values entered in my Display Form to populate all of the selected features. I am not sure if it is the syntax in my Assign activities or another issue(s). Here are the basics of my Workflow:

   

  1.CaptureGeometry

   

  2.QueryTask using the captured geometry to return a feature set

   

  3.Display Form to collect a name and date of inspection

   

  4.ForEach<Object> iterating over my featureset (which has the variable name hydrants) with the following Assign activities:    hydrants.features(0).attributes("name")=name

   

                     hydrants.features(0).attributes("date")=checkedOn

   

  5. Add Features to sde table using my hydrants feature set.

   

  The workflow will add related records for the selected features but only populate the attributes for the first record in the feature set.

   

  Any help is much appreciated

  0
• 

  Josh Vigness

  October 24, 2017 21:48

  I found another post which helped me solve my issue. 

   

  For Each<Object> needed to be ForEach<Graphic>

   

  Assign activities needed to be in the form of item.Attributes("name")=name

   

  As a true newbie I overlooked the indexing of my initial Assign activities above (I also had the incorrect ForEach so that didn't help).

  0

Please sign in to leave a comment.