<p dir="ltr">Hi,<br>
Just ideas...</p>
<p dir="ltr">I have no idea what a blob field is... But can you save the file in spatialite? That is a more modern file format than shp files. Have you tried exporting without this field in QGIS? Are the decimals ok? Could you then export the blob field using ogr then link it back to the shp file after? Could you use and intermediate database format like postgreSQL before you send it to .shp?</p>
<p dir="ltr">You are right, playing with local language config usually fixes problems like decimal comma vs point problems. Make sure everything is in us English from data base to your computer. Try exporting a few lines in other formats to see if it an org2org thing or a machine configuration problem... If you find no solutions, you could ultimately separate that field in Oracle between int and decimals and then use the field calculator to recreate the decimals...</p>
<p dir="ltr">Nicolas Cadieux M.Sc.<br>
Les Entreprises Archéotec inc. <br>
8548, rue Saint-Denis Montréal H2P 2H2<br>
Téléphone: 514.381.5112 Fax: 514.381.4995<br>
www.archeotec.ca</p>
<div class="gmail_quote">On Jan 11, 2016 5:20 AM, "Lopez Agostini, Diana [via OSGeo.org] " <<a href="/user/SendEmail.jtp?type=node&node=5244577&i=0" target="_top" rel="nofollow" link="external">[hidden email]</a>> wrote:<br type='attribution'><blockquote style='border-left:2px solid #CCCCCC;padding:0 1em' class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>
<p><span style="color:#1f497d">Hi,</span></p>
<p><span style="color:#1f497d"> </span></p>
<p><span style="color:#1f497d">We’ve got a vector layer in a spatial oracle repository.</span></p>
<p><span style="color:#1f497d">We need to export it (both geometry and attributes) to a shape file.</span></p>
<p><span style="color:#1f497d"> </span></p>
<p><span style="color:#1f497d">We cannot use “save as shape” directly from qgis, because the oracle layer has a blob field that prevent this operation.
</span></p>
<p><span style="color:#1f497d">And we cannot drop the blob field because it is needed for other purposes.</span><span style="color:#1f497d"></span></p>
<p><span style="color:#1f497d"> </span></p>
<p><span style="color:#1f497d">So we’re using OGR2OGR instead.</span></p>
<p><span style="color:#1f497d">The oracle layer have several fields tipus ‘double’:</span></p>
<p><span style="color:#1f497d"> </span></p>
<p><span style="color:#1f497d"><img width="440" height="94" src="http://osgeo-org.1560.x6.nabble.com/attachment/5244514/0/image001.png" /></span><span style="color:#1f497d"></span></p>
<p><span style="color:#1f497d"> </span></p>
<p><span style="color:#1f497d">After de conversion, the shape file keeps the double format, but we’ve lost the decimal data.</span></p>
<p><span style="color:#1f497d">For exemple:</span></p>
<p><span style="color:#1f497d"> </span></p>
<p><span style="color:#1f497d">Before conversion: AREA_HA = 3379.88378172</span></p>
<p><span style="color:#1f497d">After conversion: AREA_HA= 3379</span></p>
<p><span style="color:#1f497d"> </span></p>
<p><span style="color:#1f497d">We have repeated the conversion applying different “locale” configurations, in case the problem was originated by the decimal separation character used: “.” or “,”.</span></p>
<p><span style="color:#1f497d">However, the results are equally bad.</span></p>
<p><span style="color:#1f497d"> </span></p>
<p><span style="color:#1f497d">Do you know any workaround for this issue ?</span><span style="font-size:12pt;font-family:'times new roman' , 'serif';color:#1f497d">
</span></p>
<p><span style="color:#1f497d"> </span></p>
<p><span style="color:#1f497d"> </span></p>
<p><span style="color:#1f497d">Thanks in advance, </span></p>
<p><span style="color:#1f497d"> </span></p>
<p><span style="font-size:10pt;color:#1f497d"> </span><span style="font-size:10pt;font-family:'verdana' ,;color:#1f497d"><a href="/user/SendEmail.jtp?type=node&node=5244514&i=0">[hidden email]</a>
</span><span style="font-size:10pt;color:#1f497d"></span></p>
<p><span style="color:#1f497d"> </span></p>
</div>
<br />_______________________________________________
<br />Qgis-user mailing list
<br /><a href="/user/SendEmail.jtp?type=node&node=5244514&i=1">[hidden email]</a>
<br />List info: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br />Unsubscribe: <a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_top" rel="nofollow" link="external">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
<br />
<br />
<hr noshade="noshade" size="1" />
<div style="color:#444;font:12px 'tahoma' , 'geneva' , 'helvetica' , 'arial' , sans-serif">
<div style="font-weight:bold">If you reply to this email, your message will be added to the discussion below:</div>
<a href="http://osgeo-org.1560.x6.nabble.com/Qgis-2-13-on-windows-7-ogr2ogr-oracle-to-shape-does-not-keep-decimals-tp5244514.html" target="_top" rel="nofollow" link="external">http://osgeo-org.1560.x6.nabble.com/Qgis-2-13-on-windows-7-ogr2ogr-oracle-to-shape-does-not-keep-decimals-tp5244514.html</a>
</div>
<div style="color:#666;font:11px 'tahoma' , 'geneva' , 'helvetica' , 'arial' , sans-serif;margin-top:0.4em;line-height:1.5em">
To start a new topic under Quantum GIS - User, email ml-node+s1560n4125267h38@n6.nabble.com <br />
To unsubscribe from Quantum GIS - User, <a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4125267&code=bmljb2xhcy5jYWRpZXV4QGFyY2hlb3RlYy5jYXw0MTI1MjY3fDYzNDQ4MjQxNg==">click here</a>.<br />
<a href="http://osgeo-org.1560.x6.nabble.com/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml" style="font:9px serif">NAML</a>
</div></blockquote></div>
<br/><hr align="left" width="300" />
View this message in context: <a href="http://osgeo-org.1560.x6.nabble.com/Qgis-2-13-on-windows-7-ogr2ogr-oracle-to-shape-does-not-keep-decimals-tp5244514p5244577.html">Re: Qgis 2.13 on windows 7: ogr2ogr oracle to shape does not keep decimals.</a><br/>
Sent from the <a href="http://osgeo-org.1560.x6.nabble.com/Quantum-GIS-User-f4125267.html">Quantum GIS - User mailing list archive</a> at Nabble.com.<br/>