topic Re: Script runs on some computers, fails on others. in Python Questions

Script runs on some computers, fails on others.

GinoMellino — Mon, 24 Apr 2017 06:39:47 GMT

Hi,

I have a script which extracts land parcel polygons from a master dataset based on various user inputs such as local government area, vegetation type, agricultural land class type, etc. One of the outputs of the tool is an excel spreadsheet which I create using arcpy.TableToExcel_conversion. This works fine on my machine but throws the following error on a colleagues machine. Can anyone offer any insight into why this error is occurring?

Kind Regards,
Gino

Traceback (most recent call last):

File "<string>", line 327, in execute

AttributeError: 'module' object has no attribute 'TableToExcel_conversion'

Failed to execute (LandInvestigationShortlistingTool).

Re: Script runs on some computers, fails on others.

Anonymous User — Mon, 24 Apr 2017 10:28:25 GMT

Hello,

Are you sharing or using script as tool or script.

Try to create Custom tool using your script and use this with your colleges system.

Most of the time its working without any error.

https://community.esri.com/docs/DOC-8559

Re: Script runs on some computers, fails on others.

DanPatterson_Retired — Mon, 24 Apr 2017 10:40:34 GMT

They have arcmap installed on their machine as well I presume? and what version of ArcMap??? Can you open a python window in arcmap on their machine? Can you import arcpy?

Re: Script runs on some computers, fails on others.

JoshuaBixby — Mon, 24 Apr 2017 12:22:00 GMT

To follow-up on Dan's comments, how are you executing the script, exactly? Do some of the machines have multiple version or distributions of Python installed?

Re: Script runs on some computers, fails on others.

SolomonPulapkura — Tue, 25 Apr 2017 07:32:46 GMT

Does he have the same excel version as you?

Solomon Pulapkura

https://www.vestra.com/gis

Re: Script runs on some computers, fails on others.

RebeccaStrauch__GISP — Tue, 25 Apr 2017 15:06:53 GMT

And depending on the Excel/Office version installed, you may also want to make sure that the compatibility patch for Office is installed, if appropriate.

This thread ARc for Desktop 10.1 and Microsoft Office 2013 had a different issue, but I have seen other threads to that installing the patch helped.

Direct download of the patch Download 2007 Office Sy

stem Driver: Data Connectivity Components from Official Microsoft Download Center

Re: Script runs on some computers, fails on others.

GinoMellino — Wed, 26 Apr 2017 07:01:36 GMT

Hi Guys,

Thank you for the replies and sorry for the late reply on my part. I think Dan has nailed it, the users are running ArcGIS 10.1 which does not have the Excel tools as I understand they were added at ArcGIS 10.2. I wrongly assumed they would be running the latest version approved by our department, i.e. 10.4.1.

I will get them upgraded and try again to see if this resolves the problem.

Cheers for all your help.

Re: Script runs on some computers, fails on others.

GinoMellino — Wed, 10 May 2017 06:55:22 GMT

Confirmed the issue was with the version of ArcGIS on the target users machine. Rookie mistake...Thanks for your help Dan and everyone.