topic Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro in Python Questions

Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

VanceRenforth2 — Sat, 11 Dec 2021 21:04:05 GMT

I am trying to create a script that will automate a Feature Class to Feature Class OR Feature Class to File Geodatabase Conversion. I want to save this in a folder as a back up once a week in case I lose my current data for any reason or need to revert to that download date. So far I have the following code just for the FC to FC operation, and am recieving the error that follows.:

import arcpy
arcpy.env.workspace = "https://services.arcgis.com/T2graiaSQnlmwwmp/arcgis/rest/services/Target_Address_7_6_Backup/FeatureServer"
arcpy.FeatureClassToFeatureClass_conversion("Target Address New",
 "C:\\Users\vmrenfor\Consumers Folders\VSR\BackupExports\VSR Back up\VSR Back up.gdb",
 "Target_Adrress_12_10_2018")

Traceback (most recent call last):
 File "<string>", line 5, in <module>
 File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\conversion.py", line 860, in FeatureClassToFeatureClass
 raise e
 File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\conversion.py", line 857, in FeatureClassToFeatureClass
 retval = convertArcObjectToPythonObject(gp.FeatureClassToFeatureClass_conversion(*gp_fixargs((in_features, out_path, out_name, where_clause, field_mapping, config_keyword), True)))
 File "c:\program files\arcgis\pro\Resources\arcpy\arcpy\geoprocessing\_base.py", line 496, in <lambda>
 return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid.
ERROR 000732: Output Location: Dataset C:\Users mrenfor\Consumers Folders\VSR\BackupExports\VSR Back up\VSR Back up.gdb does not exist or is not supported
Failed to execute (FeatureClassToFeatureClass).

Any thoughts on how I can fix this error would be appreciated. I would then like this to be run each subsequent week, naming the file "Target_Address_{Current Date}.

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

MichaelVolz — Mon, 10 Dec 2018 18:56:02 GMT

I would suggest not having spaces in folder names, maybe replace with underscores. Might not solve your problem, but would be better practice.

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

JakeSkinner — Mon, 10 Dec 2018 19:04:51 GMT

Hi Vance,

Looks like you are setting your workspace to a Feature Service. Are you trying to download a feature service to a local File Geodatabase. If so, take a look at this tool.

Also, when specifying a path in python you won't want to specify a backslash in the path. The backslash (\) character is used to escape characters that otherwise have a special meaning, such as newline, backslash itself, or the quote character. You have a few options to specify a path:

1. Place an r in front of the path:

r"C:\temp\data.gdb"‍

2. Use two backslashes:

"C:\\temp\\data.gdb"‍

3. Use forward slashes:

"C:/temp/data.gdb"‍

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

JoshuaBixby — Mon, 10 Dec 2018 19:08:29 GMT

When working with Windows paths, you should use raw string formatting. You appeared to be escaping the first backslash in your path but none of the others. In Python "\v" represents the ASCII vertical tab. Since you didn't escape it, your string has a vertical tab in it, and ArcPy cannot find the path.

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

VanceRenforth2 — Wed, 12 Dec 2018 13:23:12 GMT

I took your suggestion and add "r" before the path and that worked.

So now I have:

import arcpy
arcpy.env.workspace = "https://services.arcgis.com/T2graiaSQnlmwwmp/arcgis/rest/services/Target_Address_7_6_Backup/FeatureServer"
arcpy.FeatureClassToFeatureClass_conversion("Target Address New",
r"C:\Users\vmrenfor\Consumers Folders\VSR\BackupExports\VSR Back up\VSR Back up.gdb",
"Target_Adrress_12_10_2018")

BUT, is it possible to change this so that I don't have to specify the date for the out put feature name? So in this example I have 12_10_2018. Is there an option that would automatically change this to the current date? Further is it possible to make this run once a week with out me having to input it?

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

MichaelVolz — Wed, 12 Dec 2018 14:05:47 GMT

You can use pure pythonic modules to get the current date as part of your script and then create a Windows Scheduled Task to run the operation. Just google date and python and you should get plenty of hits. There are also many Windows Scheduled Task geonet threads, so perform a keyword search on that in geonet.

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

JoshuaBixby — Sat, 11 Dec 2021 21:04:09 GMT

>>> import datetime
>>> 
>>> now = datetime.datetime.now()
>>> "Target_Address_{}".format(now.strftime("%m_%d_%Y"))
'Target_Address_12_12_2018'
>>> ‍‍‍‍‍‍

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

