Latest Contributions by ISP_graynic

Thank you for the help James.  My script is a real basic model I exported from Model Builder as a python script. # Import arcpy module import arcpy # Local variables: SpecialEvents = "SpecialEvents\\SpecialEvents" SE_Test_xls = "I:\\Documents\\SE_Test.xls" # Process: Table To Excel arcpy.TableToExcel_conversion(SpecialEvents, SE_Test_xls, "NAME", "CODE") I have replied to Jake's response with what I am trying based on his comment, but don't believe I am doing it right. ... View more

Here is the simple code below that I am trying to generate and add the token too. import arcpy, SE_Test_xls = "I:\\Documents\\SE_Test.xls" # Process: Table To Excel arcpy.TableToExcel_conversion(SpecialEvents, SE_Test_xls, "NAME", "CODE") ... View more

That is useful to know Kristian.  Thank you very much! ... View more

Thanks for your help Kelly!  The feature service that stores the images, is one of the layers in the web map which makes up the Story Map.  The feature service cannot be shared publicly, which is one of the main reasons I am storing the images in the feature service itself, and not on a public photo sharing service such as Flickr. Do you know if there is anyway to automatically update the token in the URL so I don't have to update the URL with the new token every 2 weeks?  There are probably around 30 pictures in the Story Map.  I saw on the ArcGIS blog, where this summer ESRI is supposed to allow uploading of photos directly into web apps which will be beneficial when they release that.  Thanks  ... View more

Thanks Dan.  It looks like that is for setting up the data to use the time slider in ArcGIS Online.  That is useful to know.  Even when you do that though, it want's a date and a time so the time field comes in as December 1899 and then a time.  There has to be a way to just show the time. ... View more

Thank you Wes.  It didn't originally work, but when I added .env. before the overwrite function it worked (arcpy.env.overwriteOutput = True)! Thank you again so much for all the help!!! ... View more

The goal is to update the layer on a regular basis, so I would like to just overwrite the data with newly geocoded data.  Do you know if there is a way I can overwrite the layer instead of creatinga  whole new file?' I really appreciate your help!!! ... View more

Thank you very much Wes.  I did that and it got past line 14, but then gave me this error mesage. Traceback (most recent call last):   File "D:\MY FILES\Scripts\Schools_Excel.py", line 23, in <module>     arcpy.GeocodeAddresses_geocoding(FOUO_MembersExcel, IllinoisCity_AddressLocator, "City City VISIBLE NONE;State State VISIBLE NONE", O_Members, "STATIC")   File "C:\Program Files (x86)\ArcGIS\Desktop10.3\ArcPy\arcpy\geocoding.py", line 212, in GeocodeAddresses     raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000725: Output Feature Class: Dataset D:\MY FILES\Studies\Schools\Schools.gdb\O_Members already exists. Failed to execute (GeocodeAddresses). ... View more

Here is a copy of the script # --------------------------------------------------------------------------- # Schools_Excel.py # Created on: 2016-04-06 11:30:27.00000 #   (generated by ArcGIS/ModelBuilder) # Description: # --------------------------------------------------------------------------- # Import arcpy module import arcpy # Local variables: MAP_Feb_15_2016_-_Copy_xls = "D:\\Schools\\MEMBERSHIP\\MAP Feb 15 2016 Application Status for Program - Copy.xls" O_MembersExcel = "D:\\MY FILES\\Studies\\Schools\\Schools.gdb\\O_MembersExcel" IllinoisCity_AddressLocator = "D:\\MY FILES\\Basic Map Data\\IllinoisCity_AddressLocator" O_Members = "D:\\MY FILES\\Studies\\Schools\\Schools.gdb\\O_Members" # Process: Excel To Table arcpy.ExcelToTable_conversion(MAP_Feb_15_2016_Application_Status_for_Program_-_Copy_xls, O_MembersExcel, "O") # Process: Geocode Addresses arcpy.GeocodeAddresses_geocoding(FOUO_MembersExcel, IllinoisCity_AddressLocator, "City City VISIBLE NONE;State State VISIBLE NONE", O_Members, "STATIC") ... View more