topic Re: Bulk Inserting of Assignments in ArcGIS Workforce Questions

Bulk Inserting of Assignments

PeterTimmers — Fri, 22 Jul 2016 01:45:01 GMT

Do you think there will be the ability to import Assignments from a CSV or similar in a future version?

Or does it exist already? I couldn't see it anywhere.

Re: Bulk Inserting of Assignments

CraigGillgrass — Fri, 22 Jul 2016 13:41:47 GMT

Hi Peter, thanks for your question on Workforce.

Our recommendation for bulk importing assignments from a csv file or similar file is to use one of the Python scripts we've written and published in our git repo:

GitHub - Esri/workforce-scripts: A set of scripts to help administer Workforce projects.

Alternatively, since Workforce is driven by feature services, you can use any of the tools you would use in ArcGIS Pro to load data from a csv file into the Assignments feature service. We'll have a doc topic available within the week that describes how to do this or you can log in to the Beta site and review this topic

Craig

Re: Bulk Inserting of Assignments

PeterTimmers — Sun, 24 Jul 2016 22:43:30 GMT

Thanks Craig. Still lots to learn here on Workforce. Look forward to the doco.

Re: Bulk Inserting of Assignments

RaulLeos — Tue, 18 Oct 2016 15:23:06 GMT

Good day Craig, I currently working on a project that I am trying to implement workforce and I found on that there is a script to help on loading any existing assignments but what I would like to know since I have very little knowledge on python. Is there any tutorials how to run this assignment scripting for workforce.

Re: Bulk Inserting of Assignments

RaulLeos — Tue, 18 Oct 2016 19:14:03 GMT

apologies wrong person

Re: Bulk Inserting of Assignments

RaulLeos — Tue, 18 Oct 2016 19:43:52 GMT

Peter,

Need help on how to run the python script in GITHUB for workforce for ArcGIS. I have 54,000 assignments in a csv and need to upload to workforce so that I can . Please help...

Re: Bulk Inserting of Assignments

PeterTimmers — Wed, 19 Oct 2016 01:00:05 GMT

In the end I used FME to push data to the Assignments feature service on AGOL.

No code was used.

Craig did mention above that you can use ArcGIS Pro to push to the feature service.

Re: Bulk Inserting of Assignments

RaulLeos — Wed, 19 Oct 2016 06:34:25 GMT

Craig,

you mention that you can use any of the tools in ArcGIS Pro to load data from a csv file into the Assignments feature service for workforce. Please explain I am in deadline and need your help as soon as possible.

Re: Bulk Inserting of Assignments

CraigGillgrass — Wed, 19 Oct 2016 14:46:21 GMT

Raul, yes, you can use ArcGIS Pro to load data from a csv file (or other format) into any feature service. Without knowing what format the location/address is for the csv, I'll provide a rough overview:

- Create a feature class for the csv file

- Using any of the data loading tools; you could use the Append GP tool for example, load the contents of the feature class into the Assignments feature service.

- You'll need to properly field map your feature class to the Assignments feature service; here's a link to our doc which explains the Workforce schema --> Workforce schema—Workforce for ArcGIS | ArcGIS

- You'll want to focus on the section "Create an assignment through the REST API"; this explains the fields that must be populated for assignment to be created properly.

I'd suggest testing it out with a subset of your csv first to work through any issues.

If you have questions on this, feel free to post them.

Craig

Re: Bulk Inserting of Assignments

RaulLeos — Fri, 21 Oct 2016 20:30:28 GMT

Craig,

Thank you so much I was able to add the 50,000 assignments to workforce by following the steps you provided. You saved us alot of time. Have a great day!

Re: Bulk Inserting of Assignments

AngelAvila — Sat, 25 Mar 2017 21:04:05 GMT

como lo hiciste Raul, podris ser mas descriptivo que yo todavia no puedo,

hi Raul can you give more details because i cant to load this using arcgis pro

Re: Bulk Inserting of Assignments

AngelAvila — Mon, 27 Mar 2017 16:03:29 GMT

When i try to append with ArcgisPro only append one assignment and next i got the 00594 error, i try several way to fix it but i cant, somebody have any solution? whe i run the Appen GP only add the first assigment and next i got this warning append

Re: Bulk Inserting of Assignments

ChaimSchwartz4 — Tue, 16 Oct 2018 14:06:19 GMT

Another code-free workflow for batch creating assignments based on an existing feature service, would build on the "Identify features" tool (screencap below). However, since right now this feature supports only rectangular selection, the workaround would be to first filter the dispatcher's map (say, to show all assets in a specific zone), and then select them all and batch create the assignments.