Latest Contributions by JeremyMoore3

I wrote some code to run on my server that will automatically generate reports from a file geodatabase using several .rlf files that have definition queries within the .rlf files. The code runs flawlessly and now I'm trying to improve it by reducing the number of .rlf files I have to use by adding the definition queries to python within the ExportReport function. I'm having a heck of a time figuring out how to get this to work correctly. I have read over several posts from other users and came across this documentation Specifying a query in Python. This documentation is exactly what I'm trying to do however I can not figure out how to do it correctly. I would deeply appreciate it if someone could lend a hand and get this working for me so I can dissect it and play around some to understand the syntax. SQL Expression: Date > CURRENT_DATE-8 AND Area = 'Central' Python: arcpy.mapping.ExportReport(lyr, os.path.dirname(os.path.abspath(__file__)) + '\\' + 'Report_Templates' + '\\' 'Test_Report.rlf', r'D:\FTP Files\Reports\Test.pdf, DEFINITION_QUERY, report_definition_query= What do I add here?) ‍‍‍‍ ... View more

I was wondering if anyone has been able to load Assignment types from CSV yet? I'm not trying to load Assignments by CSV. There is a a script for that. What I'm looking to do is edit the "Domain" that has the Assignment Code and Descriptions. The reason behind this is because within workforce we have only one type of work being conducted. Which is power line inspections. Since the work ID doesn't show up in the open project page it makes differentiating the different power lines the crews will be working on difficult. So we would like to be able to add the actual Power Line names to the Assignment Types so the name of the power line will show up without having to tap on the assignment to see the work ID. We could input the information by hand however the problem is that there are thousands of power lines that need to be inspected. It would be really nice if there was a way to automate it. ... View more

It would be really nice to have more information shown in the project assignments overview. Right now only the Assignment type is shown. It would be really handy to have the Work ID shown as well to make differentiating similar tasks easier. ... View more