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 qQGIS, and save as a shapefile 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 advice?
Best Answer
So what do you do with the Multi Line Strings that aren't imported? Are you just ignoring these?
You could change the Geometry type of your column to also allow MultiLineString
Peter