Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Cancel
- Home
- :
- All Communities
- :
- Products
- :
- ArcGIS Workforce
- :
- ArcGIS Workforce Questions
- :
- I can make more of 100 assignaments on web envirom...
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
I can make more of 100 assignaments on web enviroment
Subscribe
826
2
08-17-2021 03:48 PM
08-17-2021
03:48 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I can make more of 100 assignaments on web enviroment
I can make more of 100 assignaments using python scripts for workforce
2 Replies
10-07-2021
08:21 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Jhon. If it is possible to load more than 100 assignments into a Workforce project. One way is to implement Toolbox with Scripts made with the Python API and upload an Excel file with multiple assignments. I have loaded more than 3,000 assignments using a Toolbox in ArcGIS Pro. Attachment sent the Python Sample Scripts.
Example 1:
import shapefile
import types
import pandas as ipandas
import arcpy
import traceback
import arcgis
from arcgis.gis import GIS
from arcgis.apps import workforce
from arcgis.geometry import Point
def loadData (portalConnection, username, project, itemtype, file):
# overwriteOutput
arcpy.env.overwriteOutput = True
# List of assignments to add
records = []
# Read the asssigned from file and loop through the assignned information contained within this file
arcpy.AddMessage("Parsing ...")
arcpy.AddMessage(itemtype)
arcpy.AddMessage(file)
arcpy.AddMessage("Adding ...")
if itemtype == 'Excel File': # get item itemtype: 'Excel File' ...
item = ipandas.read_excel(file)
for index, row in item.iterrows():
# Create assignment in state 0-Unassigned
record = workforce.Assignment(project
,feature=None
,geometry=Point({"x" : row["POINT_X"],"y" : row["POINT_Y"],"spatialReference" : {"wkid" : row["Wkid"]}}) # Create assignment XY
,assignment_type=row["Tipo_asignacion"]
,status=0
,location=row["Direccion"])
# Update assignment attribute
record.assigned_date=ipandas.to_datetime(row["Fecha_asignacion"])
record.due_date=ipandas.to_datetime(row["Fecha_vencimiento"])
record.status=int(row["Estado"]) # state 1-Assigned
record.dispatcher=project.dispatchers.get(user_id=row["Despachador_id"]) # get dispatcher from user_id
record.worker=project.workers.get(user_id=row["Trabajadorcampo_id"]) # get worker from user_id
record.work_order_id=row["Identificador"]
record.description=row["Descripcion"]
record.priority=int(row["Prioridad"])
record.notes=row["Notas"]
# Set attachment
record.attachment_file=types.SimpleNamespace()
record.attachment_file=row["Anexo"]
# Add all assignments to the list created
records.append(record)
# Batch add assignments
batchAdd = project.assignments.batch_add(records)
arcpy.AddMessage(batchAdd)
arcpy.AddMessage("Adding Attachments...")
for assignment in batchAdd:
try:
if hasattr(assignment, "attachment_file"):
assignment.attachments.add(assignment.attachment_file)
except Exception as e:
continue
arcpy.AddMessage("Completed")
else:
arcpy.AddMessage('ERROR getting item from ... '+item)
arcpy.AddMessage("Load data "+itemtype+" completed")
return batchAdd
10-07-2021
08:23 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
| OBJECTID | Area_Terreno | Avaluo_Terreno | Dimension | Etiqueta | Relacion_Superficie | Identificador | Observaciones | Manzana_Vereda_Codigo | VR_NPN_NUMERO | POINT_X | POINT_Y | POINT_Z | Tipo_asignacion | Estado | Notas | Fecha_asignacion | Fecha_vencimiento | Despachador_id | Trabajadorcampo_id | Prioridad | Direccion | Descripcion | Wkid | Anexo |
| 88 | 4 | 4289647 | Dim2D | 0341001011003500001 | 0035 | 050340100001100350001901000001 | -75.87848091 | 5.659334119 | 0 | Visita_Inicial | 1 | Identificador: 0341001011003500001 - VR_NPN_NUMERO: 050340100001100350001901000001 - Area_Terreno: 4 - Avaluo_Terreno: 4289647- Dimension: Dim2D | 6/10/2021 | 20/09/2021 | rcartagena_gn | javendano_gn | 0 | Manzana_Vereda_Codigo:0035 - POINT_X=-75.878480912 - POINT_Y=5.65933411900005 - Wkid=4686 | Tipo_asignacion: Visita_Inicial - Estado: 1 - Despachador_id: rcartagena_gn - Fecha_asignacion: - 44475 - Fecha_vencimiento: 44459 - - Prioridad: 0 | 4686 | D:\Myprofile\Projects\Sectores\National_Government\ANT\PoC_Workforce_2021\Image_File\Anexo_1.jfif | |||
| 89 | 4 | 4289647 | Dim2D | 0341001011003500001 | 0035 | 050340100001100350001901000001 | -75.87848091 | 5.659334119 | 0 | Visita_Inicial | 1 | Identificador: 0341001011003500001 - VR_NPN_NUMERO: 050340100001100350001901000001 - Area_Terreno: 4 - Avaluo_Terreno: 4289647- Dimension: Dim2D | 6/10/2021 | 21/09/2021 | rcartagena_gn | javendano_gn | 0 | Manzana_Vereda_Codigo:0035 - POINT_X=-75.878480912 - POINT_Y=5.65933411900005 - Wkid=4686 | Tipo_asignacion: Visita_Inicial - Estado: 1 - Despachador_id: rcartagena_gn - Fecha_asignacion: - 44475 - Fecha_vencimiento: 44460 - - Prioridad: 0 | 4686 | D:\Myprofile\Projects\Sectores\National_Government\ANT\PoC_Workforce_2021\Image_File\Anexo_2.pdf | |||
| 90 | 4 | 4289647 | Dim2D | 0341001011003500001 | 0035 | 050340100001100350001901000001 | -75.87848091 | 5.659334119 | 0 | Visita_Inicial | 1 | Identificador: 0341001011003500001 - VR_NPN_NUMERO: 050340100001100350001901000001 - Area_Terreno: 4 - Avaluo_Terreno: 4289647- Dimension: Dim2D | 6/10/2021 | 22/09/2021 | rcartagena_gn | javendano_gn | 0 | Manzana_Vereda_Codigo:0035 - POINT_X=-75.878480912 - POINT_Y=5.65933411900005 - Wkid=4686 | Tipo_asignacion: Visita_Inicial - Estado: 1 - Despachador_id: rcartagena_gn - Fecha_asignacion: - 44475 - Fecha_vencimiento: 44461 - - Prioridad: 0 | 4686 | D:\Myprofile\Projects\Sectores\National_Government\ANT\PoC_Workforce_2021\Image_File\Anexo_3.jfif | |||
| 91 | 4 | 4289647 | Dim2D | 0341001011003500001 | 0035 | 050340100001100350001901000001 | -75.87848091 | 5.659334119 | 0 | Visita_Inicial | 1 | Identificador: 0341001011003500001 - VR_NPN_NUMERO: 050340100001100350001901000001 - Area_Terreno: 4 - Avaluo_Terreno: 4289647- Dimension: Dim2D | 6/10/2021 | 23/09/2021 | rcartagena_gn | javendano_gn | 0 | Manzana_Vereda_Codigo:0035 - POINT_X=-75.878480912 - POINT_Y=5.65933411900005 - Wkid=4686 | Tipo_asignacion: Visita_Inicial - Estado: 1 - Despachador_id: rcartagena_gn - Fecha_asignacion: - 44475 - Fecha_vencimiento: 44462 - - Prioridad: 0 | 4686 | D:\Myprofile\Projects\Sectores\National_Government\ANT\PoC_Workforce_2021\Image_File\Anexo_4.jpg | |||
| 92 | 4 | 4289647 | Dim2D | 0341001011003500001 | 0035 | 050340100001100350001901000001 | -75.87848091 | 5.659334119 | 0 | Visita_Inicial | 1 | Identificador: 0341001011003500001 - VR_NPN_NUMERO: 050340100001100350001901000001 - Area_Terreno: 4 - Avaluo_Terreno: 4289647- Dimension: Dim2D | 6/10/2021 | 24/09/2021 | rcartagena_gn | javendano_gn | 0 | Manzana_Vereda_Codigo:0035 - POINT_X=-75.878480912 - POINT_Y=5.65933411900005 - Wkid=4686 | Tipo_asignacion: Visita_Inicial - Estado: 1 - Despachador_id: rcartagena_gn - Fecha_asignacion: - 44475 - Fecha_vencimiento: 44463 - - Prioridad: 0 | 4686 | D:\Myprofile\Projects\Sectores\National_Government\ANT\PoC_Workforce_2021\Image_File\Anexo_5.jfif | |||
| 93 | 4 | 4289647 | Dim2D | 0341001011003500001 | 0035 | 050340100001100350001901000001 | -75.87848091 | 5.659334119 | 0 | Visita_Inicial | 1 | Identificador: 0341001011003500001 - VR_NPN_NUMERO: 050340100001100350001901000001 - Area_Terreno: 4 - Avaluo_Terreno: 4289647- Dimension: Dim2D | 6/10/2021 | 25/09/2021 | rcartagena_gn | javendano_gn | 0 | Manzana_Vereda_Codigo:0035 - POINT_X=-75.878480912 - POINT_Y=5.65933411900005 - Wkid=4686 | Tipo_asignacion: Visita_Inicial - Estado: 1 - Despachador_id: rcartagena_gn - Fecha_asignacion: - 44475 - Fecha_vencimiento: 44464 - - Prioridad: 0 | 4686 | D:\Myprofile\Projects\Sectores\National_Government\ANT\PoC_Workforce_2021\Image_File\Anexo_6.jpg | |||
| 124 | 98 | 10615794 | Dim2D | 0341001011003500002 | 0035 | 050340100001100350002000000000 | -75.87861373 | 5.659203383 | 0 | Visita_Inicial | 1 | Identificador: 0341001011003500002 - VR_NPN_NUMERO: 050340100001100350002000000000 - Area_Terreno: 98 - Avaluo_Terreno: 10615794- Dimension: Dim2D | 6/10/2021 | 26/09/2021 | rcartagena_gn | javendano_gn | 0 | Manzana_Vereda_Codigo:0035 - POINT_X=-75.87861373 - POINT_Y=5.65920338300003 - Wkid=4686 | Tipo_asignacion: Visita_Inicial - Estado: 1 - Despachador_id: rcartagena_gn - Fecha_asignacion: - 44475 - Fecha_vencimiento: 44465 - - Prioridad: 0 | 4686 | D:\Myprofile\Projects\Sectores\National_Government\ANT\PoC_Workforce_2021\Image_File\Anexo_7.docx | |||
| 125 | 88 | 9532549 | Dim2D | 0341001011003500004 | 0035 | 050340100001100350004000000000 | -75.8787135 | 5.659099703 | 0 | Visita_Inicial | 1 | Identificador: 0341001011003500004 - VR_NPN_NUMERO: 050340100001100350004000000000 - Area_Terreno: 88 - Avaluo_Terreno: 9532549- Dimension: Dim2D | 6/10/2021 | 27/09/2021 | rcartagena_gn | javendano_gn | 1 | Manzana_Vereda_Codigo:0035 - POINT_X=-75.8787134999999 - POINT_Y=5.65909970300004 - Wkid=4686 | Tipo_asignacion: Visita_Inicial - Estado: 1 - Despachador_id: rcartagena_gn - Fecha_asignacion: - 44475 - Fecha_vencimiento: 44466 - - Prioridad: 1 | 4686 | D:\Myprofile\Projects\Sectores\National_Government\ANT\PoC_Workforce_2021\Image_File\Anexo_8.xlsx |
