Latest Contributions by KevinHibma

Ok.... I couldnt find a windows installer for this package...I did find this though: http://www.lfd.uci.edu/~gohlke/pythonlibs/ I installed both of these (32 and 64bit versions.... the installer finds my the proper python and puts them in there) Base-12.9.15.win-amd64-py2.7.*exe Base-12.9.15.win32-py2.7.*exe I then took your tool you provided above, created a PYT and ran it on Desktop. (I had to make an "output" folder in the same directory as the PYT) No problems. I then published it to Server, no problems. I then executed the service, no problems. My best guess of what you're doing - you've installed the package differently? It doesnt look like theres a real installer for it. I'm not sure I can offer any advice on getting this particular package installed short of the way I did it. Why is it taking 30+ minutes to publish? My guess - you have a LOT of files inside that output folder. Gigabytes and gigabytes. As per the publishing rules, if you reference a folder, we take the contents of that folder because we assume it contains required inputs. The folder I made was brand new and had nothing in it. Could you clean the folder or point to an empty one and try again? Also - in your tool it looks like you're trying to handle unique output names for your excel file. Any particular reason why? If not, I'd suggest letting server do it for you by creating the file in the scratch directories. The way you have it right now, you're setting the scratchWorkspace in the script. You can't do this in a GP Service. The framework handles the scratchworkspace, thus you should just inherit from it. Your tool on Desktop can work the same way - let ArcMap set the scracthWorkspace and have the tool inherit from it. import arcpy import os, sys import datetime, time 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."""                 wb = openpyxl.Workbook()         filename = os.path.join(arcpy.env.scratchFolder, "myExcel.xlsx")         arcpy.AddMessage('Filename : {}'.format(filename))         wb.save(filename) ... View more