Workforce - Import Assignments from a CSV - Script geometry help

DaveSarver1 — Tue, 18 Aug 2020 20:47:44 GMT

I'm a novice at best with Python scripting but it's on the top of the list of things for me to figure out so our organization can more fully utilize Workforce. I've had success running the title script in the Python Command Prompt written like this:

python create_assignments_from_csv.py -csv-file "N:\RDA_exported_assignments.csv" -u <username> -p <password> -org "https://<our org>.maps.arcgis.com" -project-id "<xxxxxxxxxxxxxxxxxxxxxxxxxxxx>" -x-field "xField" -y-field "yField" -assignment-type-field "AssignmentType" -location-field "Location" -description-field "Description" -priority-field "Priority" -wkid 102100 -log-file "N:\Rapid Damage Assessment\log.txt" -timezone "US/Pacific"

Again, this worked. However I can't seem to get the same script to work in a Jupyter notebook. The sample notebook geocodes an address to an x,y location which I already have. My assignments csv does not have addresses, only x,y location in separate columns (exported from the Assignments Point Layer - see sample below) as the points are along river levees and don't necessarily have addresses, and i used the location field in Workforce for the name of the levee that is to be inspected. How do I get the script to recognize my x,y data? I've tried converting the x,y data into a single column titled SHAPE with formatting like this: {"x": -122.366238, "y": 47.22577965}. This seemed to work but as the script created the assignments, there was no symbology for the new assignments - similar to the discussion here: Workforce 'create assignments from csv' script - no assignments symbolized on map

I'm really hoping to use notebooks rather than Command Prompt scripts so I can document processes and share more easily.

I'm pretty sure I need to change at least the geometry line(s)?

workforce-scripts/2 - Importing Assignments.ipynb at master · Esri/workforce-scripts · GitHub

Below is a sample of the csv that works with the Command Prompt script. I know I can delete a lot of these fields, and please let me know if I should.

OBJECTID

xField

yField

Description

Status

Notes

Priority

AssignmentType

WorkOrderId

DueDate

WorkerId

GlobalID

Location

DeclinedComment

AssignedDate

AssignmentRead

InProgressDate

CompletedDate

DeclinedDate

PausedDate

DispatcherId

CreationDate

Creator

EditDate

Editor

-13621747.3

5979005.241

Puyallup Left: MP3.0 - 6.8

unassigned

high

Levee Assessment - Drive

Zone 1

e99c5014-0d2a-4a8b-9dab-278c052f703d

River Road Levee

23CE0246-08E7-4E60-B6AC-49D9DFCF7F29

7/21/2020 11:40

dsarver

7/21/2020 12:21

dsarver

I hope what I wrote makes sense, and thanks for reading this

Re: Workforce - Import Assignments from a CSV - Script geometry help

Anonymous User — Wed, 19 Aug 2020 14:13:16 GMT

You'll want to change how the geometry is created. In the script this is created from the X,Y, and spatial reference. You can see it here: workforce-scripts/create_assignments_from_csv.py at master · Esri/workforce-scripts · GitHub

This is un-tested but I think you want to do something like:

geometry = {
    "x": row["x"],
    "y": row["y],
    "spatialReference": {
        "wkid": 102100
    }
}

Re: Workforce - Import Assignments from a CSV - Script geometry help

DaveSarver1 — Wed, 19 Aug 2020 15:40:11 GMT

That worked! Thank you Aaron!!!

Re: Workforce - Import Assignments from a CSV - Script geometry help

ChristianChacon — Tue, 22 Jun 2021 01:19:22 GMT

How did you solve it, Can you copy your code?, I have tried and I do not solve it. Please

topic Re: Workforce - Import Assignments from a CSV - Script geometry help in ArcGIS Workforce Questions

Workforce - Import Assignments from a CSV - Script geometry help

Re: Workforce - Import Assignments from a CSV - Script geometry help

Re: Workforce - Import Assignments from a CSV - Script geometry help

Re: Workforce - Import Assignments from a CSV - Script geometry help