I keep receiving the following error whenever running the following code below, is it the pathname that is incorrect or is it the actual function MakeTableView?
Traceback (most recent call last): File "\ServerName\UserHome$\user.name\My Documents\Contacts Table Clean Up.py", line 23, in arcpy.MakeTableView_management(contacts,"Contacts_tbl") File "c:\program files (x86)\arcgis\desktop10.3\arcpy\arcpy\management.py", line 7047, in MakeTableView raise e ExecuteError: Failed to execute. Parameters are not valid. ERROR 000732: Input Table: Dataset C:\ServerName\UserHome$\user.name\My Documents\ArcGIS\Projects\Contact_Table_CleanUp\Test.gdb\Contacts does not exist or is not supported Failed to execute (MakeTableView).
import arcpy, os
contacts = r'C:\\ServerName\UserHome$\user.name\My Documents\ArcGIS\Projects\Contact_Table_CleanUp\Test.gdb\Contacts'
comTrkr = r'C:\\ServerName\UserHome$\user.name\My Documents\ArcGIS\Projects\Contact_Table_CleanUp\Test.gdb\ComTrkr'
GISTrkr = r'C:\\ServerName\UserHome$\user.name\My Documents\ArcGIS\Projects\Contact_Table_CleanUp\Test.gdb\GISTrkr'
gdb = r'C:\\ServerName\UserHome$\user.name\My Documents\ArcGIS\Projects\Contact_Table_CleanUp\Test.gdb'
arcpy.env.overwriteOutput=True
arcpy.MakeTableView_management(contacts,"Contacts_tbl")
contactsTblVw = "Contacts_tbl"
contactsTblVw = arcpy.MakeTableView_management(contacts,"Contacts_tbl")
#Update Contact_Status1 with'New' if value equals 'NULL'
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 Documents\ArcGIS\Projects\Contact_Table_CleanUp\Test.gdb\Export_Contact_Email
arcpy.SelectLayerByAttribute_management(contactsTblVw, "NEW_SELECTION", "Contact_Email LIKE '%@%'" )
arcpy.CopyRows_management(contactsTblVw, Contact_Email_Output)
contactsTblVw = arcpy.MakeTableView_management(contacts,"Contacts_tbl")
#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_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)