[Qgis-user] Points layer from table tool truncating texts

[Junior Delaz]

Hello,
And if u just create your points with these tools and then join the result
layer to your previous table in your database?

About the SAGA "Convert table to points" tool, you need to activate the
processing toolbox and at the bottom of the frame, choose "Advanced
Interface". It's in SAGA > Shapes - Points category.


2014-12-03 12:59 GMT+01:00 <anderso at anlaggarna.se>:

> Thank you for helping out.
>
> Comments below:
>
> > Did you create the layer as a temporary one? So then its stored as an
> ESRI
> > shape and the dbf will not store more characters.
>
> Used temporary before and i understand the problem better now.
>
> > Or did you also try to save it directly into another format which
> supports
> > longer fields (errm, here I'm lost too, cause I do not know most of the
> > formats available, but maybe try sqlite)
>
> I've tried "all" possible file-formats that can be selected in the "Points
> Layer from Table" tool and it seems like they all store the result like
> shape files (using a dbf database file).
>
> Selecting sqlite-format:
> sqll.sqlit.dbf
> sqll.sqlit.prj
> sqll.sqlit.qbj
> sqll.sqlit.shp
> sqll.sqlit.shx
>
> I'm rather confused here, i expected to find raw files with the selected
> format as output?
>
> So this is leading in the direction that i can't use the tool if i want
> longer text fields.
>
> Some other ideas (partly evaluated):
> - The EVIS database tools seem to support longer strings but have issues
> with national characters and fails to add all points "missing georeference
> infomation)?
> - The "SAGA convert table to points" seems to be missing/removed in QGIS?
>
> >
> > Cheers
> > Bernd
> >
>
> Thanks
>
> /AO
>
> >
> > Am 03.12.2014, 10:07 Uhr, schrieb <anderso at anlaggarna.se>:
> >
> >> Hi!
> >>
> >> I'm having a problem with the "Points Layer from Table" tool.
> >>
> >> The source data contain string/text data longer than 255 characters
> >> (memo
> >> fields from MS Access)
> >>
> >> The fields are truncated to 255 characters in the resulting point layer
> >> when looking in the "attribute table window"
> >>
> >> When opening the source data layer in the "attribute table window" the
> >> fields are not truncated so the problem must be in the tool itself.
> >>
> >> The source layer is created using "create vector
> >> layer->Database->ODBC->...."
> >>
> >> Does anyone have a workaround for this?
> >>
> >> I found some tips about using the SAGA "create points from table" tool
> >> instead but i can't find it in QGIS?
> >>
> >> I'm using QGIS 2.6.1
> >>
> >> BR
> >>
> >> /AO
> >> _______________________________________________
> >> Qgis-user mailing list
> >> Qgis-user at lists.osgeo.org
> >> http://lists.osgeo.org/mailman/listinfo/qgis-user
> >
> >
> > --
> > Bernd Vogelgesang
> > Siedlerstraße 2
> > 91083 Baiersdorf/Igelsdorf
> > Tel: 09133-825374
> >
> >
>
> _______________________________________________
> Qgis-user mailing list
> Qgis-user at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/qgis-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20141203/e7bdb6cb/attachment.html>