Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ERROR 000732: Input Features: Dataset
- \My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdbContacts
- does not exist or is not supported Failed to execute (MakeFeatureLayer)
- import arcpy, os
- contacts = r'\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdbContacts'
- comTrkr = r'\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdbComTrkr'
- GISTrkr = r'\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdbGISTrkr'
- gdb = "\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdb"
- arcpy.MakeTableView_management(contacts,"Contacts_tbl")
- arcpy.MakeTableView_management(contacts,"Contacts_tbl")
- arcpy.env.overwriteOutput=True
- #arcpy.Selectbyattribute. All Null Updated to New
- #Selectbyattribute QA/QC output table Contact_Status1
- arcpy.SelectLayerByAttribute_management("Contacts_tbl", "NEW_SELECTION", "Contact_Status1 IS NULL" )
- arcpy.CalculateField_management("Contacts_tbl", "Contact_Status1", '"NEW"' )
- #arcpy.SelectLayerByAttribute_management(in_table, "CLEAR_SELECTION") needed?
- #Create output table to edit in Arcmap for Both Email fields
- Contact_Email_Output = os.path.join(gdb,os.path.basename(gdb) + '_Contact_Email')
- arcpy.SelectLayerByAttribute_management("contacts", "NEW_SELECTION", "Contact_Email LIKE '%@%'" )
- arcpy.CopyRows_management("Contacts_tbl", Contact_Email_Output)
- #arcpy.AddField_management(Contact_Email_Output, "Editor", "TEXT")
- #arcpy.EnableEditorTracking_management(Contact_Email_Output,'','','','ET_Date', "ADD_FIELDS")
- arcpy.AddMessage("Contact_Email Table created, now on to Agency_Email")
- Agency_Email_Output = os.path.join(gdb,os.path.basename(gdb) + '_Agency_Email')
- arcpy.SelectLayerByAttribute_management("contacts", "NEW_SELECTION", "FROM contacts WHERE Agency_Email IS LIKE %@% " )
- arcpy.CopyRows_management("Contacts_tbl", Agency_Email_Output)
- #arcpy.AddField_management(Contact_Email_Output, "Editor", "TEXT")
- #arcpy.EnableEditorTracking_management(Agency_Email_Output,'','','','ET_Date', "ADD_FIELDS")
- #String length for phone number.
- Contact_Phone_Work_Output = os.path.join(gdb,os.path.basename(gdb) + '_Contact_Phone_Work_Email')
- arcpy.SelectLayerByAttribute_management("contacts", "Contact_Phone_Work", "NEW_SELECTION", "FROM contacts WHERE LEN([Contact_Phone_Work]) = 12")
- arcpy.SelectLayerByAttribute_management("contacts", "Contact_Phone_Work", "NEW_SELECTION", "FROM contacts WHERE Contact_Phone_Work IS LIKE '%-%' ")
- arcpy.CopyRows_management("Contacts_tbl", Contact_Phone_Work_Output)
- Agency_Phone_Email_Output = os.path.join(gdb,os.path.basename(gdb) + '_Agency_Phone_Email')
- arcpy.SelectLayerByAttribute_management("contacts", "Contact_Phone_Work", "NEW_SELECTION", "FROM contacts WHERE LEN(Agency_Phone_Work) = 12")
- arcpy.SelectLayerByAttribute_management("contacts", "Contact_Phone_Work", "ADD_SELECTION", "FROM contacts WHERE Agency_Phone_Work IS LIKE '%-%' ")
- arcpy.CopyRows_management("Contacts_tbl", Agency_Phone_Output)
- gdb = r"\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdb"
- arcpy.MakeTableView_management(contacts,"Contacts_Lyr")
- import arcpy, os
- contacts = r'\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdbContacts'
- comTrkr = r'\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdbComTrkr'
- GISTrkr = r'\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdbGISTrkr'
- gdb = r"\My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdb"
- arcpy.env.overwriteOutput=True
- contactsTblVw = arcpy.MakeTableView_management(contacts,"Contacts_tbl")
- #arcpy.Selectbyattribute. All Null Updated to New
- #Selectbyattribute QA/QC output table Contact_Status1
- arcpy.SelectLayerByAttribute_management(contactsTblVw, "NEW_SELECTION", "Contact_Status1 IS NULL" )
- arcpy.CalculateField_management(contactsTblVw, "Contact_Status1", '"NEW"' )
- #Create output table to edit in Arcmap for Both Email fields
- Contact_Email_Output = os.path.join(gdb, 'Export_Contact_Email') # To produce output named \My DocumentsArcGISProjectsContact_Table_CleanUpTest.gdbExport_Contact_Email
- arcpy.SelectLayerByAttribute_management(contactsTblVw, "NEW_SELECTION", "Contact_Email LIKE '%@%'" )
- arcpy.CopyRows_management(contactsTblVw, Contact_Email_Output)
- #arcpy.AddField_management(Contact_Email_Output, "Editor", "TEXT")
- #arcpy.EnableEditorTracking_management(Contact_Email_Output,'','','','ET_Date', "ADD_FIELDS")
- arcpy.AddMessage("Contact_Email Table created, now on to Agency_Email")
- Agency_Email_Output = os.path.join(gdb, 'Export_Agency_Email')
- arcpy.SelectLayerByAttribute_management(contactsTblVw, "NEW_SELECTION", "FROM contacts WHERE Agency_Email LIKE %@% " )
- arcpy.CopyRows_management(contactsTblVw, Agency_Email_Output)
- #arcpy.AddField_management(Contact_Email_Output, "Editor", "TEXT")
- #arcpy.EnableEditorTracking_management(Agency_Email_Output,'','','','ET_Date', "ADD_FIELDS")
- #String length for phone number.
- Contact_Phone_Work_Output = os.path.join(gdb, 'Export_Contact_Phone_Work_Email')
- arcpy.SelectLayerByAttribute_management(contactsTblVw, "NEW_SELECTION", "FROM contacts WHERE LEN([Contact_Phone_Work]) = 12")
- arcpy.SelectLayerByAttribute_management(contactsTblVw, "ADD_TO_SELECTION", "FROM contacts WHERE Contact_Phone_Work LIKE '%-%' ")
- arcpy.CopyRows_management(contactsTblVw, Contact_Phone_Work_Output)
- Agency_Phone_Email_Output = os.path.join(gdb, 'Export_Agency_Phone_Email')
- arcpy.SelectLayerByAttribute_management(contactsTblVw, "NEW_SELECTION", "FROM contacts WHERE LEN(Agency_Phone_Work) = 12")
- arcpy.SelectLayerByAttribute_management(contactsTblVw, "ADD_TO_SELECTION", "FROM contacts WHERE Agency_Phone_Work LIKE '%-%' ")
- arcpy.CopyRows_management(contactsTblVw, Agency_Phone_Output)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement