Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

So I am trying to programmatically use quick_export through the arcpy package in an arcmap tool, and so I referenced the quick_export tool's dialog box that comes up when it is executing for the parameters. So in my code, prior to using the quick_export function I am creating a database in postgres using some psql commands, and then checking to see if it exists. however, quick_export has failed. So my only thought process on why the quick_export didn't work is because of the latency of recognizing that my database has been created.

*When I created the tool I created a field to name the database as a string field.

share|improve this question
    
Quick Export is part of the Data Interoperability Extension, which is a 3rd party extension based on FME by Safe Software. Maybe post to their user group. Also you should elaborate on exactly what you're doing, why you're doing it, any code examples you can share, what error messages you are getting and what troubleshooting steps if any you have taken. –  blah238 Mar 9 '12 at 22:05
    
so essentially what I am doing is using parameters from arcmap as a toolset I am creating a postgis connection, creating a database name, and then exporting a shapefile from arcmap to postgis. –  Nightvein Mar 15 '12 at 20:01
    
I am doing it for the purpose of workflow and it suits my purpose better than using arcserver. The error message I am getting is that Quick Export isn't properly sending the shapefile. The reason being when I query postgis I can see the database name I created, but I can't see the layer name. –  Nightvein Mar 15 '12 at 20:03
    
<!-- language: python -->arcpy.QuickExport_interop(layer, 'POSTGIS,%s,"RUNTIME_MACROS,""HOST,%s,PORT,%d,USER_NAME,%s,PASSWORD,%s,GENERIC_G‌​EOMETRY,no, \ LOWERCASE_ATTRIBUTE_NAMES,Yes"",META_MACROS,""DestHOST,%s,DestPORT,%d,DestUSER_N‌​AME,%s,DestPASSWORD,%s,DestGENERIC_GEOMETRY,no, \ DestLOWERCASE_ATTRIBUTE_NAMES,Yes"",METAFILE,POSTGIS,COORDSYS,,_FME_DATASET_IS_S‌​OURCE,false"' %(dbname,(server),(portnum),(usrName),(passWord),(server),(portnum),(usrName),(p‌​assWord)))<!-- language: python --> –  Nightvein Mar 15 '12 at 20:04
    
sorry I didn't properly format my code response @blah238 –  Nightvein Mar 15 '12 at 20:06

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.