topic Re: Error 000800 in Summary Statistics in script tool in Python Questions

Error 000800 in Summary Statistics in script tool

VishalShah2 — Sat, 11 Dec 2021 07:30:27 GMT

Edit at the bottom.

So I am creating a script tool to be able to provide reports on a weekly basis without having to enter in the parameters over and over again where as I can just click a button to run it for me in the form of a script tool.

Here's what my script looks like:

import arcpy
import os
import arcpy.mapping as map
from arcpy import env
import datetime

mxd = arcpy.mapping.MapDocument("Current")
slackFeatures = r'Slack Features'
date = datetime.date.today()
reportsGDB = r'\\Desktop\Summary_Report\Slack_Summary_Reports.gdb'
reportsFolder = r'\\Desktop\Summary_Reports'

inLayer = slackFeatures
outputName = 'slack_summary'
outLayer = reportsGDB + "/" + outputName
statsFields = ["footage", "SUM"]
caseFields = ["NetworkID", "ProjectID", "type"]

arcpy.Statistics_analysis(inLayer, outLayer, statsFields, caseFields)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

Inputting these parameters manually into the Summary Statistics tool works but it doesn't in the script. I am currently out of ideas to solve this and am open to ideas to try out.

The field footage is a Long field and works manually in the Summary Statistics tool but does not work in the script. I tried the summary statistics tool on another feature class and the custom fields we have in that are Double which the summary statistics works fine for in the script. I tried it on a Long field again for the feature class with the custom fields and the summary statistics throws back the same error.

Why the Summary Statistics tool not work in a script for Long fields but would work for Double fields?

Re: Error 000800 in Summary Statistics in script tool

SteveLynch — Wed, 11 Apr 2018 16:34:15 GMT

run the the geoprocessing tool and then from the results tab copy the Python code and have a look to see what you're missing.

Re: Error 000800 in Summary Statistics in script tool

VishalShah2 — Wed, 11 Apr 2018 20:04:13 GMT

Steve,

Here is the output of that. I'm not seeing anything different other than the location. Location of the output shouldn't matter. And my stats field and case field are the same.

arcpy.Statistics_analysis(in_table="Slack Features", out_table="C:/Users/vshah/Documents/ArcGIS/Default.gdb/DBO_Statistics5", statistics_fields="footage SUM", case_field="NetworkID;ProjectID;type")‍‍‍

Re: Error 000800 in Summary Statistics in script tool

BalajiVeera — Sat, 11 Dec 2021 07:30:29 GMT

statistics_fields parameter should be within the list

import arcpy
import os
import arcpy.mapping as map
from arcpy import env
import datetime

mxd = arcpy.mapping.MapDocument("Current")
slackFeatures = r'Slack Features'
date = datetime.date.today()
reportsGDB = r'\\Desktop\Summary_Report\Slack_Summary_Reports.gdb'
reportsFolder = r'\\Desktop\Summary_Reports'

inLayer = slackFeatures
outputName = 'slack_summary'
outLayer = reportsGDB + "/" + outputName
statsFields =  [["footage", "SUM"]]
caseFields = ["NetworkID", "ProjectID", "type"]

arcpy.Statistics_analysis(inLayer, outLayer, statsFields, caseFields)

Re: Error 000800 in Summary Statistics in script tool

VishalShah2 — Wed, 11 Apr 2018 20:28:29 GMT

That did the trick! Thank you so much Balaji!