Hi KevinThis starts to give me a headache... so I uninstalled all ArcGIS and python, and removed all related to ArcGIS and Python in the registry.Installed only the Server this time, so I'm only running 64bit on the server now, so far so good.When I look in the registry there is only reference to python in these places :HKEY_LOCAL_MACHINE\SOFTWARE\ESRI\Python10.1 = C:\Python27\
HKEY_LOCAL_MACHINE\SOFTWARE\Python\PythonCore\2.7\InstallPath = C:\Python27\ArcGISx6410.1\The python (sys.version) is : 2.7.2 (default, Jun 12 2011, 14:24:46) [MSC v.1500 64 bit (AMD64)]I installed the openpyxl module and the path to that on the server (os.path.dirname(openpyxl.__file__) is : C:\Python27\ArcGISx6410.1\lib\site-packages\openpyxl-1.5.8-py2.7.egg\openpyxlNow I've made a python toolbox like this :import arcpyimport os, sys
import datetime, time
import uuid
from arcpy import env
import openpyxl
class Toolbox(object):
def __init__(self):
"""Define the toolbox (the name of the toolbox is the name of the
.pyt file)."""
self.label = "Toolbox"
self.alias = ""
# List of tool classes associated with this toolbox
self.tools = [Tool]
class Tool(object):
def __init__(self):
"""Define the tool (tool name is the name of the class)."""
self.label = "Tool"
self.description = ""
self.canRunInBackground = False
def getParameterInfo(self):
"""Define parameter definitions"""
selectOwners = arcpy.Parameter(
displayName = 'This is test 1',
name = 'owner_selected',
datatype = 'Boolean',
parameterType = 'Optional',
direction = 'Input')
selectResidents = arcpy.Parameter(
displayName = 'This is test 2',
name = 'residents_selected',
datatype = 'Boolean',
parameterType = 'Optional',
direction = 'Input')
params = [selectOwners, selectResidents]
return params
def isLicensed(self):
"""Set whether tool is licensed to execute."""
return True
def updateParameters(self, parameters):
"""Modify the values and properties of parameters before internal
validation is performed. This method is called whenever a parameter
has been changed."""
return
def updateMessages(self, parameters):
"""Modify the messages created by internal validation for each tool
parameter. This method is called after internal validation."""
return
def execute(self, parameters, messages):
"""The source code of the tool."""
scriptPath = sys.path[0]
outfolder = os.path.join(scriptPath, 'Output')
arcpy.env.scratchWorkspace = scriptPath
wb = openpyxl.Workbook()
filename = '_ags_' + str(uuid.uuid4()) + '.xlsx'
arcpy.AddMessage('Filename : %s' % os.path.join(outfolder, filename))
wb.save(os.path.join(outfolder, filename))
Running this from the ArcMap on a remote computer gives me a file in the Output folder where the toolbox is located.It's running and doing what it should do.I'm then trying to publish the result as a Geoprocess on my reinstalled server, this is where it breaks down.I'm setting up the parameters, the tools and the Item Description, running Analyze = nothing...pressing Publish and it's running and running and running and running, I think you get it... It's been running for over 30 minutes and nothing.[ATTACH=CONFIG]18305[/ATTACH]As of now, I have to install the 32 bit python and the ArcMap again, so that my other gp-services will run again.Do you have any ideas ? I'm willing to show it live to you or one of your colleagues on the ESRI EU UC in Oslo this monday or tuesday, is that possible ??Thanks