topic Re: export_assignments_to_csv.py from Workforce Enterprise missing fields in ArcGIS Workforce Questions

export_assignments_to_csv.py from Workforce Enterprise missing fields

JonathanGroves — Mon, 23 Oct 2017 10:47:59 GMT

When I export using this command:

sudo python export_assignments_to_csv.py -outCSV "/home/pi/arcgis/exported_assignments.csv" -u "[redacted]" -p "[redacted]" -url "https:[redacted]arcgis" -pid "[redacted]" -logFile "/home/pi/arcgis/log.txt"
-dateFormat "%m/%d/%Y %H:%M:%S" -timezone "US/Eastern"

... the following fields are blank in my output CSV file:

assignmentType

workOrderID

dueDate

workerId

GlobalID

There perhaps would be others but this is a test project designed to allow verification of field contents prior to importing large amounts of data as part of an AGL>Enterprise migration - and so these assignments have no progress-driven fields yet.

I am wondering if these field values are stored differently in Enterprise Workforce?

Grateful as ever for your help, guys...

PS Just noticed this GitHub Issue refers to a similar problem: https://github.com/Esri/workforce-scripts/issues/11 - is there any news on this since July please?

Re: export_assignments_to_csv.py from Workforce Enterprise missing fields

JonathanGroves — Wed, 01 Nov 2017 09:37:44 GMT

>BUMP<

Re: export_assignments_to_csv.py from Workforce Enterprise missing fields

Anonymous User — Sat, 16 Dec 2017 16:41:19 GMT

I cannot reproduce this issue. If you can still reproduce it, can you just open an issue on the github repository, and provide some more details? I'm the primary maintainer of the repo. The field names on enterprise with datastore are all lowercase, but this should be taken care of by the scripts.