I can make more of 100 assignaments on web enviroment
I can make more of 100 assignaments using python scripts for workforce
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
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 |