Latest Contributions by JoshWhite

Julia, My original problem was really the opposite of that and yes some of the issues are likely resolved for me in 10.2.4.  I want the ability to require fields have a value regardless of whether they are nullable. Others have mentioned domain fields.  Sometimes these would be required, sometimes not, depends on the feature. ... View more

I agree on the editor tracking, I've really only used Collector in a test state so far so I'm not sure how it is working.  I have noticed that when I used the editing feature in my Flex webmap using a feature service, the editor always showed up as Esri_Anonymous which is completely useless.  Of course there isn't a log in required so that might be what causes that.  I just wish it would use Windows credentials.  ... View more

I haven't worked with this much since.  I would recommend that Esri just make the required property editable in AGOL.  It seems this would be a quick fix.  Plus this would give you options to require fields that the REST endpoint says are nullable if desired. ... View more

Can somebody explain to me what Pro does?  I'm having troubles understanding the benefits of it.  It appears that you only have as many pro licenses as you have Desktop licenses so what extra capabilities does it offer me that Desktop doesn't. ... View more

I should point out that a workaround would be to covert your date fields to long integer.  So if your dates are MM/DD/YYYY you can use: Int (Right( [Date], 4 ) & Left( [Date], 2 ) &Mid( [Date], 4, 2  )  ) 01/01/2012 to 20120101   ... View more

Very much needed ... View more

Jay, How would you do it if the original date field is MM/DD/YYYY format? Nevermind I did some tweaking and came up with Int (Right( [Date], 4 ) & Left( [Date], 2 ) &Mid( [Date], 4, 2  )  ) So mine went from 01/01/2012 to 20120101 ... View more

Robert, Thanks I actually figured it out, what I forgot to do was enter the field name again. I was using Begin_Date_Occ > date '2010-11-15 14:00:00' AND < date '2011-09-01 09:30:38' so the syntax was invalid. ... View more

Owen, How do you do a range of dates in the Query builder.  I can't seem to get it to work properly. ... View more

They are on the same machine.  There is a crossdomain file that perhaps is not configured correctly.  In fact I found a default crossdomain file and saved it, and now the problem is gone.  ... View more

ok, I sent it. ... View more

I'm still getting a warning about no records being within the table.  I don't know what else to do to make this right.  There are no other errors, it even says it ran the TrimLinesByDistance successfully even though the output is empty.  I ran it a second time without deleted the tables and those tables returned with results without an issue but CCTVcondtions, the attachment table and TelevisedMains are empty.  I did replace the script with the above file. ... View more

