POST
|
Hello, I am trying to set up a collector app for infrastructure cleaning schedules. I have it set up to automatically add a date when a new point is added representing a cleaned line. Now I am trying to set up an arcade script that will take this last cleaned date and calculate the next cleaning date, then use that to symbolize lines now needing to be cleaned. There are several cleaning schedule categories (1 month, 3 months, 2 years, etc), so the script would need to look at the cleaning schedule field, and then calculate the new cleaning date accordingly. I'm assuming the best workflow for this would be to use arcade functions in order to do; - select group by cleaning schedule - calculate next clean date by taking last clean date + clean schedule - set status to "clean required" when new clean date is reached I know to use the DateAdd function to calculate the new date, but I am unsure how to link selecting the date field by clean schedule as I am new to arcade. Thanks in advance for any advice on the subject.
... View more
11-13-2019
03:29 PM
|
0
|
2
|
624
|
POST
|
I discovered the solution to this in case anyone else comes along the same issue. I created a fresh gdb for my layers and moved over one layer from the old gdb to the new using the Feature Class to Geodatabase tool in order to test. Then used the Domain to Table tool to extract my wanted domain into a table. I then used the Table to Domain tool to bring the wanted domain into the new gdb. After testing, this solution resulted in the proper domain values showing when in edit mode, I moved the rest of the layers to the new gdb with the Feature Class to Geodatabase tool (copy and paste results in errors when posting). After that I was able to post my feature service to my server, with proper domain values showing when editing in collector.
... View more
11-04-2019
12:51 PM
|
0
|
0
|
400
|
POST
|
I'm creating a feature service for collector showing infrastructure cleaning schedules. I took an xlsx with the line and cleaning information and converted it to a feature class in a gdb. I set a domain for the cleaning schedule attribute, replaced all attribute data with the proper cleaning domains and then posted my map as a feature services AGOL. The rest end shows the old cleaning information from the xlsx as the set domain values instead of the domain I created, and this is also what is shown when editing in collector. Editing in ArcMap shows the proper domain value. I have tried the feature class to feature class tool, and exporting to a new file to try and get rid of whatever is maintaining this link to the xlsx original field data, but those have not worked. Any ideas on how to maintain the proper domain values when posting as a service?
... View more
10-29-2019
01:28 PM
|
0
|
1
|
466
|
POST
|
Thank you! I am using 10.6.1, so I will try publishing the service via Pro. Is there a way to place the report in the same page as the map of selected parcels?
... View more
07-31-2019
05:02 PM
|
0
|
3
|
4478
|
POST
|
I am trying to create a web app where a user can search for a parcel, select it, and then print a document that will include the selected parcels attribute information. In Arcmap I have the custom text elements in the layout to call to attributes in a specific parcel layer when a parcel is selected. I know about creating a print service to be used in the print widget to create the custom layout, but so far I have only found ways to do this where the user still needs to enter the parcel information in for the custom text elements. I would like to have the custom text elements call to the attribute information from the selected parcel layer like in my mxd. Is there a way to accomplish this within creating a print service, or with json?
... View more
07-31-2019
01:40 PM
|
0
|
8
|
5329
|
POST
|
I'm trying to have it set to convert itself each day so that a person does not have to manually do it everyday. Is there a way to set this within excel?
... View more
02-12-2019
01:12 PM
|
0
|
1
|
1905
|
POST
|
I am currently trying to create a python script within model builder to convert an xls file to csv. I created one already using the "Excel to Table" tool which was successful. However, I tried to add data to the xls file and run the script again and it choked on the "csv already exists". I tried adding "Application.DisplayAlerts = False" to overwrite the csv already existing, but it still choked when I tried to run it again. My ultimate goal is to create a script I can set up in task scheduler to run on it's own everyday to convert an xls to csv, without using a script that requires macros to be enabled in the xls. I am at the beginner beginner level when it comes to python script. Any help would be much appreciated!
... View more
02-12-2019
12:32 PM
|
0
|
13
|
3271
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|