Hello. I have created a custom ArcGIS tool, and need to automate this tool so that it can be scheduled to run weekly outside of ArcMap. Right now, I have a version of the tool that runs inside of an ArcMap session, with the input table and target feature class as user defined parameters. Here is the code that I have so far. My Try/Except block is commented out for testing purposes. The goal is that the script will join an SDE view table to a GDB feature class, select based on some criteria, calculate some fields, than remove the join. Works great as a tool, but getting it to work outside of that has proven impossible so far. Thanks for any help! import arcpy , sys , string , os , subprocess gca = vca = "Conservation_Area_Name" gcn = vcn = "Conservation_Area_Number" gn = vn = "Network" gfi = "Field_ID" gai = "Asset_ID" gt1n = "Tier_1_System_Name" gt1t = "Tier_1_System_Type" gt2n = "Tier_2_Major_Subsystem_Name" gt2t = "Tier_2_Major_Subsystem_Type" gt3n = "Tier_3_Minor_Subsystem_Name" gt3t = "Tier_3_Minor_Subsystem_Type" gt4n = "Asset_Name" vfi = "FieldID" vai = "AssetID" vt1n = "Tier_1_Name" vt1t = "Tier_1_Type" vt2n = "Tier_2_Name" vt2t = "Tier_2_Type" vt3n = "Tier_3_Name" vt3t = "Tier_3_Type" vt4n = "Tier_4_Name" gdfcin = r 'C:\Projects\MDC\DataUpdate_20180315\MDC_PhysModel_FieldID_20180315.gdb\Exterior_Electrical\Phase_Converter_Exterior' gdfc = gdfcin . split ( '\\' ) [ - 1 ] vwfcin = r 'C:\Users\rbasaria\AppData\Roaming\ESRI\Desktop10.4\ArcCatalog\MDCTest_1025.sde\MDCTest_1025.dbo.ViewETL_FacilityType_PhaseConverterExterior' vwfc = vwfcin . split ( '\\' ) [ - 1 ] slct = gdfc + "." + gai + " IS NULL OR (" + gdfc + "." + gai + " <> " + vwfc + "." + vai + ")" #try: arcpy . AddJoin_management ( gdfcin , gfi , vwfcin , vfi ) arcpy . SelectLayerByAttribute_management ( gdfcin , "NEW_SELECTION" , slct ) arcpy . CalculateField_management ( gdfcin , gdfc + "." + gai , "[" + vwfc + "." + vai + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfcin , gdfc + "." + gca , "[" + vwfc + "." + vca + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfcin , gdfc + "." + gcn , "[" + vwfc + "." + vcn + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfcin , gdfc + "." + gn , "[" + vwfc + "." + vn + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfcin , gdfc + "." + gt1n , "[" + vwfc + "." + vt1n + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfcin , gdfc + "." + gt1t , "[" + vwfc + "." + vt1t + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfcin , gdfc + "." + gt2n , "[" + vwfc + "." + vt2n + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfcin , gdfc + "." + gt2t , "[" + vwfc + "." + vt2t + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfcin , gdfc + "." + gt3n , "[" + vwfc + "." + vt3n + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfcin , gdfc + "." + gt3t , "[" + vwfc + "." + vt3t + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfcin , gdfc + "." + gt4n , "[" + vwfc + "." + vt4n + "]" , "VB" , "" ) #except: # print arcpy.GetMessages() arcpy . RemoveJoin_management ( gdfcin ) arcpy . SelectLayerByAttribute_management ( gdfcin , "CLEAR_SELECTION" , "" )