VanceRenforth2 — Sat, 11 Dec 2021 21:04:12 GMT

So my entire script should look like this?:

import arcpy
import datetime

now = datetime.datetime.now()
arcpy.env.workspace = "https://services.arcgis.com/T2graiaSQnlmwwmp/arcgis/rest/services/Target_Address_7_6_Backup/FeatureServer"
arcpy.FeatureClassToFeatureClass_conversion("Target Address New",
 "C:\\Users\vmrenfor\Consumers Folders\VSR\BackupExports\VSR Back up\VSR Back up.gdb",
 "Target_Address_{}".format(now.strftime("%m_%d_%Y"))

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

JoshuaBixby — Mon, 17 Dec 2018 15:27:19 GMT

I doubt the code will work because you haven't corrected the Windows path issue. If you correct that, does the run without error and give you what you expect?

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

VanceRenforth2 — Sat, 11 Dec 2021 21:04:14 GMT

I apologize that was the old script. Here is what I am currently looking at:

import arcpy
import datetime

now = datetime.datetime.now()
arcpy.env.workspace = "https://services.arcgis.com/T2graiaSQnlmwwmp/arcgis/rest/services/Target_Address_7_6_Backup/FeatureServer"
arcpy.FeatureClassToFeatureClass_conversion("Target Address New",
 r"C:\\Users\vmrenfor\Consumers Folders\VSR\BackupExports\VSR Back up\VSR Back up.gdb",
 "Target_Address_{}".format(now.strftime("%m_%d_%Y"))

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

JoshuaBixby — Tue, 18 Dec 2018 15:54:54 GMT

Does the code run without error? If it errors, what is the error? If not, does it give you the results you expect?

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

VanceRenforth2 — Tue, 18 Dec 2018 16:06:24 GMT

Here is what I ran and was returned:

import arcpy
import datetime

now = datetime.datetime.now()
arcpy.env.workspace = "https://services.arcgis.com/T2graiaSQnlmwwmp/arcgis/rest/services/Target_Address_7_6_Backup/FeatureServer"
arcpy.FeatureClassToFeatureClass_conversion("Target Address New",
r"C:\Users\vmrenfor\Consumers Folders\VSR\BackupExports\VSR Back up\VSR Back up.gdb",
"Target_Address_{}".format(now.strftime("%m_%d_%Y"))

File "<string>", line 8
"Target_Address_{}".format(now.strftime("%m_%d_%Y"))
^
SyntaxError: unexpected EOF while parsing

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

JoshuaBixby — Tue, 18 Dec 2018 16:25:42 GMT

It looks like you are missing a parentheses at the end of your function call.

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

JakeSkinner — Tue, 18 Dec 2018 18:05:15 GMT

Here is a helpful link on how to post code in GeoNET. It's kind of hidden.

Also, you are specifying a feature service for your workspace:

arcpy.env.workspace = "https://services.arcgis.com/T2graiaSQnlmwwmp/arcgis/rest/services/Target_Address_7_6_Backup‍

If you are specifying a feature class for the first parameter in the Feature Class to Feature Class function, your arcpy.env.workspace should be set to the geodatabase it resides in.

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

VanceRenforth2 — Tue, 18 Dec 2018 19:28:19 GMT

Thanks for the link!

Yes, I am specifying a feature service as the work space because that is where I want to pull from. The layer was created in AGO, so it does not reside in a geodatabase on my computer anywhere.

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

VanceRenforth2 — Tue, 18 Dec 2018 19:32:03 GMT

I added the parentheses at the end on the function and that allowed it script to run. The resulting Feature Class does not contain the attachments though, where as when I ran the script without the date time part the attachments all came through.

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

VanceRenforth2 — Thu, 27 Dec 2018 15:32:38 GMT

Any thoughts?

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

JoshuaBixby — Thu, 27 Dec 2018 17:32:37 GMT

Make sure Maintain Attachments (Environment setting)—Geoprocessing | ArcGIS Desktop is set correctly.

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

VanceRenforth2 — Fri, 04 Jan 2019 17:24:13 GMT

Unfortunately I don't have the "..." option. See my comment screen below.

Re: Python Script to Automate a FC to FC/FGDB opertation ArcGIS Pro

JakeSkinner — Fri, 04 Jan 2019 17:28:52 GMT

Click on the question, and then reply. If you reply in your Inbox, you won't have that option.