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

[anderso at anlaggarna.se]

Hello again!

> Hi,
> ok, this looks like a bug!
>
> When I chose sqlite after performing "fixed distance buffer" function and
> naming the layer "test", the constructed file name in the dialog is indeed
> "test.sqlit" and saving it, it becomes "test.sqlit.shp"
> But when I just add the "e" to the path of "test.sqlit" -> "test.sqlite",
> it saves the file as a SQLITE layer as it should!
>
> Can anyone borrow an "e" to the developers?
> Seems like none ever used this format before?
>

Very odd, its the same for geojson.

When selecting geojson the resulting file name will have the suffix
".geojs", if you add "on" it works!

>
> Apart from that, I do not fully understand what this sqlite layer is. It's
> not spatialite cause I can't connect over "Add spatialite layer" but just
> over normal "Add vector layer" and the fields all have lenght and
> precision zero, but neverthelless contain everthing that was in the
> original (can't test with strings longer than 255 cause I havent got any
> source for such at the moment).
>
> Anyway, just try adding the "e" for .sqlite manually and have a test with
> the resulting sqlite layer and please report back how things worked out.
>

Yes, sqlite format supports strings longer than 255 charcters.

:-)

Thank you very much for all help!

BR

/AO

>
> Am 03.12.2014, 12:59 Uhr, schrieb <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
>>>
>>>
>>
>
>
> --
> Bernd Vogelgesang
> Siedlerstraße 2
> 91083 Baiersdorf/Igelsdorf
> Tel: 09133-825374
>
>