Skip to main content
Geographic Information Systems

Return to Question

added 33 characters in body; edited tags; edited title
Source Link
PolyGeo ♦
PolyGeo ♦
  • 65.4k
  • 29
  • 114
  • 345

How Do I Debug Debugging QuickExport Parameters in the Data Interoperability Extension for ArcGIS 10 to Exporting to PostgresPostgreSQL?

I am using ArcGIS Desktop 10.

I tried to configure the QuickExport parameters by examining the log file after I used the QuickExport tool itself. The only things I changed from the log file are the parameters as I want the user to be able to input the parameters to connect to a postgres database after they create it and pass in a layer. Any suggestions on debugging this? I didn't get any syntax errors, but if the tool didn't work I made it throw an exception.

arcpy.QuickExport_interop(layer, POSTGIS, dbname,"RUNTIME_MACROS,""HOST,%s,PORT,%d,USER_NAME,%s,PASSWORD,%s,GENERIC_GEOMETRY,no,\
LOWERCASE_ATTRIBUTE_NAMES,Yes"",META_MACROS,""DestHOST,%s,DestPORT,%d,DestUSER_NAME,%s,DestPASSWORD,%s,DestGENERIC_GEOMETRY,no, \
DestLOWERCASE_ATTRIBUTE_NAMES,Yes"",METAFILE,POSTGIS,COORDSYS,,__FME_DATASET_IS_SOURCE_,false" %((server),(portnum),(usrName),(passWord),(server),(portnum),(usrName),(passWord)))

How Do I Debug QuickExport Parameters in the Data Interoperability Extension for ArcGIS 10 to Exporting to Postgres

I tried to configure the QuickExport parameters by examining the log file after I used the QuickExport tool itself. The only things I changed from the log file are the parameters as I want the user to be able to input the parameters to connect to a postgres database after they create it and pass in a layer. Any suggestions on debugging this? I didn't get any syntax errors, but if the tool didn't work I made it throw an exception.

arcpy.QuickExport_interop(layer, POSTGIS, dbname,"RUNTIME_MACROS,""HOST,%s,PORT,%d,USER_NAME,%s,PASSWORD,%s,GENERIC_GEOMETRY,no,\
LOWERCASE_ATTRIBUTE_NAMES,Yes"",META_MACROS,""DestHOST,%s,DestPORT,%d,DestUSER_NAME,%s,DestPASSWORD,%s,DestGENERIC_GEOMETRY,no, \
DestLOWERCASE_ATTRIBUTE_NAMES,Yes"",METAFILE,POSTGIS,COORDSYS,,__FME_DATASET_IS_SOURCE_,false" %((server),(portnum),(usrName),(passWord),(server),(portnum),(usrName),(passWord)))

Debugging QuickExport Parameters in Data Interoperability Extension for Exporting to PostgreSQL?

I am using ArcGIS Desktop 10.

I tried to configure the QuickExport parameters by examining the log file after I used the QuickExport tool itself. The only things I changed from the log file are the parameters as I want the user to be able to input the parameters to connect to a postgres database after they create it and pass in a layer. Any suggestions on debugging this? I didn't get any syntax errors, but if the tool didn't work I made it throw an exception.

arcpy.QuickExport_interop(layer, POSTGIS, dbname,"RUNTIME_MACROS,""HOST,%s,PORT,%d,USER_NAME,%s,PASSWORD,%s,GENERIC_GEOMETRY,no,\
LOWERCASE_ATTRIBUTE_NAMES,Yes"",META_MACROS,""DestHOST,%s,DestPORT,%d,DestUSER_NAME,%s,DestPASSWORD,%s,DestGENERIC_GEOMETRY,no, \
DestLOWERCASE_ATTRIBUTE_NAMES,Yes"",METAFILE,POSTGIS,COORDSYS,,__FME_DATASET_IS_SOURCE_,false" %((server),(portnum),(usrName),(passWord),(server),(portnum),(usrName),(passWord)))
Source Link
Nightvein
Nightvein
  • 145
  • 1
  • 10

How Do I Debug QuickExport Parameters in the Data Interoperability Extension for ArcGIS 10 to Exporting to Postgres

I tried to configure the QuickExport parameters by examining the log file after I used the QuickExport tool itself. The only things I changed from the log file are the parameters as I want the user to be able to input the parameters to connect to a postgres database after they create it and pass in a layer. Any suggestions on debugging this? I didn't get any syntax errors, but if the tool didn't work I made it throw an exception.

arcpy.QuickExport_interop(layer, POSTGIS, dbname,"RUNTIME_MACROS,""HOST,%s,PORT,%d,USER_NAME,%s,PASSWORD,%s,GENERIC_GEOMETRY,no,\
LOWERCASE_ATTRIBUTE_NAMES,Yes"",META_MACROS,""DestHOST,%s,DestPORT,%d,DestUSER_NAME,%s,DestPASSWORD,%s,DestGENERIC_GEOMETRY,no, \
DestLOWERCASE_ATTRIBUTE_NAMES,Yes"",METAFILE,POSTGIS,COORDSYS,,__FME_DATASET_IS_SOURCE_,false" %((server),(portnum),(usrName),(passWord),(server),(portnum),(usrName),(passWord)))