Bulk Inserting of Assignments

[PeterTimmers]

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.

[CraigGillgrass · Accepted solution]

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

[RaulLeos]

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.

[CraigGillgrass]

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

[RaulLeos]

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!

[AngelAvila]

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

[PeterTimmers]

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

[RaulLeos]

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.

[RaulLeos]

apologies wrong person

[RaulLeos]

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