Well, it looks like its working now! Combination of the Make Feature Layer and Make Table View got this thing grabbing the right data, then I had an issue with my slct variable (which I know works)...which turned out to be the vwfc variable not having the "MDCTest_1025.dbo.ViewETL_FacilityType_" info before the table name. Appreciate all the help, and its always a good day when I can learn something new! import arcpy , sys , string , os , subprocess gca = vca = "Conservation_Area_Name" gcn = vcn = "Conservation_Area_Number" gn = vn = "Network" gfi = "Field_ID" gai = "Asset_ID" gt1n = "Tier_1_System_Name" gt1t = "Tier_1_System_Type" gt2n = "Tier_2_Major_Subsystem_Name" gt2t = "Tier_2_Major_Subsystem_Type" gt3n = "Tier_3_Minor_Subsystem_Name" gt3t = "Tier_3_Minor_Subsystem_Type" gt4n = "Asset_Name" vfi = "FieldID" vai = "AssetID" vt1n = "Tier_1_Name" vt1t = "Tier_1_Type" vt2n = "Tier_2_Name" vt2t = "Tier_2_Type" vt3n = "Tier_3_Name" vt3t = "Tier_3_Type" vt4n = "Tier_4_Name" gdfc = "Phase_Converter_Exterior" gdfcin = arcpy . MakeFeatureLayer_management ( r 'C:\Projects\MDC\DataUpdate_20180315\MDC_PhysModel_FieldID_20180315.gdb\Exterior_Electrical\Phase_Converter_Exterior' , gdfc ) vwfc = "MDCTest_1025.dbo.ViewETL_FacilityType_PhaseConverterExterior" vwfcin = arcpy . MakeTableView_management ( r 'C:\Users\rbasaria\AppData\Roaming\ESRI\Desktop10.4\ArcCatalog\MDCTest_1025.sde\MDCTest_1025.dbo.ViewETL_FacilityType_PhaseConverterExterior' , vwfc ) slct = gdfc + "." + gai + " IS NULL OR (" + gdfc + "." + gai + " <> " + vwfc + "." + vai + ")" #try: arcpy . AddJoin_management ( gdfc , gfi , vwfc , vfi ) arcpy . SelectLayerByAttribute_management ( gdfc , "NEW_SELECTION" , slct ) arcpy . CalculateField_management ( gdfc , gdfc + "." + gai , "[" + vwfc + "." + vai + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfc , gdfc + "." + gca , "[" + vwfc + "." + vca + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfc , gdfc + "." + gcn , "[" + vwfc + "." + vcn + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfc , gdfc + "." + gn , "[" + vwfc + "." + vn + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfc , gdfc + "." + gt1n , "[" + vwfc + "." + vt1n + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfc , gdfc + "." + gt1t , "[" + vwfc + "." + vt1t + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfc , gdfc + "." + gt2n , "[" + vwfc + "." + vt2n + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfc , gdfc + "." + gt2t , "[" + vwfc + "." + vt2t + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfc , gdfc + "." + gt3n , "[" + vwfc + "." + vt3n + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfc , gdfc + "." + gt3t , "[" + vwfc + "." + vt3t + "]" , "VB" , "" ) arcpy . CalculateField_management ( gdfc , gdfc + "." + gt4n , "[" + vwfc + "." + vt4n + "]" , "VB" , "" ) #except: # print arcpy.GetMessages() arcpy . RemoveJoin_management ( gdfc ) arcpy . SelectLayerByAttribute_management ( gdfc , "CLEAR_SELECTION" , "" )

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Automating custom Arc Tool

Anonymous User

Hello.

I have created a custom ArcGIS tool, and need to automate this tool so that it can be scheduled to run weekly outside of ArcMap.

Right now, I have a version of the tool that runs inside of an ArcMap session, with the input table and target feature class as user defined parameters.

Here is the code that I have so far.

My Try/Except block is commented out for testing purposes.

The goal is that the script will join an SDE view table to a GDB feature class, select based on some criteria, calculate some fields, than remove the join. Works great as a tool, but getting it to work outside of that has proven impossible so far.

Thanks for any help!

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> sys<SPAN class="punctuation token">,</SPAN> string<SPAN class="punctuation token">,</SPAN> os<SPAN class="punctuation token">,</SPAN> subprocess

gca <SPAN class="operator token">=</SPAN> vca <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Conservation_Area_Name"</SPAN>
gcn <SPAN class="operator token">=</SPAN> vcn <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Conservation_Area_Number"</SPAN>
gn <SPAN class="operator token">=</SPAN> vn <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Network"</SPAN>

gfi <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Field_ID"</SPAN>
gai <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Asset_ID"</SPAN>
gt1n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_1_System_Name"</SPAN>
gt1t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_1_System_Type"</SPAN>
gt2n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_2_Major_Subsystem_Name"</SPAN>
gt2t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_2_Major_Subsystem_Type"</SPAN>
gt3n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_3_Minor_Subsystem_Name"</SPAN>
gt3t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_3_Minor_Subsystem_Type"</SPAN>
gt4n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Asset_Name"</SPAN>

