export_assignments_to_csv.py from Workforce Enterprise missing fields

JonathanGroves

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...

JG

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?

Anonymous User

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.