topic Python Error in Python Questions

Python Error

StephenSmith8847 — Mon, 10 Oct 2022 12:10:11 GMT

Hi,

I am trying to follow this guide: Analyzing violent crime automation—Analytics | Documentation (arcgis.com)

I've followed it successfully, using my own data and I am at the stage of building the model.

I first created a varialbe for the report data which will be used to select any date, i've made it a peramter and named it Date (the first oval), i have then added calculate value and attempted to add the following expression:

arcpy.time.ParseDateTimeString('%ReportDate%') - datetime.timedelta(days = 365)

I then changed it to this to match my field names for where the date is:

arcpy.time.ParseDateTimeString('%Created_Date%') - datetime.timedelta(days = 365)

I'm getting an error:

ERROR 000539: Traceback (most recent call last):
File "<expression>", line 1, in <module>
AttributeError: module 'arcpy' has no attribute 'time'
Failed to execute (Calculate Value).

I'm using ArcGIS Pro version 3

Any help would be greatly appreciated.

Re: Python Error

Kara_Shindle — Mon, 10 Oct 2022 13:13:23 GMT

Your model looks like ArcPro, but the instructions are for ArcGIS Desktop. Are you sure that is the correct tool to call in Pro?

I did see this article - looks like that tool may be depreciated at Pro 3.0. You might have to do this in ArcMap if you want to finish your project.

https://support.esri.com/en/technical-article/000027752

Re: Python Error

StephenSmith8847 — Mon, 10 Oct 2022 13:19:03 GMT

That looks to be the issue then! Is there a way around this, to use python to achieve the same results?

Re: Python Error

Kara_Shindle — Mon, 10 Oct 2022 13:31:54 GMT

It looks like the support article suggests a few alternatives. Personally, I prefer the datetime module, which appears to already be used in your expression.

I did just notice that the screenshots in your instructions are from Pro even though this is listed under Desktop. They might update the instructions soon.

Looks like that expression starts to parse a date string for an attribute in your dataset. There are ways to parse a string to a datetime, such as using the strptime() method, which is a built-in method of the datetime class. Try something like this:

datetime.strptime(date_string, format)

I use something similar in a database reconciliation script:

dateToday = currentTime.strftime("%Y-%m-%d")

Re: Python Error

StephenSmith8847 — Mon, 10 Oct 2022 13:41:19 GMT

Appreciate your time and help on this, but i'm still struggling. How does it know which data table (which is added to my project) and then which field within that data table to run the expression against?

All we are trying to do in this expression is i believe allow us to select any date. Next in the model is a SQL expression which i beleive then retrieves 365 days from that date.

It's giving me an error, is this correct?

Thanks again, i appreciate your patience.

Re: Python Error

Kara_Shindle — Mon, 10 Oct 2022 15:15:42 GMT

Edit:

I updated my answer to just have a replacement for the arcpy.time.ParseDateTimeString('ReportDate%') with an alternative as a part of the datetime module.

This calculation is just creating an expression that accepts any string formatted like "month/day/year" i.e. "10/10/2022"

Building this expression means that you will be able to input that date when you run the actual tool, and the date will be consumed in the "Select By Layer Attribute" tool.

For a simpler expression, you can also try the following:

datetime.datetime.strptime('%ReportDate%', '%m/%d/%Y') - datetime.timedelta(days = 365)

Re: Python Error

StephenSmith8847 — Mon, 10 Oct 2022 15:28:17 GMT

Hi,

I've just copied your expression exactly:

datetime.datetime.strptime('%ReportDate%', '%m/%d/%Y') - datetime.timedelta(days = 365)

and i get this still:

Executing (Calculate Value): CalculateValue "datetime.datetime.strptime('01/04/2021 01:00:00', '%m/%d/%Y') - datetime.timedelta(days = 365)" # Date

Start Time: 10 October 2022 16:26:57

ERROR 000539: Traceback (most recent call last):
  File "<expression>", line 1, in <module>
AttributeError: type object 'datetime.datetime' has no attribute 'datetime'

Failed to execute (Calculate Value).

Failed at 10 October 2022 16:26:57 (Elapsed Time: 0.01 seconds)

what am i doing wrong?

Re: Python Error

Brian_Wilson — Mon, 10 Oct 2022 15:59:34 GMT

Just a style comment for you -- I usually use a separate code block, like this,

(I have no idea if the date compare "today > edit" would work - this is just to show the code block.)

That way I can test the code in a separate notebook, I can have import statements at the top, and I can spread the code out over several lines so it's easier to read and understand.

Re: Python Error

StephenSmith8847 — Mon, 10 Oct 2022 16:15:02 GMT

Ok thanks i'll try stlying like that next time, but i copied and pasted the previous posts expression and it didn't work but I can see it has worked for them?

Re: Python Error

Kara_Shindle — Mon, 10 Oct 2022 18:15:09 GMT

We are working on different Python versions - I have not updated to 3.0. so you might have different errors then I see.

You might try removing the first datetime in the expression, as the first part has it twice and the 2nd one has it once. i.e. like this

datetime.strptime('%ReportDate%', '%m/%d/%Y') - datetime.timedelta(days = 365)

When I tested in Python, I was able to create a definition formated similar to what @Brian_Wilson posted.

import datetime string = '10/10/2022' def startTime(string): date = datetime.datetime.strptime(string, '%m/%d/%Y') print(date) finalDate = date - datetime.timedelta(days = 365) print(finalDate) return finalDate startTime(string)

Re: Python Error

Brian_Wilson — Mon, 10 Oct 2022 17:23:41 GMT

Try just datetime.strptime instead of datetime.datetime.strptime

Re: Python Error

MichaelVolz — Mon, 10 Oct 2022 18:01:28 GMT

Have you tried exporting the model out to python and just working on the geoprocess in python instead of ModelBuilder?

What was the geoprocess that was deprecated at Pro 3.0? Do you know what similar geoprocess would perform the same task in Pro 3.0, if indeed the geoprocess called in the sample you are starting from has been deprecated?

Re: Python Error

StephenSmith8847 — Mon, 10 Oct 2022 20:02:06 GMT

Thank you all so much. It's worked! I went into the ReportDate parameter, removed the hh:mm:ss leaving just the date, and after seeing your python layout i noticed it was a minus symbol, but i wanted a + symbol so as you can see below i changed it to + date.timedelta(days=365) and it worked.... would this have been the reason it wasn't working for some reason?

To confirm, the final working expression is as follows:

datetime.datetime.strptime('%ReportDate%', '%d/%m/%Y') + datetime.timedelta(days = 365)

This is now what i get when i run it.

Executing (Calculate Value): CalculateValue "datetime.datetime.strptime('01/01/2020', '%d/%m/%Y') + datetime.timedelta(days = 365)" # Date

Start Time: 10 October 2022 20:56:11

Value = 31/12/2020

Succeeded at 10 October 2022 20:56:11 (Elapsed Time: 0.01 seconds)

Thanks again everyone for your time in helping me, it's very much appreciated!

Re: Python Error

RachelGomez — Thu, 17 Nov 2022 07:12:07 GMT

The correct way to fix a python error

Read the error from the beginning. The first line tells you the location of the error.
Next, look at the error type. In this case, the error type is a SyntaxError.
Look at the details of the error.
Time to use your logic.

Regards,

Rachel Gomez