<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>Even and all,</p>
<p>Thank you all for your kind help with this. The two test datasets can be found here:</p>
<p><a class="moz-txt-link-freetext" href="https://geonatura.se/test.zip">https://geonatura.se/test.zip</a></p>
<p><a class="moz-txt-link-freetext" href="https://geonatura.se/se_100km.zip">https://geonatura.se/se_100km.zip</a></p>
<p>Both files are open data and can be used and shared. "Test.zip" is a subset of the Swedish registry of environmental monitoring stations (bathing water). It's attribute table contains a lot of Swedish names. Encoding is UTF-8. The other is a dataset distributed by the European Environmental Agency containing a 100x100 km grid for Sweden. No unusual characters there.</p>
<p>For both datasets the ogr command is:</p>
<p>ogr2ogr -f ODS test.ods test.shp test</p>
<p>and</p>
<p>ogr2ogr -f ODS se_100km.ods se_100km.shp se_100km</p>
<p>Note that exporting to CSV using ogr2ogr works like charm.</p>
<p>
</p>
<p>Thanks again!</p>
<p>/Hernán
</p>
<p>
</p>
<div class="moz-cite-prefix">On 2020-09-12 20:00, Even Rouault
wrote:<br>
</div>
<blockquote type="cite" cite="mid:6009182.3bWTfo8rnF@even-i700">
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<meta name="qrichtext" content="1">
<style type="text/css">
p, li { white-space: pre-wrap; }
</style>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">On samedi 12 septembre 2020 17:20:29 CEST Hern�n De Angelis wrote:</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> Hi everyone</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> I am experiencing an odd and stubborn problem when trying to export</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> attribute tables from both shp and spatialite to ods or xlsx. ogr2ogr</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> finishes work silently with no reported errors but the generated output</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> files cannot be opened with Libreoffice, which says the file is</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> corrupted and is even unable to repair it.</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> The input files are good from what I can see using QGIS and OGR but it</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> is clear that something isn't right in my installation, my procedure or</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">> somewhere else. I am missing something? Have other users experienced this?</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Please share minimal ods/xlsx files that can be used to reproduce the issue (and possibly source datasets + ogr2ogr invokation used to generate the ods/xlsx files)</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Even</p>
<p style="-qt-paragraph-type:empty; margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; "> </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">-- </p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;">Spatialys - Geospatial professional services</p>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px; -qt-user-state:0;"><a class="moz-txt-link-freetext" href="http://www.spatialys.com">http://www.spatialys.com</a></p>
</blockquote>
</body>
</html>