vfi <SPAN class="operator token">=</SPAN> <SPAN class="string token">"FieldID"</SPAN>
vai <SPAN class="operator token">=</SPAN> <SPAN class="string token">"AssetID"</SPAN>
vt1n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_1_Name"</SPAN>
vt1t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_1_Type"</SPAN>
vt2n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_2_Name"</SPAN>
vt2t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_2_Type"</SPAN>
vt3n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_3_Name"</SPAN>
vt3t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_3_Type"</SPAN>
vt4n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_4_Name"</SPAN>

gdfcin <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Projects\MDC\DataUpdate_20180315\MDC_PhysModel_FieldID_20180315.gdb\Exterior_Electrical\Phase_Converter_Exterior'</SPAN>
gdfc <SPAN class="operator token">=</SPAN> gdfcin<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'\\'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>

vwfcin <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Users\rbasaria\AppData\Roaming\ESRI\Desktop10.4\ArcCatalog\MDCTest_1025.sde\MDCTest_1025.dbo.ViewETL_FacilityType_PhaseConverterExterior'</SPAN>
vwfc <SPAN class="operator token">=</SPAN> vwfcin<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'\\'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN>

slct <SPAN class="operator token">=</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gai<SPAN class="operator token">+</SPAN><SPAN class="string token">" IS NULL OR ("</SPAN><SPAN class="operator token">+</SPAN>gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gai<SPAN class="operator token">+</SPAN><SPAN class="string token">" <> "</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vai<SPAN class="operator token">+</SPAN><SPAN class="string token">")"</SPAN>

<SPAN class="comment token">#try:</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddJoin_management<SPAN class="punctuation token">(</SPAN>gdfcin<SPAN class="punctuation token">,</SPAN> gfi<SPAN class="punctuation token">,</SPAN> vwfcin<SPAN class="punctuation token">,</SPAN> vfi<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>gdfcin<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> slct<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfcin<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gai<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vai<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfcin<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gca<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vca<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfcin<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gcn<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vcn<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfcin<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gn<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vn<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfcin<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt1n<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt1n<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfcin<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt1t<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt1t<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfcin<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt2n<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt2n<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfcin<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt2t<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt2t<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfcin<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt3n<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt3n<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfcin<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt3t<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt3t<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfcin<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt4n<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt4n<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#except:</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp; print arcpy.GetMessages()</SPAN>
&nbsp;&nbsp;&nbsp; 
arcpy<SPAN class="punctuation token">.</SPAN>RemoveJoin_management<SPAN class="punctuation token">(</SPAN>gdfcin<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>gdfcin<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CLEAR_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Find more posts tagged with

Accepted answers

Anonymous User

Well, it looks like its working now!

Combination of the Make Feature Layer and Make Table View got this thing grabbing the right data, then I had an issue with my slct variable (which I know works)...which turned out to be the vwfc variable not having the "MDCTest_1025.dbo.ViewETL_FacilityType_" info before the table name.

Appreciate all the help, and its always a good day when I can learn something new!

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> sys<SPAN class="punctuation token">,</SPAN> string<SPAN class="punctuation token">,</SPAN> os<SPAN class="punctuation token">,</SPAN> subprocess

gca <SPAN class="operator token">=</SPAN> vca <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Conservation_Area_Name"</SPAN>
gcn <SPAN class="operator token">=</SPAN> vcn <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Conservation_Area_Number"</SPAN>
gn <SPAN class="operator token">=</SPAN> vn <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Network"</SPAN>

gfi <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Field_ID"</SPAN>
gai <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Asset_ID"</SPAN>
gt1n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_1_System_Name"</SPAN>
gt1t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_1_System_Type"</SPAN>
gt2n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_2_Major_Subsystem_Name"</SPAN>
gt2t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_2_Major_Subsystem_Type"</SPAN>
gt3n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_3_Minor_Subsystem_Name"</SPAN>
gt3t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_3_Minor_Subsystem_Type"</SPAN>
gt4n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Asset_Name"</SPAN>

vfi <SPAN class="operator token">=</SPAN> <SPAN class="string token">"FieldID"</SPAN>
vai <SPAN class="operator token">=</SPAN> <SPAN class="string token">"AssetID"</SPAN>
vt1n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_1_Name"</SPAN>
vt1t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_1_Type"</SPAN>
vt2n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_2_Name"</SPAN>
vt2t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_2_Type"</SPAN>
vt3n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_3_Name"</SPAN>
vt3t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_3_Type"</SPAN>
vt4n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_4_Name"</SPAN>

gdfc <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Phase_Converter_Exterior"</SPAN>
gdfcin <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'C:\Projects\MDC\DataUpdate_20180315\MDC_PhysModel_FieldID_20180315.gdb\Exterior_Electrical\Phase_Converter_Exterior'</SPAN><SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="punctuation token">)</SPAN>

vwfc <SPAN class="operator token">=</SPAN> <SPAN class="string token">"MDCTest_1025.dbo.ViewETL_FacilityType_PhaseConverterExterior"</SPAN>
vwfcin <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeTableView_management<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'C:\Users\rbasaria\AppData\Roaming\ESRI\Desktop10.4\ArcCatalog\MDCTest_1025.sde\MDCTest_1025.dbo.ViewETL_FacilityType_PhaseConverterExterior'</SPAN><SPAN class="punctuation token">,</SPAN> vwfc<SPAN class="punctuation token">)</SPAN>

slct <SPAN class="operator token">=</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gai<SPAN class="operator token">+</SPAN><SPAN class="string token">" IS NULL OR ("</SPAN><SPAN class="operator token">+</SPAN>gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gai<SPAN class="operator token">+</SPAN><SPAN class="string token">" <> "</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vai<SPAN class="operator token">+</SPAN><SPAN class="string token">")"</SPAN>

<SPAN class="comment token">#try:</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddJoin_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gfi<SPAN class="punctuation token">,</SPAN> vwfc<SPAN class="punctuation token">,</SPAN> vfi<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> slct<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gai<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vai<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gca<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vca<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gcn<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vcn<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gn<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vn<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt1n<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt1n<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt1t<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt1t<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt2n<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt2n<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt2t<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt2t<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt3n<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt3n<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt3t<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt3t<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt4n<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt4n<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#except:</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp; print arcpy.GetMessages()</SPAN>
&nbsp;&nbsp;&nbsp; 
arcpy<SPAN class="punctuation token">.</SPAN>RemoveJoin_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CLEAR_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

All comments

Anonymous User

Well, it looks like its working now!

Appreciate all the help, and its always a good day when I can learn something new!

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> sys<SPAN class="punctuation token">,</SPAN> string<SPAN class="punctuation token">,</SPAN> os<SPAN class="punctuation token">,</SPAN> subprocess

gca <SPAN class="operator token">=</SPAN> vca <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Conservation_Area_Name"</SPAN>
gcn <SPAN class="operator token">=</SPAN> vcn <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Conservation_Area_Number"</SPAN>
gn <SPAN class="operator token">=</SPAN> vn <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Network"</SPAN>

gfi <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Field_ID"</SPAN>
gai <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Asset_ID"</SPAN>
gt1n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_1_System_Name"</SPAN>
gt1t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_1_System_Type"</SPAN>
gt2n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_2_Major_Subsystem_Name"</SPAN>
gt2t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_2_Major_Subsystem_Type"</SPAN>
gt3n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_3_Minor_Subsystem_Name"</SPAN>
gt3t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_3_Minor_Subsystem_Type"</SPAN>
gt4n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Asset_Name"</SPAN>

vfi <SPAN class="operator token">=</SPAN> <SPAN class="string token">"FieldID"</SPAN>
vai <SPAN class="operator token">=</SPAN> <SPAN class="string token">"AssetID"</SPAN>
vt1n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_1_Name"</SPAN>
vt1t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_1_Type"</SPAN>
vt2n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_2_Name"</SPAN>
vt2t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_2_Type"</SPAN>
vt3n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_3_Name"</SPAN>
vt3t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_3_Type"</SPAN>
vt4n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_4_Name"</SPAN>

gdfc <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Phase_Converter_Exterior"</SPAN>
gdfcin <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'C:\Projects\MDC\DataUpdate_20180315\MDC_PhysModel_FieldID_20180315.gdb\Exterior_Electrical\Phase_Converter_Exterior'</SPAN><SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="punctuation token">)</SPAN>

vwfc <SPAN class="operator token">=</SPAN> <SPAN class="string token">"MDCTest_1025.dbo.ViewETL_FacilityType_PhaseConverterExterior"</SPAN>
vwfcin <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeTableView_management<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'C:\Users\rbasaria\AppData\Roaming\ESRI\Desktop10.4\ArcCatalog\MDCTest_1025.sde\MDCTest_1025.dbo.ViewETL_FacilityType_PhaseConverterExterior'</SPAN><SPAN class="punctuation token">,</SPAN> vwfc<SPAN class="punctuation token">)</SPAN>

slct <SPAN class="operator token">=</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gai<SPAN class="operator token">+</SPAN><SPAN class="string token">" IS NULL OR ("</SPAN><SPAN class="operator token">+</SPAN>gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gai<SPAN class="operator token">+</SPAN><SPAN class="string token">" <> "</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vai<SPAN class="operator token">+</SPAN><SPAN class="string token">")"</SPAN>

<SPAN class="comment token">#try:</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddJoin_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gfi<SPAN class="punctuation token">,</SPAN> vwfc<SPAN class="punctuation token">,</SPAN> vfi<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> slct<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gai<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vai<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gca<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vca<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gcn<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vcn<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gn<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vn<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt1n<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt1n<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt1t<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt1t<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt2n<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt2n<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt2t<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt2t<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt3n<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt3n<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt3t<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt3t<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt4n<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt4n<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#except:</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp; print arcpy.GetMessages()</SPAN>
&nbsp;&nbsp;&nbsp; 
arcpy<SPAN class="punctuation token">.</SPAN>RemoveJoin_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CLEAR_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

DanPatterson_Retired

SDE? can you try a simple local location to see whether the script works... just trying to rule out saving types and locations from the equation

JamesMacKay3

Is it a non-spatial dataset? If so, try Make Table View instead.

(Edit: Add Join works with non-spatial table views as well as feature layers.)

Anonymous User

Updated script and error...seems MakeFeatureLayer does not like the SQL view table...

<SPAN class="keyword token">import</SPAN> arcpy<SPAN class="punctuation token">,</SPAN> sys<SPAN class="punctuation token">,</SPAN> string<SPAN class="punctuation token">,</SPAN> os<SPAN class="punctuation token">,</SPAN> subprocess

gca <SPAN class="operator token">=</SPAN> vca <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Conservation_Area_Name"</SPAN>
gcn <SPAN class="operator token">=</SPAN> vcn <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Conservation_Area_Number"</SPAN>
gn <SPAN class="operator token">=</SPAN> vn <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Network"</SPAN>

gfi <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Field_ID"</SPAN>
gai <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Asset_ID"</SPAN>
gt1n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_1_System_Name"</SPAN>
gt1t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_1_System_Type"</SPAN>
gt2n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_2_Major_Subsystem_Name"</SPAN>
gt2t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_2_Major_Subsystem_Type"</SPAN>
gt3n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_3_Minor_Subsystem_Name"</SPAN>
gt3t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_3_Minor_Subsystem_Type"</SPAN>
gt4n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Asset_Name"</SPAN>

vfi <SPAN class="operator token">=</SPAN> <SPAN class="string token">"FieldID"</SPAN>
vai <SPAN class="operator token">=</SPAN> <SPAN class="string token">"AssetID"</SPAN>
vt1n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_1_Name"</SPAN>
vt1t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_1_Type"</SPAN>
vt2n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_2_Name"</SPAN>
vt2t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_2_Type"</SPAN>
vt3n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_3_Name"</SPAN>
vt3t <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_3_Type"</SPAN>
vt4n <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Tier_4_Name"</SPAN>

gdfc <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Phase_Converter_Exterior"</SPAN>
gdfcin <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'C:\Projects\MDC\DataUpdate_20180315\MDC_PhysModel_FieldID_20180315.gdb\Exterior_Electrical\Phase_Converter_Exterior'</SPAN><SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="punctuation token">)</SPAN>

vwfc <SPAN class="operator token">=</SPAN> <SPAN class="string token">"PhaseConverterExterior"</SPAN>
vwfcin <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'C:\Users\rbasaria\AppData\Roaming\ESRI\Desktop10.4\ArcCatalog\MDCTest_1025.sde\MDCTest_1025.dbo.ViewETL_FacilityType_PhaseConverterExterior'</SPAN><SPAN class="punctuation token">,</SPAN> vwfc<SPAN class="punctuation token">)</SPAN>

