Hi I need a little help/ ideas on how to convert tab files.
The problem: I have many TAB files produced daily by 3 party app, I need to batch import the files into postgres.
Most files import fine, however some files has mixed content like linestrings and multilinestrings in one file.
I can't import that type of files.
I can open the files in qgis, and save as shp and then import to the database, but it needs to be done in a batch job.
This is what I'm using and what is working for files that only has linestrings.
C:\Program Files (x86)\FWTools2.4.7\bin>ogr2ogr -skipfailures -overwrite -t_srs "EPSG:4326" -s_srs "EPSG:4326" -a_srs "EPSG:4326" -f "PostgreSQL" PG:"host=localhost user=zzz dbname=geo password=zzz" C:\gisdata\Cables_1.tab -nln tmpimport.Cables_1
This is the error I get when importing a mixed content file
Warning 1: Geometry to be inserted is of type Multi Line String, whereas the layer geometry type is Line String.
Insertion is likely to fail
ERROR 1: INSERT command for new feature failed.
ERROR: Geometry type (MultiLineString) does not match column type (LineString)
Anyone has any advise?