<html>
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
Thanks,<br>
I had tried both initially, with little success, the initial data
was DGN, I used an ETL to extract the line and text geometry, the
text coming in as points.<br>
I styled the text using the attributes extracted like text height
and rotation and all looks and works well within QGIS.<br>
When I use the Export to DXF tool (option B), I get all the
Linestrings perfect, but I get styled points (based on the
attributes) instead of Text.<br>
I have added the extra column to one of the Tables, and will try the
OGR export (option A) tomorrow with that.<br>
It is no big deal to add the column to the dataset, it can be added
as part of the ETL, If I get it all to work.<br>
I can submit a bug report, but as for the sample data, It is a
sensitive dataset, so I cant send that.<br>
It may also be the version of QGIS im using, not being the most up
to date 2.14.2-Essen<br>
I will continue with it tomorrow, if I find a solution, I will post
it.<br>
Regards,<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">On 09/06/2016 17:03, Andreas Neumann
wrote:<br>
</div>
<blockquote cite="mid:57599342.7000002@carto.net" type="cite">
<meta content="text/html; charset=utf-8" http-equiv="Content-Type">
Hi Richard,<br>
<br>
How did you export your DXF?<br>
<br>
There are two options:<br>
a) Save AS (through OGR)<br>
b) Menu Project --> Export DXF which is a native QGIS DXF
export not using OGR.<br>
<br>
Option b) is much more powerful and should export your label fine
- not with all details - as QGIS labels are more powerful than DXF
labels, but basic stuff, such as font-family, font-size,
multi-line labels, etc. should be exported fine.<br>
<br>
If not, please submit a bug report with some sample data.<br>
<br>
Option a) is what was discussed here, but is much more complicated
- you would have to create separate columns with feature styles
first.<br>
<br>
Andreas<br>
<br>
<div class="moz-cite-prefix">On 09.06.2016 17:08, Richard
McDonnell wrote:<br>
</div>
<blockquote cite="mid:57598676.80201@opw.ie" type="cite">
<meta content="text/html; charset=utf-8"
http-equiv="Content-Type">
I am back again,<br>
Using what you said as a guide, I added a column to the table
using the following<br>
<br>
ALTER TABLE mv_lv_network_point<br>
ADD COLUMN OGR_STYLE CHARACTER VARYING(80);<br>
UPDATE mv_lv_network_point<br>
SET OGR_STYLE =
'LABEL(f:"Arial",s:{igds_text_size},a:{igds_rotation},t:{igds_text_string})'
;<br>
<br>
s:{igds_text_size} Referencing Text size column<br>
a:{igds_rotation} Referencing Rotation Column<br>
t:{igds_text_string} Referencing Text String Column,<br>
<br>
I then used the DXF Export tool, with no success.<br>
What have I done wrong? Should I be doing this as an OGR2OGR
exercise as opposed to using the Export tool?<br>
Regards,<br>
<br>
Richard.<br>
<br>
<br>
<br>
<br>
<div class="moz-cite-prefix">On 09/06/2016 13:10, Heikki Vesanto
wrote:<br>
</div>
<blockquote
cite="mid:CAFTGJ2Bmnt4HJK1GLm_-_fB8o1s6-jxr0jr8j5-v7b_aFarf-g@mail.gmail.com"
type="cite">
<pre wrap="">With ogr2org (which QGIS uses for import/export), when writing a DXF
file, if you have an input point geometry, which has an OGR_STYLE
attribute, it will be written as a text geometry when opened in CAD.
This will work straight from a database as well. But there is a guide
that uses gml at:
<a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://gisforthought.com/gis-to-cad-using-ogr2ogr-part-3-point-annotation-to-text-in-cad/">http://gisforthought.com/gis-to-cad-using-ogr2ogr-part-3-point-annotation-to-text-in-cad/</a>
On Thu, Jun 9, 2016 at 12:30 PM, Richard McDonnell
<a moz-do-not-send="true" class="moz-txt-link-rfc2396E" href="mailto:richard.mcdonnell@opw.ie"><richard.mcdonnell@opw.ie></a> wrote:
</pre>
<blockquote type="cite">
<pre wrap="">Afternoon all,
I would firstly like to say that the DXF Export option is great, and is a
great addition to QGIS.
I do have one problem though which you you may be able to help with.
I have a PostGIS database LineStrings and Points (Text)
What I would like to do is have the text export also, all I get when I
export the points is....Points, no text.
I would appreciate any help, I am tying to get a Map out at the moment and
would have a preference to output it via QGIS.
Regards,
Richard.
OPW - Ag féachaint don am atá le teacht - Ag caomhnú ón am atá thart
OPW - Looking to the future - Caring for the past
***********************************************************
Email Disclaimer: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://www.opw.ie/en/disclaimer/">http://www.opw.ie/en/disclaimer/</a>
_______________________________________________
Qgis-user mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<b><u>Richard McDonnell</u></b><br>
<b><small><small><small>GIS Specialist PgD GIS AssocSCSI</small></small></small></b><br>
<b><small>OPW FRM Data Management</small></b><br>
<b><small>52 Stephens Green, Dublin 2.</small></b><br>
<small><small>TEL: 01 6476543</small></small></div>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a moz-do-not-send="true" class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
Qgis-user mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
List info: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
Unsubscribe: <a class="moz-txt-link-freetext" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<b><u>Richard McDonnell</u></b><br>
<b><small><small><small>GIS Specialist PgD GIS AssocSCSI</small></small></small></b><br>
<b><small>OPW FRM Data Management</small></b><br>
<b><small>52 Stephens Green, Dublin 2.</small></b><br>
<small><small>TEL: 01 6476543</small></small></div>
</body>
</html>