I use with success Fdo2Fdo to extract each night SDF from Oracle DB.
withthis command line in a batch :
f2fcmd copytask "../XML/SDF_AEP.XML"
But now I would extract with a parametric filter like “INSEE=40042”
Someone know a syntax to do that without rewrite the XML and the <CopyFilter></CopyFilter> balise
The ogr2ogr syntax is like this:
ogr2ogr -f "ESRI Shapefile" c:\temp\table.shp OCI:username/password@Server/Xe -sql "select * from mytable where INSEE=40042" –skipfailures
I never used f2fcmd so I cannot help you with that.
Fra: [hidden email] [mailto:[hidden email]] På vegne af Rémy GOURRATSendt: 21. marts 2014 14:34Til: '[hidden email]'Emne: [fdo-users] [Fdo2FDO]f2fcmd command line change Filter with parameter
Thanks a lot Hans,
Argh… I had it just under my eyes…
Great ! it’s running fine.
I know we are in fdo2fdo user list… excuse me
When i connect QGIS 2.01 to Oracle, i have an option “Only look for User’s Table” to reduce time connect.
With ogr2ogr I saw it try to describe each table/view with spatial column.
I search but I can’t get the option “Only look for User’s Table” in ogr2ogr
Someone know if exists ?