<HTML><HEAD></HEAD>
<BODY dir=ltr>
<DIV dir=ltr>
<DIV style="FONT-FAMILY: 'Times New Roman'; COLOR: #00002b; FONT-SIZE: 12pt">
<DIV>Hi </DIV>
<DIV> </DIV>
<DIV>I’m having a further problem with shell execute. There seems to be a dearth
of information on the web other than a simple “open” procedure.</DIV>
<DIV> </DIV>
<DIV>The following two part code performs well when I copy and paste it into
command prompt.</DIV>
<DIV> </DIV>
<DIV>However when I use it in shell execute there is a problem getting both
parts to run together.</DIV>
<DIV> </DIV>
<DIV>In shell execute each part of the code does its thing when the other part
is commented out.</DIV>
<DIV> </DIV>
<DIV>I have tried joining the two parts with the ogr2ogr command &&, and
as it appears below. I have also removed the second path to ogr2ogr with no
joy.</DIV>
<DIV> </DIV>
<DIV>I either get “unable to run” or the second part of the code is recognized
with the first part being ignored.</DIV>
<DIV> </DIV>
<DIV>The following is my command prompt code – which works as shown</DIV>
<DIV> </DIV>
<DIV>set PGCLIENTENCODING=LATIN1&&set DXF_ENCODING=LATIN1&&set
DXF_INLINE_BLOCKS=FALSE&&set
DXF_MERGE_BLOCK_GEOMETRIES=FALSE&&ogr2ogr -f "PostgreSQL"
PG:"host=localhost user=postgres dbname=*** password=*****"
Water2000.dxf -lco DIM=2 -nlt GEOMETRY -sql "select layer, linetype,
subclasses, ogr_style, blockname, blockangle, blockscale, text from entities"
-append -update -skipfailures </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>set PGCLIENTENCODING=LATIN1&&set DXF_ENCODING=LATIN1&&set
DXF_INLINE_BLOCKS=FALSE&&set
DXF_MERGE_BLOCK_GEOMETRIES=FALSE&&ogr2ogr -f "PostgreSQL"
PG:"host=localhost user=postgres dbname=*** password=****"
Water2000.dxf -lco DIM=2 -nlt GEOMETRY -append -update -skipfailures
-sql "select layer, linetype, subclasses, ogr_style, blockname, text from
blocks" </DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV>Here is the shell execute code which is giving me a challenge -</DIV>
<DIV> </DIV>
<DIV>ProgramName :=</DIV>
<DIV> '"'+s+'\Quantum GIS Wroclaw\bin'+</DIV>
<DIV>'ogr2ogr" "-f" '+</DIV>
<DIV>'"PostgreSQL";'+</DIV>
<DIV>' PG:"host='+DBHost+' user=postgres dbname='+DBName+' password='+Pass+'"
"'+ DXFfile +'" '+</DIV>
<DIV>' --config DXF_INLINE_BLOCKS FALSE --config DXF_MERGE_BLOCK_GEOMETRIES
FALSE --config DXF_ENCODING=UTF8 '+</DIV>
<DIV>' -lco DIM=2 -nlt GEOMETRY -overwrite -skipfailures'+</DIV>
<DIV>' -sql "select layer, linetype, subclasses, ogr_style, blockname,
blockangle, blockscale, text from entities"'+</DIV>
<DIV> '"'+s+'\Quantum GIS Wroclaw\bin'+</DIV>
<DIV>'ogr2ogr""-f"'+</DIV>
<DIV>' "PostgreSQL";'+</DIV>
<DIV>'PG:"host='+DBHost+' user=postgres dbname='+DBName+' password='+Pass+'" "'+
DXFfile +'" '+</DIV>
<DIV>' --config DXF_INLINE_BLOCKS FALSE --config DXF_MERGE_BLOCK_GEOMETRIES
FALSE --config DXF_ENCODING=UTF8 '+</DIV>
<DIV>' -lco DIM=2 -nlt GEOMETRY -overwrite -skipfailures'+</DIV>
<DIV>' -sql "select layer, linetype, subclasses, ogr_style, blockname, text from
blocks"';</DIV>
<DIV> </DIV>
<DIV>Thanks in advance for any suggestions.</DIV>
<DIV> </DIV>
<DIV>Bob</DIV></DIV></DIV></BODY></HTML>