create_assignments_from_csv fails in ArcGIS Enterprise. about workforce-scripts HOT 6 CLOSED

Hi Aaron, I noticed that the attachments of assignment can be imported to WF in your Create Assignment scripts. Can the attachments of assignment be downloaded when export assignments to desktop? I heard that WF is going to add the function to allow workers to ass attachments in the field. Download attachments into a local folder and add the filepath to the each assignment will be great! Enjoyed your scripts and thanks, Ming Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10 From: Aaron Pulver<mailto:[email protected]> Sent: Wednesday, September 20, 2017 11:32 AM To: Esri/workforce-scripts<mailto:[email protected]> Cc: Subscribed<mailto:[email protected]> Subject: Re: [Esri/workforce-scripts] create_assignments_from_csv fails in ArcGIS Enterprise. (#11) @hmelendez<https://github.com/hmelendez> I added a few commits which should add portal support for all scripts, if using the Python API. Let me know if this does not resolve your issue. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub<#11 (comment)>, or mute the thread<https://github.com/notifications/unsubscribe-auth/AWeMAchthHuauUGIbKXgcu0qcnd7Sb7rks5skS_lgaJpZM4Ofmw3>.

Hi Aaron, Sorry for the delay of reply, it is that season! Yes, we like to be able to download attachments along with the completed assignments for archive and analysis purposes. The attachments are preferred to store in a separate folder instead of stored as blob in ….__ATTACH table. In fact, we need to do this very often. We have a number the active WF projects in AGOL. Some of them created in Dispatcher, others created in 3rd party app and synced to WF project. We also archive all of them in local FGDB for historical records, as well as for system analysis (water utility) of the Assets Management process. The key step in the workflow is that every a while (monthly for now), manager will review the assignments in WF projects. Identify those completed assignments in last month, sync them into a master assignment Featureclass in local FGDB. Then remove these assignment from active WF projects. Your python scripts provided a mean to do this. However, it is still not very intuitive for non-programmers. I actually using Win Form created a GUI APP for user to created batch assignments, sync/download completed assignments, and remove synced old assignments from active WF projects. Your scripts provided me the inspirations and approaches! Speaking the attachments, I found that I can identify the url of each attachment and download them one-by-one. However, the my approach is the followings: 1. Created a replica for selected assignments; 2. Download the replica as SQLite; Extract the SQLite db to Master FGDB (assignments), extract the blob to local folder and pass the infos (path, name, format, etc.) to a related table in FGDB. If you have any suggestions, please do not hesitate to share with me! Thanks, Ming Sent from Mail<https://go.microsoft.com/fwlink/?LinkId=550986> for Windows 10