nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Workforce API - Missing Data...

JonathanGroves

This morning, assignments returned by the export_assignments_to_csv.py script (part of the standalone scripts collection) are missing newer assignments - I can see none since 1st August. When I review the Dispatcher interface I can still see the newer assignments.

It seems there is some sort of problem with the API.

How best to address this please?

Najděte více příspěvků označených jako

Accepted answers

All comments

JonathanGroves

Thanks, Craig.

Craig Gillgrass

Jonathan,

The limits on the size of the Notes field (and all other fields for the Workforce schema) are available in this FAQ:

Workforce schema—Workforce for ArcGIS | ArcGIS

I've added your Notes suggestion to our backlog.

Craig

JonathanGroves

Hi.

Failed to make head nor tail of the REST endpoint so am unable to verify if the data all appear in there.

Please advise what the constraints are for Notes fields - in terms of maximum length, characters used etc - for use with the standalone scripts. I have previously seen an odd character (an I with acute accent) crash the download to csv script, and I'm starting to think my current problem might be due to Notes field length after all.

A Notes-related suggestion:

As a Project Owner, I want to have a filter allowing Dispatchers to view all Assignments which have a Notes field containing data, so that they can easily see any exceptions reported by site personnel.

Kind regards,

Jonathan

JonathanGroves

Hi Craig, thanks for your response.

Please could you point me to the information I need to access the REST endpoint to do this?

"More recent" means "assignments which have been updated (as in, status changed, notes added etc) since about 1st August". It's hard to be more precise - I'm interested in extracting Assignments which have Notes fields populated and (sadly) the date a Note was left is not provided by the script. I have a Python script which filters out items from the AssignmentsDownload.csv which have Notes fields populated - it builds a new CSV of these and sends them to a bunch of interested parties. These "more recent" Assignments are missing from the AssignmentsDownload.csv (which is the output of your standalone script). Bizarrely, some of these missing Assignments have previously been extracted successfully. Something changed around the 8th of August, but it wasn't my end...

I've got used to dealing with script runtime errors caused by strange characters entered in Notes by site staff - and my follow-on script now correctly handles commas in the Notes (which, of course, upset csv formatting!) - but this is definitely something different. Happy to email a sample AssignmentsDownload.csv which is missing the data if it's of help, but can't see that it would be...

Very grateful for your help on this.

Craig Gillgrass

Jonathan,

At this point, I can suggest a couple ways to track this down, but a solution may take some time; have you tried confirming the queries you are using return the correct features through the REST endpoint?

When you say "the more recent assignments are missing" what does more recent mean? Is this the creation date of the assignments?

JonathanGroves

Hi, Craig.

Thanks so much for responding!

Yes - every day. I really can't see what has changed my end...

#First we delete the old temporary output file:
sudo cp -f /home/pi/arcgis/AssignmentsDownload.blank /home/pi/arcgis/AssignmentsDownload.csv;

# Build up string:
q="sudo python /home/pi/arcgis/export_assignments_to_csv.py "
# add output file:
q+="-outCSV \"/home/pi/arcgis/AssignmentsDownload.csv\" "
# add username:
q+="-u \"redacted\" "
# password:
q+="-p \"redacted\" "
# url:
q+="-url \"redacted\" "
# PID:
q+="-pid \"redacted\" "
# Logfile:
q+="-logFile \"./reporter_log.txt\" "
# Date format:
q+="-dateFormat \"%d/%m/%Y %H:%M:%S\" "
# Timezone:
q+="-timezone \"US/Eastern\" "

# Execute string (calls Python script):
echo $q;

This has been working fine for weeks and weeks - it's run by a cron job every morning - but last week the more recent Assignments are missing from the CSV. This is part of a more complex system but the data is definitely missing from the source CSV file.

Any help gratefully received.

Kind regards,

Jonathan

Craig Gillgrass

Jonathan, are you still running into this issue?

If so, can you post the command line arguments you're using?

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.