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

[anderso at anlaggarna.se]

Hi!

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

OK, i'll try to do that, new functionality to me :-)

>
> 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.

No, i can't find it in my freshly installed 2.6.1, SAGA->Shapes - Points
contain:

Add coordinates to points
Add polygon attributes to point
Aggregate point observations
Clip points with polygons
Convert lines to points
Convert multipoints to points
Convex hull
Distance Matrix
Fit n points to shape
Points Filter
Points thinning
Remove duplicate points
Separate points by direction

I also tried to search for it in the toolbox, using "table" as keyword the
only SAGA group hit i get is:
Profile from points table


BR

/AO
>
>
> 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
>>
>