Advertisement
Guest User

Untitled

a guest
Mar 8th, 2017
175
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.50 KB | None | 0 0
  1. ERROR 000732: Input Features: Dataset
  2. \My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdbCon‌​tacts
  3. does not exist or is not supported Failed to execute (MakeFeatureLayer)
  4.  
  5. import arcpy, os
  6.  
  7. contacts = r'\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdbContacts'
  8. comTrkr = r'\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdbComTrkr'
  9. GISTrkr = r'\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdbGISTrkr'
  10.  
  11. gdb = "\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdb"
  12. arcpy.MakeTableView_management(contacts,"Contacts_tbl")
  13.  
  14. arcpy.MakeTableView_management(contacts,"Contacts_tbl")
  15. arcpy.env.overwriteOutput=True
  16.  
  17. #arcpy.Selectbyattribute. All Null Updated to New
  18.  
  19. #Selectbyattribute QA/QC output table Contact_Status1
  20. arcpy.SelectLayerByAttribute_management("Contacts_tbl", "NEW_SELECTION", "Contact_Status1 IS NULL" )
  21. arcpy.CalculateField_management("Contacts_tbl", "Contact_Status1", '"NEW"' )
  22. #arcpy.SelectLayerByAttribute_management(in_table, "CLEAR_SELECTION") needed?
  23.  
  24. #Create output table to edit in Arcmap for Both Email fields
  25. Contact_Email_Output = os.path.join(gdb,os.path.basename(gdb) + '_Contact_Email')
  26. arcpy.SelectLayerByAttribute_management("contacts", "NEW_SELECTION", "Contact_Email LIKE '%@%'" )
  27. arcpy.CopyRows_management("Contacts_tbl", Contact_Email_Output)
  28. #arcpy.AddField_management(Contact_Email_Output, "Editor", "TEXT")
  29. #arcpy.EnableEditorTracking_management(Contact_Email_Output,'','','','ET_Date', "ADD_FIELDS")
  30.  
  31. arcpy.AddMessage("Contact_Email Table created, now on to Agency_Email")
  32.  
  33. Agency_Email_Output = os.path.join(gdb,os.path.basename(gdb) + '_Agency_Email')
  34. arcpy.SelectLayerByAttribute_management("contacts", "NEW_SELECTION", "FROM contacts WHERE Agency_Email IS LIKE %@% " )
  35. arcpy.CopyRows_management("Contacts_tbl", Agency_Email_Output)
  36. #arcpy.AddField_management(Contact_Email_Output, "Editor", "TEXT")
  37. #arcpy.EnableEditorTracking_management(Agency_Email_Output,'','','','ET_Date', "ADD_FIELDS")
  38.  
  39. #String length for phone number.
  40. Contact_Phone_Work_Output = os.path.join(gdb,os.path.basename(gdb) + '_Contact_Phone_Work_Email')
  41. arcpy.SelectLayerByAttribute_management("contacts", "Contact_Phone_Work", "NEW_SELECTION", "FROM contacts WHERE LEN([Contact_Phone_Work]) = 12")
  42. arcpy.SelectLayerByAttribute_management("contacts", "Contact_Phone_Work", "NEW_SELECTION", "FROM contacts WHERE Contact_Phone_Work IS LIKE '%-%' ")
  43. arcpy.CopyRows_management("Contacts_tbl", Contact_Phone_Work_Output)
  44.  
  45. Agency_Phone_Email_Output = os.path.join(gdb,os.path.basename(gdb) + '_Agency_Phone_Email')
  46. arcpy.SelectLayerByAttribute_management("contacts", "Contact_Phone_Work", "NEW_SELECTION", "FROM contacts WHERE LEN(Agency_Phone_Work) = 12")
  47. arcpy.SelectLayerByAttribute_management("contacts", "Contact_Phone_Work", "ADD_SELECTION", "FROM contacts WHERE Agency_Phone_Work IS LIKE '%-%' ")
  48. arcpy.CopyRows_management("Contacts_tbl", Agency_Phone_Output)
  49.  
  50. gdb = r"\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdb"
  51. arcpy.MakeTableView_management(contacts,"Contacts_Lyr")
  52.  
  53. import arcpy, os
  54.  
  55. contacts = r'\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdbContacts'
  56. comTrkr = r'\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdbComTrkr'
  57. GISTrkr = r'\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdbGISTrkr'
  58. gdb = r"\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdb"
  59.  
  60. arcpy.env.overwriteOutput=True
  61.  
  62. contactsTblVw = arcpy.MakeTableView_management(contacts,"Contacts_tbl")
  63.  
  64. #arcpy.Selectbyattribute. All Null Updated to New
  65. #Selectbyattribute QA/QC output table Contact_Status1
  66. arcpy.SelectLayerByAttribute_management(contactsTblVw, "NEW_SELECTION", "Contact_Status1 IS NULL" )
  67. arcpy.CalculateField_management(contactsTblVw, "Contact_Status1", '"NEW"' )
  68.  
  69. #Create output table to edit in Arcmap for Both Email fields
  70. Contact_Email_Output = os.path.join(gdb, 'Export_Contact_Email') # To produce output named \My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdbExport_Contact_Email
  71. arcpy.SelectLayerByAttribute_management(contactsTblVw, "NEW_SELECTION", "Contact_Email LIKE '%@%'" )
  72. arcpy.CopyRows_management(contactsTblVw, Contact_Email_Output)
  73. #arcpy.AddField_management(Contact_Email_Output, "Editor", "TEXT")
  74. #arcpy.EnableEditorTracking_management(Contact_Email_Output,'','','','ET_Date', "ADD_FIELDS")
  75.  
  76. arcpy.AddMessage("Contact_Email Table created, now on to Agency_Email")
  77.  
  78. Agency_Email_Output = os.path.join(gdb, 'Export_Agency_Email')
  79. arcpy.SelectLayerByAttribute_management(contactsTblVw, "NEW_SELECTION", "FROM contacts WHERE Agency_Email LIKE %@% " )
  80. arcpy.CopyRows_management(contactsTblVw, Agency_Email_Output)
  81. #arcpy.AddField_management(Contact_Email_Output, "Editor", "TEXT")
  82. #arcpy.EnableEditorTracking_management(Agency_Email_Output,'','','','ET_Date', "ADD_FIELDS")
  83.  
  84. #String length for phone number.
  85. Contact_Phone_Work_Output = os.path.join(gdb, 'Export_Contact_Phone_Work_Email')
  86. arcpy.SelectLayerByAttribute_management(contactsTblVw, "NEW_SELECTION", "FROM contacts WHERE LEN([Contact_Phone_Work]) = 12")
  87. arcpy.SelectLayerByAttribute_management(contactsTblVw, "ADD_TO_SELECTION", "FROM contacts WHERE Contact_Phone_Work LIKE '%-%' ")
  88. arcpy.CopyRows_management(contactsTblVw, Contact_Phone_Work_Output)
  89.  
  90. Agency_Phone_Email_Output = os.path.join(gdb, 'Export_Agency_Phone_Email')
  91. arcpy.SelectLayerByAttribute_management(contactsTblVw, "NEW_SELECTION", "FROM contacts WHERE LEN(Agency_Phone_Work) = 12")
  92. arcpy.SelectLayerByAttribute_management(contactsTblVw, "ADD_TO_SELECTION", "FROM contacts WHERE Agency_Phone_Work LIKE '%-%' ")
  93. arcpy.CopyRows_management(contactsTblVw, Agency_Phone_Output)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement