Python Code Help Needed:Commerical Property Imports

[RaoulComaduran]

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

[RaoulComaduran]

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.

[RaoulComaduran]

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??

[RaoulComaduran]

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.