Well I finally got around to running it with clean copies straight from the access db.  I thought I fixed everything and I still have a whole slew of errors: Start Time: Wed Oct 22 16:58:04 2014 Succeeded at Wed Oct 22 16:58:05 2014 (Elapsed Time: 1.15 seconds) Executing (Points Along a Polyline by Distance): PointsAlongLineDistance "Database Connections\Connection to GIS-SERVER.sde\acgis.DBO.SanitarySewer\acgis.DBO.ssGravityMain" FACILITYID C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Conditions Pipe_Segment_Reference Distance Direction Upstream Downstream C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb CCTVConditions Start Time: Wed Oct 22 16:58:05 2014 Running script PointsAlongLineDistance... Completed script PointsAlongLineDistance... Succeeded at Wed Oct 22 16:58:26 2014 (Elapsed Time: 20.33 seconds) Executing (Join TAPPOINTS+VIDEO): JoinField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\CCTVConditions InspectionID C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Media_Inspections InspectionID Video_Name;Video_Location Start Time: Wed Oct 22 16:58:26 2014 Succeeded at Wed Oct 22 16:58:26 2014 (Elapsed Time: 0.35 seconds) Executing (Calculate Field (2)): CalculateField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\CCTVConditions Video_Location "http://70.167.59.150/Sewer/Videos" VB # Start Time: Wed Oct 22 16:58:26 2014 WARNING 000405: No records within table Succeeded at Wed Oct 22 16:58:26 2014 (Elapsed Time: 0.25 seconds) Executing (Add VIDEO Field): AddField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\CCTVConditions VIDEO_URL TEXT # # 150 "Video URL" NULLABLE NON_REQUIRED # Start Time: Wed Oct 22 16:58:27 2014 Adding VIDEO_URL to C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\CCTVConditions... Succeeded at Wed Oct 22 16:58:27 2014 (Elapsed Time: 0.38 seconds) Executing (Calculate Field): CalculateField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\CCTVConditions VIDEO_URL "[Video_Location] & [Video_Name]" VB # Start Time: Wed Oct 22 16:58:27 2014 WARNING 000405: No records within table Succeeded at Wed Oct 22 16:58:27 2014 (Elapsed Time: 0.26 seconds) Executing (Assign Domain To Field): AssignDomainToField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\CCTVConditions PACP_Code PACP_Codes # Start Time: Wed Oct 22 16:58:27 2014 Succeeded at Wed Oct 22 16:58:28 2014 (Elapsed Time: 0.46 seconds) Executing (Enable Attachments): EnableAttachments C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\CCTVConditions Start Time: Wed Oct 22 16:58:28 2014 Succeeded at Wed Oct 22 16:58:29 2014 (Elapsed Time: 0.52 seconds) Executing (Add Attachments): AddAttachments C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\CCTVConditions ConditionID C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Media_Conditions ConditionID Image_Reference C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-24-2014\Mainline\Snapshots Start Time: Wed Oct 22 16:58:29 2014 Succeeded at Wed Oct 22 16:58:29 2014 (Elapsed Time: 0.39 seconds) Executing (Join Inspections To Pipe): AddJoin DBO.ssGravityMain_Layer FACILITYID C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Inspections Pipe_Segment_Reference KEEP_COMMON Start Time: Wed Oct 22 16:58:29 2014 Succeeded at Wed Oct 22 16:58:29 2014 (Elapsed Time: 0.08 seconds) Executing (Copy Feature Custom): CopyFeatureCustom DBO.ssGravityMain_Layer C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb TelevisedMains Start Time: Wed Oct 22 16:58:29 2014 Running script CopyFeatureCustom... Completed script CopyFeatureCustom... Succeeded at Wed Oct 22 16:58:31 2014 (Elapsed Time: 1.45 seconds) Executing (Join Inspections Media): JoinField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\TelevisedMains Inspections_InspectionID C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Media_Inspections InspectionID Video_Name;Video_Location Start Time: Wed Oct 22 16:58:31 2014 Succeeded at Wed Oct 22 16:58:31 2014 (Elapsed Time: 0.25 seconds) Executing (Remove Join): RemoveJoin DBO.ssGravityMain_Layer # Start Time: Wed Oct 22 16:58:31 2014 Succeeded at Wed Oct 22 16:58:31 2014 (Elapsed Time: 0.01 seconds) Executing (Delete): Delete C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Media_Conditions # Start Time: Wed Oct 22 16:58:31 2014 Succeeded at Wed Oct 22 16:58:32 2014 (Elapsed Time: 0.16 seconds) Executing (Delete (2)): Delete C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Media_Inspections # Start Time: Wed Oct 22 16:58:32 2014 Succeeded at Wed Oct 22 16:58:32 2014 (Elapsed Time: 0.16 seconds) Executing (Delete (3)): Delete C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Inspections # Start Time: Wed Oct 22 16:58:32 2014 Succeeded at Wed Oct 22 16:58:32 2014 (Elapsed Time: 0.17 seconds) Executing (Delete (4)): Delete C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\Conditions # Start Time: Wed Oct 22 16:58:32 2014 Succeeded at Wed Oct 22 16:58:32 2014 (Elapsed Time: 0.17 seconds) Executing (Calculate Field (3)): CalculateField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\TelevisedMains Video_Location "http://70.167.59.150/Sewer/Videos" VB # Start Time: Wed Oct 22 16:58:32 2014 WARNING 000405: No records within table Succeeded at Wed Oct 22 16:58:32 2014 (Elapsed Time: 0.43 seconds) Executing (Add VIDEO Field (2)): AddField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\TelevisedMains VIDEO_URL TEXT # # 150 "Video URL" NULLABLE NON_REQUIRED # Start Time: Wed Oct 22 16:58:33 2014 Adding VIDEO_URL to C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\TelevisedMains... Succeeded at Wed Oct 22 16:58:33 2014 (Elapsed Time: 0.38 seconds) Executing (Calculate Field (4)): CalculateField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\TelevisedMains VIDEO_URL "[Video_Location] & [Video_Name]" VB # Start Time: Wed Oct 22 16:58:33 2014 WARNING 000405: No records within table Succeeded at Wed Oct 22 16:58:34 2014 (Elapsed Time: 0.43 seconds) Executing (Add Trimmed Flag Field): AddField C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\TelevisedMains TRIMMEDFLAG TEXT # # 25 "Trimmed Flag" NULLABLE NON_REQUIRED # Start Time: Wed Oct 22 16:58:34 2014 Adding TRIMMEDFLAG to C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\TelevisedMains... Succeeded at Wed Oct 22 16:58:34 2014 (Elapsed Time: 0.38 seconds) Executing (Trim Lines By Distance): TrimLinesByDistance C:\GIS\ENVIRONSERV\SanitarySewer\CCTV\9-19-2014\CCTVOutput.gdb\TelevisedMains Inspections_Length_Surveyed Inspections_Direction TRIMMEDFLAG Upstream Downstream Start Time: Wed Oct 22 16:58:34 2014 Running script TrimLinesByDistance... error on line: line 51 error in file name: C:\GIS\OTHER\ArcGISTemplates\CCTV processor\MapsandGDBs\CCTVTools.tbx#TrimLinesByDistance.py with error message: RuntimeError: cannot open 'C:/Work/ArcGIS for Utilities/_Water/Staging/A4W-CCTVProcesser-v1_2/MapsandGDBs/CCTVOutput.gdb/TelevisedMains' Completed script TrimLinesByDistance... Failed to execute (Trim Lines By Distance). Failed at Wed Oct 22 16:58:34 2014 (Elapsed Time: 0.06 seconds) Failed to execute (CCTVObservationsToFeatures). Failed at Wed Oct 22 16:58:35 2014 (Elapsed Time: 42.76 seconds) ... View more