POST
|
Raoul: Can you try making 2 modifications to the architecture of this project? 1.)Export your SDE data to a file geodatabase 2.)Modify your data variables to hit the file geodatabase feature classes Run the script and see if you get the same type of error Did you export this from a model? It looks like it because of all the duplicate GIS_USER_CommercalPropertyLi__ entries with different numbers but pointing to the same data source. I would also advice cleaning up these variables to minimize their use. I tried pointing it towards a local source using local variables but still came in with the same error as before. This script was started in a model but that model builder setup is nowhere to be found currently. how would cleaning up the duplicateGIS_USER_CommercalPropertyLi__ entries help this script. What is the point of the currently? Thanks.
... View more
06-19-2014
02:15 PM
|
0
|
0
|
193
|
POST
|
I will give that a try, if not just for testing purposes, and see if that doesn't at least give me a good location to run testing on the broken code. So I tried redirecting to a local drive and still a failure in the code: Preparing in memory data........10% Traceback (most recent call last): File "C:\scripts\PropertyListings\RJC_test\CommercialPropertyImport_V1.2_RJC.py", line 79, in <module> arcpy.TableToTable_conversion(web_forms_dbo_v_GISPropertyImport, in_memory, "brokers", "", "Property \"Property\" true true false 15 Text 0 0 ,First,#,Database Connections\\Webforms@AUBPM01.sde\\dbo.v_GISPropertyImport,Property,-1,-1;ADDRESS \"ADDRESS\" true true false 81 Text 0 0 ,First,#,Database Connections\\Webforms@AUBPM01.sde\web_forms.dbo.v_GISPropertyImport,ADDRESS,-1,-1;Site \"Site\" true true false 4 Long 0 10 ,First,#,Database Connections\\Webforms@AUBPM01.sde\web_forms.dbo.v_GISPropertyImport,Site,-1,-1;Street \"Street\" true true false 50 Text 0 0 ,First,#,Database Connections\\Webforms@AUBPM01.sde\web_forms.dbo.v_GISPropertyImport,Street,-1,-1;PIN \"PIN\" true true false 10 Text 0 0 ,First,#,Database Connections\\Webforms@AUBPM01.sde\web_forms.dbo.v_GISPropertyImport,PIN,-1,-1;Status \"Status\" true true false 50 Text 0 0 ,First,#,Database Connections\\Webforms@AUBPM01.sde\web_forms.dbo.v_GISPropertyImport,Status,-1,-1;Listing \"Listing\" true true false 15 Text 0 0 ,First,#,Database Connections\\Webforms@AUBPM01.sde\web_forms.dbo.v_GISPropertyImport,Listing,-1,-1;Email \"Email\" true true false 50 Text 0 0 ,First,#,Database Connections\\Webforms@AUBPM01.sde\web_forms.dbo.v_GISPropertyImport,Email,-1,-1;Phone \"Phone\" true true false 50 Text 0 0 ,First,#,Database Connections\\Webforms@AUBPM01.sde\web_forms.dbo.v_GISPropertyImport,Phone,-1,-1;Contact \"Contact\" true true false 50 Text 0 0 ,First,#,Database Connections\\Webforms@AUBPM01.sde\web_forms.dbo.v_GISPropertyImport,Contact,-1,-1;Firm \"Firm\" true true false 50 Text 0 0 ,First,#,Database Connections\\Webforms@AUBPM01.sde\web_forms.dbo.v_GISPropertyImport,Firm,-1,-1;Expires \"Expires\" true true false 36 Date 0 0 ,First,#,Database Connections\\Webforms@AUBPM01.sde\web_forms.dbo.v_GISPropertyImport,Expires,-1,-1;Requested \"Requested\" true true false 36 Date 0 0 ,First,#,Database Connections\\Webforms@AUBPM01.sde\web_forms.dbo.v_GISPropertyImport,Requested,-1,-1;Link \"Link\" true true false 300 Text 0 0 ,First,#,Database Connections\\Webforms@AUBPM01.sde\web_forms.dbo.v_GISPropertyImport,Link,-1,-1", "") File "D:\Program Files (x86)\ArcGIS\Desktop10.2\arcpy\arcpy\conversion.py", line 2042, in TableToTable raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Input Rows: Dataset C:\Test\web_forms.dbo.dbf does not exist or is not supported Failed to execute (TableToTable). Thoughts??
... View more
06-17-2014
01:31 PM
|
0
|
0
|
193
|
POST
|
I am still very new to python and very much learning on the fly. I am trying to create and email a excel spread sheet of various layers in a SDE db. I am doing this because we have multiple users editing and creating new layers and to QA QC all of, we can sort by certain fields and time stamps. I have been able to create a log for one particular feature data set but would like to ultimately have this file monitor about 17 more files within this SDE db system. The code is below. in this instance the fields of interest are: sde_master.GIS_USER.AccessPoints.OBJECTID #; sde_master.GIS_USER.AccessPoints.CREATEDBY #; sde_master.GIS_USER.AccessPoints.CREATEDDATE #; sde_master.GIS_USER.AccessPoints.EDITEDBY #; sde_master.GIS_USER.AccessPoints.EDITEDDATE How would I modify this script below to track and monitor certain fields(not necessarily the ones above) and have those results emailed to me in a condensed spread sheet. A multi page excel work book with each tab representing a various SDE layer would be optimal. Thank you in advance: Raoul # Import arcpy module import arcpy import time # Set the Date Date = time.strftime("%m-%d-%Y", time.localtime()) # Set the time Time = time.strftime("%I:%M:%S %p", time.localtime()) # Set Environment Variables arcpy.env.overwriteOutput = True print "Process started at " + str(Date) + " " + str(Time) + "." + "\n" #Log File Start Time # Set up the log file. LogFile = file('C:\\Temp\\Esri_anon' + '.txt', 'w') #Creates a log file with todays date. output = open('C:\\Temp\\EsrianonLog' + '.txt', 'w') #Path to log file. output.write(str("Process started at " + str(Date) + " " + str(Time) + "." + "\n")) # Write the start time to the log file. # Local variables: Input_Tables = "'Database Connections\\gis_ims@sde_master.sde\\sde_master.GIS_USER.CommunicationNetwork\\sde_master.GIS_USER.AccessPoints'" QueryTable = "QueryTable" QueryTable_View = "QueryTable_View" new_xls = "E:\\GIS\\RJC\\GeoProccessing\\20140612\\new.xls" # Process: Make Query Table arcpy.MakeQueryTable_management(Input_Tables, QueryTable, "USE_KEY_FIELDS", "", "sde_master.GIS_USER.AccessPoints.OBJECTID #;sde_master.GIS_USER.AccessPoints.CREATEDBY #;sde_master.GIS_USER.AccessPoints.CREATEDDATE #;sde_master.GIS_USER.AccessPoints.EDITEDBY #;sde_master.GIS_USER.AccessPoints.EDITEDDATE #", "EDITEDBY in( 'Esri_Anonymous') AND EDITEDDATE >= GetDate()-14") # Process: Make Table View arcpy.MakeTableView_management(QueryTable, QueryTable_View, "", "", "sde_master.GIS_USER.AccessPoints.OBJECTID sde_master.GIS_USER.AccessPoints.OBJECTID VISIBLE NONE;sde_master.GIS_USER.AccessPoints.CREATEDBY sde_master.GIS_USER.AccessPoints.CREATEDBY VISIBLE NONE;sde_master.GIS_USER.AccessPoints.CREATEDDATE sde_master.GIS_USER.AccessPoints.CREATEDDATE VISIBLE NONE;sde_master.GIS_USER.AccessPoints.EDITEDBY sde_master.GIS_USER.AccessPoints.EDITEDBY VISIBLE NONE;sde_master.GIS_USER.AccessPoints.EDITEDDATE sde_master.GIS_USER.AccessPoints.EDITEDDATE VISIBLE NONE;sde_master_GIS_USER_AccessPoints_CREATEDBY sde_master_GIS_USER_AccessPoints_CREATEDBY VISIBLE NONE;sde_master_GIS_USER_AccessPoints_CREATEDDATE sde_master_GIS_USER_AccessPoints_CREATEDDATE VISIBLE NONE;sde_master_GIS_USER_AccessPoints_EDITEDBY sde_master_GIS_USER_AccessPoints_EDITEDBY VISIBLE NONE;sde_master_GIS_USER_AccessPoints_EDITEDDATE sde_master_GIS_USER_AccessPoints_EDITEDDATE VISIBLE NONE") # Process: Table To Excel arcpy.TableToExcel_conversion(QueryTable_View, new_xls, "ALIAS", "DESCRIPTION") print "Process Successful Completed at" + str(Date)+" " + str(Time) + "." # Sets the Date & Time since the script Ended. Date = time.strftime("%m-%d-%Y", time.localtime())# Set the date. Time = time.strftime("%I:%M:%S %p", time.localtime()) # Set the time. output.write(str("Process completed at " + str(Date) + " " + str(Time) + "." + "\n")) # Write end time to the log output.write(str("\n" + " !!!!!!!!!!!!!!!!Import Sucessful!!!!!!!!!!!!!!!!!!!")) output.close() # Closes the log file. print "!!!Records exported!!!!" #End of program
... View more
06-13-2014
03:25 PM
|
0
|
0
|
342
|
POST
|
I am still very new to python and very much learning on the fly. I am trying to create and email a excel spread sheet of various layers in a SDE db. I am doing this because we have multiple users editing and creating new layers and to QA QC all of, we can sort by certain fields and time stamps. I have been able to create a log for one particular feature data set but would like to ultimately have this file monitor about 17 more files within this SDE db system. The code is below. in this instance the fields of interest are: sde_master.GIS_USER.AccessPoints.OBJECTID #; sde_master.GIS_USER.AccessPoints.CREATEDBY #; sde_master.GIS_USER.AccessPoints.CREATEDDATE #; sde_master.GIS_USER.AccessPoints.EDITEDBY #; sde_master.GIS_USER.AccessPoints.EDITEDDATE How would I modify this script below to track and monitor certain fields(not necessarily the ones above) and have those results emailed to me in a condensed spread sheet. A multi page excel work book with each tab representing a various SDE layer would be optimal. Thank you in advance: Raoul # Import arcpy module import arcpy import time # Set the Date Date = time.strftime("%m-%d-%Y", time.localtime()) # Set the time Time = time.strftime("%I:%M:%S %p", time.localtime()) # Set Environment Variables arcpy.env.overwriteOutput = True print "Process started at " + str(Date) + " " + str(Time) + "." + "\n" #Log File Start Time # Set up the log file. LogFile = file('C:\\Temp\\Esri_anon' + '.txt', 'w') #Creates a log file with todays date. output = open('C:\\Temp\\EsrianonLog' + '.txt', 'w') #Path to log file. output.write(str("Process started at " + str(Date) + " " + str(Time) + "." + "\n")) # Write the start time to the log file. # Local variables: Input_Tables = "'Database Connections\\gis_ims@sde_master.sde\\sde_master.GIS_USER.CommunicationNetwork\\sde_master.GIS_USER.AccessPoints'" QueryTable = "QueryTable" QueryTable_View = "QueryTable_View" new_xls = "E:\\GIS\\RJC\\GeoProccessing\\20140612\\new.xls" # Process: Make Query Table arcpy.MakeQueryTable_management(Input_Tables, QueryTable, "USE_KEY_FIELDS", "", "sde_master.GIS_USER.AccessPoints.OBJECTID #;sde_master.GIS_USER.AccessPoints.CREATEDBY #;sde_master.GIS_USER.AccessPoints.CREATEDDATE #;sde_master.GIS_USER.AccessPoints.EDITEDBY #;sde_master.GIS_USER.AccessPoints.EDITEDDATE #", "EDITEDBY in( 'Esri_Anonymous') AND EDITEDDATE >= GetDate()-14") # Process: Make Table View arcpy.MakeTableView_management(QueryTable, QueryTable_View, "", "", "sde_master.GIS_USER.AccessPoints.OBJECTID sde_master.GIS_USER.AccessPoints.OBJECTID VISIBLE NONE;sde_master.GIS_USER.AccessPoints.CREATEDBY sde_master.GIS_USER.AccessPoints.CREATEDBY VISIBLE NONE;sde_master.GIS_USER.AccessPoints.CREATEDDATE sde_master.GIS_USER.AccessPoints.CREATEDDATE VISIBLE NONE;sde_master.GIS_USER.AccessPoints.EDITEDBY sde_master.GIS_USER.AccessPoints.EDITEDBY VISIBLE NONE;sde_master.GIS_USER.AccessPoints.EDITEDDATE sde_master.GIS_USER.AccessPoints.EDITEDDATE VISIBLE NONE;sde_master_GIS_USER_AccessPoints_CREATEDBY sde_master_GIS_USER_AccessPoints_CREATEDBY VISIBLE NONE;sde_master_GIS_USER_AccessPoints_CREATEDDATE sde_master_GIS_USER_AccessPoints_CREATEDDATE VISIBLE NONE;sde_master_GIS_USER_AccessPoints_EDITEDBY sde_master_GIS_USER_AccessPoints_EDITEDBY VISIBLE NONE;sde_master_GIS_USER_AccessPoints_EDITEDDATE sde_master_GIS_USER_AccessPoints_EDITEDDATE VISIBLE NONE") # Process: Table To Excel arcpy.TableToExcel_conversion(QueryTable_View, new_xls, "ALIAS", "DESCRIPTION") print "Process Successful Completed at" + str(Date)+" " + str(Time) + "." # Sets the Date & Time since the script Ended. Date = time.strftime("%m-%d-%Y", time.localtime())# Set the date. Time = time.strftime("%I:%M:%S %p", time.localtime()) # Set the time. output.write(str("Process completed at " + str(Date) + " " + str(Time) + "." + "\n")) # Write end time to the log output.write(str("\n" + " !!!!!!!!!!!!!!!!Import Sucessful!!!!!!!!!!!!!!!!!!!")) output.close() # Closes the log file. print "!!!Records exported!!!!" #End of program
... View more
06-13-2014
11:23 AM
|
0
|
0
|
264
|
POST
|
Raoul: Can you try making 2 modifications to the architecture of this project? 1.)Export your SDE data to a file geodatabase 2.)Modify your data variables to hit the file geodatabase feature classes Run the script and see if you get the same type of error Did you export this from a model? It looks like it because of all the duplicate GIS_USER_CommercalPropertyLi__ entries with different numbers but pointing to the same data source. I would also advice cleaning up these variables to minimize their use. I will give that a try, if not just for testing purposes, and see if that doesn't at least give me a good location to run testing on the broken code.
... View more
06-10-2014
01:36 PM
|
0
|
0
|
193
|
POST
|
Any way you can post the error message? Yes, I will re post the error shortly.
... View more
06-09-2014
02:28 PM
|
0
|
0
|
202
|
POST
|
That helps immensely. I will try that out and see if I have any luck know. Thank you for the insight. I tried using the full SDE link but still, no go. ExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Input Rows: Dataset \\aubpm02\c$\Users\administrator.COA\AppData\Roaming\ESRI\Desktop10.2\ArcCatalog\Webforms@AUBPM01.sde\web_forms.dbo.v_GISPropertyImport does not exist or is not supported Failed to execute (TableToTable).
... View more
06-09-2014
02:15 PM
|
0
|
0
|
653
|
POST
|
I think you need the full path to the SDE connection file in your script. If you are running on Windows 7 or Windows Server 2008, then the path would be something like: c:\Users\"User Name"\AppData\Roaming\ESRI\Desktop10.2\ArcCatalog\ + Webforms@AUBPM01.sde\web_forms.dbo.v_GIS I know that in my scripts when I migrated from v10.0 to v10.2 (I skipped v10.1), the python scripts now needed the full path to the SDE connection files. That helps immensely. I will try that out and see if I have any luck know. Thank you for the insight.
... View more
06-09-2014
09:48 AM
|
0
|
0
|
653
|
POST
|
Hello all, I am still relatively new to python and trying to troubleshoot these automated python codes as much as a I can but to no avail. I have the script that is supposed to run twice daily and import data from a webform and place it into a layer in our SDE master db. please let me know what errors you see in the line of code below. Thank you in advance. Raoul
... View more
06-06-2014
02:00 PM
|
0
|
12
|
1097
|
POST
|
Hello, So this was an automated parcel importer process from the county that supposedly worked just fine before our upgrade to 10.2. I am very new to learning Python but the error I was getting didn't seem to be Syntax related. If anybody has any thoughts on how I can correct the code attached, thank you in advance and I will ship you a beer or three for your help. Raoul
... View more
06-06-2014
12:04 PM
|
0
|
2
|
517
|
Online Status |
Offline
|
Date Last Visited |
11-11-2020
02:23 AM
|