Latest Contributions by BillDaigle

The problem is... the 'getParameters' function only runs once -- when the toolbox is refreshed.  In order to do what you want without refreshing, you will need to use the 'updateParameters' functions, as Jason Scheirer​ suggested.  This runs every time a parameter is updated. I'm not sure if it will run as soon as you open the tool.  If not, you could add another Boolean parameter that trigger the "Update from Table" and disable the parameter once the parameters have been updated.  ... View more

How much data are you working with?  Could you just store the intermediate in a python object?  Something like a list of lists or a list of dictionaries? For example: lump = [] lump.append(0, k, value[0], value[1], v[0], Mod , v[1], v[2], v[3], v[4], v[5], v[16], v[17] ) or: lump = [] lump.append({'field1Name':0, 'field2Name':k, 'field3Name':value[0], 'field4Name':value[1], 'field5Name':v[0],'field6Name':Mod , 'field7Name':v[1], 'field8Name':v[2], 'field9Name':v[3], 'field10Name':v[4], 'field11Name':v[5], 'field12Name':v[16], 'field13Name':v[17]}) You would need to modify the sorting code and figure out a way to get it into excel, but there are lots of examples out there on how to to that. ... View more

I think the reason ESRI recommends publishing from an MXD is that they want you to run the tool before publishing.  You need a valid results object before you can publish to server. It is possible to do all of this through a script, but it's not easy.   As part of the publishing process, your script will get modified.  The publishing tools will crawl the script, replace any hard-coded paths with a variables and reset the paths so they reference locations that will get created on the server -- assuming the hard-coded path is not a registered data store.  Any data that gets copied with the tool is included in the '.sd' file (i.e. service definition file) that gets copied to the server.  The updated script also get included in the '.sd' file.  Depending on where this fail in the publishing process, you may be able to view the sd file and figure out what is going wrong.  If you can find the sd file on your machine, you can view it by changing the extension to '.zip'. ... View more

Is the tool built using model-builder or a python script?  Sounds like you're using a script. I have published python toolboxes with in_memory intermediates to a 10.1 server without a problem.  If you're using a python script and still having problems, you may want to try building the "in_memory" path using os.path.join (i.e. "os.path.join('in_memory','tempFC')").  I had a similar issue with data getting inadvertently getting copied and that seemed to fix it. ... View more

It looks like the parameter "useStandardizedQueries" that was added at 10.2  http://resources.arcgis.com/en/help/arcgis-rest-api/index.html#//02r3000000p1000000 ​likely addresses my concern.  ... View more

Looks like the standardized query functionality was added a 10.2.  Although I'm able to run Oracle specific commands, I'm working on a 10.1 server.  I suspect the same would not be true on 10.2+. ... View more

It looks like a timing issue.  You are trying to set the visibility before the layer is loaded. Try setting the visiibility property or setting the visibility after the load event. var ortofotokarte = new Tiled("http://127.0.0.1/MapServer,{visible:false}); map.addLayer(ortofotokarte); or var ortofotokarte = new Tiled("http://127.0.0.1/MapServer"); ortofotokarte.on('load',function(){   ortofotokarte.setVisibility(false); }); map.addLayer(ortofotokarte); ... View more

I agree with Blake about the triple quoted strings.  They are much cleaner and will allow you to copy and paste from a SQL editor like PLSQL or SQL Developer. sql_statement =  """                    SELECT *                    FROM USER_TAB_PRIVS                    WHERE OWNER LIKE 'GISADMN'                  """ ... View more

Bledar,  you may have already done this, but it might be worth double checking to make sure the data did not get copied to the server.  I've been bitten by this before. We have a 10.1 server with Oracle SDE and I am able to apply standard oracle queries to the service layers (via REST or ArcMap).  I just tried a "TO_DATE" call and a wildcard call without a problem.  ... View more

I use the following query to fetch privileges from 10.1 geodatabase on Oracle 11.2.04: select * from USER_TAB_PRIVS ... View more

Ah yes...thanks for heads up.  I will edit accordingly! ... View more

You're creating a string instead of an array. Try: findParams.searchFields = []; findParmas.searchFields.push(dom.byId("fieldSelect").value); ... View more

I think the arcpy.ListFeatureClasses command is returning None (which is not iterable) because the workspace is not getting set correctly in line 4.  Try updating line 4 to: arcpy.env.workspace = "c:/Win/Sik/Routes" ... View more

Not that I know of.  I've shared web maps with added narrative using Survey Monkey. In my case, I needed to get feedback on the map, so survey monkey worked quite well.  ... View more