topic Re: Workforce migrate_assignments.py in ArcGIS Workforce Questions

Workforce migrate_assignments.py

JayHodny — Mon, 28 Dec 2020 20:04:07 GMT

Hello. I am trying to use the 'migrate_assignments' script to move assignment data from Classic Workforce projects to new Workforce projects in ArcGIS for Enterprise (10.8.1 with Workforce patch installed). I have already used the 'migrate' utility in the Workforce web app dashboard to create new Workforce projects from the classic ones. I am using ArcGIS Pro 2.7.0 which now has ArcGIS for Python 1.8.3. I am using the 'migrate assignment only' command prompt provided in a blog dated August 31, 2020 (Migrate a Classic Workforce project (esri.com).

From the blog: python migrate_assignments.py -u <username> -p <password> -org https://<org>.maps.arcgis.com -classic-project-id <project-item-id> -new-project-id <new-project-fs-item-id>

I am running the script from the python shell in Pro. Regardless of the command line settings, I receive a syntax error. I place double quotes around the parameters instead of the < >.

python drive:\folder\folder\migrate_assignments.py -u "username" -p "password" -org "https://webadaptor.cityofnewarkde.us/portal" -classic-project-id 5c792f3583e44a6b910076d0d7f04628 -new-project-id 766c82cff9464341850ce625c6e99a76

I could not find a way to download the script directly from GitHub. Rather, I had to copy the code and paste it into Notepad to create the migrate_assignments.py.

I have tried many iterations when it comes to placing the double quotes around the parameters. My lack of experience is evident here. The user has admin privileges.

I am at a loss as to why this script is not running, or as to what operator error is getting in the way. Any help would be appreciated.

Re: Workforce migrate_assignments.py

Anonymous User — Mon, 28 Dec 2020 20:15:09 GMT

@JayHodny

You can directly download it from Github using the "Code" button and choose "Download Zip".

You need to run the script from the command-line not from the built-in Python Interpreter in ArcGIS Pro. So open "Python Command Prompt" from inside the ArcGIS folder. This will activate the correct conda environment for you.

Then run the script there (after putting in all the parameters):

Re: Workforce migrate_assignments.py

JayHodny — Mon, 28 Dec 2020 20:21:22 GMT

Hi Aaron,

Good grief, how did I miss the download section?...sigh.......OK, let me give this a try. And thank you.

Regards,

Jay

Re: Workforce migrate_assignments.py

JayHodny — Tue, 29 Dec 2020 16:52:40 GMT

Hi Aaron,

We continued to run into an error when running the script. The error was stating 'assignmentRead was not listed in the table' (or something to this effect). After spending considerable time in trial and error in the command line settings, we realized the Python code specified "assignmentRead," while the field in the classic Workforce assignment feature service was named "assignmentread." In our copy of the Python script, we edited the field name to all lower case and the script ran successfully.

Thanks again for your help,

Jay

Re: Workforce migrate_assignments.py

PLadd — Fri, 11 Mar 2022 15:20:17 GMT

Maybe somebody on this thread can help. When running "conda env create --file environment.yml" from the instructions on this page, I get a pip error and the code stops running. Having no experience with Python but desperately wanting to migrate my project's assignments, I need to resolve this problem that ESRI's code has created for me.

Has anybody encountered a pip error when running this or know how to overcome a pip issue?

Here's what the error looks like:

++++++++++++++++++++++

Pip subprocess error:
error: subprocess-exited-with-error

× python setup.py egg_info did not run successfully.
│ exit code: 1
╰─> [1 lines of output]
error in pypng setup command: use_2to3 is invalid.
[end of output]

note: This error originates from a subprocess, and is likely not a problem with pip.
error: metadata-generation-failed

++++++++++++++++++++++

Thanks.

Re: Workforce migrate_assignments.py

Anonymous User — Fri, 11 Mar 2022 15:48:06 GMT

@PLadd

What operating system are you using for this?

Re: Workforce migrate_assignments.py

PLadd — Fri, 11 Mar 2022 15:49:29 GMT

Thanks for the quick response - Windows 10.

Re: Workforce migrate_assignments.py

PLadd — Fri, 11 Mar 2022 16:11:27 GMT

UPDATE: Have some further info. Tried using the command below after landing on this page and this page from google search of the pip error:

pip install setuptools==58.0.3

But still getting the error.

Re: Workforce migrate_assignments.py

Anonymous User — Fri, 11 Mar 2022 16:49:37 GMT

@PLaddin the environment.yml file at the bottom, there is a dependency called pypng. Try changing that one line from:

- pypng==0.0.18

- pypng==0.0.21

This should resolve the issue by upgrading that library. I tested this fix on a Windows 10 machine. I'll push up a fix to the repo later after I verify it doesn't break any of the notebooks that use that library.

Re: Workforce migrate_assignments.py

PLadd — Fri, 11 Mar 2022 18:54:16 GMT

Whoa! Thank you so much for picking out that minor issue and taking the time to share the correction with me. Such a frustrating problem and such a simple solution. Again many thanks.

Re: Workforce migrate_assignments.py

PLadd — Fri, 11 Mar 2022 19:53:05 GMT

Next issue with Migrating Classic Workforce project using these steps:

When I run this:

migrate_assignments.py -u <username> -p <password> -org https://<org>.maps.arcgis.com -classic-project-id <project-item-id> -new-project-id <new-project-fs-item-id>

it throws an error that there is invalid syntax on this line:

logger.info(f"Migrating attachments for assignment {i + 1}/{len(existing_assignments)} objectId: {object_id}")

Anybody know what this means and a viable solution?

Re: Workforce migrate_assignments.py

Anonymous User — Fri, 11 Mar 2022 20:05:54 GMT

My guess is you are running the script with the wrong python interpreter (e.g. Python 2 instead of Python 3). Make sure you run this in the command prompt/terminal first:

conda activate workforce-scripts

Then run:

python migrate_assignments.py ....

Re: Workforce migrate_assignments.py

PLadd — Mon, 14 Mar 2022 19:42:10 GMT

I finally got migrate_assignments.py to run. For anyone having to use migrate_assignments.py, Aaron's suggestion regarding changing last line in environment.yml to - pypng==0.0.21 from - pypng==0.0.18 was a critical point. Check this line to see if it needs fixing.

Since I'm using Windows 10, "conda" didn't work for me - so instead just typed "activate workforce-scripts" and that worked.

Also, I'm using ArcGIS Enterprise and had to add "portal" to my URL (see sample below comparing parameters to run code):

python migrate_assignments.py -u <username> -p <password> -org https://<org>.maps.arcgis.com

-classic-project-id <project-item-id> -new-project-id <new-project-fs-item-id>

SHOULD BE:

python migrate_assignments.py -u <username> -p <password> -org https://mygis.com/portal

-classic-project-id <project-item-id> -new-project-id <new-project-fs-item-id>