I'm wondering if there are unicode characters that are not properly
formated when output to the xlsx or ods files. If the CSV export takes a
different export and import path that handles correct conversion, maybe
that is not the case for the binary files.
I would try to locate 1-2 records from the shp file that cause this
problem then submit that to a bug report.
You should be able to apply a where clause to the export to select only
a subset of the records when you export.
-Steve W
On 9/12/2020 1:21 PM, Hernán De Angelis wrote:
That was a very good piece of advice. Unfortunately that is apparently
not the problem. The CSV imports cleanly in Libreoffice, with the same
number of rows (minus title row) as features are in the shp. No trace
of misplaced linefeed or carriage return characters. I will have to
keep looking for solutions. Thanks anyway!
/H.
On 2020-09-12 18:56, Stephen Woodbridge wrote:
Try exporting to CSV and check the that the records do not have any
embeded <CR> or <LF> chars. One simple way to do this is to compare
the record count of the shp file to the line count of the CSV file.
Try importing the CSV file into EXCEL or Libreoffice and see if it
reports a problem. This may give you a better idea of what the
problem is.
-Steve W
On 9/12/2020 11:20 AM, Hernán De Angelis wrote:
Hi everyone
I am experiencing an odd and stubborn problem when trying to export
attribute tables from both shp and spatialite to ods or xlsx.
ogr2ogr finishes work silently with no reported errors but the
generated output files cannot be opened with Libreoffice, which says
the file is corrupted and is even unable to repair it.
The input files are good from what I can see using QGIS and OGR but
it is clear that something isn't right in my installation, my
procedure or somewhere else. I am missing something? Have other
users experienced this?
I am using GDAL/OGR 3.1.2 in openSUSE Tumbleweed, compiled against
expat 2.2.9-1.12 (devel packages installed too, of course).
Any hint is appreciated!
Hernán
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
_______________________________________________
gdal-dev mailing list
gdal-dev@lists.osgeo.org
https://lists.osgeo.org/mailman/listinfo/gdal-dev