slct <SPAN class="operator token">=</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gai<SPAN class="operator token">+</SPAN><SPAN class="string token">" IS NULL OR ("</SPAN><SPAN class="operator token">+</SPAN>gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gai<SPAN class="operator token">+</SPAN><SPAN class="string token">" <> "</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vai<SPAN class="operator token">+</SPAN><SPAN class="string token">")"</SPAN>

<SPAN class="comment token">#try:</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>AddJoin_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gfi<SPAN class="punctuation token">,</SPAN> vwfc<SPAN class="punctuation token">,</SPAN> vfi<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> slct<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gai<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vai<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gca<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vca<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gcn<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vcn<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gn<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vn<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt1n<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt1n<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt1t<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt1t<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt2n<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt2n<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt2t<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt2t<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt3n<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt3n<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt3t<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt3t<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>CalculateField_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> gdfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>gt4n<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"["</SPAN><SPAN class="operator token">+</SPAN>vwfc<SPAN class="operator token">+</SPAN><SPAN class="string token">"."</SPAN><SPAN class="operator token">+</SPAN>vt4n<SPAN class="operator token">+</SPAN><SPAN class="string token">"]"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"VB"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="comment token">#except:</SPAN>
<SPAN class="comment token">#&nbsp;&nbsp;&nbsp; print arcpy.GetMessages()</SPAN>
&nbsp;&nbsp;&nbsp; 
arcpy<SPAN class="punctuation token">.</SPAN>RemoveJoin_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>gdfc<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"CLEAR_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Traceback (most recent call last):
File "C:\Projects\MDC\DataUpdate_20180315\MDC_ViewtoGIS_Automated.py", line 31, in <module>
vwfcin = arcpy.MakeFeatureLayer_management(r'C:\Users\rbasaria\AppData\Roaming\ESRI\Desktop10.4\ArcCatalog\MDCTest_1025.sde\MDCTest_1025.dbo.ViewETL_FacilityType_PhaseConverterExterior', vwfc)
File "C:\Program Files (x86)\ArcGIS\Desktop10.4\ArcPy\arcpy\management.py", line 6477, in MakeFeatureLayer
raise e
ExecuteError: Failed to execute. Parameters are not valid.
ERROR 000732: Input Features: Dataset C:\Users\rbasaria\AppData\Roaming\ESRI\Desktop10.4\ArcCatalog\MDCTest_1025.sde\MDCTest_1025.dbo.ViewETL_FacilityType_PhaseConverterExterior does not exist or is not supported
Failed to execute (MakeFeatureLayer).

Anonymous User

I don't think the named user thing is causing the problem at this point, but I am not sure. The path for that is supposed to be pointing to a SQL database, and thats the only way I know how to connect to it...Yes, "Exterior_Electrical" is a feature dataset inside the GDB. I'm not sure what you mean by rework the path references...

JamesCrandall

The vwfcin looks like it's being set to a named user directory? If this is not related to the current problem you are experiencing, my guess is that it will be a problem later on if setting this to run as a scheduled task. Also, is "Exterior_Electrical" a Feature Dataset in the gdb? You may have to go ahead and re-work those path references using os.path.join()

You may want to just eliminate anything like this for now and simply hardcode the value.

gdfc <SPAN class="operator token">=</SPAN> gdfcin<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'\\'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="operator token">-</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Anonymous User

That's what my script is currently trying to do, and seems to be failing at. Right now, it crashes at the AddJoin function, telling me that the parameters are not valid and that the value cannot be a feature class.

DanPatterson_Retired

reference the featureclass and table on disk and not the layer or table view in the project

Anonymous User

I was planning on using windows task scheduler for that part. But this isn't really the issue...

The issue is getting the script to work outside of an ArcMap session. Right now, it doesn't seem to want to recognize the feature class and table that I am pointing to.

DanPatterson_Retired

You want to run a 'scheduled task'

There are links on GeoNet if you search using that key phrase, plus options in the help topics

http://pro.arcgis.com/en/pro-app/arcpy/get-started/installing-python-for-arcgis-pro.htm

http://pro.arcgis.com/en/pro-app/help/analysis/geoprocessing/modelbuilder/scheduling-a-model-run.htm

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.